Data Storage Approach

If your computers are all on the same network, CubeSQL could be a good choice. CubeSQL uses SQLite on the backend.

@Jürg_Otter was just talking about how the CubeSQL plugin is open source

As well, recently there was a blog post about using PocketBase on your local network. PocketBase also uses SQLite.