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.