home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 709569951

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/894#issuecomment-709569951 https://api.github.com/repos/simonw/datasette/issues/894 709569951 MDEyOklzc3VlQ29tbWVudDcwOTU2OTk1MQ== 9599 2020-10-15T20:23:02Z 2020-10-15T20:23:02Z OWNER

Something to watch out for: "" empty strings cast to 0.0:

select cast("100" as real), "100", cast(null as real), cast("" as real)

cast("100" as real) | "100" | cast(null as real) | cast("" as real) -- | -- | -- | -- 100.0 | 100 |   | 0.0

https://latest.datasette.io/fixtures?sql=select+cast%28%22100%22+as+real%29%2C+%22100%22%2C+cast%28null+as+real%29%2C+cast%28%22%22+as+real%29

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
657572753  
Powered by Datasette · Queries took 0.88ms · About: github-to-sqlite