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

• ab98af9ed0
  db.query() rejected statements roll back, RETURNING commits immediately claude/db-query-transaction-bugs-ie30fn Claude 2026-07-05 00:18:15 +00:00
• 04f8971546
  Merge changes based on a Fable review of 4.0rc1 Simon Willison 2026-07-04 16:36:13 -07:00
• 7a015cff52
  Unwrap hard-wrapped prose in the documentation claude/4-0-release-review-nrt5l4 Claude 2026-07-04 23:33:38 +00:00
• 89af511f79
  Also run "pytest --sqlite-autocommit" for one matrix item in CI Simon Willison 2026-07-04 16:24:07 -07:00
• b49af65a6d
  Fix PytestRemovedIn10Warning in test_sniff Claude 2026-07-04 23:20:31 +00:00
• 2510745de4
  Add --sqlite-autocommit pytest option Claude 2026-07-04 23:19:51 +00:00
• f7ff3e2027
  db.execute() write statements now commit automatically Claude 2026-07-04 23:15:01 +00:00
• bcd9a26560
  Reject Python 3.12+ autocommit connections in the Database constructor Claude 2026-07-04 22:38:31 +00:00
• 96793668ed
  Raise TransactionError instead of RuntimeError from enable_wal/disable_wal Claude 2026-07-04 22:32:36 +00:00
• 788c393a30
  Add db.begin(), db.commit() and db.rollback() methods Claude 2026-07-04 22:31:22 +00:00
• 6c88067ab7
  Explain why the Database context manager rolls back instead of committing Claude 2026-07-04 22:25:28 +00:00
• ff76fb7740
  Clarify that db.atomic() is fine inside transactional migrations Claude 2026-07-04 22:20:37 +00:00
• 0fca5908c1
  Group the Unreleased changelog into breaking changes and everything else Claude 2026-07-04 22:19:47 +00:00
• adea475a61
  Remove View.enable_fts() Claude 2026-07-04 20:44:04 +00:00
• 70055d7432
  Document the transaction model as a first-class concept Claude 2026-07-04 20:16:15 +00:00
• 509d87b292
  Remove review notes files Claude 2026-07-04 19:56:42 +00:00
• 910a90970d
  Add upgrading guide to the documentation Claude 2026-07-04 19:21:34 +00:00
• a2e6ea2eca
  Raise ValueError instead of AssertionError for invalid arguments Claude 2026-07-04 19:19:24 +00:00
• f1cdceaca9
  Remove the no-op -d/--detect-types flag from insert and upsert Claude 2026-07-04 19:15:31 +00:00
• 397cdcc491
  Polish: clearer errors, corrected docstrings, setuptools pin Claude 2026-07-04 19:13:15 +00:00
• 30cc95c0a6
  migrate --list is now read-only Claude 2026-07-04 19:10:56 +00:00
• 0bad21280f
  migrate --stop-before: validate names and fix legacy compatibility Claude 2026-07-04 19:08:53 +00:00
• fd867282b3
  Document atomic() deferred BEGIN, savepoint behavior and connection modes Claude 2026-07-04 19:06:44 +00:00
• a6fcb5af62
  Pin the Database context manager contract Claude 2026-07-04 19:05:59 +00:00
• 70b48a3b16
  Use the sqlite3/sqlean shim in test_query.py Claude 2026-07-04 18:51:55 +00:00
• c76aad50ae
  Correct applied_at type annotation to str Claude 2026-07-04 18:47:08 +00:00
• ffec11cfb7
  enable_wal() and disable_wal() refuse to run inside a transaction Claude 2026-07-04 18:46:09 +00:00
• d6753a9f57
  upsert() now requires a value for every primary key column Claude 2026-07-04 18:43:37 +00:00
• 286a87dba4
  Add Unreleased changelog section covering changes since 4.0rc1 Claude 2026-07-04 18:37:20 +00:00
• e762656d06
  optimize() and rebuild_fts() now commit their changes Claude 2026-07-04 18:35:45 +00:00
• 45af93d463
  db.query() now executes its SQL immediately Claude 2026-07-04 18:24:52 +00:00
• 862944bc38
  drop-table and drop-view now refuse to drop the wrong object type Claude 2026-07-04 18:13:50 +00:00
• d36639ed73
  Run each migration inside a transaction Claude 2026-07-04 18:06:06 +00:00
• b17c37144e
  Fix delete_where() leaving the connection in an open transaction Claude 2026-07-04 17:57:35 +00:00
• f3c012774a
  Add review feedback for the create-table-parser branch Claude 2026-07-04 17:39:12 +00:00
• 0c369a447e
  Add 4.0rc1 pre-release review notes Claude 2026-07-04 17:33:23 +00:00
• 265f85052b Preserve CHECK constraints when transforming a table Apoorva Verma 2026-07-02 03:19:13 +05:30
• 5aa61c2f7f
  Fix transform() corrupting TRUE/FALSE/NULL column defaults Vincent Gao 2026-07-01 01:03:46 +02:00
• 407db59a41 Ran Black create-table-parser Simon Willison 2026-06-25 18:23:41 -07:00
• 95d6ff43ee Added support for CREATE TABLE AS SELECT Simon Willison 2026-06-25 18:23:30 -07:00
• ed1de15911 First attempt at CREATE TABLE parsing Simon Willison 2026-06-25 17:37:11 -07:00
• 654636ad74
  Merge 37ef98352a into 79117b9d11 fry69 2026-06-24 21:18:23 +00:00
• 79117b9d11 Pin click>=8.4.2 in dev dependencies to fix Cog Simon Willison 2026-06-24 13:31:52 -07:00
• e71b4ca3ee Ran cog Simon Willison 2026-06-24 13:11:29 -07:00
• bfd74a35bb upsert() detects existing compound primary keys Simon Willison 2026-06-24 10:43:53 -07:00
• b5d0080cd1 Handle db.table(table_name).insert({}), closes #759 Simon Willison 2026-06-22 12:00:05 -07:00
• 3ab8406b1d extract(): keep all-NULL rows unlinked even with a pre-existing NULL lookup row Johnson K C 2026-06-08 14:59:25 -04:00
• dad463e9c2 Don't extract NULL values into a lookup row (#186) Johnson K C 2026-06-07 16:23:58 -04:00
• 401fb6949c Fix broken tracer test 4.0rc1 Simon Willison 2026-06-21 16:29:32 -07:00
• c754a0ebaf Release 4.0rc1 Simon Willison 2026-06-21 16:26:41 -07:00
• f448b61f5e
  fix: Plugins are still loaded when running tests (#719) Rami Abdelrazzaq 2026-06-21 18:14:45 -05:00
• af5e3e3a5b Lazy-load plugins when listing them codex/pr-719-plugin-loading Simon Willison 2026-06-21 16:10:48 -07:00
• 733a67490f Test for CSV headers with memory command, refs #702, #707 Simon Willison 2026-06-21 16:04:45 -07:00
• 2b0cc04c8d
  Fix issue #702: Handle CSV with only header row in --detect-types (#707) Rami Abdelrazzaq 2026-06-21 17:57:06 -05:00
• 1a28416e10 Fix for detect_fts failing on [], refs #694 Simon Willison 2026-06-21 15:54:19 -07:00
• 6729ea3f60
  db.atomic() method Simon Willison 2026-06-21 10:43:19 -07:00
• a65df4cc69 Split out _iter_complete_sql_statements atomic Simon Willison 2026-06-21 10:18:25 -07:00
• 83311dc738 No need to quote_identifier here Simon Willison 2026-06-21 10:02:21 -07:00
• 11215b170d db.atomic() method, refs #755 Simon Willison 2026-06-21 09:58:07 -07:00
• 3cc27d69bc
  New migrations system, ported from sqlite-migrate (#754) Simon Willison 2026-06-21 09:40:21 -07:00
• b702a51256 Add test for transform ... --sql command Simon Willison 2026-06-21 09:37:05 -07:00
• 3423195b3a Better --stop-before Simon Willison 2026-06-21 09:28:34 -07:00
• b4a38be626 Fixes for ty type checks Simon Willison 2026-06-21 09:16:09 -07:00
• 49fbb1b262 Spelling and grammar sweep Simon Willison 2026-06-21 09:15:47 -07:00
• 4c265933b9 Typo fix Simon Willison 2026-06-21 09:08:13 -07:00
• 34cab63963 Final edits to migrations documentation, refs #752 Simon Willison 2026-06-21 09:03:33 -07:00
• 711718c694 Better changelog entry Simon Willison 2026-06-21 08:44:03 -07:00
• 40a4a0b771 fix: handle ignored inserts with explicit primary keys Kairos Ops 2026-06-21 14:06:41 +08:00
• 09c7005f15 New migrations system, ported from sqlite-migrate Simon Willison 2026-06-20 09:14:38 -07:00
• 04701e5bca Raise ValueError instead of assert for conflicting insert_all() options Ignazio De Santis 2026-06-10 14:55:58 +08:00
• de2601c42f Honor --no-headers for --fmt and --table output (#566) Johnson K C 2026-06-07 20:35:15 -04:00
• 52fc6fc115 fix issue #1: transform-fails-to-drop-column-if-table-is-part libra-exla[bot] 2026-06-02 00:11:23 +00:00
• 27dea3ef94
  Merge ba505e2c8c into 8f0c06e188 Paul 2026-05-30 18:26:51 +08:00
• 7ede256689
  Merge a25e83841f into 8f0c06e188 Jacob Chapman 2026-05-30 18:20:47 +08:00
• 551a1173b8 fix: bind attach database path Guillermo 2026-05-25 23:50:46 +02:00
• 10a6e82f9a fix: quote convert dry-run identifiers Guillermo 2026-05-25 17:55:15 +02:00
• 777693515f
  Merge 37caace215 into 8f0c06e188 Abhishek Yadav 2026-05-22 16:53:40 -04:00
• 40d24465cb fix: convert empty strings to NULL when transforming text columns to integer/float (#488) SAY-5 2026-05-22 00:20:06 -07:00
• 9667b2d0c5 Fix KeyError in insert_all when pk column is missing from a single record ATOM00blue 2026-05-22 06:44:09 +05:30
• 193a708664 fix: validate response shape before indexing in test_query_load_exten... BigNounce90 2026-05-21 12:53:03 +07:00
• 4bfb53aae3
  cli: output JSON without escaping non-ASCII characters Charlie Tonneslan 2026-05-18 11:08:36 -04:00
• 0c5e9eb104
  Skip type detection when CSV insert created no table Charlie Tonneslan 2026-05-18 10:08:37 -04:00
• 3c00175d82 cli: honor --no-headers for table and tabulate-style formats Charlie Tonneslan 2026-05-18 08:10:30 -04:00
• 33cab5e4ff insert: don't crash on header-only CSV with --detect-types Charlie Tonneslan 2026-05-17 19:54:45 -04:00
• 8f0c06e188
  Test against Python 3.15-dev, bump ty and Black (#738) Simon Willison 2026-05-17 16:52:48 -07:00
• 44edc65328 Bump to latest ty 3.15-dev Simon Willison 2026-05-17 16:46:27 -07:00
• 5b0c27036e Update tabulate and use that in cog Simon Willison 2026-05-17 16:33:45 -07:00
• 37847e0c27 Bump Black version Simon Willison 2026-05-17 16:29:45 -07:00
• cb143c0bcf Ran latest Black Simon Willison 2026-05-17 16:27:07 -07:00
• b0b6adb288
  Run ty check only on 3.14 Simon Willison 2026-05-17 16:25:02 -07:00
• ce17f6ca53
  Run ty only on Python 3.14 in test workflow copilot/skip-ty-step-python-3-14 copilot-swe-agent[bot] 2026-05-17 23:21:34 +00:00
• d5485459c6
  Add Python 3.15-dev to test matrix Simon Willison 2026-05-17 16:17:36 -07:00
• 18d2ef341e docs: render --convert and --functions literally in install section Charlie Tonneslan 2026-05-17 09:41:38 -04:00
• 01b37d1bbb docs: set smartquotes_action="qe" so '--' doesn't render as an en dash Charlie Tonneslan 2026-05-16 09:18:18 -04:00
• 36a34e95bf feat(db): document and test Database.memory and Database.memory_name Sai Asish Y 2026-05-13 11:55:13 -07:00
• 633414a556 Guard transform when --detect-types CSV has only a header row (closes #702) guzenkopavel 2026-05-04 12:18:23 +07:00
• fcbab3649d
  fix: auto-commit delete_where() cloudyun888 2026-04-22 15:14:25 +08:00
• a6b3812fc7 fix(cli): skip transform when table missing after header-only CSV (fixes #702) beejak 2026-04-21 22:33:20 +05:30
• 2786dcb914 fix(cli): honor --no-headers flag with --fmt/--table output CrepuscularIRIS 2026-04-15 17:38:32 +08:00
• bcbda4a326 docs: add docstrings to four undocumented public Database/Queryable methods Brandon Sheffield 2026-03-31 23:55:47 -05:00