3 ms·
Is your application a networked one?
by endisneigh 3y ago
Is your application a networked one?
- bob1029 3y agoIt is a web app that has exclusive ownership over its SQLite databases. Exactly one SQLiteConnection instance per for the lifetime of the application.
- endisneigh 3y agoInteresting. Any more info or link?
- belinder 3y agoDoes that mean you have to bring the whole app down if you need to manually insert something in sql?
- yjftsjthsd-h 3y agoI am not an expert, but if I had written an app that was designed like that, the app would have a /debug url that let me log in[0] and then do all kinds of fun things[1], including running raw SQL from the app's context. [0] And I would be very careful about the security angle, because this is effectively a very dangerous back door into the whole system. Useful, but something to be careful about. [1] Dump live activity stats, performance info, ability to run arbitrary queries against any database(s), ability to run arbitrary code in the app itself if available in a reasonable way (ex. if the app is in a dynamic language, just an eval(), possibly embed tcl/lua if not).
- krab 3y agoMore SQLite processes can open the same file at a same time.