News for hackers. Stuff that matters.
Re:Things I hate about PostgreSQL (2020) by otikik on Tuesday April 06, 2021 @04:15AM (#26709368)
I will add one minor point to this list:

The name.

To this day I am convinced that the Hazapard UpperCASE usage is what has granted us:

- A database called PostgreSQL

- A library called libpostgres

- An app folder called postgres

- An executable called psql

- A host of client libraries which chose to call themselves Pg or a variation.

Re:Things I hate about PostgreSQL (2020) by SigmundA on Tuesday April 06, 2021 @08:06AM (#26710812)
Lets not forget the column casing issue, you either get columns to match your apps casing and have to quote them everywhere or live with them being lower cased automatically. https://dev.to/lefebvre/dont-get-bit-by-postgresql-case-sens...
Re:Things I hate about PostgreSQL (2020) by ironmagma on Tuesday April 06, 2021 @04:53AM (#26709612)
Don’t forget “libpq”
Re:Things I hate about PostgreSQL (2020) by cpa on Tuesday April 06, 2021 @05:10AM (#26709723)
Funfact: PQ is short for toilet paper in French So libpq always cracks me up. But then again there's a theorem prover called Coq (which is indeed pronounced as you imagine, it means rooster) and it's been named by French researchers at INRIA!
Re:Things I hate about PostgreSQL (2020) by zdkl on Tuesday April 06, 2021 @05:13AM (#26709753)
libcaca, also french: http://caca.zoy.org/
Re:Things I hate about PostgreSQL (2020) by gonzus on Tuesday April 06, 2021 @12:35PM (#26713984)
Ok, let's talk about this... pico, the editor and SI prefix, means "dick" in at least some Spanish-speaking countries... Source of endless nerd jokes.
Re:Things I hate about PostgreSQL (2020) by mst on Tuesday April 06, 2021 @04:54PM (#26717265)
Not to mention the (un)surprisingly low sales in spanish speaking countries of the car known as the Vauxhall Nova ...
Re:Things I hate about PostgreSQL (2020) by brandmeyer on Tuesday April 06, 2021 @12:16PM (#26713735)
As an American, I feel like I have to deliberately mis-pronounce 'coq' the theorem prover like 'coke' the soda.
Re:Things I hate about PostgreSQL (2020) by ironmagma on Tuesday April 06, 2021 @03:36PM (#26716396)
Same. It really doesn't help that their logo is skin-colored and the shape that it is...
Re:Things I hate about PostgreSQL (2020) by pdw on Tuesday April 06, 2021 @06:28AM (#26710211)
PostgreSQL used to be called Postgres. They renamed it when they added SQL support.
Re:Things I hate about PostgreSQL (2020) by icedchai on Tuesday April 06, 2021 @10:41AM (#26712352)
This is true. Many people get confused by the name. I've met several developers who refer to it as "Postgray" or some variation.
Re:Things I hate about PostgreSQL (2020) by wosc on Tuesday April 06, 2021 @02:54PM (#26715832)
Recently I saw "post grayskull" on twitter, that's now my favourite. ;)
Re:Things I hate about PostgreSQL (2020) by dhritzkiv on Tuesday April 06, 2021 @12:41PM (#26714069)
I've never heard that before, but I kind of like it. Sounds a bit nicer and is easier to say than 'Post Gress'. I'm still not sure how to pronounce the proper name, when it has 'SQL' as part of it. I think it's 'Post Gress Queue Ell', but it feels… bad.
Re:Things I hate about PostgreSQL (2020) by rattray on Tuesday April 06, 2021 @02:56PM (#26715861)
Renaming would be even worse!
Re:Things I hate about PostgreSQL (2020) by skrebbel on Tuesday April 06, 2021 @03:27PM (#26716267)
Seems to me that they could safely rename to Postgres without much downside.
Re:Things I hate about PostgreSQL (2020) by rattray on Tuesday April 06, 2021 @03:36PM (#26716391)
Among other potential issues, this would make it much harder to search for information related to the database. Starting out, it'd always make sense to google for eg "postgres ilike", but for new features you'd have to search for eg "NewNameSQL kindalike" (assuming a new ILIKE replacement called KINDALIKE comes along in pg15 aka newname3).

Even years in to the rename, newcomers to NewNameSQL would need to be told that it used to be called Postgres and that they should look for things related to that too.

Tools and code that refer to Postgres would all have to change their names, including those developed internally, open-source, closed-source, and no-longer-maintained. Not all would, and some would change the name and functionality at the same time.

It'd be chaos.

Re:Things I hate about PostgreSQL (2020) by skrebbel on Wednesday April 07, 2021 @07:54AM (#26723513)
I meant change the name from PostgreSQL to Postgres.
Re:Things I hate about PostgreSQL (2020) by rattray on Wednesday April 07, 2021 @08:55AM (#26724159)
Ah! So sorry for misunderstanding. Yes that sounds like a straightforward, good idea!