PostgreSQL 14 • Hacker News Board

Re: PostgreSQL 14

#291

Post by darksaints » Sun, Oct 03, 2021, 1:04 AM UTC

jkatz05 wrote: post #25

maxpert wrote: post #4

I converted from MySQL (before whole MariaDB and fork), and I've been happier with every new version. My biggest moment of joy was JSONB and it keeps getting better. Can we please make the connections lighter so that I don't have to use stuff like pgbouncer in the middle? I would love to see that in future versions.

I'd be curious to see if the concurrency improvements in PostgreSQL 14 help with increasing the threshold for when you need to introduce a connection pooler.

Check out the Azure team's benchmarks. Pretty damn impressive.

https://techcommunity.microsoft.com/t5/azure-database-for-po...

Re: PostgreSQL 14

#292

Post by coded » Sun, Oct 03, 2021, 5:21 PM UTC

oauea wrote: post #290

coded wrote: post #288

Earlier quoted context omitted.

It looks like gcp supports logical replication now: https://cloud.google.com/blog/products/databases/you-can-now...

The big question is: Can you enter arbitrary IP addresses, or do you have to replicate to another GCP instance? Azure does the latter.

Yes you can enter an arbitrary IP: https://cloud.google.com/sql/docs/postgres/replication/confi...

Re: PostgreSQL 14

#293

Post by kevinob11 » Tue, Oct 05, 2021, 6:46 PM UTC

bfelbo wrote: post #248

kevinob11 wrote: post #90

Earlier quoted context omitted.

TablePlus is the only thing I've used cross-platform that is even close to Postico. Postico is amazing.

Interesting. I’m currently using Postico on Mac, but considering TablePlus. Why do you find Postico superior?

Sorry for the late response, missed this somehow. I'm realizing as I try to write this that it is a bunch of small things, and maybe it boils down to having used it a long time or it being my first non-garbage (SSMS, PGAdmin) UX db tool. The autocomplete seems to work exactly as I'm expecting, the filtering seems to work a little better than TablePlus. Copying and pasting is a bit more consistent (I do this a lot while dev'ing). The whole UI is lightning fast and always stays responsive.

That all being said, TablePlus is 80 - 90% of that and the fact that it also works with multiple databases is huge. I also love the vertical tabs for multiple connections, editor sidebar pane for single records and tabbed queries vs a single query pane.

Both are fantastic, but if I was postgres only I'd probably stick with postico. As-is I just paid for both.