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.
Announcement and feature breakdown of SQL Server 2016 general availability, highlighting new security, performance, and edition-specific capabilities.
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.
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 tutorial on using Julia's string interpolation for automating repetitive data engineering tasks like querying multiple database tables.
A patch fixes a bug in daloRADIUS's user refill feature, correcting a database column name in the billing history table.
Author announces receiving the Microsoft MVP Award for SQL Server, highlighting their community contributions and speaking engagements.
A retrospective on the first year of the Postgres Weekly newsletter, highlighting key articles, extensions, and community insights about PostgreSQL.
