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 18 relational-database Open-Source Projects
-
-
edgedb
A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
-
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.
-
-
awesome-system-design
A curated list of awesome System Design (A.K.A. Distributed Systems) resources.
-
oceanbase
OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards.
-
-
cozo
A transactional, relational-graph-vector database that uses Datalog for query. The hippocampus for AI!
-
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.
-
redux-orm
NOT MAINTAINED – A small, simple and immutable ORM to manage relational data in your Redux store.
-
go-mysql-server
A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
-
sqlsync
SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.
-
-
-
-
singlestoredb-dev-image
The SingleStoreDB Dev Container is the fastest way to develop with SingleStore on your laptop or in a CI/CD environment.
-
aws-cloudformation-resource-providers-rds
The CloudFormation Resource Provider Package For Amazon Relational Database Service
-
ActiveRecord Setops
Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: The lightweight, easy-to-use, distributed relational database built on SQLite | news.ycombinator.com | 2024-02-23
Project mention: EdgeDB – A graph-relational database with declarative schema | news.ycombinator.com | 2024-02-10
Project mention: SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL | news.ycombinator.com | 2024-03-25
Project mention: Ask HN: Resources to learn boring architecture for a small startup? | news.ycombinator.com | 2023-12-25https://github.com/madd86/awesome-system-design
Project mention: Show HN: OceanBase – An open-source distributed SQL database written in C++ | news.ycombinator.com | 2023-05-23
Project mention: 3 years of fulltime Rust game development, and why we're leaving Rust behind | news.ycombinator.com | 2024-04-26I don't use Rust for game dev but I do for low level libraries and find it easier than C++ to get started. I have enjoyed it more than Java and like it for different reasons than Go, but it feels good to program in.
As for the design patterns that a complex game requires, if you are considering Rust for game dev and ecs design patterns it might be useful to check out projects that are Rust centric like https://spacetimedb.com/.
Project mention: Transactional, relational-graph-vector database that uses Datalog for query | news.ycombinator.com | 2024-03-31
Project mention: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09
If you're looking for a very real use case of SQLite in the browser, there's SQLSync[1]. It was recently discussed on HN[2].
[1]: https://sqlsync.dev/posts/stop-building-databases/, https://sqlsync.dev/
FoundationDB is really just a set of structures and tools to build any type of database you want on top of a solid foundation.
"FoundationDB decouples its data storage technology from its data model. FoundationDB’s core ordered key-value storage technology can be efficiently adapted and remapped to a broad array of rich data models. Using indexing as an example, FoundationDB’s core provides no indexing and never will. Instead, a layer provides indexing by storing two kinds of key-values, one for the data and one for the index."
https://apple.github.io/foundationdb/layer-concept.html
Then existing standard layers like the Record layer, providing "(very) roughly equivalent to a simple relational database" providing structured types, index, complex types, queries, etc.
https://github.com/FoundationDB/fdb-record-layer
> Very curious if anyone knows how to pull this off.
I work in this space (small/mid-size).
The good news is that there are several "obvious" ways to pull this off because an ERP is the culmination of everything a company needs and does. So almost anything you can imagine on the software is part of it.
The bad news, and the reason everyone wants a solution, is that is truly a big space, and then you need E.V.E.R.Y.T.H.I.N.G.
---
My take is to start from the bottom, and build a much better version of Access/FoxPro (https://tablam.org).
Any medium/big ERP end being a specialized computing platform that needs:
- A programming language
- A database engine
- An orchestration engine
- ELT engine
- Auth
- UI/Report builders
And to be clear: NONE of the "programming language", "database engine", etc are a good fit today.
NONE.
This is the big thing, This is the reason (from a tech POW only) that most attempts fail.
This is the secret of why Cobol rule(d): Is all of this! but is too old! (also, this is why SQL still is best: Is almost this).
---
So, to pull this off, you need a team that knows what is "missing" from our current tools, makes a well-integrated package, and adds a "user-friendly" interface in a way that is palatable for the kind of user that uses excel (powerfully).
Is not that impossible. FoxPro was the best example of this kind of integrated solution.
P.D: This is my life's dream, to make this truth!
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).
relational-database related posts
- Figma's Databases team lived to tell the scale
- The lightweight, easy-to-use, distributed relational database built on SQLite
- YC's Latest Request for Startups
- Ask HN: Resources to learn boring architecture for a small startup?
- What if an SQL Statement Returned a Database?
- Rqlite 8.0
- SQLSync: Collaborative Offline-first SQLite
-
A note from our sponsor - InfluxDB
www.influxdata.com | 28 Apr 2024
Index
What are some of the best open-source relational-database projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | rqlite | 14,862 |
| 2 | edgedb | 12,280 |
| 3 | citus | 9,840 |
| 4 | awesome-system-design | 8,297 |
| 5 | oceanbase | 7,402 |
| 6 | SpacetimeDB | 4,030 |
| 7 | cozo | 3,099 |
| 8 | redux-orm | 2,952 |
| 9 | go-mysql-server | 2,182 |
| 10 | sqlsync | 1,717 |
| 11 | atomspace | 777 |
| 12 | fdb-record-layer | 564 |
| 13 | TablaM | 183 |
| 14 | singlestoredb-dev-image | 33 |
| 15 | aws-cloudformation-resource-providers-rds | 25 |
| 16 | Fregata | 23 |
| 17 | ActiveRecord Setops | 21 |
| 18 | WSQL | 2 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com