What's new in deltasql 1.8.2
Apr 21, 2017
- This release is a 10 year jubilee as deltasql development started on Easter 2007
- and was continued occasionally during the last 10 years when free time allowed it.
- As fortunate coincidence I also met my now wife at the same time :-)
- The feature added in release 1.8.2 is a simple but effective document management system
- which allows to pin documents to particular SQL scripts.
- Again, this feature is useful when using deltasql in 'script collection mode', to add
- documentation and context to complex SQL scripts. It is not intended to be used when
- deltasql is in 'script synchronization mode', as the attached documents are never
- concatenated nor executed when calculating the synchronization script.
New in deltasql 1.8.1 (Mar 14, 2017)
- 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.
New in deltasql 1.8.0 (Mar 4, 2016)
- 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).
New in deltasql 1.7.3 (Nov 19, 2015)
- 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
- Ability to move a tag when doing last minute fixes on a release
- The release is complemented by minor bugfixes.
New in deltasql 1.7.2 (Nov 5, 2015)
- 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.
New in deltasql 1.7.1 (Jun 30, 2015)
- This is a maintenance release with following patches and features:
- verification script for Microsoft SQL server did not work properly
- ability to search among projects
- ability to rename a project
- List Scripts refreshes once a a minute to show new scripts added by other users
- exclude views and packages in synchronization form was broken and is now fixed
New in deltasql 1.7.0 (Jun 19, 2014)
- 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
New in deltasql 1.6.5 (Apr 17, 2014)
- 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
- clicking on logo returns to main page also in Open Source edition.
New in deltasql 1.6.4 (Oct 9, 2013)
- 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
New in deltasql 1.6.3 (Sep 11, 2013)
- 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
New in deltasql 1.6.2 (Jul 4, 2013)
- 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).
New in deltasql 1.6.1 (May 9, 2013)
- New features:
- navigation bar on the left for faster switch between pages
- Fixes: Copy&Paste works also in Internet Explorer
- Documentation: one new FAQ entry on why deltasql is so different from commercial tools. New webpage is part of the package in web subfolder
New in deltasql 1.6.0 (Apr 30, 2013)
- New features:
- timing of synchronization script generation and of some key PHP pages
- deltaclient compiled for Linux (Gnome and Unity)
- export project as XML or HTML to avoid vendor (=deltasql) lock-in
- Fixes:
- colored diffs of scripts works in any browser
- refactoring utility library to increase rendering speed
- removing some dead code (google gadget and phone home functionality)
- increased wideness of script's title
- Documentation:
- two new FAQ entries about stable releases and how to install patches
- added documentation on how to install deltaclient on Linux
New in deltasql 1.5.5 (Jan 3, 2013)
- more deltasql fixes to work with PHP 5.3 (as XAMPP ships it by default now), moving deltasql url from deltasql.org to deltasql.sourceforge.net
New in deltasql 1.5.4-1 (Oct 4, 2012)
- bugfix in edit_script.php (PHP 5.3 compatibility)
New in deltasql 1.5.4 (Sep 20, 2012)
- Maintenance release: deltasql fixes to work with PHP 5.3 (as XAMPP ships it by default now).
New in deltasql 1.5.3 (Aug 25, 2012)
- Maintenance release: Consolidating the Copy&Paste functionality
New in deltasql 1.5.2 (Jul 18, 2012)
- With this release deltasql introduces the handy copy&paste functionality to copy pasting existing scripts, the synchronization query, the generated synchronization script and the seeding script for databases which will come under deltasql version control.
New in deltasql 1.5.1 (May 14, 2012)
- Maintenance release for deltasql, including a new Python deltasql client which works from the command line for mySQL database types only.
- A new chart showing scripts per project was added. Minor fixes
New in deltasql 1.5.0 (Apr 4, 2012)
- Major release containing charting features for deltasql. It is possible to see how many scripts are added each month and how many synchronizations are performed. A top ten page shows the best developers writing new scripts and the best release managers performing most synchronizations.
- Minor features include a changelog feature which shows which is the latest deltasql release and the ability to edit scripts when they are shown. Other minor enhancements and the removal of the unused phone home functionality round off this release.
New in deltasql 1.4.4 (Mar 2, 2012)
- removing Pyhton skeleton as to date I do not have gear to develop it
- skeleton for a deltasql client written in Python
- bugfix in homepage of enterprise edition
- email notification contains to which branches the script is applied
- author name in subject of email notification
- script version in email notification
- email notification also if script is edited or deleted
- initial install page has the option to enable email notification
New in deltasql 1.4.2 (Jan 3, 2012)
- Visual enhancements (icons on important actions and border to empty cells)
- Ability to branch from existing tags
- Minor bugfixes
New in deltasql 1.4.1 (Sep 24, 2011)
- deltaclient: new field database type added, fixed errors in closing files project.conf and branches.conf
- deltasql server:
- minimizing impact of Undefined Index errors when running with php.ini
- error_reporting = E_ALL | E_STRICT ; instead of E_ALL & ~E_NOTICE
- dropped unused schemaname and description fields as they created confusion to users and were used by spammers
- back to the onliner INSERT statement to update synchronization information
- inserted links to videos into documentation, improved documentation