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

• 7b2d74b4f6 Tests are how I want this to work (currently fail) Simon Willison 2020-09-21 16:19:03 -07:00
• e3f3bea60a Rename transform_table to just transform, refs #114 Simon Willison 2020-09-21 16:14:05 -07:00
• 774e82d562 tests Simon Willison 2020-07-26 09:28:20 -07:00
• 594504817c More work on transform Simon Willison 2020-07-26 09:27:47 -07:00
• ef882986d0 Release 2.19 2.19 Simon Willison 2020-09-20 15:22:56 -07:00
• e23eedb4ce ignore=True argument for add_foreign_key, closes #112 Simon Willison 2020-09-20 15:17:25 -07:00
• ecb50c8f76 .enable_fts(..., replace=True) argument, closes #160 Simon Willison 2020-09-20 15:05:46 -07:00
• 3cc1944e53 sqlite-utils add-foreign-keys command, closes #157 Simon Willison 2020-09-20 13:14:25 -07:00
• 7805d53bcf
  Fix accidental mega long line in docs (#158) Tom V 2020-09-16 07:21:42 +01:00
• 5c1d8a5f3a
  Fix accidental mega long line in docs Tom V 2020-09-09 23:30:16 +01:00
• 367082e787
  Typos in tests (#156) Simon Wiles 2020-09-09 11:21:22 -07:00
• b777776753 Fix typo in test name Simon Wiles 2020-09-07 16:34:21 -07:00
• f9e7888f10 Fix typo in unrelated test Simon Wiles 2020-08-29 15:54:38 -07:00
• 6be6126364 Release 2.18 2.18 Simon Willison 2020-09-08 16:37:28 -07:00
• 32f1badfec Tracer example using print, refs #150 Simon Willison 2020-09-08 16:27:55 -07:00
• e6d202b742
  Handle case where subsequent records (after first batch) include extra columns Simon Wiles 2020-09-08 16:20:36 -07:00
• 176f4e0ef4 sqlite-utils rebuild-fts command, closes #155 Simon Willison 2020-09-08 16:16:03 -07:00
• 76548596a6 optimize command now accepts optional tables, refs #155 Simon Willison 2020-09-08 15:34:55 -07:00
• 9680a0291c 'Soundness check' is better Simon Willison 2020-09-08 15:24:39 -07:00
• 64799df78b .optimize() no longer cleans up _docsize Simon Willison 2020-09-08 15:18:12 -07:00
• 4c0f79398f table.rebuild_fts() method, refs #155 Simon Willison 2020-09-08 15:09:25 -07:00
• 40fcea4152 Extract insert_chunk so it can be called recursively Simon Wiles 2020-09-07 16:22:28 -07:00
• c241162fa9 Extract build_insert_queries_and_params Simon Wiles 2020-09-07 16:01:25 -07:00
• 1b1e0ccfd3 Create test for #145 Simon Wiles 2020-08-29 21:38:32 -07:00
• deb2eb013f Release notes for 2.17 2.17 Simon Willison 2020-09-07 15:07:21 -07:00
• f28cd4de6d
  Release 2.17 Simon Willison 2020-09-07 14:58:49 -07:00
• cf2cb244fa
  Tracer mechanism for showing underlying SQL queries Simon Willison 2020-09-07 14:56:59 -07:00
• dc82bf3719 Missing rST label Simon Willison 2020-09-07 14:54:41 -07:00
• f12251092c Documentation for tracer mechanism Simon Willison 2020-09-07 14:54:07 -07:00
• 31bea2ac61 Test for with db.tracer() contextmanager Simon Willison 2020-09-07 14:39:33 -07:00
• a021b6b62e Unit test for tracer Simon Willison 2020-09-07 14:33:47 -07:00
• 2797b3ac6c Neater SQL indentation, because tracer means it could be visible now Simon Willison 2020-09-07 14:28:36 -07:00
• 6104cbd91a Sketched out a trace mechanism, refs #150 Simon Willison 2020-09-07 12:44:37 -07:00
• 3e87500e15 table.optimize() deletes junk docsize rows Simon Willison 2020-09-07 14:16:13 -07:00
• c449064297 Additional tests for WAL mode Simon Willison 2020-09-07 13:46:12 -07:00
• de10590344 recursive_triggers=on by default, closes #152 Simon Willison 2020-09-07 13:45:06 -07:00
• e878f2a8fe Applied latest black Simon Willison 2020-09-07 12:45:54 -07:00
• 59e3d4d171 Neater indentation for SQL used in schemas, closes #148 Simon Willison 2020-09-07 11:12:45 -07:00
• 0e62744da9
  Correct import path for AlterError exception Simon Willison 2020-09-02 13:29:46 -07:00
• e0cd430e89
  Docs for sqlite_utils.AlterError in add_foreign_keys() Simon Willison 2020-09-02 13:17:01 -07:00
• cbc22ef20c
  Add numpy to the matrix, refs #144 Simon Willison 2020-08-28 15:56:06 -07:00
• 1a9dab86fe Release 2.16.1 2.16.1 Simon Willison 2020-08-28 15:45:11 -07:00
• 01c7784be5 CI is now GitHub Actions, closes #143 Simon Willison 2020-08-28 15:41:29 -07:00
• d7d3f96286 Black now runs in GitHub actions, refs #143 Simon Willison 2020-08-28 15:37:45 -07:00
• 8c405965e9 GitHub Actions workflows, refs #143 Simon Willison 2020-08-28 15:36:55 -07:00
• 10c6fbc368 Applied Black 20.8b1, refs #142 Simon Willison 2020-08-28 15:30:57 -07:00
• 947bb7626f
  insert_all(..., alter=True) works for columns introduced after first 100 records Simon Wiles 2020-08-28 15:30:13 -07:00
• 1b992c7c1e Update documentation Simon Wiles 2020-08-28 15:20:48 -07:00
• eb65270782 Test that exception is raised Simon Wiles 2020-08-28 14:58:25 -07:00
• 2ded6545b4 Rename test Simon Wiles 2020-08-28 14:58:01 -07:00
• 222bbb1375 Update unit test to reflect new behaviour Simon Wiles 2020-08-28 14:51:19 -07:00
• 3901f43c6a Insert all columns for every chunk Simon Wiles 2020-08-27 13:05:59 -07:00
• ea87c2b943 Release 2.16 2.16 Simon Willison 2020-08-21 14:02:29 -07:00
• c8b2433481 Install spatialite in Travis for --load-extension tests, refs #134 Simon Willison 2020-08-21 14:01:44 -07:00
• 7e9aad7e1c --load-extension option for sqlite-utils query, closes #134 Simon Willison 2020-08-21 13:54:11 -07:00
• bf4c6b7c82 find_spatialite() utility function, closes #135 Simon Willison 2020-08-21 13:30:02 -07:00
• c8d7969192 Release 2.15.1 2.15.1 Simon Willison 2020-08-12 09:59:48 -07:00
• d03fc607b3
  Package as sdist as well, refs #133 Simon Willison 2020-08-12 09:56:36 -07:00
• 66ed36258a Renaming from master to main Simon Willison 2020-08-10 14:04:32 -07:00
• 7536a5a0f6 Release 0.15 2.15 Simon Willison 2020-08-10 12:06:02 -07:00
• 2d2d724e32 Tools for enabling and disabling WAL, closes #132 Simon Willison 2020-08-10 11:59:21 -07:00
• 957f8c9b4c
  2.14.1 release notes 2.14.1 Simon Willison 2020-08-05 23:31:11 -07:00
• 5de24ee0a4
  Release 2.14.1 Simon Willison 2020-08-05 23:28:50 -07:00
• db1e08c2c8
  Documentation for table.detect_fts() method Simon Willison 2020-08-05 19:21:49 -07:00
• 5560d717cb
  Updated list of supported parameters to db.table() Simon Willison 2020-08-01 14:30:43 -07:00
• a8b922bcb9 Release 2.14 2.14 Simon Willison 2020-08-01 13:58:47 -07:00
• 57e4eb8e55 sqlite-utils populate-fts --tokenize= option, closes #130 Simon Willison 2020-08-01 13:51:05 -07:00
• 617e6f070c enable_fts(..., tokenize=X) parameter, refs #130 Simon Willison 2020-08-01 13:40:36 -07:00
• 8fe1e6d1be insert-files can now read from stdin, closes #127 Simon Willison 2020-07-29 20:08:12 -07:00
• 710454d72a Release 2.13 2.13 Simon Willison 2020-07-29 18:13:53 -07:00
• f804690274 Support inserting UUID and memoryview, closes #128 Simon Willison 2020-07-29 18:10:25 -07:00
• 3214af4a20
  Fixed bug in one of the insert-files examples Simon Willison 2020-07-27 18:53:57 -07:00
• 3f6a10b807 Release 2.12 2.12 Simon Willison 2020-07-27 00:21:26 -07:00
• ebc802f7ff sqlite-utils insert-files command, closes #122 Simon Willison 2020-07-27 00:08:57 -07:00
• 1a61a6d3d6 Ability to insert base64 binary data as JSON, closes #126 Simon Willison 2020-07-26 20:59:15 -07:00
• 814d4a7f90 -p for passing named params to query, closes #124 Simon Willison 2020-07-26 20:53:51 -07:00
• 20e543e9a4 Output binary columns as base64 in JSON, closes #125 Simon Willison 2020-07-26 17:48:36 -07:00
• bc8409941f --raw option, refs #123 Simon Willison 2020-07-26 09:43:45 -07:00
• a236a6bc77 Release notes for 2.11 2.11 Simon Willison 2020-07-08 10:36:07 -07:00
• 0f8b042b47
  Release 2.11 Simon Willison 2020-07-08 10:28:29 -07:00
• ae4593316c Add insert --truncate option Thomas Sibley 2020-07-06 14:18:23 -07:00
• 332f7d770b Add insert --truncate option Thomas Sibley 2020-07-06 14:18:23 -07:00
• f8277d0fb9
  sqlite-utils query can now run DML (#120) Thomas Sibley 2020-07-07 22:14:04 -07:00
• 6a660d12a2 Run sqlite-utils query in a transaction so that DML is committed Thomas Sibley 2020-07-07 12:33:39 -07:00
• 52418cea80 Failing test showing that DML in sqlite-utils query doesn't work Thomas Sibley 2020-07-07 12:32:48 -07:00
• d0cdaaaf00
  Release notes for 2.10.1 Simon Willison 2020-06-23 14:13:18 -07:00
• 97246f9ef7
  Release 2.10.1 2.10.1 Simon Willison 2020-06-23 14:04:07 -07:00
• fbeb61e49c
  Documentation for table.pks, closes #116 Simon Willison 2020-06-23 14:03:13 -07:00
• 4d9a320436 Release 2.10 2.10 Simon Willison 2020-06-12 10:43:45 -07:00
• 03ee97d225 CLI now supports upsert/insert - closes #115 Simon Willison 2020-06-12 10:40:53 -07:00
• 8eaac7c5f1 pip, not pip3 Simon Willison 2020-05-11 12:23:11 -07:00
• 3b5c931287 Release 2.9.1 2.9.1 Simon Willison 2020-05-11 12:20:29 -07:00
• 74b30af31b
  Added project_urls Simon Willison 2020-05-11 12:16:22 -07:00
• 3936512edd Release 2.9 2.9 Simon Willison 2020-05-10 18:54:56 -07:00
• af3f81b540 Store decimal.Decimal in DB as FLOAT, closes #110 Simon Willison 2020-05-10 18:50:03 -07:00
• e8c57e09b6 More things to .gitignore Simon Willison 2020-05-10 18:29:29 -07:00
• 98019e92d0 Ran black, refs #111 Simon Willison 2020-05-10 18:26:16 -07:00
• 4e9cb739c7 drop-table and drop-view commands, closes #111 Simon Willison 2020-05-10 17:44:21 -07:00
• 396bee9236
  Don't show documentation badge on docs index Simon Willison 2020-05-03 08:47:28 -07:00
• 60e380e551
  Add badges to documentation index Simon Willison 2020-05-03 08:44:41 -07:00