RE: [sqlite] SQL syntax - please help

Ok, thank you Darren. It's good to know that, so I don't waste time trying to implement something that doesn't exist :-) Are there plans to implement this sometime in the future? Dennis -Original Message- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: Friday, 1 July 2005 7:31

[sqlite] SQLite and VB 2005 Express Edition

Hi all, I'm currently using the public beta 2 of M$'s VB 2005 Express Edition. Is it possible to get SQLite to work with it? Thanks, Chris

Re: [sqlite] BerkleyDB pager?

On Sun, Jul 03, 2005 at 02:14:45PM -0400, Andrew Athan wrote: > >>I'm investigating embedded databases for an upcoming project, and I came > >>upon this thought: Wouldn't an SQLite pager that uses > >>Sleepycat/BerkleyDB be quite interesting? Maybe you could clarify a bit more what you are

Re: [sqlite] Update variable problems. Bug?

Thanks, All. I totally missed the nuance between single and double quotes. Tom -- Tom Shaw - Chief Engineer, OITC <[EMAIL PROTECTED]>, http://www.oitc.com/ US Phone Numbers: 321-984-3714, 321-729-6258(fax), 321-258-2475(cell/voice mail,pager) Text Paging:

Re: [sqlite] Update variable problems. Bug?

Tom Shaw wrote: Using PHP 5 and SQLite 2.8.14 (This also occurs when commanding SQLite directly) I create a table: CREATE TABLE dnsbl (ip INTEGER PRIMARY KEY, flags VARCHAR(8), ctime INTEGER, mtime INTEGER, cnt INTEGER, ptr TEXT, refcon INTEGER); Then I insert a record: INSERT INTO dnsbl

Re: [sqlite] Update variable problems. Bug?

On Sun, Jul 03, 2005 at 02:59:19PM -0400, Tom Shaw wrote: > Using PHP 5 and SQLite 2.8.14 (This also occurs when commanding > SQLite directly) > > I create a table: > > CREATE TABLE dnsbl (ip INTEGER PRIMARY KEY, flags VARCHAR(8), ctime > INTEGER, mtime INTEGER, cnt INTEGER, ptr TEXT, refcon

Re: [sqlite] Update variable problems. Bug?

On Jul 3, 2005, at 11:59 AM, Tom Shaw wrote: Now there should be nothing wrong with the above that I can see BUT if I change the DB variable name from ip to ip_num all works OK Strings are quoted with single quotes, not double quotes. Double- quoted strings are interpreted as column

Re: [sqlite] BerkleyDB pager?

Are we talking about the same sleepycat? BerkleyDB (Sleepycat) is open source, available here: http://www.sleepycat.com/products/db.shtml Basically I am thinking that some of BerkleyDB's locking granularity and distribution/replication/etc. features might be interesting within the context

Re: [sqlite] using sqlite as a temporary database to process lots of data

On Tue, Jun 28, 2005 at 04:15:15PM -0400, Patrick Dunnigan wrote: > I am currently using SQLite to process @ 400 million records (and climbing) > a day by reading files, importing them into SQLite, and summarizing. The > summed data goes into Oracle. This is a production application that is very

Re: [sqlite] BerkleyDB pager?

Andrew Athan said: > > I'm investigating embedded databases for an upcoming project, and I came > upon this thought: Wouldn't an SQLite pager that uses > Sleepycat/BerkleyDB be quite interesting? It would be of fairly limited value for a lot of us however. For projects which don't release

[sqlite] [patch] fix compilation with new coreutils

Hello developers, the attached patch fixes compilation with the new GNU coreutils. Especially important is the "-k" parameter for "sort", because otherwise an empty opcodes.c file will be generated which will lead to an immediate SIGSEGV when using "explain". -- ---> doj / cubic >

[sqlite] Query parsing problem, many nested selects (SQLite 3.2.1)

Hi, I am having problems with query parser of SQLite 3.2.1. My object persistence framework generates huge chunks of SQL code when (object) relations are combined. For example, following (senseless) C++ - code: Cursor cur= Category::Playables::combine