Detailed Description of MesaSQLite 2.2.2

MesaSQLite makes creating, designing, and altering an SQLite3 database easy. We also use MesaSQLite 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

* 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

Views

* Add, Drop, Duplicate VIEWS
* Select a VIEW from a popup list of VIEWS

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

TAGS OF MESASQLITE

flash presentations , adult movies freewares , microsoft paint , cook recipe book , regcure advanced , swf decompiler v4.5 guide and faq , ms proxy , mpeg4 converter , free screen savers , foxy jumper 2 , tid to dwg , convert fmcmp files , proxy checker