[OSM-dev] OSM and sqlite

[Jochen Topf]

On Mon, Sep 29, 2008 at 08:25:11PM +0200, Igor Brejc wrote:
> Has anybody done any work on storing OSM data into a sqlite database? I 
> mean large quantities of data (even planet-size)? I looked through our 
> wiki and googled a little but couldn't find any information about it. 
> I'm wondering if it is feasible at all and what kind of performance it 
> would offer (compared to "real" DBMS's).

I have done some Ruby scripting. See:
http://osmlib.rubyforge.org/osmlib-sqlite/index.html

But that was only a proof-of-concept. Its far too slow to use on large
data sets.

Jochen
-- 
Jochen Topf  jochen at remote.org  http://www.remote.org/jochen/  +49-721-388298