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

• 513f22851f Docs for table.search(include_rank) Simon Willison 2024-11-23 12:29:57 -08:00
• 9a5256e226 Test for .search(include_rank) Simon Willison 2024-11-23 12:27:08 -08:00
• 42230709f7
  Recreate indexes when calling transform when possible (#634) Mat Miller 2024-11-23 14:17:15 -06:00
• b5257937cb Docs for sqlite_utils.db.TransformError Simon Willison 2024-11-23 11:41:49 -08:00
• 4d2274c53f Use new TransformError instead of AssertionError Simon Willison 2024-11-23 11:39:36 -08:00
• 3041c5d5da Test for does not have a CREATE INDEX case Simon Willison 2024-11-09 09:30:23 -08:00
• c47a2a42bc Clarifying comments Simon Willison 2024-11-09 09:19:16 -08:00
• cbddfb28f9
  typo in command name (#640) Gavin Wahl 2024-11-09 09:31:21 -07:00
• 0acb1f29c2 Release 3.38a0 3.38a0 Simon Willison 2024-11-08 12:13:57 -08:00
• 21e80dfbcf It's return_db, not _return_db - refs #643 Simon Willison 2024-11-08 12:13:05 -08:00
• 2258b431d4 Neater return_db pattern for reusing memory command, closes #643 Simon Willison 2024-11-08 12:11:17 -08:00
• 8906f57740 Hack to support reuse of memory command, closes #643 Simon Willison 2024-11-08 11:16:57 -08:00
• 48bd369f44
  Merge 478372e4a8 into 4c2628873c lbellomo 2024-09-20 18:24:03 -04:00
• 81fcaadd37
  typo in command name Gavin Wahl 2024-09-10 15:32:05 -06:00
• 4c2628873c
  Fix typo (#639) Gert Goet 2024-09-03 10:27:16 +02:00
• 908206aa7c
  Fix typo Gert Goet 2024-09-03 09:52:13 +02:00
• 4ae43b296c add unit tests for the Python 3.12 autocommit transaction behaviour feature Enno Richter 2024-08-23 07:38:40 +02:00
• e31dbf3f37 recreate indexes when calling transform when possible and raise an error when they cannot be retained automatically Mathew Miller 2024-07-21 16:20:43 -05:00
• 8b004b2406 Release 3.37 3.37 Simon Willison 2024-07-18 11:43:07 -07:00
• 896411099e
  Documented the use of delete_where (#630) Thomas 2024-07-18 20:34:24 +02:00
• dc79454234
  Fix for np.int8 error, refs #632 Simon Willison 2024-07-18 11:32:48 -07:00
• 903d74497d
  Test to trigger test run numpy2 Simon Willison 2024-07-17 12:44:22 -07:00
• 5c8d504042
  Documented the use of delete_where Thomas 2024-07-03 21:07:22 +02:00
• 381cc730e1
  add include_rank parameter to Table.search liunux4odoo 2024-05-07 08:58:22 +08:00
• 577078fe01
  ReadTheDocs formats: - pdf - epub Simon Willison 2024-04-09 20:34:42 -07:00
• 478372e4a8 change deprecated datetime.utcfromtimestamp to datetime.fromtimestamp lbellomo 2024-03-31 19:39:46 -03:00
• 6e342b89ee make sure to close fp in case of UnicodeDecodeError lbellomo 2024-03-31 19:07:52 -03:00
• d3f097901c add io.buffer in _extra_key_strategy to ensure is closed in the end lbellomo 2024-03-31 18:35:43 -03:00
• b006a4c685 add lazy=True to avoid opening the file early in case of failure lbellomo 2024-03-31 17:45:23 -03:00
• 1d050dcdc7 insert-files multiple --pk support, closes #621 Simon Willison 2024-03-16 17:33:31 -07:00
• 1feb0c4271 Docs for insert with multiple --pk, refs #621 Simon Willison 2024-03-16 17:27:18 -07:00
• da92a30679 Test for insert CLI with multiple --pk, refs #621 Simon Willison 2024-03-16 17:26:02 -07:00
• 23be5be1dc create-table now supports multiple --pk, refs #620 Simon Willison 2024-03-16 17:05:27 -07:00
• 1dc5da3e5d
  Use context managers for file writes in tests (#618) Konstantin Baikov 2024-03-15 05:20:19 +01:00
• 142bb2b937 Programming Language :: Python :: 3.13 Simon Willison 2024-03-14 21:15:20 -07:00
• 5bd7aec4d2
  Test against Python 3.13 pre-release (#619) Simon Willison 2024-03-14 21:14:10 -07:00
• ddf5ce15e6 Fixed .rST warning Simon Willison 2024-03-14 21:06:29 -07:00
• fd803d7043 Hide \b characters in cli-reference Simon Willison 2024-03-14 21:05:37 -07:00
• 995446bc94 Try to avoid Python 3.13 cog differences Simon Willison 2024-03-14 19:28:04 -07:00
• 3ab780c39f
  Skip tests for numpy on Python 3.13 Simon Willison 2024-03-14 18:59:48 -07:00
• 4241d47874
  Test against Python 3.13 pre-release Simon Willison 2024-03-14 18:47:11 -07:00
• 2fc480adae Use context managers for file writes in tests Konstantin Baikov 2024-03-04 08:36:11 +01:00
• 61de8d997d
  Merge branch 'simonw:main' into main Peter Gaultney 2024-02-14 09:21:06 -06:00
• 17eb8184d2
  Run tests against ARM macos-14 (#615) Simon Willison 2024-01-30 19:02:37 -08:00
• d536b3f0d2 Skip Python 3.8 and 3.9 on macos-14 Simon Willison 2024-01-30 18:49:59 -08:00
• dbda76d6ed Drop support for Python 3.7 Simon Willison 2024-01-30 18:37:38 -08:00
• 70cc0c91ab
  Drop support for Python 3.7 Simon Willison 2024-01-30 18:37:38 -08:00
• 7ea93af589 Back to codecov/codecov-action@v1 Simon Willison 2024-01-30 18:26:55 -08:00
• c304fc3891 Drop support for Python 3.7, refs #616 Simon Willison 2024-01-30 18:25:01 -08:00
• 976cf81dc9 Upgrade to latest Black Simon Willison 2024-01-30 18:18:52 -08:00
• ff57a97482 Upgrade to latest Black Simon Willison 2024-01-30 18:18:52 -08:00
• ea0de7ec0c
  Run tests against ARM macos-14 Simon Willison 2024-01-30 18:03:20 -08:00
• b7def00b8c More consistent indentation Simon Willison 2024-01-14 09:27:58 -08:00
• 7b2488c1a2
  rework to store schema name explicitly Peter Gaultney 2024-01-09 09:27:59 -06:00
• c2e8270b9f
  work-in-progress FTS for attached dbs Peter Gaultney 2024-01-02 14:49:37 -06:00
• 885a0b321d Release 3.36 3.36 Simon Willison 2023-12-07 21:31:03 -08:00
• f29189a3dd db.supports_strict docs, closes #344 Simon Willison 2023-12-07 21:22:27 -08:00
• 1500c19bd0
  Add more STRICT table support (#604) Taj Khattra 2023-12-07 21:05:27 -08:00
• 61c6e26cf9 Link to SQLITE strict page in a few places Simon Willison 2023-12-07 21:04:33 -08:00
• 1698a9dcbb Tiny tweak to CLI option help Simon Willison 2023-12-07 20:59:56 -08:00
• 7f66b70c2f Fix cog failure in PR #604 Taj Khattra 2023-12-06 21:30:54 -08:00
• cfecbce71f Fix mypy failures in PR #604 Taj Khattra 2023-12-06 17:12:43 -08:00
• 88bd372205 str, int, bytes aliases for column types, closes #606 Simon Willison 2023-12-06 10:49:21 -08:00
• e4b9b582cd Add more STRICT table support per https://github.com/simonw/sqlite-utils/issues/344#issuecomment-982014776. Make table.transform() preserve STRICT mode. Taj Khattra 2023-11-16 22:22:05 -08:00
• 9286c1ba43
  Fixed some markup bugs Simon Willison 2023-11-03 20:55:19 -07:00
• c64c7d1b8c More 3.35.2 release notes 3.35.2 Simon Willison 2023-11-03 18:03:42 -07:00
• 78d8dd06d3 Add 3.12 to PyPI metadata Simon Willison 2023-11-03 17:59:09 -07:00
• 08c8bb7cfb Test against Python 3.12 Simon Willison 2023-11-03 17:58:31 -07:00
• b2e0cd066d Test and docs for timedelta support, refs #522 Simon Willison 2023-11-03 17:54:37 -07:00
• 1f14df1de4 Test against Python 3.12 preview python-3.12 Simon Willison 2023-09-06 09:09:55 -07:00
• 8d186d33c2 Release 3.35.2 Simon Willison 2023-11-03 17:38:52 -07:00
• 347fdc865e
  Map datetime.timedelta to text columns, closes #522 Harald Nezbeda 2023-11-04 01:49:50 +01:00
• 37273d7f63
  Fixed issue #433 - CLI eats cursor (#598) Luke Plant 2023-11-04 00:40:29 +00:00
• b92ea4793c Fixed spelling of wrappping Simon Willison 2023-11-03 17:25:02 -07:00
• 4b3c83cd9f Add spatialite arm64 linux path Mike Coats 2023-11-03 22:11:23 +00:00
• b1a60766a4
  Fixed spelling of wrappping Simon Willison 2023-11-03 17:25:02 -07:00
• 1234425320 Add spatialite arm64 linux path Mike Coats 2023-11-03 22:11:23 +00:00
• 76113d1cb1 Fixed issue #433 - CLI eats cursor Luke Plant 2023-10-04 18:49:28 +01:00
• ab12125b3f Fixes mapping for time fields related to mysql, closes #522 Harald Nezbeda 2023-09-29 14:42:51 +02:00
• 622c3a5a7d Fixed Markdown that should be rST Simon Willison 2023-09-08 18:25:46 -07:00
• 60900bd80a Release notes for 3.35.1, refs #592 3.35.1 Simon Willison 2023-09-08 17:49:55 -07:00
• cb034621fd Release 3.35.1 Simon Willison 2023-09-08 17:45:14 -07:00
• 1c6ea54338
  .transform() now preserves rowid values Simon Willison 2023-09-08 17:45:30 -07:00
• b86374f705 Test transform rowids against different table types, refs #592 Simon Willison 2023-09-08 17:43:19 -07:00
• 4914eb1199 .transform() now preserves rowid values, refs #592 Simon Willison 2023-09-07 18:01:50 -07:00
• 5d123f031f
  Fixed bug in replacing foreign key constraints example Simon Willison 2023-09-06 15:33:06 -07:00
• 02e56d1158
  click-default-group>=1.2.3 Simon Willison 2023-09-05 19:34:53 -07:00
• 62f673835c Prototype of deregister and with db.register_functions, refs #589 deregister-functions Simon Willison 2023-09-03 12:36:10 -07:00
• 1260bdc7bf
  Link to sqlite-utils-fast-fks from changelog Simon Willison 2023-08-18 10:47:10 -07:00
• 98cd11a81b
  Link docs to sqlite-utils-fast-fks Simon Willison 2023-08-18 10:45:12 -07:00
• 7c1618e4b1
  Promote plugins in the README Simon Willison 2023-08-17 19:28:08 -07:00
• 4aea34065c Run codespell as part of 'just lint' Simon Willison 2023-08-17 19:09:22 -07:00
• ba2681e769 Fixed two typos in the release notes 3.35 Simon Willison 2023-08-17 19:05:15 -07:00
• 87c6ceb3a4 Release 3.35 Simon Willison 2023-08-17 19:01:48 -07:00
• 56093de078 sqlite-utils transform --add-foreign-key option, closes #585 Simon Willison 2023-08-17 18:51:04 -07:00
• 70717dc0e1 Remove unneccessary warning, refs #577, #585 Simon Willison 2023-08-17 18:28:09 -07:00
• d2bcdc00c6 Swapped the order of a bunch of pytest comparisons Simon Willison 2023-08-17 18:05:13 -07:00
• b4735f794a Remove test.utils.collapse_whitespace, closes #583 Simon Willison 2023-08-17 17:59:09 -07:00
• 509857ee87
  .add_foreign_keys() uses .transform() instead of PRAGMA writable_schema Simon Willison 2023-08-17 17:48:08 -07:00
• 291505084e Better fragment links for transform() docs Simon Willison 2023-08-17 17:43:25 -07:00