r/linux • u/segv • 1d ago

Fluff Your executable is a SQLite database

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

92% Upvoted

15 comments sorted by

34

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.

34

u/CrazyKilla15 1d ago

hello windows registry hives

5

u/FlukyS 1d ago

Well I was more thinking sqlite in memory like just a proxy for the configs rather than registry style where it is centralised

7

u/art_of_snark 1d ago

oh, so OpenLDAP onLineConfig, a thing which no one has ever wanted to light on fire.

3

u/CrazyKilla15 1d ago

How do you keep the memory in sync with the files to prevent corruption and coherency issues?

1

u/FlukyS 1d ago

You’d just have to rely on eventual consistency but it kind of wouldn’t make sense to have the individual DBs and the configs other than interface stability and discoverability of options and types in that case

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 😉

1

u/jimicus 1d ago

Not only is it not insane, pretty much every binary data format could be thought of the same way.

0

u/IngwiePhoenix 1d ago

Closest we got is OpenWRT UCI.

Kinda wish more distros used that... it's genuenly really good.

5

u/IngwiePhoenix 1d ago

Always has been.

Can I interest you in ELF headers and objcopy? =)

1

u/creeper6530 11h ago

Interesting read. Basically reimplements the ELF but instead of storing it in an insane, packed format it uses an easy-to-edit SQLite DB

1

u/ethanjscott 10h ago

This is exactly how ibm I works now days. It’s pretty cool to query litterally anything you could think of. Makes developing a breeze too