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

• 7f10b02449
  Merge 7b840e0f45 into 85b1be10c8 Dipak Chaudhari 2026-09-06 22:40:08 +05:30
• 7b840e0f45 Docs: correct what transform() does to indexes, views and triggers dchaudhari7177 2026-09-06 22:39:43 +05:30
• 80ebeddcc6
  Merge 041022ae07 into 85b1be10c8 Roli Bosch 2026-09-06 00:54:15 -04:00
• 041022ae07 docs: explain temporary storage for large database operations Rolando Bosch 2026-09-06 00:52:10 -04:00
• 25d5d46903
  Merge acc4fd5ac0 into 85b1be10c8 Columbus Labs 2026-09-04 12:10:50 -04:00
• 3189ef1f77
  Merge 9e31aeca16 into 85b1be10c8 Rami Abdelrazzaq 2026-09-04 10:04:52 +08:00
• 659eb2b81c
  Merge 18d2ef341e into 85b1be10c8 Charlie Tonneslan 2026-09-04 10:04:52 +08:00
• c84c81245e
  Merge 193a708664 into 85b1be10c8 BigNounce 2026-09-03 17:10:30 +00:00
• e452229d0a
  Merge 4af18681ca into 85b1be10c8 Sanjay Santhanam 2026-09-02 15:32:28 -07:00
• 60ba6f2af7
  Merge 37be9d43b6 into 85b1be10c8 Akshay Agrawal 2026-09-02 22:44:23 +05:30
• d37eed1d72
  Merge e74ac00a2c into 85b1be10c8 Dylan Xu 2026-09-02 03:57:12 -07:00
• cf84fcd631
  Merge 81e2ad8a44 into 85b1be10c8 ChrisJr404 2026-09-02 03:57:12 -07:00
• 89604610ac
  Merge a6dfd7a7af into 85b1be10c8 ChrisJr404 2026-09-02 03:57:12 -07:00
• 2ccb75a1d5
  Merge 7dff7ceea5 into 85b1be10c8 ChrisJr404 2026-09-02 03:57:12 -07:00
• 6b726b1cfb
  Merge 5c6eb9a4ec into 85b1be10c8 ikatyal2110 2026-09-02 03:57:12 -07:00
• 0a56a3c5a9
  Merge b0d35d2d8f into 85b1be10c8 Prince Thummar 2026-09-02 03:57:12 -07:00
• 85b1be10c8 Same fix for test-coverage.yml main Simon Willison 2026-09-01 21:39:41 -07:00
• f7e3174401 Fix for SpatialLite installation failure Simon Willison 2026-09-01 21:35:28 -07:00
• b97295271c Test against 3.15 RCs Simon Willison 2026-09-01 13:42:27 -07:00
• 085f3835ea Same fix for test-coverage.yml python-3.15-rc2 Simon Willison 2026-09-01 21:39:41 -07:00
• ef50b31a21
  Fix for SpatialLite installation failure Simon Willison 2026-09-01 21:35:28 -07:00
• ca5a8be45d Test against 3.15 RCs Simon Willison 2026-09-01 13:42:27 -07:00
• b0d35d2d8f docs: clarify transform() behavior for indexes, views and triggers (fixes #849) Prince Thummar 2026-09-01 01:41:25 +05:30
• 5c6eb9a4ec
  fix: raise NoTable from rows_where() and delete_where() for non-existent tables Claude 2026-08-29 14:33:05 +00:00
• 6bb1248afa
  docs: keep CLI flags literal in Python API references fly1d 2026-08-26 20:19:02 +08:00
• 7dff7ceea5
  Add -o/--column-order option to insert and upsert Chris (ChrisJr404) 2026-08-24 23:56:30 -04:00
• d2ccbbb911
  Merge 64336b7b6a into 56dd09702f Sai Asish Y 2026-08-23 06:50:23 +00:00
• 64336b7b6a docs: document PRAGMA temp_store for VACUUM on large databases Sai Asish Y 2026-05-21 01:58:04 -07:00
• a6dfd7a7af
  create-table --sql option for CREATE TABLE AS SELECT Chris (ChrisJr404) 2026-08-18 19:02:35 -04:00
• 81e2ad8a44
  tables and views commands accept optional table/view names Chris (ChrisJr404) 2026-08-18 06:22:20 -04:00
• e4d5609823
  Merge 7483e047b1 into 56dd09702f kostakost2 2026-08-16 01:15:44 +08:00
• 7533f39992
  Merge 625d004872 into 56dd09702f Shaurya Singh 2026-08-16 01:15:44 +08:00
• 540c8186fd
  Merge 9a605e058c into 56dd09702f ikatyal2110 2026-08-15 13:15:38 -04:00
• ef2c9766bd
  Merge e1d0fba30f into 56dd09702f ikatyal2110 2026-08-15 13:15:38 -04:00
• ad21d76309
  Merge c6a84225a2 into 56dd09702f ikatyal2110 2026-08-15 13:15:38 -04:00
• f2ed7eaec3
  Merge eaf39c4929 into 56dd09702f ikatyal2110 2026-08-15 13:15:38 -04:00
• e74ac00a2c docs: keep literal --convert and --functions in install docs jennifferweslowski-design 2026-08-14 12:08:47 +00:00
• 56dd09702f Run no-default-groups smoke test from Justfile Simon Willison 2026-08-13 17:01:47 -07:00
• 28dc6278cc Release 4.2.1 4.2.1 Simon Willison 2026-08-13 16:52:30 -07:00
• f6d73112c8
  Fix for sqlite-utils 4.2 crashing bug (#843) Simon Willison 2026-08-13 16:52:03 -07:00
• bcf8b564ee Only run uv smoke test on Ubuntu sqlite-utils-test-no-dev Simon Willison 2026-08-13 16:46:31 -07:00
• 829aa1438c Remove from typing_extensions import Self, refs #842 Simon Willison 2026-08-13 16:38:58 -07:00
• d7b39f7393 install uv first Simon Willison 2026-08-13 16:39:38 -07:00
• 8541829c2d Revert "Remove from typing_extensions import Self, refs #842" Simon Willison 2026-08-13 16:39:19 -07:00
• cf6a12568b Remove from typing_extensions import Self, refs #842 Simon Willison 2026-08-13 16:38:58 -07:00
• c9d8a12a7e Test that should fail Simon Willison 2026-08-13 16:37:06 -07:00
• 1d98613f28 Release 4.2 4.2 Simon Willison 2026-08-13 13:09:42 -07:00
• e4935e0644
  transform: coerce empty strings to NULL when converting TEXT columns to numeric types (#805) ikatyal2110 2026-08-13 14:56:51 -05:00
• 30b4a8cb0c Document empty-string numeric transforms Simon Willison 2026-08-13 10:58:20 -07:00
• 368964e003 Merge remote-tracking branch 'origin/main' into fix/transform-empty-string-to-null Simon Willison 2026-08-13 11:23:51 -07:00
• 4fd34b85ad
  Fix count_where() raising OperationalError on nonexistent tables Claude 2026-08-13 16:40:55 +00:00
• 75ba588462 Preserve composite UNIQUE constraints in transforms Simon Willison 2026-08-12 18:46:18 -07:00
• 2b52b5ed6f Preserve AUTOINCREMENT through transforms Simon Willison 2026-08-12 18:39:00 -07:00
• fcfccea813 Support ANY column types for strict tables Simon Willison 2026-08-12 16:43:33 -07:00
• 57192ef4e3 table.transform(rename=...) now preserves indexes, closes #822 Simon Willison 2026-08-12 14:42:24 -07:00
• e4784ec120 Changelog updates Simon Willison 2026-08-12 14:38:20 -07:00
• 88b48fa167 Fixed introspection of default values TRUE / FALSE / NULL Simon Willison 2026-08-12 14:19:30 -07:00
• e6be6267a4
  Use quote_identifier() in indexes/xindexes PRAGMA statements (#825) nyxst4ck 2026-08-12 18:15:17 -03:00
• c5063f67b1 Use quoted SQL identifiers in convert --dry-run, closes #829 Simon Willison 2026-08-12 14:14:27 -07:00
• fc2dcfca36 Merge remote-tracking branch 'origin/main' into fix/convert-dryrun-quote-identifier fix/convert-dryrun-quote-identifier Simon Willison 2026-08-12 14:07:24 -07:00
• 25c632fbbc
  Handle empty input in rows_from_file Rami Abdelrazzaq 2026-08-12 16:05:09 -05:00
• ebb04a97de Fixes for Pyright, closes #833 Simon Willison 2026-08-12 13:41:33 -07:00
• 38fe466700 Use db.table() and db.view() in tests, closes #838 Simon Willison 2026-08-12 13:40:55 -07:00
• 66aee7979c Fixes for Pyright, closes #833 codex/fix-issue-833-type-annotations Simon Willison 2026-08-12 13:41:33 -07:00
• 99fd585daf Use db.table() and db.view() in tests, closes #838 Simon Willison 2026-08-12 13:40:55 -07:00
• b143fc4913 Handle empty input in rows_from_file Rami Abdelrazzaq 2026-08-12 13:06:25 -05:00
• 43d5d3331f
  Emit LIMIT -1 when offset is used without limit (#821) ethanhawkes-gif 2026-08-12 01:52:43 -04:00
• 565cd4fa62 Remove duplicate comments Simon Willison 2026-08-11 22:52:10 -07:00
• 2d3c6b9a1e
  Escape tokenize argument in enable_fts (#828) Bunlong Heng 2026-08-12 01:48:06 -04:00
• b37b8cf8c8 Preserve column before/after comments through .transform() Simon Willison 2026-08-11 22:37:13 -07:00
• b432e686ca Use sqlite_master not sqlite_schema for older SQLite compatibility Simon Willison 2026-08-11 22:02:28 -07:00
• 2303b80aef .transform() preserves check constraints, refs #762 Simon Willison 2026-08-11 21:59:57 -07:00
• 3db0c57a3b table.checks, table.column_checks, table.table_checks, closes #834 Simon Willison 2026-08-11 21:58:00 -07:00
• 2d4d6c26e6
  Merge 5d812b920f into f726ea4a65 ikatyal2110 2026-08-11 22:39:36 -07:00
• 36e36dcd3f Preserve column before/after comments through .transform() transform-check-constraints Simon Willison 2026-08-11 22:37:13 -07:00
• 9db7578cde Use sqlite_master not sqlite_schema for older SQLite compatibility Simon Willison 2026-08-11 22:02:28 -07:00
• 1ac90b4dad .transform() preserves check constraints, refs #762 Simon Willison 2026-08-11 21:59:57 -07:00
• 4cc0418816 table.checks, table.column_checks, table.table_checks, closes #834 Simon Willison 2026-08-11 21:58:00 -07:00
• f726ea4a65
  transform() now works for tables referenced by views (#832) Simon Willison 2026-08-11 20:48:11 -07:00
• b8ed80bf5d Skip legacy_alter_table restore test on SQLite < 3.25 Simon Willison 2026-08-06 22:21:21 -07:00
• 4b66d515a3 Restore previous legacy_alter_table value after transform Simon Willison 2026-08-06 22:15:57 -07:00
• 8f264e8d2a transform() now works for tables referenced by views Simon Willison 2026-08-06 22:08:37 -07:00
• b8f0cb5a6c Fix convert --dry-run using bracket quoting instead of quote_identifier() ikatyal2110 2026-08-06 21:03:31 +05:30
• 83f9a1e317 Escape tokenize argument in enable_fts to prevent SQL injection Bunlong Heng 2026-08-06 09:19:17 -04:00
• fe5260e47e Make tables in attached/temp schemas first-class (issue #432) Parker Gurney 2026-08-05 14:38:20 -07:00
• 816028b169 Add Database(json_default=, json_object_hook=) for custom JSON encoding/decoding Parker Gurney 2026-08-05 14:35:25 -07:00
• 064625da59 Add opt-in Database(deserialize_json=True) to parse JSON strings back into dict/list on read Parker Gurney 2026-08-05 14:23:56 -07:00
• d4d075c924 Add --extract option to insert/upsert commands Parker Gurney 2026-08-05 14:22:45 -07:00
• f34dfb25da Auto-decode columns declared as JSON in output modes (issue #579) Parker Gurney 2026-08-05 14:18:25 -07:00
• c989cdf5a2 Fix dishonest progress accounting for multi-byte encoded CSV input (#439) Parker Gurney 2026-08-05 14:18:18 -07:00
• 050f11f31f Add --transpose/-x option to rows, query, memory and search for wide records Parker Gurney 2026-08-05 14:16:09 -07:00
• f6d83ec8be insert-files: add --convert/--import to transform rows during import Parker Gurney 2026-08-05 14:15:20 -07:00
• daf2ebbbaf insert-files: add --sqlar flag and content_sqlar column for sqlar-compatible compressed payloads Parker Gurney 2026-08-05 14:11:30 -07:00
• 6a2e941863 Add --key option to insert/upsert/bulk for importing JSON lists nested under a top-level key Parker Gurney 2026-08-05 14:10:18 -07:00
• 74c7038b8b Add rows_to_csv() Python API helper for writing rows as CSV (issue #580) Parker Gurney 2026-08-05 14:08:10 -07:00
• 71664b8fcf insert-files: support fixed value columns via -c colname:text:value Parker Gurney 2026-08-05 14:06:58 -07:00
• d5dabe6627 Use quote_identifier() in indexes/xindexes PRAGMA statements nyxst4ck 2026-08-05 00:26:04 -03:00
• 95826535c7
  Fix transform() raising TransformError when renaming an indexed column Claude 2026-08-02 14:38:05 +00:00
• a8b3a80aec Emit LIMIT -1 when offset is used without limit, closes #816 ethanhawkes-gif 2026-08-01 16:03:44 -04:00
• 7c182f5afa
  Fix transform() corrupting ANY columns on STRICT tables to REAL ikatyal21 2026-07-31 15:58:59 +00:00