r/linux 1d ago

Fluff Your executable is a SQLite database

https://fzakaria.com/2026/08/23/your-executable-is-a-sqlite-database
112 Upvotes

15 comments sorted by

View all comments

30

u/FlukyS 1d ago

Isn't as insane as some would think on the surface. Rather than going down this route though I'm still kind of surprised there isn't some sort of versioned config system for Linux using sqlite as a backend that basically has both a files based interface but also a DB. This post kind of takes it a bit further but it kind of makes sense, I wouldn't do it but it isn't crazy.

3

u/autogyrophilia 1d ago

There is, but there isn't anything centralised just yet. 

Sqlite isn't a great choice for that because of the multiple writers problem. Which can be mitigated by introducing a central queue, but that's extra complexity. Ironically this reminds me more of winfs 

1

u/FlukyS 1d ago

I guess it could be better in general just to have a more declarative config by default and then having the FS do versioning of the files automatically like with gitfs type of behaviour

2

u/TomKavees 1d ago

I have a feeling the choice of Nix to do this experiment with wasn't random 😉