Re:Bedrock – Rock-solid distributed data
by partycoder on Tuesday October 18, 2016 @10:53PM
(#12740642)
Yes... but you said "More powerful", rather than just "Powerful". More implies a comparison with respect to something else... with what specifically?
[ Parent
| on HN ]
Re:Bedrock – Rock-solid distributed data
by quinthar on Tuesday October 18, 2016 @10:57PM
(#12740661)
Well, with respect to stored procedures, I think C++ is a far more powerful language than MySQL's SQL-based approach -- especially since Bedrock plugins can also encapsulate schema changes.
I think Bedrock's replication is definitely more more powerful than MySQL's as well.
So in general I think it's more powerful than MySQL. I'd love to hear your thoughts about where MySQL has the edge, however. Thanks!
Re:Bedrock – Rock-solid distributed data
by partycoder on Tuesday October 18, 2016 @11:39PM
(#12740874)
Does it have transactions?
Re:Bedrock – Rock-solid distributed data
by quinthar on Wednesday October 19, 2016 @12:05AM
(#12740987)
Yes, SQLite has transactions, and Bedrock runs all stored procedures in transactions. However, the Bedrock::DB plugin (which is just a single stored procedure: "query") doesn't expose transactions to the caller. So you couldn't, for example, call "BEGIN TRANSACTION" from the webserver, issue a few queries, and then call "COMMIT". The proper way in Bedrock (and I'd argue, for any modern database) is to package your transactions into stored procedures that execute inside the database itself.