C SQL

Open-source C projects categorized as SQL

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.

    Project mention: TDengine: NEW Data - star count:21596.0 | /r/algoprojects | 2023-08-06
  • TimescaleDB

    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/

  • 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.

  • citus

    Distributed PostgreSQL as an extension

    Project mention: Revolutionizing Database Scaling with CitusDB | dev.to | 2023-08-27

    References: CitusDB

  • yugabyte-db

    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.

  • PolarDB-for-PostgreSQL

    A cloud-native database based on PostgreSQL developed by Alibaba Cloud.

  • PipelineDB

    High-performance time-series aggregation for PostgreSQL

    Project 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

    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

  • 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.

  • sqlite-gui

    Lightweight SQLite editor for Windows

    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].

    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.

  • edge-sql

    Cloudflare Workers providing a SQL API

  • godror

    GO DRiver for ORacle DB

    Project 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

    ProFTPD source code

  • pgsodium

    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

    osquery extensions by Trail of Bits

    Project 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

    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
  • OHMySQL

    Swift + MySQL = ❤️

  • react-native-quick-sqlite

    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

  • sqlite_scanner

    DuckDB extension to read and write to SQLite databases

    Project 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.

    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:

    https://github.com/duckdblabs/postgres_scanner

    https://github.com/duckdblabs/sqlite_scanner

  • CS50x_2021

    Harvard CS50x — 2021 solutions

  • 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

    Project 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).

    https://github.com/BurntSushi/xsv

    https://github.com/liquidaty/zsv/blob/main/docs/csv_json_sql...

  • sqllogictest

    personal git mirror of sqllogictest

    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...

  • csv-nix-tools

    List system information as CSV, manipulate it, pretty print, or export.

  • 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

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