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

[Stefan de Konink]

Kelly Jones wrote:
> I've seen many posts saying that SQLite2 can't handle OpenStreetMap's
> large planet.osm data file:
> 
> http://planet.openstreetmap.org/planet-090421.osm.bz2
> 
> which is 5.4G bzip2 compressed, about 150G uncompressed.
> 
> Can SQLite3 handle this? Has anyone tried?
> 
> I tried to do this myself, but I'm on a slow machine and it's taking
> too long (several days so far). If someone's done this, can I get a copy?

MonetDB compresses the complete planet to 29GB. That should give an 
indication what it should be 'at least'.


Stefan