Articles tagged with: PostgreSQL

How different opensource storage systems replicate data

Summary: How various open-source storage systems, including MongoDB, MySQL, PostgreSQL, Redis, and Cassandra, handle data replication, concluding that most use a log of commands propagated to replicas.


Bootstrapping database creation for a microservice in a container

Summary: Bootstrapping database creation for a microservice in a container, using PostgreSQL for data storage and Linux createdb command for setup.


PostgreSQL - PostGIS compatibility issues

Summary: Compatibility issues encountered when updating from PostgreSQL 9.1 to PostgreSQL 9.3 with PostGIS 2.0 installed, and a solution.


SQL LIMIT in UPDATE when the RDBMS doesn't allows it

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.


Book Review: Beginning Databases with PostgreSQL: From Novice to Professional

Summary: A review of the book 'Beginning Databases with PostgreSQL: From Novice to Professional', by Richard Stones and Neil Matthew.