Ask HN: Experienced devs, what advice for newcomers to relational databases?

Posted by jerrygoyal on Friday October 25, 2024 @06:21AM
from the ask-hn dept.

Devs who are experienced with relational databases, I want to learn from your mistakes.

I have limited experience with relational databases and I'm setting up Postgres (Supabase) for my B2B2C SaaS product and desigining table schemas.

What advice would you like to give? Anything beyond the very basics is welcome.

Thanks!

( 2 comments | on HN )

Re:Ask HN: Experienced devs, what advice for newcomers to re... by gregjor on Friday October 25, 2024 @11:33AM (#41946252)

Read books by C.J. "Chris" Date and Joe Celko.

[ Parent | on HN ]

Re:Ask HN: Experienced devs, what advice for newcomers to re... by lesserknowndan on Saturday October 26, 2024 @03:18AM (#41953151)

Learn about character sets and collations.

Otherwise, eventually, you will be forced to learn about them under circumstances not of your choosing.

[ Parent | on HN ]