zson
ZSON is a PostgreSQL extension for transparent JSONB compression (by postgrespro)
jsquery
JsQuery – json query language with GIN indexing support (by postgrespro)
| zson | jsquery | |
|---|---|---|
| 1 | 3 | |
| 527 | 695 | |
| 0.2% | 0.4% | |
| 3.0 | 3.9 | |
| about 1 year ago | 2 months ago | |
| C | C | |
| MIT License | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
zson
Posts with mentions or reviews of zson.
We have used some of these posts to build our list of alternatives
and similar projects.
-
JSONB and storage
Have you considered ZSON? It requires you to compile a dictionary based on sample data - but given you're expecting most of your data to fit one of two variations this could be quite space efficient.
jsquery
Posts with mentions or reviews of jsquery.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-10-31.
- jsquery: a PostgreSQL extension for searching nested jsonb objects and arrays
- Jsquery: A PostgreSQL extension for searching nested jsonb objects and arrays
-
Show HN: MistQL, a mini-language for querying JSON-like structures
And jsquery, an extension for searching nested jsonb objects/arrays in postgres.
https://github.com/postgrespro/jsquery
What are some alternatives?
When comparing zson and jsquery you can also consider the following projects:
bg_mon - Background worker for monitoring PostgreSQL
gravity - Gravity Programming Language
ultrajson - Ultra fast JSON decoder and encoder written in C with Python bindings
gojsonq - A simple Go package to Query over JSON/YAML/XML/CSV Data
query - Query engine.
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
cJSON - Ultralightweight JSON parser in ANSI C
tbox - 🎁 A glib-like multi-platform c library
Oj - Optimized JSON