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.
A technical guide on implementing automated validation checks for Django database migrations to achieve zero-downtime deployments.
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.
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.
Part 7 of a Docker tutorial series: creating a custom MongoDB container image for a website's persistence layer.
A first look at the new UPSERT feature in PostgreSQL 9.5, explaining its syntax and practical use cases for developers.
A developer's wishlist for upcoming features in PostgreSQL 9.5, including upsert, foreign data wrapper improvements, and better replication.
A patch fixes a bug in daloRADIUS's user refill feature, correcting a database column name in the billing history table.
