Hi all,
I'm pleased to announce the release of SQLcrypt.
http://www.sqlcrypt.com
SQLcrypt is SQLite 3 + transparent AES encryption. Try before you buy.
Please take a look.
Thanks. Cheers.
--
Ng Pheng Siong <[EMAIL PROTECTED]>
http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL
I just found that there is a book about SQLite and thought you would
like to know.
link to page: http://www.quepublishing.com/title/067232685X
Book Description
SQLite is a small, fast, embeddable database. What makes it popular is
the combination of the database engine and interface into a
Hello,
In the documentation for column constraints, there is an option called
"default" which could take the text "current_timestamp" as its value.
Supposedly, this will populate the column with the current time and
date. However, when I attempt to use this, my column is simply
populated with
There is an opportunity for a minor speedup in sqlite3Malloc().
sqlite3Malloc() is implemented as follows:
void *sqlite3Malloc(int n){
void *p;
if( (p = malloc(n))==0 ){
if( n>0 ) sqlite3_malloc_failed++;
}else{
memset(p, 0, n);
}
return p;
}
The separation of
Hello
Env.: sqlite 2.8.15 windows, mingw, C interf., table "Gosp" with "pow
integer" column.
Present rows with pos={1.20, 1.32, 430}.
Using sqlite.exe:
SELECT * FROM Gosp WHERE pow >= 1.30 AND pow <= 2.00
...|1.32
SELECT * FROM Gosp WHERE pow > 1.30
...|1.32
...|430
Using C api:
SELECT * FROM
>> ... what is the format for ... using .import ... ?
Read the docs for the COPY command.
Regards
CREATE TABLE CRS_2004_001 ( etl_extract_id INTEGER PRIMARY KEY,
courseid, coursekey char, status, schoolid, lowgrade, highgrade, effectdate,
^^
expdate, description, title, longtitle, etl_error DEFAULT 0 );
SQLite is trying to compare the values as numbers.
You should put
Hello
Env.: sqlite 2.8.15 windows, mingw, C interf., table "Gosp" with "pow
integer" column.
Using sqlite.exe:
SELECT * FROM Gosp WHERE pow >= 1.30 AND pow <= 2.00
|1.32
SELECT * FROM Gosp WHERE pow > 1.30
|1.32
|430
Using C api:
SELECT * FROM Gosp WHERE pow>=1.30 AND pow<=2.00
I get
Hi,
the failure was sitting before the monitor ;-)
I've removed the unpacked sqlite folder and unpacked it again. Now the
compilation of version 3 was successfully.
My fault was to unpack and compile sqlite Version2 and then to unpack and
compile Version3. In consequence that the folder for
I am thoroughly confused as to why the following simple query doesn't
return the proper result set but instead returns the 15 records with a
coursekey starting with '0E'. Do I need to escape something?
SQLite version 2.8.15
Enter ".help" for instructions
sqlite> .schema CRS_2004_001
CREATE
Hi,
the Makefile.linux-gcc renamed in Makefile produces the same error output.
Now I've tried to install the rpm, but this results to another failure:
rpm -i sqlite-3.0.8-1.i386.rpm
error: Failed dependencies:
libreadline.so.4 is needed by sqlite-3.0.8-1
SuSE 9.2 has libreadline.so.5
> Peter Bartholdsson wrote:
> > Is there some way to write this query in SQLite?
> > UPDATE
> > groups
> > SET
> > (fileCount, size) = (SELECT count(id), sum(size) FROM files where
> > groupId = 15)
> > WHERE
> > groupId = 15;
> >
>
> Sadly, no. SQLite only allows a subquery to
Hi Richard
May I suggest that you take a look at scons. Scons is much better than
autotools and it doesn't suffer from any of the compatibility problems.
Scons can be download from http://www.scons.org/
I would like to offer our services in writing a scons script for you. BTW
scons is a Python
"D. Richard Hipp" <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] wrote:
>> Hi,
>> I have problems to compile sqlite version 3 on SuSE 9.2. The 2.8.15 Version
>> compiled successfully.
>> Configure seems to work fine but when I invoke make the compilation
>> stops with
>> following error output:
[EMAIL PROTECTED] wrote:
Hi,
I have problems to compile sqlite version 3 on SuSE 9.2. The 2.8.15 Version
compiled successfully.
Configure seems to work fine but when I invoke make the compilation stops with
following error output:
./libtool --mode=compile gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I.
Hi,
I have problems to compile sqlite version 3 on SuSE 9.2. The 2.8.15 Version
compiled successfully.
Configure seems to work fine but when I invoke make the compilation stops with
following error output:
./libtool --mode=compile gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src
-DNDEBUG -c
16 matches
Mail list logo