TVALLEAU  I've been using this software for a few weeks now, and discovered that the previous comments no longer apply. The developer is very responsive. If you know how to run the program, you'll not have any of the previous problems... and the program continues to improve. If you're working with SQLite, this is the way to go.  
(Version 1.9.7)

MITCH BICQUET  Unfortunately I cannot conccur with the reviews below.

The program looks fine but has oo many random bugs during editing to be usable. this is on Macbook with 10.5.5 and all latest updates.

I tried creating 5 tables, then in 1 of the tables about 12 fields of different types. I Got random errors, exception not handled, SQl errors when trying to rename tables, change types for fields.

Simple example: create table Master, hit enter - commit. create some table Fields

double click on Master, change M to m lower case, click enter - all your fields just disappeared. You must close and reopen the DB.

Also at one point it corrupted my DB( created datecreated field, left the type blank to think if I wanted date or timestamp, make a search in firefox (loose focus) come back to app - change to timestamp - error. When I reopen the database the whole table is gone!

So, looks promising, but stay away for now until those basic things are fixed.  
(Version 1.7.6)

BAREFEET  Some more comments:

It's great to see this as a native Cocoa app, rather than some of the ugly Java alternatives. MesaSQLite opens database files on AppleShare volumes, which a few others choke on.

The query builder is very good, but it would be nice to have a one click way to show all the data in the selected table (eg in the table list) in one click.

Nulls and empty string entries are indistinguishable.

The entity/tables browser needs a few bugs fixed, such as not showing single quotes in table names (which result from "alter table rename to" command) and truncated name when followed by a -- comment. Alpha sorting would be helpful and perhaps filtering (by name).

Editing data is done in cell mode (one large wrapped text field in a panel) only. Cell mode is great for long text, but in-situ editing in cells in the column view would be faster for multiple edits. A line/form mode (fields down the page, for one record) would also be a good option.

The GUI for "add table" and the "Content" query editor are very good, with a polished Mac feel and helpful popups like options for what is contained in the desired field. SQL editing (in the "Custom Query" tab) is very basic and only in a small field in a panel. It has no syntax coloring, quick entry tools (such as drag from a list of tables). The GUI does 70% of the job (or probably 95% for beginners), but the lack of SQL Editor features make the remaining 30% a bit tedious. Lack of support for views to save queries limits the usefulness of queries and the "Save query to favorites" is a poor substitute, reinventing the wheel and stores a global list that shows irrelevant queries when in another database file.

Great work so far :-)  
(Version 1.6.8)

BAREFEET  Wow this developer responds quickly.

I can list all triggers or per table, which is neat. I can edit existing triggers and the "not yet implemented alert when I try to create a new freeform trigger is encouraging. The template for creating foreign key triggers is clever.

Still waiting for editing of views, but I'm hopeful.

Remaining bugs in using column names with spaces in them seem to have been taken care of.  
(Version 1.6)

BAREFEET  It's great to see a database program that uses SQLite in a Mac GUI, not a limited Java type GUI, like many others.

MesaSQLite seems to have a good grounding, providing access to the structure of tables (grid and SQL) and the associated (with each table) triggers (SQL) and indexes (SQL and grid). The grid view is functional for most but lacks some rarely used content such as "collate nocase" and comments.

MesaSQLite now happily accepts SQL names (tables, columns etc) containing spaces, though a remaining bug when using such columns in the query builder. However, you can't currently create or see the structure or content of views, which I need before making use of such a program.

Nice GUI for queries.

The grid view of content (data rows and columns) is neat, wide enough to show the data (unlike many similar programs). It would be good to see a form view too, or at least a one record per page line view (similar to the output of ".mode line" in sqlite3). A mechanism for showing lists of records related to that one record would also be really useful, though I've never seen a similar program provide it.

Keep up the good work! :-)  
(Version 1.5.8)