Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today. Learn more →
Top 23 C SQL Projects
-
TDengine
TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
Offboard it to Postgres specialists like https://www.timescale.com/
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
-
References: CitusDB
-
yugabyte-db
YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
Note that there may still be a need for bitmaps, especially with disjunctions (OR) as the following is about conjunction (AND), and it can still be implemented, differently than PostgreSQL. This is tracked by #4634.
-
-
I was experimenting with continuous sql queries in postgres for the same purpose. https://github.com/pipelinedb/pipelinedb
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
There are some interesting things in development to potentially solve that problem.
Here's a recent HN submission about OrioleDB of the more promising ones: https://news.ycombinator.com/item?id=36740921
Source code: https://github.com/orioledb/orioledb
-
InfluxDB
Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.
-
Project mention: C# program not able to open or connect to an encrypted SQLite Database | /r/sqlite | 2023-04-30
DB4S provides only one algorithm based on official SQLite cipher. You can encrypt your database with another in SQLiteStudio or sqlite-gui (I'm an author). Both applications use SQLite3 Multiple Ciphers-library.
-
pmacct
pmacct is a small set of multi-purpose passive network monitoring tools [NetFlow IPFIX sFlow libpcap BGP BMP RPKI IGP Streaming Telemetry].
If you want a tool that can ingest from a span port and generate netflow or IPFIX there is pmacct. This should work with your existing tooling that collects netflow data.
-
-
This work wasn't possible without https://github.com/sijms/go-ora and the amazing Oracle XE Docker images which Gerald Venzl put together: https://geraldonit.com/2021/08/15/oracle-xe-docker-images/. There's also https://github.com/godror/godror, but the main Benthos release is strictly CGo-free.
-
-
Project mention: Update - I built an app that analyses your worries and challenges your thoughts, looking for feedback | /r/CBTpractice | 2023-05-16
Yes! Concerning privacy: The entries are saved in Supabase and encrypted with pgsodium. I think there's a lot more to privacy, though – currently working on other safety measures like anonymization that I'll include before scaling. What sets the app apart: I have built the app specifically to integrate therapy tactics into your daily life and to make them a habit (e. g. if you talk to ChatGPT or Wysa it tells you what tactics to integrate and learn about them, with my app you actually integrate them) => less about learning, more about doing.
-
It's definitely outside the scope of core osquery (oquery is intended to be a read-only tool). However, there have been efforts to use osquery extensions to allow making changes to the system state. See for example the Trail of Bits fwctl extension table that allows modifying firewall rules.
-
cubrid
CUBRID is a comprehensive open source relational database management system highly optimized for Web Applications.
-
-
If you are interested in thread-offloading and specifically writing a large volume of data to a db, take a look at https://github.com/margelo/react-native-quick-sqlite
-
It's not a dumb question at all. I'm pretty knowledgeable with DBs and still find it very difficult to understand how many of these front-end/pass-through engines work.
Checkout Postgres Foreign Data Wrappers. That might be the most well known approach for accessing one database through another. The Supabase team wrote an interesting piece about this recently.
https://supabase.com/blog/postgres-foreign-data-wrappers-rus...
You might also want to try out duckdb's approach to reading other DBs (or DB files). They talk about how they can "import" a sqlite DB in the above 0.7.0 announcement, but also have some other examples in their duckdblabs github project. Check out their "...-scanner" repos:
-
-
kunlun
KunlunBase is a distributed relational database management system(RDBMS) with complete NewSQL capabilities and robust transaction ACID guarantees and is compatible with standard SQL. Applications which used PostgreSQL or MySQL can work with KunlunBase as-is without any code change or rebuild because KunlunBase supports both PostgreSQL and MySQL connection protocols and DML SQL grammars. MySQL DBAs can quickly work on a KunlunBase cluster because we use MySQL as storage nodes of KunlunBase. Kunl
-
zsv
zsv+lib: world's fastest (simd) CSV parser, bare metal or wasm, with an extensible CLI for SQL querying, format conversion and more
If it could be tabular in nature, maybe convert to sqlite3 so you can make use of indexing, or CSV to make use of high-performance tools like xsv or zsv (the latter of which I'm an author).
https://github.com/BurntSushi/xsv
https://github.com/liquidaty/zsv/blob/main/docs/csv_json_sql...
-
Project mention: Goal: Pass all 4259065 tests in sqllogictest in 1 week | news.ycombinator.com | 2022-10-03
That specific SQLite test suite (one of four [1]) has loads of generated SQL functions, and a long tail of more complex hand-written tests. That 95% of the test suite will be mostly generated queries that follow the same basic pattern of joins and projections with basic arithmetic and comparisons. See for example [2] and [3].
The generated tests are not designed to test a wide breadth of features of the SQL language, and passing them with a simple engine is very doable. A lot of the value of these tests is that the sheer volume of queries tends to find obscure problems in optimizers that would not easily surface otherwise. That is of course not a problem in a simple engine that does not have an optimizer.
[1] https://www.sqlite.org/testing.html#test_harnesses
[2] https://github.com/gregrahn/sqllogictest/blob/master/test/ra...
[3] https://raw.githubusercontent.com/gregrahn/sqllogictest/mast...
-
-
Mergify
Updating dependencies is time-consuming.. Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.
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-09-21.
C SQL related posts
- How to setup Postgres master-master cluster.
- Squeeze the hell out of the system you have
- Query materialized views with Java, Spring, and streaming database
- Why does the presence of a large write-only table in a PostgreSQL database cause severe performance degradation?
- Creating a Low-Latency Cache with Dozer and PostgreSQL
- Opinions and Suggestions for PostgreSQL Extension under Development
- Cubrid – Enterprise Open Source DBMS
-
A note from our sponsor - SonarLint
www.sonarlint.org | 25 Sep 2023
Index
What are some of the best open-source SQL projects in C? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | TDengine | 21,751 |
| 2 | TimescaleDB | 15,516 |
| 3 | citus | 8,958 |
| 4 | yugabyte-db | 8,060 |
| 5 | PolarDB-for-PostgreSQL | 2,666 |
| 6 | PipelineDB | 2,571 |
| 7 | orioledb | 2,363 |
| 8 | sqlite-gui | 974 |
| 9 | pmacct | 950 |
| 10 | edge-sql | 549 |
| 11 | godror | 459 |
| 12 | proftpd | 458 |
| 13 | pgsodium | 456 |
| 14 | osquery-extensions | 249 |
| 15 | cubrid | 243 |
| 16 | OHMySQL | 222 |
| 17 | react-native-quick-sqlite | 200 |
| 18 | sqlite_scanner | 167 |
| 19 | CS50x_2021 | 142 |
| 20 | kunlun | 137 |
| 21 | zsv | 130 |
| 22 | sqllogictest | 34 |
| 23 | csv-nix-tools | 30 |
Updating dependencies is time-consuming.
Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.
blog.mergify.com