Re: [sqlite] sqlite on mac os x 64 bits
Hello, many thanks for your answer, I tried the command "file" on the current lib that I just built (by ./configure CFLAGS="-DSQLITE_ENABLE_ICU `icu-config --cppflags`" LDFLAGS="`icu-config --ldflags`") it gives: $ file /usr/local/lib/libsqlite3.dylib /usr/local/lib/libsqlite3.dylib: Mach-O 64-bit dynamically linked shared library x86_64 so it is 64 bits by default... this is what I mean, in my opinion. Best regards, Sylvain On Tue, May 18, 2010 at 2:51 PM, Doug Currie wrote: > > On May 18, 2010, at 4:14 AM, Sylvain Pointeau wrote: > > but is it 64 bits? or do I have to add a special option? > > Last time I built a Universal Binary sqlite3 on OS X (March 2010 3.6.22) I > had to > > CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' > ./configure --disable-dependency-tracking > > Without the --disable-dependency-tracking configure gets confused; > alternatively you can > # edit Makefile removing -M options > # basically turning the .c.o and .c.lo rules into > # $(COMPILE) -c -o $@ $< > # $(LTCOMPILE) -c -o $@ $< > > > You can use the file command to reveal the library's compatible machine > architectures, e.g., > > ~ e$ file /usr/local/lib/libsqlite3.dylib > /usr/local/lib/libsqlite3.dylib: Mach-O universal binary with 2 > architectures > /usr/local/lib/libsqlite3.dylib (for architecture i386):Mach-O > dynamically linked shared library i386 > /usr/local/lib/libsqlite3.dylib (for architecture x86_64): Mach-O > 64-bit dynamically linked shared library x86_64 > ~ e$ file /usr/local/lib/libsqlite3.a > /usr/local/lib/libsqlite3.a: Mach-O universal binary with 2 architectures > /usr/local/lib/libsqlite3.a (for architecture i386):current ar archive > random library > /usr/local/lib/libsqlite3.a (for architecture x86_64): current ar archive > random library > ~ e$ > > > e > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite on mac os x 64 bits
On May 18, 2010, at 4:14 AM, Sylvain Pointeau wrote: > but is it 64 bits? or do I have to add a special option? Last time I built a Universal Binary sqlite3 on OS X (March 2010 3.6.22) I had to CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure --disable-dependency-tracking Without the --disable-dependency-tracking configure gets confused; alternatively you can # edit Makefile removing -M options # basically turning the .c.o and .c.lo rules into # $(COMPILE) -c -o $@ $< # $(LTCOMPILE) -c -o $@ $< You can use the file command to reveal the library's compatible machine architectures, e.g., ~ e$ file /usr/local/lib/libsqlite3.dylib /usr/local/lib/libsqlite3.dylib: Mach-O universal binary with 2 architectures /usr/local/lib/libsqlite3.dylib (for architecture i386):Mach-O dynamically linked shared library i386 /usr/local/lib/libsqlite3.dylib (for architecture x86_64): Mach-O 64-bit dynamically linked shared library x86_64 ~ e$ file /usr/local/lib/libsqlite3.a /usr/local/lib/libsqlite3.a: Mach-O universal binary with 2 architectures /usr/local/lib/libsqlite3.a (for architecture i386):current ar archive random library /usr/local/lib/libsqlite3.a (for architecture x86_64): current ar archive random library ~ e$ e ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite on mac os x 64 bits
hello, I am generally doing: ./configure make sudo make install for having sqlite in my /usr/local/ directory. but is it 64 bits? or do I have to add a special option? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite on Mac OS X with PowerPC?
On Thu, Apr 2, 2009 at 2:04 PM, Zobeid Zuma wrote: > I recently tried installing phpBB3 with SQLite on two Macs -- one > Intel-based and the other PPC. > > The Intel Mac worked perfectly, but the PPC machine keeps stalling > out. It's turned into quite a puzzle for me. So. . . I recalled > that SQLite is only available as a binary for Intel-based Macs, and > wondered if there is a reason for that. . .? > > Does it, in fact, work on PPC? Or should I just give that up as a bad > idea? > SQLite works perfectly well on PPC Macs. I use it everyday. Just compile it yourself. -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from Madison, WI, United States ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite on Mac OS X with PowerPC?
I recently tried installing phpBB3 with SQLite on two Macs -- one Intel-based and the other PPC. The Intel Mac worked perfectly, but the PPC machine keeps stalling out. It's turned into quite a puzzle for me. So. . .I recalled that SQLite is only available as a binary for Intel-based Macs, and wondered if there is a reason for that. . .? Does it, in fact, work on PPC? Or should I just give that up as a bad idea? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] SQLite on Mac
Thanks for the heads up. I have studied that and we have decided to go with SQLite, it suits our needs :) Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 11:50 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite on Mac "Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote: > > We are now just making strategic decision as of which database engine to > choose that would give us better cross platform support. > Be sure to visit http://www.sqlite.org/whentouse.html to make sure the SQLite is suited for whatever it is you are wanting to do with your database. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 T&B wrote: > As others have mentioned, yes, SQLite not only runs on a Mac, but it's > already installed as of Mac OS X 10.4 "Tiger" and after. Apple uses it > for indexing email in the Mail application, Core Data in XCode > development, and media management in high end apps like Aperture. You do have to be careful of one thing on the Mac (which has already bitten several people). If you run inside an app, or if your app loads one of the many Apple components using SQLite then you will have versioning issues. For example if the Apple component is loaded first then it loads the system SQLite which is an older version (3.0.8 IIRC) and your attempts to use a new version such as a shared library you linked against will be ignored. You can work around this by using the amalgamation and - -DSQLITE_API=static as noted in http://www.sqlite.org/cvstrac/tktview?tn=2453 (The one unanswered question in that ticket is if there are two different versions of SQLite in the same process, will the thread local storage interfere with each other or is a different key used so they co-exist). Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGoQAvmOOfHg372QQRArl4AJ9mnXK5WbtS3GpSkTCl6XvvKTjQrACffdY2 +ZcJygs3bLRIxm7MEKIN8Qo= =j5X9 -END PGP SIGNATURE- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
"Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote: > > We are now just making strategic decision as of which database engine to > choose that would give us better cross platform support. > Be sure to visit http://www.sqlite.org/whentouse.html to make sure the SQLite is suited for whatever it is you are wanting to do with your database. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] SQLite on Mac
Thanks guys for the informative replies :) We are now just making strategic decision as of which database engine to choose that would give us better cross platform support. And with such a wonderful tech/community support, I believe SQLite is the right answer :) Cheers -Original Message- From: T&B [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 12:08 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite on Mac Hi Ahmed, > Does SQLite work on Mac, and if yes, is there any Mac enabled version > that I could download? As others have mentioned, yes, SQLite not only runs on a Mac, but it's already installed as of Mac OS X 10.4 "Tiger" and after. Apple uses it for indexing email in the Mail application, Core Data in XCode development, and media management in high end apps like Aperture. If you have an earlier Mac OS X version, or want the very latest SQLite version, you can download it from the first link under the "Source Code" heading at: http://www.sqlite.org/download.html You'll need the Apple Developer Tools installed on your computer, which comes free with your computer or Mac OS X install discs, to compile and install it in about four steps. To try it out, launch the Terminal program (already in your / Applications/Utilities folder) and type: sqlite3 MyTestDatabase then in the sqlite3 shell, type any sqlite commands, such as: .help .quit create table MyTestTable( Name text, Age integer); and so on. There is also a range of GUI apps for the Mac for editing SQLite databases. Reply here if you need more info. Tom - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
Hi Ahmed, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? As others have mentioned, yes, SQLite not only runs on a Mac, but it's already installed as of Mac OS X 10.4 "Tiger" and after. Apple uses it for indexing email in the Mail application, Core Data in XCode development, and media management in high end apps like Aperture. If you have an earlier Mac OS X version, or want the very latest SQLite version, you can download it from the first link under the "Source Code" heading at: http://www.sqlite.org/download.html You'll need the Apple Developer Tools installed on your computer, which comes free with your computer or Mac OS X install discs, to compile and install it in about four steps. To try it out, launch the Terminal program (already in your / Applications/Utilities folder) and type: sqlite3 MyTestDatabase then in the sqlite3 shell, type any sqlite commands, such as: .help .quit create table MyTestTable( Name text, Age integer); and so on. There is also a range of GUI apps for the Mac for editing SQLite databases. Reply here if you need more info. Tom - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
On Jul 19, 2007, at 8:45 AM, Ahmed Sulaiman wrote: Hi all, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? SQLite is part of MacOS X. Try typing sqlite3 at the command line... Kasper Cheers -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
On Jul 19, 2007, at 11:45 AM, Ahmed Sulaiman wrote: Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? SQLite is built-in on Tiger (10.4.x)... no installation is required. pete - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
"Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote: > Hi all, > > Does SQLite work on Mac, SQLite is built into the Mac. Apple uses it for many of the applications that come on the mac, such as the email reader and safari. Just open up a terminal window and type "sqlite3" and you will see. SQLite also compiles out-of-the-box on mac. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
At 11:45 AM -0400 7/19/07, Ahmed Sulaiman wrote: Hi all, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? Cheers SQLite just works on Mac OS X. If you have the Mac OS X Developer Tools intalled, you can just compile the normal SQLite source distro and it will work. Otherwise, if you have Mac OS X 10.4 Tiger or later, a version of SQLite is also built-in as part of "Core Data". -- Darren Duncan - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
On 19 Jul 2007, at 16:45, Ahmed Sulaiman wrote: Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? SQLite is used on the Mac natively - for example Mail.app uses a SQLite DB to keep its message data straight. Try the sqlite3 shell command. Nigel. -- [ Nigel Metheringham [EMAIL PROTECTED] ] [ - Comments in this message are my own and not ITO opinion/policy - ] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
Hi On 7/19/07, Ahmed Sulaiman <[EMAIL PROTECTED]> wrote: Hi all, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? While there are fink and darwin ports, I would suggest you to compile it from scratch. It should work well. In my case I just needed to deactivate TCL bindings. Cheers Alberto -- Alberto Simões - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] SQLite on Mac
> -Original Message- > From: Ahmed Sulaiman [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 19, 2007 8:46 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite on Mac > > Hi all, > > Does SQLite work on Mac, and if yes, is there any Mac enabled version > that I could download? There's no need to download it; Apple includes a version, and uses it. If you need a more recent version, you can build from source. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite on Mac
On 7/19/07, Ahmed Sulaiman <[EMAIL PROTECTED]> wrote: Hi all, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? you must be new here, as they say on ./ Yes, SQLite works just fine on Mac. Just type the words Mac and SQLite in Google. -- 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/ S&T Policy Fellow, National Academy of Sciences http://www.nas.edu/ - collaborate, communicate, compete = - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] SQLite on Mac
Hi all, Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? Cheers - To unsubscribe, send email to [EMAIL PROTECTED] -
