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

• 1184ff8681 Updated docs for new "" tables, refs #677 Simon Willison 2025-11-23 20:36:42 -08:00
• b6e0885aa6
  Merge branch 'main' into quotes-not-braces Simon Willison 2025-11-23 20:21:19 -08:00
• 7f4aaa5fec Removed fix_square_braces and validate_column_names Simon Willison 2025-11-23 20:20:39 -08:00
• 98dd284f6b Views should be double quoted too Simon Willison 2025-11-23 20:06:44 -08:00
• 69888ee07c flake8 ignore .venv if it exists Simon Willison 2025-11-23 20:06:32 -08:00
• 1846dfb445 is True Simon Willison 2025-11-23 19:59:12 -08:00
• bf1ac778a3 Use uv in the Justfile, refs #674 Simon Willison 2025-11-23 19:41:57 -08:00
• d328f7e765 Fix flake8 error Simon Willison 2025-11-23 19:11:10 -08:00
• b2078ce6a1 Use double quotes not braces for tables and columns Simon Willison 2025-11-23 17:11:50 -08:00
• 52ea7d21f4 Fix for mypy errors Simon Willison 2025-11-23 15:53:19 -08:00
• 96fab69256 Removed convert skip_false and --skip-false, closes #542 Simon Willison 2025-11-23 15:40:28 -08:00
• fafa966300 Table.create() now stores configuration in _defaults Simon Willison 2025-11-23 14:51:12 -08:00
• d5f113de48 .gitignore uv.lock and dist Simon Willison 2025-11-23 14:12:18 -08:00
• 4f12c7a452 Port from setup.py to pyproject.toml Simon Willison 2025-11-23 14:06:11 -08:00
• abea9482b1 Merge branch 'main' into pyproject pyproject Simon Willison 2025-11-23 14:04:18 -08:00
• abbdd6d1ae Add flake8-pyproject Simon Willison 2025-11-23 14:03:46 -08:00
• bfeb366f53 Ditched setup.cfg and ran black Simon Willison 2025-11-23 12:49:59 -08:00
• 484f8f9943
  Merge 903d74497d into 1587feca6f Simon Willison 2025-11-23 21:37:17 +01:00
• 5a81626eef Add "Programming Language :: Python :: 3.14" Simon Willison 2025-11-23 12:28:58 -08:00
• 9068617e33 Remove Apache license classifier Simon Willison 2025-11-23 12:28:40 -08:00
• 9e5735e287 Port pyproject.toml to setup.py, refs #675 Simon Willison 2025-11-23 12:27:34 -08:00
• 1587feca6f Use PEP639 license metadata formatting Benson Muite 2025-10-08 18:18:06 +03:00
• 7ffd5052e9 table.insert_all() and table.upsert_all() now take generators of lists/tuples Simon Willison 2025-11-23 12:17:23 -08:00
• bf2a6ba018 Merge branch 'main' into insert-lists insert-lists Simon Willison 2025-11-23 12:13:45 -08:00
• dfb2dbe967 Update GitHub Actions workflow cache configuration Simon Willison 2025-11-23 12:12:29 -08:00
• 54b1c989c5 Merge branch 'main' into insert-lists Simon Willison 2025-11-23 12:05:52 -08:00
• 076c1a0aa2 Ran black Simon Willison 2025-11-23 11:59:19 -08:00
• 42d23f5954 test: suppress PytestUnraisableExceptionWarning in dateparse_errors fry69 2025-10-10 16:28:12 +02:00
• 10957305be test: fix Python 3.14 datetime deprecation fry69 2025-10-10 16:03:01 +02:00
• d4d4c89795 Unreleased changelog entry for list/tuple support, refs #672 Simon Willison 2025-11-23 11:51:36 -08:00
• ecabd9e0c5 Documentation for new list/tuple mode Simon Willison 2025-11-23 11:49:44 -08:00
• 7399ae48a1 Fix for bug where self.last_pk didn't work for single list rows Simon Willison 2025-11-23 10:57:08 -08:00
• d33b0e098c Fix for mypy errors Simon Willison 2025-11-23 10:49:54 -08:00
• 5073a2b1bd cache-dependency-path: setup.py Simon Willison 2025-11-23 10:31:14 -08:00
• 604200a52d Stop using actions/cache@v4 Simon Willison 2025-11-23 10:25:19 -08:00
• b26bf6c9ec Try hashFiles on setup.py Simon Willison 2025-11-23 10:22:34 -08:00
• 41fb5225bc Split test to filter out pytest.PytestUnraisableExceptionWarning Simon Willison 2025-11-23 10:06:45 -08:00
• 96f3500b40 Fix for datetime.utcfromtimestamp warnings Simon Willison 2025-11-23 09:34:29 -08:00
• a186c1356c Type annotation for records on insert_all/upsert_all, refs #672 Simon Willison 2025-11-23 09:32:33 -08:00
• 975b6c6191 Support tuples as well as lists Simon Willison 2025-11-23 09:29:43 -08:00
• 632f4f5f0e Performance optimization Simon Willison 2025-11-23 09:23:02 -08:00
• bf354b776c Initial Claude implementation of list mode Simon Willison 2025-11-23 09:16:33 -08:00
• fd9a8843ea test: suppress PytestUnraisableExceptionWarning in dateparse_errors fry69 2025-10-10 16:28:12 +02:00
• e5027f8d19 test: fix Python 3.14 datetime deprecation fry69 2025-10-10 16:03:01 +02:00
• 37ef98352a feat: add URI filename support fry69 2025-10-10 15:14:38 +02:00
• a82e069738
  Use PEP639 license metadata formatting Benson Muite 2025-10-08 18:18:06 +03:00
• c479ca0f44 SQLite tests against Python 3.10 Simon Willison 2025-10-01 13:38:29 -07:00
• 370318c695 Lowercase for geometry types Simon Willison 2025-10-01 13:32:09 -07:00
• f91e4c9e52 Run cog with --diff to show errors Simon Willison 2025-10-01 13:28:35 -07:00
• 1361ed5711 A bunch of fixes for Click sentinal stuff Simon Willison 2025-10-01 13:22:10 -07:00
• bccd05c9b4 Test on 3.14 and 3.14t, drop 3.9 Simon Willison 2025-10-01 13:04:18 -07:00
• 6d96dc202a SQLite tests against Python 3.10 Simon Willison 2025-10-01 13:38:29 -07:00
• cf1b407207
  Add a type hint for db.close() (#663) Alex Chan 2025-10-01 21:37:05 +01:00
• d621bcb36f Lowercase for geometry types Simon Willison 2025-10-01 13:32:09 -07:00
• 38332c139e Run cog with --diff to show errors Simon Willison 2025-10-01 13:28:35 -07:00
• 211831966e A bunch of fixes for Click sentinal stuff Simon Willison 2025-10-01 13:22:10 -07:00
• 4a4b037107 Test on 3.14 and 3.14t, drop 3.9 Simon Willison 2025-10-01 13:04:18 -07:00
• ad44e9fb65
  Add a type hint for db.close() Alex Chan 2025-06-13 13:48:27 +01:00
• 094b010fd8
  db.table() only returns tables, added db.view() Simon Willison 2025-05-08 23:19:36 -07:00
• 9b2136b1f4 Test for NoTable and NoView exceptions Simon Willison 2025-05-08 23:17:06 -07:00
• 08be98f5d6 Extra docs for db.view() Simon Willison 2025-05-08 23:07:39 -07:00
• 72c8c88afd Massive documentation update for db.table() Simon Willison 2025-05-08 23:03:55 -07:00
• 54ffa9c508 mypy fix Simon Willison 2025-05-08 22:56:52 -07:00
• 290ad27d40 db.table() only returns tables, added db.view(), refs #657 Simon Willison 2025-05-08 22:53:07 -07:00
• d892d2ae49 Fix underline length, refs #656 4.0a0 Simon Willison 2025-05-08 20:53:24 -07:00
• 9e458dea7d Release 0.4a0 Simon Willison 2025-05-08 20:51:48 -07:00
• 8e7d018fa2
  Use ON CONFLICT for upsert, refs #652 Simon Willison 2025-05-08 20:37:49 -07:00
• 79913af28a Handle different SQLite version error messages Simon Willison 2025-05-08 20:20:27 -07:00
• fa6ae2b332 Use drop table if exists Simon Willison 2025-05-08 20:16:56 -07:00
• 494075584f Drop table in finally Simon Willison 2025-05-08 20:15:07 -07:00
• 41497c3210 Fix for use_old_upsert branch Simon Willison 2025-05-08 20:10:17 -07:00
• efeba1f18c Prior to sqlite-utils 4.0 Simon Willison 2025-05-08 20:00:00 -07:00
• e9a6b4c176 Fixed mypy complaints Simon Willison 2025-05-08 19:56:47 -07:00
• 058a8dfa4c Fixed remaining broken tests Simon Willison 2025-05-08 19:51:41 -07:00
• ac9f8208c7 Put PrimaryKeyRequired back in the right place Simon Willison 2025-05-08 19:19:43 -07:00
• 2ab894dd73 Remove upsert() requires a pk checks Simon Willison 2025-05-08 19:15:46 -07:00
• fe3a3d4000 WIP new upsert implementation, refs #652 Simon Willison 2025-05-07 17:10:22 -07:00
• 55047db798 supports_strict now caches on self._supports_strict Simon Willison 2025-05-07 17:08:49 -07:00
• 72f6c820f6 Small documentation updates to fix warnings Simon Willison 2025-05-07 17:54:29 -07:00
• 0e4e270d44
  Test against multiple SQLite versions (#654) Simon Willison 2025-05-07 17:49:50 -07:00
• d83d7a0541 Ran cog Simon Willison 2025-05-07 17:36:51 -07:00
• 0d1d9aef48 Skip plugin test that needs pragma_function_list Simon Willison 2025-05-07 17:33:31 -07:00
• b3942fb34f Compatible with latest black Simon Willison 2025-05-07 17:25:57 -07:00
• 753a53eede Fix spelling error Simon Willison 2025-05-07 17:24:51 -07:00
• acdbd8c42b select ... from pragma_function_list() Simon Willison 2025-05-07 17:23:29 -07:00
• ba7419445f Try this on Python 3.9 Simon Willison 2025-05-07 17:13:50 -07:00
• 0123fc112c Test against pre-upsert SQLite 3.23.1 Simon Willison 2025-05-06 10:20:26 -07:00
• 88a83f0b7e
  Link to JSON Lines instead Simon Willison 2025-05-04 22:50:10 -07:00
• 37be9d43b6 docs: open tutorial in marimo Akshay Agrawal 2025-02-20 10:04:27 -08:00
• 0aefbb634d Removed trogon feature in favor of sqlite-util-tui Simon Willison 2025-01-10 17:15:02 -08:00
• 9c9fdc3790 Format with Black, remove unused imports, fix implicitly concatenated string Hugo van Kemenade 2024-11-24 11:53:00 +02:00
• 15f15933b1 Upgrade syntax with pyupgrade --py39-plus Hugo van Kemenade 2024-11-24 11:48:16 +02:00
• 35a726e3c4 macos-14 now has Python 3.9 Hugo van Kemenade 2024-11-24 11:44:22 +02:00
• 04107d3fea Remove note from docs about 3.8 and deterministic, closes #646 Simon Willison 2024-11-23 14:49:15 -08:00
• c544f75446 Remove 3.8 from trove tags, refs #646 Simon Willison 2024-11-23 14:48:55 -08:00
• 1290c50f71 Drop Python 3.9, add Python 3.13 to all CI Simon Willison 2024-11-23 14:42:08 -08:00
• 9d7da0606e Release 3.38 3.38 Simon Willison 2024-11-23 14:38:40 -08:00
• 4381390cf1 Skip this test on DBs that don't support strict, refs #644 Simon Willison 2024-11-23 14:32:58 -08:00
• 4dc2e2e9c8 Use REAL for floating point columns if table is strict, closes #644 Simon Willison 2024-11-23 14:27:21 -08:00
• 7423296ec7
  include_rank parameter for Table.search liunux4odoo 2024-11-24 04:34:27 +08:00