Re:Let's build a distributed Postgres proof of concept
by Mertax on Tuesday May 17, 2022 @07:24PM
(#31417426)
I only have experience with Azure's App Service, but their App Service can scale out and still use the same mounted local storage layer that is shared across all app instances. So I've been considering this for multi-tenant applications where each tenant's data can be siloed in it's own SQLite database.
[ Parent
| on HN ]
Re:Let's build a distributed Postgres proof of concept
by nijave on Wednesday May 18, 2022 @07:31PM
(#31428907)
I'm curious if you can get that setup to work reliably (and if it's performant when done). It looks like Azure uses SMB to mount a share so Sqlite + SMB caveats apply (generally getting synchronous writes and locks working correctly over a network filesystem). Additional details https://www.sqlite.org/draft/useovernet.html