Blog
#SQL
Discover our articles on IT performance, cloud, data science and industry best practices.
All articles
An example ETL Pipeline with dlt + SQLMesh + DuckDB
In this post, we walk through building a basic ETL (Extract-Transform-Load) pipeline.
Beyond LAST_VALUE IGNORE NULLS: Efficient Alternatives for Handling Missing Data in SQL Server
When working with SQL Server, managing missing data efficiently is crucial, especially in large datasets.
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.
Vector similarity search with pgvector
In the realm of vector databases, pgvector emerges as a noteworthy open-source extension tailored for Postgres databases.
SQL Server vector search
Some time ago i read a blog article from a senior Microsoft azure programmer Davide Mauri: The article interest me because the current "semantic search"…
TPC-H benchmark of DuckDB and Hyper on native files
In this blog post, we examine the performance of two popular SQL engines for querying large files: These engines have gained popularity due to their…
TPC-H benchmark of Hyper and DuckDB on Windows and Linux OS
In this blog post, we explore the use of two SQL engines, and specifically their Python API, for querying files.
TPC-H benchmark of Hyper, DuckDB and Datafusion on Parquet files
In this blog post, we focus on directly querying Parquet files using three different SQL engines, and more specifically their Python API: The TPC-H…
