Technics‎ > ‎

SQLite Manager Guide

SQLite Manager is a simple tool to manage SQLite databases. 

Installation

  1. Download and install Firefox from http://getfirefox.com
  2. Enable the menu bar. Alt + V -> Toolbars -> Menu Bar
  3. Go to addons: Tools -> Plugins
  4. Select "Search" and enter SQLiteManager. Then select Install
  5. Restart firefox
  6. To open the sqlite manager go to Tools -> SQLite Manager


Open or create a database

From the Database menu we can create (New Database) or open (Connect to database) a SQLite database. Each SQLite database is stored in a separate file. 

Panel of Tables Selection, Views, Indexes and Triggers.


The left pane allows you to display the tables (red) and columns (green). Selecting an item from the same panel, you can edit the item in different tabs.

Tabs

After opening the base, it can be managed through the tabs



Structure

Allows us to see and modify the structure of a table.

Browse and Search

Displays records in a table

Run SQL

Allows you to run a SQL query and display the result.

Autores

  • Miguel Galante, Alberto Laudadio