53 rows

View and edit SQL

Suggested facets: stargazers_count, tag_name, openGraphImageUrl, usesCustomOpenGraphImage, is_tool, latest_release_at (date), created_at (date)

name full_name description stargazers_count tag_name latest_release_at created_at openGraphImageUrl usesCustomOpenGraphImage downloads_this_week is_plugin is_tool
datasette-leaflet-freedraw simonw/datasette-leaflet-freedraw Draw polygons on maps in Datasette 3 0.2 2021-01-25T19:04:07Z 2021-01-20T00:55:03Z https://repository-images.githubusercontent.com/331151708/21fef280-5dcc-11eb-86e6-1b5e32d08e48 1 368 1 0
datasette-leaflet simonw/datasette-leaflet Datasette plugin adding the Leaflet JavaScript library 1 0.2 2021-01-25T19:01:57Z 2021-01-21T18:41:19Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0   1 0
datasette-auth-github simonw/datasette-auth-github Datasette plugin that authenticates users against GitHub 27 0.13 2021-01-24T05:52:43Z 2019-07-03T16:02:53Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 309 1 0
datasette-cluster-map simonw/datasette-cluster-map Datasette plugin that shows a map for any data with latitude/longitude columns 31 0.16 2021-01-23T22:49:34Z 2018-04-19T15:31:55Z https://repository-images.githubusercontent.com/130236762/e0560900-3af7-11eb-8b6a-3911dbeef752 1 109 1 0
datasette-leaflet-geojson simonw/datasette-leaflet-geojson Datasette plugin that replaces any GeoJSON column values with a Leaflet map. 7 0.7 2021-01-20T20:20:29Z 2018-05-27T01:42:30Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 117 1 0
datasette-export-notebook simonw/datasette-export-notebook Datasette plugin providing instructions for exporting data to Jupyter or Observable 2 0.2 2021-01-11T22:27:18Z 2021-01-06T07:37:00Z https://repository-images.githubusercontent.com/327236119/d9a6e700-5299-11eb-95df-216735d3ee4f 1 51 1 0
datasette-css-properties simonw/datasette-css-properties Experimental Datasette output plugin using CSS properties 7 0.2 2021-01-07T20:27:29Z 2021-01-05T18:38:07Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 27 1 0
datasette-publish-vercel simonw/datasette-publish-vercel Datasette plugin for publishing data using Vercel 4 0.9.1 2020-12-28T19:38:10Z 2020-04-06T22:47:13Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 29 1 0
dogsheep-beta dogsheep/dogsheep-beta Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette 44 0.10.1 2020-12-19T06:18:01Z 2019-07-17T17:07:26Z https://avatars.githubusercontent.com/u/53015001?s=400&v=4 0 96 1 1
datasette-publish-fly simonw/datasette-publish-fly Datasette plugin for publishing data using Fly 3 1.0.1 2020-12-12T21:10:24Z 2020-03-19T01:47:01Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 19 1 0
datasette-auth-passwords simonw/datasette-auth-passwords Datasette plugin for authentication using passwords 4 0.3.3 2020-12-11T05:27:06Z 2020-07-13T16:34:39Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 76 1 0
datasette-column-inspect simonw/datasette-column-inspect Experimental plugin that adds a column inspector 1 0.2a 2020-12-09T21:46:02Z 2020-03-09T18:11:00Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 12 1 0
datasette-pretty-json simonw/datasette-pretty-json Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays 6 0.2.1 2020-12-09T21:22:21Z 2019-01-26T19:30:43Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 26 1 0
datasette-seaborn simonw/datasette-seaborn Statistical visualizations for Datasette using Seaborn 7 0.2a0 2020-12-07T01:37:52Z 2020-09-11T13:43:08Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 25 1 0
datasette-search-all simonw/datasette-search-all Datasette plugin for searching all searchable tables at once 4 1.0.1 2020-12-04T21:11:15Z 2020-03-08T17:21:54Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 47 1 0
datasette-yaml simonw/datasette-yaml Export Datasette records as YAML 1 0.1.1 2020-12-03T00:09:11Z 2020-08-29T22:32:15Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 33 1 0
datasette-graphql simonw/datasette-graphql Datasette plugin providing an automatic GraphQL API for your SQLite databases 28 1.3.1 2020-11-30T19:01:53Z 2020-08-02T03:31:58Z https://repository-images.githubusercontent.com/284383265/1fcf2600-3af5-11eb-87be-2779779582c3 1 361 1 0
datasette-ripgrep simonw/datasette-ripgrep Web interface for searching your code using ripgrep, built as a Datasette plugin 45 0.6.1 2020-11-28T22:42:14Z 2020-11-25T01:26:36Z https://repository-images.githubusercontent.com/315796015/09e82680-3978-11eb-9828-94b780b592bb 1 53 1 0
datasette-atom simonw/datasette-atom Datasette plugin that adds a .atom output format 9 0.8.1 2020-11-25T19:39:49Z 2019-09-17T15:31:01Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 133 1 0
datasette-copyable simonw/datasette-copyable Datasette plugin for outputting tables in formats suitable for copy and paste 7 0.3.1 2020-11-14T21:44:37Z 2020-07-21T19:04:08Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 56 1 0
datasette-configure-fts simonw/datasette-configure-fts Datasette plugin for enabling full-text search against selected table columns 2 1.1 2020-11-01T02:26:53Z 2020-02-29T01:50:57Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 23 1 0
datasette-edit-schema simonw/datasette-edit-schema Datasette plugin for modifying table schemas 4 0.4 2020-10-31T22:54:33Z 2020-03-15T18:34:06Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 26 1 0
datasette-upload-csvs simonw/datasette-upload-csvs Datasette plugin for uploading CSV files and converting them to database tables 4 0.6 2020-10-31T22:44:46Z 2020-01-19T02:07:05Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 21 1 0
datasette-render-markdown simonw/datasette-render-markdown Datasette plugin for rendering Markdown 5 1.2 2020-10-28T22:53:30Z 2019-11-09T23:28:31Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 36 1 0
datasette-dateutil simonw/datasette-dateutil dateutil functions for Datasette 4 0.2.1 2020-09-30T01:06:50Z 2020-09-28T00:14:20Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 25 1 0
datasette-import-table simonw/datasette-import-table Datasette plugin for importing tables from other Datasette instances 0 0.2 2020-09-28T15:26:26Z 2020-09-28T05:30:07Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 21 1 0
datasette-ics simonw/datasette-ics Datasette plugin for outputting iCalendar files 3 0.5 2020-09-14T22:18:36Z 2020-02-28T08:11:01Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 8 1 0
datasette-backup simonw/datasette-backup Plugin adding backup options to Datasette 1 0.1 2020-09-07T02:26:42Z 2020-09-05T22:33:29Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 15 1 0
datasette-block-robots simonw/datasette-block-robots Datasette plugin that blocks all robots using robots.txt 0 0.3 2020-09-06T01:43:20Z 2020-06-23T02:52:23Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 26 1 0
datasette-render-images simonw/datasette-render-images Datasette plugin that renders binary blob images using data-uris 6 0.3.2 2020-08-23T18:35:12Z 2018-08-21T00:05:47Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 23 1 0
datasette-schema-versions simonw/datasette-schema-versions Datasette plugin that shows the schema version of every attached database 0 0.1 2020-08-19T04:04:33Z 2020-08-19T04:04:39Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 8 1 0
datasette-saved-queries simonw/datasette-saved-queries Datasette plugin that lets users save and execute queries 2 0.2.1 2020-08-15T23:37:51Z 2020-06-20T00:20:42Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 22 1 0
datasette-json-html simonw/datasette-json-html Datasette plugin for rendering HTML based on JSON values 11 0.6.1 2020-08-09T22:46:19Z 2018-07-31T05:41:39Z https://repository-images.githubusercontent.com/142967347/8ace2c00-3af8-11eb-9dd2-e825cceb5a3e 1 35 1 0
datasette-insert simonw/datasette-insert Datasette plugin for inserting and updating data 5 0.6 2020-07-31T21:42:35Z 2020-07-17T18:40:34Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 18 1 0
datasette-media simonw/datasette-media Datasette plugin for serving media based on a SQL query 8 0.5 2020-07-29T22:03:48Z 2020-05-06T02:42:57Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 21 1 0
datasette-auth-tokens simonw/datasette-auth-tokens Datasette plugin for authenticating access using API tokens 3 0.2.2 2020-07-20T00:33:26Z 2020-06-11T23:23:30Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 22 1 0
datasette-glitch simonw/datasette-glitch Utilities to help run Datasette on Glitch 1 0.1 2020-07-01T22:48:27Z 2020-06-28T15:41:25Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 9 1 0
datasette-debug-asgi simonw/datasette-debug-asgi Datasette plugin for dumping out the ASGI scope 0 0.1.1 2020-06-29T16:23:11Z 2020-02-05T00:57:09Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 13 1 0
datasette-psutil simonw/datasette-psutil Datasette plugin adding a /-/psutil debugging endpoint 0 0.2 2020-06-13T23:27:36Z 2020-06-13T22:57:07Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 10 1 0
datasette-permissions-sql simonw/datasette-permissions-sql Datasette plugin for configuring permission checks using SQL queries 0 0.3a 2020-06-12T07:03:35Z 2020-06-10T23:48:13Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 9 1 0
datasette-template-sql simonw/datasette-template-sql Datasette plugin for executing SQL queries from templates 3 1.0.1 2020-04-22T01:56:45Z 2019-11-14T23:05:34Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 16 1 0
datasette-auth-existing-cookies simonw/datasette-auth-existing-cookies Datasette plugin that authenticates users based on existing domain cookies 2 0.7 2020-04-15T15:22:49Z 2020-01-25T01:20:31Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 12 1 0
datasette-mask-columns simonw/datasette-mask-columns Datasette plugin that masks specified database columns 2 0.2 2020-04-14T16:50:31Z 2020-02-22T01:29:16Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 14 1 0
datasette-jq simonw/datasette-jq Datasette plugin that adds a custom SQL function for executing jq expressions against JSON values 9 0.2.1 2020-04-09T05:43:08Z 2019-05-30T01:06:31Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 6 1 0
datasette-render-html simonw/datasette-render-html Plugin for selectively rendering the HTML is specific columns 2 0.1.2 2020-03-21T22:04:49Z 2019-04-30T01:21:25Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 9 1 0
datasette-render-timestamps simonw/datasette-render-timestamps Datasette plugin for rendering timestamps 4 1.0.1 2020-03-21T21:53:35Z 2019-10-10T22:50:50Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 11 1 0
datasette-show-errors simonw/datasette-show-errors Datasette plugin for displaying error tracebacks 1 0.2 2020-03-21T15:41:01Z 2020-03-21T15:06:04Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 5 1 0
datasette-sentry simonw/datasette-sentry Datasette plugin for configuring Sentry 4 0.1.1 2020-01-29T05:53:16Z 2020-01-28T23:41:27Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 5 1 0
datasette-rure simonw/datasette-rure Datasette plugin that adds a custom SQL function for executing matches using the Rust regular expression engine 4 0.3 2019-09-11T22:58:20Z 2019-09-10T18:09:33Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 13 1 0
datasette-cors simonw/datasette-cors Datasette plugin for configuring CORS headers 8 0.3 2019-07-11T04:40:37Z 2019-07-07T21:03:11Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 5 1 0
datasette-render-binary simonw/datasette-render-binary Datasette plugin for rendering binary data 4 0.3 2019-06-13T16:14:18Z 2019-06-09T15:25:52Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 8 1 0
datasette-bplist simonw/datasette-bplist Datasette plugin for working with Apple's binary plist format 9 0.1 2019-06-09T01:14:22Z 2019-06-09T01:15:01Z https://avatars.githubusercontent.com/u/9599?s=400&v=4 0 5 1 0
datasette-vega simonw/datasette-vega Datasette plugin for visualizing data using Vega 25 0.6.1 2018-07-10T03:25:37Z 2018-06-26T01:40:54Z https://repository-images.githubusercontent.com/138669673/58bcca00-3af8-11eb-982a-e4f24d8bbeb9 1 99 1 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW plugins AS select
  repos.name as name,
  repos.full_name as full_name,
  repos.description as description,
  repos.stargazers_count,
  releases.tag_name,
  max(releases.created_at) as latest_release_at,
  repos.created_at as created_at,
  datasette_repos.openGraphImageUrl,
  datasette_repos.usesCustomOpenGraphImage,
  (
    select
      sum(downloads)
    from
      stats
    where
      stats.package = repos.name
      and stats.date > date('now', '-7 days')
  ) as downloads_this_week,
  (
    select
      count(*)
    from
      json_each(datasette_repos.topics)
    where
      value = 'datasette-plugin'
  ) as is_plugin,
  (
    select
      count(*)
    from
      json_each(datasette_repos.topics)
    where
      value = 'datasette-tool'
  ) as is_tool
from
  datasette_repos
  join repos on datasette_repos.id = repos.node_id
  join releases on repos.id = releases.repo
where
  datasette_repos.rowid in (
    select
      datasette_repos.rowid
    from
      datasette_repos,
      json_each(datasette_repos.topics) j
    where
      j.value = 'datasette-plugin'
  )
group by
  repos.id
order by
  latest_release_at desc;