Re: [sqlite] Sqlite3 in MAC OS

2007-03-01 Thread

Hi Kirrthana,

Im developing an application using sqlite3 in MAC OS,I just wanted  
to know wheather sqlite3 can be used in MAC OS.


Yes. It's already built in. Mac OS X 10.4 includes SQLite version  
3.1.3. And you can easily install the latest version 3.3.13 by  
following the instructions at:

http://www.sqlite.org/download.html

Or specifically:

1. Ensure that you have the developer tools installed. They come with  
the Mac OS, on a separate DVD.


2. Download the latest SQLite, currently: http://www.sqlite.org/ 
sqlite-3.3.13.tar.gz


3. Double click on the .tar file. It will create a sqlite-3.3.13 folder.

4. Launch "Terminal" (double click it in /Applications/Utilities).

5. Type "cd " (without the quotes) and drag your expanded folder  
(from step 3) into the Terminal window. Hit return.


6. type: ./configure  (And hit return)

7. type: make  (And hit return)

8. type: sudo make install (And hit return. Enter your password when  
asked.)


Then you can access the new C libraries and the new sqlite3 command  
line tool. To access the new (rather than the old) sqlite3 command,  
specify the full path: /usr/local/bin/sqlite3


There are of course several GUI programs for Mac OS which usually  
include their own compiled SQLite code. You just double click them  
like any other Mac app. For example:


http://www.sqlabs.net/sqlitemanager.php
http://www.software-by-mabe.com/software/freeware.html#sqlitequery
http://sqlitebrowser.sourceforge.net/
http://sqlitecc.sourceforge.net/

There is also a bunch of other programs that use SQLite for their own  
data storage, such as Apple's own Mail program (for mail indexing),  
and the "Core Data" data storage mechanism for developers to include  
in their own software.


If so can the same sqlite3 library and the executable used in  
windows can be used in MAC OS or a

different version has to be used.


Same source, and same result of running the code. But since it's a  
different platform, it has different compiled binaries.


Tom


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



Re: [sqlite] Sqlite3 in MAC Os

2007-02-26 Thread P Kishor

On 2/26/07, Kirrthana M <[EMAIL PROTECTED]> wrote:

Hi everybody,
Im developing an application using sqlite3 in MAC OS,I just wanted to
know wheather sqlite3 can be used in MAC OS.


yes. You can use coredata capabilities built into Tiger (but that will
give you an older version of SQLite compatibility) or you can compile
your own from the latest source code.


If so can the same sqlite3
library and the executable used in windows can be used in MAC OS or a
different version has to be used.



different. You will have to get/compile platform-specific library and
shell program. The data that you create, however, will be compatible
across Macs and Windows as long as you use reasonably similar versions
of SQLite on all machines.

--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=

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



Re: [sqlite] Sqlite3 in MAC Os

2007-02-26 Thread Martin Jenkins

Kirrthana M wrote:

Im developing an application using sqlite3 in MAC OS,I just wanted to
know wheather sqlite3 can be used in MAC OS.


I don't use Mac, but I *think* SQLite is bundled with later versions.


If so can the same sqlite3 library and the executable used in windows
can be used in MAC OS or a different version has to be used.


Pretty unlikely I'd have thought, unless your Mac is x86 based and MacOS 
has a Windows emulation layer. You'll probably have to build from source 
unless you can find a site with pre-built binaries.


As I said, I don't use Mac so the above is TTBOMK.

Martin



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



[sqlite] Sqlite3 in MAC Os

2007-02-25 Thread Kirrthana M
Hi everybody,
Im developing an application using sqlite3 in MAC OS,I just wanted to
know wheather sqlite3 can be used in MAC OS.If so can the same sqlite3
library and the executable used in windows can be used in MAC OS or a
different version has to be used.

Regards,
Kirrthana