Modules and plug-ins > 4base > Database Definition

This chapter lists information and special features related to the SQLite data connection.

The plug-in structure contains the same elements already described in section 2.1 in the chapter Database definition.

SQLite

The SQLite library is required here (Download)

Attention

If you use Timestamps in SQLite databases a problem can occur when the timestamps are wrong formatted. In this case please see the respective section in the FAQs.

SQLite type conversion

SQLite has a different handling of data types compared to other databases. This includes that the return value of each aggregate function always has the data type Object.

This affects all aggregate functions. Details can be found in the chapter SQL Statements.