Re:Distributed SQLite for Go applications
by free-ekanayaka on Friday April 06, 2018 @02:26AM
(#16771316)
BedrockDB requires to operate a separate process, whereas you can embed dqlite in your Go application (pretty much in the SQLite philosophy). Also, afaik BedrockDB patches upstream SQLite with some more intrusive changes than dqlite (e.g. for supporting concurrent writes). The SQLite patch that dqlite requires is pretty minimal and just adds hooks to internal WAL events.
Re:Distributed SQLite for Go applications
by anentropic on Friday April 06, 2018 @12:01PM
(#16774269)
so the use case is: you're building a distributed Go application that needs some shared state in the form of an SQL db?
Re:Distributed SQLite for Go applications
by free-ekanayaka on Friday April 06, 2018 @04:10PM
(#16776942)
Yes, dqlite is currently used for clustering support in LXD 3.0: https://github.com/lxc/lxd
RocksDB is a storage engine (a non-distriuted ordered Key-Value store with transactions). SQLite is a non-distributed SQL database that uses a storage engine (see SQLite4). The linked tool here makes SQLite distributed.
edit: I'm sorry, I was thinking of BedrockDB.