On JSON and SQL
See the articles:
http://tapoueh.org/blog/2017/09/on-json-and-sql/ http://tapoueh.org/blog/2017/10/set-returning-fonctions-and-postgresql-10/
To use the files:
$ createdb magic
$ psql -d magic -a -f magic.create.sql
$ PGOST=... PGPORT=... PGDATABASE=magic python3 magic.py
$ psql -d magic -a -f magic.sql
Details at the blog post articles.
