1462
Runk
(lemmy.blahaj.zone)
Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
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 ;)
db.txt
Now you're just trying to hand-roll your own DBMS. Have fun with that. It won't work out
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 ...