We stand with Ukraine to help keep people safe. Join us
All Apps
Best AppsReviewsComparisonsHow-To
When you purchase through links on our site, we may earn an affiliate commission

MesaSQLite for Mac

SQLite3 database browser, editor and manager.

$20.00
In English
3.3
Based on 8 user rates

MesaSQLite overview

MesaSQLite makes creating, designing, and altering an SQLite3 database easy. We also use it to edit, summarize, and analyze data for ourselves and clients. Although we build new databases most days, we spend more of our time viewing and editing data. MesaSQLite is set up for this in mind.

MesaSQLite uses the SQLite3 database engine. Here is an overview of MesaSQLite features:

Connections:

  • Connect to any database visible on a volume
  • Open a new connection with each new window
  • Do both of the above at the same time
Structure:
  • View, add, duplicate, rename, and delete tables
  • View, add, duplicate, rename, edit, and delete fields on tables
  • Specify field type, length, nullable, default value, and autoincrement
  • Add and delete indexes on tables
  • View the Create Table sql syntax for your tables
Viewing and Editing Content:
  • Select encoding for viewing your data - encodings: UTF8, Win Arabic, Win Baltic Rim, Win Cyrillic, Win Greek, Win Latin 1, Win Latin 2, Win Vietnamese, K018-R, Shift-JIS, ISO Arabic, SO Cyrillic, ISO Greek, ISO Hebrew, ISO Latin 1, ISO Latin 2
  • Limit the number of records that load upon table selection
  • Suppress autoloading of records upon table selection
  • Build query to limit records using dropdown menus
  • Limit a recordset from a table by selecting a record count and a starting record
  • Set a "Load Last" limit that will load the last "n" records in the table
  • Limit the columns returned in a recordset
  • Sort a recordset by multiple fields
  • Make global changes to many records in a showing recordset
  • Reset column widths for easier viewing after a recordset loads with one click
  • View totals of numeric columns in a recordset with one click
  • Add and edit records directly in the listbox view
  • Delete records directly from the listbox view
  • Multi-select adjacent or non-adjacent rows for deletion or global editing
  • Click and drag in the recordset listbox to select cells and make them available to the clipboard
  • Reorder columns of data using click-and-drag without changing the structure of the table
Special Queries:
  • Type any query into the custom query field
  • Read errors and rows returned associated with a custom query
  • Store favorite queries and keep a history of recent queries
Forerign Keys:
  • SQLite3 Trigger technology is used to create Foreign Keys whose syntax is stored in the CREATE TABLE suntax of the table. Three triggers are created for each key in order to create and preserve referential integrity between tables
  • Create, view, and edit your Foreign Keys in the Foreign Key tab
Exporting and Importing Data:
  • Drop a file containing REALBasic code to generate the database you have built in MesaSQLite
  • Export a proprietary dump to back-up the structure and content of the database
  • Export the content screen, custom query result, or table as a csv, tab, or xls file
  • Import a proprietary dump that can recreate the database from a single file
  • Import any csv, tab, or xls file into a given table

What’s new in version 4.2.7

Version 4.2.7: Release notes were unavailable when this listing was updated.
View older MesaSQLite versions

MesaSQLite for Mac

$20.00
In English
Version 4.2.7
Write a detailed review about MesaSQLite

Write your thoughts in our old-fashioned comment

MacUpdate Comment Policy. We strongly recommend leaving comments, however comments with abusive words, bullying, personal attacks of any type will be moderated.
3.3

(8 Reviews of MesaSQLite)

  • Comments

  • User Ratings

TheCore
TheCore
Feb 14 2012
3.2.6
5.0
Feb 14 2012
5.0
Version: 3.2.6
I think I have tried them all, well - almost, including some expencive ones. MesaSQLite 3.2.6 just rocks. Thought my needs are related mostly around REALBasic and Livecode, my perspective might be too narrow. Still I feel this piece of software keeps what it promises, and then some. My returning nightmare; REALBasic - SQLite - Foreign Keys is gone. MesaSQLite 3.2.6 have this solved in an smart and "over the hood" easy-looking way. I have been working with databases since 1984 (yeah, computers was invented then), and trough the years some software have impressed me by ease of use and features - in relation to it's pricetag. MesaSQLite is one of them! It's easy to understand, logical, and packed with features way beyond it's pricetag. This is software development combined with common sence!
Kris-K-
Kris-K-
Apr 4 2011
3.1.3
5.0
Apr 4 2011
5.0
Version: 3.1.3
The problem I mentioned below has been fixed in the new version. Looks like I'm going to use this a lot more than Base now :) Thanks to the developer, Rick, for being very responsive here and over email.
Kris-K-
Kris-K-
Mar 2 2011
3.0.9
5.0
Mar 2 2011
5.0
Version: 3.0.9
MesaSQLite forgets my preferences settings whenever it relaunches, including the text font for the Listbox Appearance.
tvalleau
tvalleau
Feb 24 2009
1.9.7
5.0
Feb 24 2009
5.0
Version: 1.9.7
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.
Mitch-Bicquet
Mitch-Bicquet
Oct 23 2008
1.7.6
2.0
Oct 23 2008
2.0
Version: 1.7.6
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.
Mark-0d170160
Mark-0d170160
Jun 2 2012
2.0
Jun 2 2012
2.0
Version: null
TheCore
TheCore
Feb 14 2012
5.0
Feb 14 2012
5.0
Version: null
Maksym-Cherniaiev
Maksym-Cherniaiev
Jan 14 2012
4.0
Jan 14 2012
4.0
Version: null
Kris-K-
Kris-K-
Apr 4 2011
5.0
Apr 4 2011
5.0
Version: null
Chaosmedia
Chaosmedia
Mar 30 2011
0.5
Mar 30 2011
0.5
Version: null
tvalleau
tvalleau
Feb 24 2009
5.0
Feb 24 2009
5.0
Version: null
Mitch-Bicquet
Mitch-Bicquet
Oct 23 2008
2.0
Oct 23 2008
2.0
Version: null
barefeettom
barefeettom
Mar 16 2008
3.0
Mar 16 2008
3.0
Version: null