Fwd: sqlite3 on macOS

[Dr . Jürgen Sauermann]

    Hi Peter,

thanks for reporting this. It looks like the m4/ax_lib_sqlite3.m4 macro shipped with
GNU APL has been outdated over time. I have updated it from a more recent
version from here:

https://ac-archive.sourceforge.net/ac-archive/ax_lib_sqlite3.m4

I hope this fixes the problem at your end, please let me know.

Best Regards,
Jürgen

On 10/2/22 11:03 PM, Peter Teeson wrote:

Hi Jürgen:

Doing some investigation I came across this(see my comments below):

./configure

…….

checking for SQLite3 library >= 3.0.0... yes

cat: /include/sqlite3.h: No such file or directory

./configure: line 19132: test: !=: unary operator expected

configure: WARNING: Cannot find SQLITE_VERSION macro in sqlite3.h header to retrieve SQLite version!

locate sqlite

…….

/usr/bin/sqlite3

/usr/lib/libsqlite3.0.dylib

/usr/lib/libsqlite3.dylib

/usr/lib/sqlite3

Gandalf:trunk pteeson$ cd /usr/lib

Gandalf:lib pteeson$ ls -al s*

lrwxr-xr-x  1 root  wheel     27 12 Jun 14:42 sqlite3 -> /System/Library/Tcl/sqlite3

========= My questions =======

This version and location of sqlite3 goes back to macOS Snow Leopard (2009).

It has been part of every macOS release up to and including Mojave (2017-last version I can run on my HW)

--with-sqlite3=[ARG]

   Build the native function for SQL using sqlite3. ARG may provide the

   non-default location of the sqlite3 library.

(1) Based on the above it seems macOS version is not in the default location. 

    What is the default location on Unix type systems? Also Windows?

   So what is the most elegant solution to this?

   (I don’t use sqlite and for sure I will not remember every time I download a new version of Gnuapl.)

  

(2) Would adding a note to the README make sense?

    Or recognize macOS and fix it in configure?

(3) Forget about it 

Anyway I thought to pass it on for your comment.

respect

Peter