is there a way to implement something like this in loopback? LOCK READ INCREMENT UNLOCK I would like to keep counters as database values, each key is a counter (or a setting), and they shouldn...

I have a pair of SQL Server 2014 databases set up as a synchronous AlwaysOn availability group. Both servers are set to the Synchronous commit availability mode, with a session timeout of 50 secon...

Two phase commit is described as an "atomic commitment protocol". I would expect this to mean that all clients see the state of the world from either before a transaction commits, or after it commi...

I have a Node.js application that stores some configuration data in a file. If you change some settings, the configuration file is written to disk. At the moment, I am using a simple fs.writeFile....

I'm looking for a real-world example for the various ACID properties of a database.

How does Cassandra handle concurrent updates to the same key by multiple users? Does Cassandra follow the "Isolation" property from ACID?

I have a minor, one line change (fixing a typo in a string), to a stored procedure that I would like to deploy to our production SQL Server 2005 server as soon as possible. The worry I have is wha...

Aerospike database says, that it is [...] architected with three key objectives: To create a flexible, scalable platform that would meet the needs of today’s web-scale applications To provide ...

Given the following requirements of a persistent key/value store: Only fetch, insert, and full iteration of all values (for exports) are required No deleting values or updating values Keys ...

Does anybody know if Microsoft is planning on having IE9 pass with 100/100 on the Acid 3 test? The current version of IE9 gets a 68/100 on the test (can be viewed here, main site here). What did I...

I am starting research on a project that will need to provide ACID semantics on its database. Due to the nature of the data it is not suitable for storage in common off-the-shelf systems (relation...

This is more of 'inner workings' undestanding question: How do noSQL databases that do not support *A*CID (meaning that they cannot update/insert and then rollback data for more than one object in...

It is not entirely clear from MySQL documentation whether the InnoDB engine implements true serializable isolation1 or snapshot isolation, which is often confusingly called "serializable" too. Whic...

I use Delphi XE2 along with DISQLite v3 (which is basically a port of SQLite3). I love everything about SQLite3, except the lack of concurrent writing, especially that I extensively rely on multi-t...

I am planning to use a NoSQL database like MongoDB as the back-end for my web product. For design concept, there would be around daily minimum 1,000 users. I have doubts: I have read in a bl...

From what I can make out NoSQL databases might be a good option for high intensity data read applications, but are a less good fit if you need to do also do a lot data updates and transactionality ...

Databases like Oracle, SQL Server etc are very good at data integrity. If I wanted to write a data store that I knew would either store some data or fail (i.e. be ACID) then I would use a database ...

Specifically is there some risk that data can be lost? I'm looking at running an intensive transaction processing system where it is critical that nothing be lost. Are there any examples of NoSQL b...

I'm working on an app where I need to persist data in a reliable manner, i.e. updates need to be persisted all-or-nothing even in the face of application crashes and quits etc. However I can't fin...

I would like to test the NoSQL world. This is just curiosity, not an absolute need (yet). I have read a few things about the differences between SQL and NoSQL databases. I'm convinced about the po...

MySql InnoDB is set autocommit off and used default isolation level REPEATABLE READ. There are two scenarioes that two distinct transactions T1 and T2 run in the time sequence below, 1) time T1 T...

I begin a transaction, which is to insert several records into a table. Can I select the latest inserted record out of the database before the transaction commit?

I open the database file and obtain a database connection using open() method of sqlite3 and the connection will not be closed until program exits. If there occurs an unexpected error such as compu...

I have to send an email, write to a file, and call a web service. To maintain consistency, all steps must happen. If any step throws an exception or errors out, all steps must be rolled back. Befo...

I understand, in a fuzzy sort of way, how regular ACID transactions work. You perform some work on a database in such a way that the work is not confirmed until some kind of commit flag is set. The...