Re: [sqlite] Cloudscape?

2004-08-03 Thread D. Richard Hipp
Andrew Piskorski wrote: Anyone know much of anything about IBM's Cloudscape database? Advantages or disadvantages vs. SQLite? A template wiki page is at http://www.sqlite.org/cvstrac/wiki?p=SqliteVersusDerby Please correct and or supplement this page as you are able. -- D. Richard Hipp --

Re: [sqlite] LEFT JOIN doesn't work as expected

2004-08-03 Thread Darren Duncan
At 8:12 PM +0200 8/3/04, Rolf Schaeuble wrote: SELECT object.object_id, properties.value_table, string_values.value, int_values.value FROM object LEFT OUTER JOIN properties ON object.object_id = properties.object_id LEFT OUTER JOIN string_values ON

[sqlite] Re: - [sqlite] Cloudscape?

2004-08-03 Thread rbundy
Windows download is 628.1MB. There goes your hard drive. 'Nuff said really. rayB |-+> | | Andrew Piskorski | | | <[EMAIL PROTECTED]| | | m> | | || |

[sqlite] Cloudscape?

2004-08-03 Thread Andrew Piskorski
Anyone know much of anything about IBM's Cloudscape database? Advantages or disadvantages vs. SQLite? http://www-306.ibm.com/software/data/cloudscape/ http://www.zdnet.com.au/news/software/0,261733,39155170,00.htm I hadn't heard of it before, so I'm curious. -- Andrew Piskorski <[EMAIL

Re: [sqlite] LEMON Examples

2004-08-03 Thread Joseph Stewart
I'll second sporkey, would you be able to post your calc source for us all to see? TIA, -j On Tue, 03 Aug 2004 15:38:53 -0400, John Cohen <[EMAIL PROTECTED]> wrote: > Hi all, > > Thanks for all the help! I got it all working fine.. The wrapper did the > trick - I also want to try some speed

[sqlite] LEFT JOIN doesn't work as expected

2004-08-03 Thread Rolf Schaeuble
Hello, today I've stumbled over a problem that I can't seem to find an answer for. I have the following tables: CREATE TABLE object ( object_id INTEGER PRIMARY KEY ); CREATE TABLE properties ( object_id INTEGER, property_id INTEGER, value_table INTEGER ); CREATE

Re: [sqlite] force unlocking?

2004-08-03 Thread Tito Ciuro
Hello Ara, On 3 ago 2004, at 10:09, Ara.T.Howard wrote: regarding atomic creation of lockfiles: this can be done using link(2). i have a library and command line tool for doing so, but have never tested it on a mac. it can be found at http://raa.ruby-lang.org/project/lockfile/ I have

Re: [sqlite] LEMON Examples

2004-08-03 Thread D. Richard Hipp
D. Richard Hipp wrote: John Cohen wrote: The last suggestion worked great (thanks!). But still, I still have a small problem. It won't accept more than one 'statement'. I know why, but can't fix it. Take a look: $ ./a.out 7 + 9 + 7 + 3 / (5 + 7); 23.25 3 + 3 + 3; Fatal Error: Parser

[sqlite] Analytic commands

2004-08-03 Thread Iain Mackay
I wonder, has anyone experimented with implementing OLAP-style extensions for SQLite? E.g. ROLLUP, CUBE and the various functions operating on query-results-in-sequence. Iain MacKay

Re: [sqlite] force unlocking?

2004-08-03 Thread Ara.T.Howard
On Mon, 2 Aug 2004, Tito Ciuro wrote: Hello Ara, On 2 ago 2004, at 9:59, Ara.T.Howard wrote: the simplest way to do this is to create a file for each db, say db.lock, and to apply a blocking read/write to this file depending on the intent of your operation. the contents of this file are not

Re: [sqlite] in memory databases

2004-08-03 Thread Rajesh Nagarajan
Hi I am trying to move to memory database from file based sqlite db, I want my memory database to be shared across various threads in my process. How do I do it? >From the Wiki documentation, I found the following * (defvar db2 (sql:connect '(":memory:")

Re: [sqlite] LEMON Examples

2004-08-03 Thread Christian Smith
On Tue, 2 Aug 2004, John Cohen wrote: > >in ::= in stmt ENDLINE. > >But that doesn't seem to work in lemon. I've also tried making the 2nd >statement right recursive, but that doesn't work either because it doesn't >seem to ever reduce all the way. > >Any ideas? Much thanks to all. Just make