home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1846554637

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/sqlite-utils/issues/605#issuecomment-1846554637 https://api.github.com/repos/simonw/sqlite-utils/issues/605 1846554637 IC_kwDOCGYnMM5uEDAN 9599 2023-12-08T05:07:54Z 2023-12-08T05:07:54Z OWNER

Thanks for opening an issue - this should help future Google searchers figure out what's going on here.

Another approach here could be to store large integers as TEXT in SQLite (or even as BLOB).

Both storing as REAL and storing as TEXT/BLOB feel nasty to me, but it looks like SQLite has a hard upper limit of 9223372036854775807 for integers.

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