Re: [Bug-apl] Elias' SQL code

[Juergen Sauermann]

Hi,

I have improved the check for postgresql in ./configure, see SVN 360.

Seems like SQLite does such a test already.

Since lib_sql is a shared library it can still happen that it compiles but
complains at runtime when another shared lib that it depends on cannot
be found.

/// Jürgen


On 07/06/2014 11:32 AM, Elias Mårtenson wrote:

I also noticed that the community web page says that the library supports mysql and postgres, when in fact it supports SQLite and PostgreSQL.

Regards,

Elias

On 6 July 2014 17:29, Juergen Sauermann <address@hidden> wrote:

Hi,

I will look into it. ./configure should properly detect if sqlite or postgres is
installed and compile only those pieces that are installed.

BTW if you get 0 from ⎕FX then )MORE shows where it was searching
for the .so files. That doesn't help here but might be of interest.

/// Juergen

On 07/05/2014 10:48 PM, David B. Lamkins wrote:

I found the problem.

Both sqlite and postgresql development packages must be installed.

I had sqlite installed but not postgresql. It looks as if ./configure
noticed the absence of Postgres, but somehow the lib_sql native function
didn't get built properly.

On Sat, 2014-07-05 at 12:12 -0700, David B. Lamkins wrote:

I seem to be unable to bind the lib_sql native function. Suggestions?

       'lib_sql' ⎕fx 'SQL'
0

       )host ls -l /usr/local/lib/apl/lib_sql.*
-rw-r--r--. 1 root root 1307838 Jul  5
11:18 /usr/local/lib/apl/lib_sql.a
-rwxr-xr-x. 1 root root    1008 Jul  5
11:18 /usr/local/lib/apl/lib_sql.la
lrwxrwxrwx. 1 root root      16 Jul  5
11:18 /usr/local/lib/apl/lib_sql.so -> lib_sql.so.0.0.0
lrwxrwxrwx. 1 root root      16 Jul  5
11:18 /usr/local/lib/apl/lib_sql.so.0 -> lib_sql.so.0.0.0
-rwxr-xr-x. 1 root root  569481 Jul  5
11:18 /usr/local/lib/apl/lib_sql.so.0.0.0

0


On Sat, 2014-07-05 at 16:03 +0200, Juergen Sauermann wrote:

Hi,

I have added Elias' SQL code (native functions and APL workspace) so that
it is now built and installed automatically with GNU APL.

Elias, thanks for providing this!

/// Jürgen