Thanks for the fantastic questions! Answers inline: I had never heard of you guys, this looks amazing! How can you only have > 222 github stars?! >
Heh, feel free to give it one more! > Paxos, so needs at least 3 nodes? > It works with any number of nodes, but I recommend 6 as the ideal: two nodes in each of three different datacenters. More on how the synchronization technology works is here: http://bedrockdb.com/synchronization.html > How do you use it from an application that normally uses sqlite? Is it a > drop-in replacement? I use Node.JS… > BedrockDB has an extremely simple wire protocol based around the concept of "plugins". The "db" plugin is described here: http://bedrockdb.com/db.html, but there is also a full featured "cache" and *extremely* full featured "jobs" plugin as well. The protocol is easy enough that you can "netcat" in and use it effectively by hand, or you can use our PHP binding: https://github.com/Expensify/Bedrock-PHP Interesting that you emulate mysql, given that sqlite tries to be > postgresql compatible… > Our main use for this was to accommodate users who prefer certain clients like SequelPro or Mode Analytics. More information on our MySQL emulation is here: http://bedrockdb.com/mysql.html > Any war stories around developing this? Unexpected issues due to a missing > comma etc? > Omg, so many war stories. This has been powering Expensify from day one, so we have about 8 years of scars as a result. However, Bedrock gains the benefit of all that painfully earned experience, and is hardened against a million real-world edge cases that you won't need to worry about. > Would you recommend this for any workload? I'm paticularly interested in > replicating my append-only event log db. In general I recommend Bedrock for more or less any workload that you would give to a database (which in my experience, is about any workload involving persistent data). I've long wanted to build a "logs" plugin to Bedrock that would provide full-text indexing ala Elasticsearch (which we use at Expensify, but have pretty steady problems with), but it hasn't gotten bad enough yet to worry about. Thanks for asking! -david Founder and CEO of Expensify (and BedrockDB) On Thu, Oct 26, 2017 at 10:19 PM, Wout Mertens <[email protected]> wrote: > I had never heard of you guys, this looks amazing! How can you only have > 222 github stars?! > > Paxos, so needs at least 3 nodes? > > How do you use it from an application that normally uses sqlite? Is it a > drop-in replacement? I use Node.JS… > > Interesting that you emulate mysql, given that sqlite tries to be > postgresql compatible… > > Any war stories around developing this? Unexpected issues due to a missing > comma etc? > > Would you recommend this for any workload? I'm paticularly interested in > replicating my append-only event log db. > > Wout. > > On Thu, Oct 26, 2017, 8:15 AM David Barrett <[email protected]> > wrote: > > > I'm glad you liked it! I'd be happy to answer any questions you have > about > > http://BedrockDB.com, our use of sqlite, or anything else. Thanks for > > listening! > > > > -david > > > > On Wed, Oct 25, 2017 at 4:19 PM, jungle Boogie <[email protected]> > > wrote: > > > > > Hi All, > > > > > > Pardon the usual interruption of complex sqlite questions... > > > > > > David Barrett was interviewed on Floss Weekly today and gave a rave > > > review of his project, which is based on the wonderful sqlite3 > > > database. > > > > > > I'm only 10 minutes into the interview and really love it already! > > > https://twit.tv/shows/floss-weekly/episodes/456 > > > > > > Thanks to David for appearing on the show and of course to the Sqlite3 > > > team for their amazing efforts to make, and maintain the most widely > > > deployed database engine in the world - maybe even in the galaxy. > > > > > > Thanks, > > > j.b. > > > > > > -- > > > ------- > > > inum: 883510009027723 > > > sip: [email protected] > > > _______________________________________________ > > > sqlite-users mailing list > > > [email protected] > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
