iiinova — where your digital self keeps evolving

CedarDB

@cedardb.com

152 followers 20 following 26 posts

One Database, Endless Possibilities

Posts Replies Media

CedarDB @cedardb.com · 29/09/2026

Signed or unsigned sounds like a small type-system detail, but it changes how data is compared and interpreted from assembly to SQL. We look at signedness, NULL vs. -1 sentinels and why Parquet led us to expose native unsigned types in CedarDB. cedardb.com/blog/unsigned/

Signed, Unsigned, Misaligned: Lessons from Assembly to SQL

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 23/09/2026

Meet SQLDoom. We ported the original 1993 DOOM to SQL and ran it entirely on CedarDB including game logic, renderer and online deathmatch. cedardb.com/blog/sqldoom/

We ported the original Doom to SQL

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 20/08/2026

CedarDB Cloud is coming. The engine is the one you can already self host. The new part is that the ops are ours. The preview is live today if you want to see what that actually looks like. SQL editor's in there too, benchmarks preloaded. demo.cedardb.cloud

000

CedarDB @cedardb.com · 04/08/2026

Encoding and compression get used like synonyms, but in a database, they solve different problems. We pit lightweight encoding schemes against ZSTD compression to see their impact, and land on ¿por qué no los dos? New post: cedardb.com/blog/encodin...

Encoding or Compression: Why not both?

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 28/05/2026

Here's a closer look at what we built in CedarDB in April 2026. The headliners: ON UPDATE CASCADE, drop-in observability via pg_stat_database and pg_stat_activity, and VACUUM (TRUNCATE). Plus a few more additions worth reading about. cedardb.com/blog/release...

CedarDB: Features of April 2026

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 26/05/2026

Meet DOOMbench. We ran a multiplayer DOOM server entirely in SQL and stress-tested it against 6 different data stacks: Postgres, DuckDB, ClickHouse, CockroachDB, AlloyDB, and CedarDB. cedardb.com/blog/doomben...

CedarDB @cedardb.com · 15/04/2026

New month, new features. CedarDB now ships production-grade access control with RBAC and Row Level Security, so you can define exactly who sees what down to individual rows. Plus delete cascades and Drizzle ORM support. cedardb.com/blog/release...

CedarDB: Features of March 2026

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools and tomorrow’s challenges.

CedarDB @cedardb.com · 20/03/2026

Not every feature gets the attention it deserves at release time. This is the first in our new monthly series: a closer look at the most impactful things we have shipped recently. 🌲 cedardb.com/blog/release...

CedarDB: Catching Up on Recent Releases

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 17/02/2026

When you’re over the tips of your skis in analytics, simple tools don’t cut it. We used Parquet to carry Stack Overflow data from ClickHouse to CedarDB. Result: CedarDB ran our complex queries more than 4X faster. Read the full ski-themed benchmark ⛷️ cedardb.com/blog/ski_par...

Parquet as our 'Ski Lift' to Migrate from ClickHouse to CedarDB

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 29/01/2026

Strings are everywhere; and often the most filtered columns in analytics. So compression isn't just about saving space, it's also about query speed. CedarDB now uses FSST to reduce string storage while keeping queries fast with the help of a dictionary. 🔗 cedardb.com/blog/string_...

Efficient String Compression for Modern Database Systems

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 18/12/2025

Stop nesting database systems just to paper over analytics pain. pg_duckdb and pg_clickhouse look tidy, but they rarely fix the real bottlenecks. We explain why, and what we had to build to get HTAP right end‑to‑end in our latest blog post: cedardb.com/blog/unnest_...

Stop Nesting Database Systems

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 26/11/2025

As we prepare for AWS Re:Invent, we wrote about a recent PoC in "CedarDB Tames the Slopes." The steady line on the graph might evoke images of the long, straight drive to Vegas on I-15. Enjoy our post and looking forward to seeing you in Vegas next week! cedardb.com/blog/takes_t...

CedarDB Takes to the Slopes!

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 31/10/2025

🎃 Ready for some code chills for Halloween? 👻 In “Down with template (or not)!”, we venture into the dark world of C++ templates. 😱 Prepare for some template madness! cedardb.com/blog/down_wi...

Down with template (or not)!

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

000

CedarDB @cedardb.com · 09/09/2025

What if a database could be your game engine? During parental leave @lukasvogel.bsky.social built DOOMQL: A multiplayer DOOM-like where everything (rendering, game loop, state) runs in pure SQL on CedarDB. It's fast, ridiculous, and surprisingly elegant. Full write-up: cedardb.com/blog/doomql

CedarDB @cedardb.com · 26/08/2025

Ever wished your analytics could keep up with reality instead of lagging behind? We wrote about connecting #CockroachDB change data capture (CDC) with #CedarDB, and what that means for running lightning-fast analytical queries on live data. cedardb.com/blog/crdb_cd...

CockroachDB and CedarDB: Better Together

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 24/07/2025

Leaving academia is always a big step, especially if you bring your research project with you into the real world. Read our latest post to learn what we did to prepare a research project for production workloads and what we learned along the way: cedardb.com/blog/researc...

What It Takes to Get a Research Project Ready for Production

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 09/07/2025

Congratulations to SortMergeJoins from TU Munich - winners of the 2025 SIGMOD Programming Contest! Built by the Umbra research group (CedarDB’s roots), their system ran 12× faster than median - entirely open-source and no sort-merge-joins to be found 😉: github.com/umbra-db/con...

CedarDB @cedardb.com · 01/07/2025

Join us on an AI and vector-powered journey, as we explore key philosophical topics such as "Does pickled watermelon belong on a taco?", and how to search CedarDB docs using CedarDB's vector support. cedardb.com/blog/semanti...

Use CedarDB to search the CedarDB docs and blogs

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 14/05/2025

CedarDB Community Edition is here! Download CedarDB Community Edition today - no paywall, no signup, just pure performance. Read more about our CedarDB on our blog: cedardb.com/blog/launch/

Announcing the CedarDB Community Edition

CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools a...

CedarDB @cedardb.com · 24/04/2025

Many database systems claim to be compatible with PostgreSQL. But what does that really mean? Find out in our latest blog post and learn more about what it takes to become PostgreSQL compatible. cedardb.com/blog/postgre...

What It Takes to Be PostgreSQL Compatible

Many systems and tools, including CedarDB, claim to be “PostgreSQL compatible”, but what does that actually mean? In this article, we explain why PostgresSQL compatibility has several layers, what is ...

CedarDB @cedardb.com · 02/04/2025

You don’t need an army of C++ devs to hand-optimize every query. We let the code write the code. Read our latest blog post to see how we mix runtime flexibility with almost magical performance! cedardb.com/blog/compila...

Fast Compilation or Fast Execution: Just Have Both!

Learn the basics of code generation, which is one of the secrets behind CedarDB's performance. CedarDB creates custom machine code for every query. This keeps data in CPU registers as long as possib...

CedarDB @cedardb.com · 06/03/2025

B-trees may be decades old, but we still use them extensively in CedarDB. Read our latest blog post to learn how to scale B-tree operations to hundreds of cores. cedardb.com/blog/optimis...

To B or not to B: B-Trees with Optimistic Lock Coupling

B-Trees stand the test of time. In this article, we explore why we still use a 55 year old data structure: It is still super efficient on modern hardware when we use contention free optimistic lock co...

CedarDB @cedardb.com · 29/01/2025

We follow up on our past claims that fewer code branches are better in our return to blogging after our winter break. Read on to find out why branches are a burden on the CPU, and what both you and the CPU can do to avoid performance penalties. cedardb.com/blog/reducin...

Why Trees Without Branches Grow Faster: The Case for Reducing Branches in Code

In some of our blog posts, we explained what steps we take to reduce the number of branching instructions in our critical paths. However, we only ever claimed that this is much better and faster, and ...

CedarDB @cedardb.com · 24/12/2024

"Helping Christmas Elves Count Presents" 🎁🎅 is the title of our last blog post of the year. Read how to implement vectorized overflow checking here: cedardb.com/blog/vectori...

Helping Christmas Elves Count Presents (or: Vectorized Overflow Checking)

In a previous post, we explained the importance of overflow checks when summing numbers, and mentioned that the usual approaches are not easily vectorized. Read here how to get 4x the performance when...

CedarDB @cedardb.com · 03/12/2024

In-memory database systems were a game changer when they first came out in the early 2010s. But it looks like everyone moved back to persistent storage. We explore the history of in-memory database systems, studying their mistakes and celebrating their achievements. cedardb.com/blog/in_memo...

The History of the Decline and Fall of In-Memory Database Systems

A decade ago, there was a sudden surge of high-performance in-memory systems dominating the world of interactive analytics. Today, almost everyone has gone back to using persistent storage. Does this ...

CedarDB @cedardb.com · 19/11/2024

Have you ever wondered why you see the last entry again when switching to the second page of a website? 👬 📖 The culprit is "offset"! Read why in our blog post and find out what to use instead. 🌲 cedardb.com/blog/paginat...

Offset Considered Harmful or: The Surprising Complexity of Pagination in SQL

Have you ever wondered why you sometimes see duplicate results when clicking on the second page of a website? In this blog post, we explore techniques for result pagination, how they impact the work n...