home / github

Menu
  • GraphQL API

github

Custom SQL query returning 5 rows (hide)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
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
2c2e67b9bb5f1f6b82348a16afe4a07e8073ab54 Updated default facet limits in docs 2018-05-18T15:50:37Z 2018-05-18T15:50:37Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
39426ff0e43a406f42c03692d3dc9d4a1b7b9d52 Added /-/limits and /-/limits.json, closes #270 2018-05-18T06:16:28Z 2018-05-18T06:16:28Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
b8227556c6ef040e2299b113d1ec6e220586ffc3 Suggested facets now use #fragment links Useful for pages with large amounts of content at the top like on https://fivethirtyeight.datasettes.com/fivethirtyeight-469e30d/nba-elo%2Fnbaallelo 2018-05-18T16:18:41Z 2018-05-18T16:18:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
cef9a9a8701af86cc7df8b7939398185f0a76f5f --limit= mechanism plus new limits for facets Replaced the --max_returned_rows and --sql_time_limit_ms options to "datasette serve" with a new --limit option, which supports a larger list of limits. Example usage: datasette serve --limit max_returned_rows:1000 \ --limit sql_time_limit_ms:2500 \ --limit default_facet_size:50 \ --limit facet_time_limit_ms:1000 \ --limit facet_suggest_time_limit_ms:500 New docs: https://datasette.readthedocs.io/en/latest/limits.html Closes #270 Closes #264 2018-05-18T05:08:26Z 2018-05-18T05:08:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
Powered by Datasette · Queries took 4.903ms · About: simonw/datasette-graphql