Repository files navigation

Jsquery is PostgreSQL extension,which provides advanced query language for jsonb documents.

Features:

• recursive structure of query
• search in array
• rich set of comparison operators
• types support
• schema support (constraints on keys, values)
• indexes support
• hinting support

Jsquery implemented as datatypejsquery and operator@@.

Examples:

# - any element array

SELECT'{"a": {"b": [1,2,3]}}'::jsonb @@'a.b.# = 2';

% - any key

SELECT'{"a": {"b": [1,2,3]}}'::jsonb @@'%.b.# = 2';

* - anything

SELECT'{"a": {"b": [1,2,3]}}'::jsonb @@'*.# = 2';

$ - current element

select'{"a": {"b": [1,2,3]}}'::jsonb @@'a.b.# ($ = 2 OR $ < 3)';

Use "double quotes" for key !

select'a1."12222" < 111'::jsquery;

• Getting Started
• Syntax
• Operators
• Indexes
• Optimizer

Requirements:

• PostgreSQL >= 9.4

git clone https://github.com/akorotkov/jsquery.git$SOURCE_DIR/contribcd$SOURCE_DIR/contrib/jsquery&& make&& make install&& make installcheck# or not from pg sourcesgit clone https://github.com/akorotkov/jsquery.gitcd jsquery&& make USE_PGXS=1&& make install USE_PGXS=1

TODO

• Implement jsquery as extension of SQL syntax

You can contribute by:

• stars
• issues
• documentation
• pull requests

• Oleg Bartunov
• Teodor Sigaev
• Alexand Korotkov

Development is sponsored by [Wargaming.net]

GPL