Relational Databases Explained
How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.
It is often surprising how little is known ...
Similar Articles (10 found)
🔍 64.2% similar
Build Your Own Database
A step-by-step guide to building a key-value database from scratch.
If you were to build your own database today, not knowing ...
🔍 59.3% similar
I wrote a simple dynamodb style database with a python dictionary and a Google pygtrie ("trie" data structure)
It's still a toy but I kept adding feat...
🔍 57.9% similar
What is an Open Table Format? & Why to use one?
- 1. Introduction
- 2. What is an Open Table Format (OTF)
- 3. Why use an Open Table Format (OTF)
- 4....
🔍 57.8% similar
What Does It Mean for a Column to Be Indexed
When optimizing queries on a database table, most developers tend to just create an index on the field to...
🔍 56.3% similar
Advanced SQL is knowing how to model the data & get there effectively
- 1. Introduction
- 2. SQL techniques
- 3. Query optimization
- 4. Data modeling...
🔍 56.2% similar
You don't know SQL. Aside from basic CRUD statements, you haven't used any advanced database features. This free ebook will share many recipes to make...
🔍 55.2% similar
Building Cost Efficient Data Pipelines with Python & DuckDB
- 1. Introduction
- 2. Project demo
- 3. TL;DR
- 4. Considerations when building pipelines...
🔍 55.0% similar
Object storage is taking over more of the data stack, but low-latency systems still need separate hot-data storage. Storage unification is about prese...
🔍 54.9% similar
Over the past year, I’ve been writing about several back-to-the-basics topics, like extracting data via APIs and SFTP, and building solid data models....
🔍 54.8% similar
What do Snowflake, Databricks, Redshift, BigQuery actually do?
- 1. Introduction
- 2. Analytical databases aggregate large amounts of data
- 3. Most p...