[Info-vax] a cool database... as replacement for RMS index-sequential files:: Was: VSI working on alternatives to Oracle Classic database:

[Michael C]

On Thursday, January 21, 2021 at 10:59:28 AM UTC-5, Arne Vajhøj wrote:
> On 1/21/2021 10:45 AM, Stephen Hoffman wrote: 
> > On 2021-01-20 20:06:09 +0000, Arne Vajh j said: 
> >> On 1/20/2021 2:53 PM, Jeffrey H. Coffield wrote: 
> >>> My company has developed a JDBC driver for RMS indexed files and a 
> >>> persistence layer that achieve this and allow effective joins across 
> >>> both RMS and MySQL tables. We are in the process of packaging both 
> >>> the driver and persistence layer as open source but are currently 
> >>> uncertain of the correct license to use. 
> >> 
> >> I will suggest Apache License. 
> > 
> > Apache 2 or BSD/MIT licenses are the most typical choices for source 
> > code where the copyright holder doesn't wish to restrict source code 
> > usage. I've used both licenses for releases, though will typically be 
> > using Apache 2 for newer work. 
> > 
> > The various versions of GPL and LGPL and related are so-called copyleft 
> > licenses, and add requirements around certain actions with the source 
> > code. I tend not to use GPL, LGPL, or analog, though comply when 
> > modifying code covered by those.
> Besides the differences in license terms there seems to be 
> a bit of fashion in open source licenses. 
> 
> The C people more often choose BSD and LGPL. 
> 
> The Java and the Apple people more often chose Apache. 
> 
> The JS, PHP and .NET people more often chose MIT. 
> 
> Arne

Synergy has a product called SQL Connection. As long as it does not require Oracle client you should be good to go, shouldn't you? 


SQL Connection is an API and a set of database drivers that enable Synergy applications to use SQL-based functions to access and manipulate data from various database systems, such as Oracle and SQL Server. The SQL Connection API consists of two types of functions:

    Database functions are directly related to SQL-based operations and data access. They greatly simplify application development by reducing the number of calls needed to accomplish a wide variety of SQL functions. See Database Functions.
    Utility functions enable you to get information, map error codes, and set date and time options during the execution of a Synergy application. See Utility Functions.

Every SQL Connection function generates a value and can be used any place a literal can be used in a Synergy program. Except where noted, SQL Connection functions work with both traditional Synergy and Synergy .NET.

For an overview of the steps you will need to follow to use SQL Connection in your Synergy program, see Writing an SQL Connection program.

Features and supported databases 

SQL Connection conforms to ANSI-standard database communication methods SQLCA and SQLDA (ANSI 89) and supports the following databases:

    MySQL (version 5.1 and higher) on supported Windows, Linux, and AIX platforms. (MySQL 8 requires OpenSSL 1.1.1, so on UNIX, it is supported only on platforms that support that version of OpenSSL. See MySQL notes and examples for additional information.)
    Oracle® (version 11 and higher) on all supported Windows, UNIX, and OpenVMS platforms
    SQL Server accessed via Microsoft ODBC Driver 17.x for SQL Server. For information on SQL Server versions supported by these drivers, see the Microsoft documentation. For more information on SQL Connection support for Microsoft ODBC drivers, see SQL Server notes and examples. 
    Synergy DBMS (version 10.3.1 and higher) on all supported Windows, UNIX, and OpenVMS platforms

(For information on supported Windows, UNIX, and OpenVMS platforms, see System Requirements.)

SQL Connection has limited support for the following database systems. Support for these databases may require assistance from Synergex Professional Services Group and additional support fees. Contact your Synergex account executive for details.

    IBM DB2®
    Informix® on UNIX
    ODBC-compliant databases on Windows
    Oracle Rdb on OpenVMS
    PostgreSQL on Windows
    Sybase® on Windows and UNIX