614 lines
34 KiB
Text
614 lines
34 KiB
Text
|
-------------------------------
|
||
|
|
version 3.7
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
|
||
|
|
Bufixes:
|
||
|
|
- problems with php running as FCGi in nginx server
|
||
|
|
- corrupt output on some php configuration, mainly due to incompatible settings
|
||
|
|
- list of table not displayed for PostgreSQL databases when importing a single table data from csv files
|
||
|
|
- on some php configurations, database selection did not work due to cookies and request variables being merged
|
||
|
|
- insert queries generated for some Pgsql databases failed to execute due to syntax errors
|
||
|
|
- fixed data table import bug with pgsql databases, generating incorrect queries with table namespaces
|
||
|
|
- fixed sorting and pagination issues with query data (thanks to Peng Xiao for valuable feedback)
|
||
|
|
General:
|
||
|
|
- added compatibility to PHP 5.2 after user requests
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.6
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- Edit mode updates:
|
||
|
|
for enum/boolean fields, datalist is available to choose from
|
||
|
|
date fields can now be updated with datepicker
|
||
|
|
- fixed results header for better navigation and data management
|
||
|
|
- .sqlite3 is now recognized as valid sqlite database extension
|
||
|
|
- improved in-place editing visual styles
|
||
|
|
- SQLite and SQLite3 library improvements for record editing functionality
|
||
|
|
- Added SQL editor hotkeys:
|
||
|
|
Ctrl+Up -> Increase text size
|
||
|
|
Ctrl+Down -> Decrease text size
|
||
|
|
Ctrl+Shift+Del -> Clear SQL editor
|
||
|
|
- Warnings are now shown in message pane that occur during query execution
|
||
|
|
Bugfixes:
|
||
|
|
- Enum and set field values handling with special characters
|
||
|
|
General:
|
||
|
|
- Results for data queries and other types of queries are shown separately
|
||
|
|
- Cleaned up themes structure, to simply theme modification and creation
|
||
|
|
- Aero theme is removed from the package
|
||
|
|
- Reduced package size due to removal / cleanup of various javascript code
|
||
|
|
- Other lots of minor improvements in various areas of application frontend / backend
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.5
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- support for SQLite3 driver added, so database created with SQLite3 can be managed
|
||
|
|
(thanks to J. Gutierrez for providing valuable feedback in this regard)
|
||
|
|
- added Arabic translation (thanks to Muhannad Ajjan for providing the complete translation)
|
||
|
|
- filename format can be changed before creating server side backups (to add prefix or additional info to filename)
|
||
|
|
- Auto pagination now works for all select queries other than table select
|
||
|
|
- Sorting is now done on the server side instead of client side, also improves integration with pagination
|
||
|
|
- Removed .htaccess file from root of installation folder, that caused internal server error on many hosts.
|
||
|
|
All htaccess settings are now internally managed by MyWebSQL
|
||
|
|
Bug fixes:
|
||
|
|
- minor bugs in the sqlite library, causing generation of errors in log
|
||
|
|
- sql comments were erroneously appended to exported data in html/xhtml format
|
||
|
|
General:
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.4
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- Connection details for custom database servers can be provided on login screen.
|
||
|
|
This option is disabled by default. See link below for more details
|
||
|
|
http://mywebsql.net/docs/connecting-to-database-servers/user-defined-connections/
|
||
|
|
- More options in export dialog to fine tune the format of generated SQL script
|
||
|
|
- Export dialog options are enabled/disabled based on selection of export data for best results
|
||
|
|
- Database export option now available for PostgreSQL databases also (limited to table data only)
|
||
|
|
- Secure login is enabled/disable automatically based on PHP configuration
|
||
|
|
this fixes the blank screen issue on first run, reported by some users with missing PHP extensions
|
||
|
|
Bug fixes:
|
||
|
|
- Shift+space key would indent the SQL editor, causing annoyance for most users
|
||
|
|
- Server information tab displayed MySQL server label regardless of database type
|
||
|
|
- Pgsql tables showed no result even though the query successfully returned valid result set
|
||
|
|
- Pgsql users other than 'postgres' unable to login to MyWebSQL
|
||
|
|
General:
|
||
|
|
- Exported query results contain the actual SQL statement for reference purposes
|
||
|
|
- install.php script now properly identifies and displays issue in PHP installation for running MyWebSQL
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.3
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- added bulk insert statement option in export script to speed up imports and reduce output file size
|
||
|
|
- allow skipping foreign key checks while dropping tables in batch mode to ensure deletion of all selected tables
|
||
|
|
- new user options dialog to control some aspects of the gui based on user's preferences
|
||
|
|
- object list shows the (estimated) number of record count for tables (requires option to be set in preferences)
|
||
|
|
- object list allows table listing to be sorted based on last update time (requires option to be set in preferences)
|
||
|
|
- editing large text data can be done in a separate dialog (requires option to be set in preferences)
|
||
|
|
Bug fixes:
|
||
|
|
- export results record id was being reset after the selected limit in config for queries with variables
|
||
|
|
- namespace related issues fixed with right click menus in object viewer
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.2
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- database backup module added, which allows saving database backups on the server
|
||
|
|
- some additions to export database module for more control over the export script
|
||
|
|
- updated german translation provided by Nikolaus Krismer
|
||
|
|
Bug fixes:
|
||
|
|
- editable inputs did not have default context menu functionality
|
||
|
|
- problems with escape sequences in edited queries generation caused some queries to fail
|
||
|
|
- copying a record in the interface caused slight problem with editing due to textbox problems (touch events issue)
|
||
|
|
General:
|
||
|
|
-------------------------------
|
||
|
|
version 3.1
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- sql queries are saved on per-editor basis and loaded the same (previously only saved the last executed query)
|
||
|
|
- Record editing feature works on touch devices using taphold event (Requested by Karl Hemmings)
|
||
|
|
- improved and bugfixed SQL generation code. Generated SQL is more uniform across databases,
|
||
|
|
and respects each database specific escape sequences
|
||
|
|
- Access to particular modules within MyWebSQL can be now allowed or denied using config.
|
||
|
|
Please see online documentation for more details.
|
||
|
|
- Database Manager tool added to the interface to manage server databases more easily
|
||
|
|
Bug fixes:
|
||
|
|
- quick search filter was not being applied to database listing
|
||
|
|
- quick search filter input was missing from themes other than default theme (css fixed)
|
||
|
|
- empty data fields in results sometimes caused additional sql in where clause generation
|
||
|
|
- SQL comments work with '--', instead of needing an extra space like '-- '
|
||
|
|
- batch operations for objects other than tables failed to execute from batch module
|
||
|
|
- command history contained extra lines in multilines queries, and resulted in extra <br > tags in copied text
|
||
|
|
- some ui fixes in chrome and other browsers
|
||
|
|
General:
|
||
|
|
- batch module command generation now properly quotes object names
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.0.1
|
||
|
|
-------------------------------
|
||
|
|
- quick bugfix to download module that caused errors in the generated sql batch file
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.0 Final
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- added search on object list to filter a large number of objects in tree quickly
|
||
|
|
- Table search tool fixed and working on pgsql databases for basic data types
|
||
|
|
- Updated WordPress plugin to new 3.0 codebase
|
||
|
|
- Single file distribution updated to latest codebase
|
||
|
|
Bug Fixes:
|
||
|
|
- pgsql table operations fixed (drop, create copy, rename etc)
|
||
|
|
- incorrect limit clause did not work on some pgsql tables when fetching data
|
||
|
|
- batch operation dialog failed to work for pgsql databases
|
||
|
|
- clicking on table name in one schema incorrectly selects the same table name in other schema (only if same table name existed in two schemas)
|
||
|
|
- connection failure message on login screen for db server connection failure
|
||
|
|
- IE9 related beta version issues fixed
|
||
|
|
General:
|
||
|
|
- table description lists fields in their ordinal position (pgsql)
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 3.0 Beta
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- PostgreSQL partial support. Object list, queries, table data display works as usual. Other features are either
|
||
|
|
partially implemented, or planned for future versions.
|
||
|
|
- Added custom authentication support. It is much simpler now to implement your own method of authenticating users, if the need arises.
|
||
|
|
- Added install.php script. Checks for various configurations on server and notifies about any errors or warnings
|
||
|
|
that might cause MyWebSQL to not run properly.
|
||
|
|
- Single file distribution. A single file version of MyWebSQL with all features for quick deployment and use
|
||
|
|
please visit the project files section on sourceforge to download the single file distribution
|
||
|
|
- object count is displayed in object viewer for only types that have one or more objects
|
||
|
|
- some minor ui updates
|
||
|
|
Bug Fixes:
|
||
|
|
- where clause generation problems when data had NULL values and no key definitions
|
||
|
|
- properly display messages if one or more database client libraries are not installed when accessing the databases
|
||
|
|
- lots of other small issues fixed
|
||
|
|
General:
|
||
|
|
- Updated codemirror2 to latest version
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.9
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- Added new themes:
|
||
|
|
Bootstrap - based on jquery ui twitter bootstrap theme (by addy osmani)
|
||
|
|
Chocolate - based on jQuery UI theme mint-chocolate
|
||
|
|
Pinky - A colourful pink theme
|
||
|
|
- Syntax editor improvements: Codemirror2 support improved, other editor areas cleaned up
|
||
|
|
- Fixed session issue with multiple blocking requests to keep the interface responsive
|
||
|
|
Bug Fixes:
|
||
|
|
- Fixed a bug in SQL parser that caused infinite loop in parser at end of file, resulting in unresponsive interface (reported by Brandon Hoffman)
|
||
|
|
- Blob data could not be viewed if result contained field from more than one table
|
||
|
|
- Dialogs once re-opened behaved erratically on minimize/restore
|
||
|
|
- Changing table engine type erroneously generated drop primary key statement for some tables
|
||
|
|
- Record editing could not save record if the where clause contained certain text
|
||
|
|
General:
|
||
|
|
- Automatically refresh object list after successful creation of new objects
|
||
|
|
- updated language on the interface where some of the text did not translate properly
|
||
|
|
- Cleaned up themes and standardized message/error display interface
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.8
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- Added data import option from CSV files into tables
|
||
|
|
- Added batch operation module. Allows performing various operations on multiple objects in database easily
|
||
|
|
(add/remove table prefixes, drop objects, generate sql commands for selected objects etc.)
|
||
|
|
- Added quick search in information display tables for quickly filtering result data
|
||
|
|
- Improved SQLite support
|
||
|
|
- Automatically refresh object list after completing batch imports (requested by umairj)
|
||
|
|
- suppressed warning in error log on some PHP versions (requested by Danny)
|
||
|
|
- Language names appear in their own language in menus for ease of understanding
|
||
|
|
Bug Fixes:
|
||
|
|
- Lots of issues fixed in SQLite database handling
|
||
|
|
- where clause generated query error in updates if it contained text fields
|
||
|
|
- many corrections in multilingual strings in the languages
|
||
|
|
General:
|
||
|
|
- Updated jquery/codemirror2 to latest version
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.7.6
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- Updated codemirror2 to latest version and improved mysql syntax highlighting
|
||
|
|
Bug Fixes:
|
||
|
|
- More fixes to login failure / display problems with FASTCGI servers
|
||
|
|
General:
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.7.5
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- default interface language can now be set in configuration
|
||
|
|
- installation package now contains all files inside a root folder (requested by some users)
|
||
|
|
Bug Fixes:
|
||
|
|
- usability issues when authentication type was set to NONE
|
||
|
|
- usability issues with IIS+fastCGI servers
|
||
|
|
- usability issues when using some specific server configurations of php/apache
|
||
|
|
- record editing and export output problems when mysql5 driver was used instead of mysqli
|
||
|
|
- other minor bugfixes and improvements
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.7
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- added 'copy record' functionality in result grid. Select one or more records and use the copy function to quickly create new records with same data.
|
||
|
|
- added CSV(Excel) and YAML formats in table/results export module. Code for export functionality refactored to allow creation of more export drivers easily.
|
||
|
|
- Exporting large amount of data does not fail with memory limit errors by php
|
||
|
|
(still requires php timeout settings to be large enough, or unlimited so that all data can be processed)
|
||
|
|
- results editor now automatically scrolls to right position in results to keep current edited field visible
|
||
|
|
also basic field information is shown while editing the results
|
||
|
|
- improved software update check option which does not block user interface. Also update for new version is checked every Monday.
|
||
|
|
update settings can be changed by modifiyng config/updates.php file
|
||
|
|
- process manager allows more than one process to kill in one request
|
||
|
|
- added main menu interface option to select the type of sql editor at runtime
|
||
|
|
(also fixed some issues with CodeMirror2 implementation, but it is still experimental)
|
||
|
|
- Speed improvements in some areas of functionality
|
||
|
|
Bug Fixes:
|
||
|
|
- Loading and minor theme issues with Internet Explorer 8 browser
|
||
|
|
- result set scrolling issues due to recent updates to ui libraries
|
||
|
|
- result set textarea editor setting values empty in some scenarios
|
||
|
|
- some minor structure changes to table structure using table editor did not get updated
|
||
|
|
- some other small bugfixes reported by users
|
||
|
|
General:
|
||
|
|
- Default theme revised and cleaned up a bit as per user requests (minor fixes to other themes also)
|
||
|
|
- more code cleanup and configuration files
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.5
|
||
|
|
-------------------------------
|
||
|
|
Changes:
|
||
|
|
- Support for managing SQLite databases. Includes mostly used functionality like creating databases/tables and querying tables. Import/export and GUI based record editing not available (mainly due to restrictions with sqlite driver support)
|
||
|
|
- imporved server configuration settings. You can now explicitly specify the mysql driver to us with a particular connection (e.g. mysqli, mysql5 or legacy driver etc)
|
||
|
|
- Updated encryption library for PHP 5.3. Much faster login screen, but falls back to default if using older version
|
||
|
|
of PHP or missing encryption extensions (requires openssl+gmp extensions)
|
||
|
|
General:
|
||
|
|
- Updated french language translation (with special thanks to Sylvain Chauveau)
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.3
|
||
|
|
-------------------------------
|
||
|
|
Changes:
|
||
|
|
- Unobtrusive dialogs: all tools and import/export dialogs can be minimized and do not block the user interface
|
||
|
|
> Useful when creating/tables, so that more than one table can be created/edited at the same time
|
||
|
|
> Database import/export can be minimized while you can continue work on the main interface etc.
|
||
|
|
- Query editor functionalty improved. You can now change (or add) default query editor with one of your own choice (e.g. ACE editor)
|
||
|
|
Please see documentation at http://mywebsql.net/docs/miscellaneous/adding-changing-sql-editors/
|
||
|
|
- Added codemirror2 as alternate sql editor (experimental). Can be enabled in the config for testing
|
||
|
|
Bugs Fixed:
|
||
|
|
- plain text query editor hotkeys did not work properly (default syntax highlighted editor worked fine)
|
||
|
|
- plain text query editor text not returned from current editor (javascript issue)
|
||
|
|
General:
|
||
|
|
- Fixed some warnings in code
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.2
|
||
|
|
-------------------------------
|
||
|
|
Updates:
|
||
|
|
- Added option to select mysql server at login time. Please see online documentation to see configuration details
|
||
|
|
http://mywebsql.net/docs/interface-basics/connecting-to-multiple-servers/
|
||
|
|
- Added session variable options using the 'SET @...' command. Please see the basic information on using session variables at the link below
|
||
|
|
http://mywebsql.net/docs/advanced-usage/using-session-variables-in-queries/
|
||
|
|
- Added right click option to copy a table/view/procedure/view with different name
|
||
|
|
Bugs Fixed:
|
||
|
|
Table editor:
|
||
|
|
- generated erroneous query if more than one table was created using set/enum fields
|
||
|
|
- did not generate default value in sql for number fields
|
||
|
|
General:
|
||
|
|
- newly created database name showed up at the end of database list (instead at the right place)
|
||
|
|
- import failed for sql dump generated by MyWebSQL in some scenarios
|
||
|
|
- drop object confirmation asked every time despite user's preferences to not ask every time
|
||
|
|
- text field data is shown by default in grid view instead of info text, if it is less than 80 characters or less (configurable)
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.1
|
||
|
|
-------------------------------
|
||
|
|
Changes:
|
||
|
|
- User manager now allows removing the user password (previously only allowed changing passwords)
|
||
|
|
- Search tool to search for text in database with selected options
|
||
|
|
Bugs Fixed:
|
||
|
|
- Header menu did not appear properly after re-opening browser if header was hidden
|
||
|
|
- index manager sometimes failed to add index if there was initially no index in a table
|
||
|
|
- index manager script error when adding an index to a table which had no index
|
||
|
|
- index manager generated error in query for adding a primary key to table without a primary key
|
||
|
|
- utf8 text data sometimes did not properly insert/update for database with character set other than utf8
|
||
|
|
- a rare but annoying javascript error specially in ie (and sometimes in other browsers) immediately after page load
|
||
|
|
- fixed edit toolbar and text field editor positioning issues in chrome and IE 7,8
|
||
|
|
Updates:
|
||
|
|
- automatic detection of user's language based on browser settings
|
||
|
|
- Updated to latest jquery ui library
|
||
|
|
- improved loading time for the interface by delaying some of the interface initialization for later (popups etc)
|
||
|
|
|
||
|
|
------------------------------
|
||
|
|
version 2.0 Final Release
|
||
|
|
-------------------------------
|
||
|
|
Changes:
|
||
|
|
- Index manager button text changed to be more easier to understand
|
||
|
|
- Table editor buttons display and hide properly based on selected tab
|
||
|
|
- Language files added for various languages (Google translated for the time being)
|
||
|
|
- Some IE related javascript issues fixed by including json2 script for IE7 browsers
|
||
|
|
Bugs Fixed:
|
||
|
|
- user manager privileges not flushed on some actions
|
||
|
|
- Loading screen for imcompatible browsers fixed
|
||
|
|
- session expiry now handled properly and message is displayed to user for reloading the page
|
||
|
|
- creation of new table did not refresh the object list automatically
|
||
|
|
- when text field editor closes, it leaves incorrect information about the field in table cell
|
||
|
|
- text field editor placement was out of screen on some scenarios
|
||
|
|
- table editor incorrectly accepts field length for types that do not require length
|
||
|
|
also fixed field length option for all field types
|
||
|
|
- table editor did not properly update primary key index in some cases
|
||
|
|
- table editor added extra command in alter statement for table engine type and character set
|
||
|
|
- table describe command did not show all text in the results (field type was obscured)
|
||
|
|
- blob edit dialog did not report error when blob editing failed (due to file upload error)
|
||
|
|
- Humanity, paper, aero theme styles updated
|
||
|
|
- quick start tutorials and related script issues fixed
|
||
|
|
- update langauge files and missing text in modules for translation
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 2.0 Beta
|
||
|
|
-------------------------------
|
||
|
|
- new: Interface is now completely multilingual. All modules updated to separate code and content
|
||
|
|
- new: Tool to manage table indexes
|
||
|
|
- new: Tool to manager database users and privileges (with special thanks to Ovais Tariq)
|
||
|
|
- new: Tool to analyze and/or repair database tables
|
||
|
|
- new: application and rightclick menu items contain icons for better visual cue
|
||
|
|
- new: text field inplace editing mechanism is now improved and simplified
|
||
|
|
- new: blob field inplace editing mechanism is now implemented for file uploads in blob fields
|
||
|
|
- new: 3 new themes (including an 'Aero' style transparent theme)
|
||
|
|
- new: brand new splash and login screen
|
||
|
|
- new: module to quick check for updates from the interface for new versions of software from website
|
||
|
|
- update: session security enhanced further by encrypting more insecure session variables
|
||
|
|
- update: export modules now includes mysql events to be exported
|
||
|
|
- update: history now allows copying a single selected query as well as all queries to clipboard by right click menu
|
||
|
|
- update: slightly improved syntax highlighting for sql editor
|
||
|
|
- update: changing database does not refresh the whole page, only object list
|
||
|
|
saves extra loading time and preserves other page elements (queries etc)
|
||
|
|
- update: resizing handles are larger when the panel is docked, to allow easier to be used (feedback from jquery layout group)
|
||
|
|
- update: Html class functions made static. object instantiation is not required anymore
|
||
|
|
- lots of other minor tweaks and improvements
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.8
|
||
|
|
-------------------------------
|
||
|
|
- added: functionality to manage mysql5 'event' objects
|
||
|
|
- added etags in scripts and css to save bandwidth and improve browser caching
|
||
|
|
- added: encryption based security in login screen to disable plain text login information sent over the wire.
|
||
|
|
enabled automatically if MyWebSql is not hosted on https url
|
||
|
|
- added: new interface icons for object viewer
|
||
|
|
- update: object tree list saves it expanded/collapsed state after refresh on query execution
|
||
|
|
- update: existings themes/styles brushed up and cleaned and all css formatted properly (dark theme look revised)
|
||
|
|
- update: page header and logo can now be make to hide to provide additional space in the browser for results and sql editor
|
||
|
|
(right click header area to show context menu)
|
||
|
|
- update: page and docking window layout is now saved and restored on next visit
|
||
|
|
- updated links in menu to new bugs and feature requests pages on mywebsql.net site
|
||
|
|
- updated to latest jquery and ui libraries
|
||
|
|
- other minor updates/fixes
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.7
|
||
|
|
-------------------------------
|
||
|
|
- update: mysql4 support revised. Objects/elements not supported in mysql4 do not appear in the interface
|
||
|
|
- update: Internet Explorer 9 related compatibility issues fixed
|
||
|
|
- added: record editing allows adding new records in wysiwyg mode, while allowing editing of existing ones
|
||
|
|
- added: change engine type module for quickly changing the table type only without changing structure
|
||
|
|
- update: object list now refreshes automatically when database is modified
|
||
|
|
- bugfix: history right click menu copy command was not working properly
|
||
|
|
- update: more commands available for tables and other db objects through right click menus
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.6
|
||
|
|
-------------------------------
|
||
|
|
- added: WYSIWYG table creator/editor.
|
||
|
|
- added: right click menu for databases in object tree
|
||
|
|
- added: right click menus for panels, and main menu options to access the same commands
|
||
|
|
- added: more operations supported for database object through right click menus (alter, drop, rename, truncate)
|
||
|
|
- bugfix: minor display issue with first loading when authentication type was set to NONE
|
||
|
|
- bugfix: record editing shortcut keys improper behaviour after sorting results
|
||
|
|
- fix: resizing popup dialogs was causing erratic mouse behavoiur and improperly resizing popups
|
||
|
|
- update: quick start tutorials added to help menu for new users
|
||
|
|
- update: popup screens now use theme based styles instead of default html stlying
|
||
|
|
- update: source code cleaned up and formatted through out the application in uniform style
|
||
|
|
- other minor improvements and fixes
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.5.1
|
||
|
|
-------------------------------
|
||
|
|
- bugfix: export command failing to download database dump
|
||
|
|
- bugfix: import command failing due to foreign key check for data exported through MyWebSql interface
|
||
|
|
- bugfix: blob dialog did not display binary blob column value in some situations
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.5 Final
|
||
|
|
-------------------------------
|
||
|
|
- converted icons and small images to sprites
|
||
|
|
- fixed codemirror errors for dialogs when compressed javascripts were used
|
||
|
|
- bugfix: NULL values were not being sorted if a column contained mix values
|
||
|
|
- bugfix: where clause generated for some specialized field names caused error in query
|
||
|
|
- bugfix: changing themes sometimes caused javascript warning shown before reloading the page
|
||
|
|
- bufix: incoplete database object list shown if there was only one database on server
|
||
|
|
- update: result display slightly mproved when it contains binary data
|
||
|
|
- added: Generate sql option in the interface during record editing. Generates sql for user actions instead of
|
||
|
|
directly executing queries
|
||
|
|
- update: existing themes made compatible with new code
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.5 Beta
|
||
|
|
-------------------------------
|
||
|
|
- added: 2 more sql editors, each of the three editors now accessible through hotkeys
|
||
|
|
- bugfix: sql output for certain timestamp fields generated incorrectly during export
|
||
|
|
- bugfix: minor issue when last query is not select and results are exported
|
||
|
|
- added: syntax highlighting for all queries displayed on the interface
|
||
|
|
- added: logout option in the interface (required and requested)
|
||
|
|
- added: default information displayed for tables and other db objects when left-clicked
|
||
|
|
- update: line numbers enabled for sql editor
|
||
|
|
- update:detailed online documentation now up and running. Quick help contents bundled with the package
|
||
|
|
- update: edit/delete queries now execute directly instead of being generated inside sql editor (requested)
|
||
|
|
- update main menu re-organized for ease of use and more options added
|
||
|
|
- update: sql editor now improved than earlier versions with better syntax highlighting
|
||
|
|
- optimizations: removed unused code files from project, and configuration files re-organized slightly
|
||
|
|
- added minified versions of scripts for speeding up page loading and client side performance
|
||
|
|
- lots of other minor improvements and fixes
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.4
|
||
|
|
-------------------------------
|
||
|
|
- added: two more themes for the interface (light (grayish and simple) and dark (a bit colourful but darkish theme))
|
||
|
|
- added: hotkeys for query/query all execution (customizable through editing key config file, see help for details)
|
||
|
|
- added: pagination support to results when viewing table data (requested by Richard Bondi)
|
||
|
|
- update: when a ddl is executed, additional link allows the page to be refreshed so that database
|
||
|
|
objects list is updated to reflect the changes
|
||
|
|
- update: confirmation dialogs allow remembering the choice on first confirmation and can be turned on/off from options
|
||
|
|
- update: help content updated to reflect new changes to the application
|
||
|
|
- interface changes: default interface theme cleaned up a bit to be more spacious to allow room for sql editor and results
|
||
|
|
- interface changes: record statusbar moved below results, saving some space for the overall application layout
|
||
|
|
- code changes: refactored session and preferences related code for better management
|
||
|
|
- code changes: added encryption to sensitive values in session data, to increase security on shared servers
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.3.5
|
||
|
|
-------------------------------
|
||
|
|
- bugfix: export table did not add fieldnames to the insert query if the option was checked
|
||
|
|
- bugfix: blob display dialog did not work when the blob type was changed
|
||
|
|
- bugfix: character encoding was not properly displayed in result set (special thanks to Richard Bondi for his feedback)
|
||
|
|
- update: Enhanced record editing now works in all browsers (quick fix suggested by Ovais Tariq [http://tech.ovaistariq.net])
|
||
|
|
- update: blob/text column display in result set improved
|
||
|
|
- update: fixed extra request being sent to server in some cases and caused delay in popup dialogs
|
||
|
|
- added 'Request a feature' button to the main toolbar
|
||
|
|
|
||
|
|
-------------------------------
|
||
|
|
version 1.3
|
||
|
|
-------------------------------
|
||
|
|
- improved import batch query module:
|
||
|
|
Now works with bzip and gzip files also along with plain text files
|
||
|
|
Allows continuing execution in case a query fails
|
||
|
|
Logs more information to the user before and after import
|
||
|
|
- improved export module:
|
||
|
|
Allows exporting either database structure,data or both, a single table or the current result set
|
||
|
|
Allows better selection of objects to be exported (including views, procedures, functions and triggers)
|
||
|
|
Properly creates insert command for all types of fields (bug fixed with numeric values)
|
||
|
|
Exports table/results data as insert statement, xml, xhtml or plaintext (csv format)
|
||
|
|
- user interface: popup dialog user interface, resizer bars display improved, minor font adjustments
|
||
|
|
- user interface: database object creation now also works in richedit mode
|
||
|
|
- user interface: In Firefox, record editing now supports Tab/Shift+Tab/Up/Down Keys to navigate between result fields
|
||
|
|
- update: help content and pages revised and updated help page to reflect changes in latest versions
|
||
|
|
- bugfix: import and export modules submit buttons were broken due to javascript errors on some browsers
|
||
|
|
- bugfix: unique keys in tables were not properly used while creating edit queries
|
||
|
|
- bugfix: fixed minor compatibility issues with Internet Explorer 8
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 1.2 final
|
||
|
|
-------------------------
|
||
|
|
- fix: editing keys were not properly handled on some browsers
|
||
|
|
- fix favicon missing on splash page
|
||
|
|
- update: object tree fonts and padding fixed
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 1.2 beta
|
||
|
|
-------------------------
|
||
|
|
- new: added multiple authentication types to setup MyWebSql for multiple databases or users on one server easily
|
||
|
|
please read the documentation on how to update previous version here (http://mywebsql.net/upgrading)
|
||
|
|
- new: last executed query reloads in sql editor after page reload
|
||
|
|
- new: sql editor can now be set to autohide like object tree
|
||
|
|
- update: codemirror updated to version 0.8
|
||
|
|
- update: jquery layout updated to latest version
|
||
|
|
- fix: if update/delete query contained a few special characters, the output would be wrong
|
||
|
|
- fix: table highlight would not work when doing queries
|
||
|
|
- fix: sql editor resizing caused wrong text selection in chrome and caused problem in resizing in other browsers
|
||
|
|
- fix: tables with 'spaces' in their names would not be selectable in the tree
|
||
|
|
- code cleanup: code execution framework simplified. all additional modules can now reside in one folder
|
||
|
|
- code cleanup: Removed all php warnings and notices from code
|
||
|
|
- code cleanup: moved all javascripts to one folder (including codemirror). Improved checks in cache.php to maximize
|
||
|
|
security with user provided script and css paths
|
||
|
|
- code cleanup: Most of the code is now xhtml 1.0 compliant
|
||
|
|
- lots of other minor improvements
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 1.0.2
|
||
|
|
-------------------------
|
||
|
|
- fixed bug in record editing, if < or > was used in the edited field
|
||
|
|
- Updated codemirror editor, fixes IE8 cursor hopping and firefox issues with cut/paste
|
||
|
|
- updated some javascript code to improve post query browser update speed
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 1.0.1
|
||
|
|
-------------------------
|
||
|
|
- fixed compatibility problems with php 5.3.0 and above
|
||
|
|
- fixed problem with edit field in resultset causing html code to be overwritten
|
||
|
|
- updated jquery to latest version. Should be a performance boost on in user interface on all browsers
|
||
|
|
- fixed minor user interface issues with Chrome browser
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 1.0
|
||
|
|
-------------------------
|
||
|
|
- added support for mysql4 databases (thanks to Ally Shayan for the work and testing)
|
||
|
|
- fixed problem with edit field in resultset in beta code
|
||
|
|
- fixed session expiration code to properly inform if session gets expired
|
||
|
|
- added right click options in history tab for copying/clearing command history
|
||
|
|
- added menu item to create new database
|
||
|
|
- added primary key/unique key icons to results
|
||
|
|
- help contents cleaned up a bit, credits section updated
|
||
|
|
- cleaned up commented out code which was left for reference
|
||
|
|
- minor fixes to GUI and css
|
||
|
|
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 1.0-Beta
|
||
|
|
-------------------------
|
||
|
|
- export results now also viewable along with download option
|
||
|
|
- redesign of the whole interface in jquery, for cross browser compatibility
|
||
|
|
- minor fixes and changes to the interafce in the redesign
|
||
|
|
- updated codemirror to version 0.61 - most probably fixes the copy paste bug in sql editor
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 0.5
|
||
|
|
-------------------------
|
||
|
|
- added support for database triggers
|
||
|
|
- added new tool: process manager for viewing and killing processes
|
||
|
|
- added new option: view mysql server variables
|
||
|
|
- added new export type: plain text (CSV style)
|
||
|
|
- bugfixes in export result functionality
|
||
|
|
- better handling of NULL values in interface and queries
|
||
|
|
- application now uses mysqli extension when available. This can be turned off/on from configuration file.
|
||
|
|
- more status information available about the mysql connection
|
||
|
|
- more browser compatibility fixes
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 0.4
|
||
|
|
-------------------------
|
||
|
|
- More browser compatibility fixes in drag drop, resizing page elements etc
|
||
|
|
- Some UI enhancements (eyecandy)
|
||
|
|
- Fixed javascript source path in export screens, causing exports to fail
|
||
|
|
- Query results performance is increased by 30-40%, by eliminating some redundant and extra DHTML stuff
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 0.3
|
||
|
|
-------------------------
|
||
|
|
- fixed query editor getSqlCode() bug in firefox (came up in ver 0.2 only)
|
||
|
|
- fixed object tree: 1. menu going out of display bounds. 2. menu not hiding on clicks
|
||
|
|
- record editing, deletion now works properly on firefox and opera also ! (checked in firefox 3.0.5)
|
||
|
|
- fixed a bug in determining if a resultset contained NULL values or empty field
|
||
|
|
- added more options for database export command (include create table/drop table, select tables to export)
|
||
|
|
- other miscellaneous cross browser issues
|
||
|
|
- running batch queries using interface is now possible (multiple results display still NOT supported)
|
||
|
|
- code folder cleaned up. Moved images,css and library files to separate folders.
|
||
|
|
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 0.2
|
||
|
|
-------------------------
|
||
|
|
- Added options to import/export results and database/tables as sql batch scripts
|
||
|
|
- added config item: TRACE_FILEPATH. Use it if you like to change the error log path for the application
|
||
|
|
- db connection is no longer limited to a single table in the database
|
||
|
|
- cookies are now specific to url for mywebsql and no longer accessible on other parts of domain
|
||
|
|
- pressing tab in the sql editor now moves focus to query button
|
||
|
|
- connection oriented configuration bugs fixed
|
||
|
|
- sql editor is now resizable on IE
|
||
|
|
- minor annoying bugfixes on the UI
|
||
|
|
|
||
|
|
|
||
|
|
-------------------------
|
||
|
|
version 0.1
|
||
|
|
-------------------------
|
||
|
|
- First public release.
|