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

• 30a390780a Release 2.8, refs #27 and #107 2.8 Simon Willison 2020-05-03 08:39:50 -07:00
• d16097231c Added sqlite-utils create-view command, closes #107 Simon Willison 2020-05-03 08:36:29 -07:00
• 78264b738c Removed docs for feature I decided not to implement, refs #27 Simon Willison 2020-05-03 08:25:21 -07:00
• 9f6085b4e4 create-table --ignore and --replace, refs #27 Simon Willison 2020-05-03 08:24:39 -07:00
• 4d5916075d create-table --not-null, --default, --fk, refs #27 Simon Willison 2020-05-03 08:09:00 -07:00
• 99a7906fd9 sqlite-utils create-table docs, plus doc unit test Simon Willison 2020-05-02 21:13:49 -07:00
• 36d256b047 Initial implementation of create-table command, refs #27 Simon Willison 2020-05-02 20:55:40 -07:00
• 79541d3a6d Release 2.7.2, refs #106 2.7.2 Simon Willison 2020-05-02 09:05:27 -07:00
• 5c1df4e306 replace=True and ignore=True parameters for create_view(), closes #106 Simon Willison 2020-05-02 09:02:04 -07:00
• b4d953d3cc Release 2.7.1, refs #102 #104 #105 2.7.1 Simon Willison 2020-05-01 15:08:37 -07:00
• d56029549a Serialize JSON with non-JSON values, closes #102 Simon Willison 2020-05-01 13:45:39 -07:00
• 344e9573ca Added sqlite-utils views command, closes #105 Simon Willison 2020-05-01 13:38:28 -07:00
• 147b52622d sqlite-utils tables ... --schema option, closes #104 Simon Willison 2020-05-01 10:09:36 -07:00
• 2b40710e9d
  Changelog badge Simon Willison 2020-04-30 11:32:23 -07:00
• f58f746424 Release 2.7 - refs #100 2.7 Simon Willison 2020-04-17 17:04:50 -07:00
• 7ce07705ed
  Improved README. Fixes #101 Simon Willison 2020-04-17 16:59:47 -07:00
• 2ab62bcd54 New columns= parameter for over-riding column types, closes #100 Simon Willison 2020-04-17 16:53:25 -07:00
• cd146bbbfa Fixed RST underlines Simon Willison 2020-04-17 10:58:08 -07:00
• 31d3df0f79
  Typo fix Simon Willison 2020-04-16 15:21:40 -07:00
• 13528faa81 Release 2.6 2.6 Simon Willison 2020-04-15 20:13:13 -07:00
• 125c625fbc .rows_where(..., order_by=) argument, closes #76 Simon Willison 2020-04-15 20:12:55 -07:00
• fc38868bd4 Refactored tests into new test_rows.py, refs #76 Simon Willison 2020-04-15 18:04:51 -07:00
• ad6ac19470 Release 2.5 2.5 Simon Willison 2020-04-12 20:52:19 -07:00
• 729a3e7869 Tests for Database(..., recreate=True), refs #97 Simon Willison 2020-04-12 20:47:36 -07:00
• 7e4b9997c2 Database(..., recreate=True) option, refs #97 Simon Willison 2020-04-12 20:46:51 -07:00
• 635c91475a Only set last_pk on singular .insert()/.update(), refs #98 Simon Willison 2020-04-12 20:22:32 -07:00
• 6161ebf4de
  Fixed incorrect usage example Simon Willison 2020-04-12 11:44:08 -07:00
• 8ea626e5fc
  Add type conversion for Panda's Timestamp (#96) bob 2020-03-31 00:40:48 -04:00
• 16ebbd2d49
  Fix for Black formatting Simon Willison 2020-03-30 21:37:50 -07:00
• fdf7cb4a98
  Add type conversion for Panda's Timestamp bob 2020-03-29 09:36:30 -04:00
• 22250a9c73 Release 2.4.4 2.4.4 Simon Willison 2020-03-23 13:32:09 -07:00
• b436bdb594 Fixed bug with null columns, closes #95 Simon Willison 2020-03-23 13:31:06 -07:00
• 3db9881970 Release 2.4.3 2.4.3 Simon Willison 2020-03-23 12:58:55 -07:00
• 1c745df923 Suggest column types ignores nulls, closes #94 Simon Willison 2020-03-23 12:57:02 -07:00
• 755580e2f3 Release 2.4.2 2.4.2 Simon Willison 2020-03-14 13:09:56 -07:00
• daf2a245aa Unit tests covering column_affinity, refs #92 Simon Willison 2020-03-14 13:05:07 -07:00
• 1125460497 Improved column type introspection, closes #92 Simon Willison 2020-03-14 13:04:06 -07:00
• 43f1c6ab4e
  Documentation for NotFoundError Simon Willison 2020-03-06 15:08:21 -06:00
• 8f19bbed02 Release 2.4.1 2.4.1 Simon Willison 2020-03-01 22:12:21 -08:00
• 0c36feb6ca .enable_fts() now works with columns with spaces in them, closes #90 Simon Willison 2020-03-01 22:10:43 -08:00
• 2ac4ea3c95 Fixed typo in changelog Simon Willison 2020-02-26 20:59:01 -08:00
• 277d4e55c4 Release 2.4 2.4 Simon Willison 2020-02-26 20:55:58 -08:00
• 04ec53c039 Validate column names in more places, refs #86 Simon Willison 2020-02-26 20:55:17 -08:00
• 67dd3106d5 Changelog for 2.4 Simon Willison 2020-02-26 20:46:13 -08:00
• f9473ace14 disable-fts and .disable_fts(), closes #88 Simon Willison 2020-02-26 20:40:35 -08:00
• b0ca657f49 Disallow square braces in column names, closes #86 Simon Willison 2020-02-26 20:16:02 -08:00
• 685e6a1bb3 Detect subclasses of dict/tuple/list, fixes #87 Simon Willison 2020-02-15 18:20:39 -08:00
• 5e0000609f Try using Travis Pythons that are not -dev 2.3.1 Simon Willison 2020-02-10 21:52:23 -08:00
• 45df15fe23 Attempt to fix the build Simon Willison 2020-02-10 21:19:54 -08:00
• de45597327 Release 2.3.1 Simon Willison 2020-02-10 21:15:10 -08:00
• 6f3cb2c106 create_index now works with columns with spaces, closes #85 Simon Willison 2020-02-10 21:13:15 -08:00
• 0c2451e069 Release 2.3 2.3 Simon Willison 2020-02-08 15:56:16 -08:00
• 0eda638d81 table.exists() now a documented method, closes #83 Simon Willison 2020-02-08 15:56:03 -08:00
• 4cbade2564 Release 2.2.1 2.2.1 Simon Willison 2020-02-06 23:20:03 -08:00
• 7c28a4d133 Fix for upsert(hash_id=) bug, closes #84 Simon Willison 2020-02-06 23:17:06 -08:00
• 72fa16b3d9 Release 2.2 2.2 Simon Willison 2020-02-01 13:59:08 -08:00
• de76168be5 Docs for suggest_column_types, closes #81 Simon Willison 2020-02-01 13:55:13 -08:00
• 5ecf3ffdea Extracted detect_column_types as suggest_column_types, refs #81 Simon Willison 2020-02-01 13:38:26 -08:00
• 45bf0c2549 on_create mechanism for after table creation Simon Willison 2020-01-30 19:38:08 -08:00
• f7289174e6 Release 2.1 2.1 Simon Willison 2020-01-30 16:25:20 -08:00
• e8b2b7383b
  New conversions= feature, closes #77 Simon Willison 2020-01-30 16:24:30 -08:00
• 0988f2eccc
  Explicitly include tests and docs in sdist (#75) John Vandenberg 2020-01-31 07:21:26 +07:00
• 58190d6782 Documentation for conversions= feature Simon Willison 2020-01-30 16:19:41 -08:00
• 6ea793b6e5 New conversions= feature, refs #77 Simon Willison 2020-01-30 16:02:13 -08:00
• 39a836450b Explicitly include tests and docs in sdist John Vandenberg 2020-01-07 11:51:34 +07:00
• 59a2e8ebdc Release 2.0.1 2.0.1 Simon Willison 2020-01-05 09:23:02 -08:00
• 489eda92bc .upsert() and upsert_all() require pk=, closes #73 Simon Willison 2020-01-05 09:20:11 -08:00
• 1f3f902ea4 Typo Simon Willison 2019-12-30 05:01:36 -08:00
• 6b79cb706a Removed rogue parenthesis Simon Willison 2019-12-29 22:51:07 -08:00
• c6c2e7184b Release 2.0 2.0 Simon Willison 2019-12-29 22:18:58 -08:00
• 0b0a431bff Changelog for 2.0 release Simon Willison 2019-12-29 22:18:44 -08:00
• f0f15d3dc8 Reformatted with black Simon Willison 2019-12-29 22:09:52 -08:00
• a0f0175d64 Updated help for upsert, refs #66 Simon Willison 2019-12-29 22:05:31 -08:00
• 468d51314a test_upsert_compound_primary_key Simon Willison 2019-12-29 21:31:03 -08:00
• 9f47e8b9a4 Documentation for new upsert v.s insert-replace Simon Willison 2019-12-29 21:23:58 -08:00
• 84bcabd093 New upsert implementation, refs #66 Simon Willison 2019-12-29 21:03:43 -08:00
• cfbc09967e Ran black, plus added comments for next step Simon Willison 2019-12-27 09:30:29 +00:00
• 607a2a9ff6 insert --replace and insert(..., replace=True) Simon Willison 2019-12-27 09:15:31 +00:00
• ab8a4bda75 Documentation for new upsert v.s insert-replace real-upsert Simon Willison 2019-12-29 21:23:58 -08:00
• 4a2244b3e3 New upsert implementation, refs #66 Simon Willison 2019-12-29 21:03:43 -08:00
• 79cc8b854c Ran black, plus added comments for next step Simon Willison 2019-12-27 09:30:29 +00:00
• 866a5bc487 insert --replace and insert(..., replace=True) Simon Willison 2019-12-27 09:15:31 +00:00
• dc0a62556e Run Travis tests on Ubuntu Bionic, fixes #71 Simon Willison 2019-12-27 09:46:51 +00:00
• b64fefcf05 Try bionic, refs #71 travis-bionic Simon Willison 2019-12-27 09:46:51 +00:00
• 9262c3e7c0
  Corrected Database(memory=True) documentation Simon Willison 2019-12-18 09:00:36 +00:00
• 4c6e5a4486
  Run tests against 3.5 too travis-3.5 Simon Willison 2019-11-27 06:20:21 -08:00
• 0a0cec3cf2
  Release 1.12.1 1.12.1 Simon Willison 2019-11-06 20:58:47 -08:00
• 28f8a238ab
  Release notes release-1.12.1 Simon Willison 2019-11-06 20:54:46 -08:00
• ed34c8032d
  Release 1.12.1 Simon Willison 2019-11-06 20:51:22 -08:00
• 8dab9fd1cc
  insert_all() / .upsert_all() work with empty list (#64) Simon Willison 2019-11-06 20:32:37 -08:00
• 8daea7f126
  Handle empty lists empty-list Simon Willison 2019-11-06 20:27:11 -08:00
• ace7a97b2b
  test_insert_upsert_all_empty_list Simon Willison 2019-11-06 20:24:41 -08:00
• a0a65f9a64 Release 1.12 1.12 Simon Willison 2019-11-04 08:28:52 -08:00
• 169ea455fc Added table.delete_where(), closes #62 Simon Willison 2019-11-04 08:18:06 -08:00
• 19073d6d97 Added table.delete(pk) method, refs #62 Simon Willison 2019-11-04 08:07:44 -08:00
• eb39c84a8f Test and docs for using :memory: as a filename Simon Willison 2019-10-04 09:17:27 -07:00
• d5e1f8ac77 Release 1.11 1.11 Simon Willison 2019-09-02 17:58:41 -07:00
• 3a4dddaca2 Documentation for create-triggers, refs #57 Simon Willison 2019-09-02 17:10:26 -07:00
• 2ca63e3b2d
  db.triggers and table.triggers introspection (#60) Simon Willison 2019-09-02 17:09:41 -07:00
• b0a27fbb34 db.triggers and table.triggers introspection introspect-triggers Simon Willison 2019-09-02 17:03:25 -07:00