.db files
.db file
Generic Database File
An extension many programs use for their data — it does not identify one format.
What opens a .db file
- Windows
- DB Browser for SQLite, DBeaver, the application that created it
- macOS
- DB Browser for SQLite, DBeaver, the application that created it
- Linux
- DB Browser for SQLite, DBeaver, file (to identify it)
What a .db file is
A .db file could be SQLite, Berkeley DB, a Windows thumbnail cache or an application's private store; the extension tells you nothing. Most of the time it is SQLite, and DB Browser for SQLite will open it — if it refuses, the file is something else. Never edit an application's .db while the program is running, because half-written changes corrupt it.
Converting it
A .db file is commonly converted to .sql, .csv or .sqlite. It is a binary format, so a text editor will show unreadable characters rather than its contents.
Details
- Extension
- .db
- Full name
- Generic Database File
- Category
- Data
- Created by
- Various
- Format
- Binary
Common questions
- How do I open a .db file?
- On Windows use DB Browser for SQLite; on macOS use DB Browser for SQLite; on Linux use DB Browser for SQLite. An extension many programs use for their data — it does not identify one format.
- What is a .db file?
- Generic Database File. A .db file could be SQLite, Berkeley DB, a Windows thumbnail cache or an application's private store; the extension tells you nothing. Most of the time it is SQLite, and DB Browser for SQLite will open it — if it refuses, the file is something else.
- Can I convert a .db file?
- Yes. It is usually converted to .sql, .csv or .sqlite, either by exporting from one of the programs listed above or with a format converter.
Related pages
- .csv — Comma-Separated Values A spreadsheet as plain text, one row per line — the universal data exchange form
- .json — JavaScript Object Notation The standard text format for structured data on the web and in config files.
- .xml — Extensible Markup Language A tag-based text format for structured data, still everywhere in enterprise syst
- .yaml — YAML Data File An indentation-based configuration format, readable but unforgiving about whites
- .log — Log File A plain-text record of what a program did, newest events usually at the bottom.
- .torrent — BitTorrent Metainfo File A few kilobytes of metadata describing what to download and from whom — not the
- .dat — Generic Data File A meaningless extension — .dat says only that some program stored data here.
- .vcf — vCard Contact File One or more contacts as plain text — the standard way to move an address book.
- .sql — SQL Script A text file of database commands — often a full database dump.
- .ics — iCalendar Event A calendar invitation or event feed in a plain-text standard format.
- .sqlite — SQLite Database A complete relational database in a single file — the most deployed database in
- .bin — Binary File Raw binary data — most often a disc image paired with a .cue, or device firmware
Sources
- Media Types Registry — IANA
- Official vendor product documentation — At One Place