> When the database is full What do you mean by a full database? Do you mean when the operating system has run out of disk space? A SQLite database can hold millions of rows, so technically, a database cannot be 'full'.
It would be easier explaining the full issue and what you consider the problem, rather than asking for help on a solution which may not be required. Thanks, Chris On Thu, Apr 4, 2019 at 11:53 AM Arthur Blondel <[email protected]> wrote: > Hello > > When I try to insert new data to a full SQLite database, I need to remove > much more than really needed. I'm doing the following: > > while(1) { > do { > status = insert_1_row_to_db(); > if (status == full) { > remove_one_row_from_db(); > } > } while (status == full);} > > The inserted data has always the same size. When the database is full, > removing only one row is enough to insert the new one. But after a while, I > need to remove 30, 40 and even more the 100 rows to be able to insert one > new row. Is it the correct behavior of SQLite? Is there a way to remove > only what is needed and no more? Thanks > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
