News for hackers. Stuff that matters.
Re:FoundationDB: A distributed unbundled transactional key v... by travisd on Friday March 11, 2022 @05:13PM (#30646667)
i’m also not a db engineer, but i think this is true-ish. however building and maintaining those index tables is hard and probably prone to issues if you can’t update multiple as part of the same transaction.

the other major thing you’d miss is smarter joins. the distributed databases do a lot of work to be able to push down predicates as far down as possible to the physical nodes storing the data.

there’s probably more as well.

Re:FoundationDB: A distributed unbundled transactional key v... by Gaelan on Friday March 11, 2022 @05:42PM (#30646975)
> probably prone to issues if you can’t update multiple as part of the same transaction

IIRC one of FoundationDB's features is that it does support such transactions, so you can easily implement indexing on top of it.