Get the latest tech news

DuckDB Doesn't Need Data to Be a Database

’t Need Data To Be a Database One of the many enjoyable things about databases is that they generally try to separate how data is represented internally (say on disk) from how it is used. To the point that it has become the norm to not even store the data on the same hardware that is running the queries.

One of the many enjoyable things about databases is that they generally try to separate how data is represented internally (say on disk) from how it is used. Instead of opening a web browser, the receipient of the link starts their own local DuckDB session, and attaches to the referenced database. DuckDB supports partial reading, which means that only the columns used in the definition of the weird_rides view have to be fetched, and that filters like fare_amount > 100 can be used to discard even more irrelevant data during the download.

Get the Android app