7 years ago
451 Views
0 0

MesaSQLite – SQLite database editor, browser and manager for Mac

Written by

MesaSQLite is a simple database editor, browser and manager for SQLite that help you to easily create, design and alter your SQLite databases. It allows you to edit, summarize, and analyze data using the SQLite3 database engine.

MesaSQLite SQLite database editor

it has tab style user interface where every new connection are open in new window. In this way, you can open multiple connections to the same database or open single connections to multiple databases or Do both of the action at the same time at once and get more work done. you can view, add, duplicate, rename, and delete tables and specify the field type, length, nullable, default value, auto increment and also easily add and delete indexes on tables, view the Create Table sql syntax for your tables.

Features of MesaSQLite

  1. Easy to Drop a file containing REALBasic code to generate the database you have built in MesaSQLite.
  2. Easy to export the content screen, custom query result, or table as a csv, tab, or xls files.
  3. Import any csv, tab, or xls file into a given table
  4. Import a proprietary dump that can recreate the database from a single file
  5. SQLite3 Trigger technology is used to create Foreign Keys whose syntax is stored in the CREATE TABLE syntax of the table. Three triggers are created for each key in order to create and preserve referential integrity between tables
  6. Create, view, and edit your Foreign Keys in the Foreign Key tab
  7. Store favorite queries and keep a history of recent queries
  8. Type any query into the custom query field
  9. Reorder columns of data using click-and-drag without changing the structure of the table
  10. Click and drag in the record set list box to select cells and make them available to the clipboard
  11. Multi-select adjacent or non-adjacent rows for deletion or global editing
  12. Delete records directly from the listbox view
  13. Add and edit records directly in the listbox view
  14. Set a "Load Last" limit that will load the last "n" records in the table
  15. Limit a recordset from a table by selecting a record count and a starting record
  16. Build query to limit records using dropdown menus
  17. Limit the number of records that load upon table selection
  18. 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

Download : MesaSQLite

Article Categories:
Development Tools (dev-tools)

Comments

wonderful comments!