Database Stacks List (Popular, Trending, AWS Cloud)
Tags: aws, database, startup, webdev
Published: 2022-09-28 09:36:26


There are many new tech stacks creating everyday, a lot of existing problems in software could be solved in using a different tech stacks, especially in data and data storage area. Based on my experience in software engineering, I found many companies using improper storage stack,

for example,

- Using a OLTP db for OLAP purpose, it costs tons of time and money for maintaining the services running.
  - This kind of problems could possibly be solved easily after analysing usage and switching to a data warehouse service like Amazon redshift.
- Using a single instance DB for different regions customers, with company growing, the main customers/users’ region changed, and company suffer from the bottle neck of DB performance and network latency.
  - This problem could possible be solved by using cloud native db or a proper distribute db.

![db gif](https://media.giphy.com/media/kPrlykW2TpVU4HWx2O/giphy.gif)


This page is (trying) to list all trending/robust/new data related stacks (including the AWS database as well) to help engineers and architect to choose next right db stack for their products, to avoid this kind of issues once for all. Hopefully, this could help you a bit. 

---



| Category                        | Name                                                         | Description                                                  | Tag                  |
| ------------------------------- | ------------------------------------------------------------ | ------------------------------------------------------------ | -------------------- |
| **Relational DB** (SQL DB/OLTP) | MySQL                                                        |                                                              |                      |
|                                 | PostgreSQL                                                   | Amazon RDS, Amazon Aurora                                    |                      |
|                                 | SQLite                                                       |                                                              |                      |
|                                 | [absurd-sql](https://github.com/jlongster/absurd-sql)        | sqlite3 in ur indexeddb                                      | Web, JS, SQLite      |
|                                 | [PolarDB](https://github.com/ApsaraDB/PolarDB-for-PostgreSQL) | A cloud-native database service independently developed by Alibaba Cloud, similar to Amazon Aurora | Cloud Native         |
|                                 | Yugabyte                                                     | YugabyteDB is a high-performance transactional distributed SQL database for cloud-native applications, developed by Yugabyte. | Cloud Native         |
| **Distributed DB**              | Blazing SQL                                                  | BlazingSQL provides a high-performance distributed SQL engine in Python. Built on the RAPIDS GPU data science ecosystem, ETL massive datasets on GPUs. | Python               |
| | [YDB](https://ydb.tech/) | YDB is an open-source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions. | Open Source               |
|                                 | CockroachDB                                                  | Cloud SQL database — giving all of your apps  effortless scale, bulletproof resilience and low latency performance for users anywhere. - [How we built a forever-free serverless SQL database](https://www.cockroachlabs.com/blog/how-we-built-cockroachdb-serverless/) | Postgres, Serverless |
|                                 | GunJS                                                        | Cheap distributed edge computing DB                          | Edge, Web            |
| **No SQL**                      |                                                              |                                                              |                      |
| - Document DB                   | Mongo DB                                                     | Document db                                                  |                      |
|                                 | [FerretDB](https://github.com/FerretDB/FerretDB) (MangoDB)   | The de-facto open-source substitute to MongoDB, PostgresSQL powered | Postgres, Mongo      |
|                                 | DynamoDB                                                     | Azure Cosmos DB, Oracle NoSQL DB, [PartiQL](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.html) - A SQL Compatible Query language for DynamoDB | AWS, Cloud Native    |
|                                 | Apache Cassandra                                             |                                                              | Big Data             |
| - Graph DB                      | Neo4J                                                        | Cypher language used. <br />- [Cypher: How to Rewrite a UNION Query Using a COLLECT Clause]([https://neo4j.com/blog/cypher-union-query-using-collect-clause/](https://neo4j.com/blog/cypher-union-query-using-collect-clause/))<br />- [Tuning Cypher queries by understanding cardinality]([https://neo4j.com/developer/kb/understanding-cypher-cardinality/](https://neo4j.com/developer/kb/understanding-cypher-cardinality/)) |                      |
|                                 | [OrientDB](http://orientdb.org/)                             | open source, it supports graph, document, key/value and object mode4ls | Java                 |
|                                 | [Ontotext GraphDB](https://www.ontotext.com/products/graphdb/) | *GraphDB* allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. |                      |
|                                 | AgensGraph                                                   | a transactional graph database based on PostgreSQL           | Postgres             |
|                                 | [Hasura](https://hasura.io/)                                 | graphql on postgressql  [How to get instant GraphQL APIs on your existing Django application](https://medium.freecodecamp.org/how-to-get-instant-graphql-apis-on-your-existing-django-application-c8fcfdb945aa) | Postgres             |
|                                 | EdgeDB                                                       | as _objects_ with _properties_ connected by _links_. You can call it a relational database with an object-oriented data model, or a graph database with strictly enforced schema. We call it the first _graph-relational database_. |                      |
|                                 | [terminusdb](https://terminusdb.com/)                        | TerminusDB is a database built for data people. Terminus is a model driven graph database designed specifically for the web-age. |                      |
| - Key/Value                     | Redis                                                        |                                                              |                      |
|                                 | [KeyDB](https://keydb.dev/)                                  | Compatible with Redis                                        | Redis                |
|                                 | [GhostDB](https://github.com/jakekgrog/GhostDB)              | Cache key/value db in golang                                 | Golang               |
| - Other NO SQL                  | [ImmuDB](https://github.com/codenotary/immudb)               | immudb - immutable database based on zero trust, SQL and Key-Value, tamperproof, data change history |                      |
|                                 | NocoDB                                                       | Open source Airtable Alternative                             | No Codes             |
|                                 | Airtable                                                     | Table as a DB                                                |                      |
|   | Girst| Grist is a modern relational spreadsheet. It combines the flexibility of a spreadsheet with the robustness of a database to organize your data and make you more productive.|Open Source|
| BaaS/**Real Time** DB           | supabase                                                     | Create a backend in less than 2 minutes. Start your project with a Postgres Database, Authentication, instant APIs, and realtime subscriptions. | Postgres             |
|                                 | SapphireDb                                                   | A self-hosted, easy to use realtime database                 |                      |
|                                 | Appwrite                                                     | Open Source Firebase Alternative, Appwrite is a secure end-to-end backend server for Web, Mobile, and Flutter developers |     Open Source, #BaaS                 |
|                                 | Firebase/Firestore                                           | Google's Realtime BaaS                                       |                      |
|                                 | RethinkDB                                                    | RethinkDB pushes JSON to your apps **in realtime**.          | Open Source          |
|                                 | [PipeDream](https://pipedream.com/)                                                  | AWS Lambda + Zapi         | #lowcode           |
|                                 | [SurrealDB](https://surrealdb.com/)        | As a multi-model database, table, document + graph, cloud native, suitable for serverless applications, jamstack applications, single-page applications, and traditional applications.   | #cloud    #jamstack      |
| **OLAP/Data Warehouse**         | PingCap/TiDB                                                 | pingcap/tidb open-source NewSQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability ref [pingcap]([https://www.pingcap.com/en/](https://www.pingcap.com/en/)) | Hybrid               |
|                                 | Amazon Redshift                                              | Amazon data warehouse service                                | Cloud                |
|                                 | [metabase](https://www.metabase.com/)                        | Open source BI tool                                          |                      |
| **TimeSeries DB**               | QuestDB                                                      | Fast time series data/sensors data                           | Time Series, IoT     |
|                                 | Amazon Timestream                                            | Amazon Timestream is a fast, scalable, and serverless *time series database* service for IoT and operational applications. | Cloud                |
| | [TDEngine](https://www.taosdata.com/?zh)|Open source from a Chinese company|Time Series, IoT|
| | [timescaledb](https://github.com/timescale/timescaledb)|Open source fast time series db as postgres extension|Time Series, Postgres|

---
{% embed https://dev.to/timhub %}
[![twitter](https://res.cloudinary.com/practicaldev/image/fetch/s--opAxX3tY--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://img.shields.io/badge/Twitter-1DA1F2%3Fstyle%3Dfor-the-badge%26logo%3Dtwitter%26logoColor%3Dwhite)](https://twitter.com/TechTim42)