I would like to use sqlite as a FIFO buffer. I know this isn't its intended use, but I a) need its robust storage backend and b) also need to apply and queries to it (so, it will not be actually used only as a FIFO).
My questions are the following: - How would sqlite scale as a FIFO buffer (where entries are 'pushed' in the last row of the db, and 'popped' from the first raw of the db), for a DB size in the order of a few GBs, for both read and write operations? - When entries are 'popped' (i.e. the first entry in the table is removed) the DB creates a 'hole' in the file. Is it guaranteed that, as long as the new entries fill into the holes, the DB size won't increase? That is, can I bound the maximum db file size by making sure that I delete as much data as needed before inserting new data? Thank you in advance. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
