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

Stefan de Konink stefan at konink.de
Tue Apr 28 08:26:21 BST 2009


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 ;)


Stefan




More information about the dev mailing list