[OSM-dev] OSM and sqlite

[Stefan de Konink]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Igor Brejc schreef:
> 
> 
> On Tue, Sep 30, 2008 at 10:56 AM, Stefan de Konink <skinkie at xs4all.nl
> <mailto:skinkie at xs4all.nl>> wrote:
> 
>     Igor Brejc schreef:
>     > Has anybody done any work on storing OSM data into a sqlite database?
> 
>     I'm personally pro another database, but what about publishing the
>     planet.xml inside <<insert your favorite binary format here>>? Just as
>     intermediate format?
> 
> I was thinking about that too. Is there such a binary format for OSM
> data? That has been used in practice, that is :)

There is no binary format. So a thing that does sql and is available on
many platforms can be a good choice. But SQLite is not smart, it doesn't
do automatic indexing, so as storage format there are far better
alternatives.

(Automatic indexing takes care of duplicate strings)


Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEAREKAAYFAkjh7+QACgkQYH1+F2Rqwn0jmgCfUswTPfEhxUFZJotNrfrirFto
+qMAn0PGhWfJ1bZYA7VlPo1aIqEO0xQc
=jR52
-----END PGP SIGNATURE-----