Opening and viewing the content of a .sqlite file [closed]

Question

How can I open and see the records, tables, etc in a .sqlite execution file which has been added to in an iPhone application? Are there any tutorials for doing this?

Answer 1

open firefox, go to: https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/ then download and install. after installing click on Tools-->SQLite Manager-->click on the link..connect database..-->give the path of .sqlite file. and open

Answer 2

if you use firefox: https://addons.mozilla.org/en-US/firefox/addon/5817

SQLite Manager

Manage any SQLite database on your computer...

Features:

• Manage any SQLite database on your computer.
• An intuitive heirarchical tree showing database objects.
• Helpful dialogs to manage tables, indexes, views and triggers.
• You can browse and search the tables, as well as add, edit, delete and duplicate the records.
• Facility to execute any sql query.
• The views can be searched too.
• A dropdown menu helps with the sql syntax thus making writing sql easier.
• Easy access to common operations through menu, toolbars, buttons and context-menu.
• Export tables/views/database in csv/xml/sql format. Import from csv/xml/sql (both UTF-8 and UTF-16).
• Possible to execute multiple sql statements in Execute tab.
• You can save the queries.
• Support for ADS on Windows...