Guides
- .db vs .sqlite vs .sqlite3: what's the difference?SQLite files use several extensions but the same format inside. What each one means, which to choose, and what the -wal, -shm and -journal files are.
- How to open a .db fileCheck whether a .db file is a SQLite database, then open it in your browser, a free desktop app or the command line, with fixes for common errors.
- How to view a SQLite database on a MacOpen a SQLite file on macOS in Safari or any browser, with the built-in sqlite3 tool or with DB Browser for SQLite. Plus where Mac apps keep their data.
- How to view a SQLite database on WindowsOpen a SQLite .db file on Windows 10 or 11 in your browser, with DB Browser for SQLite or the sqlite3 tool. Plus where Windows apps keep their data.