Open-source C++ projects categorized as SQL

Top 23 C++ SQL Projects

  • ClickHouse

    ClickHouse® is a free analytics DBMS for big data

    Project mention: Analyzing multi-gigabyte JSON files locally | news.ycombinator.com | 2023-03-18

    It is not necessary to write a code with Rust and simdjson. You can insert the dataset into ClickHouse as described here: https://github.com/ClickHouse/ClickHouse/issues/22482

    Running full scan for ClickHouse in body took 140 seconds on a single c5ad.24xlarge machine, the bottleneck is disk read (only 24 CPU cores are used).

  • OSQuery

    SQL powered operating system instrumentation, monitoring, and analytics.

    Project mention: Best Websites For Coders | dev.to | 2023-01-25

    OS Query : Easily ask questions about your Linux, Windows, and macOS infrastructure

  • Sonar

    Write Clean C++ Code. Always.. Sonar helps you commit clean C++ code every time. With over 550 unique rules to find C++ bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • duckdb

    DuckDB is an in-process SQL OLAP Database Management System

    Project mention: Engine recommendation for heavy and fast etl on single server | reddit.com/r/dataengineering | 2023-03-13

    - DuckDb doesn't support off memory group by: https://github.com/duckdb/duckdb/discussions/6696

  • POCO

    The POCO C++ Libraries are powerful cross-platform C++ libraries for building network- and internet-based applications that run on desktop, server, mobile, IoT, and embedded systems.

    Project mention: What are some C++ projects with high quality code that I can read through? | reddit.com/r/cpp_questions | 2023-01-16
  • better-sqlite3

    The fastest and simplest library for SQLite3 in Node.js.

    Project mention: SvelteKit 1.0 with SQLite Tutorial (Self Promotion) | reddit.com/r/sveltejs | 2023-01-06

    I used better-sqlite3 . It is simple to use as it is synchronous. I don't know if it scales good (at least the docs say it) but works great for my small use cases.

  • heavydb

    HeavyDB (formerly OmniSciDB)

  • sqlcheck

    Automatically identify anti-patterns in SQL queries

    Project mention: T-SQL Best practices analyzer | reddit.com/r/SQLServer | 2022-10-07

    SQL Check is another open source tool (and multi-platform) which looks for common anti-patterns in TSQL code.

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • griddb

    GridDB is a next-generation open source database that makes time series IoT and big data fast,and easy.

    Project mention: griddb: NEW Data - star count:2015.0 | reddit.com/r/algoprojects | 2023-03-19
  • sqlite_orm

    ❤️ SQLite ORM light header only library for modern C++

    Project mention: Comprehensive tutorial for working with databases and c++ | reddit.com/r/cpp | 2022-11-01

    I had some success with sqlite_orm, but more generally I'd just recommend to pick a lib that fit your needs and read its examples/docs.

  • ImGuiColorTextEdit

    Colorizing text editor for ImGui

    Project mention: ImGuiColorTextEdit VS imgui_md - a user suggested alternative | libhunt.com/r/ImGuiColorTextEdit | 2023-01-12
  • Firebird

    Firebird server, client and tools

  • stonedb

    StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)

    Project mention: Show HN: An Open-Source MySQL HTAP Database for OLTP, Real-Time Analytics | news.ycombinator.com | 2022-12-14
  • sql-parser

    SQL Parser for C++. Building C++ object structure from SQL statements.

  • ultimatepp

    U++ is a C++ cross-platform rapid application development framework focused on programmer's productivity. It includes a set of libraries (GUI, SQL, Network etc.), and integrated development environment (TheIDE).

    Project mention: [Cpp] Une assez grande liste de bibliothèques graphiques C ++ | reddit.com/r/enfrancais | 2023-02-14


  • duckdb-wasm

    WebAssembly version of DuckDB

    Project mention: SQLite WASM: Something subtle in the browser | news.ycombinator.com | 2023-02-13
  • LeetCode-Solutions

    A compilation of all the Leetcode solutions. (by SHY-Corp)

    Project mention: GPT-4 is phenomenal at Code | news.ycombinator.com | 2023-03-14
  • flamerobin

    FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software

  • opentick

    A fast tick database for financial timeseries data, built on FoundationDB with simplified SQL layer

    Project mention: A simple SQL layer on FoundationDB for tick data | reddit.com/r/coolgithubprojects | 2022-06-01
  • xeus-sql

    Jupyter kernel for SQL databases

  • constexpr-sql

    Header only library that parses and plans SQL queries at compile time

  • LeetCode

    This is my LeetCode solutions for all 2000+ problems, mainly written in C++ or Python. (by LeoTheBestCoder)

    Project mention: Is there someone interested in studying data structures and algorithms and it's looking for a study buddy? | reddit.com/r/programming | 2023-03-18
  • xloil

    xlOil provides framework for interacting with Excel in different programming languages (python & C++ currently)

    Project mention: XlOil: The fastest library for writing Excel functions in Python | news.ycombinator.com | 2023-03-03

    I recently discovered xlOil after many years with xlWings and periodically checking for other options out there. xlOil is an order of magnitude faster than xlWings or VBA (benchmarks taken from here: https://github.com/lukedays/excel-benchmarks) while still being easy to use and the most feature complete!

    With xlOil, you can easily write functions in Python and have them appear in Excel as worksheet functions and macros.

    What sets xlOil apart is its ability to have very low overheads when calling your own worksheet functions. This means you can write complex functions without sacrificing performance. xlOil supports different languages via plugins, including C++, Python, and SQL.

    With xlOil, you'll have access to a range of features that make writing Excel functions in Python a breeze. For instance, the Python syntax for declaring Excel functions is incredibly concise, and you can use optional type checking of function parameters and support for keyword arguments. xlOil also offers tight integration with numpy, so you can enjoy very low overheads for array functions.

    Another advantage of xlOil is its support for a range of data structures, including tuples, lists, dictionarys, and pandas dataframes. Additionally, you can use xlOil to write async functions, RTD functions, and on-the-fly RTD server creation. xlOil also supports macro-type functions that write to ranges on the sheet, and you can access the Excel Application object, hook Excel events, and pass any python object back to Excel and then back into any python function.

    xlOil even offers simple and quick add-in deployment and two-way connection to Jupyter notebooks, making it easy to run worksheet functions in Jupyter and query variables in the jupyter kernel. On-the-fly creation/destruction of COM addin objects and Ribbon UI is also supported.

    Check it out on Github and star it to encourage the developer to keep supporting this great contribution to the Open Source community!


  • vinum

    Vinum is a SQL processor for Python, designed for data analysis workflows and in-memory analytics.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-03-19.

C++ SQL related posts


What are some of the best open-source SQL projects in C++? This list will help you:

Project Stars
1 ClickHouse 27,524
2 OSQuery 20,113
3 duckdb 9,081
4 POCO 6,843
5 better-sqlite3 3,916
6 heavydb 2,772
7 sqlcheck 2,259
8 griddb 2,017
9 sqlite_orm 1,752
10 ImGuiColorTextEdit 1,106
11 Firebird 1,045
12 stonedb 714
13 sql-parser 617
14 ultimatepp 586
15 duckdb-wasm 477
16 LeetCode-Solutions 233
17 flamerobin 184
18 opentick 182
19 xeus-sql 145
20 constexpr-sql 113
21 LeetCode 83
22 xloil 74
23 vinum 63
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives