Commit graph

Select branches

Hide pull requests

3-10-dev

3.15-dev

3.x

add-foreign-keys

analyze

analyze-table

analyze-tables-options

atomic

auto-key

autodoc

buildjet-16vcpu-ubuntu-2204

bulk

claude/4-0-release-review-nrt5l4

claude/add-json-insert-support-ECtzG

claude/add-type-hints-07PAy

claude/cli-python-doc-links-8vzo1c

claude/commits-since-release-vg2zzv

claude/custom-json-serialization-01BDiG528eJwG6jvpfKum6sc

claude/datasette-tests-mown-2uaqtt

claude/db-query-transaction-bugs-ie30fn

claude/investigate-transform-fk-KMTZ7

claude/sqlite-autocommit-compat-q74bs0

claude/transform-cascade-delete-test-otfsu5

click-default-group-wheel

codex/fix-issue-833-type-annotations

codex/pr-719-plugin-loading

compound-foreign-keys-594

convert

copilot/skip-ty-step-python-3-14

create-table-parser

create-transform

deregister-functions

empty-list

extract-expand

fast-mode

fix-travis

fix/convert-dryrun-quote-identifier

fix_for_pragma

fts5

get

index-foreign-keys

insert-files-text

insert-lists

introspect-triggers

lookup

main

monkeytype

mypy

numpy-pandas

numpy2

pyproject

pysqlite3-ci

python-2.7

python-3.12

python-3.15-rc2

python-3.9

python-38-travis

real-upsert

release-1.12.1

say-5/document-memory-attrs

sqlite-utils-test-no-dev

table-extracts

test-3.10-dev

test-travis-sqlite-version

too-many-sql

transform-check-constraints

transform-strict

travis-3.5

travis-bionic

trogon

update

update-get

views

windows-ci

wip-cli-csv-extras

#1

#118

#12

#120

#142

#146

#151

#156

#158

#161

#166

#174

#178

#184

#189

#190

#195

#203

#204

#208

#224

#225

#233

#241

#241

#244

#245

#247

#254

#258

#262

#273

#277

#293

#303

#312

#32

#321

#322

#324

#326

#327

#330

#333

#337

#34

#347

#347

#361

#367

#377

#38

#385

#4

#40

#407

#410

#419

#429

#437

#45

#452

#455

#457

#460

#462

#463

#465

#466

#468

#47

#473

#480

#486

#498

#499

#499

#5

#508

#51

#515

#519

#526

#528

#53

#531

#536

#537

#546

#549

#55

#553

#56

#560

#57

#573

#584

#591

#593

#596

#598

#60

#600

#604

#609

#615

#617

#618

#619

#623

#623

#628

#630

#631

#631

#634

#637

#639

#64

#640

#647

#649

#649

#65

#653

#654

#658

#663

#665

#668

#67

#670

#670

#671

#673

#676

#678

#680

#681

#683

#685

#689

#690

#691

#693

#695

#696

#697

#698

#698

#700

#701

#701

#703

#703

#706

#706

#707

#708

#709

#710

#714

#715

#716

#717

#718

#719

#72

#720

#721

#722

#723

#723

#724

#724

#725

#725

#726

#726

#729

#730

#731

#733

#734

#735

#736

#737

#737

#738

#739

#740

#741

#742

#742

#743

#743

#744

#744

#745

#746

#747

#747

#748

#748

#749

#75

#750

#751

#753

#754

#756

#757

#764

#766

#767

#768

#770

#772

#773

#775

#776

#777

#779

#78

#780

#782

#784

#784

#785

#786

#788

#791

#792

#793

#795

#797

#798

#798

#799

#799

#80

#800

#800

#801

#801

#802

#802

#803

#803

#804

#804

#805

#806

#807

#807

#809

#810

#810

#811

#812

#812

#813

#813

#814

#817

#818

#818

#819

#820

#821

#823

#825

#826

#827

#828

#830

#832

#835

#837

#839

#840

#843

#844

#844

#845

#845

#846

#846

#847

#847

#848

#850

#850

#851

#851

#852

#853

#853

#854

#854

#855

#855

#856

#856

#858

#858

#859

#859

#860

#860

#861

#861

#862

#862

#863

#863

#864

#864

#865

#865

#866

#866

#867

#867

#868

#868

#869

#869

#9

#96

0.10

0.11

0.12

0.13

0.14

0.2

0.3

0.3.1

0.4

0.5

0.6

0.6.1

0.7

0.8

0.8.1

0.9

1.0

1.0.1

1.1

1.10

1.11

1.12

1.12.1

1.2

1.2.1

1.2.2

1.3

1.4

1.4.1

1.5

1.6

1.7

1.7.1

1.8

1.9

2.0

2.0.1

2.1

2.10

2.10.1

2.11

2.12

2.13

2.14

2.14.1

2.15

2.15.1

2.16

2.16.1

2.17

2.18

2.19

2.2

2.2.1

2.20

2.21

2.22

2.23

2.3

2.3.1

2.4

2.4.1

2.4.2

2.4.3

2.4.4

2.5

2.6

2.7

2.7.1

2.7.2

2.8

2.9

2.9.1

3.0

3.0a0

3.1

3.1.1

3.10

3.11

3.12

3.13

3.14

3.15

3.15.1

3.16

3.17

3.17.1

3.18

3.19

3.19a0

3.2

3.2.1

3.20

3.21

3.22

3.22.1

3.23

3.24

3.25

3.25.1

3.26

3.26.1

3.27

3.28

3.29

3.3

3.30

3.31

3.32

3.32.1

3.33

3.34

3.35

3.35.1

3.35.2

3.36

3.37

3.38

3.38a0

3.39

3.39.1

3.4

3.4.1

3.5

3.6

3.7

3.8

3.9

3.9.1

4.0

4.0a0

4.0a1

4.0rc1

4.0rc2

4.0rc3

4.0rc4

4.1

4.1.1

4.2

4.2.1

Mono Color

• 6531a57863 Delete obsolete test_memory_attribute_for_existing_connection test Simon Willison 2026-07-11 16:28:36 -07:00
• 0f2d525d06 Clarify transaction documentation Simon Willison 2026-07-11 16:20:37 -07:00
• 8c50b1e5dd .transform(strict=) and sqlite-utils transform --strict/--no-strict Simon Willison 2026-07-11 12:28:55 -07:00
• 625d004872
  Fix progress bar against non-UTF-8 encodings LeSingh1 2026-05-18 16:29:36 -07:00
• 4d6d51ad02
  Fix .transform() raising TransformError on column-level UNIQUE constraints Claude 2026-07-09 22:35:55 +00:00
• adfcbb4731
  Support sqlite3.connect(autocommit=False) connections too claude/sqlite-autocommit-compat-q74bs0 Claude 2026-07-09 22:06:46 +00:00
• 887c6543ee
  Support sqlite3.connect(autocommit=True) connections Claude 2026-07-09 05:19:01 +00:00
• d70c0e16a0 Fix transform to convert empty strings to NULL when changing column to integer or float type ikatyal21 2026-07-08 17:21:43 -05:00
• 7c01b8d588 Allow SQLITE_MAX_VARS to be customized via Database(sqlite_max_vars=...) Amad Naseem 2026-07-08 13:53:04 +05:00
• 7a52214624 drop-index command and table.drop_index(index_name) Simon Willison 2026-07-07 21:00:43 -07:00
• d302835d57 feat(db): document and test Database.memory and Database.memory_name Sai Asish Y 2026-05-13 11:55:13 -07:00
• eee6c49547
  Merge branch 'main' into say-5/document-memory-attrs Simon Willison 2026-07-07 19:35:27 -07:00
• e38d701fb1 Merge remote-tracking branch 'origin/main' into say-5/document-memory-attrs say-5/document-memory-attrs Simon Willison 2026-07-07 19:34:36 -07:00
• d2ac3765ed sqlite-utils insert/upsert --type colunm-name type option, closes #131 Simon Willison 2026-07-07 19:17:29 -07:00
• 092f0919c3 Changelog tweak refs #684 Simon Willison 2026-07-07 18:57:27 -07:00
• 569608e40f sqlite-utils insert --code option, closes #684 Simon Willison 2026-07-07 18:48:57 -07:00
• 23a21c1d6b Ran Black Simon Willison 2026-07-07 18:11:34 -07:00
• ebafb84c93 Allow sqlite-utils upsert to infer --pk from existing table Simon Willison 2026-07-07 18:09:12 -07:00
• aa300942bf Update sqlite-utils convert --help, refs #686 Simon Willison 2026-07-07 18:03:25 -07:00
• cf3373e7b7 Refactor --functions option, improve help Simon Willison 2026-07-07 17:59:58 -07:00
• 8ee0b7c65c Fix for rogue quote in enable-fts --help Simon Willison 2026-07-07 17:57:29 -07:00
• fa5d66bf53 Update create-table --help to mention real Simon Willison 2026-07-07 17:56:57 -07:00
• 619770bf42 sqlite-utils query - to read SQL from stdin, closes #765 Simon Willison 2026-07-07 17:52:26 -07:00
• 353baf280d Corrected imports in migrations docs Simon Willison 2026-07-07 11:51:53 -07:00
• 8bc9213a8e Release 4.0 4.0 Simon Willison 2026-07-07 08:40:31 -07:00
• 60811e7305
  Fix rowid pk and last_rowid regressions in insert/upsert Simon Willison 2026-07-07 08:24:24 -07:00
• d53e3cbb89
  Add tests for ignored-insert last_pk/last_rowid fallback paths claude/datasette-tests-mown-2uaqtt Claude 2026-07-07 15:11:54 +00:00
• f9554d36e4
  Apply black formatting Claude 2026-07-07 15:03:27 +00:00
• 46db18e5ab
  Fix rowid pk and last_rowid regressions in insert/upsert Claude 2026-07-07 14:57:43 +00:00
• 4949933917 refactor: built-in name shadowing in jsonsplit signature tomaioo 2026-07-06 23:10:15 -07:00
• d314d04215 Bump GitHub Actions versions Simon Willison 2026-07-06 22:40:37 -07:00
• d34f1bea0b Release 4.0rc4 4.0rc4 Simon Willison 2026-07-06 22:33:50 -07:00
• 9a2c582465 README tweak ready for v4, refs #769 Simon Willison 2026-07-06 22:26:58 -07:00
• e5c772823f
  Fixes for final review in issue #769 Simon Willison 2026-07-06 22:21:59 -07:00
• 2582446784 Skip RETURNING-based trigger test on SQLite older than 3.35 Simon Willison 2026-07-06 22:06:51 -07:00
• d9a0fd26e0 Transaction cleanup no longer masks transaction-destroying errors Simon Willison 2026-07-06 22:04:00 -07:00
• c2a1774409 Fix two tests that assumed modern SQLite behavior Simon Willison 2026-07-06 22:02:41 -07:00
• 93640a7dde migrate --list is read-only with legacy sqlite-migrate classes too Simon Willison 2026-07-06 21:58:52 -07:00
• 548a886ca1 Clean CLI errors for InvalidColumns from insert --pk and extract Simon Willison 2026-07-06 21:57:14 -07:00
• 8572d1e39c extract() no longer duplicates NULL-containing rows in shared lookups Simon Willison 2026-07-06 21:55:21 -07:00
• 16bbfb582d add_foreign_keys() errors instead of silently dropping action changes Simon Willison 2026-07-06 21:53:48 -07:00
• a0387791e5 ensure_autocommit_on() raises TransactionError inside a transaction Simon Willison 2026-07-06 21:51:31 -07:00
• b3aa3f47b7 migrate --stop-before an already-applied migration is now an error Simon Willison 2026-07-06 21:50:05 -07:00
• 3de8507c6b insert(pk=, alter=True) can add the pk column from records again Simon Willison 2026-07-06 21:47:59 -07:00
• 884574685f insert/upsert --csv no longer rewrites column types of existing tables Simon Willison 2026-07-06 21:44:56 -07:00
• 1ed95e4ad2 Fix pks_and_rows_where() on views Simon Willison 2026-07-06 21:42:02 -07:00
• 29ca9d27e2 foreign_keys= accepts mixed ForeignKey objects, tuples and strings again Simon Willison 2026-07-06 21:37:56 -07:00
• 404e935b63 ForeignKey is now a frozen dataclass, restoring hashability Simon Willison 2026-07-06 21:35:45 -07:00
• 8e015d024c Compound primary keys now resolve in PRIMARY KEY declaration order Simon Willison 2026-07-06 21:34:02 -07:00
• 66934918c6 Document that rejected write PRAGMAs in db.query() still take effect Simon Willison 2026-07-06 21:30:47 -07:00
• adc10df981 Fix for db.query("; COMMIT") bypasses the first-token scanner Simon Willison 2026-07-06 21:22:29 -07:00
• 7d86118168 Fix failed db.execute() write leaves a phantom transaction open Simon Willison 2026-07-06 21:19:20 -07:00
• f2fbcf60d8 --no-headers fix in changelog, refs #566 Simon Willison 2026-07-06 21:03:15 -07:00
• 2616dec795 .extract() and .lookup() no longer extract null values, closes #186 Simon Willison 2026-07-06 20:39:29 -07:00
• b8aa136857 Remove beanbag-docutils - we stopped needing that in 5f81752 Simon Willison 2026-07-06 20:37:02 -07:00
• 221774f25a Fix for table.insert(..., pk=..., ignore=True), closes #554 Simon Willison 2026-07-06 20:22:08 -07:00
• 6225eba5c8 Raise InvalidColumns on insert(pk="invalid") Simon Willison 2026-07-06 20:13:52 -07:00
• 815b6a7d3d
  JSON output no longer escapes non-ASCII characters, new --ascii option (#777) Simon Willison 2026-07-06 11:10:07 -07:00
• 823b334a59
  Document JSON unicode change in Unreleased changelog section Claude 2026-07-06 18:03:33 +00:00
• 684dd2bf2b
  JSON output no longer escapes non-ASCII characters, new --ascii option Claude 2026-07-06 18:02:36 +00:00
• d516e58543
  Honor --no-headers for --fmt and --table output (#566) (#751) Johnson K C 2026-07-06 09:54:17 -07:00
• 5f81752cf5 Fix for frustrating error in 'just docs' locally Simon Willison 2026-07-05 23:19:40 -07:00
• af3894a096 Changelog headings for 4.0rc3 Simon Willison 2026-07-05 23:19:00 -07:00
• d1f5e06816 Add subheadings to 4.0rc3 release notes Simon Willison 2026-07-05 23:12:54 -07:00
• 3e8b7403a2 Release 4.0rc3 4.0rc3 Simon Willison 2026-07-05 22:35:35 -07:00
• a4acc3958c
  Fix transform() corrupting TRUE/FALSE/NULL column defaults into strings Vincent Gao 2026-07-06 07:33:55 +02:00
• d5056fe3c9 Changelog entry for #764 Simon Willison 2026-07-05 22:28:45 -07:00
• 750686c6d1 Merge branch 'main' into fix-transform-keyword-literal-defaults Simon Willison 2026-07-05 22:26:33 -07:00
• ddd5373735 Fix for test_table_default_values Simon Willison 2026-07-05 22:22:33 -07:00
• 77d241959c Match column names case-insensitively, closes #760 Simon Willison 2026-07-05 22:11:22 -07:00
• 50938ee6f8
  Rename ensure_autocommit_off() to ensure_autocommit_on(), closes #705 Simon Willison 2026-07-05 21:54:30 -07:00
• 6df6da1a8e Rename ensure_autocommit_off() to ensure_autocommit_on(), closes #705 Simon Willison 2026-07-05 21:50:20 -07:00
• 02281f77ed
  Vendor SQLite version setup action (#775) Simon Willison 2026-07-05 21:42:22 -07:00
• 518dec1b4f Vendor SQLite version setup action Simon Willison 2026-07-05 21:33:13 -07:00
• 07b603e562
  Preserve duplicate column names in query results Simon Willison 2026-07-05 21:20:39 -07:00
• 4a03fe6d8a Preserve duplicate column names in query results, closes #624 Simon Willison 2026-07-05 16:15:50 -07:00
• a00ed60efc Apply Black to tests/test_gis.py Simon Willison 2026-07-05 21:17:41 -07:00
• afbfd95273
  Remove sqlean.py support (#772) Simon Willison 2026-07-05 16:00:52 -07:00
• a47dac2020 Remove sqlean.py support Simon Willison 2026-07-05 15:55:44 -07:00
• 9a3936531d
  Compound foreign key support (PR #770) Simon Willison 2026-07-05 15:54:44 -07:00
• 0ec0180405 add_foreign_key() on_delete= and on_update= parameters, closes #530 compound-foreign-keys-594 Simon Willison 2026-07-05 15:49:20 -07:00
• 658185d297 Fix compound foreign key test failure against sqlean Simon Willison 2026-07-05 15:46:16 -07:00
• 5b61530965 db.add_foreign_keys() no longer drops ON DELETE/ON UPDATE actions Simon Willison 2026-07-05 15:42:41 -07:00
• 2f599fc7c6 Run ty in just lint, matching CI Simon Willison 2026-07-05 15:38:05 -07:00
• 8dfbfa80b8 Fix ty errors in transform_sql foreign key closures Simon Willison 2026-07-05 15:36:46 -07:00
• d100264e9c Normalize compound foreign key columns to tuples, promote tuples in docs Simon Willison 2026-07-05 15:10:21 -07:00
• c16edb2dc4 Better type signatures for compound foreign key columns Simon Willison 2026-07-05 15:03:23 -07:00
• 42c1dd0d5f Documentation for compound foreign key support, refs #594 Simon Willison 2026-07-05 14:45:08 -07:00
• 8443d7f3ba Resolve implicit primary key references in table.foreign_keys Simon Willison 2026-07-05 14:42:30 -07:00
• be27a96484 Capture and preserve foreign key ON DELETE/ON UPDATE actions Simon Willison 2026-07-05 14:40:57 -07:00
• b75edf4b30 add_foreign_key() accepts compound keys, composite FK indexes, refs #594 Simon Willison 2026-07-05 14:37:32 -07:00
• 7d43fd50e1 transform() now round-trips compound foreign keys, refs #594 Simon Willison 2026-07-05 14:33:15 -07:00
• 577f3011e5 Create tables with compound foreign keys, refs #594 Simon Willison 2026-07-05 14:30:41 -07:00
• d5bf51df35 Fix TypeError when sorting mixed compound/single foreign keys Simon Willison 2026-07-05 14:26:56 -07:00
• f10459cffb table.foreign_keys now handles compound foreign keys, refs #594 Simon Willison 2026-07-05 13:59:25 -07:00
• 623331b3f4 Fix for test failure against sqlean Simon Willison 2026-07-05 12:16:11 -07:00
• 61619498fa Give db.query() SQL restrictions top billing in upgrading docs Simon Willison 2026-07-05 11:50:10 -07:00
• 87cf1c5a00 Replace SQL prefix matching with a first-token scanner Simon Willison 2026-07-05 11:49:59 -07:00
• a8e3a643f2 Release 4.0rc2 4.0rc2 Simon Willison 2026-07-04 17:45:42 -07:00
• 0566a9f128
  Improve db.query() error handling and transaction safety Simon Willison 2026-07-04 17:40:48 -07:00