Database
42 articles
10 Books for Learning Databases (SQL, Design, and Operations)
A staged reading list of 10 books for learning databases, from SQL basics to design and operations: SQL basics, deeper SQL, design, PostgreSQL, and distributed data. Each entry links to its full review.
Maybe Postgres Is Enough: Check Postgres Before Adding Another Database
Before adding another datastore for caching or search, check whether Postgres already covers it. A concise table of per-use-case alternatives based on postgresisenough.dev.
What is sqlc? A Practical Introduction to Type-Safe SQL in Go
Learn what sqlc is and how it generates type-safe Go code from SQL. A hands-on introduction using SQLite that covers the schema-to-code workflow, the benefits, and common pitfalls.
PostgreSQL Memory Configuration
Guidelines for optimizing PostgreSQL memory settings for performance and stability. It works through key parameters such as shared_buffers, work_mem, and maintenance_work_mem, covering how to improve response times while avoiding out-of-memory situations.
Summary of PostgreSQL Logical Replication Specifications
Learn PostgreSQL logical replication: how it differs from physical replication, publisher/subscriber setup with Docker, wal_level configuration, replication slots, and CREATE SUBSCRIPTION.
About Row Level Security (RLS) in PostgreSQL
Master PostgreSQL Row Level Security with PERMISSIVE and RESTRICTIVE policies for multi-tenant data isolation and access control.
Troubleshooting 'configure' Errors During PostgreSQL Installation
Fix the You need to run the configure program first error when compiling PostgreSQL from source. Covers ./configure options, re-running make, and common dependency issues on Ubuntu/CentOS.
About COLLATE in PostgreSQL
Learn how COLLATE works in PostgreSQL for string sorting and comparison. Covers database-level and column-level settings, checking collation with pg_database, and tips for Japanese locale.
Differences in Sorting Order Due to COLLATE and glibc Version Differences in PostgreSQL
Encountered an issue where sorting order differs despite specifying the same COLLATE setting, and documented the investigation.
Characteristics and Design of Nontemporal, Unitemporal, and Bitemporal
Exploring the features, design examples, advantages, and disadvantages of different temporal data models.
Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications
A review of Practical Introduction to Redis. A book that broadly covers Redis from its mechanisms to real-world use and operations. Valuable amid a scarcity of Japanese Redis books, it even digs into internals. One to keep at hand for whenever you get stuck with Redis.
AlloyDB vs Cloud SQL: Performance, Features, and Cost
AlloyDB vs Cloud SQL compared: use cases (OLTP vs HTAP), performance, availability, compatibility, and cost — and when AlloyDB has the edge over Cloud SQL Enterprise edition.
A Comprehensive Guide to the Distributed SQL Query Engine Trino
A review of A Comprehensive Guide to the Distributed SQL Query Engine Trino. It explains Trino, which, via ANSI SQL support and federated queries, handles data across different systems and scales resources in a distributed way for OLAP workloads. You learn an approach that differs from traditional data warehouses.
Bitemporal Modeling: Valid Time and Transaction Time Explained
Bitemporal modeling explained: how a bitemporal data model tracks two timelines, valid time and transaction time, how it differs from non-temporal and uni-temporal models, and the challenges of implementing it in a relational database.
Learning PostgreSQL from Its Internal Structure: Principles of Design and Operation Planning
A review of Learning PostgreSQL from Its Internal Structure. A book that covers what you should know to operate PostgreSQL, from the angle of design and operations grounded in its internals. Understanding the mechanisms, it guides you toward solid design and operational planning.
PostgreSQL Comprehensive Guide, 4th Edition: From Installation to Features, Mechanisms, Application Development, Management, and Operations
A review of PostgreSQL Comprehensive Guide, 4th Edition. An introductory book spanning installation, features and mechanisms, application development, and management and operations. Just right for those new to PostgreSQL, it covers the basics with application examples.
A Comprehensive Guide to Database Design: For Those Who Don’t Want to Stop at Beginner Level
A review of a thorough guide to database design for those who don't want to stop at the beginner level. It explains DB design systematically and clearly, covering the essentials of normalization and table design as a guide for stepping beyond the basics.
MySQL Locks Explained: Preventing Deadlocks and Improving Performance
Understand MySQL locking mechanisms—table locks, row locks, gap locks, and intent locks. Learn how deadlocks occur and how to prevent and diagnose them effectively.
Database Normalization Explained: 1NF to 3NF with Examples
Learn database normalization from first principles. Understand 1NF, 2NF, and 3NF with practical examples and when denormalization is the right trade-off for performance.
Beginning SQL, 3rd Edition
A review of Beginning SQL, 3rd Edition. An easy-to-understand SQL primer you will wish you had read early in your career, also just right for revisiting how to write basic queries and the underlying ideas, and easy to recommend to those starting out with SQL.