Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Robert L Cochran
That's funny to me...the only other person I know who used the word 'copacetic' was a former team leader in my office, in an email he wrote years ago. I had to check the dictionary to find out what 'copacetic' means. I think it's very funny to see the word used again in a software context. Bob

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread P Kishor
On 3/13/08, Lloyd <[EMAIL PROTECTED]> wrote: > Hi Punkish, > > I think after installing the library, and making the path entry in > the /etc/ld.so.conf (If it is not there), simply running the "ldconfig" > command will serve your need. Ya, thanks. That did it. Knowing nothing about Linux, I

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Lloyd
Hi Punkish, I think after installing the library, and making the path entry in the /etc/ld.so.conf (If it is not there), simply running the "ldconfig" command will serve your need. Regards, Lloyd On Thu, 2008-03-13 at 12:09 -0500, P Kishor wrote: > I am not at all conversant with RH Linux

Re: [sqlite] Weird locking issue Windows XP64 3.5.5

2008-03-13 Thread Teg
Hello Doug, Thursday, March 13, 2008, 4:27:40 PM, you wrote: D> I had something very similar happen. In my case there was a journal file D> that was created by a service, so it had different file rights. My account D> didn't have rights to the journal, but when SQLite saw the journal there and

Re: [sqlite] A few question using sqlite

2008-03-13 Thread Jay A. Kreibich
On Thu, Mar 13, 2008 at 12:41:15PM +0500, Zoltan Bencik scratched on the wall: > Hello, > > Thank you all for answering my questions. > > On Thu, Mar 13, 2008 at 8:23 AM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > > On Wed, Mar 12, 2008 at 11:50:57PM +0500, Zoltan Bencik scratched on the > >

Re: [sqlite] NFS SQLITE problem

2008-03-13 Thread William Yu
Oh my. From all the Googling and documentation, I forgot to do that. Let me try it out. Thanks for the lead. Reply Header Subject:Re: [sqlite] NFS SQLITE problem Author: Dennis Cote <[EMAIL PROTECTED]> Date: March 13th 2008 3:13 pm William

Re: [sqlite] Weird locking issue Windows XP64 3.5.5

2008-03-13 Thread Doug
I had something very similar happen. In my case there was a journal file that was created by a service, so it had different file rights. My account didn't have rights to the journal, but when SQLite saw the journal there and wasn't able to play it back, it reported the database locked error.

Re: [sqlite] REPLACE INTO not increase field value?

2008-03-13 Thread Dennis Cote
zaher dirkey wrote: > Thank for replay, i will use it, but that make the sql slow. > Yes, it is slower than the insert that didn't work correctly. :-) To ensure optimal speed you should have an index for the subselect to use during its search. If the table has a primary key , that would be

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Zbigniew Baniewski
On Thu, Mar 13, 2008 at 02:55:20PM -0500, P Kishor wrote: > right, but for most other programs (and, in fact, as I understand it, > this is the normal behavior for GNU's autoconf), the default behavior > is to put everything that matters under /usr/local... that is, > binaries under

Re: [sqlite] REPLACE INTO not increase field value?

2008-03-13 Thread zaher dirkey
Thank for replay, i will use it, but that make the sql slow. may be SQLite team care about it in next release. On Thu, Mar 13, 2008 at 4:59 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > zaher dirkey wrote: > > REPLACE INTO States > > (Material, Name, Qnt) > > values (1, 'MyName', Qnt + 1) > > > >

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Matthew L. Creech
On Thu, Mar 13, 2008 at 1:09 PM, P Kishor <[EMAIL PROTECTED]> wrote: > I am not at all conversant with RH Linux (RHEL-es3). I have just > compiled sqlite3.5.6 from amalgamation, and I get the error that > libsqlite3.so.0 can't be found. I did the following > > ./configure > make && make

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread P Kishor
On Thu, Mar 13, 2008 at 2:23 PM, Robert L Cochran <[EMAIL PROTECTED]> wrote: > > > Zbigniew Baniewski wrote: > > On Thu, Mar 13, 2008 at 01:03:01PM -0500, P Kishor wrote: > > > > > >> why is it the I had to do the above? Why is LD_LIBRARY_PATH not set > >> automatically? And, since it wasn't

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Robert L Cochran
Zbigniew Baniewski wrote: > On Thu, Mar 13, 2008 at 01:03:01PM -0500, P Kishor wrote: > > >> why is it the I had to do the above? Why is LD_LIBRARY_PATH not set >> automatically? And, since it wasn't set, how come other programs were >> working fine (assuming that other programs in the

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Zbigniew Baniewski
On Thu, Mar 13, 2008 at 01:03:01PM -0500, P Kishor wrote: > why is it the I had to do the above? Why is LD_LIBRARY_PATH not set > automatically? And, since it wasn't set, how come other programs were > working fine (assuming that other programs in the /usr/local/bin space > were looking for libs

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread Robert L Cochran
Did you change your path (in $HOME/.bash_profile) to point to /usr/local/bin, then log out and log back in again? I think the path setting may be the real issue. After changing /etc/ld.so.conf did you run `ldconfig` as root? Thanks Bob Cochran Greenbelt, Maryland, USA P Kishor wrote: > the

Re: [sqlite] Improvment suggestion for "BOOLEAN"-type fields

2008-03-13 Thread Zbigniew Baniewski
On Thu, Mar 13, 2008 at 05:59:54PM +, Brad Stiles wrote: > > Taking into consideration a declared close relativity between SQLite and > > TCL, I would to suggest an improvement in boolean-type fields treatment. > > In my opinion, field of that type should be treated equally, when it does > >

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread P Kishor
the following solved it [01:00 PM] ~$ export LD_LIBRARY_PATH=/usr/local/lib [01:00 PM] ~$ echo $LD_LIBRARY_PATH /usr/local/lib [01:00 PM] ~$ sqlite3 SQLite version 3.5.6 Enter ".help" for instructions sqlite> .q [01:00 PM] ~$ why is it the I had to do the above? Why is LD_LIBRARY_PATH not set

Re: [sqlite] Improvment suggestion for "BOOLEAN"-type fields

2008-03-13 Thread Brad Stiles
> Taking into consideration a declared close relativity between SQLite and > TCL, I would to suggest an improvement in boolean-type fields treatment. > In my opinion, field of that type should be treated equally, when it does > contain a values: "f", "false", 0, "no" - and, respectively: "t",

Re: [sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread P Kishor
fwiw, my /etc/ld.so.conf is like so /usr/kerberos/lib /usr/X11R6/lib /usr/lib/pgsql /usr/lib /usr/local/lib /usr/local/arcsde/sdeexe83/lib /usr/lib/qt-3.1/lib ld.so.conf (END) in other words, /usr/local/lib is in it. On Thu, Mar 13, 2008 at 12:09 PM, P Kishor <[EMAIL PROTECTED]> wrote: > I am

[sqlite] can't find libsqlite3.so.0 on RHEL

2008-03-13 Thread P Kishor
I am not at all conversant with RH Linux (RHEL-es3). I have just compiled sqlite3.5.6 from amalgamation, and I get the error that libsqlite3.so.0 can't be found. I did the following ./configure make && make install sqlite3 is place in /usr/local/bin and libsqlite3.so.0 is placed in

Re: [sqlite] Very large database

2008-03-13 Thread sswensen
Thanks you solved my problem. I was passing null instead of 0 to open_v2. I had looked at the source before but it did not click. Also I had 3 routines in my app each opening the database, doing some work then closing. The first routine using sqlite3_exec the second sqlite_open/prep/step the

[sqlite] Improvment suggestion for "BOOLEAN"-type fields

2008-03-13 Thread Zbigniew Baniewski
Taking into consideration a declared close relativity between SQLite and TCL, I would to suggest an improvement in boolean-type fields treatment. In my opinion, field of that type should be treated equally, when it does contain a values: "f", "false", 0, "no" - and, respectively: "t", "true", 1,

Re: [sqlite] NFS SQLITE problem

2008-03-13 Thread Dennis Cote
William Emmanuel S. Yu wrote: > > I am using CentOS 4.4, nfs-utils 1.0.6-70.EL4 and Linux Kernel > 2.6.9-42.0.2.ELsmp. I am using sqlite3 3.5.6. I compiled sqlite3 from > source. > Have you run the test suite on your self compiled SQLite library? That may point you to some problems. HTH

Re: [sqlite] Very large database

2008-03-13 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > Is there any reason why a database of >20GiB would have problems > being opened with sqlite3_open_v2 or have issues with sqlite3_prepare_v2. No, not really. They oth call the same function to do the work. The following is from the SQLite source: /* ** Open a new

Re: [sqlite] REPLACE INTO not increase field value?

2008-03-13 Thread Dennis Cote
zaher dirkey wrote: > REPLACE INTO States > (Material, Name, Qnt) > values (1, 'MyName', Qnt + 1) > > I want to increase value of Qnt if the record already exist and insert it > with 1 value if not exist, the default value for Qnt is 1 and it is NOT NULL > The default value is only used if you

[sqlite] Weird locking issue Windows XP64 3.5.5

2008-03-13 Thread Teg
Hello All, Just thought I'd report this and see if anyone has any ideas. I'm upgrading to 3.5.6 as I write this just in case. I had a DB file that reported locked in my application. I tried it with Sqlite3.exe and it also reported it was locked. I exited the application, exited the programming

Re: [sqlite] PHP 4 and SQLite3

2008-03-13 Thread Eugene Wee
Hi, This may be something of a non-solution, but you should pressure your host to upgrade to PHP 5 and provide the PDO extension from which you can use SQLite 3. Note that the PHP website (http://www.php.net/downloads.php) states: "Support for PHP 4 has been discontinued since 2007-12-31.

Re: [sqlite] A few question using sqlite

2008-03-13 Thread Zoltan Bencik
Hello, Thank you all for answering my questions. On Thu, Mar 13, 2008 at 8:23 AM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > On Wed, Mar 12, 2008 at 11:50:57PM +0500, Zoltan Bencik scratched on the wall: > > My questions are: > > -- Will be this way of indexing speed up my ordered retrieval