Re: [sqlite] Encryption and fixed header values (was Re: [sqlite] Why can i open a textfile?)

2005-08-25 Thread Mrs. Brisby
On Wed, 2005-08-24 at 22:55 -0400, D. Richard Hipp wrote: > Weaknesses in RC4 have been found where > the first few numbers coming out of the PRNG leak information about the > key. If an attacker can guess the first few bytes of plaintext, and > hence guess the first few numbers from the PRNG,

Re: [sqlite] Linking to SQLite with Cygwin / CMake

2005-08-25 Thread Kiel W.
Ok, I'm definately thinking this is just a problem with my understanding of the build process in *nix's and the quirks of Cygwin. I am getting the following warning with the default Makefile that is generated. "libtool: link: warning: undefined symbols not allowed in i686-pc-cygwin shared

RE: [sqlite] Linking to SQLite with Cygwin / CMake

2005-08-25 Thread Reid Thompson
Doug Currie wrote: >> I downloaded the raw source and ran 'configure' and 'make' from a >> separate folder. The resulting output I copied to /usr/lib/sqlite. >> In it a see the bunch of .lo, .o and the two .la files >> (libsqlite3.la, libtclsqlite3.la) using cygwin ( when i built sqlite3 from

Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

2005-08-25 Thread Jolan Luff
On Wed, Aug 24, 2005 at 10:08:21AM -1000, Glen Nakamura wrote: > On Wed, Aug 24, 2005 at 02:50:04PM -0500, Jolan Luff wrote: > > OpenBSD/amd64 with gcc 3.3.5. I noticed that with 3.2.2 it was possible > > to run "make test" without having done "make" first and this is no > > longer the case with

Re: [sqlite] Linking to SQLite with Cygwin / CMake

2005-08-25 Thread Doug Currie
KW> I downloaded the raw source and ran 'configure' and 'make' from a KW> separate folder. The resulting output I copied to /usr/lib/sqlite. In KW> it a see the bunch of .lo, .o and the two .la files (libsqlite3.la, KW> libtclsqlite3.la) KW> I am use to a Visual Studio build environment, but

Re: [sqlite] Linking to SQLite with Cygwin / CMake

2005-08-25 Thread Kiel Wadner
Jay Sprenkle wrote: undefined reference at link time is usually a missing library. I think you're using linux? I'm actually Cgywin is a linux emulation layer.. from their site: "Cygwin is a Linux-like environment for Windows. It consists of two parts: A DLL (cygwin1.dll) which acts as a

[sqlite] aggregate funtion in the TCL binding

2005-08-25 Thread Ramon Ribó
Hello, It also looks to my that the interface should be something as as simple as: db aggregate_function step_func final_func > But it seemed to me that all it should take is to create a normal TCL > function to be called for each row selected (say, to compute the sums > and

Re: [sqlite] Linking to SQLite with Cygwin / CMake

2005-08-25 Thread Jay Sprenkle
On 8/24/05, Kiel Wadner <[EMAIL PROTECTED]> wrote: > This is almost a general programming question, but any help would be > appreciated. > > Root Problem: > /home/kiel/development/omms/output/libdbWrapper.a(dbwrapper.o): In > function `_ZN3srs9DbWrapper4openERKSs': >

Re: [sqlite] Duration of reading records seems longer when sortedas not.

2005-08-25 Thread Edwin Knoppert
I'm using 3.2.1 and have no index. Note that i'm not talking about the query itself but the data retrieval. - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Thursday, August 25, 2005 2:59 PM Subject: Re: [sqlite] Duration of reading

Re: [sqlite] Duration of reading records seems longer when sorted as not.

2005-08-25 Thread D. Richard Hipp
On Thu, 2005-08-25 at 05:56 -0700, Cory Nelson wrote: > I believe the recent release can use an index for sorting, so you may > want to try that. > To clarify: SQLite has been able to use indices for sorting for a long time - going back to version 2.5.1 on 2002-June-19. Recent releases just do

Re: [sqlite] Duration of reading records seems longer when sorted as not.

2005-08-25 Thread Cory Nelson
I believe the recent release can use an index for sorting, so you may want to try that. On 8/25/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote: > > FYI: > > Duration of reading records seems longer when sorted as not. > ~600 rec's in 500ms instead of 2400 (also ~500ms) > I'm not talking about

[sqlite] Duration of reading records seems longer when sorted as not.

2005-08-25 Thread Edwin Knoppert
FYI: Duration of reading records seems longer when sorted as not. ~600 rec's in 500ms instead of 2400 (also ~500ms) I'm not talking about prepare but the data retrieval per record.

Re: [sqlite] Why can i open a textfile?

2005-08-25 Thread Edwin Knoppert
Maybe we should explain the term 'wrapper'. I'm using wrappers around the salite dll in my own code. But a wrapper might be seen over here as additional library (dll or so) others can use. A redistribute part, which i don't like. (Like the VB 'wrapper' dll) - Original Message - From: