View on GitHub

fluxio: a tool for JSON/PostgreSQL-jsonb I/Os

fluxio is a command line tool to insert JSON data from its standard input into a PostgreSQL 9.4+ jsonb store and which can also output JSON from the database to its standard output.

fluxio needs to be provided a configuration file from which it can read database connexion information. You can simply rename fluxio.conf.sample to fluxio.conf and adjust options where necessary.

fluxio expects one table with two columns; one of type character varying which acts as the primary key (default name: key) and another one of type jsonb which acts as the JSON store (default name: content). You can specify the column names with the -col-content and -col-key flags. If you do not use the default PostgreSQL schema, you can specify the schema name with the -s option.

fluxio expects to be provided a key in order to insert data into the database or to extract content from it. The key is provided using the -k flag.

fluxio can either import JSON into the specified table with the -w flag or read from the table and export JSON to standard output using the -r flag.

To install fluxio, simply issue the following command:

go get -u github.com/DevMine/fluxio