Skip to content

Ensure all created primary keys are not null #2807

Description

@simonw

Split from:

SQLite allows null primary keys (which then means a table can have multiple rows with the same null primary key value!). Datasette needs to be able to handle those in existing databases - see #2805 - but we can at least stem the bleeding a bit by disallowing them for tables created using the Datasette JSON API.

Metadata

Metadata

Assignees

No one assigned

    Labels

    data-entry-uiRelating to the UI for inserting/updating/deleting rows and creating/altering/dropping tables.json-api

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions