DuckDB (code) is the SQLite of OLAP queries.

That's high praise, since SQLite is the most widely deployed database on the planet, and is legendary for it's stability, performance (in use-cases that fit) and testing.

DuckDB has lots of platform support:

• NodeJS
• Python
• R
• Java
• Julia
• C++

And it's only growing in popularity. Check out the DuckDB documentation for yourself – it's a well-organized read and should make it easy to understand how DuckDB works.

Much like SQLite, DuckDB has an excellent "why DuckDB" page that you should read.

DuckDB is SQL-based so getting started with it is very familiar (if you know SQL of course), so I won't bore you with that, but jump right into the docs on loading data to get a good feel for how to get started.

This was originally posted on AWSM FOSS