HACKER Q&A
📣 jerrygoyal

Experienced devs, what advice for newcomers to relational databases?


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!

  👤 lesserknowndan Accepted Answer ✓
Learn about character sets and collations.

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

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