Open-sourced a SQLite-to-Postgres migration checker

Close

Finds the schema Postgres will reject before you move.

Point it at a SQLite file and it reports what will not survive the move: integer primary keys that are secretly text, dates stored as strings, booleans stored as zero and one, and the columns you have that happen to be Postgres reserved words.

Cursor wrote the type inference. I added the reserved-word list by hand after a migration of mine failed on a column called order, which is a mistake I only need to make once.