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

Kelly Jones kelly.terry.jones at gmail.com
Tue Apr 28 00:16:57 BST 2009

I've seen many posts saying that SQLite2 can't handle OpenStreetMap's
large planet.osm data file:


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?

We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

More information about the dev mailing list