BSON Extension for SQLite

JSON, CSV and SQL converter

Turn CSV, XML & JSON into a live analysis-ready SQL database

Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES&#x2F;_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…

Introducing ChikkaDB - a server application providing a translation layer around SQLite that enables you to use SQLite as a MongoDB-compatible JSON database. It's a small personal project to explore the possibilities of SQLite's JSON and JSONB functions to their fullest. Sharing it here in case it interests any of you. Inviting everyone to try it out and share your feedback.