采用
DuckDB 是一个快速的进程内分析数据库,DuckDB 支持功能丰富的 SQL 方言,并与客户端 API 进行深度集成。 和大多数OLAP产品,DuckDB主要是瞄准命令行和嵌入式场景,你可以在笔记上使用它,也可以在浏览器中以WebAssembly方式使用。
主要特性如下:
- Simple
- Portable: runs on Linux, macOS, Windows, and all popular hardware architectures
- Feature-rich
- Fast
- Extensible
- Free
日常的开发中,少不了数据分析,DuckDB 可以作为一个轻量级的数据分析工具,帮助你快速分析数据,这里推荐程序员可以尝试一下。
DuckDB & Friends
- chdb: an in-process OLAP SQL Engine 🚀 powered by ClickHouse
- GlareDB: An analytics DBMS for distributed data
- OctoSQL: a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL
- kwack: Memory Analytics for Kafka using DuckDB
References
- DuckDB: https://duckdb.org/
- DuckDB Community Extensions Repository: https://github.com/duckdb/community-extensions
- MotherDuck: https://motherduck.com/
- DuckDB Snippets: https://duckdbsnippets.com/
- Awesome DuckDB: https://github.com/davidgasquez/awesome-duckdb
- DuckDB Delta Extension: https://duckdb.org/docs/extensions/delta
- DuckDB Friendly SQL: advanced SQL features as well as extensions to the SQL syntax - https://duckdb.org/docs/guides/sql_features/friendly_sql.html