The Many Faces of DISTINCT in PostgreSQL
Explores the various uses of the DISTINCT keyword in PostgreSQL, including DISTINCT ON, with practical SQL examples.
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.