[OSM-dev] Rantings about API 0.6

Iván Sánchez Ortega ivan at sanchezortega.es
Wed Feb 11 00:41:17 GMT 2009

El Miércoles, 11 de Febrero de 2009, Frederik Ramm escribió:
> Hi,
> Iván Sánchez Ortega wrote:
> > I just finished coding a bulk importer which interfaces directly to the
> > MySQL DB instead of interfacing to the API.
> Well then I say let's just politely ask TomH to open up the MySQL TCP
> port for public access and create user accounts for us all, and off we
> go with factor 13 speed. I'm sure everyone will be pleased ;-)

You tell the french guys and their couple million buildings ;-)

> Jokes aside, does your bulk importer also implement populating the
> history tables, making sure that every node referenced by a way (and
> every node/way/relation referenced by a relation) actually exists, and
> all these totally useless integrity constraints?

I'm importing brand new data, so populating the history tables is no big deal.

On second thought, I haven't implemented integrity checks yet - but they would 
be only neccesary if a new way would reference an existing node, not a 
placeholder ID. (Yes, I'm trusting the optimistic locking so I'm supposing 
that the data that I just commited to the DB didn't get deleted so my 
placeholder IDs don't get screwed around - or I could just prepare a 
humongous transaction to make sure the diff upload is kind of atomic)

Anyway, I'm a MySQL guy, not a PGSQL guy. We don't need no stinkin' integrity 
checks nor foreign keys here.

If I have time to code the next few months, this is gonna get fun... :-)

Iván Sánchez Ortega <ivan at sanchezortega.es>

Justifica tus limitaciones, y ciertamente las tendrás.- Richard Basch.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20090211/3312ff40/attachment.pgp>

More information about the dev mailing list