Create Local PostgreSQL Databases using Supabase CLI Create Local PostgreSQL Databases using 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. Anyone let's crack on and see just how we can do the magic.
You need to have Docker and Docker Compose installed on your machine to run Supabase CLI.
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.
One-off Supabase setup:
In your project folder, just run these two commands:
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 Optimisation among other topics. Also subscribe to the newsletter to keep up-to-date with our latest projects.