Re:Consider SQLite
by pfarrell on Wednesday December 29, 2021 @02:23PM
(#29728863)
> I can imagine building a SAAS app where each customer has a “workspace” each as a single SQLite db
I did just that at my (now defunct) startup a few years ago. We were building a collaborative database query tool. The software we built used sqlite to keep a local db for storing user credentials, caching query results, etc. Bonus, we were able to have the local database file be encrypted protecting the data at rest.
Re:Consider SQLite
by edwinyzh on Thursday December 30, 2021 @12:39AM
(#29733999)
> we were able to have the local database file be encrypted protecting the data at rest.
How do you store the password locally? Or do you requesting the passwords from a remote server?
I did just that at my (now defunct) startup a few years ago. We were building a collaborative database query tool. The software we built used sqlite to keep a local db for storing user credentials, caching query results, etc. Bonus, we were able to have the local database file be encrypted protecting the data at rest.