Re: sqlite3 on macOS

[Peter Teeson]

Hi Jürgen:

I started with an empty dir, downloaded current version 1592, and ./configure. Same warning.

 

The m4/ax_lib_sqllite3.m4 says:

"dnl If no intallation prefix to the installed SQLite library is given

dnl the macro searches under /usr, /usr/local, and /opt."

Gandalf:~ pteeson$ cd /usr/local/opt/sqlite3/include

Gandalf:include pteeson$ ls -al sql*

-rw-r--r--  1 502  staff  581196 18 Jun  2020 sqlite3.h

-rw-r--r--  1 502  staff   35269 18 Jun  2020 sqlite3ext.h

checking for SQLite3 library >= 3.0.0... yes

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

./configure: line 19090: test: !=: unary operator expected     <======

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

I found it in the header

#define SQLITE_VERSION        "3.32.3"

#define SQLITE_VERSION_NUMBER 3032003

#define SQLITE_SOURCE_ID      "2020-06-18 14:00:33 7ebdfa80be8e8e73324b8d66b3460222eb74c7e9dfd655b48d6ca7e1933cc8fd"

So I do not know how to proceed further to help isolate what’s up.

respect…

Peter

On Oct 3, 2022, at 8:12 AM, Dr. Jürgen Sauermann <mail@xn--jrgen-sauermann-zvb.de> wrote:

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