[rarestnews]

The most popular is BerkeleyDB and it's license isn't very friendly for commercial apps. Rest of what I tested are really slow.

Also, most of DBM-style databases suffer from same flaws as disk-based SQLite - they don't use memory cache. I prefer to have slight chance of losing my data, but having 10-100 times faster performance on most queries (RAM vs HDD is often 1:100), rather than 100% consistency and slowness.

Last, but not least, hash-style mySQL is easily distributed and cached.

[gcv]

Have you had a chance to test Tokyo Cabinet?

[rarestnews]

No, actually this is the first time I hear about it. Thanks for a pointer - I'll look into that.

Although the LGPL license seems like a downer - if I understand it correctly it means that either I should distribute my software as open source or compile that particular library into some kind of external .dll, right?

[ibsulon]

It's set up as an external system anyway. You'd have to do extra work to hack it in. Otherwise, that is true.

[rarestnews]

The lib seems impressive. Anything which Python's bindings can do 65K inserts in 110ms deserves a lot of attention!!

Now I just have to attempt to make it's Python bindings compile under Windows :( It's hacking time!

Thanks for the tip!

[aaronblohowiak]

Download VirtualBox and have the best of both worlds!