Web Development

3439 readers

5 users here now

Welcome to the web development community! This is a place to post, discuss, get help about, etc. anything related to web development

What is web development?

Web development is the process of creating websites or web applications

Rules/Guidelines

Follow the programming.dev site rules
Keep content related to web development
If what you're posting relates to one of the related communities, crosspost it into there to help them grow
If youre posting an article older than two years put the year it was made in brackets after the title

Related Communities

Wormhole

!cool_github_projects@programming.dev

Some webdev blogs

Not sure what to post in here? Want some web development related things to read?

Heres a couple blogs that have web development related content

https://frontendfoc.us/ - [RSS]
https://wesbos.com/blog
https://davidwalsh.name/ - [RSS]
https://www.nngroup.com/articles/
https://sia.codes/posts/ - [RSS]
https://www.smashingmagazine.com/ - [RSS]
https://www.bennadel.com/ - [RSS]
https://web.dev/ - [RSS]

Credits

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 1 year ago

MODERATORS

snowe@programming.dev

erlingur@programming.dev

Ategon@programming.dev

Best way to convert sqlite database to postgresql database? (solved) (programming.dev)

submitted 1 year ago* (last edited 1 year ago) by Timely_Jellyfish_2077@programming.dev to c/webdev@programming.dev

11 comments fedilink hide all child comments

I have been trying to import this sqlite database into mysql or postgresql database. But had been failing. Can anyone help me with this?

you are viewing a single comment's thread
view the rest of the comments

[–] Double_A@discuss.tchncs.de 5 points 1 year ago (1 children)

Maybe this? https://pgloader.readthedocs.io/en/latest/ref/sqlite.html

Also what have you tried, and how did it fail?

[–] Timely_Jellyfish_2077@programming.dev 1 points 1 year ago (2 children)

I have tried it. Getting this error: The value NIL is not of type STRING when binding STRING

[–] pfannkuchen@lemmy.world 1 points 1 year ago

You might need to handle NULL values by explicit type casting

[–] Timely_Jellyfish_2077@programming.dev 1 points 1 year ago* (last edited 1 year ago) (1 children)

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 ___

[–] Double_A@discuss.tchncs.de 4 points 1 year ago (1 children)

You need to provide a password in the connection string. https://pgloader.readthedocs.io/en/latest/pgloader.html?highlight=password#connection-string

[–] Timely_Jellyfish_2077@programming.dev 1 points 1 year ago

Thanks man. It worked