How do you manage cron jobs with a setup like that? Does each lambda pull down its own SQLite db, write changes, and then litestream replicates the changes to the web and other lambda instances?
Similar scenario for multiple web nodes and saving data. Also, do you use sticky sessions so that any routes that write to a db also read from the same node/db so you don’t have to wait for litestream?
What do you do for BI? Are you able to ETL the data from sqlite to a warehouse? If so, what does that look like?
Similar scenario for multiple web nodes and saving data. Also, do you use sticky sessions so that any routes that write to a db also read from the same node/db so you don’t have to wait for litestream?
What do you do for BI? Are you able to ETL the data from sqlite to a warehouse? If so, what does that look like?