I’m trying to delete about 500k entries from a database configured to use 64mb max for memtable. I keep getting ErrTxnTooBig error and I really can’t increase the memtable size because I’m using running the code in a mobile os. I came across WriteBatch and it seems to handle ErrTxnTooBig properly only that I cannot read from it. I’m using badger as a database driver for an applications that support multiple databases so changing my implementation isn’t an option so my question is;
How can I read the data being written by WriteBatch I could have a read-only transaction handle the reads for me but my writes won’t reflect until WriteBatch.Flush() is called. Is there a way around this?