←back to thread

What If OpenDocument Used SQLite?

(www.sqlite.org)

275 points whatisabcdefgh | 1 comments | 04 Sep 25 21:36 UTC | HN request time: 0.2s | source

Show context

conorbergin ◴[04 Sep 25 23:48 UTC] No.45133540[source]▶

>>45132498 (OP) #

I've being trying out SQLite for a side project of mine, a virtual whiteboard, I haven't quite got my head around it, but it seems to be much less of a bother than interacting with file system APIs so far. The problem I haven't really solved is how sync and maybe collaboration is going to interact with it, so far I have:

1. Plaintext format (JSON or similar) or SQLite dump files versioned by git

2. Some sort of modern local first CRDT thing (Turso, libsql, Electric SQL)

3. Server/Client architecture that can also be run locally

Has anyone had any success in this department?

replies(2): >>45133655 #>>45134140 #

1. rogerbinns ◴[05 Sep 25 00:08 UTC] No.45133655[source]▶

SQLite has a builtin session extension that can be used to record and replay groups of changes, with all the necessary handling. I don't necessarily recommend session as your solution, but it is at least a good idea to see how it compares to others.

https://sqlite.org/sessionintro.html

That provides a C level API. If you know Python and want to do some prototyping and exploration then you may find my SQLite wrapper useful as it supports the session extension. This is the example giving a feel for what it is like to use:

https://rogerbinns.github.io/apsw/example-session.html