News for hackers. Stuff that matters.
Re:SQLite As The MP3 Of Data by henning on Wednesday April 15, 2009 @01:53PM (#563853)
If you have a database that's just hash style, why not stick it in a DBM-style database and get a major performance increase?
Re:SQLite As The MP3 Of Data by rarestnews on Wednesday April 15, 2009 @02:00PM (#563867)
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.

Re:SQLite As The MP3 Of Data by gcv on Wednesday April 15, 2009 @02:49PM (#563952)
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?

Re:SQLite As The MP3 Of Data by ibsulon on Wednesday April 15, 2009 @03:32PM (#564034)
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!