Simon Willison on datasette

Random

1,521 posts tagged “datasette”

Datasette is an open source tool for exploring and publishing data.

2021

Release datasette 0.55 — An open source multi-tool for exploring and publishing data

19th Feb 2021, 2:02 am · datasette

Release datasette-graphql 1.4 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

18th Feb 2021, 11:37 pm · datasette

Weeknotes: Finally, an intro video for Datasette

My big project this week was this Video introduction to Datasette and sqlite-utils. I recorded the video a few weeks ago in advance of FOSDEM, but this week I put together the annotated version. I’m really happy with it, and I’ve added it to the datasette.io homepage as a starting point for helping people understand the project.

[... 690 words]

6:02 am / 14th February 2021 / geospatial, projects, datasette, weeknotes

Release datasette-tiles 0.6.1 — Mapping tile server for Datasette, serving tiles from MBTiles packages

11th Feb 2021, 12:40 am · datasette

Release datasette-tiles 0.6 — Mapping tile server for Datasette, serving tiles from MBTiles packages

11th Feb 2021, 12:25 am · datasette

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 demonstrating using the sqlite-utils command-line tool to convert a CSV file into a SQLite database, and then publish it using datasette publish. Here’s the video, plus annotated screen captures with further links and commentary.

[... 1,969 words]

9 pm / 7th February 2021 / my-talks, datasette, sqlite-utils, annotated-talks

Weeknotes: Mostly messing around with map tiles

Most of what I worked on this week was covered in Serving map tiles from SQLite with MBTiles and datasette-tiles. I built two new plugins: datasette-tiles for serving map tiles, and datasette-basemap which bundles map tiles for zoom levels 0-6 of OpenStreetMap. I also released download-tiles for downloading tiles and bundling them into an MBTiles database.

[... 350 words]

5:53 am / 7th February 2021 / csv, openstreetmap, projects, datasette, weeknotes, sqlite-utils, leaflet

Release datasette-jellyfish 1.0.1 — Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish

6th Feb 2021, 2:34 am · datasette

Release datasette-jellyfish 1.0 — Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish

6th Feb 2021, 2 am · datasette

Release datasette-tiles 0.5 — Mapping tile server for Datasette, serving tiles from MBTiles packages

4th Feb 2021, 6:16 pm · datasette

Serving map tiles from SQLite with MBTiles and datasette-tiles

Working on datasette-leaflet last week re-kindled my interest in using Datasette as a GIS (Geographic Information System) platform. SQLite already has strong GIS functionality in the form of SpatiaLite and datasette-cluster-map is currently the most downloaded plugin. Most importantly, maps are fun!

[... 1,334 words]

1:09 am / 4th February 2021 / geospatial, mapping, openstreetmap, projects, sqlite, datasette, tom-macwright, leaflet

Release datasette-tiles 0.4 — Mapping tile server for Datasette, serving tiles from MBTiles packages

3rd Feb 2021, 10:24 pm · datasette

Release datasette-tiles 0.3 — Mapping tile server for Datasette, serving tiles from MBTiles packages

2nd Feb 2021, 11:41 pm · datasette

Release datasette-basemap 0.2 — A basemap for Datasette and datasette-leaflet

2nd Feb 2021, 11:33 pm · datasette, leaflet

Release datasette 0.54.1 — An open source multi-tool for exploring and publishing data

2nd Feb 2021, 9:30 pm · datasette

Release datasette-tiles 0.2 — Mapping tile server for Datasette, serving tiles from MBTiles packages

2nd Feb 2021, 7:54 pm · datasette

Release datasette-basemap 0.1 — A basemap for Datasette and datasette-leaflet

2nd Feb 2021, 7:07 am · datasette, leaflet

Release datasette-tiles 0.1.1 — Mapping tile server for Datasette, serving tiles from MBTiles packages

2nd Feb 2021, 7:05 am · datasette

Release datasette-tiles 0.1 — Mapping tile server for Datasette, serving tiles from MBTiles packages

2nd Feb 2021, 6:47 am · datasette

Release datasette-basemap 0.1a1 — A basemap for Datasette and datasette-leaflet

2nd Feb 2021, 2:02 am · datasette, leaflet

Release datasette-basemap 0.1a — A basemap for Datasette and datasette-leaflet

2nd Feb 2021, 1:59 am · datasette, leaflet

Release datasette-cluster-map 0.17.1 — Datasette plugin that shows a map for any data with latitude/longitude columns

1st Feb 2021, 10:22 pm · datasette

Release datasette-leaflet 0.2.2 — Datasette plugin adding the Leaflet JavaScript library

1st Feb 2021, 10:20 pm · datasette, leaflet

JMeter Result Analysis using Datasette (via) NaveenKumar Namachivayam wrote a detailed tutorial on using Datasette (on Windows) and csvs-to-sqlite to analyze the results of JMeter performance test runs and then publish them online using Vercel.

# 1st February 2021, 4:42 am / tutorials, datasette