home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 976399638

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
976399638 MDU6SXNzdWU5NzYzOTk2Mzg= 319 [Enhancement] Please allow 'insert-files' to insert content as text. 66709385 closed 0     10 2021-08-22T15:10:46Z 2021-08-24T23:33:45Z 2021-08-24T23:33:44Z NONE  

'insert-files' creates BLOB columns for file contents. Transforming the column to TEXT still keep the content as binary. Even though I'm sure there is a transform that can be applied decoding the text it would be great to have a argument to make 'insert-files' to do it as text (with optional text encoding).

The use case is a bunch of htmls (single file) on a directory structure that inserted with this command could be served in Datasette allowing full text search.

140912432 issue    
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/319/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  completed

Links from other tables

  • 2 rows from issues_id in issues_labels
  • 10 rows from issue in issue_comments
Powered by Datasette · Queries took 4.092ms · About: github-to-sqlite