Ethereum Stack Exchange is a question and answer site for users of Ethereum, the decentralized application platform and smart contract enabled blockchain. It only takes a minute to sign up.
Sign up to join this community
I need a reliable ACID database with complex transactions. It is a hassle to do this in Java or other high level languages, especially if the database spans multiple systems and networks. For this purpose, I wanted to use the ACID features of smart contracts (if an error then the blockchain is rolled back) to implement my internal app (a one or two node private network).
Does this make sense? Will there be performance issues? I can wait a second or so before the response.
I can wait a second or so before the response.
This is a crucial requirement, because reading is way slower than with MySQL at al. What you need to do is to
set up a private network
learn about writing and reading data to/from smart contracts (what is possible, and what's not yet)
But be aware, this is not done in a week for Ethereum beginners.
Good Luck !
No, solidity is not ACID compliant. Particularly the isolation1 part of ACID. For example, when running a for-loop that runs transactions or loops through values, if a secondary user runs the program at the same time and executes the same function, the loop will auto-increment to 0 since it's starting over. Solidity in now way should be used as a database and is not ACID compliant, although it is very durable and very consistent, it lacks isolation and atomicity to the fullest extent.
