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. Learn more β
Top 23 C Database Projects
-
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.
-
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.
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
yugabyte-db
YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
-
Greenplum
Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
-
orioledb
OrioleDB β building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) Β πΊπ¦
-
LMDB
Read-only mirror of official repo on openldap.org. Issues and pull requests here are ignored. Use OpenLDAP ITS for issues.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05netdata.cloud β Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!
Change license from BSD-3 to dual RSALv2+SSPLv1 #13157
Project mention: pg_timeseries: Open-source time-series extension for PostgreSQL | news.ycombinator.com | 2024-05-20Compression and other features use the non-Apache license:
https://github.com/timescale/timescaledb/tree/main/tsl
Project mention: SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL | news.ycombinator.com | 2024-03-25
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.
In a distributed database, NTP synchronization is essential and should be carefully monitored and fixed in case of any failures. To allow some time drift, a maximum clock skew is set. This skew should be kept low enough for performance to avoid too many read retries and high enough for availability to avoid any node evictions caused by network errors. It is a good idea to check the NTP synchronization when starting a YugabyteDB node. This will be implemented by 22255.
> PS: I've got nothing against Turso, or libSQL. In fact I spent the last year perusing their virtual WAL API. The problem is that I found no documentation, nor any useful open source implementations of it. If there any I'd be very interested. So, thus far, I also don't have anything that drives towards libSQL.
Hey, this is v and I am an engineer at Turso. We do have some documentation and an example implementation of Virtual WAL
docs: https://github.com/tursodatabase/libsql/blob/ef44612/libsql-...
example: https://github.com/tursodatabase/libsql/blob/ef44612/libsql-...
for an open source implementation, you may check how Bottomless works. Bottomless is another project which does back up like litestream and it internally implements a Virtual WAL.
Bottomless - https://github.com/tursodatabase/libsql/tree/main/bottomless
I am sure we can improve our docs, make it more discover-able and easy to find. I am open to feedback and suggestions!
Project mention: SQLiteStudio: Create, edit, browse SQLite databases | news.ycombinator.com | 2024-05-17
Project mention: Marmot: Multi-writer distributed SQLite based on NATS | news.ycombinator.com | 2023-12-11If 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)
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/
Yes, but MariaDB, mostly DIY on localhost (various test & live VMs I manage).
Most painful? Replication with automatic failover could be easier to setup. Considering switching to MySQL 8.x for the new-ish innodb cluster tools (mysqlsh, mysql-router).
Why not Postgres? Familiarity, mostly using it for Drupal & Wordpress sites where MySQL is king. Besides the occasional poorly-designed query that eats memory and causes timeouts, MySQL rarely needs my attention.
Side note: I'm excited for https://github.com/mydumper/mydumper. Multi-threaded logical backups, 2 to 5 times faster than mysqldump. It's not super stable yet, so we haven't been relying on it for long term backups, but doing a "mydumper to grab a schema on live, rsync down to laptop, myloader to import" it's been a big time saver.
This tutorial explains how to backup PostgreSQL database using pgBackRest and S3.
Project mention: SpaceX discloses cause of Starship anomalies as it clears an FAA hurdle | news.ycombinator.com | 2024-02-27
C Database related posts
-
Substituindo o Redis pelo Valkey em projetos PHP/Hyperf
-
HypoPG: Hypothetical Indexes for PostgreSQL
-
SQLiteStudio: Create, edit, browse SQLite databases
-
MySQL or Top Alternatives in 2024 and How to Choose One
-
Crash on clock skew: performance vs availability
-
Advisory/Custom/Application Lock with YugabyteDB
-
Ask HN: Any one still using MySQL?
-
A note from our sponsor - InfluxDB
www.influxdata.com | 21 May 2024
Index
What are some of the best open-source Database projects in C? This list will help you:
Project | Stars | |
---|---|---|
1 | Netdata | 68,458 |
2 | Redis | 65,060 |
3 | TDengine | 22,870 |
4 | TimescaleDB | 16,573 |
5 | valkey | 13,699 |
6 | WCDB | 10,524 |
7 | citus | 9,903 |
8 | db_tutorial | 9,265 |
9 | yugabyte-db | 8,513 |
10 | libsql | 8,018 |
11 | Greenplum | 6,213 |
12 | Hiredis | 6,104 |
13 | sqlitestudio | 4,265 |
14 | dqlite | 3,725 |
15 | psycopg2 | 3,222 |
16 | PolarDB-for-PostgreSQL | 2,769 |
17 | orioledb | 2,663 |
18 | PipelineDB | 2,615 |
19 | LMDB | 2,459 |
20 | mydumper | 2,365 |
21 | pgBackRest | 2,242 |
22 | SQLite | 1,959 |
23 | Sophia | 1,848 |
Sponsored