PostgreSQL 18 adds modern SHA-256 and SHA-512 password hashing algorithms to the pgcrypto extension, enhancing security.
PostgreSQL 18 introduces new non-text dump formats for pg_dumpall and pg_restore, improving performance and flexibility for database backups.
The author stops developing JourneyInbox as a SaaS product due to low market adoption and pivots it for personal use.
A guide to using the Azure Naming Terraform module for generating consistent and unique resource names in Azure infrastructure deployments.
PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
PostgreSQL 18 will introduce parallel CREATE INDEX for GIN indexes, significantly speeding up index builds on large tables.
PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.
Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.
A developer passionately defends the importance of editor choice and personalization, using Neovim as an example of a tool that can be deeply customized.
PostgreSQL 18 adds tracking of cost-based vacuum delay time to progress views, helping monitor performance impact of vacuum operations.
PostgreSQL 18 adds support for converting Roman numerals to numbers using the to_number() function, filling a long-standing gap.
PostgreSQL 18 adds OLD/NEW support to RETURNING in DML queries, allowing explicit access to previous and new row values.
PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.
Explains how dev containers in VS Code can streamline developer onboarding by creating consistent, pre-configured development environments.
A guide to installing and configuring the lightweight HTTP/HTTPS proxy server, tinyproxy, on Ubuntu for domain filtering.
A developer shares their experience with Elixir 1.18's new type checker, highlighting a specific warning about struct comparison and hopes for future improvements.
A guide to solving JWT authentication for protected video and image assets in Angular applications, exploring multiple approaches.
A guide to creating a SwiftUI Text view that mixes plain text with tappable links using Markdown, including a custom LinkText component.
A guide to importing frontend JavaScript libraries without using a build system, covering ES Modules, classic scripts, and CommonJS.
