Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread BareFeet 
Hi Matt,

> It appears to open, but it just spits out another compressed file,  
> over and over -- like a cruel Matryoshka doll on my desktop.
>
> The file in question: http://www.sqlite.org/sqlite3-3.6.17-osx-x86.bin.gz

Yes, it is annoying. I've mentioned the problem here before. I think  
DRH said he'd fix this, but I guess hasn't yet. The .gz file  
decompresses OK into a .bin file. But this name extension implies a  
MacBinary file, which the Mac attempts to decompress again, and again.

Once you've decompressed the .gz file, just rename the .bin file to  
"sqlite3", set execute permission (if not already) and move it to /usr/ 
local/bin/sqlite3.

Tom
BareFeet

  --
Comparison of SQLite GUI applications:
http://www.tandb.com.au/sqlite/compare/?ml



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread Adam Swift 

On Aug 26, 2009, at 7:03 AM, Simon Slavin wrote:

>
> On 26 Aug 2009, at 1:27pm, P Kishor wrote:
>
>> However, on a Mac you don't really want this. Just download the  
>> source
>> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
>> gunzip it, run make, make install, and it will install all the bits
>> and bobs for you in the right place.
>
> Actually, on a Mac you might not need that either.  You will find
> sqlite already installed in various places including
>
> /usr/include/sqlite3.h
> /usr/include/sqlite3ext.h
> /usr/lib/libsqlite3.0.8.6.dylib
> /usr/lib/libsqlite3.0.dylib
> /usr/lib/libsqlite3.dylib
> /usr/lib/sqlite3
> /usr/lib/sqlite3/libtclsqlite3.dylib
> /usr/lib/sqlite3/pkgIndex.tcl
> /usr/share/man/man1/sqlite3.1.gz
>
> unless you specifically need a later version than 3.0.8.6 .  If you
> do, make sure your own installation does not overwrite the existing
> one since this may upset the various system components that use it.
>
Point of clarification - the sqlite shared library that comes  
preinstalled on a mac has 2 oddly _named_ variants:  
libsqlite3.0.8.6.dylib (a symlink) and libsqlite3.0.dylib (the actual  
library).  This is due to the way the sqlite autoconf/Makefile build  
resources are configured to name the library.  The actual version of  
the sqlite library installed on Mac OS X 10.5 (Leopard) is 3.4.0

If you don't _need_ access to newer features of sqlite for your  
application it is highly recommended that you use the pre-installed  
shared library since it has been qualified to work well with the  
hardware, file systems and operating systems supported by the mac.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread Simon Slavin 

On 26 Aug 2009, at 5:43pm, P Kishor wrote:

> Why would you want to use the factory installed stuff when installing
> your own and mucking around with your own version is so easy

Because you can give your resulting software to anyone else using a  
Mac and know any tools they have will be able to access the databases.

But yes, if you're just using your own software and manipulating your  
own data then it doesn't matter.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread P Kishor 
On Wed, Aug 26, 2009 at 9:03 AM, Simon
Slavin wrote:
>
> On 26 Aug 2009, at 1:27pm, P Kishor wrote:
>
>> However, on a Mac you don't really want this. Just download the source
>> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
>> gunzip it, run make, make install, and it will install all the bits
>> and bobs for you in the right place.
>
> Actually, on a Mac you might not need that either.  You will find sqlite
> already installed in various places including
>
> /usr/include/sqlite3.h
> /usr/include/sqlite3ext.h
> /usr/lib/libsqlite3.0.8.6.dylib
> /usr/lib/libsqlite3.0.dylib
> /usr/lib/libsqlite3.dylib
> /usr/lib/sqlite3
> /usr/lib/sqlite3/libtclsqlite3.dylib
> /usr/lib/sqlite3/pkgIndex.tcl
> /usr/share/man/man1/sqlite3.1.gz
>
> unless you specifically need a later version than 3.0.8.6 .  If you do, make
> sure your own installation does not overwrite the existing one since this
> may upset the various system components that use it.
>


Why would you want to use the factory installed stuff when installing
your own and mucking around with your own version is so easy? If you
make, make install, your installed version will automatically go into
/usr/local/ without messing around with factory installed stuff.


-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
Sent from Madison, WI, United States
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread Simon Slavin 

On 26 Aug 2009, at 1:27pm, P Kishor wrote:

> However, on a Mac you don't really want this. Just download the source
> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
> gunzip it, run make, make install, and it will install all the bits
> and bobs for you in the right place.

Actually, on a Mac you might not need that either.  You will find  
sqlite already installed in various places including

/usr/include/sqlite3.h
/usr/include/sqlite3ext.h
/usr/lib/libsqlite3.0.8.6.dylib
/usr/lib/libsqlite3.0.dylib
/usr/lib/libsqlite3.dylib
/usr/lib/sqlite3
/usr/lib/sqlite3/libtclsqlite3.dylib
/usr/lib/sqlite3/pkgIndex.tcl
/usr/share/man/man1/sqlite3.1.gz

unless you specifically need a later version than 3.0.8.6 .  If you  
do, make sure your own installation does not overwrite the existing  
one since this may upset the various system components that use it.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread John Machin 
On 26/08/2009 5:47 AM, Matt Stiles wrote:
> Am I losing my mind, or is there something wrong with the bin.gz file on the
> download page? I've downloaded it several times, but I can't get it to open
> completely using Stuffit or the Mac archive utility. It appears to open, but
> it just spits out another compressed file, over and over -- like a cruel
> Matryoshka doll on my desktop.
> 
> The file in question: http://www.sqlite.org/sqlite3-3.6.17-osx-x86.bin.gz

I can open this on Windows XP with the "7-Zip" 3rd-party utility. As 
expected of a foo.bin.gz file, it decompresses to a foo.bin file. 7zip 
can even open that; it says there are a bunch of __TEXT__ things, some 
__DATA__ things, and 2 __IMPORT__ things ... looks superficially not 
unlike an executable to me.

Doesn't the Mac OS have a "gunzip" program? I have one from the mingw32 
project or similar collection of Windows ports of *x programs:

C:\installers>gunzip -l sqlite3-3.6.17-osx-x86.bin.gz
compressed  uncompr. ratio uncompressed_name
258707510012  49.2% sqlite3-3.6.17-osx-x86.bin

C:\installers>gunzip -tv sqlite3-3.6.17-osx-x86.bin.gz
sqlite3-3.6.17-osx-x86.bin.gz:   OK

C:\installers>gunzip -V
gunzip 1.2.4 (18 Aug 93)
Compilation options:
DIRENT SYS_UTIME STDC_HEADERS HAVE_UNISTD_H NO_CHOWN PROTO ASMV

So that's two independent witnesses to the file on the website being an 
OK gzip file, and one that the inner file appears to be an uncompressed 
executable.  How did you obtain it -- http or ftp? Have you checked the 
compressed file size (I have 258707 (see above))?

What version of OS X are you running?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trouble with precompiled binaries for MacOS X

2009-08-26 Thread P Kishor 
On Tue, Aug 25, 2009 at 2:47 PM, Matt Stiles wrote:
> Am I losing my mind, or is there something wrong with the bin.gz file on the
> download page? I've downloaded it several times, but I can't get it to open
> completely using Stuffit or the Mac archive utility. It appears to open, but
> it just spits out another compressed file, over and over -- like a cruel
> Matryoshka doll on my desktop.
>
> The file in question: http://www.sqlite.org/sqlite3-3.6.17-osx-x86.bin.gz
>

If you gunzip the above file, it will result in
sqlite3-3.6.17-osx-x86.bin. This is the sqlite3 shell program. If you
set its executable bit with 'chmod +x', you can run this file and get
sqlite3.

However, on a Mac you don't really want this. Just download the source
code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar.gz,
gunzip it, run make, make install, and it will install all the bits
and bobs for you in the right place.


> Thanks in advance.
>
> Matt
>
> --
>
> Matt Stiles
> Reporter, Texas Tribune 
> Email: msti...@texastribune.org
> Mobile: 512.965.5197
> [image: Youtube] [image:
> Facebook][image:
> Twitter] 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
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] trouble with precompiled binaries for MacOS X

2009-08-26 Thread Matt Stiles 
Am I losing my mind, or is there something wrong with the bin.gz file on the
download page? I've downloaded it several times, but I can't get it to open
completely using Stuffit or the Mac archive utility. It appears to open, but
it just spits out another compressed file, over and over -- like a cruel
Matryoshka doll on my desktop.

The file in question: http://www.sqlite.org/sqlite3-3.6.17-osx-x86.bin.gz

Thanks in advance.

Matt

--

Matt Stiles
Reporter, Texas Tribune 
Email: msti...@texastribune.org
Mobile: 512.965.5197
[image: Youtube] [image:
Facebook][image:
Twitter] 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users