home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1296343173

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/1873#issuecomment-1296343173 https://api.github.com/repos/simonw/datasette/issues/1873 1296343173 IC_kwDOBm6k_c5NRKCF 9599 2022-10-30T20:21:54Z 2022-10-30T20:22:20Z OWNER

One last case to consider: WITHOUT ROWID tables.

https://www.sqlite.org/withoutrowid.html

By default, every row in SQLite has a special column, usually called the "rowid", that uniquely identifies that row within the table. However if the phrase "WITHOUT ROWID" is added to the end of a CREATE TABLE statement, then the special "rowid" column is omitted. There are sometimes space and performance advantages to omitting the rowid.

...

Every WITHOUT ROWID table must have a PRIMARY KEY. An error is raised if a CREATE TABLE statement with the WITHOUT ROWID clause lacks a PRIMARY KEY.

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