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...
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: 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 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 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...
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...
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...
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,...
Comparison of esProc SPL and DuckDB in Data Storage
Data storage is essentially about striking a balance between flexibility, performance, and ease of...
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...
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...
Kotlin DataFrame ❤️ Arrow
Kotlin DataFrame v0.14 comes with improvements for reading Apache Arrow format, especially loading a...
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...
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
Introduction DuckDB is widely recognized for its analytical processing capabilities, but...
DuckLake: First Impressions & Getting Started with DuckDB's Database-Managed Lakehouse
※This is an English translation of the original Japanese...
Como Conectar ao DuckDB com C++
Um banco de dados veloz e futurista para seus projetos. Nós já fizemos um artigo...
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...
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...
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...
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...
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...
DuckDB to query MongoDB
DuckDB is a high-performance analytical database, but it is single-process, so it cannot replace an...
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...
Exploring OSM changesets via DuckDB
Is the statement, "DuckDB - A game changer for analyzing OpenStreetMap" true? Let's find out...