The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 RDBMS Open-Source Projects
-
shardingsphere
Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
-
PostgreSQL
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
-
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.
-
edgedb
A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
-
MySQL
MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database.
-
-
MariaDB
MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. (by MariaDB)
-
-
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.
-
-
-
awesome-database-design
:zap: A collection of resources and tutorials to design a better database schema.
-
helicalinsight
Helical Insight software is world’s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions.
-
cubrid
CUBRID is a comprehensive open source relational database management system highly optimized for Web Applications.
-
-
zeko-sql-builder
Zeko SQL Builder is a high-performance lightweight SQL query library written for Kotlin language
-
shardingsphere-on-cloud
A collection of tools and best practices to take ShardingSphere into the cloud
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.
Another key feature of txtai is being able to quickly move from prototyping to production. This article will demonstrate how txtai can integrate with Postgres, a powerful, production-ready and open source object-relational database system. After txtai persists content to Postgres, we'll show it can be directly queried with SQL from any Postgres client
Project mention: EdgeDB – A graph-relational database with declarative schema | news.ycombinator.com | 2024-02-10
MySQL
Mastering SQL is like engaging in a deep conversation with databases. Sometimes, you might feel like you're "chatting" with data. But don't worry, tools like phpMyAdmin for managing MySQL databases ensure that your data stays put, bidding farewell to the nightmare of "lost data." This phase requires mastering SQL and relational databases like MySQL, using tools like phpMyAdmin for data management and optimization. Tools to consider: phpMyAdmin, MySQL Workbench, Sequel Pro, and other database management tools.
MariaDB [1] is a community developed fork of MySQL, so you can feel free to use that in place of MySQL.
Another alternative would be Percona [2] which is a drop-in replacement for Oracle MySQL.
About PostgreSQL I haven't had that much of personal experience with it, but for sure I plan to learn it, because it has been battle-tested for years with lots of well-known projects, such as Django framework, for instance.
[1] https://github.com/MariaDB/server
[2] https://github.com/percona/percona-server
If the issue happen a lot, there is also: https://github.com/datafold/data-diff
That is a nice tool to do it cross database as well.
I think it's based on checksum method.
MariaDB [1] is a community developed fork of MySQL, so you can feel free to use that in place of MySQL.
Another alternative would be Percona [2] which is a drop-in replacement for Oracle MySQL.
About PostgreSQL I haven't had that much of personal experience with it, but for sure I plan to learn it, because it has been battle-tested for years with lots of well-known projects, such as Django framework, for instance.
[1] https://github.com/MariaDB/server
[2] https://github.com/percona/percona-server
If you installed Postgres via Homebrew, you need to configure bundler so that when it installs the pg gem, it knows where to find the pg_config executable, which is installed as part of Postgres. The pg gem is the Ruby interface to Postgres and requires pg_config during installation. We can use this command to configure bundler so that it can find it and successfully install pg.
Project mention: From data storage to data analysis: Tutorial on CrateDB and pandas 2 | dev.to | 2023-05-03Python 3.x with the pandas 2 and crate 0.31 packages installed.
Project mention: Building language-agnostic specifications: A good reason to start out with Rust? | /r/rust | 2023-12-05Recently, I have been building https://github.com/chaindexing/chaindexing-rs , an indexing daemon/engine for accessing blockchain data in EVM blockchains. The main goal is to eventually build an equivalent in popular languages to allow users from different backgrounds access blockchain data trivially.
I feel triggered https://github.com/Eldelshell/amforeas
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).
RDBMS related posts
- Integrate txtai with Postgres
- The Scoop on SQL
- Understanding SQL vs. NoSQL Databases: A Beginner's Guide
- How to sync your MySQL database with Salesforce in Docker using Boomi
- From zero to hero: using SQL databases in Node.js made easy
- I Deployed My Own Cute Lil’ Private Internet (a.k.a. VPC)
- How to dump and restore a Postgres DB with new table ownership
-
A note from our sponsor - WorkOS
workos.com | 25 Apr 2024
Index
What are some of the best open-source RDBMS projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | shardingsphere | 19,425 |
| 2 | PostgreSQL | 14,673 |
| 3 | edgedb | 12,280 |
| 4 | MySQL | 10,244 |
| 5 | phpMyAdmin | 7,019 |
| 6 | MariaDB | 5,298 |
| 7 | data-diff | 2,830 |
| 8 | ElectroCRUD | 1,522 |
| 9 | upscheme | 1,295 |
| 10 | Percona Server | 1,088 |
| 11 | pgslice | 1,030 |
| 12 | ruby-pg | 750 |
| 13 | temboard | 440 |
| 14 | awesome-database-design | 354 |
| 15 | helicalinsight | 282 |
| 16 | cubrid | 258 |
| 17 | riot | 227 |
| 18 | nextjs-sequelize | 103 |
| 19 | zeko-sql-builder | 97 |
| 20 | shardingsphere-on-cloud | 81 |
| 21 | crate-python | 78 |
| 22 | chaindexing-rs | 44 |
| 23 | amforeas | 44 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com