3 ms·
I use it together with Rails and the horizontal sharding feature. Each customer has it's own sqlite database running in WAL mode. Since the app is internally us
by config_yml 4y ago
I use it together with Rails and the horizontal sharding feature. Each customer has it's own sqlite database running in WAL mode. Since the app is internally used, traffic/writes are pretty predictable.
I also do backups periodically with ActiveJob using `.backup` on the sqlite3 client. It's simple and nice because I just have to worry about running the app, and nothing else.
- pqdbr 4y agoWould love to know more about how you set this up.
- BilalBudhani 4y agoare you doing multi tenancy in your application by creating different SQLite database for each customer? I'm curious to know more about your approach
- ricg 4y agoA potential downside here could be running out of file descriptors if you use one database file per client. Linux has a limit of 1024 open files per process. Did you ever run into this problem?