Also interesting is that it’s one of the small number of unquestionably public domain pieces of software. Not open source, but public domain. It’s not entirely clear if you can technically put your own work in the public domain, or if you’re just freely licensing it to anyone.
Sqlite was initially developed for the US military though, which explicitly makes it public domain.
I mean, what’s the alternative aside from spinning up a MariaDB for your small local app? I can still remember the swamp of .ini files some older programs used for this or the totally overblown Windows Registry. Not a good time.
Pretty sure lots of projects use json files, before that it was probably XML. Are those good or even decent alternatives? Probably depends on the amount of data …
When I last talked to Richard he had company to work on SQLite. It was like four people.
SQLite is still deployed on everything, everywhere. You browser. Your phone. Macs. Half of Linux machine. Your airplane. It’s super impressive.
Also interesting is that it’s one of the small number of unquestionably public domain pieces of software. Not open source, but public domain. It’s not entirely clear if you can technically put your own work in the public domain, or if you’re just freely licensing it to anyone.
Sqlite was initially developed for the US military though, which explicitly makes it public domain.
It doesn’t matter, but it’s interesting.
It’s lite architecture makes it the only valid option to not having to deploy a full on postgre
I mean, what’s the alternative aside from spinning up a MariaDB for your small local app? I can still remember the swamp of .ini files some older programs used for this or the totally overblown Windows Registry. Not a good time.
CSV or a spreadsheet (xlsx/ods)?
You didnt specify it had to be a good optio ;)
Pretty sure lots of projects use json files, before that it was probably XML. Are those good or even decent alternatives? Probably depends on the amount of data …
db.txt
Now you’re just trying to hand-roll your own DBMS. Have fun with that. It won’t work out