remote/datasette
1
0
Fork 0
mirror of https://github.com/simonw/datasette.git synced 2026-05-28 12:56:18 +02:00
Code Issues Projects Releases Packages Wiki Activity
3,111 commits 166 branches 170 tags 46 MiB
Commit graph

1,227 commits

Author SHA1 Message Date
Simon Willison
0c5053cdf6 Docs for /<database>/-/execute-write JSON API 
Closes #2750, refs #2742
 2026-05-27 17:26:50 -07:00
Simon Willison
b1289a73f9 stored_queries.StoredQuery dataclass 2026-05-26 16:51:00 -07:00
Simon Willison
90e19a7d58 Docs for datasette methods for queries 
Refs https://github.com/simonw/datasette/pull/2741#issuecomment-4549824373
 2026-05-26 16:33:36 -07:00
Simon Willison
2eb307b8c6 Changelog updates for queries branch 
Refs #2735, #2742
 2026-05-26 16:10:05 -07:00
Simon Willison
3c29b002ca Do not document unstable JSON APIs for stored queries 2026-05-26 16:07:53 -07:00
Simon Willison
cef52b1ffc Break up giant views/database.py into smaller modules 2026-05-26 16:06:14 -07:00
Simon Willison
7214cc3761 Remove obsolete label 2026-05-26 15:52:44 -07:00
Simon Willison
58e2e3a8ab Ran cog 2026-05-26 15:43:34 -07:00
Simon Willison
02a1468f1b Renamed canned queries to queries / stored queries in docs 
And a few renames in code and YAML as well.
 2026-05-26 15:17:51 -07:00
Simon Willison
56b14f37d5 The stored queries do not live in that DB 2026-05-26 15:16:18 -07:00
Simon Willison
2f73869c09 Document that canned_queries() has been removed 2026-05-26 15:09:48 -07:00
Simon Willison
b1029acc68 top_canned_query is now top_stored_query, closes #2747 2026-05-26 15:05:41 -07:00
Simon Willison
4bf1c4b065 Rename canned queries to queries/stored queries in docs 2026-05-26 14:54:35 -07:00
Simon Willison
24887004cf Rename insert-query to store-query 
Also queries/insert to queries/store

Refs https://github.com/simonw/datasette/pull/2741#issuecomment-4549103663
 2026-05-26 14:51:59 -07:00
Simon Willison
6033bf8e40 Merge branch 'main' into queries 2026-05-26 13:51:51 -07:00
Simon Willison
1ac4265ffd Require permissions for untrusted stored query execution, refs #2735 2026-05-26 12:12:59 -07:00
Simon Willison
4a1a4d7807 Query is_trusted and is_private properties 
Refs https://github.com/simonw/datasette/issues/2735#issuecomment-4547270516

Diff explanation: https://gist.github.com/simonw/1e4de6c4b041a51968eb273ee96dec1f
 2026-05-26 11:59:49 -07:00
Simon Willison
f1dd86ebfb Tweak URL designs of new endpoints 2026-05-25 14:05:26 -07:00
Simon Willison
1f7c26ffea Refactor to share JS/HTML between execute and execute-write 
Refs #2742
 2026-05-25 12:45:42 -07:00
Simon Willison
de55a76d40
 		Fix 500 error when accessing query page without ?sql= parameter (#2744) 
Closes #2743
 2026-05-25 12:33:57 -07:00
Simon Willison
e1261442c0 Update parameters/query operations as user edits the write query 
Refs #2742
 2026-05-25 12:09:52 -07:00
Simon Willison
6eee6c81e8 Add global query browser 
Refs #2735
 2026-05-25 10:24:42 -07:00
Simon Willison
4a70b89355 Add cursor-paginated query browser 
Refs #2735
 2026-05-25 10:11:46 -07:00
Simon Willison
539ff9ddfc Drop query publication check from docs 
Refs #2735
 2026-05-25 09:49:21 -07:00
Simon Willison
2d07c3b99e Ran cog 2026-05-25 09:47:12 -07:00
Simon Willison
e62a5ea337 Rename query publication flag 
Refs #2735
 2026-05-25 09:46:39 -07:00
Simon Willison
e0d39ba69f Store query options as JSON 
Refs #2735
 2026-05-25 09:41:32 -07:00
Simon Willison
ef43c10388 Add arbitrary write SQL execution page 
Refs #2735
 2026-05-25 08:30:49 -07:00
Simon Willison
2d77e3334b Clean up query management test coverage 
Refs #2735
 2026-05-24 23:06:01 -07:00
Simon Willison
3b26b7aff0 Document canned query hook removal 
Refs #2735
 2026-05-24 23:00:00 -07:00
Simon Willison
4b5fac9cf7 Add query management API and create UI 
Refs #2735
 2026-05-24 22:52:06 -07:00
Simon Willison
6cafdcb6fa
 		Added missing issue reference 2026-05-24 21:18:50 -07:00
Simon Willison
f403ea4e53 No need to alias description as description 2026-05-24 16:47:49 -07:00
Simon Willison
857af9293c Release 1.0a30 
Refs #1752, #2723, #2725, #2727
 2026-05-24 14:17:45 -07:00
Simon Willison
b9cb8e9a30 Tweaked JumpSQL changelog, refs #2731 2026-05-23 21:14:35 -07:00
Simon Willison
c1525cb467 Improved examples in JumpSQL docs 2026-05-23 21:01:18 -07:00
Simon Willison
c980234c41 JumpSQL(database=) parameter 
Refs https://github.com/simonw/datasette/pull/2732#issuecomment-4527304912
 2026-05-23 21:00:04 -07:00
Simon Willison
cef6aa85b6 Remove source and source_key columns from JumpSQL 
Refs https://github.com/simonw/datasette/pull/2732#issuecomment-4527290391
 2026-05-23 20:41:32 -07:00
Simon Willison
21a79b34b8 Improvements to Jump SQL columns 
- Removed database_name and resource_name
- url can now optionally return JSON to reuse datasette.urls. methods
- description is now used as a truncated text description
 2026-05-23 20:28:02 -07:00
Simon Willison
9c1f8621eb Request is always set for jump_items_sql() hook 2026-05-23 16:59:45 -07:00
Simon Willison
be1b5b2b5c Move debug links into jump menu 2026-05-23 16:57:09 -07:00
Simon Willison
1590444fa3 Simplify by removing _query_display_names_sql 
See https://github.com/simonw/datasette/pull/2732/changes#r3293627533
 2026-05-23 16:42:38 -07:00
Copilot
09ccab97cc
 		Run cog to update generated plugin docs (#2734) 
Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
 2026-05-23 09:34:03 -07:00
Simon Willison
f46c245563 blacken-docs 2026-05-23 08:58:51 -07:00
Simon Willison
8568320a23 Replace jump_start() hook with JavaScript makeJumpSections() hook 2026-05-22 21:13:49 -07:00
Simon Willison
6057c76165 Initial docs for jump_items_sql and jump_start hooks 
Refs #2731
 2026-05-21 23:28:35 -07:00
Simon Willison
9909bd654b Merge branch 'main' into jump 2026-05-21 23:11:01 -07:00
Simon Willison
1000d50220 datasette.fixtures module, closes #2733 
https://gist.github.com/simonw/613be79094d491dd08f45e05f4f70691
 2026-05-21 23:05:37 -07:00
Simon Willison
fae847ac10 Prototype of new /-/jump menu plus plugin hook 2026-05-21 15:02:17 -07:00
Simon Willison
d3330695fa Always show 'Jump to...' menu item, closes #2725 2026-05-20 13:23:05 -07:00