[OSM-talk] Live Data - all new Data in OSM

[Ian Dees]

On Wed, May 13, 2009 at 1:33 PM, Matt Amos <zerebubuth at gmail.com> wrote:

> On Wed, May 13, 2009 at 7:30 PM, Ian Dees <ian.dees at gmail.com> wrote:
> > On Wed, May 13, 2009 at 1:27 PM, Matt Amos <zerebubuth at gmail.com> wrote:
> >> sorry, i wasn't clear in my question: why triggers in particular,
> >> rather than one of the many other features that the DB provides for
> >> doing this?
> >
> > Mostly because it would allow us to use the same XML format that
> everybody
> > already knows how to parse and because it's what I've worked with in my
> > limited PostgreSQL experience.
>
> why would it allow us to use the XML format? nothing in XML ever goes
> near the database.
>

I meant that it would trigger some external executable that would build up
the XML, not that the database would do it.


> > What other features were you thinking about?
>
> i was looking at snapshots and transaction IDs to isolate the updated
> rows in the history tables.


I yield to your judgment on that. I haven't given myself enough time to
explore abusing the database app for such a thing.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090513/b2aae919/attachment.html>