Unifinity Studio allows you to define the database to be used by your Unifinity application.

To perform DB design, click [DB] on the design screen switching button before operation.

In the next and subsequent chapters, we will assume that the design screen is displayed when switching to [DB].

Database to be used

Unifinity Studio/Unifinity Application Player uses the SQLite (version 3 3.3.1) library. SQLite is a database software that stores data in a single file (SQLite file). Compared to other database software, it is faster if the amount of data is small and consumes less memory.

When you create a project in Unifinity Studio, a SQLite file is generated for that project. During development in Unifinity Studio, direct manipulation of the generated SQLite files, such as with another tool, will have no effect.

SQLite File Security

Data used internally in the Unifinity application is written to SQLite files.

This SQLite file is stored in a location on the smartphone that is inaccessible to other applications. Furthermore, even if an SQLite file were to be extracted, it would be difficult to recover the data because SQLite files are encrypted.

Response to SQL injection attacks

When using database mechanisms, it is important to take measures against "SQL injection" vulnerabilities. For more information on SQL injection, see the "What is SQL Injection?(Japan Network Information Center), etc.

SQLite employs bound parameters (SQL statements and parameters are passed to the database separately) to protect data from SQL injection attacks.