Learning in public: pgtab

In the spirit of learning in public, I’ve created pgtab, a simple PostgreSQL database for JSON Tabular Data Packages.

It doesn’t do much, but contains examples of importing, parsing, and building JSON objects, a few procedures and functions, and at least one table trigger that’s probably a terrible idea.

There’s also a psql UI hack, made up of schemas, views, and procedures that can be used to navigate and edit individual records. It might be of some interest to weirdos like me who try to do everything in psql.

Feedback is welcome, especially if you want to tell me what I’ve done wrong.