It seems SQLite could be evolve to solve this by just bundling itself entirely in the data files? After all, the binary is less than 1MB, anywhere you’re putting a database surely has at least that much overhead, for most applications it’s less than a drop in the bucket.

I’d be interested to learn if there are any db implementations that take this approach, or reasons this wouldn’t work.

▲

mort96 3 hours ago | parent | next [-]

Well you'd have the problem that an sqlite database file created on a Linux AMD64 box could be copied to an AArch64 macOS machine to be read there. And quite a lot of (cross platform) software build their file formats on top of SQLite.

	▲	appplication 3 hours ago \| parent \| next [-]
		I think my silly and unserious naive response would be linear scaling bundled binaries with number of platforms doesn’t seem to be that materially different in terms of total size. But I see your point, didn’t consider the architectures
	▲	andai 3 hours ago \| parent \| prev [-]
		Perhaps it could be an "actually portable executable"? https://news.ycombinator.com/item?id=26273960

▲

arijun 3 hours ago | parent | prev [-]

So for every new SQLite db you want to access would have to run a new untrusted executable? That seems… hilariously bad for security.

	▲	appplication 3 hours ago \| parent [-]
		Fair point! Was mostly an intrusive technical thought