C Database

Open-source C projects categorized as Database

Top 23 C Database Projects

  • Netdata

    The open-source observability platform everyone needs

    Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05

    netdata.cloud — Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!

  • Redis

    Redis is an in-memory database that persists on disk. The data model is key-value, but many different kind of values are supported: Strings, Lists, Sets, Sorted Sets, Hashes, Streams, HyperLogLogs, Bitmaps.

    Project mention: Handling Multiple requests with Redis and Bullmq | dev.to | 2024-04-13

    Redis

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • 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:22190.0 | /r/algoprojects | 2023-11-14
  • TimescaleDB

    An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

    Project mention: TimescaleDB: An open-source time-series SQL database | news.ycombinator.com | 2024-02-06
  • WCDB

    WCDB is a cross-platform database framework developed by WeChat.

  • citus

    Distributed PostgreSQL as an extension

    Project mention: SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL | news.ycombinator.com | 2024-03-25
  • valkey

    A new project to resume development on the formerly open-source Redis project. We're calling it Valkey, since it's a twist on the key-value datastore.

    Project mention: Redis Is Forked | news.ycombinator.com | 2024-04-16

    There were copious reference links in the article but the one that stood out to me and that I spent some time reading was this GitHub issues discussion on license [1] (but really on the differing opinions of two of the larger forks communities and values).

    I am pleased that Valkey has made the decision to remain independent from the competing Redict fork project. The dogmatism on display in that thread is frustrating. It is one thing to stand by your own principles and opinions, it is entirely another thing to aggressively push your opinions onto others. With the two projects remaining independent, we will get to see which kind of community stewardship results in project success and longevity. The alternative, I fear, might have been technically minded people being railroaded by ideologically driven zealots.

    Dogmatism and zealotry are words we probably mostly associate with religion, but I think they apply exactly to the kind of people I would proactively exclude from any public community I was trying to build.

    1. https://github.com/valkey-io/valkey/issues/18#issuecomment-2...

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • db_tutorial

    Writing a sqlite clone from scratch in C

    Project mention: Problem with recreating like SQLite database. | /r/cpp_questions | 2023-11-02

    I am trying to recreate work from https://cstack.github.io/db_tutorial/ Basically it is recreating very simple SQLite, loading data from a file at the start of the program, and storing data in memory when the program runs then saving data to a file when we close the program. I believe that my issues are connected to working in the Windows instead of the Linux. Right now I am at part 5 when we start saving our data to the file when we close our program.

  • yugabyte-db

    YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

    Project mention: Best Practice: use the same datatypes for comparisons, like joins and foreign keys | dev.to | 2024-02-01

    It is possible to apply Batched Nested Loop but with additional code that checks the range of the outer bigint and compare it only if it matches the range of integer. This has been added in YugabyteDB 2.21 with #20715 YSQL: Allow BNL on joins over different integer types to help migrations from PostgreSQL with such datatype inconsistencies.

  • libsql

    libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

    Project mention: 11 Planetscale alternatives with free tiers | dev.to | 2024-04-11

    Astro DB is powered by LibSQL, an open source fork of SQLite that was created by Turso. You can use Astro DB's drop-in database to build features like blogs, comment functionality, forums, feedback systems, and user authentication.

  • Greenplum

    Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.

    Project mention: Ask HN: It's 2023, how do you choose between MySQL and Postgres? | news.ycombinator.com | 2023-05-11

    Friends don't let their friends choose Mysql :)

    A super long time ago (decades) when I was using Oracle regularly I had to make a decision on which way to go. Although Mysql then had the mindshare I thought that Postgres was more similar to Oracle, more standards compliant, and more of a real enterprise type of DB. The rumor was also that Postgres was heavier than MySQL. Too many horror stories of lost data (MyIsam), bad transactions (MyIsam lacks transaction integrity), and the number of Mysql gotchas being a really long list influenced me.

    In time I actually found out that I had underestimated one of the most important attributes of Postgres that was a huge strength over Mysql: the power of community. Because Postgres has a really superb community that can be found on Libera Chat and elsewhere, and they are very willing to help out, I think Postgres has a huge advantage over Mysql. RhodiumToad [Andrew Gierth] https://github.com/RhodiumToad & davidfetter [David Fetter] https://www.linkedin.com/in/davidfetter are incredibly helpful folks.

    I don't know that Postgres' licensing made a huge difference or not but my perception is that there are a ton of 3rd party products based on Postgres but customized to specific DB needs because of the more liberalness of the PG license which is MIT/BSD derived https://www.postgresql.org/about/licence/

    Some of the PG based 3rd party DBs:

    Enterprise DB https://www.enterprisedb.com/ - general purpose PG with some variants

    Greenplum https://greenplum.org/ - Data warehousing

    Crunchydata https://www.crunchydata.com/products/hardened-postgres - high security Postgres for regulated environments

    Citus https://www.citusdata.com - Distributed DB & Columnar

    Timescale https://www.timescale.com/

    Why Choose PG today?

    If you want better ACID: Postgres

    If you want more compliant SQL: Postgres

    If you want more customizability to a variety of use-cases: Postgres using a variant

    If you want the flexibility of using NOSQL at times: Postgres

    If you want more product knowledge reusability for other backend products: Postgres

  • Hiredis

    Minimalistic C client for Redis >= 1.2

  • sqlitestudio

    A free, open source, multi-platform SQLite database manager.

    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.

  • dqlite

    Embeddable, replicated and fault-tolerant SQL engine.

    Project mention: Marmot: Multi-writer distributed SQLite based on NATS | news.ycombinator.com | 2023-12-11

    If you're interested in this, here are some related projects that all take slightly different approaches:

    - LiteSync directly competes with Marmot and supports DDL sync, but is closed source commercial (similar to SQLite EE): https://litesync.io

    - dqlite is Canonical's distributed SQLite that depends on c-raft and kernel-level async I/O: https://dqlite.io

    - cr-sqlite is a Rust-based loadable extension that adds CRDT changeset generation and reconciliation to SQLite: https://github.com/vlcn-io/cr-sqlite

    Slightly related but not really (no multi writer, no C-level SQLite API or other restrictions):

    - comdb2 (Bloombergs multi-homed RDMS using SQLite as the frontend)

    - rqlite: RDMS with HTTP API and SQLite as the storage engine, used for replication and strong consistency (does not scale writes)

    - litestream/LiteFS: disaster recovery replication

    - liteserver: active read-only replication (predecessor of LiteSync)

  • psycopg2

    PostgreSQL database adapter for the Python programming language

    Project mention: Can I learn Python while practicing writing queries for SQL simultaneously? I've recently completed learning SQL and trying to get better at it. | /r/SQL | 2023-05-10

    You can practice both by using https://www.psycopg.org from your Python code to communicate with your database. When I wanted to practice some SQL, that's what I did (we use psycopg at work, so that's what I practiced with, making a dream journal thingy for myself that was better than just noting stuff in a notepad because I could then look up e.g. what other stuff was correlated with Y, how many times I dreamed of X, etc. etc.)

  • PolarDB-for-PostgreSQL

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

  • PipelineDB

    High-performance time-series aggregation for PostgreSQL

    Project mention: PostgreSQL Is Enough | news.ycombinator.com | 2024-02-06
  • orioledb

    OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)  🇺🇦

    Project mention: Supabase Acquires OrioleDB | news.ycombinator.com | 2024-04-15

    hey hn, supabase ceo here

    we've been fans of Oriole for a while now and have been long-time supporters

    in case you're jumping straight to the comments: OrioleDB is a table storage extension for Postgres. it acts as a drop-in replacement for the default postgres storage engine using the Table Access Method APIs (pluggable storage). the storage engine changes the representation of table data on disk. its architecture is designed to take advantage of modern hardware like SSDs and NVRAM. it implements MVCC, the feature that allows allows multiple connected users to see different versions of the data depending on when their transaction started, via an UNDO log rather than tuple versioning.

    one caveat: it requires several patches to the postgres core to expand on the type of features external storage engines extensions can implement. for this reason it could be a while before you see this land as a default engine on supabase. we will probably make it available as an option for customers who want to experiment - no timeline is decided yet.

    finally, we have been working with the team on decoupled storage and compute [0]. this is experimental but promising, especially with some recent advances in S3 (specifically Express One Zone [1]). we have a demonstration in the blog post.

    i'll message Alexander in case there are any technical questions

    [0] https://github.com/orioledb/orioledb/blob/main/doc/usage.md#...

    [1] https://aws.amazon.com/s3/storage-classes/express-one-zone/

  • LMDB

    Read-only mirror of official repo on openldap.org. Issues and pull requests here are ignored. Use OpenLDAP ITS for issues.

  • mydumper

    Official MyDumper Project

    Project mention: Restore or Migrate your MySQL Database to Railway | dev.to | 2023-11-03

    You can create a MySQL backup for Railway.app using the MyDumper tool or by using a backup service like SimpleBackups. Both methods involve generating a dump file that can be used for restoration.

  • pgBackRest

    Reliable PostgreSQL Backup & Restore

    Project mention: pgBackRest: PostgreSQL S3 backups | dev.to | 2023-08-10

    This tutorial explains how to backup PostgreSQL database using pgBackRest and S3.

  • SQLite

    Unofficial git mirror of SQLite sources (see link for build instructions) (by mackyle)

    Project mention: SpaceX discloses cause of Starship anomalies as it clears an FAA hurdle | news.ycombinator.com | 2024-02-27
  • Sophia

    Modern transactional key-value/row storage library.

  • 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 2024-04-16.

C Database related posts

Index

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

Project Stars
1 Netdata 67,993
2 Redis 64,705
3 TDengine 22,764
4 TimescaleDB 16,404
5 WCDB 10,446
6 citus 9,779
7 valkey 9,616
8 db_tutorial 9,214
9 yugabyte-db 8,471
10 libsql 7,649
11 Greenplum 6,197
12 Hiredis 6,079
13 sqlitestudio 4,171
14 dqlite 3,703
15 psycopg2 3,205
16 PolarDB-for-PostgreSQL 2,752
17 PipelineDB 2,603
18 orioledb 2,603
19 LMDB 2,429
20 mydumper 2,336
21 pgBackRest 2,177
22 SQLite 1,962
23 Sophia 1,848
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com