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

• d379f430f8 rows_from_file(... ignore_extras: bool, restkey: str), refs #440 Simon Willison 2022-06-14 08:14:02 -07:00
• 7ddf530088
  A less potentially confusing parameter name Simon Willison 2022-06-13 08:22:59 -07:00
• 9fedfc69d7
  docs to dogs (#437) Yuri 2022-05-30 17:32:41 -04:00
• 9e54041782
  docs to dogs Yuri 2022-05-22 11:50:19 -04:00
• 59be60c471 Update copyright dates on docs Simon Willison 2022-05-20 14:57:49 -07:00
• 2238e9baf9 sphinx-copybutton extension, closes #436 Simon Willison 2022-05-20 14:57:26 -07:00
• 397183debd Switch docs theme to Furo, refs #435 Simon Willison 2022-05-20 14:51:30 -07:00
• 841ad44bac
  Fixed typo 3.26.1 Simon Willison 2022-05-02 11:17:19 -07:00
• 56571775a1 Release 3.26.1 Simon Willison 2022-05-02 11:14:29 -07:00
• edeec2e804 Release 3.26.1 click-default-group-wheel Simon Willison 2022-05-02 11:14:29 -07:00
• ed6fd51608
  Depend on click-default-group-wheel (#429) Simon Willison 2022-05-02 11:05:00 -07:00
• 4a02dcf265
  Depend on click-default-group-wheel Simon Willison 2022-05-02 10:58:16 -07:00
• e3a14c33a0
  Run tests against pull requests Simon Willison 2022-04-19 17:21:04 -07:00
• 6915fbcce2 Release 3.26 3.26 Simon Willison 2022-04-13 15:51:48 -07:00
• cbaad1f153 Removed unused sys import, refs #425 Simon Willison 2022-04-13 15:40:57 -07:00
• 0e60f3c80c Better error message if table has no columns, closes #424 Simon Willison 2022-04-13 15:39:48 -07:00
• 4433eafff7 Fix for register() on Python 3.7, refs #425 Simon Willison 2022-04-13 15:35:57 -07:00
• 6f3ae864f1 Better support check for deterministic=True, closes #425 Simon Willison 2022-04-13 15:31:37 -07:00
• 95522ad919 Clarified support for newline-delimited JSON, closes #417 Simon Willison 2022-03-25 14:17:10 -07:00
• 0b7b80bd40 Document the convert() with initialization pattern, closes #420 Simon Willison 2022-03-25 13:07:29 -07:00
• 396f80fcc6
  Ignore common generated files (#419) Chris Amico 2022-03-24 17:01:43 -04:00
• 228f73615c Ignore common generated files Chris Amico 2022-03-23 14:04:50 -04:00
• 93fa79d30b Ignore flake8 lambda errors, refs #415 Simon Willison 2022-03-20 21:22:09 -07:00
• 751ab205ac Fix for --multi combined with --dry-run, closes #415 Simon Willison 2022-03-20 21:18:18 -07:00
• 878d5f5cea errors=r.SET_NULL/r.IGNORE options for parsedate/parsedatetime, closes #416 Simon Willison 2022-03-20 21:01:35 -07:00
• 433813612f Move sqls=[] closer to where it is populated Simon Willison 2022-03-11 13:44:07 -08:00
• 9388edf57a Changelog item for 3.25.1 3.25.1 Simon Willison 2022-03-11 10:34:37 -08:00
• 40b76f6f56
  Release 3.25.1 Simon Willison 2022-03-11 10:08:20 -08:00
• 6fd7c138e2 Fixed .transform() method which I broke in #413 Simon Willison 2022-03-11 09:54:17 -08:00
• 26e6d2622c Use :param x: for docstring comments, refs #413 Simon Willison 2022-03-11 09:38:34 -08:00
• 7f56f90d30
  Fixed rST mistake Simon Willison 2022-03-01 23:01:07 -08:00
• b2b04aec01 Release 3.25 3.25 Simon Willison 2022-03-01 22:34:34 -08:00
• d25cdd37a3 db.sqlite_version property and fix for deterministic=True on SQLite 3.8.3 Simon Willison 2022-03-01 16:24:27 -08:00
• 521921b849 Fixed mypy error, refs #343 Simon Willison 2022-03-01 16:05:11 -08:00
• 931b1e1513 .insert(hash_id_columns=) parameter, closes #343 Simon Willison 2022-03-01 16:00:51 -08:00
• b6c9dfce0b
  Correct spelling mistakes (found with codespell) (#410) Edward Betts 2022-03-01 21:05:29 +00:00
• a174069da6 Correct spelling mistakes (found with codespell) Edward Betts 2022-02-24 20:43:39 +00:00
• 7a098aa0c5
  Link to my blog series Simon Willison 2022-02-17 07:39:54 -08:00
• 757f103ae2 Release 3.24 3.24 Simon Willison 2022-02-15 17:39:13 -08:00
• 4bc06a2437 memory_name= feature, closes #405 Simon Willison 2022-02-15 17:21:25 -08:00
• 8f528ed2b1 Fix ReST warning Simon Willison 2022-02-15 17:21:07 -08:00
• 3e5a4f60cc Tweaked SpatiaLite CLI docs, refs #398 Simon Willison 2022-02-15 17:06:49 -08:00
• a692c56659
  Add SpatiaLite helpers to CLI (#407) Chris Amico 2022-02-15 19:58:07 -05:00
• a974da5919 load extensions first, then init spatialite Chris Amico 2022-02-15 13:09:31 -05:00
• 00b650c684 Use docstring instead of help arg Chris Amico 2022-02-15 13:06:49 -05:00
• d770f8426b
  Use SpatiaLite when calculating coverage, refs #407 Simon Willison 2022-02-15 09:57:29 -08:00
• 6aab06e6ec Run cog and add some help text. Chris Amico 2022-02-15 12:24:18 -05:00
• 36518cbfcd Fix flake8 issues and add more detail on spatial types Chris Amico 2022-02-15 12:08:29 -05:00
• 7f4bb91c74 Add docs for spaitalite helpers Chris Amico 2022-02-15 11:19:34 -05:00
• 414d0cf732 Add SpatiaLite CLI helpers Chris Amico 2022-02-13 19:36:52 -05:00
• e7f040106b Add an example of --text too, refs #404 Simon Willison 2022-02-08 23:03:04 -08:00
• 7142dbd58d Fixed typo in --help Simon Willison 2022-02-08 22:57:21 -08:00
• 79a5ece62e Add --convert example to sqlite-utils insert --help, closes #404 Simon Willison 2022-02-08 22:54:40 -08:00
• 3acc2f1772 Adding a primary key to a rowid table, closes #403 Simon Willison 2022-02-08 11:33:41 -08:00
• fea8c9bcc5 Improved SpatiaLite example, closes #401 Simon Willison 2022-02-05 18:03:21 -08:00
• aa24903113 Create table if_not_exists=True argument, closes #397 Simon Willison 2022-02-05 17:28:53 -08:00
• 79b5b58354 Basic test for db[t].create(...), refs #397 Simon Willison 2022-02-05 17:19:39 -08:00
• 088d899822 Release 3.23 3.23 Simon Willison 2022-02-03 22:41:46 -08:00
• 20fe3b8abf Fixed RST warning about empty line Simon Willison 2022-02-03 22:32:57 -08:00
• 44894c6f6c Fix warning about duplicate object description Simon Willison 2022-02-03 22:31:13 -08:00
• 482fcc0da7 Fix for flake8, refs #79 Simon Willison 2022-02-03 22:13:17 -08:00
• 0fe0f476a7 Fix for mypy error, closes #396 Simon Willison 2022-02-03 22:10:09 -08:00
• e46798959e
  Looks like Actions if: clauses prefer single quotes Simon Willison 2022-02-03 22:06:23 -08:00
• 7494187284
  Only install SpatiaLite on Ubuntu, refs #395 Simon Willison 2022-02-03 22:05:12 -08:00
• cea25c28ba Capitalization of SpatiaLite Simon Willison 2022-02-03 21:59:59 -08:00
• 4a2a3e2fd0
  Install SpatiaLite in tests Simon Willison 2022-02-03 21:56:34 -08:00
• ee11274fcb
  New spatialite helper methods, closes #79 Chris Amico 2022-02-04 00:55:09 -05:00
• af86b17acf Consolidate pytest marks. Copy edit docs. Chris Amico 2022-02-03 21:25:06 -05:00
• 9dcb099905 Better error messages for --convert, closes #363 Simon Willison 2022-02-03 14:51:25 -08:00
• 092f17fdc6
  Removed two rogue spaces that snuck in Simon Willison 2022-02-03 14:26:39 -08:00
• 7d928f8308 Better insert-replace CLI documentation, refs #393 Simon Willison 2022-02-03 14:11:25 -08:00
• 813b6d07ab Much improved insert-replace documentation, refs #393 Simon Willison 2022-02-03 14:07:32 -08:00
• b2ab08e048
  Don't test main against 3.11-dev yet Simon Willison 2022-02-03 13:07:00 -08:00
• 481eb60a1b Make GIS helpers into methods on Database and Table. Remove gis.py. Chris Amico 2022-02-03 15:23:21 -05:00
• a3639f39d9 Import find_spatialite into utils for backwards compat Chris Amico 2022-02-03 14:27:21 -05:00
• 06f1270edd
  Fixed duplicate code-block declaration Simon Willison 2022-02-03 11:03:51 -08:00
• b58c9c7e88
  Added references to headers Simon Willison 2022-02-03 10:36:12 -08:00
• dc8f3c7cde Fix my spelling Chris Amico 2022-02-03 11:41:36 -05:00
• 44cbddff8a
  Run tests against Python 3.11-dev Simon Willison 2022-02-02 14:21:38 -08:00
• a6da26a856
  Simplified example Simon Willison 2022-01-30 07:24:13 -08:00
• feb01c1ddd
  Fixed duplicated example Simon Willison 2022-01-30 07:22:39 -08:00
• 6663d28952
  SQL injection, not XSS Simon Willison 2022-01-30 07:17:20 -08:00
• d1e9f09c06 Removed unneccessary import, refs #392 Simon Willison 2022-01-26 10:23:48 -08:00
• d1d2a8e6fa sqlite-utils bulk --batch-size option, closes #392 Simon Willison 2022-01-26 10:15:23 -08:00
• a9fca7efa4 Release 3.22.1 3.22.1 Simon Willison 2022-01-25 19:28:30 -08:00
• be1e89da5f Fixed flake8 errors Simon Willison 2022-01-25 19:22:06 -08:00
• 2b20957b18 Better validation for upsert --pk, closes #390 Simon Willison 2022-01-25 19:19:39 -08:00
• 4c6023452c Examples in --help for remaining commands, closes #384 Simon Willison 2022-01-25 19:14:59 -08:00
• 6e85a4bbbe Added examples to more --help output, refs #384 Simon Willison 2022-01-25 18:56:44 -08:00
• 25d8c820de Correct domain for Plausible, refs #389 Simon Willison 2022-01-25 18:06:02 -08:00
• 89c01103ec Custom layout template for docs Simon Willison 2022-01-25 18:00:16 -08:00
• b3efb29212 SQLite can drop columns now Simon Willison 2022-01-25 17:48:57 -08:00
• 8d51ae48ab Getting started section for Python library, closes #387 Simon Willison 2022-01-25 17:35:26 -08:00
• 82ea42ffee Added missing docstring for db.supports_strict Simon Willison 2022-01-24 20:12:32 -08:00
• 3091e6b6e9 Clearer help for --drop-foreign-key Simon Willison 2022-01-24 20:06:40 -08:00
• 7fdff5019d
  Link to article from contributing, closes #386 Simon Willison 2022-01-18 18:15:21 -08:00
• 0df57367e9 Return status. Handle double calls. Chris Amico 2022-01-18 09:59:03 -05:00
• 5581756831 Add documentation for gis functions Chris Amico 2022-01-15 10:13:23 -05:00
• 653350a551 Use db.execute instead of db.conn.execute Chris Amico 2022-01-14 21:10:48 -05:00
• 7d9473809f remove unused geojson fixture Chris Amico 2022-01-13 22:57:07 -05:00