Release 1.0a14

[simonw]

Commits: 1.0a13...2ad51ba

[simonw]

curl 'https://github.com/simonw/datasette/compare/1.0a13...2ad51baa31bfba7940c739e99d4270f563a77290.diff' \
  | llm -m claude-3.5-sonnet --system \
  'generate a short summary of these changes, then a bullet point list of detailed release notes'

Here's a summary of the key changes in this diff:

1. Removed metadata-related functionality and APIs, including the /metadata.json endpoint and get_metadata() plugin hook
2. Added new methods for getting and setting metadata at different levels (instance, database, resource, column)
3. Changed SQL query URL from /database?sql=... to /database/-/query?sql=...
4. Updated tests and internal logic to use the new metadata and query APIs
5. Added ETag support for static files
6. Minor UI and template updates

Detailed release notes:

• Removed metadata.json endpoint and related functionality
• Added new async methods for getting/setting metadata:
  • get_instance_metadata(), set_instance_metadata()
  • get_database_metadata(), set_database_metadata()
  • get_resource_metadata(), set_resource_metadata()
  • get_column_metadata(), set_column_metadata()
• Changed SQL query URL format to /database/-/query?sql=...
• Removed get_metadata() plugin hook
• Updated derive_named_parameters() to use regex instead of EXPLAIN
• Added ETag support for static files to improve caching
• Updated various tests to use new metadata and query APIs
• Fixed CSRF protection for custom endpoints
• Improved error messages for database/table not found errors
• Added lang="en" attribute to HTML template
• Updated Python and dependency versions in setup.py
• Various minor bug fixes and code cleanup

[simonw]

Issues, generated by:

git log --pretty=format:"%B" 1.0a13..81b68a143a78b08d1ff7534ab7f00a647a7a0781 | pbcopy

Then pasting that into https://observablehq.com/@simonw/extract-issue-numbers-from-pasted-text (and then manually removed a few that already went out in 1.0a13):

• Add ETag header for static responses #2306
• Fix httpx deprecation warnings #2307
• Document maximum rows allowed per batch in JSON Write API #2310
• Actions menu sometimes displays behind datasette-cluster-map controls #2311
• Run spell check against all of the documentation #2318
• Async example for track_event plugin hook #2319
• Accessibility: add a lang attribute to html #2348
• PyOdide test failure #2351
• Test against multiple SQLite versions #2352
• Canned queries with named parameters fail with error against SQLite 3.46.0 #2353
• derive_named_parameters() method that works with latest SQLite #2354
• Flaky test_max_csv_mb test #2355
• Very weird flaky test_create_table_ignore_replace and test_upsert tests #2356
• Consider using isolation_level="IMMEDIATE" for write connections #2358
• Database/Table/Row not found errors echo back text from URL #2359
• Bump the python-packages group across 1 directory with 4 updates #2362
• Introduce new /$DB/-/query endpoint, soft replaces /$DB?sql=... #2363
• Bump the python-packages group across 1 directory with 2 updates #2371
• Clicking --root link twice is confusing #2375

[simonw]

Better command:

git log --pretty=format:"- %ad: %s %h" --date=short --reverse 1.0a13...2ad51baa31bfba7940c739e99d4270f563a77290 | pbcopy

• 2024-03-12: Added two things I left out of the 1.0a13 release notes 8b6f155
• 2024-03-15: Fix httpx warning about app=self.app, refs Fix httpx deprecation warnings #2307 5af6837
• 2024-03-15: Fixed cookies= httpx warning, refs Fix httpx deprecation warnings #2307 54f5604
• 2024-03-15: Refactor duplicate code in DatasetteClient, closes Fix httpx deprecation warnings #2307 eb8545c
• 2024-03-15: Fix datetime.utcnow deprecation warning 261fc8d
• 2024-03-17: Add ETag header for static responses (Add ETag header for static responses #2306) 67e66f3
• 2024-03-17: datasette-enrichments is example of row_actions da68662
• 2024-03-19: Docs for 100 max rows in an insert, closes Document maximum rows allowed per batch in JSON Write API #2310 1edb24f
• 2024-03-21: z-index: 10000 on dropdown menu, closes Actions menu sometimes displays behind datasette-cluster-map controls #2311 19b6a37
• 2024-04-10: Typo fix triggera -> triggers d32176c
• 2024-04-10: Fixed some typos spotted by Gemini Pro 1.5, closes Run spell check against all of the documentation #2318 63714cb
• 2024-04-11: Async example for track_event hook 2a08ffe
• 2024-04-11: Include actor in track_event async example, refs Async example for track_event plugin hook #2319 7d6d471
• 2024-04-22: datasette, not self.ds, in internals documentation 8f9509f
• 2024-06-11: Move Metadata to --internal database e1bfab3
• 2024-06-11: Only test first wheel, fixes surprise bug c698d00
• 2024-06-11: Fix for pyodide test failure, refs PyOdide test failure #2351 9a3c3bf
• 2024-06-11: , closes Accessibility: add a lang attribute to html #2348 7437d40
• 2024-06-11: Workaround for Canned queries with named parameters fail with error against SQLite 3.46.0 #2353 2b6bfdd
• 2024-06-12: Reminder about how to deploy a release branch 780deaa
• 2024-06-12: Copy across release notes from 0.64.7 b39b01a
• 2024-06-12: named_parameters(sql) sync function, refs derive_named_parameters() method that works with latest SQLite #2354 d118d5c
• 2024-06-12: Removed unnecessary comments, refs derive_named_parameters() method that works with latest SQLite #2354 64a125b
• 2024-06-13: Test against multiple SQLite versions (Test against multiple SQLite versions #2352) 8f86d2a
• 2024-06-13: xfail two flaky tests, Flaky test_max_csv_mb test #2355, Very weird flaky test_create_table_ignore_replace and test_upsert tests #2356 45c2760
• 2024-06-13: Show response.text on test_upsert failure, refs Very weird flaky test_create_table_ignore_replace and test_upsert tests #2356 93534fd
• 2024-06-21: Do not show database name in Database Not Found error, refs Database/Table/Row not found errors echo back text from URL #2359 6268611
• 2024-06-21: Fix for TableNotFound, refs Database/Table/Row not found errors echo back text from URL #2359 7316dd4
• 2024-06-21: Fix for RowNotFound, refs Database/Table/Row not found errors echo back text from URL #2359 2637889
• 2024-06-21: Release notes for 0.64.8 on main c2e8e50
• 2024-07-02: Bump the python-packages group across 1 directory with 4 updates (Bump the python-packages group across 1 directory with 4 updates #2362) 56adfff
• 2024-07-15: Introduce new /$DB/-/query endpoint, soft replaces /$DB?sql=... (Introduce new /$DB/-/query endpoint, soft replaces /$DB?sql=... #2363) a23c2ae
• 2024-07-16: Use isolation_level=IMMEDIATE, refs Consider using isolation_level="IMMEDIATE" for write connections #2358 2edf45b
• 2024-07-25: Bump the python-packages group across 1 directory with 2 updates (Bump the python-packages group across 1 directory with 2 updates #2371) feccfa2
• 2024-07-26: /-/auth-token as root redirects to /, closes Clicking --root link twice is confusing #2375 81b68a1
• 2024-08-05: Initial upgrade guide for v0.XX to v1 169ee5d
• 2024-08-05: Tweaks and improvements to upgrade guide, refs #Upgrade guide for v0.XX to v1 #2374 bd7d3bb
• 2024-08-05: Move /db?sql= redirect to top of changes 2ad51ba

[simonw]

Extracted a TIL: https://til.simonwillison.net/github/release-note-assistance

[simonw]

I want to get this done before the release:

• Rename datasette_metadata_column_entries internal tables to e.g. metadata_columns #2382

[simonw]

Release notes are live: https://docs.datasette.io/en/latest/changelog.html#a14-2024-08-05

[simonw]

Blogged the annotated release notes here: https://simonwillison.net/2024/Aug/5/datasette-1a14/