The newest percentile.c: https://sqlite.org/src/file/ext/misc https://sqlite.org/src/artifact/b9086e223d583bda
Has the flag: SQLITE_INNOCUOUS
When I try to compile it using the instructions here: https://www.sqlite.org/loadext.html
gcc -g -fPIC -dynamiclib percentile.c -o percentile.dylib
I get the error:
percentile.c:217:44: error: use of undeclared identifier 'SQLITE_INNOCUOUS' SQLITE_UTF8|SQLITE_INNOCUOUS, 0, ^ 1 error generated.
That flag was introduced as part of this change: https://sqlite.org/src/info/4c21373c21c9b17b
Can someone toll me how I can compile this dylib without getting the error above?
The SQLITE_INNOCUOUS flag is a new feature for SQLite version 3.31.0. Whatever SQLite library you have installed must be older than that.
Either update the SQLite library that you are compiling against, or use an older version of the percentile.c source code.
or just -DSQLITE_INNOCUOUS=0 for that compilation unit. That is:
gcc -g -fPIC -DSQLITE_INNOCUOUS=0 -dynamiclib percentile.c -o percentile.dylib
but don't forget to get rid of that define when you eventually use a more up-to-date version of the sqlite3 library.