Databases
MySQL is a mature open-source relational database management system, widely used for websites, mobile backends, and enterprise applications.
Key features
JSON data type, full-text indexing, stored procedures, and triggersDatabases
MariaDB 是一个由社区和企业共同维护的高性能开源关系型数据库引擎,兼容 MySQL,提供更丰富的存储引擎与现代化特性,适合从小型应用到企业级部署。
核心功能与特色
Databases
SQLite is an open-source embedded SQL database engine known for using a single file, requiring zero configuration, and running without a server. It provides full SQL support, transactions (ACID), indexes, views, triggers, and extensions (e.g., FTS full-text search).
Use cases and target users
sqlite3 and bindings for many languages, making integration and extension straightforward.Databases
CockroachDB is an enterprise-grade distributed SQL database designed for cloud and multi-region deployments, offering strong consistency, automatic elastic scaling, and high availability, suitable for mission-critical workloads that require low latency and zero downtime.
Core features and highlights
Postgres protocol and SQL syntax, supporting complex queries and indexes.Databases
TiDB is an open-source distributed HTAP database compatible with the MySQL protocol, offering horizontal elastic scaling, strongly consistent distributed transactions, and online seamless expansion. Key components include TiKV (distributed KV storage), TiDB Server (SQL layer), PD (scheduling and metadata), and TiFlash (columnar replicas for analytics).
Use cases and target users
TiFlashTiCDC for real-time data replication, monitoring, and managed cloud options; supports self-managed deployment or hosted servicesDatabases
ClickHouse is an open-source columnar database engine for real-time analytics, optimized for large-scale OLAP and time-series data with ultra-low-latency queries and high-throughput writes.
Core features
MergeTree engine, materialized views, TTL, partitioning, and parallel replicationKafka, Grafana, Spark)ClickHouse Cloud; fast to adopt with a rich ecosystemDatabases
Elasticsearch
Elasticsearch is a distributed, near real-time search and analytics engine based on Lucene, offering powerful full-text search, structured queries, and aggregation capabilities. It is commonly used as a core component for logs/metrics, enterprise search, and security analytics.
Key features and highlights:
DSL queriesElasticsearch is suitable for a wide range of businesses that need high-speed search and real-time analytics; it's a solid foundation for building observability and search-driven applications.Databases
filters, faceting, synonyms, stop words, and custom ranking rulesHTTP/REST APIs and multi-language SDKs; get started in minutesDatabases
Typesense is an open-source, easy-to-use instant search engine focused on low-latency, fault-tolerant full-text search. It provides a simple RESTful API and multi-language SDKs to quickly add advanced search features like fuzzy matching, typo-tolerance, and instant suggestions to websites or apps.
Core features and highlights
Databases
Search API, InstantSearch and multi-language SDKs: quick to start, easy frontend integrationDatabases
Redis with a set of modular extensions into a single product, providing rich data capabilities beyond basic caching. It brings full-text search, JSON storage, graph database features, time-series data, and probabilistic data structures into one high-performance in-memory database platform.
Core features and highlights
RediSearch: full-text search, complex indexing, and vector search supportRedisJSON: native JSON storage and path queriesRedisGraph: graph modeling and relationship queriesRedisTimeSeries: efficient time-series writes and aggregation analysisRedisBloom: Bloom filters and other probabilistic structuresRedis's simple API andDatabases
Memcached is a mature distributed in-memory object caching system that provides a simple key-value store to reduce backend database load and significantly improve response times.
Key features
Memcached is well suited as a high-speed caching layer in systems that require performance optimization and scalability.Databases
Gossip protocol, and SSTable storage, and supports tunable consistency with no single point of failure.
Core features and highlights
CQL and integrates well with Spark, Kafka, Hadoop, and more.Databases
DynamoDB is AWS's fully managed NoSQL key-value and document database that delivers consistent performance at millisecond latency and automatically scales elastically, eliminating the need to manage underlying infrastructure.
Key features and highlights
Global Tables multi-region replication and DAX cache accelerationStreams real-time change streams, TTL automatic expiration, backups and restores, and at-rest encryptionDatabases
Firestore is a real-time, scalable cloud NoSQL document database provided by Google Firebase, supporting automatic sync, offline caching, and fine-grained security rules, suitable for modern mobile and web app development.
Key features & highlights
Firebase services, reducing operational and integration costsDatabases
Postgres, offering out-of-the-box APIs, real-time subscriptions, and auto-generated REST/GraphQL endpoints. It combines a traditional relational database with modern backend services to give developers a familiar, scalable backend foundation.
Core Features
REST/GraphQL endpoints from your table schemaRLS (Row-Level Security) and custom permission policiesDatabases
MySQL platform built on Vitess, designed for teams that need massive scale and fast iteration. It abstracts away traditional database operations, offering developer-friendly workflows and enterprise-grade reliability.
Key Features
Databases
Postgres platform for developers and modern cloud-native applications. Its core is the complete separation of storage and compute, enabling on-demand elastic scaling and low-cost long-term storage.
核心功能与特色
PostgreSQL:支持标准 SQL 与常用扩展,便于迁移与生态集成。Postgres 工具链无缝兼容,迁移门槛低,集成方便。Databases
SQLite for edge deployment and low-latency access. With a HTTP API and multi-language SDKs, it enables fast reads and writes, automatic multi-region replication, and a convenient local development experience. It emphasizes simple operations and developer-friendly workflows.
Use cases and target users
SQLite: easy to adopt and friendly with existing toolchainsDatabases
Prisma Studio is an intuitive database GUI from Prisma for developers using Prisma Client. It presents tables visually, allowing viewing, filtering, sorting, and direct editing of records, supports expanding relation fields and navigating between related data within the UI. Useful for local development, integration testing, debugging, and data fixes; especially well-suited to full-stack/back-end engineers and QA.
Main features and highlights
schema.prisma and Prisma Client to reveal query/type information