There's something I don't understand, it says that the "data is next to the application", what does it mean? Where is stored and how is it accessed by the application?
The data lives in a file the application reads/writes directly (and in a cache that the sqlite libraries can park inside the application itself). The point is that you're not calling out over the network to a "database server"; your app server is the database server.
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.
