Database-OpenSource-List

Database OpenSource List | 数据库相关开源工具索引

Showcase

RDB

Distributed DB

  • LBADD #Project# #Scratch#: An experimental, distributed SQL database.
  • CockroachDB #Project#: CockroachDB is a cloud-native distributed SQL database designed to build, scale, and manage modern, data-intensive applications.
  • Toydb #Project#: Distributed SQL database in Rust, written as a learning project. Most components are built from scratch.

Timeseries

  • 2017-Writing a Time Series Database from Scratch: While the current storage has served us well, I propose a newly designed storage subsystem that corrects for shortcomings of the existing solution and is equipped to handle the next order of scale.
  • 2021-mandodb #Project#: 🤔 A minimize Time Series Database, written from scratch as a learning project. 从零开始实现一个 TSDB

Universal SQL Tools

Client

GUI

  • SQL Fiddle #Project#: A tool for easy online testing and sharing of database problems and their solutions.
  • Dbeaver #Project#: Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
  • HeidiSQL #Project#: HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL or PostgreSQL.
  • 2020-Beekeeper Studio #Project#: Cross platform SQL editor and database management app for Windows, Linux, and Mac.
  • 2020-Hue Editor #Project#: Open source SQL Query Assistant for Databases/Warehouses.
  • DataStation #Project#: App to easily query, script, and visualize data from every database, file, and API.

CMD

  • 2018-q #Project#: q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).
  • usql #Project#: usql is a universal command-line interface for working with SQL databases.

Editor

  • 2014-sqlpad #Project#: Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, Presto, SAP HANA, and Cassandra.
  • 2016-Falcon #Project#: Free, open-source SQL client for Windows and Mac 🦅

Analysis & Execution & Driver

Audit(审核平台)

  • 2017-SQLAdvisor #Project#: SQLAdvisor 是由美团点评公司技术工程部 DBA 团队(北京)开发维护的一个分析 SQL 给出索引优化建议的工具。它基于 MySQL 原生态词法解析,结合分析 SQL 中的 where 条件、聚合条件、多表 Join 关系 给出索引优化建议。目前 SQLAdvisor 在美团点评内部广泛应用,公司内部对 SQLAdvisor 的开发全面转到 github 上,开源和内部使用保持一致。
  • 2019-Yearning #Project#: MYSQL 开源 SQL 语句审核平台。

Migration & Backup & Transfer

Benchmark

Relational Database

StoreEngine

  • 2021-Extensible-Storage-Engine #Project#: ESE is an embedded / ISAM-based database engine, that provides rudimentary table and indexed access. However the library provides many other strongly layered and and thus reusable sub-facilities as well: A Synchronization / Locking library, a Data-structures / STL-like library, an OS-abstraction layer, and a Cache Manager, as well the full blown…

Sharding

  • Sharding-Sphere #Project#: Sharding-Sphere is an open-source ecosystem consisted of a set of distributed database middleware solutions, including 3 independent products, Sharding-JDBC, Sharding-Proxy & Sharding-Sidecar (todo).
  • 2015-KingShard #Project#: kingshard is a high-performance proxy for MySQL powered by Go.
  • Atlas #Project#: A high-performance and stable proxy for MySQL, it is developed by Qihoo's DBA and infrastructure team.
  • 2017-Vitess #Project#: Vitess is a database clustering system for horizontal scaling of MySQL.
  • 2019-Gaea #Project#: Gaea is a mysql proxy, it's developed by xiaomi b2c-systech team.

Key-Value Database

  • LevelDB #Project#: LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
  • RocksDB #Project#: A library that provides an embeddable, persistent key-value store for fast storage.
  • 2018-Tidis #Project#: Tidis is a Distributed NoSQL database, providing a redis-protocal api(string,list,hash,set,sorted-set), written in Go.
  • 2019-Badger #Project#: BadgerDB is an embeddable, persistent and fast key-value (KV) database written in pure Go. It is the underlying database for Dgraph, a fast, distributed graph database. It's meant to be a performant alternative to non-Go-based key-value stores like RocksDB.
  • 2020-terarkdb #Project#: A RocksDB compatible KV storage engine with better performance.
  • immudb #Project#: world’s fastest immutable database, built on a zero trust model.

Graph Database

  • Cayley #Project#: Cayley is an open-source graph inspired by the graph database behind Freebase and Google's Knowledge Graph.
  • Neo4j #Project#: Neo4j is the world’s leading Graph Database. It is a high performance graph store with all the features expected of a mature and robust database, like a friendly query language and ACID transactions.
  • Dgraph #Project#: Dgraph is a horizontally scalable and distributed graph database, providing ACID transactions, consistent replication and linearizable reads.
  • Nebula #Project#: A distributed, fast open-source graph database featuring horizontal scalability and high availability.

TimeSeries

  • 2013-InfluxDB #Project#: InfluxDB is an open source time series database with no external dependencies. It's useful for recording metrics, events, and performing analytics.
  • 2017-timescaledb #Project#: An open-source time-series database optimized for fast ingest and complex queries. Engineered up from PostgreSQL, packaged as an extension.
  • 2018-M3 monorepo #Project#: Distributed TSDB, Aggregator and Query Engine, Prometheus Sidecar, Metrics Platform
  • VictoriaMetrics #Project#: VictoriaMetrics is fast, cost-effective and scalable time series database.
  • TDengine #Project#: TDengine is an open-sourced big data platform under GNU AGPL v3.0, designed and optimized for the Internet of Things (IoT), Connected Cars, Industrial IoT, and IT Infrastructure and Application Monitoring.
  • 2019-LinDB #Project#: LinDB is a scalable, high performance, high availability distributed time series database.
  • 2019-VictoriaMetrics #Project#: Fast, cost-effective and scalable time series database, long-term remote storage for Prometheus.
  • 2021-QuestDB #Project#: QuestDB is a distributed, high-performance, fully-distributed, high-availability, fully-scalable, and highly-available time series database.

NewSQL

  • FoundationDB #Project#: FoundationDB is a distributed database designed to handle large volumes of structured data across clusters of commodity servers.

P2P Database

  • OrbitDB #Project#: Peer-to-Peer Databases for the Decentralized Web.
  • Scuttlebot #Project#: Scuttlebot is an open source peer-to-peer log store used as a database, identity provider, and messaging system. It features global replication, file-syncronization, and end-to-end encryption.
Last modified 1mo ago