[leveldb] How can I create indexes in leveldb?

[Oshin Rawal]

I want to create indexes in leveldb. I created another leveldb to serve as
an index for each field. (mimic-ing what a relational database does when
you add indexes to a table). This approach worked for a small data.
However, when the data grows this dosen't work. Can someone please suggest
how to create indexes?

Thank you :)

[Ren Z]

What do you mean by "this doesn't work"?
I've built small embedded relational db for C# using leveldb (
https://github.com/ren85/linqdb) where indexes were just keys designed to
be sorted by value (for instance table_number:column_number:value:id). So
you can find by value (by seeking the key
table_number:column_number:value:) and iterate from there.

It works well for large db (tested up to 40Gb).

Post by Oshin Rawal
I want to create indexes in leveldb. I created another leveldb to serve
as an index for each field. (mimic-ing what a relational database does when
you add indexes to a table). This approach worked for a small data.
However, when the data grows this dosen't work. Can someone please suggest
how to create indexes?
Thank you :)

[Ren Z]

Forgot to add that data and indexes should be in one db to be able to use
WriteBatch'es functionality for atomic updates.

Post by Oshin Rawal
I want to create indexes in leveldb. I created another leveldb to serve
as an index for each field. (mimic-ing what a relational database does when
you add indexes to a table). This approach worked for a small data.
However, when the data grows this dosen't work. Can someone please suggest
how to create indexes?
Thank you :)