[sqlite] sqlite3 version 3.7.5: documentation of the "-heap" option

2011-01-31 Thread Oliver Peters
in the 3.7.5 releaselog (http://sqlite.org/releaselog/3_7_5.html) it is written that the "-heap" option was added to the CLI but if I follow http://sqlite.org/sqlite.html there is no further explanation. calling doesn't uncover information about this option too Oliver _

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/20/09 10:41 AM, "erfon haubenstock" wrote: > > Hey Jean-Denis! I think you may not have seen my most recent post : D > > I used the link you sent me (i think it was yours) that explained that the > local .bash_login could be overriding my .profile. I copied the contents of > .profile in

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/19/09 11:35 PM, "P Kishor" wrote: > > why make things so difficult for yourself? > > download the amalgamation source code and untar/unzip it somwhere. > > type ./configure followed by make && sudo make install > > this will put your sqlite libraries under /usr/local/ > > type /usr/loc

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread erfon haubenstock
Hey Jean-Denis! I think you may not have seen my most recent post : D I used the link you sent me (i think it was yours) that explained that the local .bash_login could be overriding my .profile. I copied the contents of .profile into my .bash_login and now my port command works just fine! I a

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-20 Thread Jean-Denis Muys
On 3/19/09 11:29 PM, "erfon haubenstock" wrote: > > Hi again. Thanks for trying to help me by the way : D > > I tried relauching terminal and even restarting my computer, but to no > avail. > > I'm not totally sure I understand when you say: > > One common pitfall here is that you must open

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Ok, i think i figured it out, only took me about 8 hours! see the path i had: > $PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sb > > in:/sbin:/usr/local/bin:/usr/X11/bin it's missing the / as the very beginning of the path. i changed it to /usr/local... and no

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread P Kishor
On Thu, Mar 19, 2009 at 6:19 PM, erfon haubenstock wrote: > > ok so macports installed sqlite3 just fine, but how do i check the version? > i think i now have 3 versions of sqlite installed. > > 1 - when i type sqlite3 --version i get version 3.4.0 > 2 - when i type usr/local/bin/sqlite3 --version

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Lawrence Gold
On Mar 19, 2009, at 5:19 PM, erfon haubenstock wrote: > > ok so macports installed sqlite3 just fine, but how do i check the > version? > i think i now have 3 versions of sqlite installed. > > 1 - when i type sqlite3 --version i get version 3.4.0 > 2 - when i type usr/local/bin/sqlite3 --version

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
ok so macports installed sqlite3 just fine, but how do i check the version? i think i now have 3 versions of sqlite installed. 1 - when i type sqlite3 --version i get version 3.4.0 2 - when i type usr/local/bin/sqlite3 --version i get version 3.5.4 3 - I know that macports has installed 3.6.11

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Thanks for pointing me to that piece of the guide. Copying the contents of my .profile into my .bash_login fixed the port command problem i was having : D This is my first experience with paths, .profile, or .bash_login and macports so this has all be quite a learning experience for me. I feel

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Ok, we're getting somewhere now. I typed /usr/local/bin/sqlite3 -version and got 3.6.11. But when i typed sqlite3 --version i get 3.4. So it must be a path issue. This is my first experience with PATH. I know I need to change my path, but I don't know what is missing from it that is giving me

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Lawrence Gold
On Mar 19, 2009, at 4:29 PM, erfon haubenstock wrote: > > Hi again. Thanks for trying to help me by the way : D > > I tried relauching terminal and even restarting my computer, but to no > avail. > > I'm not totally sure I understand when you say: > > One common pitfall here is that you must open

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread P Kishor
On Thu, Mar 19, 2009 at 5:29 PM, erfon haubenstock wrote: > > Hi again.  Thanks for trying to help me by the way : D > > I tried relauching terminal and even restarting my computer, but to no > avail. > > I'm not totally sure I understand when you say: > > One common pitfall here is that you must

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Hi again. Thanks for trying to help me by the way : D I tried relauching terminal and even restarting my computer, but to no avail. I'm not totally sure I understand when you say: One common pitfall here is that you must open a new shell for the port command to be recognised (or re-export the

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 12:20 PM, "erfon haubenstock" wrote: > > EEESH, i installed macports and when i try to port install i get an error > that says the error "port: command not found" > > maybe this has something to do with it? my > $PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
EEESH, i installed macports and when i try to port install i get an error that says the error "port: command not found" maybe this has something to do with it? my $PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin Jean-Denis Muy

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 11:07 AM, "erfon haubenstock" wrote: > > Hello Jean-Denis! I did it manually in terminal. I'm not familiar with > macports or finks. > > Here's the exact code i used: > > $ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx > $ cd sqlite-3.6.11 > $ ./configure --prefix=/u

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
Hello Jean-Denis! I did it manually in terminal. I'm not familiar with macports or finks. Here's the exact code i used: $ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx $ cd sqlite-3.6.11 $ ./configure --prefix=/usr/local $ make $ sudo make install thank you :-) erfon Jean-Denis

Re: [sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread Jean-Denis Muys
On 3/19/09 10:28 AM, "erfon haubenstock" wrote: > > This is really strange. I'm using a mac with leopard which comes with > version 3.4.0 installed. I've installed 3.6.11, and it installs > successfully as far as I can tell, but then when I check the version with > sqlite3 --version in termina

[sqlite] sqlite3 --version showing the wrong version

2009-03-19 Thread erfon haubenstock
This is really strange. I'm using a mac with leopard which comes with version 3.4.0 installed. I've installed 3.6.11, and it installs successfully as far as I can tell, but then when I check the version with sqlite3 --version in terminal, the version is shows that the installed version is STILL

Re: [sqlite] sqlite3 -version

2006-04-12 Thread Dennis Cote
Phuah Yee Keat wrote: Is there any specific reasons that "sqlite3 -version" is returning 1 instead of 0? As I understand, most of the tools return 0 for a -version or --version query. I don't think there is any reason for this. You should file a bug report at http://www.sqlite.org/cvstrac/

[sqlite] sqlite3 -version

2006-04-12 Thread Phuah Yee Keat
Hi, Is there any specific reasons that "sqlite3 -version" is returning 1 instead of 0? I am using sqlite3 -version to store the sqlite3 version in one of my build scripts, inside MAKEFILE, and I have to do "-sqlite3 -version" to get make to ignore the error. As I understand, most of the to