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. Best regards, Niall O'Reilly
signature.asc
Description: OpenPGP digital signature
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

