Easy CLI tool for making zero downtime schema changes
pg-osc (Online Schema Change) is a CLI tool for making non-blocking schema changes to large PostgreSQL tables. It creates a shadow table, copies data incrementally, and swaps tables with minimal downtime. Ideal for high-traffic applications, pg-osc lets teams modify database structures safely in production environments.
Easily setup logical replication and switchover to new database
pg_easy_replicate is a simple tool for replicating PostgreSQL data from one database to another using logical replication. It abstracts away the complexity of publication/subscription setup and enables selective table replication. Ideal for developers or data engineers who want quick replication without deep Postgres expertise.
LDO's are lightweight data objects, Java classes that provide query and update access a single table or view in a SQL database. The LDO utility provides a user-friendly interface to generate that JDBC code.