What data types does SQLite support?
SQLite supports the following data types:
- INTEGER: A numerical type that can store any whole number value.
- Real: a data type that can store floating-point values.
- TEXT: A data type that can store string values.
- BLOB: Binary Large Object type, capable of storing any binary data.
- NULL is a data type that can store empty values.
Furthermore, SQLite also supports setting constraints and default values using keywords such as PRIMARY KEY, NOT NULL, UNIQUE, and DEFAULT.