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

• 22f1d9e199 Expand FTS acronym in --help output Simon Willison 2021-03-07 08:41:49 -08:00
• 1899200fa5
  Typo in upsert example Juan E. D 2021-03-02 20:13:32 -03:00
• 09c3386f55 Applied Black, refs #237 Simon Willison 2021-02-25 09:13:00 -08:00
• bba6e241be --ignore for sqlite-utils drop-table and drop-view, closes #237 Simon Willison 2021-02-25 09:11:37 -08:00
• c236894caa table.drop(ignore=True) option, refs #237 Simon Willison 2021-02-25 09:05:08 -08:00
• a76e3b33ac Fixed bug with add_foreign_key against columns with spaces, closes #238 Simon Willison 2021-02-25 08:53:53 -08:00
• 8d641ab08a First attempt at .extract_expand() method, refs #239 extract-expand Simon Willison 2021-02-25 08:36:03 -08:00
• 16987bd56e Removed rogue assert False, refs #240 Simon Willison 2021-02-25 08:35:24 -08:00
• 38e688fb8b table.pks_and_rows_where() method, closes #240 Simon Willison 2021-02-25 08:28:17 -08:00
• 806c21044a Release 3.6 3.6 Simon Willison 2021-02-18 21:18:02 -08:00
• 2ba5588881 sqlite-utils --attach option, closes #236 Simon Willison 2021-02-18 21:08:39 -08:00
• 999f099cbe db.attach(alias, filepath) method, closes #113 Simon Willison 2021-02-18 20:56:32 -08:00
• 2c1b9f2445
  Create FUNDING.yml Simon Willison 2021-02-18 10:22:43 -08:00
• 1f49f32814 Don't need line_buffering=True here, refs #230 Simon Willison 2021-02-15 11:18:28 -08:00
• 8fcaee03b7 Release 3.5 3.5 Simon Willison 2021-02-14 14:43:06 -08:00
• ef13bb046f Useful error message for enable_fts() on views, closes #220 Simon Willison 2021-02-14 14:34:22 -08:00
• 50d2096f5e --no-headers option for sqlite-utils insert --csv, closes #228 Simon Willison 2021-02-14 14:25:03 -08:00
• 427dace184 Added --csv example to README Simon Willison 2021-02-14 13:36:43 -08:00
• 67cce7c861 Run publish tests on macOS and Windows too, refs #232 Simon Willison 2021-02-14 13:35:12 -08:00
• 1a93b72ba7 Increase csv field_size_limit to maximum, closes #229 Simon Willison 2021-02-14 13:33:21 -08:00
• 8f042ae1fd Fix for bug with extra columns in later chunks, closes #234 Simon Willison 2021-02-14 13:03:17 -08:00
• f51a1f6c3c
  Run tests against Ubuntu, macOS and Windows Simon Willison 2021-02-14 12:39:54 -08:00
• deb01a8913
  Fixes for tests on Windows windows-ci Simon Willison 2021-02-14 12:34:02 -08:00
• 44d3c8befc
  Missing import Simon Willison 2021-02-14 12:27:00 -08:00
• 7ac1774974
  Fix for Windows, thanks to @nieuwenhoven in #225 Simon Willison 2021-02-14 12:23:15 -08:00
• f748f103fe
  Run tests against Ubunt, macOS and Windows Simon Willison 2021-02-14 12:10:56 -08:00
• 320f3ac33a offset= and limit= parameters, closes #231 Simon Willison 2021-02-14 12:02:41 -08:00
• cf811e35e1 Formatting fix Simon Willison 2021-02-14 11:25:58 -08:00
• 99ff0a288c sqlite-utils insert --sniff option, closes #230 Simon Willison 2021-02-14 11:23:12 -08:00
• 1e9eb875a6 Switch from codecs.getreader to io.TextIOWrapper, refs #230 Simon Willison 2021-02-14 10:33:26 -08:00
• 726219c350 Release 3.4.1 3.4.1 Simon Willison 2021-02-05 18:10:04 -08:00
• 7d04565010 Remove rogue import, refs #226 Simon Willison 2021-02-05 18:09:48 -08:00
• f8010ca78f Release 3.4 3.4 Simon Willison 2021-02-05 17:37:27 -08:00
• 1b666f9315 --delimiter and --quotechar, closes #223 Simon Willison 2021-02-05 17:34:47 -08:00
• 929ea75511 fix for problem in Table.insert_all on search for columns per chunk of rows Frans 2021-01-29 20:58:37 +01:00
• 341f50d2d9
  Add fts offset docs. Ricardo Ander-Egg 2021-01-22 21:50:46 +01:00
• 36dc7e3909 Release 3.3 3.3 Simon Willison 2021-01-17 20:28:24 -08:00
• d4e00f8d01 table.m2m(..., alter=True) option, closes #222 Simon Willison 2021-01-17 20:26:02 -08:00
• 0b244d207a Release 3.2.1 3.2.1 Simon Willison 2021-01-12 15:22:53 -08:00
• b6840646ba .add_missing_columns() is now case insensitive, closes #221 Simon Willison 2021-01-12 15:17:27 -08:00
• 4cc82fd0bc Release 3.2 3.2 Simon Willison 2021-01-03 13:15:26 -08:00
• 0d2a47eab9 .reset_counts() method and reset-counts command, closes #219 Simon Willison 2021-01-03 12:59:31 -08:00
• b4f09146d3 table.has_counts_triggers property, refs #219 Simon Willison 2021-01-03 12:41:24 -08:00
• c265541384 Shorter help summary for rebuild_fts Simon Willison 2021-01-03 12:22:07 -08:00
• 94b5023066 table.count now uses cached counts if db.use_counts_table Simon Willison 2021-01-03 12:19:34 -08:00
• 036ec6d323 Ignore test .db files Simon Willison 2021-01-03 10:43:21 -08:00
• 1e38a16ea8 Nicer error message for invalid JSON insert, closes #206 Simon Willison 2021-01-03 10:42:17 -08:00
• 6d1828e40b
  Don't run CodeQL against pull requests Simon Willison 2021-01-02 20:30:10 -08:00
• ce042ff1f0 'sqlite-utils enable-counts' command, closes #214 Simon Willison 2021-01-02 20:26:39 -08:00
• de08096989 database.triggers_dict, closes #216 Simon Willison 2021-01-02 20:19:55 -08:00
• 3d041d34d5 Renamed db.escape() to db.quote() and documented it Simon Willison 2021-01-02 20:15:04 -08:00
• ce918195a4 Use $ instead of % in CLI documentation Simon Willison 2021-01-02 19:52:15 -08:00
• 5b246d17a0 'sqlite-utils triggers' command, closes #218 Simon Willison 2021-01-02 19:03:15 -08:00
• 9a5c92b63e db.enable_counts() method, closes #213 Simon Willison 2021-01-02 14:03:52 -08:00
• 1cad7fad3e table.enable_counts() method, closes #212 Simon Willison 2021-01-02 13:40:10 -08:00
• b067f1ff57 table.triggers_dict property, closes #211 Simon Willison 2021-01-01 18:10:04 -08:00
• 0dca784dbe Release 3.1.1 3.1.1 Simon Willison 2021-01-01 15:56:20 -08:00
• 33c759a74c Test now tolerates optimize producing larger DB, closes #209 Simon Willison 2021-01-01 15:52:36 -08:00
• 6a34426b12 Docs now live at sqlite-utils.datasette.io Simon Willison 2020-12-29 13:34:55 -08:00
• 8ca35dfb64 Link to new datasette.io website Simon Willison 2020-12-29 13:33:25 -08:00
• 5e43e31c2b
  Merge branch 'main' into issue-117-compound-foreign-keys David Kane 2020-12-14 09:39:58 +00:00
• f1277f638f
  Added Homebrew installation instructions Simon Willison 2020-12-13 20:52:24 -08:00
• 5e06026e76
  Typo fix Simon Willison 2020-12-13 16:19:51 -08:00
• 1ce96d8c08 Release 3.1 3.1 Simon Willison 2020-12-12 23:28:20 -08:00
• cede53a37d Fixed typo in release notes analyze-table Simon Willison 2020-12-12 23:29:45 -08:00
• 6eea94a49d Release 3.1 Simon Willison 2020-12-12 23:28:20 -08:00
• 69a121e088
  sqlite-utils analyze-tables command and table.analyze_column() method Simon Willison 2020-12-12 23:20:11 -08:00
• 95a966bb62 Make least_common/most_common order dependable for tests Simon Willison 2020-12-12 23:18:49 -08:00
• 5a813bae6d Ensure reliable sort order for tests Simon Willison 2020-12-12 21:43:52 -08:00
• faedf951e4 table.analyze_column() documentation Simon Willison 2020-12-12 21:40:18 -08:00
• 1491467444 Swap count and value in analyze output Simon Willison 2020-12-12 21:39:53 -08:00
• f65fe8ad5c Documentation for analyze-tables Simon Willison 2020-12-12 21:29:20 -08:00
• 736dca6289 Much improved design for CLI output of analyze-tables Simon Willison 2020-12-12 21:28:43 -08:00
• 955daaaf05 Truncate values longer than 100 characters Simon Willison 2020-12-12 20:58:05 -08:00
• c0d21956bc Test for analyze-tables --save Simon Willison 2020-12-12 20:51:40 -08:00
• f7efe77ccb Tests for analyze tables Simon Willison 2020-12-12 20:46:13 -08:00
• ef219d6b4d -c / --column option Simon Willison 2020-12-11 21:48:13 -08:00
• 61461b9881 Don't bother with least_common if less than 10 values Simon Willison 2020-12-11 21:45:37 -08:00
• d4b8d9e7a5 Improvements to most/least common values Simon Willison 2020-12-11 21:41:07 -08:00
• 5c176ccbe0 If only one distinct value, record that in most_commond and leave least_common as null Simon Willison 2020-12-11 21:30:44 -08:00
• ca2ccccac2 Initial prototype of sqlite-utils analyze-tables, refs #207 Simon Willison 2020-12-11 21:27:00 -08:00
• c5f4f0f70c
  Use jsonify_if_need for sql updates (#204) Andreas Madsack 2020-12-08 18:49:42 +01:00
• 8ea9ad1913
  use jsonify_if_needed in for sql updates Andreas Madsack 2020-11-29 11:47:14 +01:00
• 0f5d8c0ebb
  add failing tests for update with json values Andreas Madsack 2020-11-29 11:47:03 +01:00
• b33c45f073 run formatting David Kane 2020-11-16 10:55:30 +00:00
• 99992deb31 subclass namedtuple for foreign key David Kane 2020-11-16 10:50:09 +00:00
• 597965a5a9 revert change to foreign key definition in test David Kane 2020-11-16 00:55:49 +00:00
• 2f9889d795 remove print statement David Kane 2020-11-16 00:52:40 +00:00
• 8576ca873d add possibility of compound foreign keys to docs David Kane 2020-11-16 00:40:04 +00:00
• 3dba2029b5 black formatting David Kane 2020-11-16 00:32:27 +00:00
• 1c9e21f9a2 changes to allow for compound foreign keys David Kane 2020-11-16 00:18:11 +00:00
• 60d3c4821b Changes since the 3.0a0 alpha release 3.0 Simon Willison 2020-11-08 09:23:38 -08:00
• 68637732e0 Release 3.0 Simon Willison 2020-11-08 09:19:20 -08:00
• 47abca0764 Update README for 3.0 release, refs #194 Simon Willison 2020-11-08 09:16:25 -08:00
• ce2b07c358 Updated docs for .search_sql() method Simon Willison 2020-11-08 09:04:33 -08:00
• 79109939c3 search --limit now defaults to everything, refs #192 Simon Willison 2020-11-08 09:00:43 -08:00
• c5a798c15f .search_sql() fully respects columns=, closes #201 Simon Willison 2020-11-08 08:53:53 -08:00
• a8acafbfe0 Fixed RST typo Simon Willison 2020-11-06 18:49:24 -08:00
• 60f4aff9b0
  Link changelog badge to /en/latest/changelog.html Simon Willison 2020-11-06 18:23:56 -08:00
• 6785e89cc0 Release 3.0a0 3.0a0 Simon Willison 2020-11-06 17:22:24 -08:00