Millistream Database Application (MDA) version 0.9.24 released
The Millistream MDA project team is pleased to announce the release of
version 0.9.24 of our open source application for updating SQL servers
with data from the Millistream Data Feed.
Changes since the previous version:
* Fixed errors in the tabledef file. For example the 'trades' table
had erroneous keys, making cancelled trades to be added as an extra
row instead of updating the 'canceltime' column of the original
* The system check will now also check the data type and nullability
of the columns and not only the presence of the columns. If differences
are detected they are reported as warnings and MDA will execute as
normal. This is different from when columns or tables are missing, which
is treated as errors and MDA will refuse to continue.
* If MDA is invoked with "--upgrade-db", it will not try to change the
data types and nullability of the columns so that they match that of
the tabledef file. Please note that some SQL servers such as Microsoft
SQL Server does not support the alteration of columns included in keys
or indices so such changes have to made manual as of now, if MDA cannot
perform the upgrade it will write the reason to console and system log.
* When upgrading the database with "--upgrade-db", it is now possible to
use another SQL user than the one from the config file by adding the
argument "--dbsuser USERNAME". This can come handy if the normal SQL
user used by MDA does not have the permissions in the SQL server to
execute ALTER TABLE commands.
If using Windows Authentication instead of SQL Authentication with the
Microsoft SQL Server on Windows, you can use "--domainuser DOMAIN\USER".
If "DOMAIN\" is excluded then the local computer is used for the domain.
For both types of authentication, the password will be prompted for.
* On Windows when using the Microsoft SQL Server, MDA now supports the use
of Windows Authentication. To enable this, simply comment the "username"
and "password" entries in the config file under "DATABASE". Then MDA
will try and log on using the current Windows account.
To use another account, you can add these new entries to the config
file under "DATABASE":
o domain <domain> - This is the domain to use, if not present or set
to "." the local computer is used as the domain.
o domainuser <username> - The Windows Account name to use
o domainpassword <password> - The password for the Windows Account
* Native 64-bit version for Windows. The installer contains both versions
(32- and 64-bit) and will automatically install the correct version
depending upon your operating system.
* Cleaned up some of the log messages
* Added a new table: 'estimates'. SQL scripts to add this table is
attached to this e-mail since MDA currently cannot add tables.
* Fixed a number of Valgrind, cppcheck and compiler warnings. There are
currently no such warnings outstanding.
We consider MDA 0.9.24 to be the best version of MDA available and we
recommend that users of older versions upgrade as soon as possible.
MDA 0.9.24 is available for download from the following locations:
Windows installer: ftp://millistream.com/binaries/windows/
Red Hat / CentOS: https://packages.millistream.com/rpm/
Debian / Ubuntu: https://packages.millistream.com/apt/
Source code: ftp://millistream.com/sources/
Linux users who have added our apt or yum repositories can upgrade by simply
issuing "apt-get update && apt-get upgrade" (Debian/Ubuntu) or
"yum upgrade" (Red Hat/CentOS).
Information on how to add these repositories are available at
And as normal, if you have any questions what so ever regarding this release
or other things, don't hesitate to contact us at firstname.lastname@example.org
The Millistream Development Team