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.
Is the idea to eventually use DynamoDB for the events as well?
Yeah I think that is the plan and would be easiest. For the 1 table we are querying, there really is no need for a relational database and it would make the functions a lot lighter as well if I could remove the ORM modules and just use boto3