[mapserver-dev] MySQL or still PostgreSQL/PostGIS for MapServer?

[Steve Lime]

PostgreSQL with PostGIS is several generations old with solid analytical support based on JTS/Geos. Plus
there are far more client options for the GIS support. The MySQL GIS 5.1 looks to be first generation
with support from one individual. I'd favor "tried and true" in a production environment. That's said I've
not putzed with MySQL GIS 5.1 so I really don't know how it performs...

Steve

>>> On 4/23/2008 at 6:21 PM, in message
<25bc040b0804231621g5b9f5beel8614b1992802b586 at mail.gmail.com>, "Stefan Keller"
<sfkeller at gmail.com> wrote:
> I have to make a decision between MySQL and PostgreSQL which have to store
> POIs and let perform mostly - but not only - proximity queries (point(s) in
> polygon).
> 
> Let me ask it this way: Is there anyone who can report about MySQL (version
> 5.1 GIS?) and/or give reasons why - or why *not* yet - to use MySQL in a
> productive linux environment together with GeoServer?
> Regards,
> Stefan