I've created an SQLite database containing the latest data-dump. It can be found at http://dl.getdropbox.com/u/1822417/so.7z I'd appreciate any input on features you'd like to see or changes in the existing schema. I'm not very experienced with databases so help with what to change or add would be appreciated. I'm planning on adding a tag table, as well as indexes, but not quite sure which fields would be best to index. When I'm happy with the database I'll find a more permanent place to host it and release the code used to create it.
Cool, thanks a lot.
I'd say let people create the indexes themselves. That saves you bandwidth.
People could then create indexes as they want—probably at least on all the keys (primary and foreign), i.e. anything that ends in
Indexes are cheap, because all they take is disk space. Of course it takes a while to create them, but after that, there's no need to watch for index update performance, because people are (probably) only going to use the data dump as read-only.
Here are the queries to create the indexes for everyone to copy and paste as they need:
Making this wiki; feel free to add for other tables.