{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":26350830,"defaultBranch":"master","name":"sqlite-web","ownerLogin":"coleifer","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2014-11-08T05:26:31.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/119974?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1707053733.0","currentOid":""},"activityList":{"items":[{"before":"f708337b334d088d423564223010ad735de8a5ed","after":"036230a29b85e9b2d9611ca5b563db57133d3b24","ref":"refs/heads/master","pushedAt":"2024-05-30T13:15:21.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Remove google font reference from CSS.\n\nFixes #158","shortMessageHtmlLink":"Remove google font reference from CSS."}},{"before":"aa8de42f38608c70898164594229346dd4c1c678","after":"f708337b334d088d423564223010ad735de8a5ed","ref":"refs/heads/master","pushedAt":"2024-05-30T13:14:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Remove google font reference from CSS.","shortMessageHtmlLink":"Remove google font reference from CSS."}},{"before":"c3e0d2f64698c7cd8899607b321005e7d19d3291","after":"aa8de42f38608c70898164594229346dd4c1c678","ref":"refs/heads/master","pushedAt":"2024-05-23T12:42:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Uncheck cols w/default values on INSERT tab.\n\nFixes #156","shortMessageHtmlLink":"Uncheck cols w/default values on INSERT tab."}},{"before":"d084de56754b6f14d8bdafe6882f7856f4edf240","after":"c3e0d2f64698c7cd8899607b321005e7d19d3291","ref":"refs/heads/master","pushedAt":"2024-05-10T14:06:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Add option `-T` to disable text truncation.\n\nFixes #154","shortMessageHtmlLink":"Add option <code>-T</code> to disable text truncation."}},{"before":"cef7ed38d977c22b655f94c02749073249710260","after":"d084de56754b6f14d8bdafe6882f7856f4edf240","ref":"refs/heads/master","pushedAt":"2024-05-05T03:04:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Add transparent pagination to query tabs, also limit result size.\n\nPreviously a query with 1M result rows would evaluate all 1M rows and\nonly afterwards trim to the number displayed per page (1000 by default).\nThis fixes the performance issue by applying a LIMIT to a wrapped\nversion of the query, and perhaps redundantly, also using the fetchmany()\nAPI instead of fetchall().\n\nSince we were in there, we added transparent pagination as well, and a\nnew configuration option to set the results-per-page on the query tabs.\n\nFixes #153","shortMessageHtmlLink":"Add transparent pagination to query tabs, also limit result size."}},{"before":"ccf58608e88e51de420163d1d8b7000e5034181f","after":"cef7ed38d977c22b655f94c02749073249710260","ref":"refs/heads/master","pushedAt":"2024-04-21T19:36:15.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Add version to main module.\n\nRefs #151","shortMessageHtmlLink":"Add version to main module."}},{"before":"bea82919f09444dbfc91d7165d500213120669e3","after":"ccf58608e88e51de420163d1d8b7000e5034181f","ref":"refs/heads/master","pushedAt":"2024-04-21T19:34:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Add version to main module.","shortMessageHtmlLink":"Add version to main module."}},{"before":"16a06382a8de650877935eed65c7efa92475f2fe","after":"bea82919f09444dbfc91d7165d500213120669e3","ref":"refs/heads/master","pushedAt":"2024-04-10T12:55:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Attempt to fix busted pagination.\n\nBootswatch somehow messed this one up, attempt to make more readable.\n\nFixes #150","shortMessageHtmlLink":"Attempt to fix busted pagination."}},{"before":"771111cb6a3d5f84c5bc578398d11325d8e6ae97","after":"16a06382a8de650877935eed65c7efa92475f2fe","ref":"refs/heads/master","pushedAt":"2024-03-31T23:51:30.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Seems like the mimetype should be json when the export format is json (#149)","shortMessageHtmlLink":"Seems like the mimetype should be json when the export format is json (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2217164561\" data-permission-text=\"Title is private\" data-url=\"https://github.com/coleifer/sqlite-web/issues/149\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/coleifer/sqlite-web/pull/149/hovercard\" href=\"https://github.com/coleifer/sqlite-web/pull/149\">…</a>"}},{"before":"1d16f1c5aa50ec7e094936647a087abecc8520c2","after":"771111cb6a3d5f84c5bc578398d11325d8e6ae97","ref":"refs/heads/master","pushedAt":"2024-03-15T13:07:44.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Inserting a negative integer bugfix (#148)\n\nI try to create new row with a value \"-1\" and see the error: \r\n\"Value is not a number. INTEGER NOT NULL\"","shortMessageHtmlLink":"Inserting a negative integer bugfix (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2187998972\" data-permission-text=\"Title is private\" data-url=\"https://github.com/coleifer/sqlite-web/issues/148\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/coleifer/sqlite-web/pull/148/hovercard\" href=\"https://github.com/coleifer/sqlite-web/pull/148\">#148</a>)"}},{"before":"4c498e6ca14d91e7058ff4532677a05f6f06dcee","after":"1d16f1c5aa50ec7e094936647a087abecc8520c2","ref":"refs/heads/master","pushedAt":"2024-03-12T18:04:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Add support for foreign-key pragma via CLI option.\n\nFixes #147","shortMessageHtmlLink":"Add support for foreign-key pragma via CLI option."}},{"before":"6cebc5d43a0d89c80d35d5ef15256c8d2bb91517","after":"4c498e6ca14d91e7058ff4532677a05f6f06dcee","ref":"refs/heads/master","pushedAt":"2024-02-08T18:07:15.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Update README images for new cell layouts.","shortMessageHtmlLink":"Update README images for new cell layouts."}},{"before":"f283b870932f9b4ddb7fca63c3594847f57c569c","after":"6cebc5d43a0d89c80d35d5ef15256c8d2bb91517","ref":"refs/heads/master","pushedAt":"2024-02-08T18:05:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Update README images for new cell layouts.","shortMessageHtmlLink":"Update README images for new cell layouts."}},{"before":"1913084a45bec0e0d6fb0fd531321d4c99060343","after":"f283b870932f9b4ddb7fca63c3594847f57c569c","ref":"refs/heads/master","pushedAt":"2024-02-08T18:00:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Better table layout for row data.","shortMessageHtmlLink":"Better table layout for row data."}},{"before":"5ad24a55b767d4d749672b0644bfd1f5e19325cc","after":"1913084a45bec0e0d6fb0fd531321d4c99060343","ref":"refs/heads/master","pushedAt":"2024-02-08T14:23:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Use container-fluid for main body.\n\nThanks @swell-d for the suggestion.","shortMessageHtmlLink":"Use container-fluid for main body."}},{"before":"fa86cf51fe5c891ca215a491f4c94818f39b9d88","after":"5ad24a55b767d4d749672b0644bfd1f5e19325cc","ref":"refs/heads/master","pushedAt":"2024-02-05T14:27:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Remove default log handler when using log-file.","shortMessageHtmlLink":"Remove default log handler when using log-file."}},{"before":"85bf2d3d73022bd5fffd81c036bcfaafcbfa7bca","after":"fa86cf51fe5c891ca215a491f4c94818f39b9d88","ref":"refs/heads/master","pushedAt":"2024-02-04T13:35:32.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"0.6.3","shortMessageHtmlLink":"0.6.3"}},{"before":"c776cdc188c4120543b6af25e571782a8ea2b867","after":"85bf2d3d73022bd5fffd81c036bcfaafcbfa7bca","ref":"refs/heads/master","pushedAt":"2024-01-15T17:20:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"0.6.2","shortMessageHtmlLink":"0.6.2"}},{"before":"ed80c347ae1890607addf2af1c0c46f284e03a72","after":"c776cdc188c4120543b6af25e571782a8ea2b867","ref":"refs/heads/master","pushedAt":"2024-01-15T17:06:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Switch back to POST by default for query views.\n\nGET is still allowed as a fallback, however.\n\nRefs #140","shortMessageHtmlLink":"Switch back to POST by default for query views."}},{"before":"a82991f250cfea8151e404937f351318d76eb1c9","after":"ed80c347ae1890607addf2af1c0c46f284e03a72","ref":"refs/heads/master","pushedAt":"2023-12-13T15:36:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Ensure extensions are loaded before introspecting database.\n\nRefs #138","shortMessageHtmlLink":"Ensure extensions are loaded before introspecting database."}},{"before":"6ab0128c10f557e95c199a2171040d9d51d37fde","after":"a82991f250cfea8151e404937f351318d76eb1c9","ref":"refs/heads/master","pushedAt":"2023-10-13T15:28:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"0.6.1","shortMessageHtmlLink":"0.6.1"}},{"before":"2e33e12f5e6ebbde6e366984482c6d881b7ad15b","after":"6ab0128c10f557e95c199a2171040d9d51d37fde","ref":"refs/heads/master","pushedAt":"2023-10-13T15:28:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Fix bug in b64 converter.","shortMessageHtmlLink":"Fix bug in b64 converter."}},{"before":"3aafda5ab4451311440986ae8be101cbdfd0513d","after":"2e33e12f5e6ebbde6e366984482c6d881b7ad15b","ref":"refs/heads/master","pushedAt":"2023-10-12T21:12:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"0.6.0","shortMessageHtmlLink":"0.6.0"}},{"before":"d8744a54950bfd4b5bd733f6f727ea9b51b61ade","after":"3aafda5ab4451311440986ae8be101cbdfd0513d","ref":"refs/heads/master","pushedAt":"2023-09-30T14:25:06.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Fix url encoding for PKs with url-unsafe characters (like slashes) (#134)\n\nIf a PK has slashes (eg, a file path), they are not encoded properly and\r\nbreak Flask routing. For example, a PK value of `/tmp/foo` will route to\r\n`/table_name/update/tmp/foo`.\r\n\r\nFlask provides `url_map.converters['path']` for this, EXCEPT that the\r\n`path` converter still won't touch a leading slash, which needs to be\r\nencoded for this particular example.\r\n\r\nRather than worrying about what characters need to be url-encoded, or\r\nwhether they are at the start or end of a param, etc, just base64 the PK\r\nvalue so no matter what is in there, it's url-safe.\r\n\r\nhttp://exploreflask.com/en/latest/views.html#custom-converters","shortMessageHtmlLink":"Fix url encoding for PKs with url-unsafe characters (like slashes) (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1920031739\" data-permission-text=\"Title is private\" data-url=\"https://github.com/coleifer/sqlite-web/issues/134\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/coleifer/sqlite-web/pull/134/hovercard\" href=\"https://github.com/coleifer/sqlite-web/pull/134\">#134</a>"}},{"before":"f150b85b8f85d5a64712c811e0df9d8d04f633bb","after":"d8744a54950bfd4b5bd733f6f727ea9b51b61ade","ref":"refs/heads/master","pushedAt":"2023-09-17T15:56:53.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Fix incorrect arguments to export()\n\nReplaces issue in #133","shortMessageHtmlLink":"Fix incorrect arguments to export()"}},{"before":"53898145536f3b0b8b0dc8439a346c5751bb05b4","after":"f150b85b8f85d5a64712c811e0df9d8d04f633bb","ref":"refs/heads/master","pushedAt":"2023-09-17T15:53:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Fix incorrect arguments to export()","shortMessageHtmlLink":"Fix incorrect arguments to export()"}},{"before":"6495c8ab44f0cc0ec7ee0c2a2194239a3c8e4415","after":"53898145536f3b0b8b0dc8439a346c5751bb05b4","ref":"refs/heads/master","pushedAt":"2023-09-13T16:01:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Remove gif from readme.\n\nIt's no longer 2015","shortMessageHtmlLink":"Remove gif from readme."}},{"before":"561f061bd498fd0152b509c3a7b5f5587b3e0581","after":"6495c8ab44f0cc0ec7ee0c2a2194239a3c8e4415","ref":"refs/heads/master","pushedAt":"2023-09-13T15:58:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"New images for readme.","shortMessageHtmlLink":"New images for readme."}},{"before":"06cd8dd164a66cec4daa6db2c0aba20226c83ffc","after":"561f061bd498fd0152b509c3a7b5f5587b3e0581","ref":"refs/heads/master","pushedAt":"2023-09-13T12:56:31.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Improve logging and error handling.","shortMessageHtmlLink":"Improve logging and error handling."}},{"before":"b254977622dc2b6bf73e193cf97f57380ac96322","after":"06cd8dd164a66cec4daa6db2c0aba20226c83ffc","ref":"refs/heads/master","pushedAt":"2023-09-01T15:24:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"coleifer","name":"Charles Leifer","path":"/coleifer","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/119974?s=80&v=4"},"commit":{"message":"Add generic query page and update sql help images.","shortMessageHtmlLink":"Add generic query page and update sql help images."}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEWAlbzQA","startCursor":null,"endCursor":null}},"title":"Activity · coleifer/sqlite-web"}