OpenTofu v1.12.0 released in May introduced dynamic prevent_destroy values, allowing administrators to set destruction protection at the instance level rather than statically, making infrastructure-as-code safer for managing databases across production and development environments. The release also added a destroy = false lifecycle option for removing resources from state without deleting infrastructure.
This article explains how inverted indexes power full-text search in databases like Postgres. Unlike b-trees that work on entire column values, inverted indexes map individual words to document locations, enabling efficient searches for terms anywhere in text fields. The index consists of a term dictionary and postings lists that store compressed document identifiers.
An educational atlas covering distributed systems design patterns, architecture trade-offs, and technology choices. The resource includes interactive diagrams, foundational concepts like CAP and PACELC, database selection strategies, caching patterns, queuing systems, and a framework for system design interviews with specific technologies and their use cases.
The article clarifies the distinction between relational algebra, a computer science concept foundational to databases introduced by Ted Codd, and relation algebra, a mathematical algebraic structure based on binary relations. While historically separate, relation algebra has found applications in computer science through tools like the Alloy analyzer and query languages like Prela, with the author proposing the term 'Tarski's Algebra of Relations' to reduce confusion.
A developer migrated mpazari.com, a Turkish motorcycle classifieds site, from MySQL 8 to PostgreSQL 12 with three minutes of downtime. After the migration, server load dropped significantly from ~1.5 to ~0.3-0.5, suggesting PostgreSQL uses considerably less server capacity for this particular application despite identical hardware, indexes, and workload.
The article clarifies the distinction between relational algebra, a foundational concept in database theory introduced by Ted Codd, and relation algebra, a mathematical algebraic structure based on binary relations. While relational algebra underlies relational databases and is studied in computer science, relation algebra has applications in formal methods (like the Alloy analyzer) and is increasingly being applied to database systems through languages like Prela, with the author advocating for greater recognition of this mathematical framework.
A philosophical essay exploring consciousness through the lens of precision measurement, atypical perception, and information systems. The author argues that consciousness emerges from measurement and sensing across all systems—from thermostats to humans—and critiques overstated claims about artificial intelligence while drawing connections between temporal databases, Buddhist meditation, and the nature of reality itself.