sections_fts: 49
This data as json
| rowid | title | content |
|---|---|---|
| 49 | 1.0a32 (2026-05-31) | SQLite INSERT ... RETURNING clauses are now supported by /db/-/execute-write , plus several fixes relating to the base_url setting . INSERT / UPDATE / DELETE statements that use SQLite's RETURNING clause now work correctly in the new /db/-/execute-write interface. Datasette fetches returned rows before committing the write transaction, displays them in the HTML UI and includes them in the "rows" key for the JSON API response. ( #2762 , #2763 ) Database.execute_write() now returns an ExecuteWriteResult object instead of the raw sqlite3.Cursor returned by conn.execute() . The new object exposes .rowcount , .lastrowid , .description , .truncated and .fetchall() , and adds return_all= and returning_limit= options for controlling how rows from RETURNING statements are buffered. ( #2763 ) Fixed the /-/jump navigation search endpoint when Datasette is served with a configured base_url . ( #2757 ) Fixed JSON and CSV export links, plus Link: alternate headers, on table, row and query pages when base_url is configured. These could previously be prefixed twice. ( #2759 ) Fixed several other base_url handling bugs, including the API explorer form actions and share links, the /-/patterns development page, permanent redirects such as /- to /-/ and database query redirects from /<database>?sql=... to /<database>/-/query?sql=... . |