PostgreSQL: From Idea to Database - Table of Contents

PostgreSQL: From Idea to Database is a series of blog posts written to teach practical database design.

This series does not wax poetic about the theory of relational databases or normalized form. Instead we focus on practical examples that illustrates why the theory matters and applies.

Series in progress

Note: This series is currently a work in progress!

Table of contents

The following listing includes links to the pages that are already published along with placeholders for planned future topics. The future topics are likely to change in title, content and scope and I fully suspect the ToC will only grow as I start to work in the real content!

Main topics

• Introduction to PostgreSQL: From Idea to Database series
• PostgreSQL Crash Course
• Define, Design, Repeat
• Build your Data Dictionary in PostgreSQL
• Enhance your PostgreSQL Data Dictionary
• Tools for Designing Databases
• PostgreSQL vs. MySQL: Why we use PostgreSQL
• Database Anti-patterns: Performance Killers
• Deploying PostgreSQL using Sqitch
• Database lifecycle
• Backup and Restore
• Databases and change over time
• PostgreSQL, JSON and PiWS
• PostgreSQL Functions - Data as an API

Advanced topics

Security

• CIS Benchmarks

Performance

• PostgreSQL 10 Parallel Queries and Performance
• Testing PostgreSQL Unlogged Tables for Performance
• PostgreSQL Load Testing

Spatial data (PostGIS)

• PostGIS: Tame your spatial data (Part 1)
• PostGIS: Tame your spatial data (Part 2)
• Gotcha restoring XML data from pg_dump

Get in touch

If you have questions or comments please Contact us.