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 Native Mobile 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 Online Native Mobile applications architecture and Offline Native Mobile 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.

Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant