.

SQLite


Reading time: less than 1 minute

SQLite is an embedded, in-process SQL database that keeps its data in a single file.

SQLite file format

  • The SQLite file format is documented at https://sqlite.org/fileformat.html.
  • The format is essentially a collection of pages that form B-Trees.
  • While writing a whole SQL engine for querying the file might be a large task, it’s quite easy to dump all rows by reading the pages.

Citation

If you find this work useful, please cite it as:
@article{yaltirakli,
  title   = "SQLite",
  author  = "Yaltirakli, Gokberk",
  journal = "gkbrk.com",
  year    = "2025",
  url     = "https://www.gkbrk.com/sqlite"
}
Not using BibTeX? Click here for more citation styles.
IEEE Citation
Gokberk Yaltirakli, "SQLite", August, 2025. [Online]. Available: https://www.gkbrk.com/sqlite. [Accessed Aug. 24, 2025].
APA Style
Yaltirakli, G. (2025, August 24). SQLite. https://www.gkbrk.com/sqlite
Bluebook Style
Gokberk Yaltirakli, SQLite, GKBRK.COM (Aug. 24, 2025), https://www.gkbrk.com/sqlite

Comments

© 2025 Gokberk Yaltirakli