Using the python 3.10 runtime for the lambdas. Not using the serverless framework yet, these were all manually configured functions, mostly copy paste from https://github.com/UTXOnly/nost-py and don't adhere to a specific design style. Was really just shooting from the hip here to test a few things.
I'm currently using rds postgresql and relying on that to update the read replicas in the appropriate regions. From the synthetics tests, this seems to update pretty quickly on db write.
But I'm definitely with you on the relational database bit. I have been meaning to try to refactor this to use a nosql db as we are really just utilizing 1 table but it was what I'm familiar with so I just ran with it lol.