Hi, On Sat, Jan 13, 2018 at 6:32 AM, Niall O'Reilly <[email protected]> wrote: > > > On 11 Jan 2018, at 13:23, Richard Hipp wrote, in reply to John G > <[email protected]>: > >> You can >> download and/or compile your own up-to-date SQLite that is twice as >> fast and has all the latest features. > > It may be more convenient to use the [Homebrew package > manager](https://brew.sh/), which tracks SQLite pretty closely. In order to > avoid interfering with the Apple-supplied installation, Homebrew deliberately > neglects to link the executable to _/usr/local/bin_, so some care is needed > when invoking SQLite in order to run the intended version. > > Here's what I have on my laptop, running Sierra. > > dhcp-162(niall)12: brew install sqlite > Updating Homebrew... > Warning: sqlite 3.21.0 is already installed > dhcp-162(niall)13: > dhcp-162(niall)13: which sqlite3 > /usr/bin/sqlite3 > dhcp-162(niall)14: /usr/bin/sqlite3 > SQLite version 3.16.0 2016-11-04 19:09:39 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> ^D > dhcp-162(niall)15: /usr/local/Cellar/sqlite/3.21.0/bin/sqlite3 > SQLite version 3.21.0 2017-10-24 18:55:49 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> > dhcp-162(niall)16: > > I hope this helps.
Why? Just include sqlite3.c in your project and recompile. Thank you. > > Best regards, > Niall O'Reilly > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

