DuckDB

DuckDB is a small analytics tool you embed directly inside a notebook or program. Normally, to dig through data you'd need to set up a big server and connect to it, but DuckDB works more like plugging a calculator straight into your app — you just call it with a single line of code. That's why people often describe it as a 'small database for analytics.' Data scientists and developers love using it to quickly open and crunch large tabular datasets.

The company behind it was founded by a team that split off from a research institute in the Netherlands, and for over five years it grew without outside investment, with the founders holding the equity themselves. Recently, when the company decided to join a major cloud provider, questions arose about what would happen to the freely available DuckDB itself.

The bottom line: the DuckDB software itself is owned by a separate nonprofit foundation, independent of the company. So even as the company changes hands, DuckDB's current status — free to view and modify — remains unchanged.

Articles often mention the company and the tool together, like "DuckLabs joins AWS while keeping open-source DuckDB safe." It's easy to confuse the company (DuckLabs) with the tool (DuckDB). In reality, even though DuckLabs is joining Amazon Web Services, ownership of DuckDB itself rests with a separate nonprofit foundation — so its free, open status doesn't change. That's the key point of the story.

1. Download the DuckDB executable and run it in your terminal.
2. Try typing a simple SQL statement: SELECT 1+1;
3. If you have a tabular file (like a csv), you can read it directly: SELECT * FROM 'data.csv' LIMIT 5;
4. Notice you get results instantly, with no separate server setup required.