OSX sqlite3 readline support seems broken

[pearsonca]

After installing Anaconda, I noticed that I no longer had readline support in sqlite3. I checked which sqlite3 and indeed it now points the Anaconda version. When I invoke the version @ /usr/bin/sqlite3 (not sure the provenance of that - I think I obtained it via homebrew), readline support is fine.

[pearsonca]

Extra info:

me$ otool -L $(which sqlite3)
/Volumes/Data/me/anaconda/bin/sqlite3:
    @loader_path/../lib/libsqlite3.0.dylib (compatibility version 9.0.0, current version 9.6.0)
    /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 1.0.0)
    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.0.0)
me$ otool -L $(which /usr/bin/sqlite3)
/usr/bin/sqlite3:
    /usr/lib/libncurses.5.4.dylib (compatibility version 5.4.0, current version 5.4.0)
    /usr/lib/libsqlite3.dylib (compatibility version 9.0.0, current version 168.0.0)
    /usr/lib/libedit.3.dylib (compatibility version 2.0.0, current version 3.0.0)
    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1213.0.0)

[ahmadia]

/usr/bin/sqlite3 (not sure the provenance of that - I think I obtained it via homebrew)

It's almost certainly not homebrew's, since homebrew installs into /usr/local/bin. I'm guessing it is installed by the system (or the XCode SDK). Here is the OS X man page.

[krader1961]

I noticed this recently as well. I have sqlite3 installed via HomeBrew and Anaconda. Until a few days ago when I updated both environments I didn't notice a problem with readline support in the sqlite3 interactive CLI. Now I see that the Anaconda verision

3.8.4.1 2014-03-11 15:27:36 018d317b1257ce68a92908b05c9c7cf1494050d0

does not support readline while the Homebrew version

3.8.10.2 2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4

does support readline. I don't know if I've ever tried to use readline support in the Anaconda version. Primarily because I don't always pay attention to whether an Anaconda environment is active when I run a command like sqlite3. Yet, based on my ~/conda/pkgs directory it appears I've had an Anaconda version of sqlite3 installed for at least year. Which makes it unlikely I wouldn't have noticed this change in behavior until the past few weeks.

[ncoghlan]

I recently saw this at a Software Carpentry workshop on an attendees's Ubuntu system, so this may not be Mac OS X specific - the Anaconda built sqlite3 may simply not have readline support enabled properly.

[gokceneraslan]

This is not OS X specific, also reproducible on Linux. Please update the title and rebuild it with readline support :)

[dpshelio]

Same problem here, I've seen it in OS X and Linux. Using the shipped one with either works as expected, with the one from Anaconda doesn't show the readline support.

[ilanschnell]

We don't compile sqlite with readline support, see https://github.com/ContinuumIO/anaconda-recipes/blob/master/sqlite/build.sh#L11
We should probably consider doing so.

[saiwing-yeung]

Please support readline~

[jakirkham]

We are trying to do this at conda-forge in PR ( conda-forge/sqlite-feedstock#7 ), but it appears to be a real pain to make sure readline is picked up from the environment and not the system. Suggestions welcome.