DEV Community

What database do you use?

Nandini S Hinduja on March 31, 2024

I recently started doing backend development and so I started using databases in my work. So was curious as to what are the databases which other p...
Collapse
 
underflow profile image
Steffen H. Nielsen

For my own personal projects, i keep using PostgeSQL (not really sure why, but it's just seems to work for me). On the work side, MSSQL is the go to one. Here in Denmark, im not sure how many applications runs on other database platforms. I have never heard any coworker or other professional usie something else, but then again Denmark is a big Microsoft fanboy :D

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

Nice

Collapse
 
Sloan, the sloth mascot
Comment deleted
Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great!

Collapse
 
siph profile image
Chris Dawkins

I've been trying out Surrealdb and I like it a lot. I can use it as an embedded db or as a server/client model (makes testing pretty easy). The query language is nice and it also has built-in vector functions so I'm using it as a vector store for a Retrieval-Augmented Generation (RAG) pipeline.

I also recently learned about recfiles but haven't had a chance to use them yet.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

Great!

Collapse
 
mortylen profile image
mortylen

Hi. For internal company systems I use Microsoft SQL Server, for the majority of customers in the industry I also use MS SQL Server + PostgreSQL. But for Linux and low-cost solutions mainly PostgreSQL.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

amazing!

Collapse
 
alexfrancoeur profile image
AlexF • Edited

Hey, I'm head of product over at Xata. A large portion of our team came from Elastic and a common architecture we saw at scale was PostgreSQL + Elasticsearch as a way to get all the OLTP benefits of a relational database with full text search and metrics / aggregations for other application / analytical needs. This was seen across industries ranging from the ecommerce to commercial applications to the federal government. With the boost in AI use cases, I can only imagine this has become even more common of an architecture.

We've decided to productize this architecture as a service. If you're interested in learning more about the implementation details for inspiration, here's the architecture behind our platform: xata.io/docs/concepts/serverless-d...

Collapse
 
dijihax profile image
DijiHax

I am building one. Kind of insane.

Collapse
 
miketalbot profile image
Mike Talbot ⭐

Interesting... Why?

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

super!

Collapse
 
nicolus profile image
Nicolus

MySQL (and Redis for cache and queues).

Honestly I haven't really experimented with anything else, I could easily switch to MariaDB (which is more or less a drip in replacement) or Postgres (since most of my projects use an ORM that can use MySQL or Postgres interchangeably). I know that MySQL works for me, after 10 years of using it I know how InnoDB works and how to optimize for it, I know which tools I need with MySQL (mostly tools from Percona)... So I don't really feel the need to start over with another DB.

I'll definitely use something like Mongo if I ever need to store non relational data, or Cassandra if I need to store data over many decentralized servers, and I indirectly use Elastic search for time series when I use graylog to store my logs. But it turns out most of the applications I build need a centralize datasource (with a few Replicas for availability) to store relational data, so MySQL it is !

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great to know!

Collapse
 
dogecl profile image
Alejandro A.

For the back end, I prefer MySQL or PostgreSQL in GCP/AWS. For analytics, I use BigQuery daily.
Because of my specialty (data engineering), I must use all the databases mentioned and even more (depending on the project). Imagine migrating Access to SQL; it's very funny.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice!

Collapse
 
miketalbot profile image
Mike Talbot ⭐

MySQL and Redis (with SQL Server for access to some legacy data).

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

super!

Collapse
 
thomasbnt profile image
Thomas Bnt ☕

MariaDB/MySQL, and a little of PostgreSQL. But I love using these databases with Prisma ORM

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

Amazing

Collapse
 
androaddict profile image
androaddict

Now redis is paid one ? Plz confirm

Collapse
 
katafrakt profile image
Paweł Świątkowski

It's not, unless you want to resell it as managed service

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

Yes

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

no

Collapse
 
efpage profile image
Eckehard

For simple cases I use sqlite, which is easy to maintain. There is an API for NODE.JS or PHP.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

Super

Collapse
 
eayurt profile image
Ender Ahmet Yurt

Currently we use PostgreSQL and Redis.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great

Collapse
 
the_komplikator profile image
k0mplikat0r

Microsoft SQL Server

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice

Collapse
 
sreno77 profile image
Scott Reno

MySQL, Postgres, and SQLite

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great

Collapse
 
danbailey profile image
Dan Bailey

I use whatever's right for the job. Typically, though, I use MariaDB or PostgreSQL for structured data, and MongoDB or CosmosDB for unstructured data.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great

Collapse
 
bitnom profile image
bitnom

Supabase (So postgresql) and SurrealDB

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

amazing

Collapse
 
gufvr profile image
Gustavo Favero

PostgreSQL

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice

Collapse
 
pavanbelagatti profile image
Pavan Belagatti • Edited

SingleStore database for all the AI/ML applications:) Try it for free and once you sign up, you will receive $600 worth free credits to play around.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

amazing

Collapse
 
hans_stolz_e74e5342c36ccd profile image
Hans STOLZ

I use MySQL(mainly) and Redis.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great!

Collapse
 
richardevcom profile image
richardevcom

MongoDB for smaller projects and MySQL for bigger ones.
Redis for caching only.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

super

Collapse
 
pistolario profile image
Marcos Pérez

We use IBM DB2 at work. It's reliable but lacks a lot of modern features

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

awesome!

Collapse
 
ngdangtu profile image
Đăng Tú

I like SQLite for most of the daily tasks

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

great!

Collapse
 
jesusantguerrero profile image
Jesus Guerrero

MySQL and firebase mostly.

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

awesome!

Collapse
 
blinkinglight profile image
M • Edited

with golang i am using these depending on situation: mariadb , sqlite, bboltdb

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice

Collapse
 
drownedsound profile image
Drowned Sound

PostgreSQL

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice!

Collapse
 
yeahhub profile image
Yeah Hub

Elasticsearch and MongoDB

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice!

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

amazing

Collapse
 
dexelectronics profile image
Dexel

PostgreSQL

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

amazing!

Collapse
 
gittyhuble profile image
Gittyhuble

Oracle hentzer Google Amazon DOD.MI

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

nice!

Collapse
 
simulacrum profile image
PlusUltra • Edited

Supabase hands down

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

awesome

Collapse
 
w1030777212 profile image
Hubert

I use Gauss DB in work

Collapse
 
nandinishinduja profile image
Nandini S Hinduja

amazing

Collapse
 
ingenieurdev01 profile image
IngénieurDev

PostgeSQL
MySQL