If you’re following me on GitHub you might have seen that I’ve been pretty busy over the last few days.  After the short discussion on the original iteration of OSMGenerator, I began work on a branch that uses separate tables linked by foreign keys to nodes/ways/relations for the storage of keys.  The idea behind this is quicker lookups based on tag searches, which is just about the only way to get data that users will find interesting out of the database.  My thanks to Frederik Ramm for bringing up the disparity in schemas between OSMGenerator and osmosis.

The branch is located here and I’m currently doing speed comparisons between it and the original 0.1 release.