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.
I just read the Wikipedia article about Berkeley DB. Sounds very interesting. Could be a real boost. Would be worth trying it out.
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.
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.