SQLite guides for Mac
Start with the file you have or the problem you need to solve. These guides include command-line workflows as well as Petti where a graphical view helps.
Opening, inspecting and troubleshooting
How to Open a SQLite File on Mac
Open .sqlite, .sqlite3 and .db files safely on macOS. Learn how to identify SQLite files, browse tables and handle WAL companion files.
Read-only SQLite Browsing on Mac: What It Protects
Understand Petti’s genuine read-only SQLite connection, when editing becomes writable, how changes save, and when you still need a backup.
How to Browse Large SQLite Databases on Mac
Browse large SQLite databases on Mac using bounded pages and lazy loading. Learn why indexes, query shape and large values affect performance even in a fast grid.
Django SQLite databases
Find the SQLite database configured by Django, list tables with sqlite3, and inspect rows on Mac. Know when direct edits bypass Django’s application rules.
SQLite WAL and SHM files
Understand SQLite -wal and -shm files, why recent changes may be outside the main database, and how to inspect or back up a live SQLite database safely.
Database is locked
Diagnose SQLite lock errors without deleting WAL files or risking data. Check open transactions, competing writers, timeouts and read-only inspection on Mac.
File is not a database
Diagnose SQLite “file is not a database” on Mac. Check the path, file header, encryption and possible damage before attempting recovery or changing the original.
Export SQLite to CSV
Export SQLite rows to CSV on Mac with sqlite3 or Petti. Include column headers, select the data you need, and understand NULL values and spreadsheet limitations.
iOS Simulator SQLite databases
Locate an iOS Simulator app’s data container with simctl, find SQLite files, and inspect them read-only on Mac. Understand WAL files and Core Data precautions.