On 31 May 2016 at 15:41, Eric Kestler <[email protected]> wrote: > I’m a newbie to Sqlite, if that explains the following: > > Last year, I installed Sqlite on my Mac; it was version 3.7.6.3: > > Server Type: SQLite > Connection Name: testDB > Database File: /Users/ekestler/Dropbox/SyleneDB/test.db > Setting Save Path: /Users/ekestler/Library/Application Support/PremiumSoft > CyberTech/Navicat for SQLite/testDB > Auto connect: NO > Encrypted: NO > Attached Database: NO > Server Version: 3.7.6.3 > > > This past week, after carefully saving all the SQL queries, and exporting > all the tables as CSV files, renamed the sqlite3 executable to sqlite3_old, > and downloaded and installed a newer version on my Mac: > > Erics-MacBook-Pro:SyleneDB ekestler$ sqlite3 > > SQLite version 3.8.10.2 2015-05-20 18:17:19 > > Enter ".help" for usage hints. > > Connected to a *transient in-memory database*. > > Use ".open FILENAME" to reopen on a persistent database. > > sqlite>
Yes, what you have installed is a program called sqlite, which uses the sqlite library which is built in to it. You didn't actually need to do this, since OS X comes with the sqlite program already installed. Don't confuse the sqlite program, a shell program which provides you the ability to type in sql commands to modify a database, with the sqlite library, which provides the functionality that the sqlite program needs. > I use a (very old, not available from the vendor anymore) development IDE > product called Navicat Lite; when invoked, it still insists that the > working Sqlite version is 3.7.6.3, and none of the functions I need are > available (instr(), substr(), etc.). Well, that's to be expected. Your version of Navicat Lite either comes with its own version of the sqlite library built in, meaning that nothing you do with sqlite (program or library) elsewhere on your system will affect the version that Navicat Lite has in any way at all, or it uses the sharable sqlite library that also comes with your version of OS X. I wouldn't try to change that version (assuming you know how) as it may be used by a number of system components. Updates of OS X might update that library, or might not. > I am NOT a C/C++ developer, and have no idea on how to update versions of > Sqlite via Mac compilation/make; nor can I find step-by-step instructions > for version updates that preserve the data and sql scripts. As I say, you wouldn't want to. > Where does Sqlite actually reside when installed on a Mac? Depends on what is using it. Some programs may link in a version of the sqlite library, others may use the shareable library. > Any help in resolving the version problem, or suggestions on altering where > Navicat Lite is executing the wrong version, would be very welcome. If it uses a built-in copy of the library, you won't be able to change it. If when running it, it refers to an old version of the sqlite library, then it would seem likely that when Navicat Lite was built, it was linked to a static copy of the library. So, it's frozen in time. Sorry not to be more encouraging. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
