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

#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

• 3d10633a50 fix: allow rows_where(offset=...) without limit ltsyk 2026-07-30 15:16:28 +08:00
• 5d812b920f
  Fix KeyError when passing an unrecognized string type to create_table or add_column ikatyal2110 2026-07-27 14:42:17 +00:00
• 72b7d469a4
  Fix rows_where() crash when offset is given without limit ikatyal21 2026-07-26 14:37:29 +00:00
• 6a456830ca
  Fix _decode_default_value to unescape doubled single quotes in string defaults (#811) ikatyal2110 2026-07-25 23:52:04 -05:00
• a7b734946f Changelog entry for 3.39.1 Simon Willison 2026-07-25 21:50:59 -07:00
• e7f567d764 Test for doubled single quotes in string defaults Simon Willison 2026-07-25 21:45:18 -07:00
• 1f89580a42 Disable mypy and cog in 3.x branch too 3.39.1 3.x Simon Willison 2026-07-25 17:30:34 -07:00
• 6dd6c1b2ea No flake8 or black in 3.x branch Simon Willison 2026-07-25 17:28:32 -07:00
• e1d55de8f8 Release 3.39.1 Simon Willison 2026-07-25 17:26:59 -07:00
• bf133b4825 delete_where() now commits inside a transaction, refs #815 Simon Willison 2026-07-25 17:22:17 -07:00
• c621499ed1 codespell should check sqlite_utils as well Simon Willison 2026-07-25 14:53:46 -07:00
• 69a1c0d960
  Fixes for Ruff>=0.16.0 (#814) Simon Willison 2026-07-25 14:53:12 -07:00
• 486f332d1f New Protocol for migrations to make ty happy Simon Willison 2026-07-25 14:50:45 -07:00
• c12d788304 Ran cog Simon Willison 2026-07-25 14:46:34 -07:00
• a377d69238 Fix flake E501 long lines Simon Willison 2026-07-25 14:42:54 -07:00
• 48ef55152c Fix remaining Ruff errors with GPT-5.6 Sol high Simon Willison 2026-07-25 14:39:35 -07:00
• 6ee502d127 Ignore .claude Simon Willison 2026-07-25 14:34:27 -07:00
• c0bcc04431 Automated upgrades by Ruff Simon Willison 2026-07-25 14:20:31 -07:00
• acc4fd5ac0 Move plugin directory into documentation !stable-docs ColumbusLabs 2026-07-24 16:41:13 -04:00
• eaf39c4929
  Fix progress bar stalling at ~50% for multi-byte encodings like utf-16-le Claude 2026-07-24 14:29:42 +00:00
• d7c6df6b46
  Fix _decode_default_value to unescape doubled single quotes in string defaults Claude 2026-07-23 14:38:23 +00:00
• c6a84225a2
  Fix progress bar reporting character count instead of byte count for multibyte encodings Claude 2026-07-22 14:21:31 +00:00
• 1ddc3f0400
  fix rows_from_file() crash on empty or whitespace-only input Claude 2026-07-21 14:31:28 +00:00
• bec3c3c81d
  Merge cffe30fd2f into a947dc6739 ikatyal2110 2026-07-20 09:58:43 -05:00
• cffe30fd2f
  Fix ValueTracker skipping type evaluation for empty strings Claude 2026-07-20 14:57:53 +00:00
• 58f5aeb37f
  transform: coerce empty strings to NULL when converting TEXT columns to numeric types Claude 2026-07-18 14:50:50 +00:00
• 4f4d823f1c fix: allow recipes.jsonsplit to pass through NULL values santhreal 2026-07-17 22:37:44 -07:00
• e1d0fba30f
  Strip NUL bytes from CSV input to prevent crash ikatyal2110 2026-07-17 14:35:13 +00:00
• 09f7b4d8b4
  Merge 4a4e38d0a2 into a947dc6739 ikatyal2110 2026-07-16 09:27:19 -05:00
• 4a4e38d0a2
  Catch runtime exceptions from --code, not just SyntaxError ikatyal2110 2026-07-16 14:26:18 +00:00
• 2153ee342f
  Merge 9db0308e72 into a947dc6739 fazalpsinfo-cmyk 2026-07-16 19:18:33 +05:30
• 9db0308e72 Fix en-dash rendering in install/uninstall docs by disabling smartquotes Muhamed Fazal PS 2026-07-16 19:15:54 +05:30
• 244817718c
  Merge 2370fb01e7 into a947dc6739 fazalpsinfo-cmyk 2026-07-16 19:10:59 +05:30
• 2370fb01e7 Fix en-dash rendering in install/uninstall docs Muhamed Fazal PS 2026-07-16 19:10:24 +05:30
• 9a605e058c
  Fix progress bar reporting incorrect percentage for multi-byte encodings ikatyal2110 2026-07-15 14:18:48 +00:00
• f8ca2e4347
  Merge ad77d36a55 into a947dc6739 ikatyal2110 2026-07-14 09:48:54 -05:00
• ad77d36a55
  Fix _decode_default_value returning float for negative integer defaults Claude 2026-07-14 14:48:28 +00:00
• b18796aea9
  Merge bcbda4a326 into a947dc6739 sh3ff 2026-07-14 07:34:28 +00:00
• 06bba4b3e6
  Merge 7c01b8d588 into a947dc6739 Amad Naseem 2026-07-14 00:26:34 +00:00
• 10e128e520
  Merge 10a6e82f9a into a947dc6739 Guillermo Garcia 2026-07-13 09:59:06 +00:00
• c51736edd7
  Merge 551a1173b8 into a947dc6739 Guillermo Garcia 2026-07-13 08:52:05 +00:00
• 4af18681ca Fix VACUUM with an open transaction Sanjay Santhanam 2026-07-13 00:54:42 -07:00
• a947dc6739 Changelog now links to CLI and Python API in most recent entry Simon Willison 2026-07-12 17:14:01 -07:00
• 458b3ab5b1
  Release 4.1.1 4.1.1 Simon Willison 2026-07-12 13:52:14 -07:00
• f1a490dfab
  Remove named parameters bullet from 4.1.1 release notes claude/commits-since-release-vg2zzv Claude 2026-07-12 20:49:31 +00:00
• a99c970dc0
  Release notes and version bump for 4.1.1 Claude 2026-07-12 20:35:36 +00:00
• f66ddcb215
  Transform now refuses to run inside a transaction if destructive foreign keys exist (#795) Simon Willison 2026-07-12 08:43:51 -07:00
• 4de0fe16a3
  Move Foreign keys and transactions docs to bottom of transform section Claude 2026-07-12 15:37:49 +00:00
• 44dd92a12c
  Transform now refuses to run inside a transaction if destructive foreign keys exist Claude 2026-07-12 15:17:54 +00:00
• 05b5f0fe26
  Fix transform() dropping AUTOINCREMENT from INTEGER PRIMARY KEY columns ikatyal21 2026-07-12 14:18:21 +00:00
• d714200659
  Add test: transform does not cascade-delete referencing records (#792) Simon Willison 2026-07-12 05:00:32 -07:00
• 8ca780c30d
  Apply Black claude/transform-cascade-delete-test-otfsu5 Claude 2026-07-12 11:55:08 +00:00
• 89b3724871
  Add test: transform does not cascade-delete referencing records Claude 2026-07-12 11:45:36 +00:00
• 3f0471701b
  Add cross-reference notes between CLI and Python API documentation (#791) Simon Willison 2026-07-11 21:45:21 -07:00
• f2b455ef78
  Add cross-reference notes between CLI and Python API documentation claude/cli-python-doc-links-8vzo1c Claude 2026-07-12 02:08:19 +00:00
• 5e8822efd2
  Clarify usage of named parameters in CLI documentation Simon Willison 2026-07-11 18:52:09 -07:00
• 57c1617391 Release 4.1 4.1 Simon Willison 2026-07-11 16:48:41 -07:00
• b74b727035
  .transform(strict=) and sqlite-utils transform --strict/--no-strict (#788) Simon Willison 2026-07-11 16:43:37 -07:00
• dc61f75a0b sqlite-utils upsert optional --pk in changelog Simon Willison 2026-07-11 16:42:59 -07:00
• 989729d5ed Clarify changelog to mention transform_sql() too transform-strict Simon Willison 2026-07-11 16:37:07 -07:00
• b73e0e1021 TransformError() on strict=True if SQLite does not suppor strict Simon Willison 2026-07-11 16:35:27 -07:00
• 5b9898ed9b Update _defaults["strict"] when necessary Simon Willison 2026-07-11 16:31:58 -07:00
• 7a01dd94f3 Merge branch 'main' into transform-strict Simon Willison 2026-07-11 16:29:21 -07:00
• 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