Re: [sqlite] encrypted file

Thanks for your informative reply. I would like to know, whether I can open a database which is created using the sqlite API from a program, using the sqlite command line client? [I tried it using sqlite and it shown the following error- Unable to open database "/root/userdb": file is

Re: [sqlite] Sqlite & Matlab

Dennis, Fine! In that case, I wonder whether it will be of some use to add the possibility to access sqlite from Matlab on the official Sqlite web site, more precisely at http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers It would avoid the need to search on Google... Selon Dennis Cote <[EMAIL

[sqlite] Compiling Sqlite with Openwatcom

Hi All, I wonder whether anyone has already compiled Sqlite with Openwatcom (a free compiler suite available at www.openwatcom.org including a C/C++/Fortran compiler). Since when I tried, I got the following compiling error on line 95 of the file sqlite3ext.h: invalid declarator i.e.

Re: [sqlite] Compiling Sqlite with Openwatcom

[EMAIL PROTECTED] wrote: Hi All, I wonder whether anyone has already compiled Sqlite with Openwatcom (a free compiler suite available at www.openwatcom.org including a C/C++/Fortran compiler). Since when I tried, I got the following compiling error on line 95 of the file sqlite3ext.h: invalid

Re: [sqlite] Re: Regarding sqlite3_exec

What prevents you from doing the same yourself? Just collect the data in a memory buffer as you get it, before processing it. Nothing but effiency as discussed. Basically, as Mr Cote has said, its either a count(*) query or O(n) step calls. The former means two statements have to be run, if

Re: [sqlite] Regarding sqlite3_exec

Hi Thanks for your resposne. In the end its not important as you point out as many options are available, I guess I allowed myself to indulge in "idealic" fantasy for a moment :-) S On 10/24/06, Dennis Cote <[EMAIL PROTECTED]> wrote: Da Martian wrote: > Hi > > I understand the problem in

Re: [sqlite] Re: Regarding sqlite3_exec

Da Martian wrote: But to return all the rows just to count them requires N calls to step. If the data set is large you only want to return a subset to start with. So you wouldnt know the count. If you dont know the count, you cant update GUI type things etc.. I haven't been following this

Re: [sqlite] Re: Regarding sqlite3_exec

Yes but google doesnt us an RDMS, its all propriatary to support there speed and huge volumes. Its anyones guess (excpet google themselves) what exactly they do, and rumours abound, but I have done many apps which require custom data handling to achieve some end that doesnt fit with RDBM Systems.

Re: [sqlite] Re: Regarding sqlite3_exec

Da Martian wrote: Yes but google doesnt us an RDMS, its all propriatary to support there speed and huge volumes. I know, but that was my point. If they can't/don't do it (with their custom kit) then surely it's non-trivial? Martin

[sqlite] Re: Regarding sqlite3_exec

* Da Martian <[EMAIL PROTECTED]> [2006-10-25 11:35]: > >What prevents you from doing the same yourself? Just collect > >the data in a memory buffer as you get it, before processing > >it. > > Nothing but effiency as discussed. Basically, as Mr Cote has > said, its either a count(*) query or O(n)

Re: [sqlite] encrypted file

Sorry for my mistake. I was creating database using sqlite3 API and trying to open it with sqlite command line client version 2.7 Thanks a lot. Lloyd. On Wed, 2006-10-25 at 11:51 +0530, Lloyd wrote: > Thanks for your informative reply. > > I would like to know, whether I can open a database

Re: Re: [sqlite] database corrouption during power failure

Thanks Dennis Cote. Now even though synchrounous is set to FULL. But Database Corrouption is happening. Here are my observations in our sqlite 2.8.13. 1. This corrouption is not detected by the sqlite_open(). 2. After the crash/power failure. I see a journal file in the same directory as the

Re: [sqlite] Compiling Sqlite with Openwatcom

Hi Arjen Unfortunately I am still using f77 not f90... Selon Arjen Markus <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > >Hi All, > > > >I wonder whether anyone has already compiled Sqlite with Openwatcom (a free > >compiler suite available at www.openwatcom.org including a C/C++/Fortran >

Re: [sqlite] Compiling Sqlite with Openwatcom

[EMAIL PROTECTED] wrote: Hi Arjen Unfortunately I am still using f77 not f90... Hello Victor, any specific reason? There are lots of (free) Fortran 90 compilers around, and unless I am mistaken the Openwatcom compiler supports Fortran 90 (after all, the standard is more than 20 years

Re: [sqlite] Re: Regarding sqlite3_exec

Its quiet simple: 1) If there are too many results the user will have to wait a long time before they see anything because we will be buffering away results. The application will appear slugish. The user would get bored. I can point you to dozens of studies which show the correlation between

Re: [sqlite] Re: Regarding sqlite3_exec

Your extremly simplistic view on this is a result of never dealing in volumous data and result sets and quick running queries. Once you >put volumes into your thinking cap you will begin to see why you dont just read everything into memory for the hell of it. Just to complete the above thought.

[sqlite] Re: Regarding sqlite3_exec

* Da Martian <[EMAIL PROTECTED]> [2006-10-25 14:15]: > 1) If there are too many results the user will have to wait > a long time before they see anything because we will be > buffering away results. The application will appear slugish. > The user would get bored. I can point you to dozens of

Re: [sqlite] Re: Regarding sqlite3_exec

Its was not meant as an insult, however you did set the tone with your post (ala: Either you want the data from the query, or you don't.). I mearly responded in kind. If you live in glass houses dont throw stones and all that. I mean its not hard to see that loading 20 million records into memory

[sqlite] Re: Regarding sqlite3_exec

* Da Martian <[EMAIL PROTECTED]> [2006-10-25 15:05]: > Its was not meant as an insult, however you did set the tone > with your post (ala: Either you want the data from the query, > or you don't.). I mearly responded in kind. If you live in > glass houses dont throw stones and all that. I mean its

[sqlite] hexadecimal

Hi list, can I insert a hexadecimal value to an integer field? if yes How can do that? Thanks, Lloyd __ Scanned and protected by Email scanner - To unsubscribe, send email to

Re: [sqlite] Trouble with ALTER TABLE/ADD

Isaac Raway uttered: Thank, I will look at that (away from my dev machine for the day). One other related question, are there plans to expand the functionality of ALTER TABLE? I am working on a feature that could benefit greatly from REMOVE/RENAME COLUMN. As it stands, I am going to have to

Re: [sqlite] any data access and retrieval engine?

Sarah uttered: Hi, John Stanton I really really appreciate your warm help. That's great if you can send me the codes of B tree and B+ tree. Many thanks in advance. My requirements for data access are as follows: -all the data are stored in non-volatile memory instead of volatile memory -the

Re: [sqlite] Re: Regarding sqlite3_exec

On 10/25/06, Da Martian <[EMAIL PROTECTED]> wrote: [...] But to return all the rows just to count them requires N calls to step. If the data set is large you only want to return a subset to start with. So you wouldnt know the count. If you dont know the count, you cant update GUI type things

Re: [sqlite] Re: Regarding sqlite3_exec

Hi All these options are good, and the discussion was interesting. I mearly wanted to see what peoples thoughts on the sqlite providing this were. There are many ways to skin a cat as they say. Since this is probably drifting off topic, I suggest we discontinue the thread. Thanks for your

Re: [sqlite] any data access and retrieval engine?

"Sarah" <[EMAIL PROTECTED]> wrote: > Hi, John Stanton > > I really really appreciate your warm help. > That's great if you can send me the codes of B tree and B+ tree. > Many thanks in advance. > > My requirements for data access are as follows: > -all the data are stored in non-volatile memory

Re: [sqlite] Re: Regarding sqlite3_exec

Nuno Lucas wrote: There is another alternative if you don't mind to have the overhead of having an automatic row count (which sqlite avoids by design). It's by having a trigger that will update the table row count on each insert/delete. Nuno, This technique only works if you never use

Re: [sqlite] INSERT Abilities?

On Wed, 2006-10-25 at 11:47 -0500, Jarvis Stubblefield wrote: > I am very sorry if this seems to be a newb question, and on the FAQ's > or otherwise elsewhere. I couldn't find an answer to my question. > > These INSERT statements work. > > INSERT INTO fIndex(fPrice) VALUES(20); > INSERT INTO

Re: [sqlite] Re: Regarding sqlite3_exec

On 10/25/06, Dennis Cote <[EMAIL PROTECTED]> wrote: Nuno Lucas wrote: > > There is another alternative if you don't mind to have the overhead of > having an automatic row count (which sqlite avoids by design). It's by > having a trigger that will update the table row count on each >

Re: [sqlite] hexadecimal

Hi Lloyd, On Wed, 25 Oct 2006 20:11:49 +0530, you wrote: > Hi list, > can I insert a hexadecimal value to an integer field? Yes. > if yes How can do that? Convert it to an integer in your host language first. The X'hexstring' syntax is only for BLOBs. > Thanks, > Lloyd -- ( Kees Nuyt

Re: [sqlite] Re: Regarding sqlite3_exec

Indeed, Thanks to all for the responses. Currently I use the seperate count(*), but think I will change to the "prepare, step(n), reset" option only because the query is a little slow. Utlimatly sqlite is brilliant, hands down the best embeddable and standalone db I have yet to encounter.

Re: [sqlite] Re: Regarding sqlite3_exec

There is no magic in data retrieval. Google use the same physical laws as us ordinary mortals. I see no reason to ever perform a dataabase search twice. Da Martian wrote: Yes but google doesnt us an RDMS, its all propriatary to support there speed and huge volumes. Its anyones guess (excpet

Re: [sqlite] Re: Regarding sqlite3_exec

Nuno Lucas wrote: On 10/25/06, Dennis Cote <[EMAIL PROTECTED]> wrote: Nuno Lucas wrote: > > There is another alternative if you don't mind to have the overhead of > having an automatic row count (which sqlite avoids by design). It's by > having a trigger that will update the table row count on

[sqlite] number problem with 3.2.8

I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be having a problem doing queries where with '>' to search a number. for instance if I do the following select ring_time fron calls where ring_time > '10'; I get the following results 3 6 3 6 3 6 2 3 3 3 2 etc. Why? This row is

[sqlite] Re: number problem with 3.2.8

Lloyd Thomas wrote: I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be having a problem doing queries where with '>' to search a number. for instance if I do the following select ring_time fron calls where ring_time > '10'; I get the following results 3 6 3 6 3 6 2 3 3 3 2 etc.

Re: [sqlite] number problem with 3.2.8

I'm fairly certain that it's because when you're saying ring_time > '10', it's asking sqlite to take all strings that are greater than the string '10'. So all the numbers you presented are greater than 1. What you want is "where ring_time > 10". Notice the lack of quotes which means treat

Re: [sqlite] Re: number problem with 3.2.8

I did try number literal >10 but mad no difference. I will rebuild the database row as an integer. Lloyd - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" Sent: Thursday, October 26, 2006 12:21 AM Subject: [sqlite] Re: number

RE: [sqlite] Re: number problem with 3.2.8

-Original Message- From: Lloyd Thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 7:49 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Re: number problem with 3.2.8 I did try number literal >10 but mad no difference. I will rebuild the database row as an integer.

Re: [sqlite] Re: number problem with 3.2.8

"Lloyd Thomas" <[EMAIL PROTECTED]> writes: > I did try number literal >10 but mad no difference. I will rebuild the > database row as an integer. As an interim solution (prior to changing your database schema), you should be able to use your existing schema with this query: select ring_time