DEV Community

20 databases to pick in 2023 - simplified

John Rush on June 09, 2023

Hi, I'm John, Multi Startup Builder. I enjoy both coding and marketing. See all my 20 products here → johnrush.me → my BIO → Say Hi to me On Twit...
Collapse
 
jdgamble555 profile image
Jonathan Gamble

Dgraph, Supabase, Firebase, TigerGraph, RedisGraph, SurrealDb, EdgeDb, Hasura, Memgraph, 8base, Grafbase, Prisma, Drizzle, TypeDb, Neptune, Couchbase, Singlestore, Appwrite -- although there is a difference between a db, a db platform, and a db orm

Collapse
 
ivan_jrmc profile image
Ivan Jeremic

This are not db's and yes I know you wrote this already but... why the hell even write it here.

Collapse
 
johnrushx profile image
John Rush

true, I just tried to simplify it for an average reader

Collapse
 
fyapy profile image
aabdullin

I think we should add YDB to the list of distributed SQL databases.
ydb.tech/

Collapse
 
deathroll profile image
deathroll • Edited

There's also a column-oriented DBMS Clickhouse initially developed by the same company. It was designed with analytics in mind, I believe.

clickhouse.com/

edit: typo

Collapse
 
johnrushx profile image
John Rush

yeah, good one, gonna include in my next article

Collapse
 
johnrushx profile image
John Rush

never heard of it, gonna give it a try

Collapse
 
fyapy profile image
aabdullin

YDB most good for read loads, benchmark: blog.ydb.tech/ycsb-performance-ser...

Collapse
 
toddpress profile image
Todd Pressley

hoping to see gundb make the next article.

Essentially like firebase but open source and awesomer - it’s an offline-first, distributed P2P, real-time graph db built on top of browser storage 🤯

this is truly inspiring tech, check it out!

Collapse
 
syxaxis profile image
George Johnson

Superb article, some crackers I'm going to have a look and the starter code is a great way to get people playing with some of these!

I will say that with 25 years working with Oracle, make sure you pay the licenses or keep the heck away. If you think the IRS/HMRC are a nightmare for audits, you do not want to be working in a big Oracle RBDMS set up when Oracle decide to do a deep audit on your kit!

Collapse
 
johnrushx profile image
John Rush

Oracel and MsSql are just to credit their corporate market share :)

Collapse
 
adriens profile image
adriens

Why not adding duckdb ?

DuckDB Snippets

Share and vote for your favorites with the DuckDB community.

duckdbsnippets.com
Collapse
 
johnrushx profile image
John Rush

gonna give it a try first

Collapse
 
asadbukhari profile image
Asad Bukhari

This article is informative and insightful.

Collapse
 
villelmo profile image
William Torrez

What happen with SQL Server? Why nobody use this database nowadays?

Collapse
 
johnrushx profile image
John Rush

it was super expensive back in those days, Im not sure if it's free now, but running MS Sql server was not cheap

Collapse
 
villelmo profile image
William Torrez

In my university we use this technology but in the world of the living the people use non-relational database.
Image description

Collapse
 
stetrippier profile image
SteTrippier

PG for me, simple easy to read and write. I'm a noob though

Collapse
 
johnrushx profile image
John Rush

Agree, PG and Mongo are best for quick start

Collapse
 
justgage profile image
Gage

Shoutout to:

  • Datomic: datomic.com/ which allows you to make historical searches (see every value a database thing has had)
  • Dgraph: Awesome OpenSource Graph DB: dgraph.io/
Collapse
 
ilumin profile image
Teerasak Vichadee

Where is my beloved DynamoDB 🤣

Collapse
 
johnrushx profile image
John Rush

DynamoDB, how could I forget, I actually use it a lot.
Gonna add it to some of my next articles

Collapse
 
xaberue profile image
Xavier Abelaira Rueda

Funny way of introducing different DB options for new or existing projects! Tha nks!

I wanted to ask about RavenDb, what do you think? It is not listed here

Collapse
 
johnrushx profile image
John Rush

I will try it out and add to next articles

Collapse
 
igorboky profile image
Igor Boky

Ok, next time I would use KeyDB in my project I will imagine how I lift two girls with no complexity :D

Thanks for this summary John

Collapse
 
johnrushx profile image
John Rush

I keep rewatching the articles just for the memes

Collapse
 
barqawiz profile image
Alex

Many options and we still seeing startups finding a niche to create new database targeted for specific problem or use case.

Collapse
 
johnrushx profile image
John Rush

as long as we, as developers, get excited about new toys, this will be the world.
Which is good I think. Competition drives the innovation. The dev world is seeing new names every day and a week. New frameworks, languages, dbs and etc

Collapse
 
memgraphdb profile image
Memgraph

Thank you @johnrushx for including Memgraph in your list :)
Do you perhaps have Memgraph based project that you can share with us?

Collapse
 
johnrushx profile image
John Rush

don't have it in prod, just played around with it in my sandbox

Collapse
 
johnrushx profile image
John Rush

If you are interested in database, start with this one SQL, NoSql, and 5 DB types you'll never need

Collapse
 
juanitomint profile image
Juan Ignacio Borda

Minio Is still relevant?

Collapse
 
alexander_kirpichny profile image
Alexander Kirpichny

What a great way to provide useful info with memes! I didn't notice any datawarehouse in the list. Which one to choose?