{"id":5365,"date":"2026-11-03T21:10:50","date_gmt":"2026-11-03T20:10:50","guid":{"rendered":"https:\/\/millistream.com\/?p=5365"},"modified":"2026-11-03T21:10:50","modified_gmt":"2026-11-03T20:10:50","slug":"millistream-database-application-mda-version-0-9-60-released","status":"publish","type":"post","link":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/","title":{"rendered":"Millistream Database Application (MDA) version 0.9.60 released"},"content":{"rendered":"<p>The Millistream MDA project team is pleased to announce the release of version 0.9.60 of our open source application for updating SQL servers with data from the Millistream Data Feed.<\/p>\n<ul>\n<li>Fixed a bug in v1.0.59 where the &#8220;connected&#8221; stat on Windows stopped working<\/li>\n<li>Made the error message when connecting to a MySQL\/MariaDB server with no database defined more easy to understand<\/li>\n<li>Fixed a bug in the handling of tabular format that prevented NULL values to exist between non NULL values<\/li>\n<li>Properly handle the new error code 1020 in MariaDB v12 that indicates a deadlock<\/li>\n<li>Make sure that all primary key columns are used on PostgreSQL in the ON CONFLICT statement to properly handle edge cases if any of the primary key columns are not sent in the feed.<\/li>\n<li>Force the installer on Windows to install all the dependency dll:s even if the version is the same, turned out that some of them are always in v1.0.0 despite being actually updated<\/li>\n<li>Added support for the TPT table (MiFID Tripartite Template)<\/li>\n<\/ul>\n<p>As previously announced, as of v0.9.33 the database schema is developed independently of the MDA and the latest schema including upgrade scripts is available on our http server under the documents section\u00a0 (MDA_schemas_[version].zip). As of this writing the latest database schema is v135 and is available from <a href=\"https:\/\/packages.millistream.com\/documents\/MDA_schema_135.zip\" data-wplink-edit=\"true\">https:\/\/packages.millistream.com\/documents\/MDA_schema_135.zip<\/a><\/p>\n<p>Do note however that the latest schemas are only needed if you need the new columns\/tables, they are not mandatory to operate the MDA!<\/p>\n<p>We consider MDA 0.9.60 to be the best version of MDA available and we recommend that users of older versions upgrade as soon as possible.<\/p>\n<p>MDA 0.9.60 is available for download from the following locations:<\/p>\n<ul>\n<li>Windows installer: <a href=\"https:\/\/packages.millistream.com\/Windows\/mda-0.9.60.exe\">https:\/\/packages.millistream.com\/Windows\/mda-0.9.60.exe<\/a><\/li>\n<li>Red Hat \/ CentOS: <a href=\"https:\/\/packages.millistream.com\/rpm\/\">https:\/\/packages.millistream.com\/rpm\/<\/a><\/li>\n<li>Debian \/ Ubuntu: <a href=\"https:\/\/packages.millistream.com\/apt\/\">https:\/\/packages.millistream.com\/apt\/<\/a><\/li>\n<li>Source code: <a href=\"https:\/\/packages.millistream.com\/source\/mda-0.9.60.tar.gz\">https:\/\/packages.millistream.com\/source\/mda-0.9.60.tar.gz<\/a><\/li>\n<li>Documentation: <a href=\"https:\/\/packages.millistream.com\/documents\/MDA.pdf\">https:\/\/packages.millistream.com\/documents\/MDA.pdf<\/a><\/li>\n<\/ul>\n<p>Windows users upgrade by running the installer for the new version.<\/p>\n<p>Linux users who have added our apt or yum repositories can upgrade by simply issuing:<\/p>\n<ul>\n<li>Debian\/Ubuntu: &#8220;<code>apt update && apt upgrade<\/code>&#8220;<\/li>\n<li>Red Hat\/CentOS\/Amazon Linux AMI: &#8220;<code>yum upgrade<\/code>&#8220;<\/li>\n<\/ul>\n<p>Information on how to add these repositories are available at<a href=\"https:\/\/packages.millistream.com\/Linux\/\">https:\/\/packages.millistream.com\/Linux\/<\/a><\/p>\n<p>And as usual, if you have any questions what so ever regarding this release or other things, don&#8217;t hesitate to contact us at <a href=\"mailto:tech@millistream.com\">tech@millistream.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":3595,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[56],"class_list":["post-5365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-news","tag-latest"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Millistream Database Application (MDA) version 0.9.60 released - Millistream<\/title>\n<meta name=\"description\" content=\"Financial market data from exchanges like Nasdaq, NYSE, Deutsche B\u00f6rse and London Stock Exchange. Real time and delayed via feed API:s and widgets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Millistream Database Application (MDA) version 0.9.60 released - Millistream\" \/>\n<meta property=\"og:description\" content=\"Financial market data from exchanges like Nasdaq, NYSE, Deutsche B\u00f6rse and London Stock Exchange. Real time and delayed via feed API:s and widgets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/\" \/>\n<meta property=\"og:site_name\" content=\"Millistream\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-03T20:10:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/millistream.com\/wp-content\/uploads\/2017\/05\/Millistream-highres-300x23.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"23\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Henrik Holst\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Henrik Holst\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/\"},\"author\":{\"name\":\"Henrik Holst\",\"@id\":\"https:\\\/\\\/millistream.com\\\/#\\\/schema\\\/person\\\/2077820af732fc051625b0872602d531\"},\"headline\":\"Millistream Database Application (MDA) version 0.9.60 released\",\"datePublished\":\"2026-11-03T20:10:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/\"},\"wordCount\":408,\"image\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/Millistream-highres-300x23.png\",\"keywords\":[\"latest\"],\"articleSection\":[\"Technology News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/\",\"url\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/\",\"name\":\"Millistream Database Application (MDA) version 0.9.60 released - Millistream\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/Millistream-highres-300x23.png\",\"datePublished\":\"2026-11-03T20:10:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/#\\\/schema\\\/person\\\/2077820af732fc051625b0872602d531\"},\"description\":\"Financial market data from exchanges like Nasdaq, NYSE, Deutsche B\u00f6rse and London Stock Exchange. Real time and delayed via feed API:s and widgets.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#primaryimage\",\"url\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/Millistream-highres-300x23.png\",\"contentUrl\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/Millistream-highres-300x23.png\",\"width\":300,\"height\":23},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-60-released\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/millistream.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Millistream Database Application (MDA) version 0.9.60 released\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/millistream.com\\\/#website\",\"url\":\"https:\\\/\\\/millistream.com\\\/\",\"name\":\"Millistream\",\"description\":\"A Modern Market Data Company\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/millistream.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/millistream.com\\\/#\\\/schema\\\/person\\\/2077820af732fc051625b0872602d531\",\"name\":\"Henrik Holst\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1653ab5521e33f89270afb16c1767dd4b4c8c0a1157fd2f32314338b33624e1c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1653ab5521e33f89270afb16c1767dd4b4c8c0a1157fd2f32314338b33624e1c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1653ab5521e33f89270afb16c1767dd4b4c8c0a1157fd2f32314338b33624e1c?s=96&d=mm&r=g\",\"caption\":\"Henrik Holst\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Millistream Database Application (MDA) version 0.9.60 released - Millistream","description":"Financial market data from exchanges like Nasdaq, NYSE, Deutsche B\u00f6rse and London Stock Exchange. Real time and delayed via feed API:s and widgets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/","og_locale":"en_US","og_type":"article","og_title":"Millistream Database Application (MDA) version 0.9.60 released - Millistream","og_description":"Financial market data from exchanges like Nasdaq, NYSE, Deutsche B\u00f6rse and London Stock Exchange. Real time and delayed via feed API:s and widgets.","og_url":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/","og_site_name":"Millistream","article_published_time":"2026-11-03T20:10:50+00:00","og_image":[{"width":300,"height":23,"url":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/05\/Millistream-highres-300x23.png","type":"image\/png"}],"author":"Henrik Holst","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Henrik Holst","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#article","isPartOf":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/"},"author":{"name":"Henrik Holst","@id":"https:\/\/millistream.com\/#\/schema\/person\/2077820af732fc051625b0872602d531"},"headline":"Millistream Database Application (MDA) version 0.9.60 released","datePublished":"2026-11-03T20:10:50+00:00","mainEntityOfPage":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/"},"wordCount":408,"image":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#primaryimage"},"thumbnailUrl":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/05\/Millistream-highres-300x23.png","keywords":["latest"],"articleSection":["Technology News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/","url":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/","name":"Millistream Database Application (MDA) version 0.9.60 released - Millistream","isPartOf":{"@id":"https:\/\/millistream.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#primaryimage"},"image":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#primaryimage"},"thumbnailUrl":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/05\/Millistream-highres-300x23.png","datePublished":"2026-11-03T20:10:50+00:00","author":{"@id":"https:\/\/millistream.com\/#\/schema\/person\/2077820af732fc051625b0872602d531"},"description":"Financial market data from exchanges like Nasdaq, NYSE, Deutsche B\u00f6rse and London Stock Exchange. Real time and delayed via feed API:s and widgets.","breadcrumb":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#primaryimage","url":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/05\/Millistream-highres-300x23.png","contentUrl":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/05\/Millistream-highres-300x23.png","width":300,"height":23},{"@type":"BreadcrumbList","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-60-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/millistream.com\/"},{"@type":"ListItem","position":2,"name":"Millistream Database Application (MDA) version 0.9.60 released"}]},{"@type":"WebSite","@id":"https:\/\/millistream.com\/#website","url":"https:\/\/millistream.com\/","name":"Millistream","description":"A Modern Market Data Company","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/millistream.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/millistream.com\/#\/schema\/person\/2077820af732fc051625b0872602d531","name":"Henrik Holst","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1653ab5521e33f89270afb16c1767dd4b4c8c0a1157fd2f32314338b33624e1c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1653ab5521e33f89270afb16c1767dd4b4c8c0a1157fd2f32314338b33624e1c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1653ab5521e33f89270afb16c1767dd4b4c8c0a1157fd2f32314338b33624e1c?s=96&d=mm&r=g","caption":"Henrik Holst"}}]}},"_links":{"self":[{"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts\/5365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/comments?post=5365"}],"version-history":[{"count":1,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts\/5365\/revisions"}],"predecessor-version":[{"id":5366,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts\/5365\/revisions\/5366"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/media\/3595"}],"wp:attachment":[{"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/media?parent=5365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/categories?post=5365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/tags?post=5365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}