[OSM-talk] Heresy - pure discussion

[John Whelan]

Thank you Hartmut,

my expertise is not in GIS databases so this is helpful to know.  My 
experience is much more to do with straight SQL databases doing none GIS 
work on a variety of platforms.

Cheerio John

Hartmut Holzgraefe wrote on 2020-07-24 18:49:
> On 25.07.20 00:16, Alexandre Oliveira wrote:
>>> Having said that the main advantage of SQL is
>>> it is a standard so you should be able to connect practically 
>>> anything to
>>> it.
>> That's not entirely true. SQL is a language but every database
>> implements its own dialect, i.e., some query keywords implemented in
>> MSSQL might not be available in MySQL/MariaDB and vice-versa.
>>
>>
>
> SQL is a "standard" only in so far as developers are somewhat
> interchangeable between products.
>
> There is nothing that prevents RDBMS implementations from adding
> features on top of the standard, and most of the standard features
> are optional anyway.
>
> E.g. the actual ISO SQL standard for stored procedures is only really 
> implemented by IBM/DB2, MySQL and MariaDB, while all other RDBMS 
> products implement their own procedure languages (and I can't even
> blame them, as the ISO SQL standard syntax feels as if it got
> stuck in the old BASIC days).
>
> The key question though would be: is MS SQL Server GIS support
> on par with PostGIS?
>
> My impression so far was that it provides just a little bit more
> than what the OGC 1.1 standard requires.
>
> That would put it in the same league as MySQL and MariaDB, maybe
> slightly ahead, but very far below what PostGIS provides.
>
> (Disclaimer: I'm working for MariaDB as a support engineer, and
> have been working for MySQL before, so I may a little bit biased.
> But even I would always recommend the PostgreSQL / PostGIS combo
> over MariaDB for all but the most basic GIS applications)
>

-- 
Sent from Postbox <https://www.postbox-inc.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20200724/09370050/attachment.htm>