Got 1,315 results, sorted by newest / oldest

Release: datasette-cluster-map 0.15

Fixed bug where foreign key labels were displayed as [object Object]. #26

Released 2021-01-18T21:49:39Z

Release: sqlite-transform 0.3.1

Better --help for sqlite-transform lambda. #7

Released 2021-01-18T21:01:06Z

Release: swarm-to-sqlite 0.3.3

Fixed bug where tool could crash with an error about missing columns. #11

Released 2021-01-18T04:36:03Z

Release: sqlite-utils 3.3

The table.m2m() method now accepts an optional alter=True argument to specify that any missing columns should be added to the referenced table. See Working with many-to-many relationships. (#222)

Released 2021-01-18T04:29:48Z

Blog: Weeknotes: Still pretty distracted

Not a lot to report this week. U.S. politics continues to make it extremely difficult to focus on anything substantial. Ongoing Datasette projects I have a lot of balls in the air regarding Datasette core at the moment. I'm mainly thinking rather than coding, but I feel like I've made some good progress that should turn into a flurry of code relatively soon. Some of the areas I've been thinking ab...

Published 2021-01-17T05:00:26+00:00

Release: markdown-to-sqlite 0.2

Upgraded tests for latest dependencies Switched CI to GitHub Actions

Released 2021-01-14T20:21:19Z

Release: sqlite-utils 3.2.1

Fixed a bug where .add_missing_columns() failed to take case insensitive column names into account. (#221)

Released 2021-01-12T23:23:25Z

Release: datasette-export-notebook 0.2

Observable export instructions are only shown if Datasette is run with the --cors option. #5 Export notebook page links back to view the rows. #6 CSV streaming export instructions are provided, if available. #7

Released 2021-01-11T22:29:04Z

Blog: Weeknotes: datasette-export-notebook, PyInstaller packaged Datasette, CBSAs

What a terrible week. I've found it hard to concentrate on anything substantial. In a mostly futile attempt to distract myself from doomscrolling I've mainly been building some experimental output plugins, fiddling with PyInstaller and messing around with shapefiles. Packaged Datasette with PyInstaller A long running goal for Datasette has been to make it as easy to install as possible - something...

Published 2021-01-10T00:26:13+00:00

Release: datasette-export-notebook 0.1.1

Improved README with links to a live demo.

Released 2021-01-09T23:57:26Z

Blog: APIs from CSS without JavaScript: the datasette-css-properties plugin

I built a new Datasette plugin called datasette-css-properties. It's very, very weird - it adds a .css output extension to Datasette which outputs the result of a SQL query using CSS custom property format. This means you can display the results of database queries using pure CSS and HTML, no JavaScript required! I was inspired by Custom Properties as State, published by by Chris Coyier earlier th...

Published 2021-01-07T20:50:44+00:00

Release: datasette-css-properties 0.2

.css pages now send the x-content-type-options: nosniff header, to protect against browsers incorrectly rendering the CSS as HTML which could be an XSS security hole. #1

Released 2021-01-07T20:28:40Z

Release: datasette-css-properties 0.1.1

Improved README

Released 2021-01-07T19:48:50Z

Blog: datasette-css-properties

datasette-css-properties My new Datasette plugin defines a ".css" output format which returns the data from the query as a valid CSS stylesheet defining custom properties for each returned column. This means you can build a page using just HTML and CSS that consumes API data from Datasette, no JavaScript required! Whether this is a good idea or not is left as an exercise for the reader. ...

Published 2021-01-07T19:42:37+00:00

Datasette News: 2021-01-07

APIs from CSS without JavaScript: the datasette-css-properties plugin introduces datasette-css-properties, a highly experimental plugin that can output table rows and SQL query results as CSS stylesheets defining custom properties that can then be used to customize a static HTML page.

Release: datasette-export-notebook 0.1

First working version. #1

Released 2021-01-06T08:12:31Z

Plugin: datasette-export-notebook

Datasette plugin providing instructions for exporting data to Jupyter or Observable datasette-export-notebook Datasette plugin providing instructions for exporting data to a Jupyter or Observable notebook. Installation Install this plugin in the same environment as Datasette. $ datasette install datasette-export-notebook Usage Once installed, the plugin will add a .Notebook export option to e...

Created 2021-01-06T07:37:00Z

Release: datasette-css-properties 0.1

Initial prototype.

Released 2021-01-05T18:39:44Z

Plugin: datasette-css-properties

Experimental Datasette output plugin using CSS properties datasette-css-properties Extremely experimental Datasette output plugin using CSS properties, inspired by Custom Properties as State by Chris Coyier. More about this project: APIs from CSS without JavaScript: the datasette-css-properties plugin Installation Install this plugin in the same environment as Datasette. $ datasette install da...

Created 2021-01-05T18:38:07Z

Blog: sqlite-utils 3.2

sqlite-utils 3.2 As discussed in my weeknotes yesterday, this is the release of sqlite-utils that adds the new "cached table counts via triggers" mechanism. Via @simonw

Published 2021-01-03T21:25:45+00:00

Release: sqlite-utils 3.2

This release introduces a new mechanism for speeding up count(*) queries using cached table counts, stored in a _counts table and updated by triggers. This mechanism is described in Cached table counts using triggers, and can be enabled using Python API methods or the new enable-counts CLI command. (#212) table.enable_counts() method for enabling these triggers on a specific table. db.enable_coun...

Released 2021-01-03T21:17:37Z

Blog: Weeknotes: A flurry of not-quite-finished features

My Christmas present to myself this year was to allow myself to spend a week working on stuff I found interesting, rather than sticking to the most important things. This may have been a mistake: it's left me with a flurry of interesting but not-quite-finished features. Prettier for Datasette A couple of years ago I decided to adopt Black, an opinionated code formatter, for all of my Python projec...

Published 2021-01-03T06:07:47+00:00

Release: sqlite-utils 3.1.1

Fixed failing test caused by optimize sometimes creating larger database files. (#209) Documentation now lives on README now includes brew install sqlite-utils installation method.

Released 2021-01-01T23:57:07Z

Blog: Replicating SQLite with rqlite

Replicating SQLite with rqlite I've been trying out rqlite, a "lightweight, distributed relational database, which uses SQLite as its storage engine". It's written in Go and uses the Raft consensus algorithm to allow a cluster of nodes to elect a leader and replicate SQLite statements between them. By default it uses in-memory SQLite databases with an on-disk Raft replication l...

Published 2020-12-28T19:51:23+00:00

Release: datasette-publish-vercel 0.9.1

Fixed a bug with the datasette publish now alias for datasette publish vercel. #31

Released 2020-12-28T19:39:10Z

Blog: Weeknotes: Datasette internals

I've been working on some fundamental changes to Datasette's internal workings - they're not quite ready for a release yet, but they're shaping up in an interesting direction. One of my goals for Datasette is to be able to handle a truly enormous variety of data in one place. The Datasette Library ticket tracks this effort - I'd like a newsroom (or any other information-based organization) to be a...

Published 2020-12-27T03:38:51+00:00

Blog: Datasette Weekly: Official project website for Datasette, building a search engine with Dogsheep Beta, sqlite-utils analyze-tables

Datasette Weekly: Official project website for Datasette, building a search engine with Dogsheep Beta, sqlite-utils analyze-tables Volume 5 of the Datasette Weekly-ish newsletter. Via @simonw

Published 2020-12-23T23:52:29+00:00

Blog: Building a search engine for

This week I added a search engine to, using the search indexing tool I've been building for Dogsheep. Project search for Datasette The Datasette project has a lot of constituent parts. There's the project itself and its documentation - 171 pages when exported to PDF and counting. Then there are the 48 plugins, sqlite-utils and 21 more tools for creating SQLite databases, the Dogsheep...

Published 2020-12-19T18:12:31+00:00

Release: dogsheep-beta 0.10.1

Fix for error if search query contains hyphens such as github-to-sqlite. #31

Released 2020-12-19T06:19:13Z

Datasette News: 2020-12-19

New on this site: a Datasette Tools directory and a search engine that covers documentation, tools, plugins, releases and more. The search engine uses Dogsheep Beta - I wrote about how that works in Building a search engine for

Release: dogsheep-beta 0.10

Now depends on sqlite-utils >= 3.0. #30 The user's original search term is now passed to the display_sql SQL query as the :q parameter. #29

Released 2020-12-16T21:28:13Z

Release: github-to-sqlite 2.8.2

--readme now stores null if the README file does not exist, rather than throwing an error. #57 README HTML is rewritten to fix broken internal links, e.g. for a table of contents. #58

Released 2020-12-16T19:21:58Z

Release: datasette-publish-vercel 0.9

New --setting option for specifying Datasette settings, as a working alternative to --extra-options. #30

Released 2020-12-14T04:03:06Z

Blog: Weeknotes:, an official project website for Datasette

This week I launched - the new official project website for Datasette. Datasette's first open source release was just over three years ago, but until now the official site duties have been split between the GitHub repository and the documentation. The Baked Data architectural pattern The site itself is built on Datasette (source code here). I'm using a pattern that I first started ...

Published 2020-12-13T08:34:44+00:00

Release: sqlite-utils 3.1

New command: sqlite-utils analyze-tables my.db outputs useful information about the table columns in the database, such as the number of distinct values and how many rows are null. See Analyzing tables for documentation. (#207) New table.analyze_column(column) Python method used by the analyze-tables command - see Analyzing a column. The table.update() method now correctly handles values that sho...

Released 2020-12-13T07:31:40Z

Release: datasette-publish-fly 1.0.1

Fixed various errors that occurred when using latest version of flyctl. #7

Released 2020-12-12T21:11:49Z

Release: datasette-auth-passwords 0.3.3

Fixed bug where users with a "someusername_password_hash" value defined in metadata.json but no corresponding "actor" record were incorrectly signed in as an actor with "id": "username", when they should have been signed in as an actor with "id": "someusername". #14

Released 2020-12-11T05:29:14Z

Blog: Datasette finally has an official project website, three years after the first release of the software. I built it using Datasette, with custom templates to define the various pages. The site includes news, latest releases, example sites and a new searchable plugin directory. Via @simonw

Published 2020-12-11T04:11:11+00:00

Release: datasette 0.53

Datasette has an official project website now, at This release mainly updates the documentation to reflect the new site. New ?column__arraynotcontains= table filter. (#1132) datasette serve has a new --create option, which will create blank database files if they do not already exist rather than exiting with an error. (#1135) New ?_header=off option for CSV export which omi...

Released 2020-12-11T01:46:44Z