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

  Рет қаралды 12,019

Josean Martinez

Josean Martinez

Күн бұрын

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

Пікірлер: 40
@StoneColdET_
@StoneColdET_ 2 ай бұрын
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
@joseanmartinez 2 ай бұрын
Thank you! That means a lot!
@OmarElbaga
@OmarElbaga 2 ай бұрын
So glad to see your content again! I always come back to the vim and iterm2 setup videos :)
@joseanmartinez
@joseanmartinez 2 ай бұрын
Happy to hear that, thank you!
@nicohussein2635
@nicohussein2635 2 ай бұрын
Thank you very much for this content, it's highly appreciated 🙌. Keep pushing 🚀
@joseanmartinez
@joseanmartinez 2 ай бұрын
Thank you!
@kayglifts
@kayglifts 2 ай бұрын
Love your videos, Josean!
@joseanmartinez
@joseanmartinez 2 ай бұрын
Thanks!!
@alexisortizojeda809
@alexisortizojeda809 2 ай бұрын
Just came across your channel. Good luck on the project, keep them coming!
@joseanmartinez
@joseanmartinez 2 ай бұрын
Thank you!
@EmmanuelOloyede
@EmmanuelOloyede 2 ай бұрын
Sure. I'll be expecting the next one 😊
@EmmanuelOloyede
@EmmanuelOloyede 2 ай бұрын
Amazing! ❤
@ordinarygg
@ordinarygg 2 ай бұрын
Great series, would be interesting to see how it will evolve after year or two)
@sergendoua8186
@sergendoua8186 2 ай бұрын
your are awesome 😇😇😇, love the workflow learn a lot watching your vim video. thanks for sharing this.🙏
@joseanmartinez
@joseanmartinez 2 ай бұрын
Thanks!!
@md.jubair8893
@md.jubair8893 17 сағат бұрын
can you create a fullstack development course? where you include everything from the very beginning to coding and dsa stuffs and then the web dev stufss!??
@ccfvhh6588
@ccfvhh6588 2 ай бұрын
Thanks for your effort, love your videos! What type of paid courses are you planning to offer? Would be really interested in that
@joseanmartinez
@joseanmartinez 2 ай бұрын
Really appreciate it! I’m thinking of doing stuff related to Neovim and working on the terminal as well as web development
@alfredooviedo9410
@alfredooviedo9410 2 ай бұрын
Lesgooooooo
@jjaimealeman
@jjaimealeman Ай бұрын
Kinda surprised to see you NOT use 'pnpm'. Any reason?
@mrqwenty
@mrqwenty 2 ай бұрын
great video! So what's the name of the program you using to draw the schema?
@joseanmartinez
@joseanmartinez 2 ай бұрын
I used lucidchart in the video!
@ucsdbrandon2025
@ucsdbrandon2025 2 ай бұрын
When will the next eposide be posted?
@alii2284
@alii2284 2 ай бұрын
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
@joseanmartinez 2 ай бұрын
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
@erickvasquez5652 2 ай бұрын
Is awesome how you do the auto imports in vim!
@joseanmartinez
@joseanmartinez 2 ай бұрын
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
@cassiorsfreitas
@cassiorsfreitas 2 ай бұрын
Hey, quick question, how did you open a file in the right buffer from telescope directly?
@joseanmartinez
@joseanmartinez 2 ай бұрын
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
@cassiorsfreitas 2 ай бұрын
Oh you did that so fast I didn't even notice. Thanks@@joseanmartinez I appreciate that!
@dmitrykaa46
@dmitrykaa46 2 ай бұрын
It is nice to see your real vim workflow!
@jsjunior
@jsjunior 2 ай бұрын
What do you use app for Schema design?
@rheaastons1658
@rheaastons1658 2 ай бұрын
looks like Lucidchart
@joseanmartinez
@joseanmartinez 2 ай бұрын
I used lucidchart in this video!
@a7kerkh
@a7kerkh 2 ай бұрын
All things you did in the video are using only postgres, supabase just for auth and file upload is so heavy
@joseanmartinez
@joseanmartinez 2 ай бұрын
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
@synen 2 ай бұрын
are you concerned about AI interfering in your career?
@alexandrodisla6285
@alexandrodisla6285 2 ай бұрын
No
@zheil9152
@zheil9152 Ай бұрын
Friendly reminder that we are now 11 months into “in 6 months, AI will take your job” So, no. Not worried.
The Ultimate Beginner’s Guide To Learn And Master Vim
33:56
Josean Martinez
Рет қаралды 42 М.
7 Amazing CLI Tools You Need To Try
18:10
Josean Martinez
Рет қаралды 235 М.
Must-have gadget for every toilet! 🤩 #gadget
00:27
GiGaZoom
Рет қаралды 9 МЛН
Increíble final 😱
00:37
Juan De Dios Pantoja 2
Рет қаралды 101 МЛН
MEGA BOXES ARE BACK!!!
08:53
Brawl Stars
Рет қаралды 25 МЛН
Smart Sigma Kid #funny #sigma #comedy
00:19
CRAZY GREAPA
Рет қаралды 19 МЛН
3 Types of Algorithms Every Programmer Needs to Know
13:12
ForrestKnight
Рет қаралды 451 М.
Why I use Convex over Supabase as my BaaS
51:33
Web Dev Cody
Рет қаралды 17 М.
Setting up homerow mods with usevia - for Nuphy Air v2
18:36
CalmCode
Рет қаралды 1,1 М.
Why Are Electric Cars Losing Momentum?
16:03
DW REV - Cars & Mobility
Рет қаралды 97 М.
How To Make Your Boring macOS Terminal Amazing With Alacritty
16:33
Josean Martinez
Рет қаралды 114 М.
The App YOU or I Could Have Built... ShipFast
6:52
Travis Media
Рет қаралды 117 М.
PHP doesn't suck (anymore)
10:48
Aaron Francis
Рет қаралды 197 М.
20 Advanced Coding Tips For Big Unity Projects
22:23
Tesseract
Рет қаралды 160 М.
How To Use lazy.nvim For A Simple And Amazing Neovim Config
25:44
Josean Martinez
Рет қаралды 153 М.
How I Setup Neovim To Make It AMAZING in 2024: The Ultimate Guide
1:26:35
Josean Martinez
Рет қаралды 147 М.
iPhone 12 socket cleaning #fixit
0:30
Tamar DB (mt)
Рет қаралды 48 МЛН
Samsung S24 Ultra professional shooting kit #shorts
0:12
Photographer Army
Рет қаралды 28 МЛН
Секретный смартфон Apple без камеры для работы на АЭС
0:22