SQLite is a self-container, serverless SQL database engine especially well suited to low powered devices such as the iPhone. If you're doing iPhone development work then you'll find your SQLite file under ~/Library/Application Support/iPhone Simulator/User/Applications/

Clients

• Firefox (cross-platform)
  • SQLite Manager 0.4.8

Tips

• To describe a table use pragma table_info ( table_name );