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.
I wrote a book!
