News for hackers. Stuff that matters.
Re:FoundationDB 6.0 released, featuring multi-region support by continuations on Monday November 19, 2018 @09:26PM (#18491419)
- Secondary Index

- some way to store ordered records to speed up range query

- comparison & benchmarks of FoundationDB vs other distributed DB like TiDB, CockroachDB, ScyllaDB, etc

Re:FoundationDB 6.0 released, featuring multi-region support by ryanworl on Monday November 19, 2018 @09:33PM (#18491450)
Those first two are pretty trivial. Keys are already stored in sorted order in a b-tree. Secondary indexing involves putting the indexed value to the left of the primary key in the key you write.
Re:FoundationDB 6.0 released, featuring multi-region support by continuations on Monday November 19, 2018 @10:01PM (#18491533)
> Keys are already stored in sorted order in a b-tree

I thought FoundationDB stored data in a hash table. Didn't realize it uses a b-tree. Thanks for the clarification.

> Secondary indexing involves putting the indexed value to the left of the primary key in the key you write

By secondary index I meant having a sort order that's different from the primary key sort order.

Re:FoundationDB 6.0 released, featuring multi-region support by rbranson on Monday November 19, 2018 @11:16PM (#18491755)
FoundationDB provides the building blocks. Secondary indexes can be built on top of the regular primary index. Transactions make it possible to maintain a consistent 2I using a K/V interface.