Kwil v2
Search
⌃K

Supported Features

Kuneiform has a set of supported data types and attributes

Data Types

Kwil supports a restricted set of data types compared to other relational databases. If there is a data type your application would like to see added, please let us know! Below is a list of currently supported data types
Data Type
Restrictions
TEXT
Must be no greater than 1024 characters
INT
Must be within -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807

Attributes

Attributes refer to a the properties and constraints of a column. A column can have multiple attributes. Some attributes require values to be defined with them. Below is a list of supported attributes:
Attribute
Description
Primary Key
Identifies a column as the table's primary key. In Kwil, primary key variables are nullable.
Unique
Ensures that all values in a column are unique. Also creates a unique index on the column.
Not Null
Ensures that all values in the column are not null.
Default
If no value is provided to a new record, the column will be set to the passed value.
Min
Specifies a minimum value for an INT column.
Max
Specifies a maximum value for an INT column.
Min Length
Specifies a minimum length for a TEXT column.
Max Length
Specifies a maximum length for a TEXT column.