Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread David Lamkins
I have the ISO component file implementation up and running. Give me a few days to polish and test, then I'll post the code to Github. On Jul 6, 2014 1:47 PM, "David B. Lamkins" wrote: > I wasn't previously aware that an appendix of the ISO standard called > for a component file system. Thanks fo

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread David B. Lamkins
I wasn't previously aware that an appendix of the ISO standard called for a component file system. Thanks for calling that to my attention. I based my API on a vague recollection of component file systems of days past. (In particular, STSC's component files as implemented in Richard Smith's short-

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread Blake McBride
Dear Juergen, While the keyed file system is often more desired than a component file system, the semantics of the two are different enough that one cannot easily substitute for the other. Having both options would be a good thing IMO. David wasn't part of our prior conversation on having the co

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread Juergen Sauermann
Hi Blake, yes, sorry. The bug-apl mailing list just passed the 2000'th email and I did not yet have the time to fully understand the different contributions related to file systems. When I briefly read the ISO standard I thought an SQL database with integers as keys and 10 ⎕CR of a value would

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread Juergen Sauermann
Hi David, I believe there is (in *m4/ax_lib_sqlite3.m4*). /// Jürgen On 07/05/2014 08:24 PM, David B. Lamkins wrote: Nice. Should there be a ./configure check for the sqlite3.h file? On Sat, 2014-07-05 at 16:03 +0200, Juergen Sauermann wrote: Hi, I have added Elias' SQL code (native funct

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread 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/0

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread Juergen Sauermann
Hi Elias, there also seems to be an issue with PQconnectdbParams() I have it defined in /usr/include/postgresql/libpq-fe.h on one (newer: linux-mint 16) machine but not in the same file on an older (Ubuntu 12.04 machine). /// Jürgen On 07/06/2014 11:32 AM, Elias Mårtenson wrote: I also not

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread Elias Mårtenson
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 wrote: > Hi, > > I will look into it. ./configure should properly detect if sqlite or > postgres

Re: [Bug-apl] Elias' SQL code

2014-07-06 Thread Juergen Sauermann
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

Re: [Bug-apl] Elias' SQL code

2014-07-05 Thread David B. Lamkins
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, Dav

Re: [Bug-apl] Elias' SQL code

2014-07-05 Thread David B. Lamkins
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 root1008 Jul 5 11:18 /usr/local/lib/apl/lib_sql.la lrw

Re: [Bug-apl] Elias' SQL code

2014-07-05 Thread David B. Lamkins
Nice. Should there be a ./configure check for the sqlite3.h file? 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 pro

Re: [Bug-apl] Elias' SQL code

2014-07-05 Thread Elias Mårtenson
Cool. I suppose I need to add proper documentation for it as well. :-) Regards, Elias On 5 Jul 2014 22:04, "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

[Bug-apl] Elias' SQL code

2014-07-05 Thread Juergen Sauermann
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