[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