Hey Rémi, thanks for reading and responding! I think you’re exactly right, that they didn’t have a ton of great options. Database as a service is a rapidly growing industry for sure.
The engineers who explained their process didn’t go too much into detail about front end and caching, so database performance may matter a lot (like for a WordPress site hitting the DB for every page) or relatively little (like for a Gatsby or Next.js site with a build process, either at runtime or on first page load). My understanding is Postgres is going to be quite fast for SQL lookups by ID, even with a lot of concurrent users.
Thanks for sharing your thoughts!