Sass Works
We build, develop and support software for national and international organisations and HNW Individuals.
Apr 29
£200.00/hour
Medium
In Progress
4 hours
AWS Cost Reduction
We have to continually keep an eye on AWS Costs and where possible we have to make changes in applications to find a more cost efficient method to getting the same output. Below is an example of reducing the size of an RDS Instance and implementing AWS Elasticache to take some of the database load. The end result $2,400 in savings a month.
Apr 12
£200.00/hour
Medium
In Progress
2 hours
YouTube Management
One of our clients has a pretty significant YouTube Channel. We manage the full backend of this channel for them. Including the live streaming and the copyright management. Probably not the usual hardcore technical features that are expected of us but allows them to focus on creating their content which creates tens of thousands of AdSense revenue each month.
Apr 10
£550.00/day
Medium
In Progress
2 days
REACT UI for ERP
One of our clients, is a nationwide recruiter and we support them on all aspects of their own in house built ERP, which allows them to manage thousands of staff at any one time. We are rebuilding one aspect of this platform which allows for the management of staff to individual shifts. We are designing this using REACT JS, and AWS SQS. React ensure the state stays the same without having to do multiple refreshes with requests from the database/server. AWS SQS ensures we can manage all the POST/UPDATE requests that the application makes without any lack of performance.
Apr 04
£550.00/day
Medium
In Progress
4 days
Search Improvements
Have recently been asked to help improve the search speed for a company that sells personalised number plates. Currently was using a MySQL RDS Instance, where each table had 53million + rows. However good the indexing there is only so much you can do with MySQL. This is where we fired up AWS DMS, which automatically streams any updates on the MySQL Instance and fires them into Opensearch (Scalable search, analytics engine for real-time data). The WebApp then queries the Opensearch domain. Gone from 10s + query to under 300ms, and we can now also reduce the instance size of RDS to save some additional £££.
Mar 27
£100.00/hour
Medium
Completed
2 days
AWS Instance Update
One of those annoying jobs that has to be done once in a while, updating OS to the latest version. Most of our clients run off AWS Linux instances, with AL2 coming to end of life in June this year. So been ensuring any old instances are up to date, which is AWS Linux 2023. Feels like a spring clean but important to ensure everything is optimal
Mar 18
£100.00/hour
Medium
In Progress
2 days
Performance
Perhaps one of the frequent requests we get is in regards to performance. Its very easy to solve performance issues by throwing lots of cash at hardware resources, who wants an ongoing increase in their monthly spend. Optimisation and in time we have to start splitting the load of web applications across multiple microservices. Caching, queuing and lambda are the main ones we use. However decent indexing of DB's is a must. As well as a healthy use of CRON's to build caches away from client requests. All in a days work
Mar 06
£200.00/hour
Medium
Completed
5 days
Content Auto Publishing (Testing & Monitoring)
In order to be hands off with this, there are a number of scenarios we are having to cater for to ensure that if there is a problem with the multi step process then we can fix automatically without having to raise a software engineer to debug and fix. Essentially we are putting a virtual "lock" in place for every file as we go through the process. The "lock" is only released when we have received the streaming url back from AWS SNS letting us know the job is complete.
Now we are going to leave this running for a good few days to see if we receive any hiccups if not then we can move to the next phase of making the content available for publishing to the customers Content Management Platform.
*The attached is a processing log table we have used to record every single step of the process, helps us massively to debug
Mar 02
£200.00/hour
Medium
Completed
12 days
Content Auto Publishing
This work has now completed, actually its all rather impressive. In the end we decided to split the task into 4 distinct areas.
Download
Extract Audio
Transcribe
Synopsis Generation and Encoding
The transcription is running from an old mining rig so AWS not needed, we have baked this into the back up int he case of failure. However as the workflow is not time sensitive we dont have to worry about it too much. The real art is taking a complex process and make it simple.
We are using www.clearcron.com to help with our automation and CRON management.
Feb 21
£200.00/hour
Medium
In Progress
12 days
Content Auto Publishing
Feb 17
£200.00/hour
Medium
Completed
2 hours
BAFTA's Streaming
As part of the awards season, yesterday evening we took a live video feed for the BAFTA's and distributed to a Nigerian only audience. Plenty of tech was used, including FairPlay, WideVine and PlayReady DRM Profiles. Also we had to use a combination of methods to ensure the stream could only be accessed within the licensed region, including geo location and account authentication. As always plenty of AWS Services. The show went off without a hitch
To learn, more about how things work or you are uncertain, please go here