- Notifications
You must be signed in to change notification settings - Fork49
JsQuery – json query language with GIN indexing support
License
NotificationsYou must be signed in to change notification settings
postgrespro/jsquery
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
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;
Requirements:
- PostgreSQL >= 9.4
git clone https://github.com/akorotkov/jsquery.git$SOURCE_DIR/contribcd$SOURCE_DIR/contrib/jsquery&& make&& make install&& make installcheck
docker run --name=myjsquery -p 5432:5555 -i -t jsquery/jsquerypsql -p 5555- TODO1
- TODO2
You can contribute by:
- stars
- issues
- documentation
- pull requests
MIT?
About
JsQuery – json query language with GIN indexing support
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
No packages published
Uh oh!
There was an error while loading.Please reload this page.
Contributors13
Uh oh!
There was an error while loading.Please reload this page.