Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL is the worlds’ best database

2ndquadrant.com

Post reply on HN
Print view View original

191–200 of 365 posts

Re: PostgreSQL is the worlds’ best database

#191

Post by jansense »

KptMarchewa wrote: post #165
guiriduro wrote: post #20

Earlier quoted context omitted.

I wouldn't say PostgreSQL was the analogue of golang: go's initial popular growth for being 'good enough' while being arguably oversimplified, where simplicity masks problems, under the pretence that YANGNI always applies (initial N emphasizing the Not of Aren't), seems much closer to MySQL's history. PG was driven by engineering correctness, by considering what DBAs 'Are Going to Need'. Sometimes that strictness wor…

Rust is too complicated for 90% cases. 90% of cases are simpler with GC.

I'd argue that what you're saying is true, in its current state. High-level Rust libraries take longer to write, and so they don't exist yet. As soon as Rust gets more powerful tools that abstract away the work, I suppose it might alleviate a large part of the churn.

Re: PostgreSQL is the worlds’ best database

#192

Post by jakearmitage »

smt88 wrote: post #153
jakearmitage wrote: post #149

I get all the comparison, but Redis? I still use Redis as a cache on top of my PostgreSQL queries. PostgreSQL simply can't be as fast as a K/V like Redis.

> I still use Redis as a cache on top of my PostgreSQL queries Why? Postgres has a "Redis cache" (in-memory query cache) built in already[1]. Your application layer doesn't have to worry about query caching at all. 1. https://www.postgresql.org/docs/current/runtime-config-resou...

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json

Re: PostgreSQL is the worlds’ best database

#193

Post by sandGorgon »

briffle wrote: post #173
sandGorgon wrote: post #81

i wish there was a management layer that runs and operates high availability postgres databases on AWS/GCP/Azure...but is significantly cheaper. AWS RDS makes it impossible to export snapshots to s3 (because the native snapshot storage is super expensive). EC2 m5.xlarge w/ 5000 GB storage costs 700$ RDS db.m5.xlarge w/ 5000 GB costs 1000$ Why is there no SAAS that lets me BYO my own EC2 and just runs and gives me a d…

GCP does have HA for postgresql: https://cloud.google.com/sql/docs/postgres/high-availability

GCP managed databases are more expensive than AWS.

They claim this is because (unlike AWS), they don't provision iops as "credits".

There is an opportunity to play in this price arbitrage space where you can take the cloud instances and manage a database on top of it.

Re: PostgreSQL is the worlds’ best database

#194

Post by profquail »

drdec wrote: post #162

I think that PostgreSQL itself is great. However, the developer client tools (pgAdmin) leave something to be desired. The old pgAdmin3 was fine, if lacking bells and whistles. The new pgAdmin4 however, was not very good last time I tried it [1]. It was implemented as a client/server web application and had frequent issues. Can anyone recommend a good client for PostgreSQL? [1] - I see that there have been some new re…

HeidiSQL: https://www.heidisql.com/

Bonus — it also works for MySQL/MariaDB, MS SQL, and sqlite.

Re: PostgreSQL is the worlds’ best database

#195

Post by iruoy »

nicoburns wrote: post #164
drdec wrote: post #162

I think that PostgreSQL itself is great. However, the developer client tools (pgAdmin) leave something to be desired. The old pgAdmin3 was fine, if lacking bells and whistles. The new pgAdmin4 however, was not very good last time I tried it [1]. It was implemented as a client/server web application and had frequent issues. Can anyone recommend a good client for PostgreSQL? [1] - I see that there have been some new re…

If you're on a mac, then Postico is pretty good ( https://eggerapps.at/postico/ ). Otherwise, TablePlus is cross-platform (and supports multiple DBs) https://tableplus.com/ Agreed that PgAdmin is awful.

TablePlus is awesome on MacOS, but not so much on Windows.

I use TablePlus for quickly looking stuff up when I'm working on my MacBook, but I use DataGrip when I'm working on Linux.

Re: PostgreSQL is the worlds’ best database

#196

Post by jsmith99 »

onion2k wrote: post #7
Jonnax wrote: post #2

This is advertising of course. But if I had to select an SQL DB postgres is my only choice. Perhaps I don't know enough about databases and their differences. Anyone have some pros and cons of others? Like why would I pick MySQL, Microsoft, Oracle, Maria etc over Postgres? Apart from support that you gotta pay for.

One of Postgres's biggest pros (over other commonly used dbs in web dev) is Row Level Security. Controlling what data a user can access at the database rather than the application or as part of a query makes the application logic a lot simpler. That's a big win.

MS SQL has row level security too.

Re: PostgreSQL is the worlds’ best database

#197

Post by jwr »

DeathArrow wrote: post #93
jwr wrote: post #25

PostgreSQL is great if you: a) are OK with using SQL (this is not obvious) b) do not need a distributed database I've spent a lot of time on looking at database solutions recently, reading through Jepsen reports and thinking about software architectures. The problem with PostgreSQL is that it is essentially a single-point-of-failure solution (yes, I do know about various replication scenarios and solutions, in fact I…

So what distributed database solution have you found for your project?

There is no such thing as a "best database for everyone". I intend to migrate to FoundationDB in the main project I'm working on, but it is not necessarily the "best" option for everyone (see https://blogs.vmware.com/management/2020/03/changing-the-fou... for a good writeup).

Re: PostgreSQL is the worlds’ best database

#198

Post by throwaway_pdp09 »

pritambaral wrote: post #178
throwaway_pdp09 wrote: post #26

Earlier quoted context omitted.

> consistently underperforms in benchmarks across the board Show me mssql vs PG speed comparison on a recent industry standard benchmark. > and costs you a fortune right? Are you witless enough to think I'm unaware of the wallet-raping, labyrinthine licensing of MSSQL? > Hope the job security is worth... Since you apparently can't understand, let me spell it out for you: I've recently installed PG to start learning i…

> Show me mssql vs PG speed comparison on a recent industry standard benchmark. Does the mssql license allow for this though? Last I heard, they did have a DeWitt clause.

TPC

Re: PostgreSQL is the worlds’ best database

#199

Post by jeffdavis »

kardianos wrote: post #179

I use PostgreSQL and MS SQL Server. I love Postgres. There are some things that SQL Server does differently that I would love to see supported in Postgres: * Protocol: (a) no wire level named parameters support; everything must be by index. (b) Binary vs text is is not great, and binary protocol details is mostly "see source" (c) no support for inline cancellation: to cancel a query client can't signal on current TCP…

That's an interesting list. Can you give more context about how you would like to use these features?

Re: PostgreSQL is the worlds’ best database

#200

Post by dashwav »

manigandham wrote: post #169
drdec wrote: post #162

I think that PostgreSQL itself is great. However, the developer client tools (pgAdmin) leave something to be desired. The old pgAdmin3 was fine, if lacking bells and whistles. The new pgAdmin4 however, was not very good last time I tried it [1]. It was implemented as a client/server web application and had frequent issues. Can anyone recommend a good client for PostgreSQL? [1] - I see that there have been some new re…

DBeaver: https://dbeaver.io/ Native cross-platform and works across dozens of databases with lots of features. Another option is Jetbrains DataGrip: https://www.jetbrains.com/datagrip/

Thank you for this - my team and I have been looking for a replacement to PgAdmin for quite some time now and this fits the bill exactly. Two features I thought we were going to have to give up when moving from MySQL to PG where ERD management in-app and the ease of use of MySQL workbench.
Post reply on HN