Friday, 28 November 2014

SQLite and Julia

I've found SQLite a good way to store whole lots of local data and even config information for applications. For config information it provide a clean interface for any required updating programmatically, with tools like SQLite manager as an add in it's easy to modify and easier to keep formats correct than with a text editor and xml or the more plausible yaml. Having a single file on the disk is also nice. I've not had a problem with corruption and trying to recover from it yet.
The one hitch is version control - yaml and git works well and is simpler than comparing changes with
sqlite3 somedb.sqlite .dump > somedb.txt
and using backups.

Julia has an easy to use and working library named not surprisingly SQLite
An update was incompatible with 0.3 Julia - before I'd sorted a work around, the maintainer Jacob Quinn had fixed it.
I'm still astounded that it's possible to come across salesman for enterprise software trying to spread FUD on open source software in between trying to convince me that JSON was something to do with Java, and vomiting out a torrent of technology buzzwords. This is when almost without exception I've had better response times on fixes for open source software I use,  even where we don't have any maintenance agreements, than on any closed source software, even when the supplier is cooperative and we do have maintenance agreements.