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.
Features
- Perform non-blocking ALTER TABLE operations
- Uses shadow table and trigger-based syncing
- Minimal downtime during schema changes
- Progress reporting and resumable execution
- CLI interface for ease of use and automation
- Safe rollback and dry-run capabilities
Categories
DatabaseLicense
MIT LicenseFollow pg-osc
Other Useful Business Software
Skillfully - The future of skills based hiring
Skillfully transforms hiring through AI-powered skill simulations that show you how candidates actually perform before you hire them. Our platform helps companies cut through AI-generated resumes and rehearsed interviews by validating real capabilities in action. Through dynamic job specific simulations and skill-based assessments, companies like Bloomberg and McKinsey have cut screening time by 50% while dramatically improving hire quality.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of pg-osc!