5 ms·
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 P
by otikik 6y ago
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.
- ironmagma 6y agoDon’t forget “libpq”
- cpa 6y agoFunfact: 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!
- zdkl 6y agolibcaca, also french: http://caca.zoy.org/ http://caca.zoy.org/
- brandmeyer 6y agoAs an American, I feel like I have to deliberately mis-pronounce 'coq' the theorem prover like 'coke' the soda.
- ironmagma 6y agoSame. It really doesn't help that their logo is skin-colored and the shape that it is...
- pdw 6y agoPostgreSQL used to be called Postgres. They renamed it when they added SQL support.
- SigmundA 6y agoLets 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-sensitivity--457i https://dev.to/lefebvre/dont-get-bit-by-postgresql-case-sens...
- icedchai 6y agoThis is true. Many people get confused by the name. I've met several developers who refer to it as "Postgray" or some variation.
- dhritzkiv 6y agoI'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.
- wosc 6y agoRecently I saw "post grayskull" on twitter, that's now my favourite. ;)
- rattray 6y agoRenaming would be even worse!
- skrebbel 6y agoSeems to me that they could safely rename to Postgres without much downside.
- rattray 6y agoAmong 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.