Softpedia >Mac >Business >MesaSQLite >  Changelog

MesaSQLite Changelog

What's new in MesaSQLite 4.2.3

Apr 22, 2014
  • Fix: Fixes an error in the content screen where Mesa would fail to duplicate a record in a table that had multiple primary keys and the first field in the table was an integer field.

New in MesaSQLite 4.0.8 (Jun 26, 2013)

  • Fix: Fixes an error in the horizontal scrolling of the content screen.

New in MesaSQLite 3.3.5 (Nov 3, 2012)

  • Fix: Fixed a bug that crashed the app when running a special query on the special query screen when there was no prior query history loaded from preferences.

New in MesaSQLite 3.2.6 (Jan 30, 2012)

  • Change: Implemented a far superior CSV parser for importing records from comma delimited files.
  • Fix: Fixed an error where using the delete key to delete records in the content screen would falsely raise an error message that the records were not deleted even though they were.

New in MesaSQLite 3.2.3 (Jan 14, 2012)

  • Add: Added horizontal scroll wheel functionality in the content screen listbox.
  • Add: Added sql .dump fuction to the File menu.
  • Add: Added the ORDER BY function for content screen searches.
  • Add: Added a button press indicator when clicking the header of a column in the content screen in order to sort by it.
  • Add: Added a percent progress indicator to the progresswheel for rows being returned on larger searches.
  • Change: Changed the appearance of the NUL character on the content screen.
  • Fix: Rows returned was not always returning a value on the content screen searches.

New in MesaSQLite 3.2.1 (Dec 29, 2011)

  • Fix: Fixes an error that allowed records to be deleted from a table in the content screen even when the action was cancelled.

New in MesaSQLite 3.1.4 (May 16, 2011)

  • Change: Changes the edit view protocol when a cell is double clicked in the content screen.

New in MesaSQLite 3.0.9 (Feb 19, 2011)

  • Fix: Fixes an error in the export script.
  • The export button confirming whether to include field names and whether to escape special characters was inactive.

New in MesaSQLite 3.0.8 (Feb 18, 2011)

  • Fix: Fixes a drawing error in the content screen when Mesa opens to the content screen and the database has views.
  • Fix: Fixes an error change field definition script (ALTER TABLE) and in the renaming of a table where an autocommit database action would show an error on commit even though there was no error.

New in MesaSQLite 3.0.7 (Feb 10, 2011)

  • Change: Changes the location of your preferences file. It is now stored in Home:Library:Application Support:com.desertsandsoftware.mesasqlite
  • New: Clicking on the Dock Icon when no windows exist will open a new window.
  • Fix: Fixes an error in the reorder columns in a table by drag-reordering columns in the GUI when running Mesa in AutoCommit mode.

New in MesaSQLite 3.0.6 (Feb 10, 2011)

  • Change: Added a checkbox in the content screen for retrieving a limited number of rows. You can now include the search parameters in the limited result or leave them out.
  • Change: Changed the appearance theme of the scrollbars.
  • Change: The clipboard button on the content screen now has a dual function. If cells are highlighted by clicking and dragging, the clipboard button copies them to the clipboard as tab-delmited data. If not cell are selected, the clipboard button copies the current query to the clipboard.

New in MesaSQLite 3.0.4 (Feb 1, 2011)

  • Fix: Fixes an error in the structure tab that occurred when selecting the TIMESTAMP data type for a new column in the table.
  • New: Adds a helptag to the database selection popup in the toolbar to show the full file path to the database file when not connected over a server.
  • New: Implements Explicit Transactions allowing you to run Mesa with autocommit turned off.
  • New: Added tabs to the custom query screen to allow work on multiple queries at the same time.
  • New: Navigation key strokes have been added in the Content listbox. Up arrow moves your record selection up one record. Down arrow moves it down one record. Option Up Arrow moves it to the first record. Option Down Arrow to the last record.
  • New: Adds a single record viewer / editor.
  • New: Content Listbox attributes: textfont, textsize, row height are now preference settings.
  • New: Implements an environment for building triggers.

New in MesaSQLite 2.2.2 (Nov 2, 2009)

  • Fix: Fixes an error in the content screen when you edit a cell from one record then click on another record. The editcell highlight would show even thought the editcell was closed.
  • Fix: Fixes a couple errord in the drop REALBasic database creation code menuitem.

New in MesaSQLite 2.2.0 (Oct 14, 2009)

  • Fix: Fixes an error in the content screen when you: copy or cut a cell from one record, paste it into another record, click back on the original record, then delete that record. Two records could be deleted in that sequence.

New in MesaSQLite 2.0.8 (May 8, 2009)

  • Fix: Fixes a mistake in the Limit portion of the query when limiting rows but not loading most recent records
  • Fix: Fixes an error where the Load Most Recent Rows preference setting was not retained in the preferences window.
  • Fix: Fixes an error on the delete record button of the content screen when used after rendering a new row with the return or enter keys and not selecting a row to delete.

New in MesaSQLite 2.0.7 (May 7, 2009)

  • Fix: Fixes a bug that wrote the reloaded data for an edited record on top of another record. It did not actually overwrite the data, but showed it as a duplicate record in the interface.

New in MesaSQLite 2.0.6 (May 5, 2009)

  • New: Adds a Load Last REcords preference for content screen when limiting rows returns from the table.
  • Fix: Structure Screen: Checking AUTOINCREMENT without checking PRIMARY KEY would throw an error and prevent the alter table command from succeeding. The PRIMARY KEY syntax is now inferred.

New in MesaSQLite 2.0.4 (Mar 30, 2009)

  • Fix: fixes an error on a reload created in 2.0.3.

New in MesaSQLite 2.0.3 (Mar 27, 2009)

  • Change: An edit to a record in the content screen now only reloads the record and not the whole table.
  • Fix: Fixed a nuisance but where the mouse down event in a popup selection fell thru to the window and rendered a row prematurely in the structure tab.

New in MesaSQLite 2.0.2 (Mar 18, 2009)

  • Fix: Fixed a bug in the data viewer window when double clicking on a data cell. The window was not correctly showing data after it had shown a nul character prior.
  • Fix: Now catch unsupportedformat exception for shell paths associated with recent items. Some users have reported a fatal error when shell paths fail to be evaluated.
  • New: Added an undo function to the custom query text box.
  • New: Dragging a column header to make the column wider causes the window width to grow if you drag to the edge of the listbox.
  • Fix: Cleaned up wrapped text from the last row in the content listbox.
  • Change: Changed the protocol under which the rowid is presented in the table data in the content tab.
  • Fix: Fixed an error where numeric columns were not being right justified.
  • Fix: Fixed a drag reorder issue in the structure screen where fields were being dragged inadvertently. Fix: Corrected an issue where commas were being removed from data in tab and semicolon-seperated import files.

New in MesaSQLite 2.0.0 (Mar 11, 2009)

  • Fix: Changing the name of a table now accepts special characters in the name including spaces.
  • Fix: Found a missing COMMIT TRANSACTION statement in the 'changefielddef' function for changing the attributes of a column in the structure tab.
  • Add: Added the ability to change the delimiter for a text file on the Import CSV function.
  • Add: Added the query time and display time for queries.
  • Add: Allow semicolon to be used as a field delimiter in import files.
  • Change: Set the drawing protocol for text in the content listbox to use the "compressed" algorithm.
  • Change: Rewrote the table structure listbox as a proprietary canvas listbox due to some misbehavior in painting selected cells.
  • Add: Added keyboard shortcut for adding a column in the structure tab.
  • New: Column structure for a table can be done entirely with the keyboard.
  • New: Animated buttons to show the mousedown event.
  • Fix: Added code to deal with table structure changes such as happens in the background when columns are reordered in the table structure. New code deals with recovering the original table when the table change fails.
  • New: Enabled the reversion row in the columns table of the structure screen.
  • Change: Null values in recordsets are now shown with the null symbol, not with the word "null".
  • Add: Added the ability to specify the record delimiter when importing a text file full of records. Added the semicolon.
  • New: Added query time and display time to query environments.
  • New: Colorized a row in edit in the content screen and the column table on the structure screen.

New in MesaSQLite 1.9.9 (Mar 6, 2009)

  • Fix: Fix: Improved the handling of Tables, Columns, Indexes using reserved words and special characters including spaces in their names.
  • New: Added the ability to run a series of commands in the special query window by separating them with semicolons.
  • New: Refresh views button is added.
  • Change: Use inline editing for column types Blob and Text when the the data in the cell is not as wide as the cell (content screen).

New in MesaSQLite 1.9.8 (Feb 26, 2009)

  • Change: Threads are rewritten using a cooperative model.
  • Fix: Clicking the requery button on the lower left of the content screen when no sitting "last query"exists no longer throws an error.
  • Fix: Dropping a field or reordering fields in the structure screen is now tolerant of tables containing fields with no descriptions in their Create table syntax.

New in MesaSQLite 1.9.7 (Feb 23, 2009)

  • Change: This version temporarily invokes a limit on the toolbar, forcing the app to run in Autocomplete mode until I get explicit transactions 100% solid.
  • New: You can now set the text size in the custom query text field in preferences.
  • Change: Mesa now clears the content screen whenever you make a structure change to your database. Thus eliminating errors on data edits in the content screen.
  • Change: Menu item "File -> New Database" now opens a new window instead of populating the current front window.

New in MesaSQLite 1.9.5 (Feb 19, 2009)

  • Fix: All preemptimve threads have been rewritten. Some Leopard users were experiencing crashes.
  • New: Mesa now will create and properly display table structures with multiple primary keys.
  • Change: Many minor User Interface improvements.

New in MesaSQLite 1.9.0 (Feb 2, 2009)

  • Fix: Return key and Enter key now render a new column on the structure tab when adding a column to a table.
  • An error occured when creating a new row then reordering it even when the return key or enter key is hit after the row is created.

New in MesaSQLite 1.8.9 (Jan 29, 2009)

  • Fix: Return key and Enter key now render a new column on the structure tab when adding a column to a table.
  • An error occured when creating a new row then reordering it even when the return key or enter key is hit after the row is created.

New in MesaSQLite 1.8.3 (Nov 10, 2008)

  • Change: Made the sql areas on the VIEWS tab and Custom Query tab larger.
  • Add: Added text sizing capability on the sql areas on the VIEWS tab and custom query tab.
  • Add: Added a Window menu.
  • Change: Changed the window titles by removing the prefix "Database:" to simplify the appearance of the new Window menu.
  • Change: Returned recordsets now show null values as "null"

New in MesaSQLite 1.8.1 (Nov 4, 2008)

  • New: Adds a VIEWS screen for create, drop, duplicate VIEW.
  • New: Adds a Save as View button to the Table content Screen.
  • New: Added styled text in SQL text environments.

New in MesaSQLite 1.7.8 (Nov 3, 2008)

  • Fix: Improves the stability of the structure screen when adding columns to tables. Prevents combinations of attributes that will fail.
  • Add: Adds a function to change the capitalization of a table name. For example changing master to Master. This is not permitted by SQLite but is now permitted by Mesa.
  • Fix: Add column button is now disabled until a current add column function is completed so clicking to add multiple columns in a row is now safer.

New in MesaSQLite 1.7.7 (Nov 3, 2008)

  • Fix: Fixes an error in the add column function on the structure tab where time and date fields were being given the autoincrement attribute and this was corrupting the table.

New in MesaSQLite 1.7.6 (Oct 14, 2008)

  • Note: This version should be run in autocommit mode. Explicit instructions need some work.
  • This version improves the Drop Create Database Code for REALBasic users.
  • When building an app that runs on a local db, rather than ship the db, I build the db in Mesa, drop the Create Database Code and paste it into the app which checks for the presence of the database locally each time it launches.
  • If the db is not present, the create db code runs and we have the database file locally.

New in MesaSQLite 1.7.4 (Oct 6, 2008)

  • Note: This version should be run in autocommit mode. Explicit instructions need some work.
  • Change: Tables for a database are now loaded in alpha order every time.