Mac OS X | Business / Productivity | Database | MesaSQLite

MesaSQLite - 1.5.2

SQLite3 database browser, editor & manager

Download v 2.2.2

(File Size: 8.6M)

Free Product Alerts!

All Time:	(4.0)
Version 1.5.2:	Not rated (0.0)
Selected Version:	1.5.2
Release Date:	2007-11-14
License:	Beta
Downloads (version 1.5.2):	647
Downloads (all versions):	16,391

Information Related to Version:

Broken Link? Newer Version? Tell us!

Product Description:

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 a database on your machine or over the internet
Open a new connection with each new window
Open multiple connections to the same database
Open connections to multiple databases
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 this version:

Version 1.5.2

Change: Updates the SQLite library to 3.4.2

Operating System Requirements:

This product is designed to run on the following operating systems:

Mac OS X 10.4 Intel
Mac OS X 10.4 PPC
Mac OS X 10.3.9
Mac OS X 10.3
Mac OS X 10.2

Additional Requirements:

Mac OS X

Feedback Summary:

Version 1.5.2:
Overall Rating:	Not rated (0.0)	Features:	Not rated (0.0)	Support:	Not rated (0.0)
Ease of Use:	Not rated (0.0)	Quality / Stability:	Not rated (0.0)	Price:	Not rated (0.0)

Key to Types of Feedback:

Reviews Reviews Troubleshooting Usage Tips Developer Notes Commentary Featured Reviews

Good software - Version: 1.9.7, 2/23/2009 11:12AM PST

tracy valleau--2008

I've been using this for a few weeks now, and find that it works with SQLite very well. Further, and importantly, the developer is quick to respond, and courteous. If you know SQLite, or want to get into it, you'll find this software worth the price.