If you've ever tried converting a MySQL database to PostgreSQL (or the reverse), you've probably run...
If you've ever tried converting a MySQL database to PostgreSQL (or the reverse), you've probably run into tools that do text replacement on your SQL dump.
They work fine — until they don't.
Where regex converters fail
The edge cases pile up fast:
Zero dates (0000-00-00) — PostgreSQL rejects them outright
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators...
PostgreSQL Error 2200C: Invalid Use of Escape Character PostgreSQL error 2200C...
Many SQL queries that "seem correct but produce strange results" in a gbase database trace back to...
I wanted to see how far PostgreSQL extensibility could go. Most People Think PostgreSQL Is Just a...
PostgreSQL Error 2200G: Most Specific Type Mismatch PostgreSQL error code 2200G...
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm Today's...
