github

Custom SQL query returning 10 rows (hide)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
3e87500e1561f5c4e105cd026d33e0f715cc7dea table.optimize() deletes junk docsize rows Closes #153. Closes #149. 2020-09-07T21:16:13Z 2020-09-07T21:16:13Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
59e3d4d1715192ef7b6710ac970f5f4849ab0f0d Neater indentation for SQL used in schemas, closes #148 2020-09-07T18:12:45Z 2020-09-07T18:12:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
c44906429735e9c23774404dc105913f3ff90b7c Additional tests for WAL mode This should have been included in 2d2d724e32824095b0bf267a38d9c6fd628cc706 Refs #132 2020-09-07T20:46:12Z 2020-09-07T20:46:12Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
cf2cb244faf992118f34aa196387a4ef8b39a20f Tracer mechanism for showing underlying SQL queries * Pass a tracer= function to Database constructor * New db.tracer() contextmanager * Neater SQL indentation, because tracer means it could be visible now * New db.execute() and db.executescript() methods Closes #150 2020-09-07T21:56:59Z 2020-09-07T21:56:59Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
d0c752d50c9ddd1d094a26837347c970a9b34872 Fixed a couple of tiny HTML bugs, thanks curlylint curlylint datasette/templates https://github.com/thibaudcolas/curlylint 2020-09-07T15:43:37Z 2020-09-07T15:43:37Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
db02e87840e0b86ec35fcdfb170d7a879189adb9 Build demo with sqlite-utils>=2.17 To get the fix for this issue: https://github.com/simonw/sqlite-utils/issues/149 2020-09-07T23:18:07Z 2020-09-07T23:18:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 207052882 9599 19864447
de1059034486166131f2b2cd59ad69b4d26d6e25 recursive_triggers=on by default, closes #152 Refs #149 2020-09-07T20:45:06Z 2020-09-07T20:45:06Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
deb2eb013ff85bbc828ebc244a9654f0d9c3139e Release notes for 2.17 2020-09-07T22:07:21Z 2020-09-07T22:08:12Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
e878f2a8fe110ed5cf68e49c9902b641022c5b1d Applied latest black 2020-09-07T19:45:54Z 2020-09-07T19:45:54Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
f28cd4de6d0c87e892999adb7d23699d6c00af05 Release 2.17 Refs #144, #148, #149, #150, #151, #152, #153 2020-09-07T21:58:49Z 2020-09-07T21:58:49Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447