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?

all 12 comments

sorted by: hot top controversial new old

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

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

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'.

[–] [email protected] -3 points 1 year ago (2 children)

Great webdev question /s

[–] [email protected] 3 points 1 year ago (1 children)

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.

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

Makes sense. I still haven't really figured out how searching works either.

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

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.