Re: [Bug-apl] ⎕SQL

[Juergen Sauermann]

Hi Blake,

looking at keyedFiles.apl, for example, you can remove the  'lib_sql.so' ⎕FX 'SQL' completely and
replace variable SQL by ⎕SQL to use ⎕SQL.

You can as well leave everything as is. The difference is that in one case the internal copy
of lib_sql.so is used and otherwise lib_sql.so is loaded. That could be a good mid-term strategy
because otherwise all users of your workspace would need to update to at least SVN 838.

There were some problems related to )SAVEd native functions. These problems should be
fixed by now, but I would generally consider ⎕SQL to be cleaner. Syntax- and semantics-wise
⎕SQL is the same as SQL after having ⎕FXed it.

Regarding MS SQL, the SQL related code in GNU APL is still Elias' code and ⎕SQL will follow
his decisions regarding different SQL providers.

/// Jürgen

On 01/06/2017 08:30 PM, Blake McBride wrote:

My component and keyed file systems are built on Elias' SQL DB interface.  Do I need to convert those?

Also, if we are making the SQL interface an integral part of GNU APL, I would really like to see MS SQL Server support added.

Thanks!

Blake

On Fri, Jan 6, 2017 at 9:57 AM, Juergen Sauermann <address@hidden> wrote:

Hi,

Elias (the author of the SQL native function) and myself have
converted the previously native function into a system function named
⎕SQL. Everything else remains the same.

The wslib5/SQL.apl workspace was updated accordingly; if you use
that workspace instead of the native function directly then you should
not notice any differences.

The native function for SQL will remain for a while, but disappear eventually.

Enjoy,
Jürgen