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

Ian Dees ian.dees at gmail.com
Wed May 13 19:30:10 BST 2009


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

> On Wed, May 13, 2009 at 7:13 PM, Ian Dees <ian.dees at gmail.com> wrote:
> > On Wed, May 13, 2009 at 1:09 PM, Matt Amos <zerebubuth at gmail.com> wrote:
> >>
> >> why via triggers?
> >
> > Because the database is the only aggregation point for the data. There
> are
> > many API servers (which would be the ideal spot for creating this data
> > feed), but my initial thought was that it was quite cumbersome to try and
> > aggregate the streams from the various API servers (along with
> time-aligning
> > them) when the DB server was already doing that for you.
>
> 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.

What other features were you thinking about?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090513/81f76b5a/attachment.html>


More information about the talk mailing list