Hi all - http://github.com/tlaurenzo/pgjson
I'm a long-time postgres user but have never developed any extensions for it. I had some time over the past week and decided to tackle a project I've had on my list for a while: adding robust JSON capabilities to the database server. This is the first step in a bigger thought that I've been toying with for a while. Its not done yet, but it builds and works with some examples (see the Github readme). This isn't just an alias for a text type with some validation. The internal representation is actually a superset of BSON (http://bsonspec.org/) as defined for MongoDB. I've architected it so that it should play naturally with the postgres type system, but there are still some cast functions that need to be implemented. Anyway, feedback is appreciated - good, bad or otherwise. Thanks. Terry
