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
General
- Medium - 15 Databases, 15 Use Cases โ The Ultimate Guide That No One Asked For (But Everyone Needs)
- Medium - 11 Data Structures Powering Database
- dev.to - What is RocksDB (and its role in streaming)?
- Medium - Running SpiceDB with Postgresql using docker-compose
Redis
SQL Server
Setup
Tips & Configuration
- 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 โก ๐ โจ
- OpenSearch: ๐ Open source distributed and RESTful search engine.
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. 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.