Timely_Jellyfish_2077Best way to convert sqlite database to postgresql database?
The link to download the database : send.whateveritworks.org/…/eafb8f99d35d4dfb/#tVhO…
It contains all the movies and shows on rarbg.
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’.
Double_AMaybe this? pgloader.readthedocs.io/en/latest/…/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
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
You need to provide a password in the connection string. pgloader.readthedocs.io/en/latest/pgloader.html?h…
Thanks man. It worked
You might need to handle NULL values by explicit type casting
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.