Articles filed in category 'sql'

Using DuckDB for Data Analytics

By: Wei-Meng Lee

Last updated: Monday, December 8, 2025

Published in: CODE Magazine: 2023 - May/Jun

In this article by Wei-Meng Lee, the author introduces DuckDB, a Relational Database Management System (RDBMS) that supports Structured Query Language (SQL) and is designed for data analytics. Unlike traditional database systems, DuckDB does not require installation and can run queries directly on Pandas data. The article provides examples and demonstrations of how to use DuckDB for data analytics tasks, including loading datasets, querying data using SQL, and performing analytics on the data. The author also discusses the recently added support for JSON ingestion in DuckDB. Overall, the article highlights the convenience and efficiency of using DuckDB for data analytics tasks.

• .NET 3.5
• AI
• Big Data
• CSV
• Data
• data analytics
• Data Science
• Data Visualization
• Database
• databases
• Domain Driven Design
• JSON
• OLAP
• Python
• sql
• SQL Server