Skip to main content
18 votes

Where is the state data stored?

Technically the states are assembled into a state tree (patricia-tree) linked to the account (balance in case of EAOs and balance and storage in case of contract's account) and to the blocks (figures ...
Badr Bellaj's user avatar
  • 18.8k
13 votes
Accepted

Database used for Parity

I'm one of parity devs. We use Rocksdb. It's a key-value database developed by Facebook. We chose it mostly because of it's performance. In our benchmarks it was faster than LevelDB From their ...
debris's user avatar
  • 861
10 votes

Exploring and Analyzing the Ethereum blockchain

I am also interested in analysing the Ethereum blockchain. In fact, I'm primarily looking into smart contracts. While I was researching papers and articles about this, I stumbled upon this paper where ...
Dominik Harz's user avatar
8 votes
Accepted

How to use blockchain as a Database?

The best way to start is to understand the following few concepts and learnings. what is Smart contracts ? What is solidity and how to start writing your domain data or objects in solidity. ...
Abhiram mishra's user avatar
7 votes

If a blockchain is a distributed database, where is the data?

Blockchains are databases from a high-level view, but the underlying technology is different enough to make some assumptions inaccurate. An Excel file is also a database, but with characteristics ...
Matthew Schmidt's user avatar
6 votes
Accepted

Django, Ethereum, Sqlite

It's very difficult to answer with any precision based on a general description of a modest data model with 6 entities. Some comments to hopefully help clarify the big topics. Ethereum consensus ...
Rob Hitchens's user avatar
  • 55.4k
6 votes
Accepted

What is the composition of the blockchain database?

account is a local object to easily track changes on the accounts (with a StateObject db). The size depends on the nbr of transactions you execute with this account. An unused account should be less ...
wiwulo's user avatar
  • 131
5 votes

Which database(s) do the ethereum clients use and why?

Parity is using RocksDB as it's database. From reading here it seems the reason for choosing it was performance. Faster than LevelDB in their tests. Lately though they have hit some performance ...
NoMan'sLand's user avatar
4 votes
Accepted

Best way to store data on the chain

Couple of ideas that might help simplify this and reduce the cost by removing redundant storage. This line: mapping(string => OrganisationObject[]) organisations; seems heavy. I would incline ...
Rob Hitchens's user avatar
  • 55.4k
4 votes

Using Ethereum as a ACID database?

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 ...
n1cK's user avatar
  • 3,388
4 votes

Is it worth to store Ether at the full precision in database?

As the commenters have correctly pointed out, it depends entirely on what you are trying to achieve. You can, and probably should store full-precision strings so you have all significant digits, i.e. ...
Rob Hitchens's user avatar
  • 55.4k
3 votes
Accepted

Is there a practical way for Ethereum networks to handle considerably large volumes of data used by heavy contracts?

An SSTORE of a non-zero value costs 20,000 gas. Each SSTORE can store 32 bytes of information. Double check my math: 1TB / 32 bytes = 31,250,000,000 31,250,000,000 * 20,000 gas * 1 gwei/gas = 625,...
user19510's user avatar
  • 28.1k
3 votes
Accepted

Local caching database for fast retrieval

A two-part answer. "you need to loop": This just jumps out at me and deserves a comment. Smart Contracts don't give you indexed storage but this doesn't imply that a contract should loop over ...
Rob Hitchens's user avatar
  • 55.4k
3 votes

LDB files reading

...or a Go API library, or to explain me what part of Geth accesses the chain files, for being able to develop it myself? Have a look at Geth's database.go, which is part of the ethdb package. For ...
Richard Horrocks's user avatar
3 votes
Accepted

Where should I store GPS data on Ethereum?

Hmm.. you should seriously research Ethereum alot more before proposing this. because it is expensive does not begin to describe how expensive and slow this will be if you wrote all your GPS data to ...
cappy's user avatar
  • 191
3 votes

Database used for Parity

The answer here is slightly out of date. Parity has migrated to use blooms db which is an implementation of a Bloom Filter to reduce overall disk reads. The blooms are a db layer before the kvdb ...
forgetso's user avatar
  • 163
3 votes

If a blockchain is a distributed database, where is the data?

It is a custom structure, not SQL anyways. It contains the previous hash, Nonce, Merkle tree root and the timestamp, very basically, but also may other informations about the block. You can look at ...
A. Grenouilloux's user avatar
3 votes

Are the contents of ethereum storage private?

The contents are private only in the sense that other contracts can't read them if you set them private, but otherwise everything is public. All nodes need to be able to process the data so they also ...
Lauri Peltonen's user avatar
3 votes

Is there any lifespan of data on Rinkeby testnet?

I read that there are pre-autorized nodes which creates blocks on rinkeby testnet. Correct. It's a proof of authority (PoA) network, where certain nodes have the authority to create new blocks. ...
Richard Horrocks's user avatar
3 votes

Is it possible for multiple geth processes to share chain data?

I don't think that is possible, because it will completely break the goal of the ethereum network and may (and should) break the integrity and network validation of transactions and stored data on the ...
Kaki Master Of Time's user avatar
3 votes

how to identify a transaction?

Transaction hashes are unique until there is a hash collision. A hash collision occurs if two different inputs produce the same hash output. The transaction hash is 64 hexadecimal characters (2 ...
Lauri Peltonen's user avatar
2 votes

Connect Ethereum to a database

It's possible to cache the data that's stored on the blockchain in a database and update it frequently (every block?). This can be done simply by querying the blockchain and retrieving an updated ...
Mark Beylin's user avatar
2 votes
Accepted

Ethereum - Does it only have a single blockchain?

Ethereum offers a platform for anyone to create their own applications which are powered by the blockchain technology. Just like Bitcoin, Ethereum also has a public blockchain. So, you can either run ...
galahad's user avatar
  • 3,930
2 votes

what is the difference between Swarm and BigchainDB?

Both Swarm and BigchanDB are complementary to the Ethereum platform. You can use both of them in your Ethereum contracts to either host and distribute content (Swarm) or use a database system (...
Ninja Dragon's user avatar
2 votes

How to save data in my private blockchain?

I suggest that you follow the basic tutorial which shows exactly that. I would advise you to not bother with infrastructure and running your own node at first. You can use the entirely browser-based ...
SCBuergel's user avatar
  • 8,774
2 votes

How to do searching in Ethereum's Ledge? (SQL)

You are correct, ethereum blockchain is a distributed database but you cannot do any query you want (for example, getting all the transactions for a given account needs you to process the whole ...
lalanv's user avatar
  • 300
2 votes

data size on ethereum blockchain

That would be extremely expensive. As the price for 256 bit word is 20,000 gas as stated in yellow paper and current gas price is about 20 gwei eth network stats we may calculate that with current ...
Jakub Wojciechowski's user avatar
2 votes
Accepted

Should I use smart contract for storing huge data and real-time updates?

If you end needing storing lot of data in smart contract, it means you don't understand what it is made for. Storing data in a smart contract is crazy expensive in gas because you change the EVM ...
Itération 122442's user avatar
2 votes
Accepted

Does data storage on private Ethereum blockchain come at no cost?

You would be better off having a traditional DB where those 3 organizations will authenticate and send their data, because: at the present moment, the ethereum network doesn't support 1k tx/s (not ...
Tudor Constantin's user avatar
2 votes
Accepted

Web3 (python) - confirming transaction hash format

The transaction hash is the result of hashing the rlp-encoded transaction with keccak256() (many APIs erroneously call it sha3()). The hash produces 32 bytes data. When hex-encoded, that produces 64 ...
carver's user avatar
  • 6,381

Only top scored, non community-wiki answers of a minimum length are eligible