For those looking for more autism related stuff I tweet about autistic daily life over at @spacedoutsmiles :)

Love that SQLite is getting attention. We’re probably approaching about a billion read & writes through the various SQLite databases we use in @ERMILTD since we started. It’s bloody quick for calculating stats too :)

Not checked this account for ages as I do most of my twitter stuff on @spacedoutsmiles these days. It’s good to see stuff folks are working on. Lots of extremely funky things!

AWS servers can be surprisingly slow compared to Macs. On a per core bases even an M1 CPU is around 2x the speed of a Graviton 3 CPU used in the c7g AWS instances. We work around it by scaling out not up, but it’s far from ideal. At least they are super cheap :)

It’s been really fun watching this grow. @micmath and the rest of the team have done an amazing job with it :)

I got burned by data migrations in the past, so for @ERMILTD we treat our backend database as ephemeral, it’s a fast and easy to query index of data held in S3. Rather than migrate data, we regenerate the database from S3 files when needed. Works well for our use case :)

Really impressed with AWS ECR support in Serverless. A few days of playing & I have a single command which can… - Build + upload a complex container - Deploy it to Lambda & AWS Batch environments - Setup input & output buckets - Deploy an admin api to manage it all Magic :)

Does anyone know of a really good training for creating AWS diagrams? I’m creating diagrams for a bunch of @ERMILTD stuff and they keep ending up a bit of a mess. It’s a bunch of simple things… interconnected via events & common resources like S3.. Quickly gets messy!

After evaluating a heap of approaches we’ve decided go to go with an AWS sandbox account for each dev on the team. To make that work, we need to fully automate some of the older bits of our setup which where hand setup ~5 years ago :) It’s been fun to get going :)

Doing a bunch of nerdy work to simplify the deployment process for @ERMILTD. It’s very satisfying to run a single command on an empty AWS account… and have a working install of ERMI running a few minutes later. About 70% there for a few hours work :)

This was really fun to write. Fab to see an event getting lots of the small details right :)

Final test that all the equipment is ready for a user testing sessions tomorrow… Then windows started installing updates in the background. Now doing another final tests to make sure everything is ready for tomorrow :)

A little annoyed that AWS don’t have an equivalent of LocalStack as part of the platform. Having to pay a third party $35 per dev, per month to access basic local testing for AWS batch is painful.

Finally got around to setting up a twitter account for the financial crime platform I built with @MisterWookie :) Mostly so I can reference it in tweets within having to explain :) Everyone, please say hello to @ermiltd! She’s got quite a lot of personality… :)

Feels like a one click ‘report spam’ button would be useful on @X Multiple clicks and needing to scroll makes it slow to bulk report spam mentions etc.

Is anyone out there using the Node Rapids framework for GPU acceleration in production? github.com/rapidsai/node It looks useful for a large data processing task I need to do… but I’m seeing some red flags around long term support & development. Whatcha think?

Our little Financial Crime Detection tool ERMI is sponsoring the upcoming Barcamp London :) It’s epic when we can support the very events which helped get us started in tech. Looking for the 11th (and all the Lego!)

They are rather fab for accessibility folks too :)

Going live in about 5 mins :)