github

Custom SQL query returning 101 rows (hide)

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
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
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
00e2473f919d921a2aa1c9264397e3e593e3907e Added support for stickers 2019-08-30T14:45:26Z 2019-08-30T14:45:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 205429375 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
015bd2a840a008a105f731c50eee319963352c1b Test for .table_names(fts5=True) 2019-01-25T04:23:53Z 2019-01-25T04:23:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 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
01b7a6a71ca121ec91ca4cc18f46a565098441fd List of all current Dogsheep tools 2019-10-13T02:23:10Z 2019-10-13T02:23:10Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 214746582 9599 19864447
01c7784be54d14ee5b653753c38005d823fcdd09 CI is now GitHub Actions, closes #143 2020-08-28T22:41:29Z 2020-08-28T22:41:29Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
01dec730860ce4d2b6e92cb8cbca7330c252893d GitHub Actions test badge 2020-10-12T20:30:18Z 2020-10-12T20:30:18Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 205429375 9599 19864447
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
022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9 Much, much faster extract() implementation Takes my test down from ten minutes to four seconds! * Removed unnecessary update() optimization * Added column_order= to .transform() and .transform_sql() * Tests for reusing lookup table in extract() Closes #172 2020-09-24T15:43:55Z 2020-09-24T15:43:55Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
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
028f193dd6233fa116262ab4b07b13df7dcec9be How to use a custom domain with Cloud Run 2020-07-22T18:17:05Z 2020-07-22T18:17:05Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
02b1814fcfdc61b1b69b5955f2b60252ff10cde9 Redirects now preserve query string Fixes #28 2017-10-24T23:54:26Z 2017-10-24T23:54:26Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 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
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
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
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
046ca380fd93f352da6e58139b96f2e4a365f53a Release 0.2 2020-03-27T22:23:16Z 2020-03-27T22:23:16Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 213286752 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
05a85b358fb907d8fcb72f19390ee2ba5a2261a5 Don't assume -1 for error code 2019-02-24T19:50:56Z 2019-02-24T19:50:56Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
05bdf53358ec6ea81a7dce17290f3db0cd94d23d Added missing hyphen 2018-04-20T21:15:13Z 2018-04-20T21:15:13Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
05cabaebd99b4aa388096de0a03fb52d08f6c117 Pass --token to now alias, refs #459 2019-05-11T20:35:34Z 2019-05-11T20:35:34Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 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
06645f2e267b16d0c193bb1d1b7ca0cb67227c43 Formatting tweak 2017-12-09T18:41:20Z 2017-12-09T18:41:20Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
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
070838bfa19b177f59ef3bd8f0139266adecda90 Better test for Vary header 2020-06-06T19:26:19Z 2020-06-06T19:26:19Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
071bc2dd6350461aa1fb1a8e281ad9a79fba08ae Typo 2020-03-21T04:29:53Z 2020-03-21T04:29:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 248903544 9599 19864447
0747dabb24b608e8524de4858ce50c60ba7e471b table.update() method * Also now set .last_pk to lastrowid for rowid tables * table.pks introspection now returns ["rowid"] for rowid tables Closes #35 2019-07-28T15:43:50Z 2019-07-28T15:43:50Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
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
075d422c0a1c70259188dfbd940538c67419694a Fixed typo 2017-11-14T05:28:02Z 2017-11-14T05:28:02Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0784f2ef9d3ff6dd9df05f54cb51de29a6d11764 Allow specific pragma functions, closes #761 2020-05-06T17:18:31Z 2020-05-06T17:18:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 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
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
08029a2f8f67bbcd42bea755de5fb7db12b2c275 Hyperlink to www.srihash.org 2018-05-26T19:46:24Z 2018-05-26T19:46:24Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0807c4200f6b31c804c476eb546ead3f875a2ecc Release notes for 0.45a1, refs #852 2020-06-18T23:40:45Z 2020-06-18T23:40:45Z 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
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
08b4928a75faa1f2ba1c5b9908bcf2df4975a9d4 asgi-csrf>=0.6, refs #835 2020-07-01T01:18:19Z 2020-07-01T01:18:19Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
08f4b7658fec97419eb34118a2cd5c8be805673f Show facets that timed out using new InterruptedError If the user requests some _facet= options that do not successfully execute in the configured facet_time_limit_ms, we now show a warning message like this: These facets timed out: rowid, Title To build this I had to clean up our SQLite interrupted logic. We now raise a custom InterruptedError exception when SQLite terminates due to exceeding a time limit. In implementing this I found and fixed a logic error where invalid SQL was being generated in some cases for our faceting calculations but the resulting sqlite3.OperationalError had been incorrectly captured and treated as a timeout. Refs #255 Closes #269 2018-05-18T06:07:45Z 2018-05-18T06:11:23Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09253817dea3c131553494f9b2eb9c03f94ae761 Fix for missing view_name bug, closes #716 2020-04-05T18:28:20Z 2020-04-05T18:28:20Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
092874202c8748d6e0d4800eaf707c0145d95ffe Improvements to allow block logic and debug tool true and false allow block values are now supported, closes #906 Added a bunch of demo links to the documentation, refs #908 2020-07-25T00:04:06Z 2020-07-25T00:04:06Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
092e1368edc4e7f4cb337a62eabd9a6e1245006b Fixed typo 2019-05-25T14:24:17Z 2019-05-25T14:24:17Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
09316835e609e2321dafa08d37d8f227521373f8 Implemented --tsv option, closes #41 2019-07-19T04:50:38Z 2019-07-19T04:50:38Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0934844c0b6d124163d0185fb6a41ba5a71433da request.post_vars() no longer discards empty values 2020-06-03T13:48:39Z 2020-06-03T13:48:39Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0949f0989c932bae59ec702a002fe521ca56570c emojis command, closes #47 2020-08-18T14:52:08Z 2020-08-18T14:52:08Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
0988f2eccc2dfa26b1a55243582222f540a72838 Explicitly include tests and docs in sdist (#75) Also exclude 'tests' from runtime installation - thanks, @jayvdb 2020-01-31T00:21:26Z 2020-01-31T00:21:26Z 85de645274a2cefaeda2a43f117f5e672fd8e2f9 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 15092 19864447
0991ea75cc7b265389aa8362414a305ba532d31a Renamed _timestamp to _now, refs #842, closes #871 2020-06-28T19:45:34Z 2020-06-28T19:47:28Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09a3479a5402df96489ed6cab6cc9fd674bf3433 New "startup" plugin hook, closes #834 2020-06-13T17:55:41Z 2020-06-13T17:55:41Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09bf3c63225babe8e28cde880ca4399ca7dbd78b Documentation for publish --secret, refs #787 2020-06-11T16:14:30Z 2020-06-11T16:14:30Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09ef305c687399384fe38487c075e8669682deb4 Fixed "datasette publish now ... --alias=x" The --alias argument can now be passed more than once. Also updated our Travis configuration to use this. Fixes #459 2019-05-11T20:20:36Z 2019-05-11T20:20:36Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0a0cec3cf27861455e8cd1c4d84937825a18bb30 Release 1.12.1 2019-11-07T04:58:47Z 2019-11-07T04:58:47Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0a14a4846b29b4b60d153356ad926cbc461c45c7 Added plugin_config() method 2018-08-28T08:35:21Z 2018-08-28T08:35:21Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0a2dddccd7eb6cedae128c08931f14f12d5bce70 'github-to-sqlite repos' now accepts multiple usernames 2019-11-11T05:02:33Z 2019-11-11T05:02:33Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
0a8194e730f8ecdd9a5af1f6a8d5a889796d7dba sqlite-utils optimize command, .optimize() and .detect_fts() table methods 2019-01-25T04:35:51Z 2019-01-25T04:35:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0aa28293adedc488eb9107dc52b5e9a124887fbd Fix compatibility with SQLite prior to 3.16.0 pragma_index_info() and pragma_index_list() were introduced in 3.16.0 but the version of SQLite running in Travis CI is earlier than that, hence the test failures: https://travis-ci.com/simonw/sqlite-utils/jobs/137617744 2018-08-01T15:29:53Z 2018-08-01T15:29:53Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 140912432 9599 9599
0abd3abacb309a2bd5913a7a2df4e9256585b1bb New ?_shape=objects/object/lists param for JSON API (#192) New _shape= parameter replacing old .jsono extension Now instead of this: /database/table.jsono We use the _shape parameter like this: /database/table.json?_shape=objects Also introduced a new _shape called 'object' which looks like this: /database/table.json?_shape=object Returning an object for the rows key: ... "rows": { "pk1": { ... }, "pk2": { ... } } Refs #122 2018-04-03T14:52:54Z 2018-04-03T14:52:54Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0ac8bbce2e73c0759ec48661a7b740d2c368b2a2 Default subcommand is now serve Using click-default-group: https://github.com/click-contrib/click-default-group Also removed requirements.txt in favour of setup.py 2017-11-04T23:53:50Z 2017-11-04T23:53:50Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0ad3ce5e2d664c227d7045afafec46704f251a10 Use INTEGER for organization column, fixes #27 2020-04-18T00:18:45Z 2020-04-18T00:18:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
0b0a431bff94d24866fc10d82dc91ab00287de2d Changelog for 2.0 release 2019-12-30T06:18:44Z 2019-12-30T06:18:44Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0b1af42ead3b3902347951180b3364ce1942da6e Link to my blog entry 2019-02-25T03:45:38Z 2019-02-25T03:45:38Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0b5edd646926d6e01e3bf9f2897d072f4302ce2d Added basic tests using hypothesis, closes #180 2020-10-19T04:51:50Z 2020-10-19T04:51:50Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0b702f3679a2ffd4e3efb5c34b9fe30221172ccb Fixed weird edge-case with foreign key detection It turns out it is possible for a SQLite table to define a foreign key relationship to a table that does not actually exist We should still be able to handle these databases. 2017-11-17T16:18:26Z 2017-11-17T16:18:26Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0b84d52ab87d960d4b5e188052540518db2ea569 Release 0.10 2019-10-15T18:53:53Z 2019-10-15T18:53:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
0b8a952cd5709ac27494b1694ca95188c89442ce Release 0.20.1 Refs #41 2020-04-01T04:31:23Z 2020-04-01T04:31:23Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
Powered by Datasette · Query took 6.24ms · About: simonw/datasette-graphql