Download
JsQuery is a language to query jsonb data type, introduced in PostgreSQL release 9.4. It's primary goal is to provide an additional functionality to jsonb (currently missing in PostgreSQL), such as a simple and effective way to search in nested objects and arrays, and more comparison operators with indexes support. We hope, that jsquery will be eventually a part of PostgreSQL. JsQuery is realized as an extension and is not available in the default PostgreSQL installation. It is available from GitHub under the same license as PostgreSQL and supports PostgreSQL 9.4+.
Features
- JsQuery is realized as an extension and not available in default PostgreSQL installation
- JsQuery extension contains jsquery datatype which represents whole JSON query as a single value
- Prefix expressions are expressions given in the form path
- JsQuery extension contains two operator classes (opclasses) for GIN which provide different kinds of query optimization
- JsQuery opclasses perform complex query optimization
- Optimizer evades index evaluation of less selective conditions when possible
Project Samples
Categories
JSONFollow JsQuery
nel_h2
Secure User Management, Made Simple | Frontegg
Frontegg powers modern businesses with a user management platform that’s fast to deploy and built to scale. Embed SSO, multi-tenancy, and a customer-facing admin portal using robust SDKs and APIs – no complex setup required. Designed for the Product-Led Growth era, it simplifies setup, secures your users, and frees your team to innovate. From startups to enterprises, Frontegg delivers enterprise-grade tools at zero cost to start. Kick off today.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of JsQuery!