A developer's personal appreciation letter to PostgreSQL, reflecting on its evolution, robust features, and adaptability over the years.
A technical article about optimizing Django Admin's date_hierarchy feature to eliminate performance bottlenecks caused by expensive database queries.
A preview of the 2017 Postgres Open Silicon Valley conference lineup, highlighting key talks on PostgreSQL indexing, scaling, and concurrency.
A beginner's guide to using Sequelize, a popular promise-based ORM for Node.js, covering installation, connection setup, and basic configuration.
A guide to implementing Kubernetes liveness and readiness health checks in a Django application using custom middleware.
Explores the various uses of the DISTINCT keyword in PostgreSQL, including DISTINCT ON, with practical SQL examples.
An updated overview of PostgreSQL's key features and improvements from the last 5 years, including JSONB, extensions, and logical replication.
A step-by-step tutorial on integrating Couchbase Lite, an embedded NoSQL database, with a .NET Core console application.
Explains the pitfalls of optimistic locking in JPA/Hibernate and how to properly implement it to prevent data overwrites.
A technical guide on implementing automated validation checks for Django database migrations to achieve zero-downtime deployments.
A recap of the Polish Oracle User Group (POUG) conference, covering database, BI, and OBIEE performance topics.
A technical guide explaining how to backup and restore a PostgreSQL database within a Kubernetes cluster using kubectl and pg_dump.
Explains new JSON column query and update syntax in Laravel 5.3 for MySQL 5.7+, using arrow notation.
Announcement and feature breakdown of SQL Server 2016 general availability, highlighting new security, performance, and edition-specific capabilities.
Explains changes to the BI Server cache behavior in OBIEE 12c, focusing on the new OBIS_REFRESH_CACHE logic.
Explains why XA/2PC distributed transactions are not strongly consistent and only provide eventual consistency, debunking a common misconception.
A detailed overview of key new features in PostgreSQL 9.5, including Upsert, grouping sets, and pg_rewind.
Exploring MassiveJS, a Node.js library for PostgreSQL that offers a better alternative to traditional ORMs by embracing SQL power and good database design.
A database professional's travelogue of speaking at SQL Server and tech conferences across Asia, Europe, and America in late 2015.
A tutorial on using R's dbWriteTable function to efficiently write a data frame to a temporary SQL table for database queries.
