demo

Custom SQL query returning 6 rows (show)

packageurljq(info, "{summary: .info.summary, author: .info.author, versions: .releases|keys|reverse}")
datasette-jq https://pypi.org/project/datasette-jq/
{
    "summary": "Datasette plugin that adds custom SQL functions for executing jq expressions against JSON values",
    "author": "Simon Willison",
    "versions": [
        "0.1"
    ]
}
datasette-cluster-map https://pypi.org/project/datasette-cluster-map/
{
    "summary": "Datasette plugin that shows a cluster map for any data with latitude/longitude columns",
    "author": "Simon Willison",
    "versions": [
        "0.6",
        "0.5",
        "0.4",
        "0.3",
        "0.2",
        "0.1"
    ]
}
datasette-vega https://pypi.org/project/datasette-vega/
{
    "summary": "A Datasette plugin that provides tools for generating charts using Vega",
    "author": "Simon Willison",
    "versions": [
        "0.6.2",
        "0.6.1",
        "0.6",
        "0.5.1",
        "0.5",
        "0.4.1",
        "0.4",
        "0.3",
        "0.2",
        "0.1"
    ]
}
datasette-jellyfish https://pypi.org/project/datasette-jellyfish/
{
    "summary": "Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish",
    "author": "Simon Willison",
    "versions": [
        "0.3",
        "0.2"
    ]
}
datasette-pretty-json https://pypi.org/project/datasette-pretty-json/
{
    "summary": "Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays",
    "author": "Simon Willison",
    "versions": [
        "0.2",
        "0.0.1"
    ]
}
datasette-json-html https://pypi.org/project/datasette-json-html/
{
    "summary": "Datasette plugin for rendering HTML based on JSON values",
    "author": "Simon Willison",
    "versions": [
        "0.4.1",
        "0.4.0",
        "0.3.4",
        "0.3.2",
        "0.3.1",
        "0.3",
        "0.2",
        "0.1"
    ]
}
Powered by Datasette · Query took 34.53ms · About: https://github.com/simonw/datasette-jq