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,...
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...
Analyzing DuckDB’s Performance Optimization through TOPN and COUNT DISTINCT Operations
In recent years, DuckDB has emerged as a popular choice for numerous data analysis scenarios. Its...
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...
Querying Overture Maps GeoParquet Directly in the Browser with DuckDB WASM
Overture Maps provides a rich, open and collaborative dataset of geospatial features that’s designed...
Querying S3 logs in a flash with DuckDB 🦆
Amazon S3 server access logs are a treasure trove of valuable information, detailing requests made to...
Comparison of esProc SPL and DuckDB in Data Storage
Data storage is essentially about striking a balance between flexibility, performance, and ease of...
Comparison of esProc SPL and DuckDB in Multi-Data Source Capabilities
Both DuckDB and esProc SPL support diverse data sources, and this article will compare the...
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,...
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...
esProc SPL vs DuckDB: Which is more Lightweight for In-Application Computation
Both DuckDB and esProc SPL can be embedded in applications as computing engines. This article will...
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...
Lightweight ETL with AWS Lambda, DuckDB, and PyIceberg
Original Japanese article: AWS Lambda×DuckDB×PyIcebergによるETLの実装 Introduction I'm Aki,...
DuckLake: First Impressions & Getting Started with DuckDB's Database-Managed Lakehouse
※This is an English translation of the original Japanese...
Kotlin DataFrame ❤️ Arrow
Kotlin DataFrame v0.14 comes with improvements for reading Apache Arrow format, especially loading a...
Como Conectar ao DuckDB com C++
Um banco de dados veloz e futurista para seus projetos. Nós já fizemos um artigo...
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
Introduction DuckDB is widely recognized for its analytical processing capabilities, but...
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...
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...
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...
Lightweight ETL with AWS Glue Python Shell, DuckDB, and PyIceberg
Introduction I'm Aki, an AWS Community Builder (@jitepengin). I previously posted an...
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...
DuckDB to query MongoDB
DuckDB is a high-performance analytical database, but it is single-process, so it cannot replace an...
Exploring OSM changesets via DuckDB
Is the statement, "DuckDB - A game changer for analyzing OpenStreetMap" true? Let's find out...
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...
How to Connect to DuckDB with C++
A fast and futuristic database for your projects. We have already written an initial...
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...