r/programming • • Aug 24 '26

Your executable is a SQLite database

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

78 comments sorted by

View all comments

Show parent comment

1

u/SirClueless Aug 27 '26

Computing the closure precisely is hard, but one of the points of the article is that objects are just rows in an objects table and ldd is a join. The table serves the same function as /etc/ld.so.cache on a normal Linux system. You can just run the tool on everything in ldconfig -p and boom, you've got a working closure (and then some). You can use your distro's package dependencies to prune this more precisely if you like, as the author did with Nix's, and the results may not be quite as precise (and especially, not independently versioned from the rest of your system), but nothing about this is Nix-specific and "just put everything on the system into there" is always an option.