Windows support SQLite, the SQL-based relational database management system (RDMS), for local data storage. There are a few things to note when you first work with SQLite, that may influence integration.properties the way we develop with it:
- SQLite stores data in a simple text file. There is no granular security or user privileges for data therefore anyone with file system access to it may read its contents.
- There are only five underlying data types; NULL, INTEGER, REAL, TEXT and BLOB. For more detail see Datatypes In SQLite .
- Binary objects (BLOBs) are stored as text representations, thus access to BLOBs is not optimal. It is recommend to store BLOBs on the file system and store the file system path in the database.
- SQLite supports concurrent read access, but enforces sequential write access. This is because a file system lock is placed on the file during write operations. This is an important point to bear in mind with multi-threaded applications.
- RIGHT and FULL OUTER JOINs are not supported.
- There is limited ALTER TABLE support columns may not be modified or deleted.