HN Explorer

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

1 points by jerrygoyal ↗ HN
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

[ 2.5 ms ] story [ 15.6 ms ] thread
gregjor
Read books by C.J. "Chris" Date and Joe Celko.
lesserknowndan
Learn about character sets and collations.

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