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

• 2376c452a5 upsert_all() now works with not_null - refs #538 Simon Willison 2023-05-08 12:24:10 -07:00
• 80763edaa2
  Different approach for Python 3.11 on ReadTheDocs Simon Willison 2023-05-07 11:40:47 -07:00
• 963518bb16
  Build with 3.11 on ReadTheDocs Simon Willison 2023-05-07 11:38:54 -07:00
• 373b7886d2 --raw-lines option, closes #539 Simon Willison 2023-05-07 11:26:03 -07:00
• 8f9a729e8a
  Add paths for homebrew on Apple silicon (#536) Chris Amico 2023-04-12 21:44:43 -04:00
• a75abeb61b Support self-referencing FKs in create Scott Perry 2023-04-12 13:26:15 -07:00
• cea05dc5ea Add paths for homebrew on Apple silicon Chris Amico 2023-04-08 09:32:13 -04:00
• afdf618771 Merge branch 'main' of github.com:simonw/sqlite-utils into spatialite-paths-update Chris Amico 2023-04-07 14:16:49 -04:00
• c0251cc927
  Link /latest/ to /stable/ - refs #388 Simon Willison 2023-03-26 16:42:01 -07:00
• 92f77c3262 Ran against updated Black Simon Willison 2023-03-12 14:28:43 -07:00
• 6cd0fd2b4c Fix for Sphinx bug, closes #533, refs #531 Simon Willison 2023-03-12 14:25:26 -07:00
• 0e4750dff0 Add paths for homebrew on Apple silicon and use those paths when passed in Chris Amico 2023-03-11 17:26:05 -05:00
• a09df3844a Enable Table.convert() on falsey values Martin Carpenter 2023-02-09 23:51:40 +01:00
• 486e0cc1cd Raise exception on registering identical function names Martin Carpenter 2023-02-09 00:59:53 +01:00
• a158445db5 Register Table.convert() functions under their own name Martin Carpenter 2023-02-09 00:05:57 +01:00
• fc73af7a55 Test repeated calls to Table.convert() Martin Carpenter 2023-02-08 23:29:59 +01:00
• 1806da14d6
  Try a buildjet-16vcpu-ubuntu-2204 runner buildjet-16vcpu-ubuntu-2204 Simon Willison 2023-01-12 15:54:09 -08:00
• 5e5c262fab Fixes an issue #509 rhoboro 2022-12-17 21:22:44 +09:00
• fc221f9b62 Try this fix for flake8 error, refs #518 Simon Willison 2022-12-09 17:30:45 -08:00
• e660635cea Drop support for Python 3.6, refs #517 Simon Willison 2022-12-09 17:25:23 -08:00
• ebe504ab21 Clarify column types in create-table help Simon Willison 2022-11-29 09:03:35 -08:00
• 32f8173a8f upsert new rows with constraints Colin Dellow 2022-11-26 11:11:06 -05:00
• 965ca0d5f5 Apply no_implicit_optional codemod, closes #512 Simon Willison 2022-11-15 22:25:26 -08:00
• 52ddb0b9ff
  Rename utility functions to library Simon Willison 2022-11-15 07:53:38 -08:00
• 43a8c4c91f
  Update db.py Jacob Chapman 2022-10-31 17:53:53 -05:00
• 2d6a14938a
  Allow surrogates in parameters Jacob Chapman 2022-10-31 17:11:35 -05:00
• 529110e7d8
  GitHub Actions has Python 3.11 on macOS now Simon Willison 2022-10-26 12:27:32 -07:00
• fb8f495582
  Skip macOS 3.11 test when publishing 3.30 Simon Willison 2022-10-25 15:34:30 -07:00
• 0d45ee1102 Release 3.30 Simon Willison 2022-10-25 15:21:34 -07:00
• defa2974c6 jsonify_if_needed output of convert() functions, closes #495 Simon Willison 2022-10-25 14:23:24 -07:00
• c7e4308e6f Use new db.close() method, refs #504 Simon Willison 2022-10-25 14:00:53 -07:00
• 05e2bb85fc db.close() method, closes #504 Simon Willison 2022-10-25 13:57:43 -07:00
• ba7242b1f2 Try closing the database before recreating it, refs #503 Simon Willison 2022-10-25 13:36:17 -07:00
• f6b796277f Try a 0.1s sleep, refs #503 Simon Willison 2022-10-25 13:27:18 -07:00
• c5d7ec1dd7 Fix for mypy issue, refs #503 Simon Willison 2022-10-25 13:21:37 -07:00
• 7ca497a8f5 repr improvements, refs #503 Simon Willison 2022-10-25 13:14:41 -07:00
• 079bf1f4dc Use tmp_path fixture in test_recreate, refs #503 Simon Willison 2022-10-25 13:06:58 -07:00
• 7b2d1c0ffd Update tests for Python 3.11, closes #502 Simon Willison 2022-10-25 12:23:20 -07:00
• 5133339d00
  Skip macos-latest Python 3.11 for the moment Simon Willison 2022-10-25 12:08:58 -07:00
• b8526c434a
  Test against Python 3.11 Simon Willison 2022-10-25 07:17:49 -07:00
• 9cbe19ac05 Skip cog check on Python 3.6, refs #501 Simon Willison 2022-10-18 11:16:43 -07:00
• eb67fc69a2 Run cog -r against latest tabulate, refs #501 Simon Willison 2022-10-18 11:08:34 -07:00
• 34e75ed0dd sqlite_utils.utils.flatten() function, closes #500 Simon Willison 2022-10-18 11:00:25 -07:00
• a25e83841f
  feat: recreate fts triggers after table transform Jacob Chapman 2022-10-11 15:35:03 -05:00
• 75577e595d
  fix: enable-fts create triggers Jacob Chapman 2022-10-11 00:07:48 -05:00
• d792dad1cf
  Clarify wording Simon Willison 2022-09-26 19:23:17 -07:00
• cbed080782
  Typo Simon Willison 2022-09-26 17:10:59 -07:00
• cf9861216b Comment for 'just docs' command Simon Willison 2022-09-26 12:36:09 -07:00
• c7cad6fc25 Documentation for Just, closes #494 Simon Willison 2022-09-26 12:26:31 -07:00
• 6b268a1b36 language = "en" to fix Sphinx warning Simon Willison 2022-09-26 12:26:04 -07:00
• afbd2b2cba Link to convert command too, refs #483 Simon Willison 2022-09-26 12:09:32 -07:00
• 9a5add659d 'just docs' command for running the livehtml docs server Simon Willison 2022-09-26 12:09:00 -07:00
• ee74bd5f81 Fix heading levels, refs #483 Simon Willison 2022-09-26 12:03:54 -07:00
• 85247038f7 install and uninstall commands, closes #483 Simon Willison 2022-09-26 11:57:11 -07:00
• 1689807024 --key and --auto-key prototype, refs #489 auto-key Simon Willison 2022-09-15 13:56:54 -07:00
• 0b315d3fa8
  progressbar for inserts/upserts of other file formats Mischa Untaga 2022-09-15 22:37:51 +02:00
• d5db749480
  Pin to Python 3.10.6 for the moment Simon Willison 2022-09-15 13:22:35 -07:00
• 0acbc68545
  Applied Black Simon Willison 2022-09-15 12:33:04 -07:00
• 5fd78e27d2 progressbar for inserts/upserts of all fileformats, closes #485 Mischa Untaga 2022-09-08 16:56:52 +02:00
• d9b9e075f0 Documented the release process Simon Willison 2022-09-06 20:45:36 -07:00
• 5b969273f1
  Markup tweak Simon Willison 2022-09-01 18:44:56 -07:00
• 686eed9a49
  Typo in release notes Simon Willison 2022-09-01 18:37:13 -07:00
• ecf1d40112
  table.search_sql(include_rank=True) option (#480) Jacob Chapman 2022-08-30 22:40:35 -05:00
• 3dbfca6fdd
  Apply Black Simon Willison 2022-08-30 20:32:55 -07:00
• 8942df36e3 add FTS4 test Jacob Chapman 2022-08-30 16:22:53 -05:00
• b1b9b0aa5a add test Jacob Chapman 2022-08-30 16:19:47 -05:00
• d40df56acc
  include docstring Jacob Chapman 2022-08-30 10:13:40 -05:00
• 863dd03c67
  search_sql add include_rank option Jacob Chapman 2022-08-30 04:08:55 -05:00
• 087753cd42 sites.db is better name than dogs.db in this example Simon Willison 2022-08-27 21:01:55 -07:00
• b491f22d81 Release 3.29 3.29 Simon Willison 2022-08-27 20:48:36 -07:00
• 165bc5fcb0 test_extract_works_with_null_values, refs #423, #455 Simon Willison 2022-08-27 20:32:01 -07:00
• 365f62520f will, not may - refs #468 Simon Willison 2022-08-27 16:20:35 -07:00
• dacdcf1a42 test_extract_works_with_null_values, refs #423, #455 create-transform Simon Willison 2022-08-27 20:32:01 -07:00
• cdb6e1b659 will, not may - refs #468 Simon Willison 2022-08-27 16:20:35 -07:00
• 104f37fa4d
  db[table].create(..., transform=True) and create-table --transform Simon Willison 2022-08-27 16:17:55 -07:00
• 2f6a64f61d Documentation for create-table --transform option, refs #467 Simon Willison 2022-08-27 16:11:37 -07:00
• fc38480e02 Docs for .create(transform=True), refs #467 Simon Willison 2022-08-27 16:03:35 -07:00
• 6d4efd2949 transform=True for differing column types, refs #467 Simon Willison 2022-08-27 16:00:54 -07:00
• 1ac5d4e39d Handle changed defaults, refs #467 Simon Willison 2022-08-27 15:53:53 -07:00
• 36ffcafb1a table.default_values property, closes #475 Simon Willison 2022-08-27 15:41:10 -07:00
• 341f000097 not_null support for .create(transform=True), refs #467 Simon Willison 2022-08-27 15:42:47 -07:00
• 9e3d8abc58 table.default_values property, closes #475 Simon Willison 2022-08-27 15:41:10 -07:00
• 5fdf4d9731
  Merge branch 'main' into create-transform Simon Willison 2022-08-27 15:12:58 -07:00
• 1e7959d7a6 Initial tests for .create(..., transform=True), refs #467 Simon Willison 2022-08-27 15:11:59 -07:00
• 5ef47d6c30 sqlite-utils create-table --transform, refs #467 Simon Willison 2022-08-27 07:54:54 -07:00
• c5f8a2eb1a
  in extract code, check equality witH IS instead of = for nulls (#455) Forest Gregg 2022-08-27 10:45:03 -04:00
• 19dd077944
  Support entrypoints for --load-extension (#473) Simon Willison 2022-08-26 22:55:47 -07:00
• 72db599ae0 Fix load extension tests, refs #470 Simon Willison 2022-08-26 22:50:59 -07:00
• dac8dec343 Show directory content after compiling, refs #470 Simon Willison 2022-08-26 22:40:03 -07:00
• 3f694e51a0 Load extension entrypoint support, refs #470 Simon Willison 2022-08-26 22:34:48 -07:00
• a46a5e3a9e Improved code compilation pattern, closes #472 Simon Willison 2022-08-26 22:20:09 -07:00
• 23ef1d6c20 bulk --functions, closes #471 Simon Willison 2022-08-26 22:10:43 -07:00
• 59e2cfbdc1 sqlite-utils memory --functions, refs #471 Simon Willison 2022-08-26 22:03:53 -07:00
• 85e7411bbd Skip test if pragma_function_list not supported, refs #471 Simon Willison 2022-08-26 22:01:58 -07:00
• 31f062d4a7 sqlite-utils query --functions option, refs #471 Simon Willison 2022-08-26 21:53:55 -07:00
• 7a9a6363ff sqlite-utils rows --order option, closes #469 Simon Willison 2022-08-26 21:10:20 -07:00
• b09b7a5129 Docstring tweak Simon Willison 2022-08-23 10:30:44 -07:00
• 5a738ed793 Remove unused import Simon Willison 2022-08-23 10:28:42 -07:00
• 8250b201c2 mypy fixes, refs #467 Simon Willison 2022-08-23 10:26:03 -07:00
• 8e3df0acce Initial tranform=True prototype for #467 Simon Willison 2022-08-23 10:20:46 -07:00