[georss] Database Schema

[Raj Singh]

No one has an opinion on this one? I think most people use PostGIS  
since its support for geometry is older, but the general principle is  
the same. I wouldn't store the GeoRSS GML text (XML) in the database.  
Instead, you should use the native spatial support in the database  
(http://www.mysql.org/doc/refman/5.1/en/spatial-extensions.html) to  
store the real coordinates. That allows you to do spatial indexing  
and queries. Then generate XML on the fly as needed.
---
Raj


On Jun 26, 2007, at 3:04 PM, rico.hauke at daimlerchrysler.com wrote:

> Hi list,
>
> I need to store GeoRSS GML encoded data in a MySQL database, so I  
> was wondering if there already exists a database schema (tables,  
> keys and stuff) or if anyone has done this before?
>
> Thanks,
> Rico