SQLite briefing for Linux kernel hackers (2019)

Re:SQLite briefing for Linux kernel hackers (2019) by goatinaboat on Saturday November 21, 2020 @04:56AM (#25168759)

Does someone know if there is something like an SQLite server, so that it could be used like a 'normal' database server?

    $ ssh dbserver -c sqlite3 /path/to/database.db

Is as close as you’re going to get. You can have multiple users doing this but all transactions are serialised so don’t expect concurrent writes to be performant - concurrent SELECTs will be fine.

[ Parent | on HN ]

Re:SQLite briefing for Linux kernel hackers (2019) by leicmi on Saturday November 21, 2020 @06:30AM (#25169103)

Possibly Bedrock fits your needs: https://bedrockdb.com

"Bedrock [..] is a networking and distributed transaction layer built atop SQLite"

"... That query can be any SQLite-compatible query – including schema changes, foreign key constraints, partial indexes, native JSON expressions, or any of the tremendous amount of functionality SQLite offers."

[ Parent | on HN ]