From Design to SQL

I wanted to show off how I use modern databases in full stack apps. From data modeling, to schema, to relations, to queries, to the modern systems for migrations and deployment with database branches and pushes.
Thanks to cloudinary for sponsoring this series!
cld.media/bendavis
SITE REPO: github.com/bmdavis419/SvelteK...
THE LIVE SITE: www.sedimentart.com/
my stuff
discord: / discord
x (twitter): / bmdavis419
insiderviz: www.insiderviz.com
blok: www.theblokapp.com
timestamps
0:00 data modeling
4:00 schema
7:56 queries
10:20 migrations and deployment
#programming #tutorial #webdev

[@bmdavis419]

This series is sponsored by cloudinary, definitely go check them out, their new Svelte SDK is fantastic and the beautiful performant images on Sediment would not have happened without them!
cld.media/bendavis

[@Richetechguy]

Nice touch with the styling defaults for your product meta data 👌

[@Ryguy12543]

Awesome video. Thanks for the content 💪🏼

[@alexanderleschanz9991]

Wow! great vid as always

[@gamingwolf3385]

Hi ben , your videos are really helpful , you are beautiful with great knowledge thank you a lot

[@mateoroldos6287]

Good video Ben, loved the svletekit + drizzle + planetscale combination.
Some questions:
- Do you find any good use for API routes?
- Have you tried Tanstack Query with sveltekit?

[@bmdavis419]

Yea I actually use api routes for a lot of my auth stuff, if you look at how I do sign in with github I redirect the user to a get request route and then run the flow from there I also use them for stripe webhooks
I have not tried tanstack query for sveltekit, so far my use cases have been simple enough that I have not needed it, but that may change we will see...

[@StephenFosterUK]

great vid Ben. re migrations and the branching model... how do "rollbacks" work? does PS generate the migration?

[@bmdavis419]

Since we're not using traditional migrations, we can easily just rollback the branch and change the schema that way which is really nice. No migrations directory needed

[@BlueeyesChineseguy]

Great vid
Think you should get a stronger pop filter, the plosives are pretty harsh
😅

[@bmdavis419]

Yea I noticed that too, I need to figure that out in post

[@emmanuelU17]

I had the foreign key issue with planet scale. But they now support foreign key constraints.

[@ouss]

0:53 not being a grammar nazi but "Migrations"

[@bmdavis419]

Lmao, me not being able to spell at a third grade level is kinda just a feature of the channel

[@mikejohneviota9293]

is it ok to get the figma design so we can practice too 😅

[@asadmehboob1300]

Can you help me to create dynamic queries in drizzle so that I use abstraction

[@bmdavis419]

like a function with params that wraps drizzle? like getUsers(count, skip, order) => users? That should be pretty ez