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!

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

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"

This was very helpful. Thank you.

Thanks!

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.

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

2 ай бұрын

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 kzread.info/dash/bejne/nadnyrSpf5euZrg.html

@edojoshua

2 ай бұрын

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

@mountoubriandavid5472

2 ай бұрын

Hey please where did you get your endpoint id?

@codewithosvaldas

2 ай бұрын

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

Thanks alot. Im trying it right now

@codewithosvaldas

2 ай бұрын

Let me know how it went ;)

@user-pz2fu9ie9u

2 ай бұрын

@@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

2 ай бұрын

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

@user-pz2fu9ie9u

2 ай бұрын

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

@user-pz2fu9ie9u

2 ай бұрын

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)

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

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.

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

2 ай бұрын

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

2 ай бұрын

@@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

2 ай бұрын

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