DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’» is a community of 970,177 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
Tech Tim (@TechTim42)
Tech Tim (@TechTim42)

Posted on • Updated on • Originally published at tim.bai.uno

Database Stacks List (Popular, Trending, AWS Cloud)

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

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 sqlite3 in ur indexeddb Web, JS, SQLite
PolarDB 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 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 Postgres, Serverless
GunJS Cheap distributed edge computing DB Edge, Web
No SQL
- Document DB Mongo DB Document db
FerretDB (MangoDB) The de-facto open-source substitute to MongoDB, PostgresSQL powered Postgres, Mongo
DynamoDB Azure Cosmos DB, Oracle NoSQL DB, PartiQL - A SQL Compatible Query language for DynamoDB AWS, Cloud Native
Apache Cassandra Big Data
- Graph DB Neo4J Cypher language used.
- Cypher: How to Rewrite a UNION Query Using a COLLECT Clause
- Tuning Cypher queries by understanding cardinality
OrientDB open source, it supports graph, document, key/value and object mode4ls Java
Ontotext 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 graphql on postgressql How to get instant GraphQL APIs on your existing Django application 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 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 Compatible with Redis Redis
GhostDB Cache key/value db in golang Golang
- Other NO SQL 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 AWS Lambda + Zapi #lowcode
SurrealDB 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 Hybrid
Amazon Redshift Amazon data warehouse service Cloud
metabase 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 Open source from a Chinese company Time Series, IoT
timescaledb Open source fast time series db as postgres extension Time Series, Postgres


twitter

Top comments (0)

What image format should you use in your next project? πŸ€”