Web Development

3430 readers

1 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

[email protected]

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

[email protected]

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

submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]

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

[–] [email protected] 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?

[–] [email protected] 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

[–] [email protected] 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 ___

[–] [email protected] 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

[–] [email protected] 1 points 1 year ago

Thanks man. It worked

[–] pfannkuchen 1 points 1 year ago

You might need to handle NULL values by explicit type casting