On Wed, Nov 11, 2009 at 08:04:23AM -0800, Peter Haworth scratched on the wall: > The group_concat function works fine in the Firefox SQLite Manager > extension on the same Mac where it fails within sqlite3. Also, the > development software I'm using (Revolution) also rejects the > group_concat function. > > I would have thought that the sqlite code would have been in a central > library somewhere on my machine for any programs that make calls to > it, but based on the above, it seems that each program has it's own > private sqlite library of sqlite calls?
Mac OS X includes a system-wide dynamic (shared) library in /usr/lib. That is also used by the CoreData framework and a few other Apple tools. The included /usr/bin/sqlite3 command line tool dynamically links against the /usr/lib library as well. Most applications (such as Firefox) just compile the SQLite code directly into the application. This is considered the preferred way use SQLite in a larger application where the user never directly interacts with the database. Clearly that's not the case when using the Firefox SQLite Manager, but that's not exactly the normal way of using Firefox. Revolution may be using the system library, or it may just have an older, internal version. You can run the SQL query "SELECT sqlite_version()" to see what code a specific environment is using. As others have pointed out, it is extremely easy to build a new version of the SQLite libs and command line tool if you have the XCode tools installed. The download is a bit big, but they're useful to have around, even if you're not writing a lot of code. The only gotcha is that you want to be sure to install things into /usr/local/bin and /usr/local/lib. Since the /usr/lib stuff is used by some pretty core system OS stuff, I'd leave that alone and just install the newer copy elsewhere. If you use Terminal for a lot of command line work, make sure your PATH is setup to use the correct binary/library. No use installing a new one if you keep using the old one.... -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
