Using SQLite

SQLite is a superb database that doesn't need a server since it's actually on the file system with all tables stored in a file. That means you can have your database even on a memory stick, or your hard-disk, or a server.

In Firefox there is a free Addon you can download, though it's already installed in our labs at the university, it's called SQLite Manager; install it as an addon in Firefox if you don't have it.

This is for Firefox only, from the Tools menu, choose SQLite Manager then, to use it, do the following:

To Open an existing database

1. Click on the open folder icon or choose from the menu Database=>Connect Database. Using either method choose your sqlite database file. By default it will have an sqlite file extension.
2. When you've opened it you'll see a screen a little like the one on the right. It will be different, of course, according to the database you've opened and the version of SQLite Manager you're using.

   Notice, under the Tables section, you will see all the tables in your database.

3. Click on one of the tables to browse the records that table contains, making sure that the Browse & Search button at the top of the window is clicked.
4. You can also execute SQL commands like in any other database. Click on the Execute SQL button, then enter any valid SQL command where it says "Enter SQL", then click the Run SQL button.
5. There is obviously much more you can do: created indexes, alter table structures, create new tables etc. But you can find out how for yourself.