Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.

In part 1, we learned important PostgreSQL fundamentals. Today, we’ll learn how to populate a table with data, and about important concepts like schema, normalization, views, and transactions. We only ...