Commit graph

Select branches

Hide pull requests

0.52.x

0.54.x

0.56.x

0.60.x

0.63.x

0.64.x

0.65.x

1-0-alpha

1.0a.x

3.15-dev

api-extras

asg017/hidden-revamp

asg017/script-write-endpoint

asgi

asgi-first-attempt

base-url

better-templates

black

black-update

bugfix-0.27.1

bump

bump-versions

ci-macos-windows

claude/add-db-file-watcher-JkJpx

claude/async-settings-access-461MI

claude/column-types-design-8yXIk

claude/database-backed-api-tokens-zUHZP

claude/debug-menu-hub-F6gAH

claude/document-expand-options-FHr9v

claude/investigate-metadata-system-1S9OZ

claude/optimize-datasette-subqueries-7FkhE

claude/per-request-db-connections-4gdSV

claude/remove-datasette-publish-0l5cf

claude/review-json-api-consistency-6Xrns

claude/review-side-panel-production-em0Lr

claude/review-sql-permissions-8toT4

claude/toggle-suggested-facets-FqW19

claude/warn-temp-database-writes-lmoYo

cleaner-link-column-pass-tests

cloudrun-upgrade

codespell

codex/document-undocumented-_extra=-options

codex/operation-sql-analysis

col-nocol

column-sort

columns

configure-from-directory

cross-database-joins

csv

csv-stream

custom-pages

custom-router

dash-encoding

datasette-close

datasette-library-simple

datasette-package-port

debug-travis

debug-travis-issue-216

default-deny

dependabot/pip/python-packages-b18d64ad6f

detect-fts

distinct-column-values

encode-decode-table-name

extra-template-vars

facet-by-comma

facet-refactor

facet-wip

filter-plugin-hook

fix-2473

fix-regex-warnings

fix-warnings

gith

header-footer-integration

in-memory-option

include-vcs-ignore

integrate-new-permissions

isort

isort-22-aug-2023

issue-1179

issue-1657-wip

issue-597

issue-744

jinja2-async

json-extras-query

json-labels

json-post

json_renderer_refactor

keyword-only

less-counting-on-homepage

link-rel-alternate-header

load-template-plugin-hook

m2m

magic-columns

main

master

metadata-yaml

new-starlette

new-views

no-auto-format-sql

no-uvicorn

optional-hash

pages

parallel-queries

path-from-header

permission-sql-restrictions

permissions-allow-blocks

pint-0.9

plugin-config

plugin-hook-cell

plugin-includes

plugin-load-metadata

plugin-secret

plugins

plugins-dir

pool

postgresql-prototype

prepare-connection-datasette

prepare_asgi

prototype-json-context-docs

publish-3.8

py35

pysqlite3

pytest-dist

python-3.8-minimum

query-info

querystring-fks

refactor-query-page-module

refactor-views

render-template

request-id

resource-based-permissions

revert-324-speed-up-travis

row-panel

sanic-07

scan-dirs

schema-version-fix

schema-version-fix-0.64.x

set-column-types-api

shape-array

shared-extras

simonw-aiohttp-bump

speed-up-travis

sql-errors

sql-list-parameters

sqlite-cache-setting

sqlite-interrupt

stable

starlette

suggested-facets

tableview-asyncinject

tableview-refactor

test-3.12-dev

tilde-setup

travis-38dev

travis-deploy-now

travis-python38

update-tests

uv

uvicorn-0-10-4

uvicorn-bump

vendored-pint

view-transitions

windows-ci

windows-github-actions

wip-url-prefix

writable-canned

#1000

#1008

#1008

#1017

#1018

#1022

#1029

#1030

#1031

#1038

#104

#1040

#1043

#1044

#1049

#1056

#1059

#1060

#1061

#1065

#1069

#107

#1085

#1097

#1112

#1117

#1120

#1122

#1128

#1130

#1130

#114

#1145

#115

#1158

#1159

#1159

#117

#1170

#118

#1203

#1204

#1204

#1206

#1211

#1222

#1223

#1229

#1232

#1243

#1252

#1254

#1256

#1260

#1271

#1271

#1279

#1282

#1290

#1291

#1296

#1296

#1303

#1306

#1309

#1311

#1313

#1314

#1318

#1319

#1321

#1323

#1324

#1325

#1330

#1335

#1339

#1346

#1347

#1348

#1348

#1352

#1357

#1368

#1370

#1373

#1374

#1378

#1385

#1386

#1392

#1393

#1397

#1399

#1399

#1400

#1418

#1430

#1433

#1434

#1434

#1444

#1447

#1448

#145

#1453

#1455

#1458

#1463

#1465

#1465

#1467

#1471

#1474

#1475

#1475

#1476

#1481

#1484

#1485

#1487

#1489

#1490

#1494

#1495

#1500

#1508

#1512

#1514

#1516

#1529

#1537

#1543

#1548

#1554

#1559

#1562

#1574

#1582

#1589

#1593

#1602

#1610

#1616

#1617

#1622

#1626

#1626

#1629

#1631

#1648

#1649

#1656

#1659

#1664

#1665

#168

#1685

#1693

#1694

#1703

#1717

#1736

#1740

#1753

#1757

#1757

#1759

#1760

#1763

#1766

#1769

#1772

#1778

#178

#1789

#1792

#1793

#1794

#1797

#1799

#180

#1801

#1803

#181

#1812

#182

#1820

#1823

#1823

#1825

#1827

#1835

#1837

#1838

#1839

#1840

#1842

#1870

#1870

#1893

#1898

#1912

#192

#1930

#1931

#1935

#1938

#1940

#1944

#196

#1960

#1961

#1965

#1967

#1974

#1976

#1977

#1982

#1984

#1986

#1992

#1996

#1996

#1999

#200

#2003

#2003

#2004

#2004

#2008

#2008

#2014

#202

#202

#2025

#2026

#2026

#2028

#2031

#2031

#2034

#2034

#204

#2043

#2044

#2046

#2047

#205

#205

#2052

#2053

#2056

#206

#2061

#2061

#2063

#2064

#2068

#207

#2074

#2074

#2075

#2076

#2076

#2077

#208

#2080

#2082

#2082

#2083

#209

#2096

#2096

#2098

#2099

#210

#2100

#2100

#2107

#2118

#212

#2121

#2124

#2125

#2128

#2141

#2142

#2144

#2148

#2149

#2151

#2151

#2152

#2154

#2155

#2158

#2158

#2159

#2159

#2160

#2161

#2162

#2165

#2166

#2173

#2174

#2174

#2175

#2181

#2182

#2183

#2185

#2190

#2191

#2192

#2200

#2202

#2206

#2209

#2209

#2217

#222

#2220

#2221

#2222

#2227

#2236

#2238

#2241

#2242

#2245

#2251

#2257

#2261

#2266

#2268

#2269

#2271

#2282

#2288

#2295

#2306

#2309

#2314

#2314

#232

#2321

#2322

#2324

#2327

#2328

#2330

#2332

#2336

#2339

#2339

#2340

#2342

#2343

#2344

#2352

#2362

#2363

#2365

#2367

#2369

#2370

#2371

#2374

#2376

#2379

#2379

#2380

#2385

#2386

#2391

#2392

#2395

#2401

#2409

#2409

#2411

#2411

#2416

#2423

#2432

#2435

#2439

#2445

#2449

#2450

#2450

#2459

#246

#2462

#2463

#2464

#2474

#2474

#2476

#2478

#2481

#2481

#2489

#2489

#2491

#2491

#2494

#2494

#2496

#2499

#2500

#2501

#2504

#2504

#2505

#2507

#2513

#2515

#2517

#2533

#2535

#2539

#2542

#2548

#2551

#2555

#2558

#2562

#2566

#2567

#2569

#257

#2573

#258

#258

#2581

#2583

#2585

#2587

#2590

#2593

#2598

#2598

#2600

#2600

#2603

#2607

#2607

#2609

#261

#2611

#2615

#2615

#2616

#2616

#2617

#2617

#2623

#2623

#2626

#2627

#2628

#2631

#2633

#2634

#2634

#2635

#2635

#2636

#2640

#2640

#2641

#2642

#2645

#2646

#2648

#2650

#2651

#2652

#2652

#2653

#2653

#2654

#2654

#2655

#2655

#2656

#2656

#2657

#2657

#2658

#2658

#2659

#2659

#2660

#2660

#2662

#2666

#2667

#2668

#2669

#2670

#2673

#2674

#2675

#2678

#2679

#2682

#2684

#2686

#2686

#2687

#2687

#2688

#2689

#2690

#2690

#2693

#2694

#2696

#2698

#2698

#2699

#2699

#2700

#2700

#2703

#2703

#2704

#2704

#2705

#2705

#2706

#2706

#2707

#2707

#2710

#2715

#2716

#2717

#2717

#2718

#2718

#2719

#2719

#2720

#2720

#2721

#2721

#2722

#2722

#2726

#2727

#2729

#2729

#2730

#2732

#2734

#2737

#2739

#2741

#2744

#2745

#2745

#2746

#2746

#2749

#2749

#277

#279

#280

#281

#281

#293

#293

#307

#307

#311

#311

#315

#322

#322

#324

#341

#345

#349

#353

#358

#361

#363

#363

#364

#364

#365

#367

#368

#375

#376

#377

#378

#379

#380

#381

#382

#383

#384

#385

#386

#387

#388

#389

#390

#392

#404

#407

#413

#416

#424

#426

#430

#432

#434

#437

#439

#441

#442

#443

#444

#445

#447

#449

#450

#452

#452

#458

#479

#480

#497

#500

#501

#518

#524

#529

#533

#535

#536

#539

#542

#544

#546

#546

#554

#556

#557

#559

#561

#564

#564

#571

#578

#579

#579

#589

#590

#591

#592

#595

#599

#601

#602

#603

#609

#623

#624

#627

#630

#631

#635

#644

#652

#653

#660

#663

#664

#666

#669

#672

#672

#683

#686

#688

#703

#708

#714

#719

#720

#721

#722

#725

#728

#730

#734

#737

#739

#746

#753

#763

#768

#769

#772

#783

#796

#798

#803

#809

#81

#819

#844

#848

#866

#868

#868

#869

#883

#883

#89

#890

#901

#902

#910

#927

#936

#937

#94

#941

#952

#977

#986

#994

#995

0.10

0.11

0.12

0.13

0.14

0.15

0.16

0.17

0.18

0.19

0.20

0.21

0.22

0.22.1

0.23

0.23.1

0.23.2

0.24

0.25

0.25.1

0.25.2

0.26

0.26.1

0.26.2

0.27

0.27.1

0.28

0.29

0.29.1

0.29.2

0.29.3

0.30

0.30.1

0.30.2

0.31

0.31.1

0.31.2

0.32

0.33

0.34

0.35

0.36

0.37

0.37.1

0.38

0.39

0.40

0.41

0.42

0.43

0.44

0.45

0.45a0

0.45a1

0.45a2

0.45a3

0.45a4

0.45a5

0.46

0.47

0.47.1

0.47.2

0.47.3

0.48

0.49

0.49.1

0.49a0

0.49a1

0.50

0.50.1

0.50.2

0.50a0

0.50a1

0.51

0.51.1

0.51a0

0.51a1

0.51a2

0.52

0.52.1

0.52.2

0.52.3

0.52.4

0.52.5

0.53

0.54

0.54.1

0.54a0

0.55

0.56

0.56.1

0.57

0.57.1

0.57a0

0.57a1

0.58

0.58.1

0.58a0

0.58a1

0.59

0.59.1

0.59.2

0.59.3

0.59.4

0.59a0

0.59a1

0.59a2

0.60

0.60.1

0.60.2

0.60a0

0.60a1

0.61

0.61.1

0.61a0

0.62

0.62a0

0.62a1

0.63

0.63.1

0.63.2

0.63.3

0.63a0

0.63a1

0.64

0.64.1

0.64.2

0.64.3

0.64.4

0.64.5

0.64.6

0.64.7

0.64.8

0.65

0.65.1

0.65.2

0.7

0.8

0.9

1.0a0

1.0a1

1.0a10

1.0a11

1.0a12

1.0a13

1.0a14

1.0a15

1.0a16

1.0a17

1.0a18

1.0a19

1.0a2

1.0a20

1.0a21

1.0a22

1.0a23

1.0a24

1.0a25

1.0a26

1.0a27

1.0a28

1.0a29

1.0a3

1.0a30

1.0a4

1.0a5

1.0a6

1.0a7

1.0a8

1.0a9

Mono Color

• 79cb8d6498
  Merge 2f54c2d0f6 into 316daf9a43 Ethan-kkk 2026-05-27 06:28:24 -07:00
• 22a0a4c9c8
  Merge 96b8b7f1ec into 316daf9a43 Chris Amico 2026-05-27 09:09:41 -04:00
• 9fb1cad036
  Merge 4265e4b500 into 316daf9a43 antigravkids 2026-05-27 13:13:35 +08:00
• 3523f174ef
  Merge 9d9c462a4d into 316daf9a43 Eelke van den Bos 2026-05-27 13:13:35 +08:00
• f35d71b25c
  Merge 737ff03efb into 316daf9a43 Simon Willison 2026-05-27 05:12:00 +00:00
• 737ff03efb Expanded analysis of SQL operations, refs #2748 codex/operation-sql-analysis Simon Willison 2026-05-26 22:11:06 -07:00
• 9f66cf72c1 Removed execute write SQL from query create page Simon Willison 2026-05-26 21:42:50 -07:00
• 316daf9a43
  Write SQL query UI, canned queries now stored in internal database main Simon Willison 2026-05-26 16:54:00 -07:00
• b1289a73f9 stored_queries.StoredQuery dataclass Simon Willison 2026-05-26 16:51:00 -07:00
• 2fde692a3e Disallow edits of dangerous decsription_html/on_success_message_sql Simon Willison 2026-05-26 16:34:48 -07:00
• 90e19a7d58 Docs for datasette methods for queries Simon Willison 2026-05-26 16:33:36 -07:00
• ec438496a9 Get rid of the write/is_write dual properties Simon Willison 2026-05-26 16:31:07 -07:00
• 56160e44fc Trusted queries cannot be updated using the API Simon Willison 2026-05-26 16:25:33 -07:00
• 2eb307b8c6 Changelog updates for queries branch Simon Willison 2026-05-26 16:10:05 -07:00
• 3c29b002ca Do not document unstable JSON APIs for stored queries Simon Willison 2026-05-26 16:07:53 -07:00
• cef52b1ffc Break up giant views/database.py into smaller modules Simon Willison 2026-05-26 16:06:14 -07:00
• 7214cc3761 Remove obsolete label Simon Willison 2026-05-26 15:52:44 -07:00
• d6de8e7520 Link to save query from /-/execute-write Simon Willison 2026-05-26 15:52:16 -07:00
• c3ceabae03 Ran Black Simon Willison 2026-05-26 15:51:40 -07:00
• 58e2e3a8ab Ran cog Simon Willison 2026-05-26 15:43:34 -07:00
• 1bcd99df90 Refactor code from datasette.app into datasette.stored_queries Simon Willison 2026-05-26 15:42:36 -07:00
• e89ffa0e06 Fixed broken test caused by apply_queries_config() rename Simon Willison 2026-05-26 15:37:21 -07:00
• ca4907ab6b Make _save_queries_from_config a private method Simon Willison 2026-05-26 15:30:36 -07:00
• e2864fc895 test_stored_queries.py Simon Willison 2026-05-26 15:21:09 -07:00
• cafb6b9dbd Need is_trusted=True for the counters demo Simon Willison 2026-05-26 15:20:29 -07:00
• 02a1468f1b Renamed canned queries to queries / stored queries in docs Simon Willison 2026-05-26 15:17:51 -07:00
• 56b14f37d5 The stored queries do not live in that DB Simon Willison 2026-05-26 15:16:18 -07:00
• 2f73869c09 Document that canned_queries() has been removed Simon Willison 2026-05-26 15:09:48 -07:00
• b1029acc68 top_canned_query is now top_stored_query, closes #2747 Simon Willison 2026-05-26 15:05:41 -07:00
• 4bf1c4b065 Rename canned queries to queries/stored queries in docs Simon Willison 2026-05-26 14:54:35 -07:00
• 0cadd07187 No need to document QueryCreateAnalyzeView Simon Willison 2026-05-26 14:53:31 -07:00
• 24887004cf Rename insert-query to store-query Simon Willison 2026-05-26 14:51:57 -07:00
• 180a6a86fd Remove queries-plan.md Simon Willison 2026-05-26 14:16:10 -07:00
• ac6ee097dd Disallow update/delete of private queries Simon Willison 2026-05-26 14:10:48 -07:00
• 024b911772 Clarifying comment Simon Willison 2026-05-26 14:09:53 -07:00
• f7e9dbc27e Tweaked design of create query page Simon Willison 2026-05-26 14:02:37 -07:00
• 5dca2dc9be Show query count on database page Simon Willison 2026-05-26 13:54:47 -07:00
• 6033bf8e40 Merge branch 'main' into queries Simon Willison 2026-05-26 13:51:51 -07:00
• eb7c25c57c Major redesign of create saved query UI Simon Willison 2026-05-26 13:48:40 -07:00
• 70b23ff4a5 Tweaked save query link Simon Willison 2026-05-26 13:47:24 -07:00
• 0fcaa5792b Style query operations on create query Simon Willison 2026-05-26 13:12:07 -07:00
• 71c76e3853 Better faceting on /-/queries Simon Willison 2026-05-26 13:08:19 -07:00
• 866852eff6 Clarifying comments Simon Willison 2026-05-26 12:46:18 -07:00
• 1ac4265ffd Require permissions for untrusted stored query execution, refs #2735 Simon Willison 2026-05-26 12:12:59 -07:00
• 1cd162e9da Removed some no-longer-necessary code, simplified Simon Willison 2026-05-26 12:07:30 -07:00
• 4a1a4d7807 Query is_trusted and is_private properties Simon Willison 2026-05-26 11:59:49 -07:00
• 6f1bf98d4f
  Merge 69c552f319 into de55a76d40 sergiubrega 2026-05-26 10:18:00 +00:00
• 69c552f319 fix: use double backticks for inline code formatting Sergiu Brega 2026-05-26 13:17:48 +03:00
• 17fceb7648 Add glossary of key terms to documentation Sergiu Brega 2026-05-26 12:42:40 +03:00
• 7daef14c3f
  Merge 5f83d94119 into de55a76d40 Matt Van Horn 2026-05-26 00:14:35 -07:00
• 5f83d94119
  Add content hash to JS includes (closes #2714) Matt Van Horn 2026-05-26 00:14:15 -07:00
• f1dd86ebfb Tweak URL designs of new endpoints Simon Willison 2026-05-25 14:05:26 -07:00
• 8ab8999ba9 Big visual improvement to /-/queries pages Simon Willison 2026-05-25 12:55:36 -07:00
• 4208ded249 No execute-write on immutable databases Simon Willison 2026-05-25 12:46:21 -07:00
• 1f7c26ffea Refactor to share JS/HTML between execute and execute-write Simon Willison 2026-05-25 12:45:42 -07:00
• de55a76d40
  Fix 500 error when accessing query page without ?sql= parameter (#2744) Simon Willison 2026-05-25 12:33:57 -07:00
• 59909284b8 Shorter changelog entry Simon Willison 2026-05-25 12:32:07 -07:00
• 9272290ad8
  Fix 500 on /db/-/query with no sql, closes #2743 Claude 2026-05-25 19:28:58 +00:00
• e1261442c0 Update parameters/query operations as user edits the write query Simon Willison 2026-05-25 12:08:22 -07:00
• abb17ba773 Improved the look of the parameters table Simon Willison 2026-05-25 11:42:26 -07:00
• 66bbbbc947 Support multi-line parameters on /db/-/execute-write Simon Willison 2026-05-25 11:35:09 -07:00
• 1bce34a338 If just a single insert, link to row page Simon Willison 2026-05-25 11:22:24 -07:00
• 2b5b4ed66b Much improved "Write to this database" UI Simon Willison 2026-05-25 11:11:08 -07:00
• f0b59971f7 Delete unnecessary test Simon Willison 2026-05-25 10:39:56 -07:00
• 6eee6c81e8 Add global query browser Simon Willison 2026-05-25 10:24:42 -07:00
• 310c36ae94 Limit database query preview to five Simon Willison 2026-05-25 10:18:36 -07:00
• 4a70b89355 Add cursor-paginated query browser Simon Willison 2026-05-25 10:11:46 -07:00
• 539ff9ddfc Drop query publication check from docs Simon Willison 2026-05-25 09:49:21 -07:00
• 2d07c3b99e Ran cog Simon Willison 2026-05-25 09:47:12 -07:00
• e62a5ea337 Rename query publication flag Simon Willison 2026-05-25 09:46:39 -07:00
• e0d39ba69f Store query options as JSON Simon Willison 2026-05-25 09:41:32 -07:00
• b7505a9fc2 Add execute write SQL database action Simon Willison 2026-05-25 08:49:18 -07:00
• 58ed3d9801
  Merge 9fbd31df00 into 6cafdcb6fa wheelman 2026-05-25 15:42:28 +00:00
• ef43c10388 Add arbitrary write SQL execution page Simon Willison 2026-05-25 08:30:49 -07:00
• 0093a5f643
  Merge e8417d58a4 into 6cafdcb6fa Evan Jones 2026-05-25 09:25:09 +00:00
• c7f10d41ff
  Merge ca5e52b8ed into 6cafdcb6fa Charlie Tonneslan 2026-05-25 06:18:37 +00:00
• 2d77e3334b Clean up query management test coverage Simon Willison 2026-05-24 23:06:01 -07:00
• 3b26b7aff0 Document canned query hook removal Simon Willison 2026-05-24 23:00:00 -07:00
• 040e42ddca Enforce query ownership and remove canned query hook Simon Willison 2026-05-24 22:58:50 -07:00
• 4b5fac9cf7 Add query management API and create UI Simon Willison 2026-05-24 22:52:06 -07:00
• 221be2632e Add query management actions and write analysis Simon Willison 2026-05-24 22:41:56 -07:00
• b4c63966f8 Load saved queries into permission resources Simon Willison 2026-05-24 22:40:22 -07:00
• 7e1abd0da4 Add internal query storage APIs Simon Willison 2026-05-24 22:37:34 -07:00
• daeeca6c6b Plan internal query storage and management Simon Willison 2026-05-24 22:35:18 -07:00
• a855a1acec Database.analyze_sql(sql) method Simon Willison 2026-05-24 22:29:49 -07:00
• 6cafdcb6fa
  Added missing issue reference Simon Willison 2026-05-24 21:18:50 -07:00
• 2cff3e3aa6
  Merge f8438376cc into f403ea4e53 cloudyun888 2026-05-25 03:15:29 +00:00
• c3dbdb1246
  Merge 093693edd2 into f403ea4e53 StudioCordillera 2026-05-24 23:54:20 +00:00
• f403ea4e53 No need to alias description as description Simon Willison 2026-05-24 16:47:49 -07:00
• f3a34c5012 Enable root permissions for latest.datasette.io Simon Willison 2026-05-24 15:42:49 -07:00
• 6aaed2d9b5
  2-space indent for HTML version of special JSON views Simon Willison 2026-05-24 15:28:13 -07:00
• ef5949f4b2
  Use 2-space indent for JSON on HTML versions of /-/ pages Claude 2026-05-24 22:18:09 +00:00
• 857af9293c Release 1.0a30 1.0a30 Simon Willison 2026-05-24 14:17:45 -07:00
• 312740b97c
  Keyboard navigation and ARIA attributes for actions menus (#2727) pintaste 2026-05-25 05:11:04 +08:00
• c222b26141
  Merge e870ad2074 into d11326b250 Simon Willison 2026-05-24 18:25:02 +00:00
• d11326b250
  Fixes for jump to menu accessibility Simon Willison 2026-05-24 07:55:40 -07:00
• 63a6dbd01f Fixes for jump to menu accessibility, refs #2736 Simon Willison 2026-05-23 21:58:04 -07:00
• b013aa1f7f
  Add CORS headers to /db?sql= query redirect (#2730) wheelman 2026-05-24 09:51:13 +05:30
• b9cb8e9a30 Tweaked JumpSQL changelog, refs #2731 Simon Willison 2026-05-23 21:14:35 -07:00
• a75c9f2401
  jump_items_sql() and makeJumpSections() plugin hooks (#2732) Simon Willison 2026-05-23 21:11:17 -07:00