![]() Go to your Railway dashboard and create a new project and provision PostgreSQL.Setup a Railway account ( referral link).Make sure you can run the pg_restore command. ![]() if you’re on Mac - brew install postgresql Installed postgresql locally on your machine.This is easily one of the push factors that made me decide to migrate to Railway Postgres. The dashboard also provides CPU, memory, and network metrics on your database usage which is unavailable on Heroku’s free tier.You can only view and make SQL queries on the default database name railway Though, I would argue that using a database tool like TablePlus or pgAdmin would be much more convenient. On top of that, you can view and make SQL queries directly via the dashboard. They have a Discord community where you can easily get help from.In my case, this is a lot cheaper than using Heroku. Incredibly generous pricing, where you would only start paying for resource usage after $10.Below are some of the things that I like about Railway: I chose Railway because it makes the most economical sense for my use case. fly.io/docs/about/pricing/#postgresql-clusters.TL DR: I’ve migrated my side projects’ PostgreSQL to Railway because of its pricing and ease of migration.Īfter some Googling, I came across a couple of PaaS similar to Heroku, each with its own Postgres offerings: With a row limit of 10,000 and a storage capacity of 1 GB, I thought that it would last me for at least a year - it didn’t.ĭespite having a garbage collector service that runs every week to remove staled rows, Heroku Postgres’s free tier simply wasn’t enough. Intending to keep my infrastructure cost as low as possible, I started with Heroku Postgres free tier. A little less than a year ago, I built Burplist, a free search engine for craft beer in Singapore.
0 Comments
Leave a Reply. |