SQLitening Support Forum

General => General Board => Topic started by: James Klutho on August 04, 2013, 02:27:15 PM

Title: Berkeley DB
Post by: James Klutho on August 04, 2013, 02:27:15 PM
Has anyone tried using SQLitening with Berkeley DB from Oracle.  It is suppose to be a SQLite drop-in with the advantage of finer grain locking.  Just curious.
Title: Re: Berkeley DB
Post by: Rolf Brandt on August 05, 2013, 03:56:18 AM
I just read the Wikipedia article about Berkeley DB. Sounds very interesting. Could be a real boost. Would be worth trying it out.

Rolf
Title: Re: Berkeley DB
Post by: James Klutho on August 05, 2013, 10:40:46 AM
I downloaded the docs and looked at the C API.  I did not see where the SQLite API calls were.  From I read, I thought those were added a couple of years ago to make Berkeley DB a slick drop in replacement.  The Berkeley DB speed tests on multiuser transactions were about 5 times faster than the SQLite tests.  The commerical license is about $1800 per CPU (but free for a GNU license) but may give a need boost to the remote connections with many users.

Jim
Title: Re: Berkeley DB
Post by: Rolf Brandt on August 06, 2013, 04:17:07 AM
Thats exactly what I thought of, multiuser environment. A lot of my customers host their databases on an online server. But they probably won't be willing to pay the price for an commercial license. My clients are smaller taxi and ambulance services - not exactly the richest clentele.

Rolf