[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)
<joke>
Anyway, I'm a MySQL guy, not a PGSQL guy. We don't need no stinkin' integrity
checks nor foreign keys here.
</joke>
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