home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 803501756

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/249#issuecomment-803501756 https://api.github.com/repos/simonw/sqlite-utils/issues/249 803501756 MDEyOklzc3VlQ29tbWVudDgwMzUwMTc1Ng== 9599 2021-03-21T02:33:45Z 2021-03-21T02:33:45Z OWNER

Did you run enable-fts before you inserted the data?

If so you'll need to run populate-fts after the insert to populate the FTS index.

A better solution may be to add --create-triggers to the enable-fts command to add triggers that will automatically keep the index updated as you insert new records.

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