General

Articles

Pages

  • DB-Engines: Knowledge Base of Relational and NoSQL Database Management Systems ๐ŸŒŸ (Recommended)

Repository

  • awesome-db-tools : Everything that makes working with databases easier ๐ŸŒŸ (Recommended)

Topics

Database Collections

Key-value Stores

Info

Key-value stores are probably the simplest form of database management systems. They can only store pairs of keys and values, as well as retrieve values when a key is known.

  • etcd: Distributed reliable key-value store for the most critical data of a distributed system ๐ŸŒŸ (Recommended)
  • redis: An in-memory database that persists on disk ๐ŸŒŸ (Recommended)
  • rocksdb: A library that provides an embeddable, persistent key-value store for fast storage.
  • tikv: Distributed transactional key-value database, originally created to complement TiDB
  • valkey: A flexible distributed key-value datastore that is optimized for caching and other realtime workloads ๐ŸŒŸ (Recommended)

No-Code

Info

A no-code database platform is similar to a spreadsheet. Itโ€™s a collection of data that can be used for storing, processing and retrieving related information without coding

  • nocodb: ๐Ÿ”ฅ ๐Ÿ”ฅ ๐Ÿ”ฅ Open Source Airtable Alternative. Website

Relational DBMS

Info

A high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.

  • ClickHouse: ClickHouseยฎ is a real-time analytics DBMS ๐ŸŒŸ (Recommended)
  • cockroach: the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
  • Apache Druid: A high performance real-time analytics database.
  • duckdb: An analytical in-process SQL database management system
  • tidb: the open-source, cloud-native, distributed SQL database designed for modern applications.

Search Engine

Info

NoSQLย database management systemsย dedicated to the search for data content. In addition to general optimization for this type of application, the specialization consists in typically offering the following features:

  • Support for complex search expressions
  • Full text search
  • Stemming (reducing inflected words to their stem)
  • Ranking and grouping of search results
  • Distributed search for high scalability
  • manticoresearch: Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon ๐ŸŒŸ (Recommended)
  • typesense: Open Source alternative to Algolia + Pinecone and an Easier-to-Use alternative to ElasticSearch โšก ๐Ÿ” โœจ
  • OpenSearch: ๐Ÿ”Ž Open source distributed and RESTful search engine ๐ŸŒŸ (Recommended)

Time Series DBMS

Info

Aย database management systemย that is optimized for handling time series data: each entry is associated with a timestamp.

  • influxdb: Scalable datastore for metrics, events, and real-time analytics

Database Tools

Configuration

  • pgbouncer: lightweight connection pooler for PostgreSQL
  • mongobetween: a proxying connections for mongodb. It is developed by coinbase.
  • GatewayD: a free and open-source cloud-native database gateway and framework for building data-driven applications

Database IDE

  • beekeeper-studio: Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows
  • Chat2DB: ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅAI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
  • dbeaver: Free universal database tool and SQL client

Database Management

  • bytebase : The GitHub/GitLab for database DevOps.
  • limbo: A work-in-progress, in-process OLTP database management system, compatible with SQLite.

Migration Tools

  • goose: A database migration tool. Supports SQL migrations and Go functions.

Self-hosted

  • pigsty: Battery-Included PostgreSQL Distro as a Free & Better RDS Alternative โ€”โ€” Pigsty
  • postgresql_cluster: PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.