{"id":161,"date":"2017-01-04T20:57:31","date_gmt":"2017-01-04T20:57:31","guid":{"rendered":"https:\/\/reldb.org\/c\/?p=161"},"modified":"2017-01-04T20:57:31","modified_gmt":"2017-01-04T20:57:31","slug":"rel-version-3-003-is-now-available","status":"publish","type":"post","link":"https:\/\/reldb.org\/c\/index.php\/rel-version-3-003-is-now-available\/","title":{"rendered":"Rel version 3.003 is now available!"},"content":{"rendered":"<p class=\"p1\"><span class=\"s1\">This is a maintenance release of <i>Rel<\/i>, an implementation of Date &amp; Darwen&#8217;s <b>Tutorial D<\/b> database language. The most significant new feature is the ability to connect to external CSV files, XLS and XLSX spreadsheets, Microsoft Access databases, and JDBC database connections, and represent their contents as relation-valued variables (aka relvars). Facilities have also been provided to easily export relvars and query results as CSV and spreadsheet (XLS or XLSX) files.<\/span><\/p>\n<p class=\"p1\"><span class=\"s1\"><b>IMPORTANT NOTE<\/b>: Once opened with this or later versions of <i>Rel<\/i>, databases cannot be read by earlier versions.<\/span><\/p>\n<p class=\"p1\"><span class=\"s1\">The following enhancements have been made:<\/span><\/p>\n<ul class=\"ul1\">\n<li class=\"li1\"><span class=\"s1\">Support for UNORDER() (the inverse of ORDER(), to convert an ARRAY to a RELATION) has been added to the visual query editor in the <i>Rel<\/i> user interface.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface, a &#8220;refresh&#8221; toolbar item has been added to VIEWs, the same as for VARiables.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface, the visual query editor&#8217;s &#8220;View Query&#8221; &#8216;?&#8217; dialog now provides option to emit query text, or VIEW and OPERATOR definitions, directly to command-line. Furthermore, the dialog box is no longer modal; makes it easier to use query definition elsewhere.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface&#8217;s command-line, the initial use of the Save dialog defaults to directory of the most recent Load, if Load used first. Likewise, the initial Load dialog defaults to directory of most recent Save, if Save is used first.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface, Variables (relvars), Views, and visual query results may now be exported to CSV text files and XLS\/XLSX spreadsheet files.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the standalone <i>Rel<\/i> DBMS, all application .jars have been moved to the \/lib subdirectory.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">Support for accessing CSV files, XLS\/XLSX spreadsheet files, Microsoft Access databases, and JDBC databases for various popular DBMSs, and representing their contents as relation-valued variables (relvars) is now built-in. See\u00a0<a href=\"https:\/\/reldb.org\/c\/index.php\/read\/accessing-external-data-sources\/\"><span class=\"s2\">https:\/\/reldb.org\/c\/index.php\/read\/accessing-external-data-sources\/<\/span><\/a>\u00a0for further information.<\/span><\/li>\n<\/ul>\n<p class=\"p1\"><span class=\"s1\">The following bugs have been fixed:<\/span><\/p>\n<ul class=\"ul1\">\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface, spaces in application path caused external Java-based operator compilation to fail. Fixed.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface, the &#8220;Get File Path&#8221; button now correctly returns backslashes in file path as &#8216;\\\\&#8217;.<\/span><\/li>\n<li class=\"li1\"><span class=\"s1\">In the <i>Rel<\/i> user interface, failing to open a database could allow all database tabs to be closed, which left the <i>Rel<\/i> UI in an unstable state. Fixed.<\/span><\/li>\n<\/ul>\n<p class=\"p1\"><span class=\"s1\">For more information, or to download <i>Rel<\/i>, go to\u00a0<a href=\"https:\/\/reldb.org\/\"><span class=\"s2\">https:\/\/reldb.org<\/span><\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a maintenance release of Rel, an implementation of Date &amp; Darwen&#8217;s Tutorial D database language. The most significant new feature is the ability to connect to external CSV files, XLS and XLSX spreadsheets, Microsoft Access databases, and JDBC database connections, and represent their contents as relation-valued variables (aka relvars). Facilities have also been <a href=\"https:\/\/reldb.org\/c\/index.php\/rel-version-3-003-is-now-available\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Rel version 3.003 is now available!<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":149,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-161","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/comments?post=161"}],"version-history":[{"count":1,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/161\/revisions"}],"predecessor-version":[{"id":162,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/posts\/161\/revisions\/162"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/media\/149"}],"wp:attachment":[{"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/media?parent=161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/categories?post=161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/reldb.org\/c\/index.php\/wp-json\/wp\/v2\/tags?post=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}