Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-12 Thread pirx
Apologies for not answering earlier, I* was away. I've never used Process Monitor - the whole setup you describing is new to me - but I will try to do something about it in the coming week. It has to be a background project for me - I do not use SQLite in production. -Original

[sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-07 Thread pirx
SQLite bug report   Summary: -- error message: Error: near line 2: database or disk is full It happens with plenty of disk space available and with 'unlimited' database size. It does not happen on all systems. It does not happen on small databases.   Details: --

Re: [sqlite] windowing functions != recursive functions

2005-10-13 Thread pilot pirx
if there is a sufficient interest. - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Subject: Re: [sqlite] windowing functions != recursive functions Date: Wed, 12 Oct 2005 22:48:35 -0400 > > "pilot pirx" <[EMAIL PROTECTED]> wrote: > &

[sqlite] wiindow functions and recursive functions

2005-10-12 Thread pilot pirx
-0400 > > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot pirx wrote: > > Subject: [sqlite] Please, please do _not_ remove this feature from SQLite... > > > While using SQLite for some time (with R package, www.r-project.org) > > I did admire its functionality and sp

[sqlite] windowing functions != recursive functions

2005-10-12 Thread pilot pirx
previous value(s) of VALUE. - Original Message - From: "Andrew Piskorski" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Subject: [sqlite] SQL Window/OLAP functions Date: Wed, 12 Oct 2005 08:34:02 -0400 > > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot p

Re: [sqlite] SQL Window/OLAP functions

2005-10-12 Thread pilot pirx
: "Andrew Piskorski" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Wednesday, October 12, 2005 2:34 PM > Subject: [sqlite] SQL Window/OLAP functions > > > > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot pirx wrote: > > > Su

[sqlite] Please, please do _not_ remove this feature from SQLite...

2005-10-12 Thread pilot pirx
While using SQLite for some time (with R package, www.r-project.org) I did admire its functionality and speed. Then I did discover a hidden SQLite feature of immense usefulness - not available in other databases. SQLite can compute Fibonacci numbers! (I will explain why this is important