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/sveltekit-blog/tree/video-courses
✍? 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/joseanmartinez
✨ My Wallpaper Pack: https://bit.ly/49pC13Q
?️⌨️ Visit the SplitType Shop To Build A Corne: https://splittype.com
? How to build a Corne keyboard: https://youtu.be/vzDTdLaAzXc?si=xGBmB9CWsrtUwmOM
-----
⌨️ 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