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.
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.
Overview of new PostgreSQL 9.4 features, focusing on the performance benefits of JSONB for document storage and the introduction of logical decoding.
