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

Project Samples

Project Activity

See All Activity >

Categories

Database

License

MIT License

Follow pg-osc

pg-osc Web Site

Other Useful Business Software
Skillfully - The future of skills based hiring Icon
Skillfully - The future of skills based hiring

Realistic Workplace Simulations that Show Applicant Skills in Action

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.
Learn More
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of pg-osc!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Ruby

Related Categories

Ruby Database Software

Registered

2025-06-17