You can skip this in seconds

Click here to continue

Download Now!

MesaSQLite 3.1.6

MesaSQLite 3.1.6

Download Now!

This download will be managed by our ad-supported smart download manager. Learn more

Screenshots of MesaSQLite

MesaSQLite Publisher's Description

We built MesaSQLite for ourselves. 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

    Relationships

  • Store metadata about your relationships in a relationships table
  • Create, view, and edit your relationship metadata easily

    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
  • Look for Similar Items by Category

    Development Tools > Databases & Networks
    This product is also listed in: Editors, Applications

    Feedback


    This download is managed by our ad-supported smart download manager. During the download process we may show commercial offers, such as a toolbar or other browser add-ons. The download manager is in no way affiliated or endorsed by the author of this product. Enable Search Protect to set my home page and default search to Trovi Search powered by Bing® for Safari®, Firefox®, and Chrome™, and prevent third parties from changing my browsers’ home page and search settings. The product can be downloaded as well freely from the author's website. Learn more

    Popular Downloads