SQLite

Unofficial Content

SQLite Databases are created and maintained by Smart Devices Applications generated by GeneXus' Native Mobile Generator.

Schema

Generated Schema depends on Connectivity Support property.

Offline Smart Devices applications generate a normalized database, while the online ones generate just a very simple one to use the SQLite database as a cache. Take a look at Smart Devices online applications architecture and Smart Devices offline applications architecture for a deeper understanding.

Encoding

Data is stored in unicode (specifically UTF8 ).

Data Types mapping (Offline Apps)

GeneXus Datatype   SQLite Datatype
 
N(X) X<19 INTEGER
N(X) X>=19 NUMERIC
N(X,Y)   NUMERIC
CHAR   TEXT
VARCHAR   TEXT
LONGVARCHAR   TEXT
BLOB   TEXT
DATE   TEXT
DATETIME   TEXT
BOOLEAN   INTEGER
     

Limits

https://www.sqlite.org/limits.html
Limits may vary depending on the Device's limits and the SQLite version installed in those devices.