You may also find this direct comparison between Berkeley DB and SQLite on IT Central Station to be helpful: https://goo.gl/eRMLlN.
On Thursday, 7 January 2016 22:02:31 UTC+2, Glen Newton wrote: > > Ah, related: just found this: mattn/go-sqlite3 > <https://www.bountysource.com/teams/go-sqlite3/issues?tracker_ids=32581> > » 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 > > > On Thursday, January 7, 2016 at 2:54:07 PM UTC-5, Glen Newton wrote: >> >> 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 >> > -- You received this message because you are subscribed to the Google Groups "golang-nuts" group. To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
