/sqlite-to-json

Query SQLite databases with prebuilt binaries

Primary LanguageGoMIT LicenseMIT

SQLite to JSON

This program allows you to run queries on a SQLite database and output each row as JSON. This is a very basic program, could be modified for other purposes.

Usage

./stj mydatabase.db "SELECT * FROM mytable" > outputfile

Goal

The goal of this program is to be as simple as possible. It also uses no CGO SQLite to enable cross compilation. See supported platforms. This isn't a replacement for sqlite3.

Sources

I used/plagiarized parts of @SchumacherFM's code