I wrote about the "pattern of judgment" regarding how I used Claude Code to migrate the Oracle logging framework log_set_oracle (MIT license) to PostgreSQL and how I designed the verification process.

Migrating from Oracle to PostgreSQL is a classic example of a project that many teams know they must tackle eventually, but for which they cannot estimate the man-hours. If AI could handle not just ...

postgres-json-schema allows validation of JSON schemas in PostgreSQL. It is implemented as a PL/pgSQL function and you can use it as a check constraint to validate the format of your JSON columns.

It covers the entire lifecycle of building a database application — from schema design, data manipulation, complex querying, procedural programming (PL/SQL), to cursors, views, procedures, functions, ...