Bookmark this page:
   Re: advice needed: efficient approach to find stre...
| ujaval@gmail.co... | 07-16-2007 |
If you were Registered and logged in, you could reply and use other advanced thread options
busnet kirjoitti:
I would really suggest to switch over if possible to PostgreSQL +
PostGIS solution, or another possibility is OracleXE which is free
nowadays (it contains spatial functionality too).
Both work very well with PHP.
--
Jani Tiainen
>
> Well, I'm using mysql as the database and it spatial database parts
> lacks the distance-function, which I need most. I didn't know that
> postgresql has this extension already. I now use the serialize
> function to store and load some preprocessed (i.e. stripped) data. Its
> not a professional solution, but it works for now and does not need a
> database, which is a bit pro for local deployment. But thank you for
> the hint towards postgresql, I will keep it in mind.
> Well, I'm using mysql as the database and it spatial database parts
> lacks the distance-function, which I need most. I didn't know that
> postgresql has this extension already. I now use the serialize
> function to store and load some preprocessed (i.e. stripped) data. Its
> not a professional solution, but it works for now and does not need a
> database, which is a bit pro for local deployment. But thank you for
> the hint towards postgresql, I will keep it in mind.
I would really suggest to switch over if possible to PostgreSQL +
PostGIS solution, or another possibility is OracleXE which is free
nowadays (it contains spatial functionality too).
Both work very well with PHP.
--
Jani Tiainen
> > I am not sure why you can't use a spatial database. You don't have to
> > write one, just use the php interface to access the database.
> > Postgresql should suffice your requirements for building spatial index
> > and I have used to it with php to build google maps applications.
> > write one, just use the php interface to access the database.
> > Postgresql should suffice your requirements for building spatial index
> > and I have used to it with php to build google maps applications.
> Well, I'm using mysql as the database and it spatial database parts
> lacks the distance-function, which I need most. I didn't know that
> postgresql has this extension already. I now use the serialize
> function to store and load some preprocessed (i.e. stripped) data. Its
> not a professional solution, but it works for now and does not need a
> database, which is a bit pro for local deployment. But thank you for
> the hint towards postgresql, I will keep it in mind.
> lacks the distance-function, which I need most. I didn't know that
> postgresql has this extension already. I now use the serialize
> function to store and load some preprocessed (i.e. stripped) data. Its
> not a professional solution, but it works for now and does not need a
> database, which is a bit pro for local deployment. But thank you for
> the hint towards postgresql, I will keep it in mind.
Cool. FYI.. Postgresql has a spatial extension called PostGIS, which
will handle all sort of spatial queries.
-Ujaval
http://spatialthoughts.com
>> write one, just use the php interface to access the database.
>> Postgresql should suffice your requirements for building spatial index
>> and I have used to it with php to build google maps applications.