On 01.11.2007, at 11:22, RobRoyAus wrote:
> > Hi guys, > > I'm planning a very geo-heavy website and would dearly love to use a > database with built-in GIS functions. PostgreSQL with PostGIS (http:// > postgis.refractions.net/) looks ideal although the GIS extensions for > MySQL would do at a push. My requirements are simple - I mainly want > to search for points inside polygons and within a nominated distance > of points or polylines. > PostGIS is definately the more mature product, though MySQL is catching [1] up a little recently. > Unfortunately there doesn't seem to be any support for either > extension in Propel or Doctrine (and hence Symfony). Is this correct? > Have I missed something? > I doubt any abstraction layers so far covers GIS. Doctrine at least supports passing through any DBMS specific function. Both will allow you to drop back to using the underlying DBAL though, which is probably what you want to do. > Does anyone have any advice for me? Is it worth thinking about > extending Propel or Doctrine to include support for the new data types > (particularly with my noob Symfony skills) or should I roll my own > functions and put them into a plugin? I would rather not have to do > this for performance reasons (and laziness) I would go with just starting to write some queries and then see what you can generalize into a helper and then consider working with either project to see if its can be made decently cross DBMS. regards, Lukas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
