[ontologiae]

Using PostgreSql, I tend now to directly generate query result in json.

It implies an architecture model where you put the business logic and type safety in the RDBMS.

It reduces the number of layers for a lot of functionalities.

[toasterlovin]

How does version control work for an architecture like this?

[diegoperini]

In my experience, migration scripts that include modifications to output JSON (as ALTER TABLE statements) are always tracked and programmed to be auto-executed on each version update.