Re: [postgis-users] PostgreSQL HStore and PostGIS

2012-10-26 Thread Ricardo Bayley
Blair, If I understood correctly you dont intend to store geometries in HStore but in the standard geometry PostGIS enabled column. Storing key/value pairs in hstore should not bring any issues. You can also index such hstore field for quick searches. In order to properly get / set data in

Re: [postgis-users] PostgreSQL HStore and PostGIS

2012-10-26 Thread Mike Toews
On 26 October 2012 12:26, Blair Deaver blairdea...@gmail.com wrote: Can anyone comment on successful or unsuccessful attempts to implement such a technology approach integrating PostGIS with HStore? Here are some links of interest that pair up PostGIS + HStore:

[postgis-users] PostgreSQL HStore and PostGIS

2012-10-25 Thread Blair Deaver
Hello, I have a need to design and develop an application which handles a wide variety of possible variations for a database schema. I am looking into a number of options including popular NoSQL databases. I do keep coming back to PostgreSQL and PostGIS since I need to deal with geometries in a

Re: [postgis-users] PostgreSQL HStore and PostGIS

2012-10-25 Thread Stephen Frost
Blair, * Blair Deaver (blairdea...@gmail.com) wrote: With that said, I have been looking into the new capabilities available with PostgreSQL HStore Uhm.. hstore isn't exactly new. It's been around since something like 8.0.. It is amusing how people are just now coming to see. :) - Can