Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Workbench is MySQL default. Correct me if I'm wrong. I dont believe SQLite has it own default admin. Is there any recommendation for the admin?

share|improve this question

migrated from Aug 24 '10 at 16:04

This question came from our site for professional and enthusiast programmers.

Theres not much to administer in a SQLite DB. There are no users, extra databases, or even any server settings to speak of. I would use a generic data modeling tool to create my table structures and relations then use the sqlite command line tool to execute the create table scripts. Once your tables are in place then use whatever tool or api you were going to use anyways to interact with the database.

share|improve this answer

I've had good experience with the Firefox add-on SQLite Manager - although it's primarily intended to work with FF's SQLite databases, it is usable for unrelated SQLite databases.

share|improve this answer

SQLite comes with a command-line client. This is the default administration client for SQLite.

share|improve this answer

You must log in to answer this question.