Blog
#DuckDB
Discover our articles on IT performance, cloud, data science and industry best practices.
All articles
Fast Geographic Data Extraction from SQL Server to Parquet with FastBCP
SQL Server holds spatial data in geography and geometry columns.
An example ETL Pipeline with dlt + SQLMesh + DuckDB
In this post, we walk through building a basic ETL (Extract-Transform-Load) pipeline.
Data Loading from S3 Parquet Files to PostgreSQL on OVH Cloud
Loading data efficiently from cloud storage into databases remains a critical challenge for data engineers.
Spatial queries in DuckDB with R-tree and H3 indexing
This Python notebook explores the use of two indexing techniques, R-tree and H3, for performing spatial queries in DuckDB.
In-memory cosine distance calculation, NumPy vs DuckDB
This notebook compares the performance of NumPy and DuckDB for computing cosine distances on the same dataset.
Using DuckDB with Tableau Desktop on Windows
DuckDB is an in-process SQL OLAP database management system. These database is very fast for OLAP queries and have several advantages: There is also…
A Hybrid information retriever with DuckDB
When it comes to information retrieval, vector search methods have demonstrated some good performance, especially when the embedding models have been…
Streaming data from PostgreSQL to a CSV file as fast as possible
In this post, we explore the process of streaming data from a PostgreSQL database to a CSV file using Python.
Parquet file sorting test
Some time ago, we came across an intriguing Parquet sorting test shared by Mimoune Djouallah on Twitter @mim_djo.
