Re: [sqlite] On VACUUM I get "constraint failed"

sue is. > > sqlite> .output db.sql > sqlite> .dump > sqlite> .exit > > sqlite3 -init db.sql test.db > > hope this helps > --preston > > >From: John Duprey <[EMAIL PROTECTED]> > >Reply-To: sqlite-users@sqlite.org > >To: sqlite-users@sqlit

Re: [sqlite] What does SQLITE_FULL - "database is full" mean? How to fix?

Stephen, Thank you. That makes sense. I later confirmed that the file system had temporarily ran out of disk space. -John On 10/17/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi John, > > I believe that SQLite will return with an SQLITE_FULL error if your run > out of disk space, OR if

[sqlite] On VACUUM I get "constraint failed"

We have an SQLite database with a table that has about a million rows. We do a lot of (thousands) of deletes and inserts in this table. Recently, deleting rows has become slow. I assumed the slow down was a result of fragmentation or wasted space due to the deletes. Therefore, I thought

[sqlite] What does SQLITE_FULL - "database is full" mean? How to fix?

Hi all, I just recently got the SQLITE_FULL error while trying to insert a row into a table. What does it mean when the database is full? Out of disk space perhaps or did I hit some internal constraint? Here's a except from my log: Oct 14 17:49:19 [8048/3899832] ERROR: SQL statement failure

[sqlite] What's the safest, most elegant way to copy a live db.

I'd like to copy a database that may or may not be in use. Doing a filesystem copy will not ensure a stable copy. Can I use the sqlite3 CLI and some SQL to do this such that I can wrap it up into a script or do I need to write my own program, that gets a lock and re-creates the DB in a new

Re: [sqlite] SQLite in memory database from SQLite (3.x) file database?

s triggers either. > > On 7/6/05, John Duprey <[EMAIL PROTECTED]> wrote: > > Is it possible to load an SQLite file database into an SQLite "in > > memory" database? If so what is the most efficient method to do this? > > I'm looking for the fastest possi

[sqlite] SQLite in memory database from SQLite (3.x) file database?

Is it possible to load an SQLite file database into an SQLite "in memory" database? If so what is the most efficient method to do this? I'm looking for the fastest possible performance. Taking out the disk I/O seems like the way to go. Thanks, -John

Re: [sqlite] Database is locked on SELECT only calls?

isNT() returns 1(true) I've only seen this database lock problem while access the db file on the (slow) NAS - local file systems seem to work fine. Even accessing it through one of our Windows shares seems to work fine. I'll keep you posted if I find any more information related to this

[sqlite] Database is locked on SELECT only calls?

Hi All, I'm using sqlite 3.2.0 - the native C/C++ interface. I'm seeing something that I haven't seen before. I have 4 programs accessing the same db file. The db file is on a slow Windows network share (NAS device). The 4 programs are the only processes accessing the DB file and all of them