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: https://github.com/josean-dev/sveltek...
✍🏽 My Blog: https://www.josean.com/

📧 Stay up to date with me and the project: https://buttondown.email/josean
☕️ Help Support Me And The Channel: https://www.buymeacoffee.com/joseanma...

✨ My Wallpaper Pack: https://bit.ly/49pC13Q

🛠️⌨️ Visit the SplitType Shop To Build A Corne: https://splittype.com
🎥 How to build a Corne keyboard:    • How To Build A Corne Keyboard: The Co...  

-----
⌨️ Corne Keyboard Parts
1. Cherry MX Corne V3 Kit:
- Partially Assembled Kit: https://bit.ly/3wPLofX
- Regular Kit: https://bit.ly/3PicaE5
2. Elite-C Microcontroller:
- Little Keyboards: https://bit.ly/48Q9CDR
- Keebio: https://bit.ly/3Pm9lBJ
3. Low Profile Sockets & Mill-Max Pins: https://bit.ly/3TePp4V
4. 128x32 Oled Screens: https://bit.ly/3TdjZMf
5. Corne Keyboard Case: https://bit.ly/48W6bLP or https://etsy.me/4ca7fPc
6. Corne Display Covers: https://bit.ly/48QgkJW
7. Switches & Keycaps: https://bit.ly/3Vbvrus
8. TRRS Cable: https://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