[Geocoding] Local Mirror of OSM Data...

[Tom Hughes]

On 23/10/09 18:05, Anthony wrote:

> By the way, I highly disagree with that statement.  Maybe it's true if
> you're using MyISAM, but with any modern database with views, and
> triggers, and stored procedures, your core schema should be
> independent of implementation.

Well in theory maybe, just like in theory everybody would have their 
databases fully normalised.

In the real world we don't all have infinite CPU time and I/O bandwidth 
so sometimes we have to do some pre-computation to get the data in a 
form where the queries we want to use can be efficiently processed.

In the case of OSM data for example it may often be advantageous to 
create proper PostGIS geometries for objects so that spatial queries can 
be efficiently resolved. I'm not sure it would be possible to write a 
view to do that even if you wanted to - if you could it would be pretty 
horrible and mind-blowing inefficient.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/