One comment I thought valuable after a large New Zealand Govt agency implemented a national GIS suite. This was their first install using Postgis instead of the usual MS SQL Server.
I asked how they found Postgis/Postgres as a platform. I got a very succinct reply.
"It's so easy to connect to, and sh** it's fast!"
In general, you don't need to know much more...
Brent Wood
From: "Ramamoorthi, Meenakshi" <Meenakshi.Ramamoorthi@xxxxxxxxxxx>
To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, January 16, 2019 8:42 AM
Subject: Can anyone please provide me list of customers using postgreSQL
Dear folks:
1)
Can someone please send me a link of all companies using PostgreSQL ?
2)
Both government and private companies using PostgreSQL
3)
Any security issues found earlier and the steps taken for resolution or how it was mitigated.
4)
Advantages of PostgreSQL compared to other databases like Oracle, MySQL etc.
Thanks and best regards
Meenakshi Ramamoorthi
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Sent: Tuesday, January 15, 2019 11:24 AM
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: aggregate functions are not allowed in UPDATE
Sent: Tuesday, January 15, 2019 11:24 AM
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: aggregate functions are not allowed in UPDATE
And I should better change the avg_time column from TEXT to TIMESTAMPTZ (and use TO_CHAR on it later down the road) so that I can compare my players
Regards
Alex
