metadata.json

{
    "title": "Today I Learned",
    "about": "simonw/til",
    "about_url": "https://github.com/simonw/til",
    "plugins": {
        "datasette-graphql": {
            "path": "/-/graphql"
        },
        "datasette-atom": {
            "allow_unsafe_html_in_canned_queries": true
        },
        "datasette-block-robots": {
            "literal": "User-agent: *\nDisallow: /tils"
        },
        "datasette-sitemap": {
            "sql": "select '/' || topic || '/' || slug as path from til"
        }
    },
    "databases": {
        "tils": {
            "queries": {
                "search": {
                    "sql": "select\n  til_fts.rank,\n  til.*,\n  snippet(til_fts, -1, 'b4de2a49c8', '8c94a2ed4b', '...', 60) as snippet\nfrom\n  til\n  join til_fts on til.rowid = til_fts.rowid\nwhere\n  til_fts match case\n    :q\n    when '' then 'nomatchforthisterm'\n    else escape_fts(:q)\n  end\norder by\n  til_fts.rank limit 40\n",
                    "name": "search"
                },
                "feed": {
                    "title": "Simon Willison TIL",
                    "sql": "SELECT\n  'tag:til.simonwillison.net,2020-04-30:' || path as atom_id,\n  title as atom_title,\n  'https://til.simonwillison.net/' || topic || '/' || slug as atom_link,\n  created_utc as atom_updated,\n  html as atom_content_html,\n  'Simon Willison' as atom_author_name,\n  'https://simonwillison.net/' as atom_author_uri\nFROM\n  til\norder by\n  created_utc desc\nlimit\n  15",
                    "name": "feed"
                },
                "feed_by_topic": {
                    "title": "Simon Willison TIL for topic",
                    "sql": "SELECT\n  'tag:til.simonwillison.net,2020-04-30:' || path as atom_id,\n  title as atom_title,\n  'https://til.simonwillison.net/' || topic || '/' || slug as atom_link,\n  created_utc as atom_updated,\n  html as atom_content_html,\n  'Simon Willison' as atom_author_name,\n  'https://simonwillison.net/' as atom_author_uri\nFROM\n  til\nwhere\n  topic = :topic\norder by\n  created_utc desc\nlimit\n  15",
                    "name": "feed_by_topic"
                }
            },
            "tables": {
                "til": {
                    "sort_desc": "updated_utc",
                    "facets": [
                        "topic"
                    ],
                    "source": null,
                    "source_url": null,
                    "license": null,
                    "license_url": null,
                    "about": "simonw/til",
                    "about_url": "https://github.com/simonw/til"
                }
            },
            "source": null,
            "source_url": null,
            "license": null,
            "license_url": null,
            "about": "simonw/til",
            "about_url": "https://github.com/simonw/til"
        }
    }
}