Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely
Adding a NOT NULL constraint to an existing column is one of the most common schema changes, and one of the most dangerous. The naive approach scans t...
Mickel Samuel1mo ago
Adding a NOT NULL constraint to an existing column is one of the most common schema changes, and one of the most dangerous. The naive approach scans t...
ALTER TABLE is not a single operation. PostgreSQL has dozens of ALTER TABLE sub-commands, and they acquire different lock levels. Some are instant and...
Flyway and Liquibase are the two most widely used database migration tools in the Java ecosystem. Both support PostgreSQL. Both are mature. And both h...
Article URL: https://niketpatel.com/essays/why-go-cant-try Comments URL: https://news.ycombinator.com/item?id=47218090 Points: 11 # Comments: 0
STRUCTURED QUERY LANGUAGE SQL (Structured Query Language) is the standard programming language designed for managing, manipulating, and retrieving dat...
By the time we noticed it, the read replica was 3x hotter than the primary. Continue reading on Medium »
Article URL: http://microslop.com/ Comments URL: https://news.ycombinator.com/item?id=47217491 Points: 16 # Comments: 1
Comments
IDisposable, Finalizers, and the Dispose Pattern in .NET Memory management in .NET is automatic thanks to the Garbage Collector (GC). But GC only hand...
Article URL: https://dfarq.homeip.net/amd-am386-released-march-2-1991/ Comments URL: https://news.ycombinator.com/item?id=47217402 Points: 5 # Comment...
Article URL: https://bumbershootsoft.wordpress.com/2026/02/28/c64-putting-sprite-multiplexing-to-work/ Comments URL: https://news.ycombinator.com/item...
I had a task where one small part involved writing a byte array to a MemoryStream . Since this was a trivial task, I let Copilot generate the code. Bu...
hi again! i'm back with a new release of Narwhal, the lightweight pub/sub server i shared a while ago. the biggest change in v0.5.0 is the migration f...
SQL Joins and Window Functions SQL joins allows you to collate/add two or more tables together using a common identifier e.g. a foreign key. Due to no...
Understanding JOINS in PostgreSQL Joins let you merge data from multiple tables (or views) by linking them through related columns. The choice of join...
When a mentor asks you to experiment with a vhost-user backend before working on memory isolation, the goal is much deeper than simply… Continue readi...
Agentic coding increases throughput in ways that are now observable in practice. Tasks that previously required sustained effort can be implemented qu...
A Real Story of Performance Reviews, Documentation, and Shifting Power Dynamics. Continue reading on Medium »
When retrieving data from a database, there are specific conditions or criteria you may want to use to analyze that data. You might need to perform ca...
PostgreSQL's JSONB gives you the flexibility of a document database with the reliability of SQL. Here's when and how to use it effectively. When to Us...
Showing 3401 - 3420 of 4606 articles