Datatypes in QDB

Updated: April 19, 2023

QDB databases, which are stored in SQLite files, allow any value stored in any database field to have one of five standard storage classes. The SQLite design doesn't enforce data typing on database columns but instead maps each input value to a storage class based on the column's type affinity (preference).

QDB uses these storage classes to format data and to apply comparison or mathematical operators when evaluating queries and when ordering and grouping the results.