3 ms·

I'm looking to build a saas app on AWS and was seriously considering using SQLITE db for each company. I was also looking at RDS (Postgres) but im really think

I'm looking to build a saas app on AWS and was seriously considering using SQLITE db for each company. I was also looking at RDS (Postgres) but im really thinking with SSD this isnt going to be necessary. The only downside I can see is that i'd have to handle backups and provide read instances if that became necessary.

milquetoastaf 7y ago
if you host your sqlite DBs on EC2 you can handle the backup problem by taking snapshots of the machine AMI. Then restoration is as easy as spinning up a new machine with the snapshot
atombender 7y ago
Have you looked at ActorDB [1]? It's a distributed version of SQLite that may be particularly suited to multitenant SaaS applications. [1] http://www.actordb.com http://www.actordb.com
- mmargerum 7y ago
  Did not know about this. thanks