What database do you use?

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

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.

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.

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...

I am building one. Kind of insane.

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 !

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.

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

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