Start Supabase Locally and Create a Table

Ben Patton
InstructorBen Patton
Share this video with your friends

Social Share Links

Send Tweet
Published 9 months ago
Updated 2 weeks ago

With the project setup, we can now start our local instance of supabase. This gives us a local running version of the supabase studio that we can interact with.

We will create a table in called todos in the studio

[00:00] Now we can run MPX Supabase start. And this is where if you don't have Docker running, it will not work. So it's gonna pull all these images. Okay. Now that everything is set up, we can come to our browser and go to this URL for the studio URL. We can come to our table editor. Let's create a new table, and we'll call it to dos. It'll be an ID. We can remove the [00:19] created app, make this a UUID. Give it a text, be of type text. It should not be nullable. What good is it to do? It's nullable. And then if we add another column, we'll just call this one completed. And this will be a Boolean, and the default value will be false. Save. And with [00:39] that, we now have our local database running, and we've created a tape.

egghead
egghead
~ 5 minutes ago

Member comments are a way for members to communicate, interact, and ask questions about a lesson.

The instructor or someone from the community might respond to your question Here are a few basic guidelines to commenting on egghead.io

Be on-Topic

Comments are for discussing a lesson. If you're having a general issue with the website functionality, please contact us at support@egghead.io.

Avoid meta-discussion

  • This was great!
  • This was horrible!
  • I didn't like this because it didn't match my skill level.
  • +1 It will likely be deleted as spam.

Code Problems?

Should be accompanied by code! Codesandbox or Stackblitz provide a way to share code and discuss it in context

Details and Context

Vague question? Vague answer. Any details and context you can provide will lure more interesting answers!

Markdown supported.
Become a member to join the discussionEnroll Today