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.
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.