I've created osm2sqlite, a programme to convert from OSM files (OpenStreetMap's XML file format) into a SQLite database. It's not very good for display OpenStreetMap data in a GIS programme. It's good if you want to muck around with raw OpenStreetMap data, in a familiar SQL environment.
I'm using git to store the code, you can get it here: http://repo.or.cz/w/osm2sqlite.git
- Checkout the code
git clone git://repo.or.cz/osm2sqlite.git .
- For this example, we'll download the OSM data from Ireland.
- Unzip the file. Currently it has to be unzipped. Support for converting bzipped files is planned.
- And finally run the script to convert the OpenStreetMap file to a database called ireland.sqlite.
./convert_osm_to_sqlite.sh -o ireland-2009-11-17.osm -d ireland.sqlite