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

• 5839ddb490 Do not allow --drop without --output or --multi Simon Willison 2021-08-01 14:22:13 -07:00
• dfed7ad18a Use types-python-dateutil Simon Willison 2021-08-01 14:09:59 -07:00
• 53f9088963 Implemented recipes for sqlite-utils convert, refs #251 Simon Willison 2021-08-01 14:01:41 -07:00
• 504ee7015a Rename tests to test_cli_convert, refs #251 Simon Willison 2021-08-01 12:58:47 -07:00
• 89f754cd4b Updated sqlite-utils convert --help, refs #251 Simon Willison 2021-08-01 09:50:57 -07:00
• 58fd02a91c Docs for sqlite-utils convert --multi, refs #251 Simon Willison 2021-08-01 08:47:26 -07:00
• e5163a3b84 Fleshed out documentation for sqlite-utils convert a bit, refs #251 Simon Willison 2021-08-01 08:38:23 -07:00
• 1b152951e5 Initial documentation for sqlite-utils convert, refs #251 Simon Willison 2021-08-01 08:31:41 -07:00
• 6964d67ce1 Began implementation of sqlite-utils convert, refs #251 Simon Willison 2021-07-31 21:33:00 -07:00
• c7e8d72be9 Release 3.13 3.13 Simon Willison 2021-07-24 15:15:27 -07:00
• ab8d4aad0c sqlite-utils schema now takes optional tables, closes #299 Simon Willison 2021-07-24 15:08:36 -07:00
• 8286a66413 sqlite-utils memory --help now mentions --schema Simon Willison 2021-06-28 09:35:01 -07:00
• 8981b9c1f3 Release 3.12 3.12 Simon Willison 2021-06-25 10:59:05 -07:00
• fec6cd55ca Contributing documentation, closes #292 Simon Willison 2021-06-25 10:53:46 -07:00
• ae0f46a789
  Test against Python 3.10-dev 3-10-dev Simon Willison 2021-06-24 18:40:34 -07:00
• 747be6057d Added some more types, refs #266, #290 Simon Willison 2021-06-24 16:06:12 -07:00
• 33c9d00879 Documentation for db.query(), closes #290 Simon Willison 2021-06-24 15:54:38 -07:00
• 93c7fd9868 Ignore this entire file, refs #291 Simon Willison 2021-06-22 19:08:52 -07:00
• 1fba60537d Try more aggressive noqa, refs #291 Simon Willison 2021-06-22 19:06:18 -07:00
• 02898bf7af Run flake8 in CI, refs #291 Simon Willison 2021-06-22 18:23:12 -07:00
• 90e211e3e2 Now complies with flake8, refs #291 Simon Willison 2021-06-22 18:22:08 -07:00
• 8d1d801389 mypy tweaks, refs #289, #266, #37 Simon Willison 2021-06-22 11:08:21 -07:00
• 7b3fdf0fcd mypy annotations for rows_from_file(), run mypy in CI Simon Willison 2021-06-22 11:04:32 -07:00
• 3805d1c973 Removed duplicate vacuum() function, thanks mypy Simon Willison 2021-06-22 10:44:12 -07:00
• e5d7a2ba3d Tests for db.query() method, refs #290 Simon Willison 2021-06-22 10:43:49 -07:00
• 9faeef230b New db.query() method, refs #290 Simon Willison 2021-06-21 21:03:59 -07:00
• 8cedc6a8b2
  Typo fix Simon Willison 2021-06-20 13:44:02 -07:00
• adcd32a866 Re-enable publish testing on macos-latest 3.11 Simon Willison 2021-06-20 11:52:15 -07:00
• a25a5845b8 Release 3.11 Simon Willison 2021-06-20 11:50:48 -07:00
• dbcba6c597 Added installation instructions, closes #286 Simon Willison 2021-06-20 11:47:09 -07:00
• 933be66eba sqlite-utils memory --schema, closes #288 Simon Willison 2021-06-20 11:25:21 -07:00
• 0bb6c7a389
  Merge 8d641ab08a into dce9bb05b6 Simon Willison 2021-06-19 22:33:55 -04:00
• dce9bb05b6 Really fix the anchors this time Simon Willison 2021-06-19 14:43:04 -07:00
• e71c41d39b
  Fixed broken anchors Simon Willison 2021-06-19 13:36:16 -07:00
• eb18b6e42c Disabling macos-latest for the moment 3.10 Simon Willison 2021-06-19 09:09:29 -07:00
• 13e76b375a Release 3.10 Simon Willison 2021-06-19 09:01:39 -07:00
• 0e797033f9 .transform() on rowid (non-pk) tables bug fix, closes #284 Simon Willison 2021-06-19 08:28:26 -07:00
• 5b257949d9 table.use_rowid introspection property, closes #285 Simon Willison 2021-06-19 08:12:29 -07:00
• dc94f4bb8c Don't detect types on JSON input to memory, closes #283 Simon Willison 2021-06-19 07:52:44 -07:00
• ec5174ed40 Detect types for sqlite-utils memory CSV, opt out with --no-detect-types - closes #282 Simon Willison 2021-06-18 21:37:56 -07:00
• fd9867d145 sqlite-utils insert --detect-types option, refs #282 Simon Willison 2021-06-18 21:18:58 -07:00
• 59992d2fee Better help text for 'sqlite-utils memory', refs #272 Simon Willison 2021-06-18 20:20:56 -07:00
• 1091a9cbd8 Add sqlite-utils memory to the README, refs #272 Simon Willison 2021-06-18 20:14:12 -07:00
• 00e4bd5ff1 TSV and JSON support for sqlite-utils memory Simon Willison 2021-06-18 20:11:54 -07:00
• 93594ce15b
  Open CSV in binary mode, refs #280 Simon Willison 2021-06-18 08:36:09 -07:00
• 7684bbf097 --encoding option for sqlite-utils memory, closes #280 Simon Willison 2021-06-18 08:29:41 -07:00
• 42ec59d8ee
  sqlite-utils memory command for directly querying CSV/JSON data Simon Willison 2021-06-18 08:00:52 -07:00
• eea3851d40 Added test, formatted with Black - refs #276, #277 Simon Willison 2021-06-18 07:55:26 -07:00
• aa652b6afe
  add -h support Loren McIntyre 2021-06-18 07:56:59 -07:00
• abbd324a21 add -h support closes #276 Loren McIntyre 2021-06-17 01:00:14 -07:00
• df7a37bdb7 Fixed broken link in changelog Simon Willison 2021-06-16 17:13:44 -07:00
• a19ce1a4d0
  codecov badge, closes #275 Simon Willison 2021-06-16 17:12:11 -07:00
• f003d051e7 Not using .coveragerc, refs #275 Simon Willison 2021-06-16 16:55:53 -07:00
• 276fc4297c Enable codecov.io, refs #275 Simon Willison 2021-06-16 16:54:16 -07:00
• ca2b26130f sqlite-utils dump command, closes #274 Simon Willison 2021-06-16 16:51:48 -07:00
• 192dc2c5b7 Improved arrangement of CLI query documentation Simon Willison 2021-06-16 11:18:08 -07:00
• 4aada0a3d2 Documented --attach option for memory command, refs #272 Simon Willison 2021-06-16 11:17:46 -07:00
• fe1562e8a6
  Structure of most_common and least_common columns Simon Willison 2021-06-16 09:36:32 -07:00
• 2271dae96a Replaced one last :memory: example Simon Willison 2021-06-16 08:17:25 -07:00
• 435096c563 Docs for --save and --dump plus made SQL optional for those, refs #273 Simon Willison 2021-06-16 08:15:44 -07:00
• 88b46288b3 Re-organized CLI query docs, refs #272 Simon Willison 2021-06-16 08:06:26 -07:00
• 1e6ab6fa1a Re-arranged CLI query documentation, refs #272 Simon Willison 2021-06-16 07:55:53 -07:00
• 988d363657 Implement --save plus tests for --save and --dump, refs #272 Simon Willison 2021-06-16 07:43:55 -07:00
• c7234cae83 Initial CSV-only prototype of sqlite-utils memory, refs #272 Simon Willison 2021-06-15 22:02:18 -07:00
• 287cdcae89 Turn SQL errors into click errors Simon Willison 2021-06-15 21:40:28 -07:00
• 78aebb6479
  Link to --load-extension docs Simon Willison 2021-06-15 19:36:16 -07:00
• a54b6788b0
  Sub-headings for .transform() Simon Willison 2021-06-15 15:34:29 -07:00
• a81c05d235
  Clarify types that can be passed to .transform() Simon Willison 2021-06-14 20:47:34 -07:00
• 10f4913c14 Release 3.9.1 3.9.1 Simon Willison 2021-06-12 19:59:08 -07:00
• b9629099ab Fix bug with upsert_all() and single column tables, closes #271 Simon Willison 2021-06-12 19:57:21 -07:00
• b0f9d1e494 Fixed typo in 3.8 release notes 3.9 Simon Willison 2021-06-11 19:07:18 -07:00
• baafcec4a5 Release 3.9 Simon Willison 2021-06-11 19:05:12 -07:00
• 0d2e4f49f3 db.schema and 'sqlite-utils schema' command, closes #268 Simon Willison 2021-06-11 13:51:49 -07:00
• 9696abfabf
  Rearranged "Inserting JSON data" section Simon Willison 2021-06-08 13:03:12 -07:00
• 9dff7a3883
  Fixed markup Simon Willison 2021-06-06 23:02:18 -07:00
• d1a372b300 Release 3.8 3.8 Simon Willison 2021-06-02 22:16:33 -07:00
• 28dc5aac34 sqlite-utils indexes command, refs #263 Simon Willison 2021-06-02 21:26:46 -07:00
• 9c67cb9252 table.xindexes property plus improved introspection documentation, closes #261 Simon Willison 2021-06-02 20:51:27 -07:00
• 2dad4f583c Improved .rows_where() documentation, added test for :named parameters Simon Willison 2021-06-02 11:57:05 -07:00
• 670f92285f
  Fixed RST Simon Willison 2021-05-28 23:31:04 -07:00
• 8c542d20ca Release 3.7 3.7 Simon Willison 2021-05-28 22:47:59 -07:00
• 8de5595c21 Handle BOM in CSV files, closes #250 Simon Willison 2021-05-28 22:34:17 -07:00
• 668e8c9fd1 Better help for sqlite-utils create-table Simon Willison 2021-05-28 22:00:11 -07:00
• 51d01da30d
  Ability to add descending order indexes (#262) Simon Willison 2021-05-28 22:01:38 -07:00
• 50a4fb722d Revert "Better help for sqlite-utils create-table" Simon Willison 2021-05-28 22:00:45 -07:00
• b3d11f5225 Better help for sqlite-utils create-table Simon Willison 2021-05-28 22:00:11 -07:00
• 9a8c6fa020 Ability to add desc indexes using CLI, closes #260 Simon Willison 2021-05-28 21:50:24 -07:00
• c374d7ef04 DescIndex(column) for descending index columns, refs #260 Simon Willison 2021-05-28 21:32:03 -07:00
• b2302875c9 Document --type option better, closes #255 Simon Willison 2021-05-28 20:55:46 -07:00
• 2f3371ecb1 Suggest --alter if column is missing, closes #259, refs #256 Simon Willison 2021-05-18 20:26:13 -07:00
• 328211eaca
  Typo in upsert example (#244) Juan E. D 2021-05-18 23:58:21 -03:00
• 3e62ab62a8
  Correct some typos (#245) Damien Ready 2021-05-18 21:58:04 -05:00
• e7b2626291
  Fix incorrect create-table cli description (#254) Rob Wells 2021-05-19 03:57:26 +01:00
• a95954c481 Tests for unicode characters in nested JSON, refs #257 Simon Willison 2021-05-18 19:56:53 -07:00
• 6f4f9a3eff
  Fixing insert from JSON containing strings with non-ascii characters are escaped aps unicode for lists, tuples, dicts (#258) Dylan Wu 2021-05-18 21:47:44 -05:00
• 27e7c1ae19 Fixing insert from JSON containing strings with non-ascii characters are escaped aps unicode for lists, tuples, dicts Dylan-Wu 2021-04-26 15:48:56 -05:00
• cdeb7d7da7
  Fix incorrect create-table cli description Rob Wells 2021-04-13 21:01:52 +01:00
• 2d2376ffd8 add escape functionality from datsette Mark Neumann 2021-03-16 11:15:08 +00:00
• eb5aa71bce failing test for fts Mark Neumann 2021-03-16 10:39:53 +00:00
• 79de6b639f Correct some typos Damien Ready 2021-03-12 22:20:50 -06:00