Skip to content

Columns of views have incorrect datatype #87

@ad-si

Description

@ad-si

As far as I can tell all columns of views (which don't have any type affinity per default) are coerced to TEXT by datasette-graphql.

One way to figure out the correct datatype would be to inspect all values (or a sample?) and use that information:

sqlite> select typeof(name), typeof(name_length) from songs_view;
text|integer
text|integer
text|integer

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions