Re: [sqlite] SQLite and OS X - Can I have multiple versions?

2008-01-28 Thread Carl Gundel


drh-2 wrote:
> 
> "P Kishor" <[EMAIL PROTECTED]> wrote:
>> 
>> Most folks though install their own version of SQLite under the
>> /usr/local tree ...
> 
> Why do people feel like they need SQLite to be a seperately
> library?  It is *designed* to be statically linked.
Yes, but not everyone uses C/C++.  Run BASIC is written in Smalltalk which
is a VM-based language like Java, so it cannot link statically to SQLite.

Thanks,

-Carl Gundel
http://www.runbasic.com
-- 
View this message in context: 
http://www.nabble.com/SQLite-and-OS-X---Can-I-have-multiple-versions--tp15145894p15146642.html
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] SQLite and OS X - Can I have multiple versions?

2008-01-28 Thread P Kishor
On 1/28/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "P Kishor" <[EMAIL PROTECTED]> wrote:
> >
> > Most folks though install their own version of SQLite under the
> > /usr/local tree ...
>
> Why do people feel like they need SQLite to be a seperately
> library?  It is *designed* to be statically linked.
>

disclaimer: All my use for SQLite thus far has been via Perl DBI and
DBD::SQLite, and SQLite is indeed bolted into DBD::SQLite.

Puneet.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] SQLite and OS X - Can I have multiple versions?

2008-01-28 Thread Rick Langschultz
What I did was used the SQLite sources and added them into a Carbon  
framework. Then set sqlite3.h and the other source header to public.  
That way I could call the functions. Then i set the installation path  
to @executable_path/../Frameworks, then added a new copy phase and  
copied the target to the Frameworks folder. It really works well, and  
you don't have to worry about installing the libraries in /usr/lib or  
wherever when distributing your library.



On Jan 28, 2008, at 3:29 PM, Carl Gundel wrote:



As I understand it, Apple's Mac OS X comes with SQLite as part of  
its Mail
app.  Is there some way to leverage this to avoid distributing  
SQLite with

Mac apps?  Has anyone tried this, or is it a bad idea?

I'm assuming that I can have my own copy of SQLite packaged with my  
OS X
application and it will not conflict with the version that Apple  
ships?


Thanks,

-Carl Gundel
http://www.runbasic.com
--
View this message in context: 
http://www.nabble.com/SQLite-and-OS-X---Can-I-have-multiple-versions--tp15145894p15145894.html
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-





smime.p7s
Description: S/MIME cryptographic signature


Re: [sqlite] SQLite and OS X - Can I have multiple versions?

2008-01-28 Thread drh
"P Kishor" <[EMAIL PROTECTED]> wrote:
> 
> Most folks though install their own version of SQLite under the
> /usr/local tree ...

Why do people feel like they need SQLite to be a seperately
library?  It is *designed* to be statically linked.

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] SQLite and OS X - Can I have multiple versions?

2008-01-28 Thread P Kishor
On 1/28/08, Carl Gundel <[EMAIL PROTECTED]> wrote:
>
> As I understand it, Apple's Mac OS X comes with SQLite as part of its Mail
> app.

It is not so much that "OS X comes with SQLite" as part of its
Mail.app. It is more like OS X allows one to create persistent data
stores using multiple technologies... one of them is SQLite compatible
SQL tables. It does come with SQLite, the shell program residing under
/usr/bin, which on my Leopard system is version 3.4.0. Its supporting
libraries are likewise in system-specific locations.

> Is there some way to leverage this to avoid distributing SQLite with
> Mac apps?  Has anyone tried this, or is it a bad idea?
>
> I'm assuming that I can have my own copy of SQLite packaged with my OS X
> application and it will not conflict with the version that Apple ships?
>

You can have gazillion copies of SQLite on your computer, and as long
as you install the libraries in different locations, and remember to
call them from those different locations, they wouldn't affect each
other.

Most folks though install their own version of SQLite under the
/usr/local tree thereby not only being able to customize their SQLite
experience but also to ensure that they don't clobber any system
related thing accidentally.

Puneet.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-