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 😅😅😅
Articles
Elasticsearch
- Opster - Elasticsearch Heap Size Usage and JVM Garbage Collection
- Orchestrating Elastic Stack applications
General
- Medium - 15 Databases, 15 Use Cases — The Ultimate Guide That No One Asked For (But Everyone Needs)
- Medium - 11 Data Structures Powering Database
MongoDB
OthersDB
- dev.to - What is RocksDB (and its role in streaming)?
- Medium - Running SpiceDB with Postgresql using docker-compose
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
Redis
SQL Server
- Azure - Analyze and prevent deadlocks in Azure SQL Database
- How to find and fix SQL Server deadlocks
- Performance Troubleshooting | Azure SQL
- Azure - Deadlocks guide
Awesome repositories
Pages
- DB-Engines: Knowledge Base of Relational and NoSQL Database Management Systems
Repository
- awesome-db-tools : Everything that makes working with databases easier
- mongodb-kubernetes-operator : MongoDB Community Kubernetes Operator
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
- redis: An in-memory database that persists on disk.
- 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.
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
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. Website
- 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. Website Documentation
- 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
- typesense: Open Source alternative to Algolia + Pinecone and an Easier-to-Use alternative to ElasticSearch ⚡ 🔍 ✨
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
Database IDE
- beekeeper-studio: Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows. Website
- 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
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.