News for hackers. Stuff that matters.
Re:Embeddable, replicated and fault tolerant SQL engine base... by stickupkid on Wednesday February 02, 2022 @04:42AM (#30175537)
Ignoring Postgres and comparing apples to apples, rqlite has limitations on "safe" SQL statements[1]. This might be a big deal breaker for you than it might for others. As dqlite replicates the pages and not the SQL statements over raft, which means dqlite doesn't have _that_ problem. Using random() and now() are classified as non-deterministic[2].

Using the application to send the time, although not idea could be used as a workaround, but attempting to use non-deterministic functions in triggers becomes a lot harder.

1. https://github.com/rqlite/rqlite#limitations 2. https://www.sqlite.org/deterministic.html

Re:Embeddable, replicated and fault tolerant SQL engine base... by otoolep on Wednesday February 02, 2022 @05:34AM (#30175881)
Yes, that's correct. rqlite does statement-based replication, which means it has the limitation you outlined. This could be solved by parsing the entire SQLite statement passed into rqlite before it's written to the Raft log, but I haven't got around to that yet.