Re: [sqlite] limiting database size

2005-07-11 Thread Cory Nelson
sqlite is file-based. use your filesystems quota functionality. On 7/11/05, Ramon <[EMAIL PROTECTED]> wrote: > > On 7/11/05, Ramon <[EMAIL PROTECTED]> wrote: > >> I would like to know if there is a way to limit a sqlite database and then > >> be > >> able > >> to change this limit later on? > >

Re: [sqlite] limiting database size

2005-07-11 Thread Sean Heber
I want to put a limit like 10mb then later on e able to change this database limit to 15mb if I want to, is this possible? You could use auto_vacuum (so the data file shrinks when data is deleted) and check the file size so you know when it is "full." l8r Sean

Re: [sqlite] limiting database size

2005-07-11 Thread Ramon
> On 7/11/05, Ramon <[EMAIL PROTECTED]> wrote: >> I would like to know if there is a way to limit a sqlite database and then be >> able >> to change this limit later on? > > Stop inserting when it's full? > > I want to put a limit like 10mb then later on e able to change this database limit to 15m

Re: [sqlite] limiting database size

2005-07-11 Thread Jay Sprenkle
On 7/11/05, Ramon <[EMAIL PROTECTED]> wrote: > I would like to know if there is a way to limit a sqlite database and then be > able > to change this limit later on? Stop inserting when it's full?

[sqlite] limiting database size

2005-07-11 Thread Ramon
I would like to know if there is a way to limit a sqlite database and then be able to change this limit later on?