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

• 50ec2e49de Add implementation to read --parquet files. Florents Tselai 2021-10-29 02:34:37 +03:00
• fda4dad23a
  Test against Python 3.10 (#330) Simon Willison 2021-10-13 15:25:05 -07:00
• fc3de90963
  Test on Python 3.10 before publish Simon Willison 2021-10-13 14:55:46 -07:00
• bd61ca343a
  Added 3.10 to classifiers Simon Willison 2021-10-13 14:54:43 -07:00
• 52b7220ae1
  Test against Python 3.10 Simon Willison 2021-10-13 14:50:19 -07:00
• 2840c697aa
  WIP: set m21 true for empty lists... Paul Haerle 2021-10-11 17:31:41 +02:00
• 718a8f61bc
  Clarified description of --quote Simon Willison 2021-10-02 09:54:39 -07:00
• 54191d4dc1 Release 3.17.1 3.17.1 Simon Willison 2021-09-22 13:49:36 -07:00
• c1b26eed03 sqlite-utils memory handles files with same filename, closes #325 Simon Willison 2021-09-22 13:45:37 -07:00
• 7427a9137f Output [] in JSON mode if no rows, closes #328 Simon Willison 2021-09-22 13:20:04 -07:00
• 17da3bf343 Handle m2m and m21 in extract_expand() phaer 2021-09-19 12:22:18 +02:00
• 70423bb37f Allow specifying our_id in Table.m2m() phaer 2021-09-19 12:16:15 +02:00
• d39ac10c03 Throw ExpandError for unknown in .extract_expand() phaer 2021-09-19 09:47:16 +02:00
• d1d780379c Support lists in .extract_expand() phaer 2021-09-19 09:46:56 +02:00
• 078a08765d
  Test against 3.10-dev test-3.10-dev Simon Willison 2021-09-08 08:01:09 -07:00
• 275ac3b282 Use python-dateutil package instead of dateutils Denys Pavlov 2021-09-03 14:13:45 -04:00
• 69619f68c2
  Add dict type to be mapped as TEXT in sqllite Mina Rizk 2021-08-25 22:52:33 +02:00
• 77c240df56 Release 3.17 3.17 Simon Willison 2021-08-24 16:39:49 -07:00
• c18ae2faca Release 3.17 insert-files-text Simon Willison 2021-08-24 16:39:49 -07:00
• 49a010c93d
  Ability to insert file contents as text, in addition to blob (#321) Simon Willison 2021-08-24 16:31:13 -07:00
• db2dd6d9f3 Skip this test on Windows Simon Willison 2021-08-24 16:24:55 -07:00
• 96bc06db03 Show output on error Simon Willison 2021-08-24 16:16:32 -07:00
• d5dab71d24 Fix for flake8 Simon Willison 2021-08-24 15:40:16 -07:00
• 873877111c Fixed spelling Simon Willison 2021-08-24 15:36:39 -07:00
• 0c796cd945 WIP insert-files --text option, refs #319 Simon Willison 2021-08-24 15:30:16 -07:00
• 9258f4bd84 sqlite-utils memory --analyze, closes #320 Simon Willison 2021-08-22 08:44:25 -07:00
• d7b1024d3a
  Corrected stdin example Simon Willison 2021-08-18 16:02:55 -07:00
• b30f725d98
  Small improvement to example Simon Willison 2021-08-18 16:02:07 -07:00
• ddfdff657f
  Fixed incorrecte output example Simon Willison 2021-08-18 16:01:00 -07:00
• 5912878d62 Release 3.16 3.16 Simon Willison 2021-08-18 15:36:32 -07:00
• c79737bb4f Type signatures for .create_table() and .create_table_sql() and .create() and Table.__init__ Simon Willison 2021-08-18 15:25:18 -07:00
• 282e81362a Applied Black plus some extra type hints Simon Willison 2021-08-18 14:55:37 -07:00
• c62363ebdc Run mypy against tests/ too, refs #37 Simon Willison 2021-08-18 14:48:05 -07:00
• 7479933bc4
  More sqlite-utils memory examples in README closes #294 Simon Willison 2021-08-18 14:40:02 -07:00
• 7e2dcbbbea Fixed bug with --no-headers --tsv, closes #295 Simon Willison 2021-08-18 13:18:54 -07:00
• 61b60f58ce Nice capitalization of API reference Simon Willison 2021-08-18 13:13:52 -07:00
• ccf128cd6d sqlite-utils search --quote option, closes #296 Simon Willison 2021-08-18 13:10:44 -07:00
• 8ae77a6961 table.search(quote=True) parameter, refs #296 Simon Willison 2021-08-18 12:55:53 -07:00
• f0fd19267f Black/flake8, refs #246 Simon Willison 2021-08-18 11:56:36 -07:00
• 1fa5a12a49 Documentation for db.quote_fts(), refs #246 Simon Willison 2021-08-18 11:55:50 -07:00
• e6b1022791 Fix markup warning in docstring Simon Willison 2021-08-18 11:55:19 -07:00
• 53fec0d863
  db.quote_fts() method, thanks Mark Neumann Mark Neumann 2021-08-18 19:43:11 +01:00
• af989af658
  Merge branch 'main' into fts-quote Simon Willison 2021-08-18 11:40:46 -07:00
• 1fe73c898b
  Remove link to older code example Simon Willison 2021-08-18 11:31:20 -07:00
• 7a19822ac9
  Updated tagline Simon Willison 2021-08-17 08:42:02 -07:00
• 7ee7b628e1
  Fixed some rogue backticks, closes #316 Simon Willison 2021-08-13 22:10:47 -07:00
• b966c44ef8
  Minor markup fix Simon Willison 2021-08-13 04:32:40 -07:00
• 6de0a5d46a
  Typo fix Simon Willison 2021-08-11 05:03:07 -07:00
• af89c5f851
  How to create a Database instance Simon Willison 2021-08-11 04:56:54 -07:00
• 3091bec4f7
  Don't show inheritance for Database class Simon Willison 2021-08-11 04:54:00 -07:00
• bde3725257 Fixed spelling existent 3.15.1 Simon Willison 2021-08-10 16:55:12 -07:00
• 86fc9fb5c8 Release 3.15.1 Simon Willison 2021-08-10 16:51:59 -07:00
• 8fa2df978b Release 3.15.1 autodoc Simon Willison 2021-08-10 16:51:59 -07:00
• 6155da72c8
  Add reference page to documentation using Sphinx autodoc (#312) Simon Willison 2021-08-10 16:09:28 -07:00
• 43bc064817 Finished adding docstrings and type hints to db Simon Willison 2021-08-10 16:05:35 -07:00
• f51b712479 Fixed rogue backtick, renamed to API Reference Simon Willison 2021-08-10 14:52:40 -07:00
• 5d758a2761 docstrings for most of the Table class Simon Willison 2021-08-10 12:41:41 -07:00
• b39131f375 Completed docstrings for Database and Queryable Simon Willison 2021-08-10 11:35:21 -07:00
• 99cf7c1c53 Finished adding docstrings to everything in Database Simon Willison 2021-08-10 11:14:32 -07:00
• 6ad3ce414c Leave this as it was Simon Willison 2021-08-10 10:43:32 -07:00
• eeb5550ed7 RTD doesnt have 3.9 yet Simon Willison 2021-08-10 10:41:09 -07:00
• 50dcfc01dc Custom Read The Docs config, to get autodoc working Simon Willison 2021-08-10 10:39:51 -07:00
• b58352f730 Try ../../ Simon Willison 2021-08-10 10:34:26 -07:00
• e20f62613a Help Read The Docs find modules to autodoc Simon Willison 2021-08-10 10:29:55 -07:00
• be6dd5bda8 More annotations plus a fix for #313 Simon Willison 2021-08-10 10:25:23 -07:00
• c11ff89894 flake8/black fix Simon Willison 2021-08-10 10:12:30 -07:00
• cf92a29c2e Fixed bug I introduced with register_function() Simon Willison 2021-08-10 10:08:23 -07:00
• 2da7af10a4 Fix for Python 3.6 Simon Willison 2021-08-10 10:01:38 -07:00
• b95b6b63f6 More docstrings plus configured autodoc, refs #311 Simon Willison 2021-08-10 09:57:59 -07:00
• ee469e3122 Corrected tiny mistake in --flatten examples Simon Willison 2021-08-09 15:50:53 -07:00
• 8757de84b2
  Link to stable docs, not latest Simon Willison 2021-08-09 15:44:26 -07:00
• d5ef912120 Release 3.15 3.15 Simon Willison 2021-08-09 15:42:06 -07:00
• a6567ec507 Capture parameters= not params=, refs #309 Simon Willison 2021-08-09 15:33:33 -07:00
• 14f643d9e9 Better error messages in CLI, closes #309 Simon Willison 2021-08-09 15:25:52 -07:00
• 3fb1034e86 option, not object, refs #310 Simon Willison 2021-08-09 14:46:47 -07:00
• 15758d02fd Fixed spelling of objects, refs #310 Simon Willison 2021-08-09 14:45:39 -07:00
• f67327abf0 sqlite-utils insert --flatten option, closes #310 Simon Willison 2021-08-09 14:44:03 -07:00
• cc90745f4e Started a Jupyter notebook tutorial, refs #308 Simon Willison 2021-08-04 13:34:30 -07:00
• cff6afcc43 Run codespell against source code too, refs #307 Simon Willison 2021-08-03 10:06:08 -07:00
• 991cf56ae2 Check spelling with codespell, closes #307 Simon Willison 2021-08-03 09:48:37 -07:00
• f7c8c78cd0
  Fixed typo: commad Simon Willison 2021-08-02 23:05:45 -07:00
• d83f624a31 Clarified documentation for convert recipes, refs #251 Simon Willison 2021-08-02 15:39:16 -07:00
• ec50e5eebc sqlite3.enable_callback_tracebacks(True) in docs, closes #300 Simon Willison 2021-08-02 14:53:44 -07:00
• e83aef951b New :issue: macro, closes #306 3.14 Simon Willison 2021-08-02 14:29:00 -07:00
• 723ee35344 Release 3.14 Simon Willison 2021-08-02 14:18:01 -07:00
• 59032b00bb
  Fixed incorrect example in documentation Simon Willison 2021-08-02 12:29:55 -07:00
• 60dea99ef7 --silent option for sqlite-utils insert-files, closes #301 Simon Willison 2021-08-02 12:12:16 -07:00
• d83b256813 --where and -p options for sqlite-utils convert, closes #304 Simon Willison 2021-08-02 11:58:05 -07:00
• 69c7da5ec9 Implemented .convert(..., where=, where_args=), refs #304 Simon Willison 2021-08-02 11:33:56 -07:00
• 4823aff4c3 table.count_where() method, closes #305 Simon Willison 2021-08-01 22:05:03 -07:00
• 652040f213 table.count_where() method, closes #305 convert Simon Willison 2021-08-01 22:05:03 -07:00
• 5ec6686153
  sqlite-utils convert command and db[table].convert(...) method Simon Willison 2021-08-01 21:47:39 -07:00
• 4c3bf97305 Documentation for table.convert(...), refs #302 Simon Willison 2021-08-01 21:43:20 -07:00
• 93114feefb flake8 fixes Simon Willison 2021-08-01 21:21:21 -07:00
• da93cf115e Test more sqlite-utils convert error conditions Simon Willison 2021-08-01 21:17:53 -07:00
• d2436c148e Unit tests for .convert(multi=True), refs #251, #302 Simon Willison 2021-08-01 21:11:40 -07:00
• 570bee7edd Implemented .convert(multi=True) and refactored CLI to use that method, refs #251, #302 Simon Willison 2021-08-01 21:08:40 -07:00
• d0e25fbc0d Tests for recipes Simon Willison 2021-08-01 14:40:35 -07:00
• 3532bcca97 Test for --drop error without --output or --multi Simon Willison 2021-08-01 14:31:06 -07:00
• eef46da8f5 table.convert(...) method, refs #251 Simon Willison 2021-08-01 14:22:41 -07:00