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

• cbc9841646 Docs for .search() and .search_sql(), refs #197 Simon Willison 2020-11-06 16:58:57 -08:00
• bce1872109 order= is now order_by=, refs #197 Simon Willison 2020-11-06 16:43:33 -08:00
• 2bc1e9c5b4 Added test for .search_sql() and FTS4, refs #197 Simon Willison 2020-11-06 16:32:40 -08:00
• 6863dc2677 sqlite-utils rows -c, closes #200 Simon Willison 2020-11-06 16:28:41 -08:00
• 309ae84336 '-f' must now always be specified as '--fmt', refs #194 Simon Willison 2020-11-06 16:17:15 -08:00
• afee15f04b --tsv output option, closes #193 Simon Willison 2020-11-06 16:09:42 -08:00
• 771bd81b62 search_sql() returns most relevant first, not least Simon Willison 2020-11-06 15:50:02 -08:00
• 63e2bdf18d Added test for sqlite-utils search, refs #192 Simon Willison 2020-11-06 15:40:42 -08:00
• d411fba1f4 .search() works for FTS4, yields dicts Simon Willison 2020-11-06 10:23:16 -08:00
• 476825a224 How to use register_function as a method, not a decorator Simon Willison 2020-11-06 08:03:25 -08:00
• 27b67f1cae @db.register_function(..., replace=True), closes #199 Simon Willison 2020-11-06 07:53:22 -08:00
• 7c22a64fb6 .search() now works differently for FTS4 v.s. FTS5 Simon Willison 2020-11-05 10:01:58 -08:00
• de39e8db1e Refactored to table.search_sql() method, added --limit Simon Willison 2020-11-03 14:46:18 -08:00
• 2c00567aac sqlite-utils search WIP, refs #192 Simon Willison 2020-11-03 14:01:14 -08:00
• 973d94d44f
  Merge branch 'main' into cli-search Simon Willison 2020-11-06 10:26:07 -08:00
• a5b85ebdf8 .search() works for FTS4, yields dicts Simon Willison 2020-11-06 10:23:16 -08:00
• 905f8bf65a How to use register_function as a method, not a decorator Simon Willison 2020-11-06 08:03:25 -08:00
• 49881ffbc9 @db.register_function(..., replace=True), closes #199 Simon Willison 2020-11-06 07:53:22 -08:00
• 0c46f34b25 .search() now works differently for FTS4 v.s. FTS5 Simon Willison 2020-11-05 10:01:58 -08:00
• 59d8689ed0 table.virtual_table_using property, closes #196 Simon Willison 2020-11-04 19:53:32 -08:00
• 757172065c table.virtual_table_using property, closes #196 Simon Willison 2020-11-04 19:53:32 -08:00
• c8a900df59 Refactored to table.search_sql() method, added --limit Simon Willison 2020-11-03 14:46:18 -08:00
• 6cadc6103f sqlite-utils search WIP, refs #192 Simon Willison 2020-11-03 14:01:14 -08:00
• 43eae8b193 Release 2.23 2.23 Simon Willison 2020-10-28 14:38:10 -07:00
• 0789bad8f7 @db.register_function(deterministic=True), closes #191 Simon Willison 2020-10-28 14:24:03 -07:00
• f99a236529
  Progress bar for sqlite-utils insert command, closes #173 Simon Willison 2020-10-27 11:16:02 -07:00
• 62d678122a Documentation for --silent, refs #173 Simon Willison 2020-10-27 11:10:49 -07:00
• 2f38660d48 Progress bar for insert works now Simon Willison 2020-10-27 11:07:06 -07:00
• c7e5dd6451 Applied latest Black Simon Willison 2020-10-27 09:26:01 -07:00
• f045d8559a
  Allow iterables other than lists in m2m records (#189) Adam Wolf 2020-10-27 11:24:21 -05:00
• 93230b2acb Add test for iterable m2m records Adam Wolf 2020-10-27 11:15:20 -05:00
• 4c1ed92c17 Progress bar WIP Simon Willison 2020-10-26 21:37:19 -07:00
• 0193ba04d5 Allow iterables other than Lists in m2m records Adam Wolf 2020-10-26 13:36:50 -05:00
• 2771ab96e7 Test showing stdin inserts work Simon Willison 2020-10-25 20:05:56 -07:00
• e4f1c7b936
  python_requires=">=3.6" Simon Willison 2020-10-23 14:19:30 -07:00
• 55133b5966
  Link to sqliteutils tag on my blog Simon Willison 2020-10-21 11:08:28 -07:00
• 0b5edd6469 Added basic tests using hypothesis, closes #180 Simon Willison 2020-10-18 21:51:50 -07:00
• 47af71f603 Release 2.22 2.22 Simon Willison 2020-10-16 12:30:25 -07:00
• 21ff60e3b1 --load-extension= for many more commands, closes #137 Simon Willison 2020-10-16 12:14:22 -07:00
• 2c541fac35 --encoding option for non-utf8 CSV/TSV, closes #182 Simon Willison 2020-10-16 10:18:46 -07:00
• 7c0ef116ed pk=['id'] now equivalent to pk='id', closes #181 Simon Willison 2020-10-14 14:59:38 -07:00
• 7eda0532e8 Consistent usage of db["dogs"], closes #185 Simon Willison 2020-10-11 17:13:24 -07:00
• 4e8e157b5d
  Test against Python 3.9 on publish Simon Willison 2020-10-07 18:45:07 -07:00
• 8e91de8e4e
  Python 3.9 (#184) Simon Willison 2020-10-07 18:44:05 -07:00
• 975c05b6dd
  Python versions badge python-3.9 Simon Willison 2020-10-07 18:43:27 -07:00
• b724956586
  Programming Language :: Python :: 3.9 Simon Willison 2020-10-07 18:42:29 -07:00
• ee811fb6c7
  Test agaist Python 3.9 Simon Willison 2020-10-07 18:37:01 -07:00
• 7f4fe9190c
  Configure code scanning, refs #183 Simon Willison 2020-09-30 15:17:23 -07:00
• cada1017ed
  Fixed incorrect example in README Shakeel Mahate 2020-09-30 16:29:27 -04:00
• 0c6a81dae8
  Update README.md Simon Willison 2020-09-30 13:28:57 -07:00
• a53d19fb1c
  Update README.md Shakeel Mahate 2020-09-25 11:51:50 -04:00
• 94fc62857e Demonstrate extract= creates correct foreign keys Simon Willison 2020-09-24 15:46:46 -07:00
• cda559f835 Include --column-order in combined example, refs #176 Simon Willison 2020-09-24 13:33:19 -07:00
• a57acf84f7 Release 2.21 2.21 Simon Willison 2020-09-24 09:44:30 -07:00
• 5a63b9e88c Simplify drop-foreign-key, and drop_foreign_keys, closes #177 Simon Willison 2020-09-24 09:19:07 -07:00
• d13c123100 sqlite-utils transform --column-order option, closes #176 Simon Willison 2020-09-24 09:11:53 -07:00
• 725f206949 Documentation for .transform(column_order=), closes #175 Simon Willison 2020-09-24 09:00:50 -07:00
• 022cdd97a9
  Much, much faster extract() implementation Simon Willison 2020-09-24 08:43:55 -07:00
• 227095ee90 Tests for reusing lookup table in extract() Simon Willison 2020-09-24 08:40:55 -07:00
• 01ff0937f7 Fix for column ordering after .extract(), refs #172 Simon Willison 2020-09-24 08:15:12 -07:00
• dfe91a8a44 Removed unnecessary update() optimization Simon Willison 2020-09-24 07:55:04 -07:00
• bf15acde88 Removed unnecessary progress bar, refs #172 Simon Willison 2020-09-24 07:53:30 -07:00
• 5eb14d1c1f Added several missing 'return self' to support chaining Simon Willison 2020-09-24 07:51:36 -07:00
• 61015c8f64 Much, much faster extract() implementation, refs #172 Simon Willison 2020-09-24 00:51:55 -07:00
• 0ca5585fcb Clarify why you would want transform_sql() Simon Willison 2020-09-23 13:16:01 -07:00
• 66d506587e Some optimizations for extract() Simon Willison 2020-09-23 13:12:09 -07:00
• 1ebffe1dbe Correction: SQLite ALTER TABLE can rename columns Simon Willison 2020-09-22 20:09:42 -07:00
• 9f59a7a325 Fixed typo in release notes, refs #170 2.20 Simon Willison 2020-09-22 17:35:44 -07:00
• 5534c320e4 Applied Black Simon Willison 2020-09-22 17:32:40 -07:00
• dcdef136db Release 2.20 Simon Willison 2020-09-22 17:31:15 -07:00
• b8e0048485 Fixed PRAGMA foreign_keys handling for .transform, closes #167 Simon Willison 2020-09-22 17:12:56 -07:00
• 5c4d58d152 Progress bar for "sqlite-utils extract", closes #169 Simon Willison 2020-09-22 17:02:29 -07:00
• 55cf928f73 sqlite-utils extract, closes #42 Simon Willison 2020-09-22 16:37:39 -07:00
• 2db6c5b2d5 table.extract() now works with rowid tables, refs #42 Simon Willison 2020-09-22 16:11:07 -07:00
• 71782311ce New .rows_where(select=) argument Simon Willison 2020-09-22 16:10:14 -07:00
• 317071a552 Applied Black Simon Willison 2020-09-22 16:09:28 -07:00
• c3210f2ffb Added table.extract(rename=) option, refs #42 Simon Willison 2020-09-22 15:57:02 -07:00
• c755f2852d Docstring for sqlite-utils transform Simon Willison 2020-09-22 15:47:11 -07:00
• f8553799d3 table.extract() method, refs #42 Simon Willison 2020-09-22 15:20:18 -07:00
• f29f6821f2 Applied Black Simon Willison 2020-09-22 00:49:27 -07:00
• 752d261229 Implemented sqlite-utils transform command, closes #164 Simon Willison 2020-09-22 00:46:32 -07:00
• f8e10df00e
  Keyword only arguments for transform() Simon Willison 2020-09-21 23:39:10 -07:00
• f8648cac3a Keyword only arguments for transform() Simon Willison 2020-09-21 23:38:40 -07:00
• 139c8df85b
  Keyword only arguments, refs #165 Simon Willison 2020-09-21 22:41:18 -07:00
• 987dd123f2
  table.transform() method - closes #114 Simon Willison 2020-09-21 21:20:01 -07:00
• dc3eb9c313 Correct handling of pragma foreign_keys for .transform() Simon Willison 2020-09-21 21:18:24 -07:00
• 2628e4d676 Documentation for table.transform(), refs #114 Simon Willison 2020-09-21 20:47:22 -07:00
• 95bfe1c77c .transform(pk=None) to create rowid table Simon Willison 2020-09-21 20:39:05 -07:00
• 1e05fb157d .transform(drop_foreign_keys=...), refs #114 Simon Willison 2020-09-21 20:20:48 -07:00
• 785c4a80a2 .transform(defaults=...) Simon Willison 2020-09-21 19:57:44 -07:00
• 90258748b4 Fixed error when .transform(not_null=None) Simon Willison 2020-09-21 19:47:00 -07:00
• a29ba8cf34 .transform() can now alter NOT NULL Simon Willison 2020-09-21 19:40:38 -07:00
• 99d931ed4a Applied Black Simon Willison 2020-09-21 19:24:51 -07:00
• fe7cb7e8aa Test for .transform() rowid table to id table Simon Willison 2020-09-21 19:22:23 -07:00
• 7b8e7c4207 Also check that .transform() runs without exceptions Simon Willison 2020-09-21 19:18:15 -07:00
• 9a6e7dab4d .transform() can now change the primary key Simon Willison 2020-09-21 19:15:43 -07:00
• 2b5956690d @db.register_function decorator, closes #162 Simon Willison 2020-09-21 17:31:43 -07:00
• 482477585a @db.register_function decorator, closes #162 Simon Willison 2020-09-21 17:31:43 -07:00
• 59692895fd More .transform() tests Simon Willison 2020-09-21 16:58:02 -07:00
• b34c9b40c2 New, improved implementation of transform(), refs #114 Simon Willison 2020-09-21 16:54:37 -07:00