{"id":3448,"date":"2017-03-30T10:47:12","date_gmt":"2017-03-30T10:47:12","guid":{"rendered":"http:\/\/s672932733.websitehome.co.uk\/?p=3448"},"modified":"2017-05-28T00:28:00","modified_gmt":"2017-05-27T22:28:00","slug":"millistream-database-application-mda-version-0-9-40-released","status":"publish","type":"post","link":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/","title":{"rendered":"Millistream Database Application (MDA) version 0.9.40 released"},"content":{"rendered":"<p>The Millistream MDA project team is pleased to announce the release of version 0.9.40 of our open source application for updating SQL servers with data from the Millistream Data Feed.<\/p>\n<ul>\n<li>Fixed an error on PostgreSQL where escaped string containing forward slash &#8220;\\&#8221; characters would be sent wrongly to the SQL server if &#8220;standard_conforming_strings&#8221; is enabled on the server (which it is per default in newer versions of PostgreSQL).<\/li>\n<li>Support &#8220;connectionstring&#8221; setting in mda.config for the Microsoft SQL Server and PostreSQL servers for power users that want to set more options for the connection to the SQL server than the available settings in mda.config allow. When &#8220;connectionstring&#8221; is used then the other settings such as &#8220;username&#8221;, &#8220;password&#8221;, &#8220;dbname&#8221;, &#8220;server&#8221; and &#8220;port&#8221; are ignored by the MDA.<\/li>\n<li>On Microsoft SQL Server and PostgreSQL a &#8220;mda &#8211;check-types&#8221; could erroneously report errors for &#8220;numeric&#8221; columns with a length between (10,0) and (19,0).<\/li>\n<li>When connecting with MySQL\/MariaDB, MDA will now read options from the &#8220;mda&#8221; group in the &#8220;my.cnf&#8221; file if such a group exists.<\/li>\n<li>The SSL settings added in v0.9.39 for MySQL\/MariaDB will now also work for PostgreSQL (even though they are perhaps best set there using the &#8220;connectionstring&#8221; setting anyway).<\/li>\n<li>Added man pages for &#8220;mda&#8221; and &#8220;mda.config&#8221; on Linux.<\/li>\n<\/ul>\n<p>As earlier 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 ftp server under the documents section (MDA_schemas_[version].zip). As of this writing the latest database schema is v89 and thus the file is available from <a href=\"ftp:\/\/ftp.millistream.com\/documents\/MDA_schema_89.zip\">ftp:\/\/ftp.millistream.com\/documents\/MDA_schema_89.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.40 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.40 is available for download from the following locations:<\/p>\n<ul>\n<li>Windows installer: <a href=\"ftp:\/\/ftp.millistream.com\/binaries\/windows\/\">ftp:\/\/ftp.millistream.com\/binaries\/windows\/<\/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=\"ftp:\/\/ftp.millistream.com\/sources\/\">ftp:\/\/ftp.millistream.com\/sources\/<\/a><\/li>\n<li>Documentation: <a href=\"ftp:\/\/ftp.millistream.com\/documents\/mda.pdf\">ftp:\/\/ftp.millistream.com\/documents\/mda.pdf<\/a><\/li>\n<\/ul>\n<p>Windows users upgrade by running the installer for the new version. 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 &amp;&amp; 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=\"ftp:\/\/ftp.millistream.com\/binaries\/linux\/\">ftp:\/\/ftp.millistream.com\/binaries\/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":"<p>The Millistream MDA project team is pleased to announce the release of version 0.9.40 of our open source application for updating SQL servers with data from the Millistream Data Feed. Fixed an error on PostgreSQL where escaped string containing forward slash &#8220;\\&#8221; characters would be sent wrongly to the SQL server if &#8220;standard_conforming_strings&#8221; is enabled [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[],"class_list":["post-3448","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-news"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Millistream Database Application (MDA) version 0.9.40 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-40-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.40 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-40-released\/\" \/>\n<meta property=\"og:site_name\" content=\"Millistream\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-30T10:47:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-27T22:28:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/millistream.com\/wp-content\/uploads\/2017\/02\/Millistream-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"383\" \/>\n\t<meta property=\"og:image:height\" content=\"29\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"matsfors\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"matsfors\" \/>\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-40-released\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/\"},\"author\":{\"name\":\"matsfors\",\"@id\":\"https:\\\/\\\/millistream.com\\\/#\\\/schema\\\/person\\\/a7eea1259f86a44cfc666b773809de5d\"},\"headline\":\"Millistream Database Application (MDA) version 0.9.40 released\",\"datePublished\":\"2017-03-30T10:47:12+00:00\",\"dateModified\":\"2017-05-27T22:28:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/\"},\"wordCount\":450,\"image\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/Millistream-logo.png\",\"articleSection\":[\"Technology News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/\",\"url\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/\",\"name\":\"Millistream Database Application (MDA) version 0.9.40 released - Millistream\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/Millistream-logo.png\",\"datePublished\":\"2017-03-30T10:47:12+00:00\",\"dateModified\":\"2017-05-27T22:28:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/millistream.com\\\/#\\\/schema\\\/person\\\/a7eea1259f86a44cfc666b773809de5d\"},\"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-40-released\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-released\\\/#primaryimage\",\"url\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/Millistream-logo.png\",\"contentUrl\":\"https:\\\/\\\/millistream.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/Millistream-logo.png\",\"width\":383,\"height\":29},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/millistream.com\\\/index.php\\\/millistream-database-application-mda-version-0-9-40-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.40 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\\\/a7eea1259f86a44cfc666b773809de5d\",\"name\":\"matsfors\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c1e3c460c5300043ee5abc8bb061e3610b9e1f84ff27f869375d1e1357b06dea?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c1e3c460c5300043ee5abc8bb061e3610b9e1f84ff27f869375d1e1357b06dea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c1e3c460c5300043ee5abc8bb061e3610b9e1f84ff27f869375d1e1357b06dea?s=96&d=mm&r=g\",\"caption\":\"matsfors\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Millistream Database Application (MDA) version 0.9.40 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-40-released\/","og_locale":"en_US","og_type":"article","og_title":"Millistream Database Application (MDA) version 0.9.40 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-40-released\/","og_site_name":"Millistream","article_published_time":"2017-03-30T10:47:12+00:00","article_modified_time":"2017-05-27T22:28:00+00:00","og_image":[{"width":383,"height":29,"url":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/02\/Millistream-logo.png","type":"image\/png"}],"author":"matsfors","twitter_card":"summary_large_image","twitter_misc":{"Written by":"matsfors","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-40-released\/#article","isPartOf":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/"},"author":{"name":"matsfors","@id":"https:\/\/millistream.com\/#\/schema\/person\/a7eea1259f86a44cfc666b773809de5d"},"headline":"Millistream Database Application (MDA) version 0.9.40 released","datePublished":"2017-03-30T10:47:12+00:00","dateModified":"2017-05-27T22:28:00+00:00","mainEntityOfPage":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/"},"wordCount":450,"image":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/#primaryimage"},"thumbnailUrl":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/02\/Millistream-logo.png","articleSection":["Technology News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/","url":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/","name":"Millistream Database Application (MDA) version 0.9.40 released - Millistream","isPartOf":{"@id":"https:\/\/millistream.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/#primaryimage"},"image":{"@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/#primaryimage"},"thumbnailUrl":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/02\/Millistream-logo.png","datePublished":"2017-03-30T10:47:12+00:00","dateModified":"2017-05-27T22:28:00+00:00","author":{"@id":"https:\/\/millistream.com\/#\/schema\/person\/a7eea1259f86a44cfc666b773809de5d"},"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-40-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-released\/#primaryimage","url":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/02\/Millistream-logo.png","contentUrl":"https:\/\/millistream.com\/wp-content\/uploads\/2017\/02\/Millistream-logo.png","width":383,"height":29},{"@type":"BreadcrumbList","@id":"https:\/\/millistream.com\/index.php\/millistream-database-application-mda-version-0-9-40-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.40 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\/a7eea1259f86a44cfc666b773809de5d","name":"matsfors","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c1e3c460c5300043ee5abc8bb061e3610b9e1f84ff27f869375d1e1357b06dea?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c1e3c460c5300043ee5abc8bb061e3610b9e1f84ff27f869375d1e1357b06dea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c1e3c460c5300043ee5abc8bb061e3610b9e1f84ff27f869375d1e1357b06dea?s=96&d=mm&r=g","caption":"matsfors"}}]}},"_links":{"self":[{"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts\/3448","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/comments?post=3448"}],"version-history":[{"count":9,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts\/3448\/revisions"}],"predecessor-version":[{"id":3863,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/posts\/3448\/revisions\/3863"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/media\/9"}],"wp:attachment":[{"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/media?parent=3448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/categories?post=3448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/millistream.com\/index.php\/wp-json\/wp\/v2\/tags?post=3448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}