On 11 Jan 2018, at 13:23, Richard Hipp wrote, in reply to John G 
<rjkgilles...@gmail.com>:

> 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

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to