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

Ævar Arnfjörð Bjarmason avarab at gmail.com
Tue Apr 28 15:30:33 BST 2009


On Tue, Apr 28, 2009 at 12:29 PM,  <marcus.wolschon at googlemail.com> wrote:
> 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.

You could always make your program embed/start the database server
regardless of whether it's a library or a server. It would just mean
e.g. shipping the postgresql binaries with your program and doing some
magic in your program that ensures that the server is started when the
program is.




More information about the dev mailing list