it means the data is stored in a file on the local drive of a computer that is also running the application.

it also means that it is the application itself (via the SQLite library) that reads and modifies that database file. There is no separate database process.