datasette-jq
Datasette plugin that adds custom SQL functions for executing jq expressions against JSON values.
Install this plugin in the same environment as Datasette to enable the jq() SQL function.
Usage:
select jq(
column_with_json,
"{top_3: .classifiers[:3], v: .version}"
)
See the jq manual for full details of supported expression syntax.
Interactive demo
You can try this plugin out at datasette-jq-demo.datasette.io
Sample query:
select package, "https://pypi.org/project/" || package || "/" as url,
jq(info, "{summary: .info.summary, author: .info.author, versions: .releases|keys|reverse}")
from packages
Try this query out in the interactive demo.
1 maintainer
Metadata
1 maintainer
Release files for datasette-jq 0.2.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| datasette_jq-0.2.1-py3-none-any.whl | Python 3 | none | any | Details for datasette_jq-0.2.1-py3-none-any.whl |
Release files / datasette_jq-0.2.1-py3-none-any.whl
| Download URL | datasette_jq-0.2.1-py3-none-any.whl |
|---|---|
| Size | 6.6 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
d67c45bfa912ae030aaeb331e48b7254756c00f6058fb403ce93860e8d2a11bb
|
|
BLAKE2b-256 checksum How to use checksums |
6e4ffac9eb900ac6b33d24eebf9929c1fe212b27e245cb49b15a48c7e643110c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.45.0 CPython/3.6.10
|
Security for datasette-jq 0.2.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
