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

• b579a9c8ae Add new gis.py module with spatialite helper methods Chris Amico 2022-01-13 22:52:08 -05:00
• 74586d3cb2 Release 3.22 3.22 Simon Willison 2022-01-11 15:44:48 -08:00
• 3b632f0a7e sqlite-utils rows --where and -p options, closes #382 Simon Willison 2022-01-11 15:32:43 -08:00
• 324ebc3130 sqlite-utils rows --limit and --offset options, closes #381 Simon Willison 2022-01-11 15:19:29 -08:00
• 1d44b0cc27 CLI reference page, maintained by cog, closes #383 Simon Willison 2022-01-11 13:43:39 -08:00
• 5f38c81601
  Fixed typo Simon Willison 2022-01-11 11:20:34 -08:00
• 5737a3aab4
  Link to annotated release notes Simon Willison 2022-01-11 11:18:35 -08:00
• 2448e45ddb
  upsert command, not update command Simon Willison 2022-01-11 10:06:50 -08:00
• 7c637b1180 Release 3.21 3.21 Simon Willison 2022-01-10 18:33:48 -08:00
• 60740a498b Release 3.21 bulk Simon Willison 2022-01-10 18:33:48 -08:00
• 129141572f
  sqlite-utils bulk command Simon Willison 2022-01-10 18:10:54 -08:00
• f4ea0d32c0 Documentation for sqlite-utils bulk, refs #377 Simon Willison 2022-01-10 17:59:56 -08:00
• 71e546e105 Tests for sqlite-utils bulk, refs #377 Simon Willison 2022-01-10 17:53:09 -08:00
• de29a10c49 Refactor import_options and insert_upsert_options, refs #377 Simon Willison 2022-01-10 17:47:04 -08:00
• d138a60deb --analyze option for create-index, insert, update commands, closes #379, closes #365 Simon Willison 2022-01-10 17:36:41 -08:00
• 0dbf4b2775 sqlite-utils analyze command, refs #379 Simon Willison 2022-01-10 17:24:17 -08:00
• cf73818136 delete_where(analyze=True), closes #378 Simon Willison 2022-01-10 17:08:05 -08:00
• 131ed27ab0 analyze=True for insert_all/upsert_all, refs #378 Simon Willison 2022-01-10 17:00:34 -08:00
• 5881a80be1 Improved test_create_index_analyze test, refs #378 Simon Willison 2022-01-10 12:02:08 -08:00
• ced9034383 table.create_index(..., analyze=True), refs #378 Simon Willison 2022-01-10 12:00:24 -08:00
• 04e319a18d db.analyze() and table.analyze() methods, refs #366 Simon Willison 2022-01-10 11:48:38 -08:00
• 1b84c175b4 --analyze option for create-index, insert, update commands, closes #379, closes #365 Simon Willison 2022-01-10 17:36:41 -08:00
• e0ef9288fe sqlite-utils analyze command, refs #379 Simon Willison 2022-01-10 17:24:17 -08:00
• 389cbd5792 delete_where(analyze=True), closes #378 Simon Willison 2022-01-10 17:08:05 -08:00
• ab392157f7 analyze=True for insert_all/upsert_all, refs #378 Simon Willison 2022-01-10 17:00:34 -08:00
• 0142c2a3c2 Improved test_create_index_analyze test, refs #378 Simon Willison 2022-01-10 12:02:08 -08:00
• 0d10402f7b table.create_index(..., analyze=True), refs #378 Simon Willison 2022-01-10 12:00:24 -08:00
• 541f64ddb0 db.analyze() and table.analyze() methods, refs #366 Simon Willison 2022-01-10 11:48:38 -08:00
• bb16f52681 Initial sqlite-utils bulk prototype, refs #375 Simon Willison 2022-01-09 21:31:41 -08:00
• b6dad08a83 Keep trying up to ten times, refs #364 Simon Willison 2022-01-09 21:04:51 -08:00
• 046e5246c9 Longer delay to hopefully get test to pass, refs #364 Simon Willison 2022-01-09 20:51:07 -08:00
• e6ae643497 Did not need WAL after all, refs #364 Simon Willison 2022-01-09 20:41:00 -08:00
• cfb3f12358 Only buffer input if --sniff, closes #364 Simon Willison 2022-01-09 20:39:58 -08:00
• d2a79d200f --nl now ignores blank lines, closes #376 Simon Willison 2022-01-09 20:12:39 -08:00
• 2f8879235a Renamed function to fix lint error, refs #348 Simon Willison 2022-01-09 12:39:14 -08:00
• 1d64cd2e5b sqlite-utils create-database command, closes #348 Simon Willison 2022-01-09 12:33:16 -08:00
• f08fe6fd4d Fixed error in docs: it's suffix not extension, refs #372 Simon Willison 2022-01-09 12:18:31 -08:00
• c9ecd0d6a3 stem and suffix columns for insert-files, closes #372 Simon Willison 2022-01-09 12:16:52 -08:00
• 49a54ffb2f Fix for cog error Simon Willison 2022-01-09 12:08:03 -08:00
• 22c8d10dd3 --convert function can now modify row in place, closes #371 Simon Willison 2022-01-09 12:06:02 -08:00
• b8c134059e --fmt now implies --table, closes #374 Simon Willison 2022-01-09 10:07:48 -08:00
• 148e9c7aee Use cog to maintain --fmt list, closes #373 Simon Willison 2022-01-09 09:48:48 -08:00
• e0c476bc38 Fix test for Python 3.6, refs #368 Simon Willison 2022-01-08 18:37:53 -08:00
• 539f5ccd90 Support 'python -m sqlite_utils', closes #368 Simon Willison 2022-01-08 18:33:00 -08:00
• 9848eaa61b Support 'python -m sqlite_utils', closes #368 analyze Simon Willison 2022-01-08 18:33:00 -08:00
• 650f97a08f Initial prototype of .analyze(), refs #366 Simon Willison 2022-01-08 13:34:01 -08:00
• a8f9cc6f64 Add test for chunks(), refs #364 Simon Willison 2022-01-08 13:16:34 -08:00
• 6e46b99134
  Renamed ip to source in example code Simon Willison 2022-01-06 10:01:35 -08:00
• 3d464893ee Release 3.20 3.20 Simon Willison 2022-01-05 22:55:35 -08:00
• a7b29bfaa9 Fixed bug with sqlite-utils upsert --detect-types, closes #362 Simon Willison 2022-01-05 22:28:29 -08:00
• 413f8ed754 --convert --text for iterators, docs for --convert Simon Willison 2022-01-05 22:19:52 -08:00
• 2e4847e493 Implemented --convert for different things, renamed --all to --text Simon Willison 2022-01-05 21:44:04 -08:00
• e66299c6ed Implemented and documented sqlite-utils insert --all Simon Willison 2022-01-05 18:16:51 -08:00
• f1569c9f7f Implemented sqlite-utils insert --lines Simon Willison 2022-01-05 18:10:10 -08:00
• d1ed2f423d Refactored sqlite-utils insert tests into test_cli_insert.py Simon Willison 2022-01-05 17:57:03 -08:00
• 9e286cc6d2 New help for --lines and --all and --convert and --import, refs #356 Simon Willison 2022-01-05 17:32:40 -08:00
• b7f0b88d49 --convert --text for iterators, docs for --convert Simon Willison 2022-01-05 22:19:52 -08:00
• 686db981be Implemented --convert for different things, renamed --all to --text Simon Willison 2022-01-05 21:44:04 -08:00
• 33223856ff Implemented and documented sqlite-utils insert --all Simon Willison 2022-01-05 18:16:51 -08:00
• 9d5b8e23cd Implemented sqlite-utils insert --lines Simon Willison 2022-01-05 18:10:10 -08:00
• a5fdeb18e3 Refactored sqlite-utils insert tests into test_cli_insert.py Simon Willison 2022-01-05 17:57:03 -08:00
• abb6376ad5 New help for --lines and --all and --convert and --import, refs #356 Simon Willison 2022-01-05 17:32:40 -08:00
• f3fd861311
  Removed unneccessary pytest-runner, closes #357 Simon Willison 2021-12-16 12:43:12 -08:00
• 1a7ef2fe20 Better test for rebuild, refs #354 pysqlite3-ci Simon Willison 2021-12-10 16:59:37 -08:00
• ee13f98c2c Better test for rebuild, refs #354 Simon Willison 2021-12-10 16:59:37 -08:00
• 3b2a7c0e5b Refactor test for #149, spitting it from other rebuild test Simon Willison 2021-12-10 16:56:50 -08:00
• 500a35ad4d Also support def convert(value), closes #355 Simon Willison 2021-12-10 16:49:28 -08:00
• 7a43af232e Support nested imports, closes #351 Simon Willison 2021-12-10 16:11:22 -08:00
• a3df483c80 sqlite-utils convert db table column -, refs #353 Simon Willison 2021-12-10 16:01:02 -08:00
• e328db8eba
  Improved schema example for sqlite-utils extract Simon Willison 2021-12-10 13:12:38 -08:00
• 4beb87f446 Fixed typo in workflow Simon Willison 2021-11-29 15:43:04 -08:00
• f70a61e58a
  Merge 71b6c3803e into 213a0ff177 Simon Willison 2021-11-29 23:41:53 +00:00
• 71b6c3803e And now a fix for Black Simon Willison 2021-11-29 15:41:49 -08:00
• f990e134aa Need both mypy and flake8 to ignore this line Simon Willison 2021-11-29 15:39:53 -08:00
• 93b059dd23 Ignore mypy warning about sqlite3.dump Simon Willison 2021-11-29 15:33:02 -08:00
• c91f1e6957 iterdump() workaround for compatibility with pysqlite3 Simon Willison 2021-11-29 15:29:23 -08:00
• e02c8f35d4
  Fixes for new matrix option, refs #347 Simon Willison 2021-11-29 15:20:32 -08:00
• 2cfffbd33d
  Test against pysqlite3 running SQLite 3.37 Simon Willison 2021-11-29 15:17:53 -08:00
• 213a0ff177 Really fix flake8 error, refs #344, #345 Simon Willison 2021-11-29 14:34:40 -08:00
• 1f8178f7e4 Fix flake8 error, refs #344, #345 Simon Willison 2021-11-29 14:29:46 -08:00
• e3f108e0f3 db.supports_strict and table.strict properties, refs #344 Simon Willison 2021-11-29 14:19:30 -08:00
• 126703706e Release 3.19 3.19 Simon Willison 2021-11-20 20:40:47 -08:00
• 33176ad47b
  Run pytest with colors Simon Willison 2021-11-19 00:09:16 -08:00
• 8f386a0d30
  Release 3.19a0 3.19a0 Simon Willison 2021-11-18 23:27:41 -08:00
• 93b21c230a Extra parameters for .lookup(), passed to .insert() - closes #342 Simon Willison 2021-11-18 23:26:50 -08:00
• 3b8abe6087 Release 3.18 3.18 Simon Willison 2021-11-14 19:15:23 -08:00
• ffb54427d3 insert now replaces square braces in column name with underscore, closes #341 Simon Willison 2021-11-14 18:56:35 -08:00
• fb9d61754a Better type signature for hash_id, closes #341 Simon Willison 2021-11-14 18:19:28 -08:00
• 54a2269e91 Optional second argument to .lookup() to populate extra columns, closes #339 Simon Willison 2021-11-14 18:01:56 -08:00
• 9cda5b070f Handle dict/tuple/list mapping to TEXT, closes #338 Simon Willison 2021-11-14 16:36:00 -08:00
• 84007dffa8 Applied Black, refs #322, #328 Simon Willison 2021-11-14 16:28:53 -08:00
• 271b894af5
  Map dict to TEXT Mina Rizk 2021-11-15 02:27:40 +02:00
• bc4c42d688
  Use python-dateutil package instead of dateutils (#324) Denys Pavlov 2021-11-14 18:25:40 -05:00
• adea5bc396 flake8 fix, refs #331 Simon Willison 2021-11-14 15:24:15 -08:00
• 73e214a976 py.typed file so mypy picks up the types, closes #331 Simon Willison 2021-11-14 15:21:04 -08:00
• 12b8c9de25 sqlite-utils memory --flatten, closes #332 Simon Willison 2021-11-14 15:05:00 -08:00
• 13195d8747 Test demonstrating fix for #335 Simon Willison 2021-11-14 14:55:42 -08:00
• e8d958109e create_index(..., find_unique_name=True) option, refs #335 Simon Willison 2021-11-14 14:49:19 -08:00
• 92aa5c9c5d
  Fixed typo Simon Willison 2021-11-11 12:50:22 -08:00
• 095fc64c53 Default values for --attach and --param options Matej Urbas 2021-11-05 21:55:13 +00:00