Articles by Tag #duckdb
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Running SQL on files with the esProc is very convenient, on par with duckDB
esProc SPL, to query CSV, JSON, Excel and other files, you can use it directly after installation,...
Tactical Cloud Audit Log Analysis with DuckDB - AWS CloudTrail
Using DuckDB to query Cloud Provider audit logs when you don't have a SIEM available. ⚠️...
Released SuperDuperDB v0.2
🔮Superduperdb v0.2!🔮 SuperDuperDB is excited to announce the release of superduperdb v0.2, a major...
DuckDB in Action
Disclaimer: this post includes affiliate links; I may receive compensation if you purchase the book...
Duckdb — O novo banco de dados dos Big Data
DuckDB: O Novo Favorito para Análise de Dados DuckDB é um mecanismo de análise SQL que...
Local Data Analysis: DuckDB or esProc SPL?
DuckDB can directly read common files such as CSV, Parquet, and JSON. With just a single SQL...
esProc SPL: Equivalent to the Python-enhanced DuckDB
For desktop data analysis users, if DuckDB is the handy ‘SQL Swiss Army Knife,’ then esProc SPL is an...
SPL Operates Multi-layer JSON Data Much More Conveniently than DuckDB
esProc SPL is much more convenient than DuckDB in operating multi-layer JSON data, particularly when...
Querying S3 logs in a flash with DuckDB 🦆
Amazon S3 server access logs are a treasure trove of valuable information, detailing requests made to...
esProc SPL: Combining the Strengths of DuckDB and Python
That DuckDB is gaining more and more attention is no accident. As a rising star in desktop analytics,...
Magia e Músculos: ETL com Mage e DuckDB com dados do meu treino de powerlifting
Acesse o pipeline completo aqui Mage No ultimo post que fiz, falei um pouco sobre um...
"Inside DuckDB" series articles
Recently, I’ve been interested in DuckDB’s code. DuckDB is a C++ open-source project, great for...
Kotlin DataFrame ❤️ Arrow
Kotlin DataFrame v0.14 comes with improvements for reading Apache Arrow format, especially loading a...
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
Introduction DuckDB is widely recognized for its analytical processing capabilities, but...
DUCKDB, S3 Tables with iceberg using Iceberg Rest API
I wrote my previous article about Duckberg, a combination of PyIceberg with Duckdb to access iceberg...
DuckDB vs Pandas - Exploring DuckDB's capabilities
Ever since I came across DuckDB, I have been fascinated by its capabilities. For those who are not...
Analyzing Svenskalag Data using DBT and DuckDB
As a youth football coach and data engineer, I have been dreaming of that Moneyball moment to become...
Kicking the tyres on the new DuckDB UI
I wrote a couple of weeks ago about using DuckDB and Rill Data to explore a new data source that I’m...
CDK construct for a SaaS that performs data analysis on S3 using DuckDB
Introduction Are you familiar with DuckDB? It can be described as a fast analytical...
Exploring UK Environment Agency data in DuckDB and Rill
The UK Environment Agency publishes a feed of data relating to rainfall and river levels. As a...
My First Billion (of Rows) in DuckDB | By João Pedro
When you want to process 450Gb/1billion rows of data we think in all the directions like PySpark,...
Unlocking DuckDB from Anywhere - A Guide to Remote Access with Apache Arrow and Flight RPC (gRPC)
Be like a duck. Calm on the surface, but always paddling like the dickens underneath. Michael...
DuckDB tricks - renaming fields in a SELECT * across tables
I was exploring some new data, joining across multiple tables, and doing a simple SELECT * as I’d not...
Using DuckDB for Ad-Hoc Analysis: A SQL-Lover's Alternative to Pandas
Ad-hoc analysis is an integral part of anyone in the data field. We have to on a regular basis...
One Minute: DuckDB
DuckDB is an open-source, in-memory, column-oriented relational database management system inspired...
Magic and Muscles: ETL with Mage and DuckDB with data from my powerlifting training
You can acecces the full pipeline here Mage In my last post, i writed about a dashboard I...
Exploring OSM changesets via DuckDB
Is the statement, "DuckDB - A game changer for analyzing OpenStreetMap" true? Let's find out...
Hi! Just finished my first blogpost here, with some test of DuckDB and OSM data. Public notebook attached! ;)
Exploring OSM changesets via DuckDB Pavel P. ・ Dec 28 ...
Personal Picks: Data Product News (April 30, 2025)
Modern Data Stack Updates: April 2025 ※This article is an English translation of my...