home / github / issue_comments

Menu
  • GraphQL API

issue_comments: 586676856

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/86#issuecomment-586676856 https://api.github.com/repos/simonw/sqlite-utils/issues/86 586676856 MDEyOklzc3VlQ29tbWVudDU4NjY3Njg1Ng== 9599 2020-02-16T07:20:34Z 2020-02-16T07:20:34Z OWNER I'm not sure what to do about this one. I can't fix it: this bug in Python's `sqlite3` module means that even if I write a database out with column names that include `[]` I won't be able to read them back again. So... I could do one of the following: - Throw an error if a column name includes those characters. That's my preferred option I think. - Automatically replace `[` in column names with `(` and `]` with `)` - Do the automatic replacement but show a user-visible warning when I do it - Throw an error, but give the user an option to run with e.g. `--fix-column-names` which applies that automatic fix. Since this is likely to be an incredibly rare edge-case I think I'd rather minimize the amount of code that deals with it, so my preferred option is to just throw that error and stop. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} 564579430  
Powered by Datasette · Queries took 2.851ms