4 ms·
Been looking for something like this, I also wish there was a way for multiple users to collaborate and interact with the same database. Think like MySql Workb
by Alifatisk 1y ago
Been looking for something like this, I also wish there was a way for multiple users to collaborate and interact with the same database.
Think like MySql Workbench but for multiple users, that would be incredible
- jen20 1y agoThat is a limitation of SQLite no?
- breadwinner 1y agoYes and no. SQLite can handle a small number of users. It locks the entire database while writing to it, so it can't support a large number of concurrent users.
- __bb 1y agoI realise you’ve hinted at it, but also think it’s worth explicitly pointing out that it’s more about the number of users writing than just user count. It can handle concurrent readers with little bother. For those who’ve not seen it already, there’s a good guide on when to use SQLite here: https://sqlite.org/whentouse.html https://sqlite.org/whentouse.html
- dnet 1y agoWhile the default is indeed to lock the entire database, it has been an option for 15 years to avoid this: https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
- Alifatisk 1y agoI am thinking of an application where multiple users can interactive with the workbench BUT the workbench performs its actions against the database as one user. That way, it could consolidate the connections into a single one
- jen20 1y agoIn other words, a database server around Sqlite? That seems like the kind of thing that should exist!