Re: [sqlite] Another SQLite documentation/manual

On 7/5/05, Roger Binns <[EMAIL PROTECTED]> wrote: > > Any SQLite documentation/manual out there? > > http://www.sqlite.org/docs.html > http://www.sqlite.org/cvstrac/wiki > That's the official docs one. > > There's not enough with the > > official documentation for me, I need more docs for

Re: [sqlite] Another SQLite documentation/manual

Any SQLite documentation/manual out there? http://www.sqlite.org/docs.html http://www.sqlite.org/cvstrac/wiki There's not enough with the official documentation for me, I need more docs for exploring SQLite. What specifically is missing? Roger

Re: [sqlite] how to do select by Date and Time range?

Cory, thanks for the information. the wiki talks about time functions. what should we do when defining the table columns? should i just use REAL? can you give a sample CREATE table statement? and a sample insert statement? jack.

Re: [sqlite] how to do select by Date and Time range?

sqlite stores dates/times in floating point, the normal comparison operators should work fine on them. http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions On 7/4/05, jack wu <[EMAIL PROTECTED]> wrote: > > i have a table which has Date one the columns. i 'd > like run a query in this form:

[sqlite] Another SQLite documentation/manual

Hi Guys. Any SQLite documentation/manual out there? There's not enough with the official documentation for me, I need more docs for exploring SQLite. Thanks, -- :: Never Dreamt Before :: http://php.hm/~firman/ < firman(@)php.net | firmanw(@)gmail.com >

[sqlite] how to do select by Date and Time range?

i have a table which has Date one the columns. i 'd like run a query in this form: select * from table1 where Date>date1 and Date

Re: [sqlite] 3.2.2 MacOS X = 3.0.8.6 ?

Le 4 juil. 05 à 23:41, Dirk Theisen a écrit : It seems to be that the build system for OS X always assigns the 3.0.8.6 version number - never what. I haven't looked at it any further. That's what I've figured out. But functions that are supposed to be included in 3.2.2 are not included

Re: [sqlite] 3.2.2 MacOS X = 3.0.8.6 ?

Hi! So it looks like a mistery to me. Which sqlite version I need to compile in order to be able to use these two functions ? It seems to be that the build system for OS X always assigns the 3.0.8.6 version number - never what. I haven't looked at it any further. BTW: Anyone used CoreData

Re: [sqlite] What happens to unused space?

So perhaps I could add some code to sqlite to overwrite deleted data when it is marked as unused/deleted. If I do this*, is anyone else interested in it? Obviously it would be a compile time option, as it would probably impact performance (but not to a level that matters for my application).

Re: [sqlite] 3.2.2 MacOS X = 3.0.8.6 ?

Le 4 juil. 05 à 18:40, Gwendolynn ferch Elydyr a écrit : On Mon, 4 Jul 2005, Dominic wrote: I've just compiled 3.2.2 version on MacOS X (both Panther-10.3.X and Tiger-10.4.X) and I was surprised that generated libsql3.dylib is labelled version 3.0.8.6, with a sqlite3.h that doesn't

Re: [sqlite] What happens to unused space?

Dan Kennedy wrote: >> So in summary, when I delete a blob, I want it to stay deleted, even from prying eyes with a hex editor - what's the best way to do this in the SQLite model? > > > Tricky question. So, judging from this and other replies, there isn't a 'safe' way of doing this at the

[sqlite] Probleme with Java SQLite Wrapper

my problem is a litel stange. Firstly I work with eclipse and Java SQLite Wrapper dounloaded at this site and that normally works well http://www.ch-werner.de I open a sqlite DB and I execute the query I do same think like this query = "select name from sqlite_master where type=table";

Re: [sqlite] 3.2.2 MacOS X = 3.0.8.6 ?

On Mon, 4 Jul 2005, Dominic wrote: I've just compiled 3.2.2 version on MacOS X (both Panther-10.3.X and Tiger-10.4.X) and I was surprised that generated libsql3.dylib is labelled version 3.0.8.6, with a sqlite3.h that doesn't integrate functions like "sqlite3_clear_bindings()" and

Re: [sqlite] What happens to unused space?

At 2:24 PM +0100 7/4/05, Tim Browse wrote: Hi, Before I go diving into the SQLite source code, can anyone tell me what happens to unused space? (i.e. from deleted data in the db) It gets reused unless you use VACUUM in which case it could end up reused in the DB or reused in the OS file

Re: [sqlite] What happens to unused space?

About the blob delection issue, i have a sugestion: - At the same blob deletion transaction, before the delection sql code, update the blob with an standard blob without relevant meaning, overwriting the original. Then an hacker will read the standard blob in the deleted blob space. Well... it

Re: [sqlite] What happens to unused space?

> Hi, > > Before I go diving into the SQLite source code, can anyone tell me what > happens to unused space? (i.e. from deleted data in the db) > > Specifically, I'm interested in whether it gets over-written by zeroes, > or something. I'm storing information in a database (in a blob field),

[sqlite] 3.2.2 MacOS X = 3.0.8.6 ?

Hello, I've just compiled 3.2.2 version on MacOS X (both Panther-10.3.X and Tiger-10.4.X) and I was surprised that generated libsql3.dylib is labelled version 3.0.8.6, with a sqlite3.h that doesn't integrate functions like "sqlite3_clear_bindings()" and "sqlite3_transfer_bindings()" that

Re: [sqlite] Database LOCK on SELECT only - BUG ?

I am now able to replicate the error using NT as well. So the problem is not related to XP only. Massimo

[sqlite] Database LOCK on SELECT only - BUG ?

As reported some days ago I got a message "database is locked" in an application using a SELECT statement only. Some facts. A) I am using Sqlite 3.2.2 under Windows using MinGW (gcc 3.4.2). B) It seems that the problem is present if the application is running under Windows XP Pro Service Pack

[sqlite] What happens to unused space?

Hi, Before I go diving into the SQLite source code, can anyone tell me what happens to unused space? (i.e. from deleted data in the db) Specifically, I'm interested in whether it gets over-written by zeroes, or something. I'm storing information in a database (in a blob field), which the

[sqlite] INTEGER data type

Hello All, What is the maximum number that can be stored using INTEGER data type? My table uses INTEGER to store primary key, I store lot of records in table. I suspect that primary key will run out of limit. How can I use long instead of INTEGER? Regards, Ajay Sonawane

RE: [sqlite] SQLite and VB 2005 Express Edition

-Original Message- From: Robert Simpson [mailto:[EMAIL PROTECTED] Sent: Sunday, July 03, 2005 8:30 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] SQLite and VB 2005 Express Edition > -Original Message- > From: Chris Moody [mailto:[EMAIL PROTECTED] > Sent: Sunday, July