Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
And your accept rate is still 0%… Pay attention to the advice you were given stackoverflow.com/questions/3554502/… and stackoverflow.com/questions/3554226/… and stackoverflow.com/questions/3553892/… –  Quentin Aug 24 '10 at 14:57
add comment

migrated from stackoverflow.com Aug 24 '10 at 16:04

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

3 Answers

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
add comment

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.