Summary: Bootstrapping database creation for a microservice in a container, using PostgreSQL for data storage and Linux createdb command for setup.
Summary: Compatibility issues encountered when updating from PostgreSQL 9.1 to PostgreSQL 9.3 with PostGIS 2.0 installed, and a solution.
Summary: How to use SQL LIMIT in UPDATE queries when the RDBMS doesn't allow it. And some optimization techniques for handling large data imports.
Summary: A review of the book 'Beginning Databases with PostgreSQL: From Novice to Professional', by Richard Stones and Neil Matthew.
Summary: Using 'ticket servers' to manage auto-incremented unique IDs across multiple databases, a common issue when sharding databases.