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 database-management Open-Source Projects
-
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.
-
postgres-operator
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service. (by CrunchyData)
-
nosqlclient
Cross-platform and self hosted, easy to use, intuitive mongodb management tool - Formerly Mongoclient
-
cloudnative-pg
CloudNativePG is a comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments, covering the entire operational lifecycle from initial deployment to ongoing maintenance
-
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.
-
DataStructures-Algorithms
This repo contains links of resources, theory subjects content and DSA questions & their solution for interview preparation from different websites like geeksforgeeks, leetcode, etc.
-
schemahero
A Kubernetes operator for declarative database schema management (gitops for database schemas)
-
vector-admin
The universal tool suite for vector database management. Manage Pinecone, Chroma, Qdrant, Weaviate and more vector databases with ease.
-
pmm
Percona Monitoring and Management: an open source database monitoring, observability and management tool
-
awesome-mysql-performance
🔥 A curated list of awesome links related to MySQL / MariaDB / Percona performance tuning
-
SQL-interview-questions
List of Top 500 SQL Interview Questions & Answers with queries and more (by kansiris)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows: https://flywaydb.org/
(Though I don't think it is "complete" or "perfect", either.)
EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's tooling you can package your migration "runner application" as a single deployable executable for most platforms. You can build the executable once and run it in all your environments. (The same tool that updates your QA and Staging updates your Prod, testably running the same migrations.) Given the single executable deployable I might even consider using it for projects not themselves written in C#.
Project mention: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase
Project mention: C# program not able to open or connect to an encrypted SQLite Database | /r/sqlite | 2023-04-30DB4S 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.
Project mention: No disk space crashloop but pod healthy · Issue #3788 · CrunchyData/postgres-operator | /r/Health2020 | 2023-12-09
Project mention: SQLedge: Replicate Postgres to SQLite on the Edge | news.ycombinator.com | 2023-08-09#. SQLite WAL mode
From https://www.sqlite.org/isolation.html https://news.ycombinator.com/item?id=32247085 :
> [sqlite] WAL mode permits simultaneous readers and writers. It can do this because changes do not overwrite the original database file, but rather go into the separate write-ahead log file. That means that readers can continue to read the old, original, unaltered content from the original database file at the same time that the writer is appending to the write-ahead log
#. superfly/litefs: aFUSE-based file system for replicating SQLite https://github.com/superfly/litefs
#. sqldiff: https://www.sqlite.org/sqldiff.html https://news.ycombinator.com/item?id=31265005
#. dolthub/dolt: https://github.com/dolthub/dolt
> Dolt can be set up as a replica of your existing MySQL or MariaDB database using standard MySQL binlog replication. Every write becomes a Dolt commit. This is a great way to get the version control benefits of Dolt and keep an existing MySQL or MariaDB database.
#. pganalyze/libpg_query: https://github.com/pganalyze/libpg_query :
> C library for accessing the PostgreSQL parser outside of the server environment
#. Ibis + Substrait [ + DuckDB ]
> ibis strives to provide a consistent interface for interacting with a multitude of different analytical execution engines, most of which (but not all) speak some dialect of SQL.
> Today, Ibis accomplishes this with a lot of help from `sqlalchemy` and `sqlglot` to handle differences in dialect, or we interact directly with available Python bindings (for instance with the pandas, datafusion, and polars backends).
> [...] `Substrait` is a new cross-language serialization format for communicating (among other things) query plans. It's still in its early days, but there is already nascent support for Substrait in Apache Arrow, DuckDB, and Velox.
#. benbjohnson/postlite: https://github.com/benbjohnson/postlite
> postlite is a network proxy to allow access to remote SQLite databases over the Postgres wire protocol. This allows GUI tools to be used on remote SQLite databases which can make administration easier.
> The proxy works by translating Postgres frontend wire messages into SQLite transactions and converting results back into Postgres response wire messages. Many Postgres clients also inspect the pg_catalog to determine system information so Postlite mirrors this catalog by using an attached in-memory database with virtual tables. The proxy also performs minor rewriting on these system queries to convert them to usable SQLite syntax.
> Note: This software is in alpha. Please report bugs. Postlite doesn't alter your database unless you issue INSERT, UPDATE, DELETE commands so it's probably safe. If anything, the Postlite process may die but it shouldn't affect your database.
#. > "Hosting SQLite Databases on GitHub Pages" (2021) re: sql.js-httpvfs, DuckDB https://news.ycombinator.com/item?id=28021766
#. awesome-db-tools https://github.com/mgramin/awesome-db-tools
My holiday project was doing another pass at my Homelab Kubernetes cluster, part of which involved switching to a proper operator to manage Postgres. Coincidentally, I setup cloudnative-pg (https://github.com/cloudnative-pg/cloudnative-pg) yesterday.
Project mention: Five Free Open-Source Database Managers for MySQL, PostgreSQL, and More | dev.to | 2024-01-18OmniDB is a collaborative open-source database manager that’s available as a hosted version or as a stand-alone app. The application is built keeping simplicity in mind, making it one of the most user-friendly database managers.
Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11Congratulations on launching, it's nice to see more open source products in this area (I work on https://mathesar.org/). Feel free to reach out if you'd like to talk and compare notes.
Project mention: Generate and run SQL with GPT in Database Client (built with go - wails) | /r/golang | 2023-07-02
Project mention: C# program not able to open or connect to an encrypted SQLite Database | /r/sqlite | 2023-04-30DB4S 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.
Project mention: SchemaHero Is a Kubernetes Operator for Declarative Schema Management | news.ycombinator.com | 2023-10-01
Project mention: 🐬How to Install Local MySQL on Your Mac, Ubuntu, CentOS, Windows🚀🦾 | dev.to | 2023-11-16Check out DBngin or StackBricks.
Also comes with more than a CRUD UI, also has other built-in tools for RAG applications. https://github.com/Mintplex-Labs/vector-admin
Project mention: HouseWatch: Open-source tool for monitoring and managing ClickHouse clusters | /r/hypeurls | 2023-06-17
Project mention: How MySQL Tuning Can Dramatically Improve WordPress Performance | /r/Wordpress | 2023-06-21To tune manually, you could start with the following links: 1. MySQL Health Checks https://releem.com/blog/mysql-health-checks 2. Documentation on how to tune parameters: - https://releem.com/docs/getstarted - https://releem.com/docs/mysql-performance-parameters 3. Curated list of awesome links related to MySQL Performance Tuning https://github.com/Releem/awesome-mysql-performance
Project mention: Hi Guys! I am completely new to database and trying to switch from Civil Engineering background to IT sector. I want to get entry level job in database. I have learned the basics of MySQL. Now how do I prepare for interview? | /r/SQL | 2023-06-22Here’s a list of 500 SQL interview questions https://github.com/kansiris/SQL-interview-questions
database-management related posts
- Percona Monitoring and Management (Pmm)
- Create your Joomla website using Docker
- 🐬How to Install Local MySQL on Your Mac, Ubuntu, CentOS, Windows🚀🦾
- 🌹 Awesome development tools for PHP 2023
- Show HN: EDMA – Embedded database management tool written in Rust
- How I created AI-powered ORM for PostgreSQL, MySQL and SQLite and why you shouldn't use it
- SchemaHero Is a Kubernetes Operator for Declarative Schema Management
-
A note from our sponsor - WorkOS
workos.com | 19 Apr 2024
Index
What are some of the best open-source database-management projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Flyway | 7,754 |
2 | liquibase | 4,384 |
3 | sqlitestudio | 4,195 |
4 | postgres-operator | 3,715 |
5 | awesome-db-tools | 3,680 |
6 | nosqlclient | 3,472 |
7 | cloudnative-pg | 3,304 |
8 | OmniDB | 3,084 |
9 | mathesar | 2,188 |
10 | DataStructures-Algorithms | 1,599 |
11 | Prequel | 1,518 |
12 | upscheme | 1,292 |
13 | slashbase | 1,291 |
14 | sqlite-gui | 1,043 |
15 | schemahero | 950 |
16 | android_dbinspector | 943 |
17 | DBngin | 879 |
18 | vector-admin | 755 |
19 | pmm | 542 |
20 | HouseWatch | 460 |
21 | awesome-mysql-performance | 457 |
22 | compalex | 425 |
23 | SQL-interview-questions | 413 |