Re: [sqlite] Running out of space

On 25 Nov 2009, at 12:26pm, Antti Nietosvaara wrote: > Simon Slavin wrote: >> I assume your database file is on your boot volume. What operating system >> are you using ? >> > > Actually the database is alone in its own partition. Ah. That's better in some ways. But I think you're still

Re: [sqlite] Running out of space

Simon Slavin wrote: > I assume your database file is on your boot volume. What operating system > are you using ? > Actually the database is alone in its own partition. I'm currently trying to avoid the problem by assigning "big enough" partition for the db calculated from the estimated

Re: [sqlite] Running out of space

On 11/25/09 10:50 , "Simon Slavin" wrote: > The message is that if you are short of > space it is already too late for any software to cope with the problem. > I disagree. It all depends on where you set the threshold for "short of space". To give you a trivial example,

Re: [sqlite] Running out of space

On 25 Nov 2009, at 9:40am, Antti Nietosvaara wrote: > I have an application which keeps an index of data in an SQLite > database. I'm trying to figure out the best way to handle the possible > scenario of database filling out the entire hard disk. I could just > delete some of the oldest

Re: [sqlite] Running out of space

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Antti Nietosvaara Sent: 25 November 2009 09:41 To: sqlite-users@sqlite.org Subject: [sqlite] Running out of space Hello, I have an application which keeps an index of data in an SQLite database. I'm trying to figure out the best way

[sqlite] Running out of space

Hello, I have an application which keeps an index of data in an SQLite database. I'm trying to figure out the best way to handle the possible scenario of database filling out the entire hard disk. I could just delete some of the oldest rows, but I wonder if it's possible that even delete