Re: [sqlite] Limiting the size of a database?

2007-05-08 Thread John Stanton
Try the traditional way and use disk partitions/filesystems. Joe Wilson wrote: --- Ron Stevens <[EMAIL PROTECTED]> wrote: Is it possible to tell SQLite to limit the size that a database may grow to? It would be useful for storage constrained applications. This is a tricky problem. What

Re: [sqlite] Limiting the size of a database?

2007-05-07 Thread Ron Stevens
It would be helpful if the maximum size was configurable per database via a PRAGMA statement. That way you would be able to ensure a non-critical database doesn't grow too large leaving no space for one that is more important. On 5/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Joe Wilson

Re: [sqlite] Limiting the size of a database?

2007-05-07 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > --- [EMAIL PROTECTED] wrote: > > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > I wrote too soon: > > > > > > http://www.sqlite.org/cvstrac/chngview?cn=3941 > > > > > > + /* > > > + ** Maximum number of pages in one database file. > > > + */ > > > + #ifndef

Re: [sqlite] Limiting the size of a database?

2007-05-07 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > I wrote too soon: > > > > http://www.sqlite.org/cvstrac/chngview?cn=3941 > > > > + /* > > + ** Maximum number of pages in one database file. > > + */ > > + #ifndef SQLITE_MAX_PAGE_COUNT > > + # define SQLITE_MAX_PAGE_COUNT

Re: [sqlite] Limiting the size of a database?

2007-05-07 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > I wrote too soon: > > http://www.sqlite.org/cvstrac/chngview?cn=3941 > > + /* > + ** Maximum number of pages in one database file. > + */ > + #ifndef SQLITE_MAX_PAGE_COUNT > + # define SQLITE_MAX_PAGE_COUNT 1073741823 > + #endif > This #define doesn't

Re: [sqlite] Limiting the size of a database?

2007-05-07 Thread Joe Wilson
I wrote too soon: http://www.sqlite.org/cvstrac/chngview?cn=3941 + /* + ** Maximum number of pages in one database file. + */ + #ifndef SQLITE_MAX_PAGE_COUNT + # define SQLITE_MAX_PAGE_COUNT 1073741823 + #endif --- Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Ron Stevens <[EMAIL PROTECTED]>

Re: [sqlite] Limiting the size of a database?

2007-05-07 Thread Joe Wilson
--- Ron Stevens <[EMAIL PROTECTED]> wrote: > Is it possible to tell SQLite to limit the size that a database may > grow to? It would be useful for storage constrained applications. This is a tricky problem. What would you have the database do if an insert failed upon reaching the limit? What

[sqlite] Limiting the size of a database?

2007-05-07 Thread Ron Stevens
Is it possible to tell SQLite to limit the size that a database may grow to? It would be useful for storage constrained applications. - To unsubscribe, send email to [EMAIL PROTECTED]