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

201–210 of 365 posts

Re: PostgreSQL is the worlds’ best database

#201

Post by egeozcan »

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…

I'd love to see the MERGE statement from MSSQL in other databases. Wonderful tool for integrations.

Re: PostgreSQL is the worlds’ best database

#202

Post by jwr »

BozeWolf wrote: post #49
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 do you suggest then? Do you really care that much about the language? Shouldn't you care more about your data? If you are not OK with SQL there are abstractions available.

> Do you really care that much about the language? Shouldn't you care more about your data? If you are not OK with SQL there are abstractions available.

I do care about SQL being a text-based protocol with in-band commands, bringing lots of functionality that I never need (I do not use the fancy query features for exploratory analysis, I have applications with very specific data access patterns).

For my needs, I do not need a "query language" at all, just index lookups. And I would much rather not have to worry about escaping my data, because I have to squeeze everything into a simple text pipe.

Re: PostgreSQL is the worlds’ best database

#203

Post by kthejoker2 »

_kyran wrote: post #171

While we're all here talking about databases I've got a question for the DBA/well versed software engineers. What database or database design strategies to be used for an analytics dashboard that can be queries real-time similar to Google Analytics? The first real scaling issue I've come across (as a junior dev working on a side project) is a table with 38 million rows and rapidly growing. Short of just adding indexe…

You want an OLAP database, something like Clickhouse.

Re: PostgreSQL is the worlds’ best database

#205

Post by manigandham »

egeozcan wrote: post #201
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…

I'd love to see the MERGE statement from MSSQL in other databases. Wonderful tool for integrations.

Postgres has UPSERT (INSERT INTO ... ON CONFLICT DO ... )

I wish MSSQL had this.

Re: PostgreSQL is the worlds’ best database

#206

Post by subliminalpanda »

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 willing to pay, worth checking out Aqua Data Studo (https://www.aquafold.com/aquadatastudio), otherwise DataGrip is also fantastic.

Re: PostgreSQL is the worlds’ best database

#207

Post by egeozcan »

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/

I tried DataGrip many times but kept coming back to DBeaver. It's just easier IMHO.

Re: PostgreSQL is the worlds’ best database

#208

Post by ptrwis »

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…

pgAdmin4 is not that bad, I'm using it every day

Re: PostgreSQL is the worlds’ best database

#209

Post by jfkebwjsbx »

ansible wrote: post #180
KptMarchewa wrote: post #165

Earlier quoted context omitted.

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

Rust is more complicated than some languages with GC. However, if you are writing some code with multi-threading (who isn't these days), then you may eventually want the help Rust gives you there as far as correctness goes.

Multithreading is only needed in very few fields. Multiprocessing is way easier and works fine for most. And the majority of programmers still only need to write serial code.

Re: PostgreSQL is the worlds’ best database

#210

Post by eyelidlessness »

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.

I use Postico and agree it's pretty great overall. There's some odd behavior in the SQL editor that sometimes bites me when I'm pasting from my code editor (VSCode), where whitespace sometimes picks up some kind of invisible character or something that makes the query invalid. I have no idea how to reproduce it but it can really break my flow when I hit it. Other than that I've been pretty pleased with it.

If I didn't already have a Postico license I'd definitely be looking at TablePlus.

Post reply on HN