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
Release: sqlite-transform 0.3.1
Better --help for sqlite-transform lambda. #7
Release: swarm-to-sqlite 0.3.3
Fixed bug where tool could crash with an error about missing columns. #11
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)
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...
Release: markdown-to-sqlite 0.2
Upgraded tests for latest dependencies Switched CI to GitHub Actions
Release: sqlite-utils 3.2.1
Fixed a bug where .add_missing_columns() failed to take case insensitive column names into account. (#221)
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
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...
Release: datasette-export-notebook 0.1.1
Improved README with links to a live demo.
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
Release: datasette-css-properties 0.1.1
Release: datasette-export-notebook 0.1
First working version. #1
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...
Release: datasette-css-properties 0.1
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
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...
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...
Release: sqlite-utils 3.1.1
Fixed failing test caused by optimize sometimes creating larger database files. (#209) Documentation now lives on https://sqlite-utils.datasette.io/ README now includes brew install sqlite-utils installation method.
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...
Release: datasette-publish-vercel 0.9.1
Fixed a bug with the datasette publish now alias for datasette publish vercel. #31
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...
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
This week I added a search engine to datasette.io, 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...
Release: dogsheep-beta 0.10.1
Fix for error if search query contains hyphens such as github-to-sqlite. #31
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 datasette.io.
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
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
Release: datasette-publish-vercel 0.9
New --setting option for specifying Datasette settings, as a working alternative to --extra-options. #30
This week I launched datasette.io - 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 ...
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...
I wrote more about how this site works in Weeknotes: datasette.io, an official project website for Datasette.
Release: datasette-publish-fly 1.0.1
Fixed various errors that occurred when using latest version of flyctl. #7
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
datasette.io 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
Release: datasette 0.53
Datasette has an official project website now, at https://datasette.io/. 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...