Coding a new full stack project - setting up the database | devlog #1

This is the first video in my new series documenting the process of building a real life full stack project from the ground up. In this video, I'm setting up a postgres database for this project with supabase and drizzle. I hope you enjoy it!
💻 Source Code: github.com/josean-dev/sveltek...
✍🏽 My Blog: www.josean.com/
📧 Stay up to date with me and the project: buttondown.email/josean
☕️ Help Support Me And The Channel: www.buymeacoffee.com/joseanma...
✨ My Wallpaper Pack: bit.ly/49pC13Q
🛠️⌨️ Visit the SplitType Shop To Build A Corne: splittype.com
🎥 How to build a Corne keyboard: • How To Build A Corne K...
-----
⌨️ Corne Keyboard Parts
1. Cherry MX Corne V3 Kit:
- Partially Assembled Kit: bit.ly/3wPLofX
- Regular Kit: bit.ly/3PicaE5
2. Elite-C Microcontroller:
- Little Keyboards: bit.ly/48Q9CDR
- Keebio: bit.ly/3Pm9lBJ
3. Low Profile Sockets & Mill-Max Pins: bit.ly/3TePp4V
4. 128x32 Oled Screens: bit.ly/3TdjZMf
5. Corne Keyboard Case: bit.ly/48W6bLP or etsy.me/4ca7fPc
6. Corne Display Covers: bit.ly/48QgkJW
7. Switches & Keycaps: bit.ly/3Vbvrus
8. TRRS Cable: amzn.to/3PjyfBX
⏰ Timestamps
00:00 - Introduction
01:12 - Schema design
02:05 - Setting up supabase
02:42 - Install dependencies
02:54 - Code models/schema
06:01 - Drizzle config
07:11 - Generate migration
08:30 - Defining the db client
09:29 - Running the migration
12:36 - Seeding the database
17:36 - Commit changes
18:13 - Conclusion

[@StoneColdET_]

Love your videos Josean, really leaned on your content to help build my programming setup (Mac with Yabai and a split keyboard). Your content is interesting and intuitive, always glad to see one of your videos pop up in my feed. Dev Vlog is a great idea, hope to see more in the future!

[@joseanmartinez]

Thank you! That means a lot!

[@nicohussein2635]

Thank you very much for this content, it's highly appreciated 🙌. Keep pushing 🚀

[@joseanmartinez]

Thank you!

[@OmarElbaga]

So glad to see your content again! I always come back to the vim and iterm2 setup videos :)

[@joseanmartinez]

Happy to hear that, thank you!

[@kayglifts]

Love your videos, Josean!

[@joseanmartinez]

Thanks!!

[@EmmanuelOloyede]

Amazing! ❤

[@ordinarygg]

Great series, would be interesting to see how it will evolve after year or two)

[@EmmanuelOloyede]

Sure. I'll be expecting the next one 😊

[@sergendoua8186]

your are awesome 😇😇😇, love the workflow learn a lot watching your vim video. thanks for sharing this.🙏

[@joseanmartinez]

Thanks!!

[@alexisortizojeda809]

Just came across your channel. Good luck on the project, keep them coming!

[@joseanmartinez]

Thank you!

[@alfredooviedo9410]

Lesgooooooo

[@ccfvhh6588]

Thanks for your effort, love your videos! What type of paid courses are you planning to offer? Would be really interested in that

[@joseanmartinez]

Really appreciate it! I’m thinking of doing stuff related to Neovim and working on the terminal as well as web development

[@mrqwenty]

great video! So what's the name of the program you using to draw the schema?

[@joseanmartinez]

I used lucidchart in the video!

[@alii2284]

Hey 🙋🏼‍♂️ so you use supabase for a database on the cloud as an alternative for firebase and you use drizzle to model the relational db into an object in your code? Also are you using javascript for this project? I’m a biginner so ik this might sound stupid Edit: another question: why won’t we just download a postgres db like mysql or compass? Are you using postgres on supabass incase another project member wants to access the database?

[@joseanmartinez]

Hey! Thanks for the question! So yes, for this project, I’m planning on using supabase to manage and run a postgres database for me. I could use any another postgres service, but I like the supabase option and their connection pooler is something I’ll need for a “serverless”project like this one which I’m planning to host on Vercel. Supabase has its own database client that you can use instead of drizzle and its what I would recommend if you’re gonna be using their built in auth system. I’m pretty comfortable with working on the backend and prefer using an ORM like drizzle or prisma to manage the schema and migrations for the database as well as define all of the objects for these tables in the code as well as you’ve pointed out. Because I’m using an ORM like this though, I’m probably gonna be setting up another solution for auth instead of what is built into supabase. Basically, supabase is only acting as my db provider for this specific project. And I’m using typescript for the project which is just a superset of javascript which allows the addition of types to the language. Hope that helps!

[@erickvasquez5652]

Is awesome how you do the auto imports in vim!

[@joseanmartinez]

Thanks! It’s a combo of using nvim-cmp completion paired with my lsp setup. Here’s my full guide on setting up Neovim if you’re interested: kzbin.info/www/bejne/bKGkeGZ4fdqlmq8

[@dmitrykaa46]

It is nice to see your real vim workflow!

[@ucsdbrandon2025]

When will the next eposide be posted?

[@jjaimealeman]

Kinda surprised to see you NOT use 'pnpm'. Any reason?

[@cassiorsfreitas]

Hey, quick question, how did you open a file in the right buffer from telescope directly?

[@joseanmartinez]

Hey! How I do it is that I navigate to the split I want telescope to open the file in before opening up telescope

[@cassiorsfreitas]

Oh you did that so fast I didn't even notice. Thanks@@joseanmartinez I appreciate that!

[@jsjunior]

What do you use app for Schema design?

[@rheaastons1658]

looks like Lucidchart

[@joseanmartinez]

I used lucidchart in this video!

[@a7kerkh]

All things you did in the video are using only postgres, supabase just for auth and file upload is so heavy

[@joseanmartinez]

I’m actually planning on using supabase only for the postgres db service because the managed solution they offer is pretty nice and I need the connection pooler :) It is quite overkill to have the whole supabase stack running locally on my computer as I only need the db, I could switch to a remote db for development down the line if I need to, but once things are running in production, using just the db for the project shouldn’t be an issue

[@synen]

are you concerned about AI interfering in your career?

[@alexandrodisla6285]

No

[@zheil9152]

Friendly reminder that we are now 11 months into “in 6 months, AI will take your job” So, no. Not worried.