tag: sql
articles: 8 · beats: 3
latest: November 17, 2026
---
Sql
8 Crashtech articles on Sql, spanning System Design & Architecture, Databases and Development Best Practices, published in November 2026. Every piece is full-text HTML with sources, structured data and an authored FAQ.
They span System Design & Architecture (6), Databases (1), Development Best Practices (1). System Design & Architecture Databases Development Best Practices
Relational Database Design Guide: Keys, Relationships, Normalization, and Joins
A comprehensive guide to relational schema design, primary and surrogate keys, normal forms (1NF to BCNF), and indexing join performance trade-offs.

Database Sharding Guide: Horizontal Partitioning, Shard Keys, and Cross-Shard Joins
Why databases resist horizontal scaling: deep dive into database sharding, range vs hash vs directory strategies, cross-shard joins, and resharding.

Database Types Guide: Storage Models, Access Patterns, and Polyglot Persistence
A practical guide to modern database types: relational, columnar, key-value, document, time-series, graph, and vector engines matching storage to workloads.
Database Locks Explained: Shared, Exclusive, Update, Key-Range and Granularity
What each lock mode allows, why update locks exist, how key-range locks stop phantoms, and when row, page or table locks cost you concurrency.
Pessimistic vs Optimistic Locking: Choosing by How Often Your Writes Collide
Lock first or check at commit? Version columns, SELECT FOR UPDATE, retry logic and the contention numbers that decide which strategy fits.
Relational Schema Design That Survives Contact With Production
Keys, relationships, constraints and indexes: the schema decisions that decide integrity and speed, with worked SQL for one-to-many and many-to-many.
Database Normal Forms, Worked Through One Ugly Table
1NF to 4NF are easier to remember as the specific anomaly each one removes. One messy orders table, fixed step by step, shows what each form is for.
What Actually Happens Between You Hitting Enter and Rows Coming Back
A SQL query passes through five stages before you see a row: connection, parsing, planning, execution, storage. What each does and where it breaks.
Questions we answer about Sql
- What is the core distinction between database replication and database sharding?
- What are the trade-offs between range-based sharding and hash-based sharding?
- Why are cross-shard joins considered an anti-pattern in sharded architectures?
- What should an engineering team attempt before introducing database sharding?
- What is polyglot persistence and why is it standard in modern distributed architectures?
- When should an engineering team choose a columnar database over a relational database?
- Why is it an anti-pattern to use a dedicated vector database as the primary system of record?
- What is the primary difference between wide-column stores and relational databases?
- What is the difference between a shared and an exclusive lock?
- Why do update locks exist?
Covered alongside
Frequently asked questions
What does Crashtech publish about Sql?
8 articles tagged Sql, the most recent published November 17, 2026. They span System Design & Architecture (6), Databases (1), Development Best Practices (1). Each carries numbered sources, an authored FAQ and full structured data.
What questions about Sql does Crashtech answer directly?
10 questions have a dedicated answer page under this tag, including “What is the core distinction between database replication and database sharding?”. Each answer is authored prose from the article it belongs to, not a generated summary.
Can AI assistants read Crashtech's Sql coverage?
Yes. Crashtech serves full static HTML to every crawler, allows all major AI user agents in robots.txt, and publishes an llms.txt manifest plus a full-text corpus, so assistants can retrieve and cite these articles directly.