This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2014

Jsquery - the jsonb query language with GIN indexing support.

Date: 2014-10-24
Time: 13:40–14:30
Room: Medici I
Level: Intermediate

PostgreSQL 9.4 has new jsonb data type, which was designed for efficient work with json data. However, its query language is very limited and supports only a few operators. In this talk we introduce jsquery - the jsonb query language, which is flexible, expandable and has GIN indexing support. Jsquery provides postgres users an ability to talk to json data in an efficient way on par with NoSQL databases. The preliminary prototype was presented at PCGon-2014 and has got a good feedback, so now we want to show to european users the new version of jsquery (with some enhancements), which is compatible with 9.4 release and can be installed as an extension. We'll also discuss current issues of jsquery and possible ways of improvements.

Speaker

Alexander Korotkov