News for hackers. Stuff that matters.
Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by virmundi on Sunday April 12, 2015 @05:07PM (#9364736)
So why not BerkleyDB? I couldn't find a comparison to the old standard on the site (granted did just a cursory glance).
Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by beagle3 on Sunday April 12, 2015 @05:59PM (#9364894)
Why BerkleyDB?

BerkleyDB is now AGPL3[0], which some projects have a problem with. (Of course, you can buy a commercial license. Some projects have a problem with that too).

But the main reason, almost regardless of context, as to "why not BerkleyDB" is LMDB[1]. It works way better than everything else, in just about every practical use that has more reads than writes.

The only downside as far as I can tell, is that right now it relies on memory mapping the entire database, so you're limited to ~1GB overall database size on 32 bit systems. There is no practical limit on 64 bit systems. Also, I recall Howard Chu (main LMDB developer) mentioned that in the near future LMDB will gain the ability to manage memory manually - thus removing this restriction as well (for a performance price if used this way).

[0] http://www.oracle.com/technetwork/database/database-technolo...

[1] http://symas.com/mdb/

Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by hyc_symas on Monday April 13, 2015 @02:43PM (#9369525)
The feature for re-mapping on 32bit systems is available here https://gitorious.org/mdb/mdb/source/69d7cb8d44e04f02d8d0c92...:
Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by beagle3 on Monday April 13, 2015 @03:35PM (#9369875)
When will it be merged to the mainline? (or is it already there?) Will it eventually be a run-time option, or always a compile time option?

The latest reference I can find is http://www.openldap.org/lists/openldap-devel/201410/msg00001... - were the problems solved?

Thanks for LMDB. It is awesome.

Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by hyc_symas on Monday April 13, 2015 @09:43PM (#9371600)
It still needs heavier testing before going to mainline. I expect it will only ever be a compile-time option. On 64bit it's pointless, and 32bit is going the way of the dodo.
Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by pron on Sunday April 12, 2015 @05:21PM (#9364777)
BerkeleyDB is awesome, but its license may not be suitable for many organizations. Also, the different design would probably result in different behaviors under different scenarios. It seems like Sophia is optimized for inserts.
Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by halayli on Sunday April 12, 2015 @05:16PM (#9364764)
BerkeleyDB API is ugly. And probably its extra features impact performance.
Re:Sophia: A modern embeddable key-value database – v1.2.2 r... by tremols on Sunday April 12, 2015 @08:24PM (#9365282)
Xodus from JetBrains (Java only / Apache 2 License) looks promising.