[OSM-dev] Can SQLite3 handle OSM 150G data file?

marcus.wolschon at googlemail.com marcus.wolschon at googlemail.com
Tue Apr 28 13:29:10 BST 2009


On Tue, 28 Apr 2009 09:26:21 +0200, Stefan de Konink <stefan at konink.de>
wrote:
> marcus.wolschon at googlemail.com wrote:
>> On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald
>>> SQLite isn't designed for huge databases like OpenStreetMap. You could 

>>> get away with a city or small region, but more than that, you will get 

>>> the slowness that you are seeing.
>>> http://www.sqlite.org/faq.html#q19 and some other FAQs on that page.
>>> You are much better using Postgres, or even MySQL.
>> 
>> Is there ANY embedded database out there that can handle the planet?
>> Anything that does not require the (unskilled) user of a program to
>> install a local database-server first?
> 
> MonetDB can be running in embedded mode ;)

>From what I can see at
http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Embedded-Server.html#Embedded-Server
the "embedded"-mode is still a server, just for
embedded systems.
I was talking about having the database as a library
be a part of the program.
Nothing to install or to start separately.

Marcus




More information about the dev mailing list