5 ms·
Does that mean you have to bring the whole app down if you need to manually insert something in sql?
by belinder 3y ago
Does 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.