Mental Health Awareness Month

“Community”

Create Local PostgreSQL Databases using Supabase CLI # Create Local PostgreSQL Databases using Supabase CLI #

Create Local PostgreSQL Databases using Supabase CLI #

Published: 4 years ago

2 minute read

Gunning Fog Index: 6.9

Content by Rodney

🌟 How to Spin up a PostgreSQL Development Server with Supabase CLI #

There are several reasons you might want to create local PostgreSQL databases. You might be trying out Prisma (as suggested in this video). Alternatively, you might need a local development database for an API you are building. Whatever your reason, you will see it can be pretty quick to create local PostgreSQL databases using Supabase CLI.

An alternative is Docker Compose, though you will see Supabase uses this method, behind the scenes, saving you having to create the docker-compose.yml file. Anyway, let’s crack on and see just how we can do the magic.

📹 Create Local PostgreSQL Databases: Video #

Please enable JavaScript to watch the video 📼

Create Local PostgreSQL Databases using Supabase CLI

🖥 Code #

Installing Docker #

You need to have Docker and Docker Compose installed on your machine to run Supabase CLI.

    # macOS
brew install docker
docker --version
docker-compose --version

Installing Docker

For Linux, there are detailed instructions on the Docker site . You can see additional macOS installation instructions on the Docker site . There are also Windows Docker installation instructions there.

Installing Supabase CLI #

One-off Supabase setup:

    pnpm add -g supabase

Installing Supabase CLI

Spinning up a Local PostgreSQL Database #

In your project folder, just run these two commands:

    supabase init
supabase start

Spinning up a Local PostgreSQL Database

🗳 Poll #

Have you already tried Supabase?

🔗 Create Local PostgreSQL Databases: Links #

🙏🏽 Feedback #

If you have found this video useful, see links below for further related content on this site. I do hope you learned one new thing from the video. Let me know if there are any ways I can improve on it. I hope you will use the code or starter in your own projects. Be sure to share your work on Twitter, giving me a mention, so I can see what you did. Finally, be sure to let me know ideas for other short videos you would like to see. Read on to find ways to get in touch, further below. If you have found this post useful, even though you can only afford even a tiny contribution, please consider supporting me through Buy me a Coffee.

Finally, feel free to share the post on your social media accounts for all your followers who will find it useful. As well as leaving a comment below, you can get in touch via @askRodney on Twitter and also askRodney on Telegram . Also, see further ways to get in touch with Rodney Lab. I post regularly on SvelteKit as well as Search Engine Optimization among other topics. Also, subscribe to the newsletter to keep up-to-date with our latest projects.