Things you wish you knew about PostgreSQL for building an app

This text discusses various tips and best practices for working with PostgreSQL when building an application. It covers data types, primary key selection, JSON support, default timestamps, use of schemas and extensions, indexing, database users and sessions, connection strings, views, version control of schema changes, and transactional DDL. The author emphasizes the importance of choosing the right data type for columns, using appropriate primary keys, leveraging PostgreSQL's JSON support, making most columns NOT NULL, creating default timestamps, utilizing schemas and extensions, being judicious with indexes, managing database users and sessions, understanding connection strings, using views to transform data, version controlling schema changes, and employing transactional DDL for complex updates.