or make.go, for some project it makes sense to not add another language for scripting and building tasks. It way easier for every one to have to master multiple language.
It's more than a PITA, it's almost impossible to implement ACID correctly. It's very very hard to do. There almost no point in implementing that in house when we have sqlite3.
For custom binary file you could and should use sqlite, it has many benefits instead of writing your own custom file format. You just have acid without any cost. It's a single file database you can access throuhg lib statically linked in your application and that's done.
It's also the reflect on the value part which slows down things. It could be improved but it's hard to do that without breaking interface. It's so widely used that a major bump wouldn't that useful.
I agree it's indeed one of the best tool to process csv files. Using basic coreutils command are going to be soon very limited and brittle to process csv files.
I do use sqlite too to process csv file, but I either rely on csvkit to generate the schema from the csv or create the table with raw sql before inserting data in the sqlite database.
I've previously used gitolite for such kind of set up https://gitolite.com/gitolite/index.html
The configuration is done by pushing on a specific gitolite-admin repository
It's not that really interesting but it's something I use daily. I've written a sqlite3 based time tracking tool. I highly inspired by timewarrior, but I wasn't satisfied with it.
That's the save method I'm using since one year now. It perfectly fits my needs as a single user of this wiki.
No infrastructure to set up, it works out of the box.
As a former ikiwiki user I won't go back.
> Many classically trained pianists are excellent at improvisation.
I would not say that, the example you give are the most reknown composer of all times. I think they are more the exception than the reality of professional musicians. Not every one is able to reach such level of genius. It seems, proficiency in both style seems rather rare. I don't think I could name a single current world class contemporary jazz player which could reach the same level in classical music interpretation.
Regarding jazz improvistion, from my little experience of amateur player, jazz musicians mostly improvise together as a band, this is not a solo activity.