MesaSQLite for Mac

MesaSQLite for Mac is a tool that allows you to create, design and change SQLite3 databases on Mac easily. You can use this tool to edit, synthesize and analyze data for both yourself and your customers.

Key features of MesaSQLite:

Connect

• Open a new connection with each new window.
• Open connection with multiple databases.
• Perform both operations on the same time.

VIEWS

• Add, drop, duplicate VIEWS .
• Select VIEW from the popup list of VIEWS .

Structure

• View, add, copy, rename and delete tables.
• View, add, copy, rename, edit and delete fields in the table.
• Specifies the field's type, length, default value.
• Add and delete indexes on tables.
• See the Create Table SQL syntax on a table.

View and edit content

• Select encoding for viewing data - encoding: 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.
• Automatically load records when selecting tables.
• Limit the number of records loaded when selecting a table.
• Build a query to restrict records using the drop-down menu.
• Limit records from a table by selecting the number of records and the starting record.
• Setting a limit to ' Load Last ' will load the last " n " record in the table.
• Limit the columns returned in a record.
• Reset column widths for easier viewing after loading a record with just one mouse click.
• See the total of columns in a record.
• Add and edit records directly in Listbox View .
• Delete the record directly from the Listbox screen.
• Click and drag the record in the Listbox to select the cells and switch to the clipboard.
• Rearrange data columns by clicking and dragging without changing the structure of the table.

Special query

• Enter the query into any custom query field.
• Stores important queries and records the history of recent queries.

Pactimza