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/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_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.9

python-38-travis

real-upsert

release-1.12.1

say-5/document-memory-attrs

table-extracts

test-3.10-dev

test-travis-sqlite-version

too-many-sql

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

#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

#708

#709

#710

#714

#714

#715

#716

#717

#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

#740

#741

#742

#742

#743

#743

#744

#744

#745

#746

#746

#747

#747

#748

#748

#749

#749

#75

#750

#751

#753

#754

#756

#757

#764

#766

#766

#767

#768

#770

#772

#773

#775

#776

#777

#779

#78

#780

#782

#784

#784

#785

#785

#786

#786

#788

#791

#792

#793

#793

#795

#797

#798

#798

#799

#799

#80

#800

#800

#801

#801

#802

#802

#803

#803

#804

#804

#805

#805

#806

#806

#807

#807

#809

#809

#810

#810

#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.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

Mono Color

• 5595a1a66b
  Merge c6a84225a2 into a947dc6739 ikatyal2110 2026-07-22 09:22:01 -05:00
• c6a84225a2
  Fix progress bar reporting character count instead of byte count for multibyte encodings Claude 2026-07-22 14:21:31 +00:00
• 1d68563356
  Merge 1ddc3f0400 into a947dc6739 ikatyal2110 2026-07-21 09:31:54 -05: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
• 6b5b03fd81
  Merge 4f4d823f1c into a947dc6739 Santh 2026-07-18 16:17:06 -07:00
• 33a7a1dcb3
  Merge 58f5aeb37f into a947dc6739 ikatyal2110 2026-07-18 09:51:16 -05:00
• 58f5aeb37f
  transform: coerce empty strings to NULL when converting TEXT columns to numeric types Claude 2026-07-18 14:50:50 +00:00
• ca9647c1ee
  Merge 4e5f4ef176 into a947dc6739 Sai Asish Y 2026-07-18 13:46:51 +00:00
• 4e5f4ef176 docs: document PRAGMA temp_store for VACUUM on large databases Sai Asish Y 2026-05-21 01:58:04 -07:00
• 4f4d823f1c fix: allow recipes.jsonsplit to pass through NULL values santhreal 2026-07-17 22:37:44 -07:00
• 5b6bddeb9d
  Merge e1d0fba30f into a947dc6739 ikatyal2110 2026-07-17 09:56:25 -05:00
• e1d0fba30f
  Strip NUL bytes from CSV input to prevent crash ikatyal2110 2026-07-17 14:35:13 +00:00
• f70b1fe938
  Merge b330cf6d92 into a947dc6739 Rami Abdelrazzaq 2026-07-17 16:04:06 +03: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
• 48ff506787
  Merge 40d24465cb into a947dc6739 Sai Asish Y 2026-07-15 20:09:00 +00:00
• df7174aab6
  Merge 9a605e058c into a947dc6739 ikatyal2110 2026-07-15 09:19:15 -05:00
• 9a605e058c
  Fix progress bar reporting incorrect percentage for multi-byte encodings ikatyal2110 2026-07-15 14:18:48 +00:00
• f22e93675a
  Merge 625d004872 into a947dc6739 Shaurya Singh 2026-07-14 12:54:50 -07:00
• fa679000f2
  Merge 7483e047b1 into a947dc6739 kostakost2 2026-07-14 18:11:20 +00:00
• e770bfdd2b
  Merge 9e31aeca16 into a947dc6739 Rami Abdelrazzaq 2026-07-14 15:17:47 +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
• 62066bfe6a
  Merge 37be9d43b6 into a947dc6739 Akshay Agrawal 2026-07-14 03:50:29 +00:00
• 06bba4b3e6
  Merge 7c01b8d588 into a947dc6739 Amad Naseem 2026-07-14 00:26:34 +00:00
• b282f955b1
  Merge 193a708664 into a947dc6739 BigNounce 2026-07-13 15:40:47 +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
• 6131719c14
  Merge 4af18681ca into a947dc6739 Sanjay Santhanam 2026-07-13 00:55:25 -07:00
• 4af18681ca Fix VACUUM with an open transaction Sanjay Santhanam 2026-07-13 00:54:42 -07:00
• c276aa55d2
  Merge d70c0e16a0 into a947dc6739 ikatyal2110 2026-07-12 21:36:19 -05:00
• de6a4a2e9d
  Merge 05b5f0fe26 into a947dc6739 ikatyal2110 2026-07-12 21:36:16 -05:00
• a947dc6739 Changelog now links to CLI and Python API in most recent entry main 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
• be974c22d4
  Merge 4d6d51ad02 into 6531a57863 ikatyal2110 2026-07-11 16:38:57 -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
• 114c7b59de
  Merge 18d2ef341e into 7a52214624 Charlie Tonneslan 2026-07-09 20:47:26 -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