mleku on Nostr: if you design your indexes well, badger's separate key and value log design gives you ...

if you design your indexes well, badger's separate key and value log design gives you much better search performance for the memory used

and yes, it's very resilient, i have not once no matter how stupid my code got, corrupted the database, it's very resilient

also, look into batching... i used this to do garbage collection, but it can be used for all sorts of things, runs processes over the entire database in parallel for a performance boost proportional to the number of threads you throw at it