github: issue_comments: 9 rows where reactions = "{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}"

9 rows where reactions = "{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}"

Search:

descending

id ▼	html_url	issue_url	node_id	user	created_at	updated_at	author_association	body	reactions	issue
489353316	https://github.com/simonw/datasette/issues/187#issuecomment-489353316	https://api.github.com/repos/simonw/datasette/issues/187	MDEyOklzc3VlQ29tbWVudDQ4OTM1MzMxNg==	carsonyl 46059	2019-05-04T18:36:36Z	2019-05-04T18:36:36Z	NONE	Hi @simonw - I just hit this issue when trying out Datasette after your PyCon talk today. Datasette is pinned to Sanic 0.7.0, but it looks like 0.8.0 added the option to remove the uvloop dependency for Windows by having an environment variable `SANIC_NO_UVLOOP` at install time. Maybe that'll be sufficient before a port to Starlette?	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Windows installation error 309033998
758280611	https://github.com/simonw/datasette/issues/1091#issuecomment-758280611	https://api.github.com/repos/simonw/datasette/issues/1091	MDEyOklzc3VlQ29tbWVudDc1ODI4MDYxMQ==	tballison 6739646	2021-01-11T23:06:10Z	2021-01-11T23:06:10Z	NONE	+1 Yep! Fixes it. If I navigate to https://corpora.tika.apache.org/datasette, I get a 404 (database not found: datasette), but if I navigate to https://corpora.tika.apache.org/datasette/file_profiles/, everything WORKS! Thank you!	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	.json and .csv exports fail to apply base_url 742011049
781077127	https://github.com/simonw/datasette/issues/283#issuecomment-781077127	https://api.github.com/repos/simonw/datasette/issues/283	MDEyOklzc3VlQ29tbWVudDc4MTA3NzEyNw==	simonw 9599	2021-02-18T05:56:30Z	2021-02-18T05:57:34Z	OWNER	I'm going to to try prototyping the `--crossdb` option that causes `/_memory` to connect to all databases as a starting point and see how well that works.	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Support cross-database joins 325958506
781764561	https://github.com/simonw/datasette/issues/283#issuecomment-781764561	https://api.github.com/repos/simonw/datasette/issues/283	MDEyOklzc3VlQ29tbWVudDc4MTc2NDU2MQ==	simonw 9599	2021-02-19T02:10:21Z	2021-02-19T02:10:21Z	OWNER	This feature is now released! https://docs.datasette.io/en/stable/changelog.html#v0-55	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Support cross-database joins 325958506
783674038	https://github.com/simonw/datasette/issues/1236#issuecomment-783674038	https://api.github.com/repos/simonw/datasette/issues/1236	MDEyOklzc3VlQ29tbWVudDc4MzY3NDAzOA==	simonw 9599	2021-02-22T21:05:21Z	2021-02-22T21:05:21Z	OWNER	It's good on mobile - iOS at least. Going to close this open new issues if anyone reports bugs.	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Ability to increase size of the SQL editor window 812228314
803130332	https://github.com/simonw/datasette/issues/1265#issuecomment-803130332	https://api.github.com/repos/simonw/datasette/issues/1265	MDEyOklzc3VlQ29tbWVudDgwMzEzMDMzMg==	simonw 9599	2021-03-19T21:03:09Z	2021-03-19T21:03:09Z	OWNER	This is now available in `datasette-auth-passwords` 0.4! https://github.com/simonw/datasette-auth-passwords/releases/tag/0.4	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Support for HTTP Basic Authentication 836123030
808986495	https://github.com/simonw/datasette/pull/1252#issuecomment-808986495	https://api.github.com/repos/simonw/datasette/issues/1252	MDEyOklzc3VlQ29tbWVudDgwODk4NjQ5NQ==	simonw 9599	2021-03-29T00:13:59Z	2021-03-29T00:13:59Z	OWNER	Neat fix, thank you!	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Add back styling to lists within table cells (fixes #1141) 825217564
995023410	https://github.com/simonw/datasette/issues/1423#issuecomment-995023410	https://api.github.com/repos/simonw/datasette/issues/1423	IC_kwDOBm6k_c47Ttoy	simonw 9599	2021-12-15T17:48:40Z	2021-12-15T17:48:40Z	OWNER	You've caused me to rethink this feature - I no longer think there's value in only showing these numbers if `?_facet_size=max` as opposed to all of the time. New issue coming up.	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Show count of facet values if ?_facet_size=max 962391325
1055855845	https://github.com/simonw/sqlite-utils/issues/343#issuecomment-1055855845	https://api.github.com/repos/simonw/sqlite-utils/issues/343	IC_kwDOCGYnMM4-7xTl	simonw 9599	2022-03-01T21:04:45Z	2022-03-01T22:43:38Z	OWNER	I'm going to make that `_hash()` utility function a documented, non-underscore-prefixed function too - called `hash_record()`.	{"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 1, "eyes": 0}	Provide function to generate hash_id from specified columns 1063388037

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
, [performed_via_github_app] TEXT);
CREATE INDEX [idx_issue_comments_issue]
                ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
                ON [issue_comments] ([user]);