3 ms·
Has SQLite ever attained multiuser functionality or is that still the main thing it lacks?
by nickpeterson 3y ago
Has SQLite ever attained multiuser functionality or is that still the main thing it lacks?
- tehbeard 3y agoMultiuser in what fashion? If you absolutely need high concurrency, then by their own admission pick something else. [1] But for most things you can survive queuing up writes. 1. https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html
- justinclift 3y agoThe SQLite developers seem to be experimenting with a solution to that: https://sqlite.org/hctree https://sqlite.org/hctree The announcement blog post: https://sqlite.org/forum/forumpost/d9b3605d7ff40cf4 https://sqlite.org/forum/forumpost/d9b3605d7ff40cf4 HN thread about it from a few months ago: https://news.ycombinator.com/item?id=34434025 https://news.ycombinator.com/item?id=34434025
- jsmeaton 3y agoI assume you’re asking about concurrent writes and yes, if you use WAL mode you can have that too. https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
- justinclift 3y agoSQLite does have an optional "user authentication" extension, though I've not personally tried it out: https://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt https://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.... The widely used Go SQLite library by mattn says it supports it, if that's useful: https://github.com/mattn/go-sqlite3#user-authentication https://github.com/mattn/go-sqlite3#user-authentication