Have you had a chance to test Tokyo Cabinet?
Re:SQLite As The MP3 Of Data
by rarestnews on Wednesday April 15, 2009 @03:16PM
(#564006)
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?
It's set up as an external system anyway. You'd have to do extra work to hack it in. Otherwise, that is true.
Re:SQLite As The MP3 Of Data
by rarestnews on Wednesday April 15, 2009 @03:41PM
(#564047)
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!
Re:SQLite As The MP3 Of Data
by aaronblohowiak on Wednesday April 15, 2009 @06:46PM
(#564300)
Download VirtualBox and have the best of both worlds!
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.