DbNinja Changelog

Version 3.2.7 (2017-02-17)

New Features

  • Better compatibility with MariaDB

Bug Fixes

  • DATETIME columns support CURRENT_TIMESTAMP
  • Fix issues with incorrect arguments parsing in stored functions
  • Fix error definer related errors in procedure/view/event/trigger

Version 3.2.6 (2014-05-04) - Recommended upgrade

New Features

  • Added row numbering in query result
  • Allow to export query data prior to running the query
  • Added show/hide query log button to top menu

Bug Fixes

  • Stored procedures with enum arguments do not parse correctly
  • Table data import problems with files containing over a few tens of thousand records
  • Export to Script and Export Data sometimes failing if PHP has no multibyte extension installed
  • More informative error messages

Version 3.2.5 (2013-12-23)

New Features

  • View database object details: amount of rows in tables, table size, etc

Bug Fixes

  • Paging issues in multi result with multiple pages
  • Execution errors in scripts with certain stored routines
  • Bottom scrollbar in query editor not working after opening query log

Version 3.2.4 (2013-10-17)

Bug Fixes

  • Views with UNION don't show correctly in the editor
  • Execution of a script that's larger than 'max_allowed_packet' doesn't produce an error message
  • Request time out setting not affecting execution of scripts

Version 3.2.3 (2013-09-13)

New Features

  • Ability to set data values to SHA and MD5 from context menu

Bug Fixes

  • MySQL connectivity related errors not displayed when running queries
  • Unnecessarily displaying browser extension related exceptions

Version 3.2.2 (2013-09-01)

New Features

  • Added table dependencies viewer
  • Added ability to temporarily disable foreign keys when updating table's structure
  • Added ability to follow URLs contained in table data
  • Improved SQL script execution technique to ensure large scripts don't time out
  • Improved SQL formatting in Views
  • Ability to select how INSERTs will be performed when exporting a database to script
  • Automatic refresh of object browser after running a script

Bug Fixes

  • AUTO_INCREMENT value not showing correctly in table editor
  • Certain stored routines failing to open in editor
  • Script execution failing on certain files
  • Procedures with no parameters fail to open in editor
  • Query autorefresh "stop" button is unclickable in long running queries

Version 3.2.1 - Minor release (2013-06-20)

Bug fixes

  • Regression bug: "Export to Script" not exporting data correctly

Version 3.2.0 - Major release. Important to upgrade! (2013-06-18)

New Features / Bug fixes

  • Improved paging of query results with ability to jump to a certain page
  • Ability to specify the maximum query result size in MBs and limit the number of fetched records
  • Table data editor now supports sorting and multi-column filtering
  • Data editor tab is now available in View editor window
  • Many bug fixes and other improvements

Version 3.1.2 (2013-02-05)

Bug Fixes

  • Data export functionality not working
  • Popup windows not closing with the X button

Version 3.1.1 (2013-01-29)

New Features

  • Tabs can now be reordered by dragging
  • Duplicating a table now allows copying data in addition to structure (see Duplicate table dialog)
  • DbNinja is now capable of sending keep-alive packets to your host (can be turned on in Settings)
  • Choose if double clicking on a table should open schema or data editor (configurable in Settings)
  • Query log is now available and accessible through the top menu
  • Ability to remove multiple objects without the need to confirm every operation (see Drop Multiple Objects in database context menu)

Bug Fixes

  • Fixed numerous interface and connectivity related issues

Version 3.1.0 - Major release (2012-12-16)

New Features

  • New tool for comparing and synchronizing databases between servers.
  • Ability to export query results and table data into files. Supported formats: Text, Excel, SQL, JSON and PHP.
  • Ability to import data from text files

Other Improvements

  • Ability to choose the default action for double-clicking cells with binary data in query results
  • Allow connecting hosts with an "empty" password
  • Added the ability to sort data by certain column in query results
  • Ability to rename tab titles (use right click)
  • Better handling of copy-to-clipboard
  • Added ability to select the default database when executing script files
  • Other significant GUI improvements

Bug Fixes

  • File upload doesn't work when Flash player is not available
  • Resized data-grid columns return to default width when data is refreshed
  • Temporary files not getting cleaned up on exit
  • Removed forced limit of 1000 rows per query result
  • Other small issues

Version 3.0.6 (2012-09-10)

New Features

  • Index type is now displayed on columns of query results
  • Using Shift+DblClick in the tree on a table opens data editor

Bug Fixes

  • Numeric stepper doesn't like Float, Double and Decimal columns
  • Issues when setting a new password
  • Clicking refresh in the tree on a group of tables, procs, etc. does nothing

Version 3.0.5 (2012-09-05)

New Features

  • Export users and grants into SQL script
  • Launch queries repeatedly with a given delay
  • Preview binary data as Hex or Text

Bug Fixes

  • Amount of selected/affected rows in query editor reported incorrectly
  • Issues when updating data fetched from a View
  • Loosing connectivity after long running queries
  • Saving settings sometimes removes all favourite queries
  • Internet Explorer shows "Leave this page?" dialog when downloading a file
  • Minor user interface related issues

Version 3.0.4 (2012-08-05)

Bug Fixes

  • No indentation in stored routines after script execution
  • File upload does not work if Flash player is not installed or too old
  • Up/down keys not working in lists (datatype selector, etc)
  • View editor missing the 'NONE' option in CHECK OPTION field