MesaSQLite makes creating, designing, and altering an SQLite3 database as easy as possible for new developers or database administrators.
It allows you to edit, summarize, and analyze data using the SQLite3 database engine. It works in a "tab" style interface where new database connections are opened in a new window. In this way, you can open connections to multiple databases at once and get more work done.
You can carry out basic functions such as view, add, duplicate, rename, and delete tables, specify field type, length, default value, and auto increments and add and delete indexes on tables. The program is particularly adept at exporting data to REALBasic code, a proprietary dump to back-up the structure and content of the database and export the content screen, custom query result, to a table as a csv, tab, or xls file.
If you're new to SQLite3 database administration or need to administer several databases at the same time, then MesaSQLite is a good start.
