The current version of MesaMySQL is 1.5.7
Version 1.5.7
Release Date May 13, 2008
Fix: Fixed an error when preferences were edited with no connection window open.
Version 1.5.2
Release Date January 25, 2008
Fix: Fixed the drawing code for the content listbox which could require as much as 3 seconds to render the listbox when very large strings existed in the recordset. Drawing is back down to 1/30 of a second.
Version 1.5.1
Release Date January 8, 2008
Fix: Fixed a fatal error in the Add User button that kep the window from opening.
Version 1.4.8
Release Date September 6, 2007
Add: Added reserved words button on the structure tab
Add: Added a reversion menu items for the content listbox on the content screen. These allow you to roll back data prior to the rendering of cell data changes.
Version 1.4.7
Release Date July 20, 2007
Fix: Fixed the right arrow on the add/edit user window that selected a db or a table or a column for adding privileges. It now behaves the same as a double click on the left listbox.
Version 1.4.6
Release Date July 3, 2007
Change: Enabled drag-reorder of columns in the columns selector window when limiting columns in the content screen.
Version 1.4.4
Release Date June 10, 2007
Fix: Fixed a problem in the mesamysqldump script that showed up when table sizes approached 60k records. The problem showed itself in import of the exported file. This was an important fix for me.
Version 1.4.3
Release Date June 5, 2007
Fix: Fixed an error that could come when when trying to run a special query when no prior queries are stored.
Version 1.4.2
Release Date June 4, 2007
Fix: Fixed the csv export for table content result when not including fieldnames in the export file.
Fix: Fixed the behavior of the splitter on the structure screen. It does not drag up, only down, as it was originally intended.
Version 1.4.1
Release Date May 14,2007
Fix: Improved the handling of commas in data fields when exported to and imported from a comma separated file. Commas in data were splitting a field into multiple fields.
Fix: Fixed the conjunction switch on the content screen where a new search parameter did not follow the conjunction pattern.
Fix: Fixed the editcell error where double clicking a cell in the content screen when rows were hidden would land the editcell in the wrong location.
Version 1.4.0
Release Date April 25, 2007
Change: Structure screen: Both enter and return keys now serve the same function to accept a change in the field structure listbox so that laptop users can use the return key for this function. Left and right arrow keys now can serve the function that the return key used to for toggling a checkbox in a checkbox cell.
Fix: Decimal field type was not properly accepting length and decimal parameters when adding a new field with type decimal (structure tab)
Add: Arrow up in the popuplistbox for field type in the structure tab takes you to the last row; arrow down in the last row takes you to the first row.
Add: Aggressive out of bounds error checking for the listbox drawing on the content screen.
Add: Added the ability to set the opening tab in preferences
Change: Tweaked the appearance of the column selector window for viewing limited columns in the content screen.
Change: Added 9 character positions for data returned in a special query that looks numeric but may be in fact, a string. Prior, digits were truncated to the ten-thousandths.
Version 1.3.7
Release Date March 31, 2007
Add: Activated the following functions in the special query screen: INSERT,SET,FLUSH,GRANT,DROP,ALTER,LOCK AND UNLOCK TABLES,CREATE,RENAME TABLE,LOAD DATA INFILE,TRUNCATE TABLE,EXPLAIN,DESCRIBE,HANDLER,HELP
Change: Made sure a MesaMySQL dump can be done one record at a time
Fix: fixed a bug that arose when changing a column to auto_increment after it was already in the table
Fix: Fixed the movement of the listbox corner rectangle on the content screen when search parameters are removed upon new table selection.
Fix: Handled the apostrophe in the search param field on the content screen
Fix: Fixed a bug where adding a new row in the structure screen when the cursor is still in an edit cell cause an error
Change: Allowed multiple tables to be selected for deletion on the structure screen
New: Added a splitter to the custom query screen for long queries
New: Animated the progress wheel in the content screen for long column sorts
Fix: Fixed the splitter on the special query screen from moving beyond other controls.
Change: MesaMySQL dump now dumps records in insert batches of a qty you can prescribe so that the import MesaMySQL dump speed is improved. Import speeds can been increased by 30-40x using this method.
Change: Tabbing through a record in the content screen resets the horizontal scroll position to zero when the record is exited at the end
Fix: Fixed a bug when an error occurred when shift clicking to select multiple rows after adding a row in the content screen without rendering it.
Change: Global edit now allows you to set a value to many rows in the content screen by replacing, appending to the start, or appending to the end of the data.
Fix: Corrected an error where add record in the content screen failed to add a record when there was only 1 column in the table.
Add: Added Repair All and Optimize All command
Version 1.3.3
Release Date March 1, 2007
Fix: Tweaked the bug report submission script. It now gives a dialogue box upon success.
Fix: The user is now alerted to connect to one of their databases before adding or editing a users privileges
Change: Import CSV file now presents a popup window for the table selection
Change: The parameter edit field on the content screen now selects all its contents when it gets the focus. The parameter editfield now keeps the focus when the parameter field selection is made
Change: Changed the approach to the persistent connection for apps running over the net. Mesa checks every second for a network connection and every 30 seconds for a db connection. Some internet providers, it seems, purge connections on 3306 pretty often. RCN for one.
Fix: Fixed a bug in the edit custom query favorites window opening
Change: Made it easier to view and edit long queries in the custom query favorites edit window
Fix: Handled dropped parts of long queries where there were carriage returns in the query
Version 1.3.0
Fix: Edit Favorites shows 'delete row' button which was missing and does not open a new window (unnecessarily)
Fix: Removed WinKorean encoding which caused a fatal error
Fix: Fixed the reload script when adding a record in the content screen after doing a search prior
Fix: Colored rows in the index listbox did not draw text in white
Version 1.2.9
Release Date: February 8, 2007
Fix: Text encoding popup change on content screen no longer throws error.
Fix: Summation function on content screen and special query screen now handles negative numbers properly.
Version 1.2.7
Release Date: January 11, 2007
Fix: Select all in content listbox did not properly select all rows even though they all get highlighted.
version 1.2.6
Release Date: January 7, 2007
release notes:
Feature: Reconfigured the DEMO to be full functioning without limitations
Feature: Added the ability to change the name of a table in structure tab
Feature: Add popup selection of values for an enum field when viewing and editing data in the content screen
Fix: Fixed a window modal window glitch when duplicating a table including content in the structure screen
Fix: Fixed a bug where a dump file did not include table structure if you didn't call for the content as well
Fix: Fixed a bug where the mesamysql dump script hid the windows taskbar
version 1.2.5 release notes:
Improved the handling of date, time, timestamp, and datetime default settings
fixed the dragreorder function in the structure table for timestamp fields
Changed the structure editcell alignment to "left" so columns with text alignment of "center" show the cursor when editing
Changed the column sort function from binary (case-sensitive) to lexicographic (case-insensitive)
version 1.2.3:
Release Date: December 4, 2006
Version Notes:
Optimized reading and importing of large dump files (100mb file import takes 6 minutes to read and 10 minutes to import)
Fixed Demo showing 500 rows in table when only 10 are present
Scroll content listbox when editing a column with the return key to move down a row
Enabled column resize in structure listbox
Fixed Users listboxes resize on window resize
Added Relationships Tab for storing relationships metadata
Created a custom progressbar for windows imports/exports
Created Barber Pole for custom progressbar
MesaMySQL dump window reads dumping... (table 7 out of 93)
Fixed cancel export table not releasing the progress bar
Enabled usercancelled in the export and import scripts
Allowed import into < 4.1 from an export from > 4.1 using currenttimetsamp
ImportMesasDump names the import file on the import progress window
Added insert capability to the special query screen
Now use the progress wheel when deleting records from the contentlisbox
Scrollbar max resets after deletes on the contentlistbox