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.
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