[postgis] Unrelated question

[Paul Ramsey]

Hi Kenneth,
I suppose that would end up as myGIS? :) Unfortunately (or fortunately),
postGIS is tied right into the internals of pgsql: there is no leverage
to be gained against mysql using the code (or understanding) our postgis
efforts have generated. Along the lines of my "Feature Server" message
of last night, a clean and db neutral API could frontend both postgis
and a different mygis implementation. 

Our early tests of using pgsql to do opengis yielded the following
thoughts which may or may not apply to mysql:
- the "fully-relational" setup of SF had a lot of input/output overhead
putting things together and taking them apart
- using pgsql with the features in BLOBs seemed cool, but in comparison
with using the basic geometric types to store the same features was 10
TIMES slower for read access
- the built-in geometrics were good, but were limited to the 8K page
size, did not support aggregation, and did not have explicit holes for
the polygons. in the end we decided it would be better to write our own
than to try and hack around the limitations of the built-in types.

So what would a myGIS implementation look like? I have no idea, I know
too little about the strength and weeknesses of mysql. If the blob
access is fast enough, perhaps a system which stuffs the geometries into
tables as WKB would work. I assume better people than I have chewed this
over :)

TTYL,
Paul

Kenneth Melero wrote:
> 
> Is there any desire to support MySQL as well as PostgreSQL?
> Great work on PostGIS already!  :-)
> 
> Thanks!
> - Ken
> 
> --
> Kenneth Melero                          Imagelinks, Inc.
> Director of Technology                  4450 W. Eau Gallie Blvd.
>                                         Melbourne, FL  32934
> 
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
> 
> 
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/