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

211–220 of 365 posts

Re: PostgreSQL is the worlds’ best database

#211

Post by egeozcan »

iruoy wrote: post #195
nicoburns wrote: post #164

Earlier quoted context omitted.

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.

I was on the fence about giving TablePlus a go. Why isn't it awesome on Windows? I'm very interested.

Re: PostgreSQL is the worlds’ best database

#212

Post by [deleted] »

INTPenis wrote: post #29

My first job in IT, I was 18, it was the early 2000s. I was a nerd but in professional IT I was essentially a blank slate. I lucked up and ended up with a real hacker for a boss. As early as 2001-2002 he had saved entire businesses by migrating them from mysql to postgres. He was a BSD guy and a postgres guy. He made me into a fanboy of both those technologies. So out of sheer luck I've preferred Postgres for over 15…

[deleted]

Re: PostgreSQL is the worlds’ best database

#213

Post by KristiMKE »

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…

Check out ScaleGrid's BYOC plans. They are similar to RDS, but give you the option to host in your own AWS or Azure account. ScaleGrid supports MongoDB, Redis, MySQL and Postgres. https://scalegrid.io/pricing.html#section_pricing_byoc

Re: PostgreSQL is the worlds’ best database

#214

Post by davidspiess »

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…

I prefer using Adminer or Azure Data Studio (with pg extension)

Re: PostgreSQL is the worlds’ best database

#215

Post by benbristow »

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…

Azure Data Studio (don't be put off by Azure, it runs locally) has a decent extension for PostgeSQL.

https://github.com/microsoft/azuredatastudio#azure-data-stud...

Re: PostgreSQL is the worlds’ best database

#216

Post by electrotype »

manigandham wrote: post #205
egeozcan wrote: post #201

Earlier quoted context omitted.

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.

But this doesn't deal with DELETEs of a true MERGE statement

Re: PostgreSQL is the worlds’ best database

#217

Post by jeffdavis »

unnouinceput wrote: post #72

For most of the projects where the DB really mattered, throughout my 10+ freelancer carrier, it came down to one thing that client really cared about. Performance. Nothing else mattered, not license price, not whistles and bells, not hype. My clients wanted to have data in front of their eyes the same second when they clicked the button. And when you have a table with 100 million rows in it, and an application is not…

That might be selection bias: those who look for you are mostly concerned about performance. And performance is usually not "solved" -- it's often a treadmill where hardware and software performance is trying to outrun the data growth -- so people who need performance are constantly coming back for more (usually with a pile of cash).

A lot of users case mostly about accessibility, simplicity, integration with existing experience/tools (e.g. JSON), managability, ecosystem, etc. Those users might be happy from the start; or if they aren't happy, they complain for a while until their problem is solved, and then go silent.

Re: PostgreSQL is the worlds’ best database

#218

Post by steve-chavez »

chatmasta wrote: post #120
remus wrote: post #113

Earlier quoted context omitted.

It also means you need a per-user database connection which isn't feasible in many applications as the recommended number of concurrent connections is typically quite low.

Not necessarily. You can SET ROLE at beginning of transaction and DISCARD afterward. This is what postgraphile and postgrest do, for example.

postgrest actually does a `SET LOCAL ROLE`(transaction scoped, so no need to DISCARD), but yes, that's the gist of it.

Re: PostgreSQL is the worlds’ best database

#219

Post by SigmundA »

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…

Good list.

Also true indexed organized table aka real clustered indexes.

Oh and real cross connection query plan caching, prepared statements are only for the connection and must be explicitly used. No need to use prepared statements in MSSQL since the 90's

Re: PostgreSQL is the worlds’ best database

#220

Post by bernawil »

onion2k wrote: post #155
BiteCode_dev wrote: post #62

Earlier quoted context omitted.

But that also means that: - the code is not reusable outside of a database setting. So not cacheable. - the code is not reusable accross different storage layers. So not portable. - the code may needs updating if the schema change, you can't abstract that - changing the logic means a db migration - testing the code requires a DB - tooling support to check that code si limited to SQL tooling, which is very weak, espec…

the code is not reusable accross different storage layers. So not portable. In my 23-and-a-bit years of web development I've literally never changed the database engine on a project. Maybe that happens on other people's projects, but it's not something I consider important or even useful really. The notion that you can swap out your database for a different one without changing the application code to take advantage…

  I've literally never changed the database engine on a project
And some of us do it several times a day because we deploy to prod with Postgres but run testing and CI with SQLite.
Post reply on HN