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
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
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
--- [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
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
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]>
--- 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
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]
8 matches
Mail list logo