A preview of PostgreSQL 11's key new features, including usability improvements, safer column additions, and performance enhancements like JIT compilation.
A preview of the top talks at PostgresOpen 2018, covering topics like debugging the Postgres planner, indexes, extensions, and connection pooling.
Announcing a 2018 Asia & Australia tour featuring a full-day SQL Server performance analysis workshop in Melbourne and tech talks on Azure SQL and Availability Groups.
Microsoft's new Azure Postgres offering goes GA, bringing high availability, compliance, and competition to the managed PostgreSQL market.
A tutorial demonstrating Redis sorted sets using the command line interface, Python, and Go programming languages.
Practical tips for optimizing Django database interactions, covering aggregation filters, namedtuples, and custom functions.
A technical guide on enabling and locating MySQL query logs for debugging and monitoring database activity.
A guide to automating development database setup using Docker, including scripts to import production dumps into a MariaDB image for faster local deployment.
Announcement of the Spanish translation of 'SQL Performance Explained' with updates for latest database releases and a refreshed SQL indexing quiz.
Highlights from PASS Summit 2017 Day 1 keynote, covering SQL Server 2017, Azure data services, and Microsoft's data platform announcements.
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.
