Re: [sqlite] Legal to use sqlite docs in commercial applications ?

2004-12-01 Thread George Ionescu
Hello Dr. Hipp, sorry for the second repost. I've had some problems with mailing lists and I didn't notice my message actually arrived and that I've even got a reply. > I have no objection to you using the parts that I wrote. But bare > in mind that many others have contributed to the documentat

[sqlite] Legal to use sqlite docs in commercial applications ?

2004-12-01 Thread George Ionescu
Hello Dr. Hipp, Hello sqlite users, I would like to know if it's legal to use sqlite documentation (sql syntax, sqlite logo etc.) into commercial applications' documentation (which are obviously built on top of sqlite). Thanks. Regards, George Ionescu

Re: [sqlite] Sqlite Binding

2004-12-01 Thread D. Richard Hipp
Randall Fox wrote: > [I]s there any chance of allowing the '?' use in a create table > statement as well? For binding of default values of a particular > column. > Not much. Recall that SQLite stores the original text of the CREATE TABLE statement in the SQLITE_MASTER table and reparses that text

Re: [sqlite] Why does my query take so long

2004-12-01 Thread Dennis Cote
Ulrik Petersen wrote: > Hi, > >> Hi, I am having a problem with the following query. It seems to >> force php to timeout after 30secs. The query goes through 150K >> records. Is there anything I can do to speed it up? >> >> code- >> SELECT call_id, C.extn_no

[sqlite] Sqlite Binding

2004-12-01 Thread Randall Fox
On Wed, 01 Dec 2004 16:35:48 -0500, you wrote: >I have lately noticed a need for an "IS" operator in SQLite. >IS would work just like "=" for most things. The difference >is that "IS" would compares NULLs as equals. There would, >of course, need to be a corresponding "IS NOT" operator. > >You ca

Re: [sqlite] SQL "IS" operator.

2004-12-01 Thread Grzegorz Makarewicz
Brass Tilde wrote: You can already us the IS operator with a right-hand side of NULL. For example: "x IS NULL" or "x IS NOT NULL". What I am proposing is to expand IS so that the right-hand side can be an arbitrary expression. Like this: "x IS 5" or "x IS NOT y". The motivation for this change

RE: [sqlite] SQL "IS" operator.

2004-12-01 Thread Brass Tilde
> You can already us the IS operator with a right-hand side > of NULL. For example: "x IS NULL" or "x IS NOT NULL". What > I am proposing is to expand IS so that the right-hand side > can be an arbitrary expression. Like this: "x IS 5" or > "x IS NOT y". > > The motivation for this change is

Re: [sqlite] SQL "IS" operator. Was: field=null vs. field isnull

2004-12-01 Thread Ara.T.Howard
On Wed, 1 Dec 2004, D. Richard Hipp wrote: I have lately noticed a need for an "IS" operator in SQLite. IS would work just like "=" for most things. The difference is that "IS" would compares NULLs as equals. There would, of course, need to be a corresponding "IS NOT" operator. You can already us

Re: [sqlite] sqlite shell

2004-12-01 Thread Mateusz Łoskot
User D. Richard Hipp wrote:: Mateusz Łoskot wrote: I wonder if there is any plan of development sqlite shell? I have some small list of new features I would like to add to the "sqlshell" (SQLiteSHELL ;-) but I would like to know it there is some roadmap or sth about that. I'm sure the command-line

Re: [sqlite] sqlite shell

2004-12-01 Thread D. Richard Hipp
Mateusz Łoskot wrote: I wonder if there is any plan of development sqlite shell? I have some small list of new features I would like to add to the "sqlshell" (SQLiteSHELL ;-) but I would like to know it there is some roadmap or sth about that. I'm sure the command-line shell will be improved from t

[sqlite] sqlite shell

2004-12-01 Thread Mateusz Łoskot
Hello, I wonder if there is any plan of development sqlite shell? I have some small list of new features I would like to add to the "sqlshell" (SQLiteSHELL ;-) but I would like to know it there is some roadmap or sth about that. Best regards -- Mateusz Łoskot, mateusz (at) loskot (dot) net Register

[sqlite] SQL "IS" operator. Was: field=null vs. field isnull

2004-12-01 Thread D. Richard Hipp
I have lately noticed a need for an "IS" operator in SQLite. IS would work just like "=" for most things. The difference is that "IS" would compares NULLs as equals. There would, of course, need to be a corresponding "IS NOT" operator. You can already us the IS operator with a right-hand side of

[sqlite] benchmarking SQL queries

2004-12-01 Thread Eli Burke
I've read through pretty much everything available on sqlite.org, including Dr. Hipp's helpful slides from the 2004 International PHP conference (slides 56-58), but I still feel like I'm stumbling around in the dark when it comes to writing optimizedl SQL queries (specifically, SELECTS + JOINS).

[sqlite] pragma allbytes; pragma locks_block;

2004-12-01 Thread Ara.T.Howard
every month or so someone seems to write in with 'database locked' questions. is there any good reason a pragma could not be added to lock the file in a blocking fashion (pragma locks_block) lock the whole file vs. byte range locking (pragma allbytes) ?? i realize this yields lower performance

Re: [sqlite] field=null vs. field isnull

2004-12-01 Thread Ara.T.Howard
On Wed, 1 Dec 2004, Brass Tilde wrote: i've read the 'null handling' section and still not found the answer to this question: why should 'select * from tbl where field=null' be any different from 'select * from tbl where field isnull' The short answer is "because it's different". A

Re: [sqlite] Legal to use sqlite docs in commercial applications?

2004-12-01 Thread D. Richard Hipp
George Ionescu wrote: Hello Dr. Hipp, Hello sqlite users, I would like to know if it's legal to use sqlite documentation (sql syntax, sqlite logo etc.) into commercial applications' documentation (which are obviously built on top of sqlite). I have no objection to you using the parts that I wrot

Re: [sqlite] %Q in sqlite3_mprintf

2004-12-01 Thread D. Richard Hipp
Randall Randall wrote: I notice that the "%Q" option for sqlite3_mprintf no longer appears in the documentation, but still works as of 3.0.8. Is this now deprecated, or is there some other reason for omitting it? Must be an oversight. SQLite uses %Q internally so it isn't likely to go away anytim

Re: [sqlite] This is a test...

2004-12-01 Thread D. Richard Hipp
Ralph Wetzel wrote: ... to check if the SQLite Mailinglist is down?? Disregard if not down ;-) I got back from a business trip this afternoon (Wed) and noticed that I hadn't seen any SQLite mail for a couple of days. So I logged onto www.sqlite.org and reset the qmail daemon. That seemed to clear

RE: [sqlite] Tools for sqlite ver 3

2004-12-01 Thread Griggs, Donald
Amir, Regarding: Are there any tools like sqliteplus that work with version 3? Not sure what platform you need, but SqliteExplorer http://www.sqlite.org/contrib And SqliteCC (Control Center) http://home.student.uu.se/frax0795/ Look for sqlitecc-api3-exe.zip and you must a

Re: [sqlite] field=null vs. field isnull

2004-12-01 Thread Eric Bohlman
Ara.T.Howard wrote: i've read the 'null handling' section and still not found the answer to this question: why should 'select * from tbl where field=null' be any different from 'select * from tbl where field isnull' Because the SQL standard says so. By definition, a null never compar

[sqlite] SQLite ( old and new ) and QNX

2004-12-01 Thread Adlai Shawareb
Hi, I am using the latest version of QNX (6.3.0). I got SQLite 2.7.3 from the QNX web site. I would prefer to use SQLite3, and I'm wondering if there is anything I unique to QNX that was done for SQLite 2.7.3 that I would need to do to make SQLite3 work. I am thinking of malloc calls, or anythi

Re: [sqlite] field=null vs. field isnull

2004-12-01 Thread Brass Tilde
> i've read the 'null handling' section and still not found the answer to this > question: > >why should > > 'select * from tbl where field=null' > >be any different from > > 'select * from tbl where field isnull' The short answer is "because it's different". A longer answer wou

Re: [sqlite] Help compiling sqlite2

2004-12-01 Thread Ulrik Petersen
Hi, > Hi, > > I need to compile sqlite 2.8.15 under Linux and an other UNIX platform > with THREAD_SAFE, NDEBUG and -DTEMP_STORE=3 enabled. > If I write something like: > > ./configure --enable-tempdb-in-ram=always > > I can see in the makefile that -DTEMP_STORE is defined as 3. > But what about T

Re: [sqlite] Why does my query take so long

2004-12-01 Thread Ulrik Petersen
Hi, > Hi, I am having a problem with the following query. It seems to force php > to timeout after 30secs. The query goes through 150K records. Is there > anything I can do to speed it up? > > code- > SELECT call_id, C.extn_no AS extn_no, dest, dest_name, ca

[sqlite] %Q in sqlite3_mprintf

2004-12-01 Thread Randall Randall
I notice that the "%Q" option for sqlite3_mprintf no longer appears in the documentation, but still works as of 3.0.8. Is this now deprecated, or is there some other reason for omitting it? -- Randall Randall <[EMAIL PROTECTED]> Property law should use #'EQ , not #'EQUAL .

[sqlite] Help compiling sqlite2

2004-12-01 Thread Marco Bambini
Hi, I need to compile sqlite 2.8.15 under Linux and an other UNIX platform with THREAD_SAFE, NDEBUG and -DTEMP_STORE=3 enabled. If I write something like: ./configure --enable-tempdb-in-ram=always I can see in the makefile that -DTEMP_STORE is defined as 3. But what about THREAD_SAFE and NDEBUG?

Re: [sqlite] sqlite-GUI - under linux

2004-12-01 Thread Maurício M. Maia
A web based tool, like phpmyadmin: http://sourceforge.net/projects/sqlitemanager/ --- ajit mote <[EMAIL PROTECTED]> escreveu: > hello freind's , > i am using sqlite on terminal .. > any download version under linux which > is availabale in GUI .. > >

Re: [sqlite] Locking database

2004-12-01 Thread Ara.T.Howard
On Wed, 1 Dec 2004, Alexander Jordanov wrote: this is getting a bit of off thread so if anyone is annoyed please speak up. I can't really make that because in PHP i can't set a global variable that will be available for anyone that uses the script. If i set a variable and change it in the script th

Re: [sqlite] Locking database

2004-12-01 Thread Alexander Jordanov
> make every single sql execution follow this logic > >die 'nested lock' if global_recursion_flag > >global_recursion_flag = true > > ret = flock 'db.lock', LOCK_EX > die 'lock failed' unless ret > > result = execute sql > > ret = flock 'db.lock', LOCK_UN > die

[sqlite] This is a test...

2004-12-01 Thread Ralph Wetzel
... to check if the SQLite Mailinglist is down?? Disregard if not down ;-) Greetings, Ralph

[sqlite] field=null vs. field isnull

2004-12-01 Thread Ara.T.Howard
i've read the 'null handling' section and still not found the answer to this question: why should 'select * from tbl where field=null' be any different from 'select * from tbl where field isnull' using 2.8.15 it seems to be: jib:~ > sqlite db 'create table tbl(field); insert into tbl

[sqlite] Tools for sqlite ver 3

2004-12-01 Thread Amir Hadar
Hi Are there any tools like sqliteplus that work with version 3? Amir Hadar Software Engineer tel: +972.9.7476668 fax: +972.9.7476600 mobile: +972.52.8550201 email: [EMAIL PROTECTED] IXI Mobile Inc. **

[sqlite] Help compiling sqlite2

2004-12-01 Thread Marco Bambini
Hi, I need to compile sqlite 2.8.15 under Linux and an other UNIX platform with THREAD_SAFE, NDEBUG and -DTEMP_STORE=3 enabled. If I write something like: ./configure --enable-tempdb-in-ram=always I can see in the makefile that -DTEMP_STORE is defined as 3. But what about THREAD_SAFE and NDEBUG?

[sqlite] new sqlite user - need help

2004-12-01 Thread ajit mote
  hello friend's , i want to know that hpw to convert tables from msexcel to sqlite... i am new for sqlite and wanna shift from window's , hoping Ustand my problem.. thanking u.

[sqlite] Why does my query take so long

2004-12-01 Thread Lloyd Thomas
Hi, I am having a problem with the following query. It seems to force php to timeout after 30secs. The query goes through 150K records. Is there anything I can do to speed it up? code- SELECT call_id, C.extn_no AS extn_no, dest, dest_name, call_time, durat

Re: [sqlite] Locking database

2004-12-01 Thread Ara.T.Howard
On Tue, 30 Nov 2004, Alexander Jordanov wrote: I am 100% sure that my all my queries go trought that class. Unfortunatelly it is too late to make such changes ('forces the user to specify whether the transaction is write or read') - i have too many scripts to change. make every single sql executio

Re: [sqlite] Locking database

2004-12-01 Thread Alexander Jordanov
I am 100% sure that my all my queries go trought that class. Unfortunatelly it is too late to make such changes ('forces the user to specify whether the transaction is write or read') - i have too many scripts to change. About NFS i asked the hosting and they said they dont use NFS. Do you or someo

Re: [sqlite] Locking database

2004-12-01 Thread Ara.T.Howard
On Wed, 24 Nov 2004, Alexander Jordanov wrote: @Ara.T.Howard: Thanks for the suggestion i will try it and hope the database will not lock again... Here is what i did: clearstatcache (); if ($sql[0]=='S'){ $fp=fopen('koral.db.lock','a+');

[sqlite] Why does my query take so long

2004-12-01 Thread Lloyd Thomas
Hi, I am having a problem with the following query. It seems to force php to timeout after 30secs. The query goes through 150K records. Is there anything I can do to speed it up? code- SELECT call_id, C.extn_no AS extn_no, dest, dest_name, call_time, durat

[sqlite] how to convert mysql database to sqlite?

2004-12-01 Thread ajit mote
  hello friend's, i am new user for linux , shifting from windows ... using sqlite for my project... i developed database in mysql and wanna it on sqlite.. please give me solution for this .. Thanking u all. ajit mote.

[sqlite] Legal to use sqlite docs in commercial applications?

2004-12-01 Thread George Ionescu
Hello Dr. Hipp, Hello sqlite users, I would like to know if it's legal to use sqlite documentation (sql syntax, sqlite logo etc.) into commercial applications' documentation (which are obviously built on top of sqlite). Thanks. Regards, George Ionescu

[sqlite] hi- how to convert text file to sqlite tables?

2004-12-01 Thread ajit mote
  hello freind's, i am really thankful to sqlite users .. now i got the information for crating and all basic things... i want to know that HOW TO CONVERT TEXT FILE INTO SQLITE TABLES? I HAVE SMALL DATABASE BUT THE ENTRIES ARE LARGE AND HECTIC TO ENTER MANUALL

Re: [sqlite] Locking database

2004-12-01 Thread Alexander Jordanov
Unfortunately i don't have access to lsof or fuser on the hosting machine i tried to make a cron job from cpanel but it returned that they don't exist (or at least i dont't have access to them...) so i can't use that... and i don't have any other access to the server no ssh or telnet or whatever j

[sqlite] SQLite Tutorial: Request For Comments

2004-12-01 Thread sporkey
The html has been cleaned up on the tutorial: http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download Regards, Mike Chirico

Re: [sqlite] Problem with pkg_mkIndex and Tclsqlite3

2004-12-01 Thread Denis Smirnov
On Tue, Nov 23, 2004 at 07:16:06PM -0500, D. Richard Hipp wrote: DRH> >I am getting problem trying to create a packing index for tclsqlite3 DRH> We're working on getting the Makefile to do this automatically. DRH> Once that is done, we'll publish a tclkit for SQLite. I create patch, that works

Re: [sqlite] [ANN] SQLcrypt 1.0

2004-12-01 Thread info
Hi, Thank you for your reply. Do you have a list of customers (at least a couple?) that use your encryption mechanism in a commercial software? Since it's quite new, I'd like to know about other users before I commit myself. For any further discussion, I think it's best to go off this list, you