Comment by scott_w
3 days ago
Only for large scale multiple user applications. It’s more than reasonable as a data store in local applications or at smaller scales where having the application and data layer on the same machine are acceptable.
If you’re at a point where the application needs to talk over a network to your database then that’s a reasonable heuristic that you should use a different DB. I personally wouldn’t trust my data to NFS.
What is a "local application"?
Funny how people used to ask "what is a cloud application", and now they ask "what is a local application" :-)
Local as in "desktop application on the local machine" where you are the sole user.
This, though I think other posters have pointed to a web app/site that’s backed by SQLite. It can be a perfectly reasonable approach, I think, as the application is the web server and it likely accesses SQLite on the same machine.
That commenter's idea clearly wasn't about desktop application on a local machine. That is why I asked.
1 reply →