Robuta

https://til.simonwillison.net/google-sheets/datasette-sql SQL functions in Google Sheets to fetch data from Datasette | Simon Willison’s TILs I've been experimenting with ways to fetch data from Datasette and display it in Google Sheets. https://simonwillison.net/2023/Dec/1/datasette-enrichments/ Datasette Enrichments: a new plugin framework for augmenting your data Today I’m releasing datasette-enrichments, a new feature for Datasette which provides a framework for applying “enrichments” that can augment your data. An... datasette enrichmentsplugin frameworknewaugmenting https://simonwillison.net/2025/Nov/4/datasette-10a20/ A new SQL-powered permissions system in Datasette 1.0a20 Datasette 1.0a20 is out with the biggest breaking API change on the road to 1.0, improving how Datasette’s permissions system works by migrating permission... a newpermissions systemsqlpowereddatasette https://simonwillison.net/2024/Aug/5/datasette-1a14/ Datasette 1.0a14: The annotated release notes Released today: Datasette 1.0a14. This alpha includes significant contributions from Alex Garcia, including some backwards-incompatible changes in the run-up... datasetteannotatedreleasenotes https://simonwillison.net/2021/Feb/7/video/ Video introduction to Datasette and sqlite-utils I put together a 17 minute video introduction to Datasette and sqlite-utils for FOSDEM 2021, showing how you can use Datasette to explore data, and... video introductiondatasettesqliteutils https://simonwillison.net/2024/Feb/7/datasette-1a8/ Datasette 1.0a8: JavaScript plugins, new plugin hooks and plugin configuration in datasette.yaml I just released Datasette 1.0a8. These are the annotated release notes. This alpha release continues the migration of Datasette’s configuration from... plugins new https://datasette.io/ Datasette: An open source multi-tool for exploring and publishing data Datasette is a tool for exploring and publishing data. It helps people take data of any shape, analyze and explore it, and publish it as an interactive website... open sourcemulti tooldatasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets/96 Datasette datasette https://linuxcommandlibrary.com/man/datasette datasette man | Linux Command Library datasette linux command man page: tool for exploring and publishing SQLite databases linux commanddatasettelibrary https://datasette.io/plugins/datasette-plot datasette-plot - a plugin for Datasette A Datasette plugin for making data visualizations with Observable Plot a plugindatasetteplot https://datasette.io/plugins/sqlite-lines sqlite-lines - a plugin for Datasette a pluginsqlitelinesdatasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?format=CSV&end_date__date=-4707-01-23&source=data.gov.au&licence=Creative+Commons+Attribution+4.0+International Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?_facet_date=dataset_issued&publisher=National+Archives+of+Australia&file_created__date=2014-07-11&dataset_issued__date=2014-07-11&_facet_date=dataset_modified&licence=Creative+Commons+Attribution+3.0+Australia Datasette datasette https://dakewen.com/tags/datasette 'Datasette' Questions - 答客问 通过简单的导入导出和数据库管理,探索和发布数据。 datasettequestions https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?format=CSV&_facet=dataset_modified&dataset_modified=2022-05-25T18%3A46%3A13.911322&_facet_date=dataset_modified&dataset_modified__date=2022-05-25&licence=Creative+Commons+Attribution+4.0&_facet_date=dataset_issued&_facet_date=file_created&source=data.wa.gov.au Datasette datasette https://advisories.gitlab.com/pkg/pypi/datasette/GHSA-gff3-739c-gxfq/ https://advisories.gitlab.com/pypi/datasette/GHSA-gff3-739c-gxfq/ httpsadvisoriesgitlabpypidatasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?licence=Custom+%28Other%29&dataset_modified__date=2022-05-25&_facet_date=file_created&source=data.wa.gov.au Datasette datasette https://datasette.io/news/2026-04-19 Datasette News: 19th April 2026 datasettenewsapril https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets/745 Datasette datasette https://datasette.io/plugins/datasette-block-robots datasette-block-robots - a plugin for Datasette a plugindatasetteblockrobots https://datasette.io/plugins/datasette-column-sum datasette-column-sum - a plugin for Datasette a plugindatasettecolumnsum https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?format=CSV&_facet_date=file_modified&end_date__date=-4707-03-12&publisher=Libraries+Tasmania&source=data.gov.au&licence=Creative+Commons+Attribution+2.5+Australia&_facet_date=file_created Datasette datasette https://datasette-auth-passwords-demo.datasette.io/ datasette-auth-passwords demo: public datasetteauthpasswordsdemopublic https://datasette.io/plugins/datasette-vega datasette-vega - a plugin for Datasette Datasette plugin for visualizing data using Vega a plugindatasettevega https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?format=CSV&end_date__date=-4707-02-09&dataset_modified__date=2021-11-30&_facet_date=file_modified&source=data.gov.au&_facet_date=dataset_issued&licence=Creative+Commons+Attribution+4.0+International&publisher=Libraries+Tasmania Datasette datasette https://datasette.io/plugins/datasette-tiddlywiki datasette-tiddlywiki - a plugin for Datasette a plugindatasettetiddlywiki https://datasette.io/plugins/datasette-graphql datasette-graphql - a plugin for Datasette Datasette plugin providing an automatic GraphQL API for your SQLite databases a plugindatasettegraphql https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?dataset_modified__date=2022-06-28&dataset_issued__date=2015-12-18&_facet_date=file_created&format=CSV&source=data.qld.gov.au&file_created__date=2015-12-18&_facet_date=dataset_issued&publisher=Queensland+State+Archives Datasette datasette https://datasette.io/plugins/datasette-psutil datasette-psutil - a plugin for Datasette a plugindatasettepsutil https://discord.com/invite/ktd74dm5mw Datasette Check out the Datasette community on Discord - hang out with 1413 other members and enjoy free voice and text chat. datasette https://craigulmer.com/hobbies/?id=260118_Separating_Plane_Tracks_with_Datasette Separating Plane Tracks with Datasette separatingplanetracksdatasette https://datasette.io/plugins/datasette-x-forwarded-host datasette-x-forwarded-host - a plugin for Datasette host adatasettexforwardedplugin https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets.json?dataset_modified__date=2020-09-23&dataset_issued__date=2017-07-26&file_created__date=2017-07-26&publisher=Queensland+State+Archives&_facet_date=dataset_issued Datasette datasette https://datasette.io/plugins/datasette-edit-schema datasette-edit-schema - a plugin for Datasette schema adatasetteeditplugin https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?dataset_issued=2014-09-30T04%3A45%3A10.718317&_facet_date=file_created&file_created__date=2014-09-30&licence=Creative+Commons+Attribution&publisher=NSW+State+Archives&source=data.nsw.gov.au Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?dataset_modified__date=2020-09-30&publisher=Queensland+Museum&dataset_issued__date=2018-10-12&file_modified__date=2018-10-12&_facet_date=file_created&_facet_date=dataset_modified Datasette datasette https://datasette.io/plugins/datasette-json-html datasette-json-html - a plugin for Datasette Datasette plugin for rendering HTML based on JSON values json htmla plugindatasette https://datasette.io/plugins/datasette-redirect-forbidden datasette-redirect-forbidden - a plugin for Datasette a plugindatasetteredirectforbidden https://datasette.io/plugins/datasette-render-timestamps datasette-render-timestamps - a plugin for Datasette a plugindatasetterendertimestamps https://datasette.io/plugins/datasette-schema-versions datasette-schema-versions - a plugin for Datasette schema versionsdatasetteplugin https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?publisher=Queensland+State+Archives&dataset_modified__date=2022-05-29&file_modified__date=2021-08-03&source=data.qld.gov.au&format=CSV&licence=Creative+Commons+Attribution+4.0 Datasette datasette https://datasette.io/plugins/sqlite-vss sqlite-vss - a plugin for Datasette a pluginsqlitevssdatasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?format=API&file_created__date=2016-07-26&publisher=State+Library+of+NSW&_facet_date=file_created Datasette datasette https://datasette.io/plugins/datasette-extract datasette-extract - a plugin for Datasette a plugindatasetteextract https://datasette.io/plugins/datasette-sitemap datasette-sitemap - a plugin for Datasette a plugindatasettesitemap https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?publisher=National+Archives+of+Australia&licence=Creative+Commons+Attribution+3.0+Australia&source=data.gov.au&file_created__date=2014-07-11&format=CSV&_facet_date=dataset_issued Datasette datasette https://docs.datasette.io/en/stable/full_text_search.html Full-text search - Datasette documentation full text searchdatasettedocumentation https://simonwillison.net/2026/Apr/15/datasette/ Release: datasette 1.0a27 An open source multi-tool for exploring and publishing data releasedatasette https://datasette.io/news/2023-08-22 Datasette News: 22nd August 2023 datasettenewsaugust https://docs.datasette.io/en/stable/getting_started.html Getting started - Datasette documentation getting starteddatasettedocumentation https://www.datasette.cloud/login/ Login to Datasette Cloud login todatasettecloud https://datasette.io/tutorials Datasette Tutorials datasettetutorials https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?_facet_date=file_modified&dataset_modified__date=2022-06-13&publisher=Queensland+State+Archives&format=CSV&licence=Creative+Commons+Attribution+4.0&_facet_date=dataset_issued Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?licence=Creative+Commons+Attribution+4.0&format=TIF&source=data.wa.gov.au&publisher=State+Records+Office+of+Western+Australia&_facet_date=file_created&_facet_date=dataset_issued Datasette datasette https://datasette-auth-github-demo.datasette.io/ datasette-auth-github demo: public datasetteauthgithubdemopublic https://datasette.io/plugins/datasette-placekey datasette-placekey - a plugin for Datasette a plugindatasette https://registry.datasette.io/ Datasette: registry datasetteregistry https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?publisher=Queensland+State+Archives&dataset_modified__date=2022-06-20&file_created__date=2018-09-03&format=JSON Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets.json?file_created__date=2015-05-29&_facet_date=dataset_issued&source=data.vic.gov.au&publisher=Public+Records+Office+Victoria&licence=Creative+Commons+Attribution+4.0+International Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?dataset_issued=2014-09-30T04%3A52%3A48.805972&_facet_date=file_created&licence=Creative+Commons+Attribution&source=data.nsw.gov.au&_facet_date=dataset_modified Datasette datasette https://datasette.io/plugins/datasette-publish-vercel datasette-publish-vercel - a plugin for Datasette a plugindatasettepublishvercel https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?format=CSV&source=data.gov.au&licence=Creative+Commons+Attribution+3.0+Australia&dataset_issued__date=2014-07-11&_facet_date=dataset_modified&_facet_date=file_created&publisher=National+Archives+of+Australia&dataset_modified__date=2015-04-08 Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?publisher=Queensland+State+Archives&dataset_modified__date=2022-06-20&file_created__date=2021-02-23&format=CSV&dataset_issued__date=2014-06-25&source=data.qld.gov.au&_facet_date=file_modified&licence=Creative+Commons+Attribution+4.0 Datasette datasette https://datasette.io/for/publishing-data Datasette for publishing data datasettepublishing https://simonwillison.net/2020/Oct/7/datasette-digitalocean-app-platform/ Running Datasette on DigitalOcean App Platform I spent some time with DigitalOcean's new App Platform today, which is a Heroku-style PaaS that starts at $5/month. It looks like it could be a really good fit... runningdatasettedigitaloceanappplatform https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?_facet_date=dataset_issued&dataset_modified__date=2022-05-29&dataset_issued__date=2015-04-20&file_modified__date=2021-08-03&source=data.qld.gov.au&licence=Creative+Commons+Attribution+4.0&_facet_date=dataset_modified&_facet_date=file_modified Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?dataset_modified__date=2022-06-12&source=data.qld.gov.au&publisher=Queensland+State+Archives&_facet_date=dataset_issued&format=CSV&dataset_issued__date=2012-12-10 Datasette datasette https://glam-workbench.net/datasette-lite/?csv=https://github.com/GLAM-Workbench/gov-portals-data/blob/main/glam-datasets-from-gov-portals.csv/data/glam-datasets?file_created__date=2014-12-23&_facet_date=dataset_modified&source=data.vic.gov.au&licence=Creative+Commons+Attribution+4.0+International&dataset_modified__date=2015-11-25 Datasette datasette https://datasette.io/plugins/datasette-saved-queries datasette-saved-queries - a plugin for Datasette saved queriesdatasetteplugin https://simonwillison.net/2019/Jun/14/datasette-json-html/ Release: datasette-json-html 0.5 - tooltips and demos Datasette plugin for rendering HTML based on JSON values json htmlreleasedatasettetooltipsdemos