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 is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.Project mention: TDengine: NEW Data - star count:21596.0 | /r/algoprojects | 2023-08-06
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.Project mention: How to setup Postgres master-master cluster. | /r/sysadmin | 2023-09-05
Offboard it to Postgres specialists like https://www.timescale.com/
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.
Distributed PostgreSQL as an extensionProject mention: Revolutionizing Database Scaling with CitusDB | dev.to | 2023-08-27
YugabyteDB - the cloud native distributed SQL database for mission-critical applications.Project mention: Bitmap Scan in YugabyteDB | dev.to | 2023-09-21
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.
A cloud-native database based on PostgreSQL developed by Alibaba Cloud.
High-performance time-series aggregation for PostgreSQLProject mention: The database inside out with event streams | /r/coding | 2023-04-12
I was experimenting with continuous sql queries in postgres for the same purpose. https://github.com/pipelinedb/pipelinedb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦Project mention: When Did Postgres Become Cool? | news.ycombinator.com | 2023-08-09
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
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.
Lightweight SQLite editor for WindowsProject 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 is a small set of multi-purpose passive network monitoring tools [NetFlow IPFIX sFlow libpcap BGP BMP RPKI IGP Streaming Telemetry].Project mention: NetFlow-equivalent analysis for mirrored traffic | /r/networking | 2023-07-12
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.
Cloudflare Workers providing a SQL API
GO DRiver for ORacle DBProject mention: Oracle DB support in Benthos | /r/golang | 2022-10-07
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.
ProFTPD source code
Modern cryptography for PostgreSQL using libsodium.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.
osquery extensions by Trail of BitsProject mention: Endpoint Isolation with osquery ? | /r/osquery | 2023-03-20
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 is a comprehensive open source relational database management system highly optimized for Web Applications.Project mention: Cubrid – Enterprise Open Source DBMS | news.ycombinator.com | 2023-05-24
Swift + MySQL = ❤️
A fast react-native SQLite library built using JSI (by margelo)Project mention: How to deal with single thread on mobile? | /r/reactnative | 2023-05-25
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
DuckDB extension to read and write to SQLite databasesProject mention: DuckDB 0.7.0 | news.ycombinator.com | 2023-02-13
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.
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:
Harvard CS50x — 2021 solutions
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+lib: world's fastest (simd) CSV parser, bare metal or wasm, with an extensible CLI for SQL querying, format conversion and moreProject mention: Analyzing multi-gigabyte JSON files locally | news.ycombinator.com | 2023-03-18
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).
personal git mirror of sqllogictestProject 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 ) 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  and .
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.
List system information as CSV, manipulate it, pretty print, or export.
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.
C SQL related posts
How to setup Postgres master-master cluster.
1 project | /r/sysadmin | 5 Sep 2023
Squeeze the hell out of the system you have
4 projects | news.ycombinator.com | 11 Aug 2023
Query materialized views with Java, Spring, and streaming database
3 projects | dev.to | 23 Jul 2023
Why does the presence of a large write-only table in a PostgreSQL database cause severe performance degradation?
1 project | /r/PostgreSQL | 2 Jul 2023
Creating a Low-Latency Cache with Dozer and PostgreSQL
2 projects | dev.to | 29 May 2023
Opinions and Suggestions for PostgreSQL Extension under Development
3 projects | /r/PostgreSQL | 29 May 2023
Cubrid – Enterprise Open Source DBMS
1 project | news.ycombinator.com | 24 May 2023
A note from our sponsor - SonarLint
www.sonarlint.org | 25 Sep 2023
What are some of the best open-source SQL projects in C? This list will help you: