FileHint
JAEN

.sqlite

Use caution

SQLite database

A self-contained relational database in a single file. Embedded in iOS, Android, and browsers — the de-facto standard for mobile local storage.

MIME types

  • application/vnd.sqlite3
  • application/x-sqlite3

Category

data

Aliases

.sqlite3 / .db

What opens this file

  • DB Browser for SQLite
  • sqlite3 CLI
  • TablePlus
  • Datasette

How to open by OS

Windows

  • DB Browser for SQLite, sqlite3.

Mac

  • DB Browser, TablePlus, sqlite3.

Linux

  • sqlite3, Datasette.

Ios

  • SQLite Pro, direct from embedded apps.

Android

  • SQLite Editor.

Safety notes

  • Tampered SQLite files have led to parser CVEs with RCE potential; treat untrusted databases with care.
  • WAL files (-wal / -shm) must travel with the main file — sharing only .sqlite leaves the DB inconsistent.

Common mistakes

  • Skipping VACUUM leaves the file bloated over time — schedule maintenance.
  • Multiple writers hit database is locked. Funnel writes through a single process or connection.

Related extensions

References