deltasql full changelog

This release eases life for users who do lot of searches among scripts. When users do search, the query is stored and listed. Users can click on the lists 'Last 10 Searches', 'Top 10 Searches'. They can flag a query as favorite, if they think they will use it more often. Queries are automatically named with the criteria used but users can rename the search query at their wish. People who use deltasql as script collection tool, or to store a log of all queries they run in a day will find this feature very useful.

This is a release to get deltasql working with PHP 5.6, PHP 7.0, MariaDB and mySQL. It is also backward compatible to PHP 5.4 and PHP 5.3. The support for PHP 7.0 is experimental (the feature to diff changes on a single script is missing at the moment, the rest should work).

This is a maintenance release with following patches and features
New features:
Visibility for projects: useful in large deltasql installations with many users and old unused projects

This is a maintenance release with following patches and features - Visibility for modules: useful in large deltasql installations with many users and old unused projects - Disabling automatic comments on generated synchronization script at project level: useful when deltasql is used in conjunction with other synchronization tools (e.g. like Microsoft SQL Schema compare) - Other minor fixes in tool, GUI, documentation and XML-Export.

verification script for Microsoft SQL server did not work properly
ability to search among projects
ability to rename a project

Deltasql now officially supports Microsoft SQL server:
Information on database type is saved on the project, it is not necessary to give this information each time a synchronization is performed.
Deltaclient recompiled without database type field
Revised script creation for Microsoft SQL server
USE clause for Microsoft SQL server can be specified on the project
deltasql is installed by default with the test data set, to simplify the learning process

Deltasql can be exposed to the Internet via HTTPS, other minor fixes
$keep_private option in config.inc.php asks all users to be authenticated before showing any content
added FAQ on how to publish deltasql via HTTPS
fixed issue with "Give latest version number to edited script"
added missing session starts on several pages

Added automatic branch selection when creating synchronization table.
Fixes to the branch selection in the main synchronization form.
Same fixes applied also to deltaclient for Windows
The dbredactor client includes now a JDBC driver for sqlite databases.
Favicon and other visual enhancements

Major features:
· New toolbox page listing tools which help in script creation

· The first two tools support creation of INSERT scripts, and of INSERT, UPDATE, DELETE scripts based on .csv exported from your SQL client.

· This in case your SQL client does not have an SQL export feature, or if you want to record configurations changes on big applications mantained and developed by a third party.

· In such case, you would export the db table before doing the changes as .csv, and after doing it.

· The provided tool will generate automatically an SQL script with the changes, the script can then be submitted to deltasql in the usual way.

· Added Microsoft SQL server JDBC driver to dbredactor

Fixes:
· Bash client fixed by Thanos Efraimidis, retrieving version number did not work in all circumstances

Minor:
· Removed warnings from Edit Module and Edit Script page
· Preparing database schema to general merging feature

· Major features: I
ntelligent branch selection on deltasql server:
· when submitting a new script, or while editing an existing one, deltasql will show only branches to which the script can be attached.
· when synchronizing, only suitable combinations of projects, from and to branches are shown. This considerably reduces the amount of errors. The dynamic feature is achieved through a PHP-AJAX-Javascript solution.
Pyhton deltasql client:
· the client supports now also Oracle's mysql.connector to reach a MySQL database. An adapter allows the user to choose between mysql.connector or MySQLdb adapter.

Minor:
· Cancel search link moves on the menu bar on the left. Latest changelog link is more visible and moved on the main of deltasql server.

· Fixes: Cleanup: moved graph scripts into a subfolder Known Issues: Intelligent branch selection does not work on Internet Explorer (only when submitting scripts).