datasette (exploring and publishing data)

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 or size and publish that as an interactive, explorable website and accompanying API.

An open source multi-tool for exploring and publishing data
https://github.com/simonw/datasette
814 forks.
10,891 stars.
666 open issues.

Recent commits:

Database(is_temp_disk=True) option, used for internal database (#2684)Closes #2683* Add is_temp_disk option to Database for temp file-backed databasesReplace the default in-memory internal database with a temporaryfile-backed database using WAL mode. This fixes concurrent read/writelocking errors that occur with named in-memory SQLite databases.The new is_temp_disk parameter on Database creates a temp file viatempfile.mkstemp, connects to it as a regular file-based databasewith WAL mode enabled, and cleans it up on close() and via atexit.https://claude.ai/code/session_01TteLrUjpDcARjnP1GMRqz2, GitHub
Warning note about VACUUM and RenameTableEventI noticed that VACUUM can update the rootpage for tables in a way thatcould confuse our rename table detection logic – but using theexecute_isolated_fn() method to run VACUUM avoids this problem.Refs #2681, Simon Willison
RenameTableEvent, plus write connection track_event() mechanism (#2682)* Add track_event callback to execute_write_fn and write_wrapperAllows write functions and write_wrapper generators to queue eventsduring a write operation that are dispatched after successful commit.The fn or wrapper can optionally accept a `track_event` parameter(detected via call_with_supported_arguments). Events are discardedif the write raises an exception.Does not yet handle the block=False (non-blocking) case – eventsqueued during non-blocking writes are currently silently discarded.Refs https://github.com/simonw/datasette/issues/2681* Dispatch track_event events for non-blocking (block=False) writesSpawns a background asyncio task that awaits the write thread's replyqueue and dispatches pending events after a successful non-blockingwrite. Events are still discarded if the write raises an exception.Refs https://github.com/simonw/datasette/issues/2681* Warn that events won't fire for other processesRefs https://github.com/simonw/datasette/issues/2681#issuecomment-4157118662, GitHub
Bump rollup from 3.29.5 to 3.30.0 (#2651)Bumps [rollup](https://github.com/rollup/rollup) from 3.29.5 to 3.30.0.- [Release notes](https://github.com/rollup/rollup/releases)- [Changelog](https://github.com/rollup/rollup/blob/v3.30.0/CHANGELOG.md)- [Commits](https://github.com/rollup/rollup/compare/v3.29.5…v3.30.0)—updated-dependencies:- dependency-name: rollup dependency-version: 3.30.0 dependency-type: direct:production…Signed-off-by: dependabot[bot] <support@github.com>Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>, GitHub
Bump picomatch from 2.3.1 to 2.3.2 (#2679)Bumps [picomatch](https://github.com/micromatch/picomatch) from 2.3.1 to 2.3.2.- [Release notes](https://github.com/micromatch/picomatch/releases)- [Changelog](https://github.com/micromatch/picomatch/blob/master/CHANGELOG.md)- [Commits](https://github.com/micromatch/picomatch/compare/2.3.1…2.3.2)—updated-dependencies:- dependency-name: picomatch dependency-version: 2.3.2 dependency-type: indirect…Signed-off-by: dependabot[bot] <support@github.com>Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>, GitHub

Bojan Bjelić

datasette (exploring and publishing data)

Comments

Leave a ReplyCancel reply

More posts

Lifesaving snippets

What is Culture?

“Recursion” by Blake Crouch

Technical debt and vibe-coding

First online article on technical debt

datasette (exploring and publishing data)

Share this:

Comments

Leave a ReplyCancel reply

More posts

Lifesaving snippets

What is Culture?

“Recursion” by Blake Crouch

Technical debt and vibe-coding

First online article on technical debt