Seamless Migration from MySQL to PostgreSQL (from PlanetScale to Neon)

[@programmerslife01]

I just saw your video and I'm writing this comment before I even watch it, but thank you so much for it, because I'm working on a project with Planetscale and got that email, so I was thinking of migrating to another free solution but I still didn't do my research, and suddenly saw your video from your another tutorial. I'll try your instructions thanks again man!

[@avaze7]

the migration using pgloader only worked for me after setting sslmode=allow instead of require on both connection strings. Otherwise a great tutorial, thanks!

[@mosescodes]

thank you so much! the migration worked. for some reason i hit an "unexpected end of input error" when trying to run my config.load file with pgloader (same as 2:27) -- this was solved by adding a semicolon after the words "create indexes"

[@edojoshua]

This was very helpful. Thank you.

[@academai11]

Yep, until this fancy service does the same rug pull as planetscale did. I'm trying to migrate to the self-hosted db but its painful.

[@uffamei8044]

Thanks!

[@Dave_devProjects]

Thanks alot. Im trying it right now

[@codewithosvaldas]

Let me know how it went ;)

[@Dave_devProjects]

@@codewithosvaldas im not really familiar with docker. I just intalled it right now. I do not understant the first command you typed in your cmd. (I mean the docker pull for dimitri pgloader).

[@codewithosvaldas]

It downloads, “pulls” the docker image for pgloader. Execute it and move further with instructions

[@Dave_devProjects]

please where can i find my endpoint id?@@codewithosvaldas

[@Dave_devProjects]

Failed to connect to pgsql at "ep-long-lab-*******.eu-central-1.aws.neon.tech" (port 5432) as user "the-sphere_owner": SSL verify error: 20 X509_V_ERR_UNABLE_TO_GET_ISSUER_CERT_LOCALLY @@codewithosvaldas i had this error while doing the docker run for the mirgation (i put the asterics myself because its sensitive info)

[@PaulVarna]

Who could have ever thought that you would need to pay for a service that was growing by leaking money on a free tier.

[@edojoshua]

Hi, I have been able to migrate successfully from Planetscale to Neon following your instructions. However, when I start my app, I get an error saying "public.{Model} does not exist in this database". It would seem the default schema being queried is the public one, and my data is on my custom schema. I am not very familiar with postresql or neon db. Any thoughts on how I can resolve this?

[@codewithosvaldas]

Glad to hear that! Have you appended your custom schema to your database URL in .env file? Like so DATABASE_URL='..url..?sslmode=require&schema=your_custom_schema' I mentioned this in the video at ~03:30 kzbin.info/www/bejne/oaSWmYWmhJl7bLc

[@edojoshua]

I somehow missed that. I appended it and it works! Thanks again @@codewithosvaldas

[@mountoubriandavid5472]

Hey please where did you get your endpoint id?

[@codewithosvaldas]

You can get endpoint id from neon console. My connection string in console: postgresql://finance_dashboard_owner:************@ep-nameless-hat-a2cr4p7a.eu-central-1.aws.neon.tech/finance_dashboard?sslmode=require so ep-nameless-hat-a2cr4p7a is my endpoint id (in between @ and .eu-central

[@PlayGameToday]

Нормально

[@CaimAstraea]

There's no guarantee Neon won't go the same way... You can replicate PlanetScale if your determined enogh. It's just a wrapper build around Vitess.

[@curiously-cinnamon]

Hi, I am not able to install Docker Desktop on my Windows 11 device. When I run the installer, it displays an error : Component Docker.Installer.EnableFeaturesAction failed: Not found at Docker.Installer.InstallWorkflow.d__30.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Docker.Installer.InstallWorkflow.d__23.MoveNext() Have you faced this problem too ?

[@codewithosvaldas]

Hey, no I haven’t. I have win 11 too. I can see some people are facing this issue, but there are solutions forums.docker.com/t/unable-to-install-docker-desktop-4-8-2-component-communityinstaller-enablefeaturesaction-failed-not-found/124882/6

[@curiously-cinnamon]

@@codewithosvaldas I think it's because I have Windows 11 Home Single Language version. What about you> Do you have Windows 11 Pro, Enterprise or Education version? Or is it Home like mine? Edit : I've been trying to figure out how to fix the problem by talking to Gemini chatbot.

[@codewithosvaldas]

I have Win 11 Pro. I suggest first checking out what humans have to say in the link I have provided or some stack overflow