![]() Now we need a docker-compose.yaml for our services.Take MySQL dump from your MySQL Client like phpmyadmin, Sequel Pro etc in.A Big Shoutout to GavinRay from Hasura who helped me reach 3rd setup and prevented me from going bald with all my hair i was pulling out of frustration with 1st and 2nd setup. Learning : Always use Docker for such tasks (or generally too) as we can isolate environment and dependencies. On heroku all you need to do is tell Sequel to connect to the content of the DATABASEURL environment variable (which is a properly formed url that Sequel understands): DB nnect (ENV 'DATABASEURL') Share. When i ran pgloader via Docker then Standalone MySQL and Standalone PostgreSQL also worked. ![]() Reaching this stage i found out that problem was pgloader installed via Homebrew. ✅ Docker MySQL and PostgreSQL and pgloader: In this setup MySQL, PostgreSQL and pgloader were all installed via Docker and it worked. ❌ Docker MySQL and PostgreSQL and Standalone pgloader: In this setup MySQL, PostgreSQL were installed via Docker and pgloader with homebrew brew install pgloader. ❌ Standalone MySQL and PostgreSQL and pgloader: In this setup MySQL, PostgreSQL i installed from their official site on MacOSX and pgloader with homebrew brew install pgloader. Below is my experience with different local setups for using pgloader I started reading about it and came to know about this tool called pgloader. Since the product is not in production, now is a good time to migrate. ![]() Then 1 day I thought of migrating my existing MySQL setup to Postgres. We become greedy and I'm not gonna lie I too became greedy, the sooner it comes out the better for obvious reasons. They have to properly test everything and then initial beta comes out and then final release. The thing about open source software is that we want it to support our ecosystem, so i was literally asking every few days to Rajoshi about MySQL support landing. I asked Hasura team about MySQL Support and got a reply that its under development and will come out soon, possibly 2 months from now. But since #Hasura only supports Postgres as of now I needed to migrate my MySQL to Postgres. Problem with REST is development time and updating. As you can see, the sequel work Interface is divided into three parts, the left side shows the data tables that exist in the currently connected database, the upper right part is the place for writing SQL, and pressing the COMMAND+R key in the MAC environment will execute the SQL you wrote. Same thing happened with SOAP when REST came. Although REST is still powering majority of internet but once you taste the blood, there's no going back. I recently made a decision to use #Hasura for backend on one of my products. If you want code directly then skip to end. TLDR This article is about converting a MySQL database to Postgres using pgloader with Docker. This is my first article so please ignore my mistakes. ![]() Follow me on Twitter, happy to help or take suggestions from you /Narayan ![]()
0 Comments
Leave a Reply. |