All Projects → cwida → Duckdb

cwida / Duckdb

Licence: mit
DuckDB is an in-process SQL OLAP Database Management System

Programming Languages

C++
36643 projects - #6 most used programming language
c
50402 projects - #5 most used programming language
javascript
184084 projects - #8 most used programming language
python
139335 projects - #7 most used programming language
java
68154 projects - #9 most used programming language
CMake
9771 projects

Projects that are alternatives of or similar to Duckdb

Crate
CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of data in real-time.
Stars: ✭ 3,254 (-18.93%)
Mutual labels:  sql, analytics, olap, database
duckdb
DuckDB is an in-process SQL OLAP Database Management System
Stars: ✭ 4,707 (+17.26%)
Mutual labels:  analytics, olap, embedded-database
Clickhouse
ClickHouse® is a free analytics DBMS for big data
Stars: ✭ 21,089 (+425.39%)
Mutual labels:  sql, analytics, olap
Datafuse
Datafuse is a free Cloud-Native Analytics DBMS(Inspired by ClickHouse) implemented in Rust
Stars: ✭ 327 (-91.85%)
Mutual labels:  sql, olap, database
Omniscidb
OmniSciDB (formerly MapD Core)
Stars: ✭ 2,601 (-35.2%)
Mutual labels:  sql, olap, database
Radon
RadonDB is an open source, cloud-native MySQL database for building global, scalable cloud services
Stars: ✭ 1,584 (-60.54%)
Mutual labels:  sql, olap, database
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Stars: ✭ 4,581 (+14.13%)
Mutual labels:  sql, analytics, database
Genji
Document-oriented, embedded SQL database
Stars: ✭ 636 (-84.16%)
Mutual labels:  sql, database, embedded-database
Eventql
Distributed "massively parallel" SQL query engine
Stars: ✭ 1,121 (-72.07%)
Mutual labels:  sql, analytics, database
Data Science Best Resources
Carefully curated resource links for data science in one place
Stars: ✭ 1,104 (-72.5%)
Mutual labels:  sql, analytics, database
Bats
面向 OLTP、OLAP、批处理、流处理场景的大一统 SQL 引擎
Stars: ✭ 152 (-96.21%)
Mutual labels:  sql, olap, database
Spark With Python
Fundamentals of Spark with Python (using PySpark), code examples
Stars: ✭ 150 (-96.26%)
Mutual labels:  sql, analytics, database
Web Database Analytics
Web scrapping and related analytics using Python tools
Stars: ✭ 175 (-95.64%)
Mutual labels:  sql, analytics, database
Scenic
Scenic is maintained by Derek Prior, Caleb Hearth, and you, our contributors.
Stars: ✭ 2,856 (-28.85%)
Mutual labels:  sql, database
Grdbcombine
GRDB ❤️ Combine
Stars: ✭ 220 (-94.52%)
Mutual labels:  sql, database
Clear
Advanced ORM between postgreSQL and Crystal
Stars: ✭ 220 (-94.52%)
Mutual labels:  sql, database
Java Persistence Frameworks Comparison
Comparison of non-JPA SQL mapping frameworks for Java (Jooq, Spring JDBCTemplate, MyBatis, EBean, JDBI, Speedment, sql2o)
Stars: ✭ 213 (-94.69%)
Mutual labels:  sql, database
Fluentmigrator
Fluent migrations framework for .NET
Stars: ✭ 2,636 (-34.33%)
Mutual labels:  sql, database
Jaydebeapi
JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.
Stars: ✭ 247 (-93.85%)
Mutual labels:  sql, database
Materialize
Materialize lets you ask questions of your live data, which it answers and then maintains for you as your data continue to change. The moment you need a refreshed answer, you can get it in milliseconds. Materialize is designed to help you interactively explore your streaming data, perform data warehousing analytics against live relational data, or just increase the freshness and reduce the load of your dashboard and monitoring tasks.
Stars: ✭ 3,341 (-16.77%)
Mutual labels:  sql, database

 

.github/workflows/main.yml CodeFactor codecov discord

DuckDB

DuckDB is a high-performance analytical database system. It is designed to be fast, reliable and easy to use. DuckDB provides a rich SQL dialect, with support far beyond basic SQL. DuckDB supports arbitrary and nested correlated subqueries, window functions, collations, complex types (arrays, structs), and more. For more information on the goals of DuckDB, please refer to the Why DuckDB page on our website.

Installation

If you want to install and use DuckDB, please see our website for installation and usage instructions.

Data Import

For CSV files and Parquet files, data import is as simple as referencing the file in the FROM clause:

SELECT * FROM 'myfile.csv';
SELECT * FROM 'myfile.parquet';

Refer to our Data Import section for more information.

SQL Reference

The website contains a reference of functions and SQL constructs available in DuckDB.

Development

For development, DuckDB requires CMake, Python3 and a C++11 compliant compiler. Run make in the root directory to compile the sources. For development, use make debug to build a non-optimized debug version. You should run make unit and make allunit to verify that your version works properly after making changes. To test performance, you can run several standard benchmarks from the root directory by executing ./build/release/benchmark/benchmark_runner.

Please also refer to our Contribution Guide.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].