SQLite to PostgreSQL Converter

A SQLite dump does not load into PostgreSQL as it stands. AUTOINCREMENT, BLOB literals and PRAGMA lines are syntax errors, BOOLEAN columns hold 0 and 1, tables can reference tables created later, and because SQLite allows any value in any column, a DATETIME column may really contain Unix timestamps. This converter reads the output of sqlite3 app.db .dump, a schema or a .sqlite file and writes a script you can run with psql. It looks at your actual rows before it picks a type: a VARCHAR(5) holding longer text stays loadable as TEXT, a BOOLEAN with a stray 2 is not forced into BOOLEAN, and integers beyond 2^53 keep every digit. Foreign keys are added after the data, so load order and self-references stop mattering, and orphaned rows are reported and added as NOT VALID instead of aborting the import. Identity sequences are set past the highest id, including the AUTOINCREMENT value in sqlite_sequence. Common functions in defaults, indexes and views are translated, such as datetime('now'), ifnull(), group_concat() and strftime(), and anything without a safe translation is listed in the warnings instead of being guessed. Test runs loaded 500 randomly generated SQLite databases into PostgreSQL 18.6 and compared them row by row with the source. Dumps and .sqlite files are processed in your browser and are not uploaded.