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

#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

• 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
• 19c1640876 Docs for .transform() add_foreign_keys= and foreign_keys=, refs #577 Simon Willison 2023-08-17 17:38:43 -07:00
• 829a407db4 Tests for .transform(foreign_keys=, add_foreign_keys=), refs #577 Simon Willison 2023-08-17 17:30:13 -07:00
• 993029f466 flake8 fixes Simon Willison 2023-08-17 17:10:44 -07:00
• 0771ac61fe Update .add_foreign_key() and .add_foreign_keys() docs, refs #577 Simon Willison 2023-08-17 17:15:38 -07:00
• 6f6aca1329 flake8 fixes Simon Willison 2023-08-17 17:10:44 -07:00
• 63973d6af0 Fixed mypy issue, refs #584 Simon Willison 2023-08-17 17:05:40 -07:00
• 1c6973baa8 Fixed dumb bug I just introduced Simon Willison 2023-08-17 16:56:10 -07:00
• 7396d085fe Fixed two mypy errors Simon Willison 2023-08-17 16:54:38 -07:00
• 374506a7ed Fix for last issue relating to #577 Simon Willison 2023-08-17 16:43:40 -07:00
• 842b61321f Use .transform() instead of modifying sqlite_master for add_foreign_keys(), refs #577 Simon Willison 2023-08-17 16:32:15 -07:00
• 1dc6b5aa64 Note about execute_plugins=False, refs #575 Simon Willison 2023-08-07 11:47:34 -07:00
• 619cea8681 sqlite-utils convert --pdb option, closes #581 Simon Willison 2023-07-26 14:06:05 -07:00
• 5e9a02153d Fix bug with --editable Simon Willison 2023-07-25 22:20:49 -07:00
• 37e374e05a Improved convert() function documentation Simon Willison 2023-07-25 07:47:29 -07:00
• fba26d3564
  Typo in release notes Simon Willison 2023-07-24 22:54:13 -07:00
• 8bee145886
  Link 3.34 notes to new blog entry Simon Willison 2023-07-24 10:22:20 -07:00
• 13ebcc575d Backfilled release notes for 0.2, 0.3, 0.3.1 - closes #576 Simon Willison 2023-07-22 22:48:14 -07:00
• c728c25555 Undo change which broke the tests 3.34 Simon Willison 2023-07-22 16:25:14 -07:00
• 3e1d467c52 Last minute changelog for register_commands() for 3.34 Simon Willison 2023-07-22 16:22:18 -07:00
• 778dad789e More robust _called_from_test pattern Simon Willison 2023-07-22 16:21:27 -07:00
• e337a88b45 Tweaks to prepare_connection() example in docs, refs #574 Simon Willison 2023-07-22 16:13:46 -07:00
• 374a816c72 Database(..., execute_plugins=False) mechanism, refs #575 Simon Willison 2023-07-22 16:06:11 -07:00
• 3f80a02698
  prepare_connection plugin hook Alex Garcia 2023-07-22 15:59:08 -07:00
• faf398fe07
  Removed a rogue colon Simon Willison 2023-07-22 15:55:46 -07:00
• 9631d9acdf
  Documentation tweaks Simon Willison 2023-07-22 15:55:11 -07:00
• f2e2700477
  Fixed prepare_connection heading Simon Willison 2023-07-22 15:51:08 -07:00
• 80a5020e6d import Database after defining hookimpl Alex Garcia 2023-07-22 15:48:31 -07:00
• 091c63cfbf Release 3.34 Simon Willison 2023-07-22 15:47:56 -07:00
• 249d7de7b2 Link to docs on distributing plugins, refs #567 Simon Willison 2023-07-22 15:45:23 -07:00
• 61aaa69815 .transform(..., keep_table=name) parameter, closes #571 Simon Willison 2023-07-22 15:32:09 -07:00
• ae973e794b feat: Implement a prepare_connection plugin hook Alex Garcia 2023-07-22 15:31:53 -07:00
• 2c12c01346 Caling .transform() also reformats the schema, closes #564 Simon Willison 2023-07-22 15:15:30 -07:00
• fedd477e01 Don't attempt tui stuff on Python 3.7, refs #572 Simon Willison 2023-07-22 15:11:38 -07:00
• 18f190e283 sqlite-utils rename-table command, refs #565 Simon Willison 2023-07-22 12:48:04 -07:00
• 82e8cd3667 db.rename_table() method, refs #565 Simon Willison 2023-07-22 12:38:31 -07:00
• 86a352f8b7 Fixed mypy error, refs #568 Simon Willison 2023-07-22 12:27:41 -07:00
• 0c563e2d13 Fixed test I broke in #568 Simon Willison 2023-07-22 12:23:42 -07:00
• 2d55f185ff Applied Black, refs #568 Simon Willison 2023-07-22 12:22:15 -07:00
• 80b5fa7f12 Documentation for replace=True/ignore=True, refs #568 Simon Willison 2023-07-22 12:19:01 -07:00
• 58b577279f table.create(..., replace=True / ignore = True) closes #568 Simon Willison 2023-07-22 12:15:40 -07:00
• b379a2a0c3 Added pluggy and first hook, register_commands - refs #569, #567 Simon Willison 2023-07-22 12:04:31 -07:00
• bff240032d pygments-csv-lexer Simon Willison 2023-07-22 11:45:45 -07:00
• 7e48502b5a Update CLI reference docs for -e, refs #570 Simon Willison 2023-07-22 11:37:53 -07:00
• ef31210bf0 sqlite-utils install -e, closes #570 Simon Willison 2023-07-22 11:32:42 -07:00
• f7af23837d --empty-null option for CSV and TSV imports, closes #563 Simon Willison 2023-07-02 22:42:26 -07:00
• 63dc7ab1a5 Fixed a complaint from ruff check Simon Willison 2023-06-29 13:41:08 -07:00
• 8c739558f7 --stop-after option, closes #561 Simon Willison 2023-06-27 11:50:04 -07:00
• 9d38925cde Release 3.33 3.33 Simon Willison 2023-06-25 18:31:22 -07:00
• f5c63088e1
  Use sqlean if available in environment (#560) Simon Willison 2023-06-25 16:25:51 -07:00
• 5e7d27e5df Removed unused import Simon Willison 2023-06-25 16:06:54 -07:00
• 1c0b8cbc04 Fix for cannot change into wal mode from within a transaction Simon Willison 2023-06-25 15:52:22 -07:00
• 01e92b0173 Skip SpatiaLite tests with sqlean.py Simon Willison 2023-06-25 15:31:24 -07:00
• 31bde41baf db.iterdump() method uses sqlite-dump if available Simon Willison 2023-06-25 15:29:00 -07:00
• 5f0517fb11 Updated tests to handle unexpected sqlite_stat4 table, refs #559 Simon Willison 2023-06-25 14:46:24 -07:00
• eee72b7be7 On macOS with Python 3.10 test with sqlean.py, refs #559 Simon Willison 2023-06-25 14:08:00 -07:00
• 802b970ca6 Documentation for pysqlite3 and sqlean, refs #235, #559 Simon Willison 2023-06-25 14:05:38 -07:00
• 1f3ddea08b Ignore missing imports for pysqlite3 and sqlean, refs #559 Simon Willison 2023-06-25 13:57:07 -07:00
• 572d9ed7b3 sqlean/pysqlite3 avoiding mypy errors Simon Willison 2023-06-23 11:00:33 -07:00
• aac05c31c7
  mypy ignore Simon Willison 2023-06-23 09:40:32 -07:00
• fa484a9958
  Try sqlean too Simon Willison 2023-06-23 09:35:35 -07:00
• 2747257a33 Fixed link in changelog 3.32.1 Simon Willison 2023-05-21 14:11:54 -07:00
• 6fb32d27ae Release 3.32.1 Simon Willison 2023-05-21 14:09:46 -07:00
• 87bddef8fd Documented bash/zsh completion, closes #552 Simon Willison 2023-05-21 14:03:32 -07:00
• 8188acc1f1 Fix for missing csv Pygments support, refs #551 Simon Willison 2023-05-21 14:03:03 -07:00
• d8fe1b0d89
  Reformatted CLI examples in docs Simon Willison 2023-05-21 13:57:22 -07:00
• 21036a5084 Final review of documentation fixes Simon Willison 2023-05-21 13:56:59 -07:00
• 0b817944f7 Reformatted CLI examples in docs, refs #551 Simon Willison 2023-05-21 13:44:01 -07:00
• e240133b11 Release 3.32 3.32 Simon Willison 2023-05-21 11:53:33 -07:00
• 5587da085d Release 3.32 trogon Simon Willison 2023-05-21 11:53:33 -07:00
• 718b0cba9b
  Experimental TUI powered by Trogon Simon Willison 2023-05-21 11:41:56 -07:00
• 948692a94b only run flake8 on Python 3.8 or higher, refs #550 Simon Willison 2023-05-21 11:26:27 -07:00
• e4cff2236b Ignore trogon mypy error Simon Willison 2023-05-21 11:14:34 -07:00
• c4fec77eea It's trogon not trogan Simon Willison 2023-05-21 10:59:08 -07:00
• 0ac8ca972b Fixed command documentation test for tui Simon Willison 2023-05-21 10:57:42 -07:00
• f3120f06a3 Screenshot of TUI, refs #545 Simon Willison 2023-05-21 10:55:19 -07:00
• b1a2bb1dbf Documentation for trogon TUI, refs #545 Simon Willison 2023-05-21 10:53:22 -07:00
• e8c5b042e4 Validate column names in analyze-columns, closes #548 Simon Willison 2023-05-21 10:35:48 -07:00
• 6027f3ea69 No need to show common values if everything is null Simon Willison 2023-05-21 10:19:16 -07:00
• d2a7b15b2b
  Analyze tables options: --common-limit, --no-most, --no-least Simon Willison 2023-05-21 09:19:30 -07:00
• 2eca17d46e Tests for --common-limit, --no-most, --no-least, refs #544 analyze-tables-options Simon Willison 2023-05-21 09:17:54 -07:00
• 9f23e68cf0 Tests and docs for new analyze_column() parameters, refs #544 Simon Willison 2023-05-21 09:06:21 -07:00
• 9e9d63b989 Docs for --no-most --no-least --common-limit, refs #544 Simon Willison 2023-05-21 08:53:10 -07:00
• ec12b780d5 sqlite-utils tui command if Trogon is installed, refs #545 Simon Willison 2023-05-21 07:10:20 -07:00
• 1c1991b447 New options for analyze-tables - refs #544 Simon Willison 2023-05-21 07:02:02 -07:00
• e047cc32e9
  backwards-incompatible, not compatible Simon Willison 2023-05-09 14:08:31 -07:00
• b3b100d7f5 Release 3.31 3.31 Simon Willison 2023-05-08 15:33:57 -07:00
• c764a9ee8f Avoid negative hashes in lambda names, refs #543 Simon Willison 2023-05-08 15:12:39 -07:00
• dab23884ae Better error message if rows_from_file called with StringIO, closes #520 Simon Willison 2023-05-08 15:08:02 -07:00
• eebd1a26ae Removed FunctionAlreadyRegistered error, refs #526, #525 Simon Willison 2023-05-08 14:58:28 -07:00
• fca3ef8cf2 Applied Black, refs #526, #525 Simon Willison 2023-05-08 14:54:24 -07:00
• 02f5c4d69d
  Support repeated calls to Table.convert() Martin Carpenter 2023-05-08 23:53:58 +02:00
• 6500fed8b2
  Transform no longer breaks non-string default values rhoboro 2023-05-09 06:13:36 +09:00
• 923768db2e Assert on exact error message, refs #537 Simon Willison 2023-05-08 14:11:48 -07:00
• 39ef137e67
  Support self-referencing FKs in create (#537) Scott Perry 2023-05-08 14:10:00 -07:00
• 9662d4ce26 Updated cog, refs #527 Simon Willison 2023-05-08 14:05:30 -07:00
• e0ec4c3451 --no-skip-false option, plus docs - closes #527 Simon Willison 2023-05-08 14:03:20 -07:00
• 455c35b512 .convert(skip_false) option, refs #527 Simon Willison 2023-05-08 13:52:21 -07:00
• e4ed372517 Show more detailed error on invalid JSON, closes #532 Simon Willison 2023-05-08 13:31:56 -07:00