Berkeley DB drop in replacement for SQLIte3 supporting better concurrency: has anyone tried it?

[Glen Newton]

I was wondering if anyone has tried to replace SQLIte in any of the Go sqlite drivers with the "drop-in replacement" of Oracle's 

Berkeley DB SQL API? http://www.oracle.com/technetwork/database/berkeleydb/overview/sql-160887.html

If yes, have you noticed any problems or experienced improved performance?

I found a reference of someone doing something similar for Python http://charlesleifer.com/blog/updated-instructions-for-compiling-berkeleydb-with-sqlite-for-use-with-python/

but no comments on performance.

The reason I am interested is that SQLIte - as amazingingly good as it is - does not scale well in the area of concurrent writes, whereas Berkeley DB SQL does. 

For some use cases where concurrent write performance is limited by SQLite, this would make a SQLite-ish solution via BDB SQL more viable.

Some more references:

- Oracle Berkeley DB SQL API vs. SQLite API – A Technical Evaluation   http://www.oracle.com/technetwork/database/berkeleydb/learnmore/bdbvssqlite-wp-186779.pdf

- Oracle Berkeley DB SQL API vs. SQLite API – Integration, Benefits and Differences   http://www.oracle.com/technetwork/database/berkeleydb/bdb-sqlite-comparison-wp-176431.pdf

Of course, the documents suggesting BDB better than SQLite for this use case come from the vendor, so caveat emptor.

I would also like to see some of the SQL performance tests run against both of these to compare them  (perhaps from http://www.tpc.org/ ?  I don't know much about these...)

I also do not know how other important things compare, like query planning/optimization, which may be stronger / more mature in SQLite.

Thanks,

Glen

[Glen Newton]

Ah, related: just found this: mattn/go-sqlite3 » Integrate with Berkeley DB SQL API https://www.bountysource.com/issues/9722638-integrate-with-berkeley-db-sql-api
(9 months ago)

'How quickly is Berkeley DB SQL compared to SQLite?' http://incorrectcode.news/question/41483/how-fast-is-berkeley-db-sql-compared-to-sqlite/
Nov 2015

Glen

[dani...@itcentralstation.com]

You may also find this direct comparison between Berkeley DB and SQLite on IT Central Station to be helpful: https://goo.gl/eRMLlN.