I would like to know what the .sqlite file is for. When I use MySql or MongoDB, the database is on disk, its something I never see. The documentation tells me with SQLite, everything is contained in a single disk file. Does this mean this .sqlite file is the database itself (and that it is, like all my other regular files, stored on disk)?
closed as unclear what you're asking by Jörg W Mittag, Doc Brown, gnat, Peter K., JeffO Mar 23 '18 at 13:58
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
.sqlite file is the complete database. It's one of the big features of sqlite in that it's single-file with binary compatibility between platforms.
From the About SQLite page (emphasis added):
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
For a description of the file format, see Database file format on the sqlite website.
Does this mean this .sqlite file is the database itself (and that it is, like all my other regular files, stored on disk)?
One use case for this design is when you actually want "data files" that can be stored in arbitrary locations and whose content happens to be accessible to your code like an SQL database.