Ask HN: Is PostgreSQL Your Goto DBMS?

#1

Post by munduz » Thu, Oct 07, 2021, 5:23 AM UTC

Noticed for me, whenever new project starts, PostgreSQL is chosen as a DBMS.

We don't even consider other DBMS. PostgreSQL has proven it's efficiency even in big tech.

P.S. No offense to other DBMS

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#2

Post by shams93 » Thu, Oct 07, 2021, 5:31 AM UTC

Yeah it's definitely taking off and with the improved support for kubernetes it's going to take off even more.

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#3

Post by atmosx » Thu, Oct 07, 2021, 6:16 AM UTC

shams93 wrote: post #2

Yeah it's definitely taking off and with the improved support for kubernetes it's going to take off even more.

What kind of support are we talking about?

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#4

Post by tofukid » Thu, Oct 07, 2021, 6:24 AM UTC

My go to is SQLite, unless I need GIS features. If traffic or database size becomes unwieldy, it’s easy to transition to PostgreSQL.

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#5

Post by gjvc » Thu, Oct 07, 2021, 6:25 AM UTC

atmosx wrote: post #3

shams93 wrote: post #2

Yeah it's definitely taking off and with the improved support for kubernetes it's going to take off even more.

What kind of support are we talking about?

https://www.kubegres.io/ perhaps

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#6

Post by Andys » Thu, Oct 07, 2021, 6:27 AM UTC

I have switched to cockroachdb for personal projects as it is wire-compatible with postgres, but is easier to run/scale/maintain

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#7

Post by munduz » Thu, Oct 07, 2021, 6:45 AM UTC

tofukid wrote: post #4

My go to is SQLite, unless I need GIS features. If traffic or database size becomes unwieldy, it’s easy to transition to PostgreSQL.

We do same with projects in django but deploy with PostgreSQL.

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#8

Post by m8s » Thu, Oct 07, 2021, 9:09 AM UTC

It's pretty much the default database in the Elixir/Phoenix world and I really don't see any reason for my to change.

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#9

Post by altdataseller » Thu, Oct 07, 2021, 9:37 AM UTC

I use MongoDB as it’s more scalable by default. Harder to distribute Postgres across more than 1 node

Re: Ask HN: Is PostgreSQL Your Goto DBMS?

#10

Post by jmstfv » Thu, Oct 07, 2021, 9:57 AM UTC

I love Postgres and used it in the past in my businesses.

With my new business, though, I went with SQLite. It's good enough, and I don't have to worry about keeping it up 24/7 (or paying someone to keep it up). I can copy a database file to a new machine, and it'll be up and running in no time. I don't worry much about scalability.

More often than not, simple is better than complex.