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

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

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

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

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

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

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

Re: [sqlite] SQL "IS" operator.

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

RE: [sqlite] SQL "IS" operator.

> 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

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

[sqlite] sqlite shell

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

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

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

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 +

[sqlite] pragma allbytes; pragma locks_block;

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

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

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?

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

Re: [sqlite] %Q in sqlite3_mprintf

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

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

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

RE: [sqlite] Tools for sqlite ver 3

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

[sqlite] SQLite ( old and new ) and QNX

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

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

> 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

Re: [sqlite] Help compiling sqlite2

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

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

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,

[sqlite] field=null vs. field isnull

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

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

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

  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

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,

Re: [sqlite] Locking database

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

Re: [sqlite] Locking database

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

[sqlite] Why does my query take so long

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,

[sqlite] how to convert mysql database to sqlite?

  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?

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?

  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

Re: [sqlite] Locking database

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