Info
Purpose to share what I learn and figure out when work with multiple Database like solutions, managing and helpful guideline for next people. Enjoy 😅😅😅
Awesome repositories
- awesome-db-tools : Everything that makes working with databases easier
- database-topic: The collection of database
- DB-Engines: Knowledge Base of Relational and NoSQL Database Management Systems
Utilities and Useful Opensource
Database IDE
- 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. Website
- beekeeper-studio: Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows. Website
OpenSource Database
- manticoresearch: Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
- ClickHouse: ClickHouse® is a real-time analytics DBMS. Website
- nocodb: 🔥 🔥 🔥 Open Source Airtable Alternative. Website
- duckdb: An analytical in-process SQL database management system. Website Documentation
- etcd: Distributed reliable key-value store for the most critical data of a distributed system
- redis: An in-memory database that persists on disk.
- cockroach: the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
- influxdb: Scalable datastore for metrics, events, and real-time analytics
- rocksdb: A library that provides an embeddable, persistent key-value store for fast storage.
- typesense: Open Source alternative to Algolia + Pinecone and an Easier-to-Use alternative to ElasticSearch ⚡ 🔍 ✨
- druid: A high performance real-time analytics database.
- tidb: the open-source, cloud-native, distributed SQL database designed for modern applications.
- tikv: Distributed transactional key-value database, originally created to complement TiDB
Migration
- goose: A database migration tool. Supports SQL migrations and Go functions.
Database Self-hosted
- postgresql_cluster: PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
- pigsty: Battery-Included PostgreSQL Distro as a Free & Better RDS Alternative —— Pigsty
General Articles
PostgreSQL
- How To Kill All Connections to a Database in PostgreSQL
- Medium - Postgres is eating the database world
- Medium - Solve PostgreSQL DataFileRead and buffer_io with Parameter Tuning
- Github Gist - psql-with-gzip-cheatsheet.sh
- Azure PostgreSQL - Backup and Restore
- Useful PostgreSQL (psql) queries, commands and snippets
MongoDB
- Medium - Solving curious case of excess memory consumption by MongoDB
- mongodb-kubernetes-operator : MongoDB Community Kubernetes Operator
Elasticsearch
- Opster - Elasticsearch Heap Size Usage and JVM Garbage Collection
- Orchestrating Elastic Stack applications