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

Matt Amos zerebubuth at gmail.com
Tue Apr 28 11:49:07 BST 2009


On Tue, Apr 28, 2009 at 8:26 AM, 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 ;)

seriously, you should get paid for the amount you promote MonetDB ;-)

cheers,

matt




More information about the dev mailing list