DEV Community

awsmfoss
awsmfoss

Posted on • Originally published at awsmfoss.com

 

F/OSS Spotlight: DuckDB

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

Top comments (0)

Timeless DEV post...

Git Concepts I Wish I Knew Years Ago

The most used technology by developers is not Javascript.

It's not Python or HTML.

It hardly even gets mentioned in interviews or listed as a pre-requisite for jobs.

I'm talking about Git and version control of course.

One does not simply learn git