Awesome DB

Overview

Awesome DB provides a curated list of database libraries, resources, and tools covering both SQL and NoSQL databases including Redis, RethinkDB, and many others.

Featured Databases

In-Memory Databases

• Redis: In-memory data structure store used as database, cache, and message broker
• Memcached: High-performance distributed memory caching
• Hazelcast: In-memory data grid

Document Databases

• MongoDB: Popular NoSQL document database
• RethinkDB: Open-source distributed JSON document database with realtime change feeds
• CouchDB: Document-oriented NoSQL database
• DocumentDB: AWS document database (MongoDB compatible)

Relational Databases

• PostgreSQL: Advanced open-source relational database
• MySQL/MariaDB: Popular open-source SQL databases
• SQLite: Embedded SQL database
• Oracle: Enterprise relational database
• Microsoft SQL Server: Microsoft's relational database

Graph Databases

• Neo4j: Leading graph database
• ArangoDB: Multi-model database with graph support
• OrientDB: Multi-model database
• JanusGraph: Distributed graph database

Time Series Databases

• InfluxDB: Time series database
• TimescaleDB: PostgreSQL extension for time series
• Prometheus: Monitoring and time series database
• Graphite: Time series database

Wide Column Stores

• Cassandra: Distributed NoSQL database
• HBase: Hadoop database
• ScyllaDB: Cassandra-compatible database

Search Engines

• Elasticsearch: Distributed search and analytics
• Solr: Enterprise search platform
• MeiliSearch: Fast search API
• Typesense: Fast search engine

NewSQL Databases

• CockroachDB: Distributed SQL database
• TiDB: Distributed SQL database
• YugabyteDB: Distributed SQL database

Database Tools

Management Tools

• DBeaver: Universal database tool
• pgAdmin: PostgreSQL administration
• phpMyAdmin: MySQL web interface
• MongoDB Compass: MongoDB GUI

CLI Tools

• mycli: MySQL CLI with autocomplete
• pgcli: PostgreSQL CLI with autocomplete
• redis-cli: Redis command line
• mongo shell: MongoDB shell

Migration Tools

• Flyway: Database migration tool
• Liquibase: Database schema change management
• Alembic: Database migration for Python
• migrate: Go migration library

Backup & Recovery

• pg_dump: PostgreSQL backup
• mysqldump: MySQL backup
• Percona XtraBackup: MySQL backup tool
• Barman: Backup and Recovery Manager for PostgreSQL

Performance & Monitoring

• pg_stat_statements: PostgreSQL query statistics
• Percona Monitoring and Management: Database monitoring
• SolarWinds Database Performance Analyzer: Performance monitoring
• Datadog: Database monitoring

Database Libraries & ORMs

JavaScript/TypeScript

• Sequelize: ORM for Node.js
• TypeORM: TypeScript ORM
• Prisma: Next-generation ORM
• Mongoose: MongoDB object modeling
• Knex.js: SQL query builder

Python

• SQLAlchemy: SQL toolkit and ORM
• Django ORM: Built-in Django ORM
• Peewee: Simple ORM
• Motor: Async MongoDB driver
• PyMongo: MongoDB driver

Java

• Hibernate: ORM framework
• MyBatis: SQL mapper
• jOOQ: Type-safe SQL builder
• Spring Data: Data access framework

Go

• GORM: ORM library
• sqlx: Extensions for database/sql
• pgx: PostgreSQL driver

PHP

• Doctrine: ORM and DBAL
• Eloquent: Laravel ORM
• RedBeanPHP: Easy ORM

Ruby

• ActiveRecord: Rails ORM
• Sequel: Database toolkit
• DataMapper: ORM framework

Database Concepts

ACID Properties

• Atomicity
• Consistency
• Isolation
• Durability

CAP Theorem

• Consistency
• Availability
• Partition tolerance

Indexing

• B-tree indexes
• Hash indexes
• Full-text indexes
• Geospatial indexes

Replication

• Master-slave replication
• Master-master replication
• Synchronous vs asynchronous
• Statement-based vs row-based

Sharding

• Horizontal partitioning
• Vertical partitioning
• Hash-based sharding
• Range-based sharding

Use Cases

Ideal for:

• Database administrators
• Backend developers
• Data engineers
• DevOps engineers
• Anyone working with databases