Best way to convert sqlite database to postgresql database? (solved)
Best way to convert sqlite database to postgresql database? (solved)
I have been trying to import this sqlite database into mysql or postgresql database. But had been failing. Can anyone help me with this?
Maybe this? https://pgloader.readthedocs.io/en/latest/ref/sqlite.html
Also what have you tried, and how did it fail?
I have tried it. Getting this error: The value NIL is not of type STRING when binding STRING
You might need to handle NULL values by explicit type casting
Full error message: DB-CONNECTION-ERROR: Failed to connect to pgsql at "localhost" (port 5432) as user "postgres": The value NIL is not of type STRING when binding STRING An unhandled error condition has been signalled: Failed to connect to pgsql at "localhost" (port 5432) as user "postgres": The value NIL is not of type STRING when binding STRING
What I am doing here?
Failed to connect to pgsql at "localhost" (port 5432) as user "postgres": The value NIL is not of type STRING when binding STRING ___
I exported the file in db drowser for sqlite into an sql file. When I tried importing in mysql workbench, i am getting this error: Error executing SQL script. '>' not supported between instances of 'NoneType' and 'int'.
Permanently Deleted
Great webdev question /s
Yeah I know. I didn't find better suitable community on lemmy. It's the closest one I got. Also searching for communities is little harder on lemmy.
Makes sense. I still haven't really figured out how searching works either.
Actually, yes it's a fitting question unless you define webdev as just creating websites that might query an api via js.
The services that provide this apis are just as much part of our domain and basic knowledge about the other end of a communication channel benefits everyone.