github

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
000528192eaf891118932250141dabe7a1561ece New 'Testing plugins' page, closes #687 2020-06-22T03:53:42Z 2020-06-22T03:53:42Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
00185af74a91646d47aa54f2369c1a19a6f76a27 Show pysqlite3 version on /-/versions, if installed - #1125 2020-12-03T22:08:50Z 2020-12-03T22:08:50Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
00527e5c629d9dae56d6228891b40105ff0e34c6 Enable --cors by default in containers 2017-11-14T01:23:22Z 2017-11-14T01:23:22Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0057c087a1d467b1770bebf3206e2cb008bc2b7f Upgrade to sqlite-utils 2.x, closes #20 2020-03-23T19:22:46Z 2020-03-23T19:22:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
005913518b695a2456fada7db61ba0d30488bc12 Fix for bug where tweets were not saved This is a messy fix, need to dig in more 2019-09-04T21:16:38Z 2019-09-04T21:16:38Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
0071b5d6f5c97b9896dbcfc8f95ca0db8652a18a Added UI for editing table filters Refs #86 2017-11-23T04:33:55Z 2017-11-23T04:33:55Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
008e2f63c217aa066027a872ee706b07bd084857 response.set_cookie(), closes #795 2020-06-09T22:19:37Z 2020-06-09T22:19:37Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0091dfe3e5a3db94af8881038d3f1b8312bb857d More reliable tie-break ordering for facet results I was seeing a weird bug where the order of results running tests on my laptop was inconsistent, causing pytest failures even though the order of tests in Travis CI was fine. I think the fix is to explicitly state how facet ordering ties on the count should be resolved. 2020-02-13T06:36:42Z 2020-02-13T06:36:42Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
00a2895cd2dc42c63846216b36b2dc9f41170129 execute_write defaut is now block=True, closes #1579 2021-12-23T19:03:49Z 2021-12-23T19:03:49Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
00a9a5a5d184251c46e4c6426b10a1e56583300f Release 0.21.4 Refs #20, #55, #57 2021-08-20T00:04:07Z 2021-08-20T00:04:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
00ab95430003768067bb496b125a2be93134e73d Added CSS class rows-and-columns to main table 2018-04-24T01:30:03Z 2018-04-24T01:31:32Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
00c5a49a87e1ef3e39bb7ec5ab61f7c17f9ecd60 Option to ignore inserts if primary key exists already Support for SQLite's INSERT OR IGNORE In the API layer it looks like this: fresh_db["test"].insert({"id": 1, "bar": 3}, ignore=True) For the CLI layer it looks like this: $ sqlite-utils insert data.db dogs dogs.json --ignore Closes #21 2019-05-29T04:15:57Z 2019-05-29T04:15:57Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
00e233d7a7f6443cb95fb5227c23580c48551cad Prettier should ignore bundle.js file - refs #1893 2022-11-16T23:53:27Z 2022-11-16T23:53:27Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
00e2473f919d921a2aa1c9264397e3e593e3907e Added support for stickers 2019-08-30T14:45:26Z 2019-08-30T14:45:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 205429375 9599 9599
00e4bd5ff18ef4c3db6c1d67e2b974131c80d65c TSV and JSON support for sqlite-utils memory Closes #281, closes #279, refs #272 2021-06-19T03:11:54Z 2021-06-19T03:11:54Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0104dccca9d04916a9a5ba03874c92d9a9704096 Updated Travis password, refs #317 2018-06-21T15:33:14Z 2018-06-21T15:33:14Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0120c24927af364304574ab1a58e417094e01c22 extra_css_urls/extra_js_urls in metadata, refs #153 A mechanism in the metadata.json format for adding custom CSS and JS urls. Create a metadata.json file that looks like this: { "extra_css_urls": [ "https://simonwillison.net/static/css/all.bf8cd891642c.css" ], "extra_js_urls": [ "https://code.jquery.com/jquery-3.2.1.slim.min.js" ] } Then start datasette like this: datasette mydb.db --metadata=metadata.json The CSS and JavaScript files will be linked in the <head> of every page. You can also specify a SRI (subresource integrity hash) for these assets: { "extra_css_urls": [ { "url": "https://simonwillison.net/static/css/all.bf8cd891642c.css", "sri": "sha384-9qIZekWUyjCyDIf2YK1FRoKiPJq4PHt6tp/ulnuuyRBvazd0hG7pWbE99zvwSznI" } ], "extra_js_urls": [ { "url": "https://code.jquery.com/jquery-3.2.1.slim.min.js", "sri": "sha256-k2WSCIexGzOj3Euiig+TlR8gA0EmPjuc79OEeY5L45g=" } ] } Modern browsers will only execute the stylsheet or JavaScript if the SRI hash matches the content served. You can generate hashes using www.srihash.org 2017-11-29T02:38:15Z 2017-11-29T02:38:15Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
012c76901af65442e90eac4b36db43455e3c922f _ prefix for many private methods of Datasette, refs #576 2020-05-30T14:38:46Z 2020-05-30T14:38:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
012fc7c5cd3e9160c9a4c19cc964253e97fb054a Fix for FTS virtual table counting error 2018-03-21T01:26:04Z 2018-03-21T01:26:04Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
013cc8147abb78227b7232c2d14cb428613b5760 user-timeline documentation 2019-09-04T20:39:12Z 2019-09-04T20:39:12Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
0142c2a3c2772cc370c734e7e6049e8cc2343a5f Improved test_create_index_analyze test, refs #378 2022-01-10T20:02:08Z 2022-01-10T20:02:08Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0156c6b5e52d541e93f0d68e9245f20ae83bc933 Facet in predictable order for tests, refs #448 2021-11-16T01:31:33Z 2021-11-16T01:31:33Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0159662ab8ccb363c59647861360e0cb7a6f930d Fix for bug running ?sql= against databases with a different route, closes #1682 2022-03-23T18:48:10Z 2022-03-23T18:48:10Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
015bd2a840a008a105f731c50eee319963352c1b Test for .table_names(fts5=True) 2019-01-25T04:23:53Z 2019-01-25T04:23:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
015c6634644a11e5a3ca9d7dafe22ba62b87f2dd Fixed lint errors, refs #454 2022-07-15T21:59:06Z 2022-07-15T21:59:06Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0183e1a72d4d93b1d9a9363f4d47fcc0b5d5849c Preserve JSON key order in YAML, refs #1153 2023-07-08T17:26:50Z 2023-07-08T17:27:36Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
01b3de5b66742f0f661183e9e2ef66be3600e831 Unit test for binary data display, refs #442 2019-05-03T16:43:59Z 2019-05-03T16:45:06Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
01c7784be54d14ee5b653753c38005d823fcdd09 CI is now GitHub Actions, closes #143 2020-08-28T22:41:29Z 2020-08-28T22:41:29Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
01e0c3fa18cd0dd7970e208790ffd683a420c924 Fixed &nbsp; bug &nbsp; was showing for all None values in table cells, thanks to the autoescaping change introduced in 82261a638bd35c9 2017-11-16T15:29:52Z 2017-11-16T15:29:52Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
01fe5b740171bfaea3752fc5754431dac53777e3 datasette install / datasette uninstall commands, closes #925 2020-08-11T22:31:47Z 2020-08-11T22:32:06Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0209a0a344503157351e625f0629b686961763c9 table_exists() now uses async SQL, refs #420 2019-03-31T18:02:22Z 2019-03-31T18:02:22Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
020effe47bf89f35182960a9645f2383a42ebd54 Preserve query string in % to - redirects, refs #1650 2022-03-07T16:18:07Z 2022-03-07T16:18:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0242ae340b34417248fb88cdaa7716804ced1ed9 Handle subject-date note attribute 2020-10-11T23:45:15Z 2020-10-11T23:45:15Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 303218369 9599 9599
026c84db30bd0a75ecde146a80a5d142078dc299 Refactor Datasette methods to ConnectedDatabase Refs #487 2019-05-27T04:56:43Z 2019-05-27T04:56:43Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
02862be04c51e8ec6e29517d3c28b030627bb179 Default to FTS5 2018-08-13T00:21:55Z 2018-08-13T00:21:55Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 140912432 9599 9599
02870e573154517f129cbc85e437d5f0105d7cbe Filter out duplicate JS/CSS URLs, refs #291 (testme) 2018-05-27T08:45:03Z 2018-05-27T08:45:03Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
02898bf7af4a4e484ecc8ec852d5fee98463277b Run flake8 in CI, refs #291 2021-06-23T01:23:12Z 2021-06-23T01:23:12Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
02b1814fcfdc61b1b69b5955f2b60252ff10cde9 Redirects now preserve query string Fixes #28 2017-10-24T23:54:26Z 2017-10-24T23:54:26Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
02b19c7a9afd328f22040ab33b5c1911cd904c7c Removed rogue pdb=True, refs #1377 2021-06-23T22:50:48Z 2021-06-23T22:50:48Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
02bb373194000d2b15f61914e7c5fdb124275bcd Updated release process 2020-12-11T01:38:16Z 2020-12-11T01:38:16Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
02dc6298bdbfb1d63e0d2a39ff597b5fcc60e06b permission_allowed resource can be a tuple 2020-07-21T15:22:31Z 2020-07-21T15:22:36Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
02e38b363ed2211fd32f7d97bef36512b5ebf294 Foreign keys for milestones table, refs #31 2020-04-21T18:58:21Z 2020-04-21T18:58:21Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
02ee31c8b45b872fff91e2059c15a20532e2d035 New hidden: True option for table metadat, closes #239 2018-04-26T03:42:57Z 2018-04-26T03:42:57Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
030deb4b25cda842ff7129ab7c18550c44dd8379 Try to handle intermittent FileNotFoundError in tests Refs #1361 2021-06-05T23:01:34Z 2021-06-05T23:02:03Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
03305ea183b1534bc4cef3a721fe5f3700273b84 Remove python.version, refs #1176 2022-02-07T06:40:47Z 2022-02-07T06:40:47Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0331666e346c68b86de4aa19fbb37f3a408d37ca ?_search=x now works directly against fts virtual table Closes #135 2017-11-20T06:18:07Z 2017-11-20T06:18:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
033a1bb22c70a955d9fd1d3b4675a0e2e5c8b8cd Removed rogue print() from test 2020-06-05T19:06:43Z 2020-06-05T19:06:43Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
033cf0bcbbcadd0256d0c43fb7b9d3053727b4fe DatabaseView no longer uses .inspect(), closes #420 2019-05-02T01:12:58Z 2019-05-02T01:13:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
03418ee037057aa85204f5a3feb2066cbb6a9b3e Release 0.47 Refs #335, #923, #925, #926, #928 2020-08-12T00:42:47Z 2020-08-12T00:42:47Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
034d498b319d37b0639203fa4fbb304715b3ae03 Support Database(memory=True) for in-memory databases 2019-07-23T00:12:54Z 2019-07-23T00:12:54Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
03572ae35573c2ea802a540624ce116f540ba1ac Allow --load-extension to be set via environment variable I tesed this by first building and running a container using the new Dockerfile from #114: docker build . docker run -it -p 8001:8001 6c9ca7e29181 /bin/sh Then I ran this inside the container itself: apt update && apt-get install wget -y \ && wget http://www.gaia-gis.it/spatialite-2.3.1/test-2.3.sqlite.gz \ && gunzip test-2.3.sqlite.gz \ && mv test-2.3.sqlite test23.sqlite \ && datasette -h 0.0.0.0 test23.sqlite I visited this URL to confirm I got an error due to spatialite not being loaded: http://localhost:8001/test23-c88bc35?sql=select+ST_AsText%28Geometry%29+from+HighWays+limit+1 Then I checked that loading it with `--load-extension` worked correctly: datasette -h 0.0.0.0 test23.sqlite \ --load-extension=/usr/lib/x86_64-linux-gnu/mod_spatialite.so Then, finally, I tested it with the new environment variable option: SQLITE_EXTENSIONS=/usr/lib/x86_64-linux-gnu/mod_spatialite.so \ datasette -h 0.0.0.0 test23.sqlite Running it with an invalid environment variable option shows an error: $ SQLITE_EXTENSIONS=/usr/lib/x86_64-linux-gnu/blah.so datasette \ -h 0.0.0.0 test23.sqlite Usage: datasette -h [OPTIONS] [FILES]... Error: Invalid value for "--load-extension": Path "/usr/lib/x86_64-linux-gnu/blah.so" does not exist. Closes #112 2017-11-17T14:13:35Z 2017-11-17T14:13:35Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0357774c946b7a35871715d7fc23b3f04f519af8 Renamed test_tables.db to fixtures.db in unit tests 2018-06-17T18:34:16Z 2018-06-17T18:34:16Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
036ec6d32313487527c66dea613a3e7118b97459 Ignore test .db files 2021-01-03T18:43:21Z 2021-01-03T18:43:21Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
03933b30841470d05769807828cdcfffbb7a5780 .prettierrc, refs #1166 2020-12-31T21:25:44Z 2020-12-31T21:25:44Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
03c58fb350f6b9bb941a46907da5ac6f67bf47cf Show databases in alphabetical order on index page 2017-11-10T19:04:56Z 2017-11-10T19:04:56Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
03e3f7d6486123bf3eb852ad007d9761475f138c Configured Travis CI 2018-07-28T13:48:53Z 2018-07-28T13:48:53Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 140912432 9599 9599
03ec71193b9545536898a4bc7493274fec48bdd7 Don't truncate list of columns on /db page, closes #1364 2021-06-06T22:07:45Z 2021-06-06T22:07:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
03ee97d2258254581bea72842518904fc1cbe60f CLI now supports upsert/insert - closes #115 2020-06-12T17:40:53Z 2020-06-12T17:40:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
040fc0546f1ad602125ecdc27d9d013d830aa808 Updated tests, refs #817 2020-06-08T19:02:56Z 2020-06-08T19:02:56Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0467723ee57c2cbc0f02daa47cef632dd4651df0 New, improved favicon - refs #1603 2022-01-20T05:46:03Z 2022-01-20T05:46:03Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
046ca380fd93f352da6e58139b96f2e4a365f53a Release 0.2 2020-03-27T22:23:16Z 2020-03-27T22:23:16Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 213286752 9599 9599
046e5246c9698a6fc9901ca265ae47c68fcf5d13 Longer delay to hopefully get test to pass, refs #364 2022-01-10T04:51:07Z 2022-01-10T04:51:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0486303b60ce2784fd2e2ecdbecf304b7d6e6659 Explicitly push version tag, refs #1281 2021-03-29T01:42:42Z 2021-03-29T01:42:42Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
04c1d2cc54c71d4c6e795d174c7bb52f91739627 followers/friends --sql/--attach options, closes #36 2020-03-20T23:12:30Z 2020-03-20T23:12:30Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
04c896160a9981d37beb71529ac717a6fcf1b195 Renamed 'stream all records' to 'stream all rows', refs #266 2018-06-18T14:25:44Z 2018-06-18T14:25:44Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
04d21ccd089fcaf7a2b535d217fc541ab19aa54b /-/versions now includes SQLite fts_versions, closes #252 2018-05-11T13:19:25Z 2018-05-11T13:19:25Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
04ec53c039feb590c7832d499a14a9caba081f11 Validate column names in more places, refs #86 2020-02-27T04:55:17Z 2020-02-27T04:55:17Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
05238b16328c9fed1486972dbce1b4df66a82f1b Added tags to demo, refs #43 2020-07-18T21:52:51Z 2020-07-18T21:52:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
05317f53411fab3c3d66b88408bc867f2e474a35 Release 0.14 2019-02-24T23:11:51Z 2019-02-24T23:11:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
05399058062ba6df467c8745b87ece5f6951b39f Renamed "datasette build" command to "datasette inspect" Closes #130 2017-12-07T16:57:31Z 2017-12-07T16:57:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0539bf0816b58c7f0ba769331f1509656bff3619 Don't execute facets/counts for _shape=array or object, closes #263 2021-06-02T02:53:00Z 2021-06-02T02:53:00Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
05a312caf3debb51aa1069939923a49e21cd2bd1 Applied Black, refs #1368 2021-06-26T22:25:28Z 2021-06-26T22:25:28Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
05a85b358fb907d8fcb72f19390ee2ba5a2261a5 Don't assume -1 for error code 2019-02-24T19:50:56Z 2019-02-24T19:50:56Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
05cabaebd99b4aa388096de0a03fb52d08f6c117 Pass --token to now alias, refs #459 2019-05-11T20:35:34Z 2019-05-11T20:35:34Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
05daa15aac27bdfb86bd04e97f7544347d398598 Documentation for /-/create ignore/replace, closes #1927 2022-12-08T01:42:54Z 2022-12-08T01:42:54Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
05e2bb85fcd11729db40c6452f2f7287232e2f1a db.close() method, closes #504 2022-10-25T20:57:43Z 2022-10-25T20:57:43Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
060a56735c1d3bde0a4c7674e82b5f45bef34dee actor_from_request and permission_allowed hookspecs, refs #699 2020-05-30T20:24:00Z 2020-06-01T01:16:42Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
062303419cef9bbf72927c4ac4efdb185829c03b Hide facet button is now a ✖ - refs #255 2018-05-16T14:37:05Z 2018-05-16T15:27:24Z 13ae486343ea6454a93114c6f558ffea2f2c6874 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0663d5525cc41e9260ac7d1f6386d3a6eb5ad2a9 More comments in TableView.data(), refs #1518 2021-12-16T22:00:29Z 2021-12-16T22:00:29Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
06762776f712526fdb40a18ed26f259be62bb214 Fix for incorrect hidden for fields for _columns, refs #1527 2021-11-30T03:04:20Z 2021-11-30T03:04:35Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
06a826c3188af82f27bb6b4e09cc89b782d30bd6 :fire: Removes DS_Store (#81) * :fire: Removes .DS_Store Signed-off-by: Jeff Triplett <jeff.triplett@gmail.com> * :snowflake: Adds .DS_Store to gitignore Signed-off-by: Jeff Triplett <jeff.triplett@gmail.com> 2017-11-13T22:16:54Z 2017-11-13T22:16:54Z 207bb2132044fa5a4fe28a579f7588c2eee6e391 2946d096d0cdefdc017559e6b57e87658736e843 107914493 50527 9599
06dfb95a5ca5c0682ccad87b6150a2b0db66ade1 Initial working version Only supports loading checkins from a JSON file on disk: swarm-to-sqlite swarm.db -f checkins.json 2019-08-30T11:26:27Z 2019-08-30T11:26:27Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 205429375 9599 9599
06fdf0fd79adb8510da5de8f6ed30a0b5b8668e1 Fully working faceted search Closes #3 2020-09-03T21:01:14Z 2020-09-03T21:01:20Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 197431109 9599 9599
07044bd130542870d5eb2e545988d0a24eb573ec SQL view-friendly arraycontains/arraynotcontains implementation, refs #448 2021-11-15T23:41:07Z 2021-11-15T23:41:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
070838bfa19b177f59ef3bd8f0139266adecda90 Better test for Vary header 2020-06-06T19:26:19Z 2020-06-06T19:26:19Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0748a65a22302640ec7520a19aaba280b5615930 Fixed content-disposition header on DB download, closes #909 2020-07-29T21:34:22Z 2020-07-29T21:34:22Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0784f2ef9d3ff6dd9df05f54cb51de29a6d11764 Allow specific pragma functions, closes #761 2020-05-06T17:18:31Z 2020-05-06T17:18:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0789bad8f7581fd96dec5bde51a75e937dffb1e0 @db.register_function(deterministic=True), closes #191 2020-10-28T21:24:03Z 2020-10-28T21:30:58Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
079bf1f4dc8540f834adae68c7feeeffcbc1d4f2 Use tmp_path fixture in test_recreate, refs #503 2022-10-25T20:06:58Z 2022-10-25T20:06:58Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
07a10bdb2c09c7e275a9db546c42900b1dea4e75 foreign_keys=[...] can now detect tables and keys - closes #25 2019-06-13T05:32:26Z 2019-06-13T05:32:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
07e163561592c743e4117f72102fcd350a600909 All ?_ parameters now copied to hidden form fields, closes #1194 2021-01-25T03:10:10Z 2021-01-25T03:10:10Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
07e208cc6d9e901b87552c1be2854c220b3f9b6d Refactored .custom_sql() method to new QueryView class Refs #698 2020-04-03T01:12:13Z 2020-04-03T01:12:13Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
07fc2d113e462bfd8d7d56152c0d1fc55e0fdbe9 Fix for _sort_desc=sortable_with_nulls test, refs #216 2018-04-17T00:05:03Z 2018-04-17T00:05:03Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0807c4200f6b31c804c476eb546ead3f875a2ecc Release notes for 0.45a1, refs #852 2020-06-18T23:40:45Z 2020-06-18T23:40:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
080d4b3e065d78faf977c6ded6ead31aae24e2ae Switch to python:3.10.6-slim-bullseye for datasette publish - refs #1768 2022-08-14T15:49:14Z 2022-08-14T15:49:14Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
08110bc2b8801d725d65fa834d30b57e473d2241 Added example Twitter developer account application email Thanks to Jacob Kaplan-Moss: https://twitter.com/jacobian/status/1192510111719313408 2019-11-08T23:04:17Z 2019-11-08T23:04:17Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
08181823990a71ffa5a1b57b37259198eaa43e06 Update cli-reference for editable change, refs #2106 2023-07-26T18:52:37Z 2023-07-26T18:52:57Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
084350b0f1343d988928cae63cfedbeb6205e25e Switched to gather_request=False for Sanic tests Gets rid of those ugly _, response = lines. 2017-11-17T14:53:37Z 2017-11-17T14:53:37Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
087753cd42c406f1e060c1822dcd9b5fda3d60f4 sites.db is better name than dogs.db in this example 2022-08-28T04:01:55Z 2022-08-28T04:01:55Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
088d89982299f8136e608fa2b6c30e9529adc714 Release 3.23 Refs #79, #363, #392, #393, #395, #396 2022-02-04T06:41:46Z 2022-02-04T06:41:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
089278b8dbe0cb3d41f27666d97b0096b750fbe2 rST fix, refs #1384 2021-06-26T22:49:07Z 2021-06-26T22:49:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599