from Hacker News

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

by jerrygoyal on 10/25/24, 10:21 AM with 2 comments

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!

  • by lesserknowndan on 10/26/24, 7:18 AM

    Learn about character sets and collations.

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

  • by gregjor on 10/25/24, 3:33 PM

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