Questions tagged [database]

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.

Filter by
Sorted by
Tagged with
34
votes
5answers
14k views

Exploring and Analyzing the Ethereum blockchain

I would like to explore the data inside of the Ethereum blockchain. All transactions and contracts of the Ethereum Blockchain are stored there. So it's an interesting open dataset and I'd like to get ...
26
votes
3answers
7k views

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

Ethereum clients (such as geth, eth, pyethapp, ethereumj, and ethereumH) download the Ethereum blockchain from their peers and then store a copy of it locally, presumably indexed within some sort of ...
16
votes
4answers
9k views

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

There are a lot of articles describing how Ethereum is just another database, and a number of posts here on this site that talk about storing data on the blockchain itself (e.g., [1], [2]). However, ...
15
votes
2answers
8k views

How to reduce chaindata database size?

Currently chaindata size is more then 10.02 GB. Is there any solution to reduce the size of stored data? Is there a way to store particular database and keep entirely the functionality of client (e.g....
10
votes
2answers
7k views

Fatal: Could not open database: resource temporarily unavailable

I get this error when I run the geth upgradedb command: I0317 08:29:57.792433 4202 chaincmd.go:137] Upgrading blockchain database I0317 08:29:57.792491 4202 database.go:71] Alloted 16MB cache ...
8
votes
1answer
888 views

What is the composition of the blockchain database?

From axic's explanation of the structure of the ethereum database, we learned that data is stored in Merkle Patricia tries, usually inside a LevelDB store. It consists of structures such as blocks, ...
8
votes
1answer
2k views

Is Ethereum suitable for a storage application?

I'm interested to make an app to store some data and I'd rather think that the blockchain might not be the only or the right solution for me. I'd like the users to contribute data and to make that ...
7
votes
1answer
4k views

LDB files reading

I'm looking for the format of the LDB files in order to fetch all the contracts created by my account. I read in a post on reddit (https://www.reddit.com/r/ethereum/comments/64hhp1/...
6
votes
1answer
1k views

Database used for Parity

Specific to Geth the database used is LevelDB. But what is the database used for parity?
5
votes
1answer
4k views

How to use blockchain as a Database?

I'm pretty new to the concept of blockchain and use cases so please bear with me if this sounds to vague or elementary. As, I researched more on this, I wanna know how can we use blockchain as a ...
4
votes
1answer
1k views

Django, Ethereum, Sqlite

I am creating blockchain application in django with 6 main entities .By entities I mean to say these 6 entities will replicate data or you can say consensus mechanism will evolve around these entities ...
4
votes
2answers
553 views

Using Ethereum as a ACID database?

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 ...
4
votes
1answer
259 views

How can I check the current state of a token I made?

How can I check what coins have gone where using the standard coin contract? I know how to check the balance of an address, but I'd like to see something like a ledger of all the current coin balances....
4
votes
1answer
191 views

Why use a private block chain over a shared database?

Isn't a shared database able to provide all the guarantees that a private block chain could provide. Since you can track transactions,have transaction restriction and have authenticated access to ...
3
votes
1answer
29 views

Do contract calls atomically modify contract contents?

Suppose a contract has the following: uint[] arr; function func(int a, int b) { arr.push(a); arr.push(b); } If two clients call func at essentially the same time with (1, 2) and (3, 4), are ...
3
votes
1answer
208 views

Is there any lifespan of data on Rinkeby testnet?

I read that there are pre-autorized nodes which creates blocks on rinkeby testnet. If developers keep publishing smart contract and do transactions for testing purpose isn't the size of testnet will ...
3
votes
1answer
120 views

“Centralized Relational Databases” vs. “Decentralized Blockchain ” : Which one is really more scalable? [closed]

There are many research papers on problem of scalability of blockchains: Just as an example : An Overview of Blockchain Technology: Architecture, Consensus, and Future Trends However, (usually by ...
3
votes
1answer
154 views

Unable to start parity: database migration fails repeatedly

I am unable to start Parity, the database migration fails repeatedly. How in Parity on MacOS (1.4.5 already installed) do I eliminate this error so that my Parity will run? Geth is fine but not ...
3
votes
0answers
295 views

BigChaindb + Ethereum

In BigChaindb paper, it's mentioned that it's compatible with Ethereum and is complementary to Ethereum. But BigChaindb has has its own consensus. Question 1: How can BigChaindb work with Ethereum (...
2
votes
2answers
164 views

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

I would like to know if it is at all possible to have multiple geth processes share the same chain data. I currently have multiple nodes (for a private chain) connected to the same file system via ...
2
votes
1answer
314 views

Developing a CRUD database in Solidity

I want to implement a database in a private blockchain. It consists of four tables and my idea is to use four smart contracts, one for one table. For each table i'll put the corresponding attributes ...
2
votes
1answer
75 views

Can i change data in a database using smart contract and oraclize?

i understand that smart contract and oraclize can be use to get data from a database but can i manipulate the data inside the database using smart contract and oraclize? If so how can i do it? Can I ...
2
votes
2answers
470 views

data size on ethereum blockchain

can I store a big data size, like 100TB on ethereum blockchain? and then, is this mean that all clients should download 100TB to get full blockchain data!?
2
votes
2answers
3k views

How to save data in my private blockchain?

I am running a private blockchain using geth as the client. I want to save some custom variables in my chain. I know there is a practical limitation on the storage capabilities as it would require ...
2
votes
1answer
431 views

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

Recently, I have a question about searching function in blockchain. Blockchain is a distributed database and as a database, there should be some searching functions such as "Select", "Join". I am ...
2
votes
1answer
118 views

Ethereum - Does it only have a single blockchain?

I still do not get if ethereum creators want it to be single blockchain or not? If not, where are instructions for creating my own blockchain to play with?
2
votes
1answer
19 views

What is the difference between IPDB and Blockchain Databases?

I wanted to know what are the differences between IPFS, interplanetary file system and a block chain database like IPDB and BigChainDB
2
votes
1answer
202 views

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

Knowing that: In a private Ethereum blockchain, I can have no value of ether and basically allocate as much ether as I want. Storing data on a public blockchain is a costly affair If I were to ...
2
votes
4answers
1k views

Would it make sense to use a SQL database to store the data of a Dapp?

Let's say that I want to develop a Dapp and I need to store different information about the users. This information must not be public as not all the users are allowed to see all the information ...
2
votes
1answer
3k views

How to store small database, editable data on blockchain accessible by smart contract?

New to blockchain and smart contracts. Been doing research and I realize I can't update my transaction smart contract. Is it possible to store database data as an entry to the ledger or in another ...
2
votes
1answer
103 views

How can a smart contract store mutable data outside blockchain?

As storing persistent data on blockchain is costly due to the storage operation being gas-expensive, what are the solutions to store mutable data outside the realm of blockchain from within a smart ...
2
votes
0answers
659 views

How Merkle trees are implemented in a database exactly

I have just checked out these resources: What is a Merkle Tree? Beginner’s Guide to this Blockchain Component Using Merkle trees to detect inconsistencies in data Exploring the use of Hash Trees for ...
2
votes
0answers
22 views

Art registry site: isn't this just a centralized DB?

Just trying to wrap my head around the claims here:: https://www.artory.com/how-it-works/ Essentially they work with an industry partner (auction houses like Christie's), use all of the information ...
2
votes
0answers
144 views

How can I connect to the local Rocksdb instance used by my parity node?

I want to see everyones balances, and eventually try to create a realtime visualisation of the state. If I have a node with 10 GB of disk space used by the db, I understand this is Rocksdb taking up ...
2
votes
0answers
349 views

What is the best way to store and access large volume of data in blockchain? [duplicate]

I was creating a Dapp which will get KYC information from the user, I want to store this data in the blockchain. This data will be accessible through API and it will be used to do KYC process. In ...
2
votes
0answers
203 views

What is the physical location of Blockchain?

Hello everyone i am new in this technology and i am confused please clear my few doubts. Thanks in advance. Blockchain consist of Blocks but where these blocks are stored, i mean what is the physical ...
2
votes
0answers
57 views

Updateable contract design: Database contract only accessible through setters and getters? [duplicate]

Hey I'm designing a Dapp that has a database contract and a contract with the logic side. The only way I can see of making this work is through having the logic contract make a call to a getter or ...
1
vote
2answers
249 views

Best way to store data on the chain

Follow up on: Web3J: TypeError: MyContract is not a constructor Here is how my contract looks like: contract OrganisationsFactory { mapping(string => OrganisationObject[]) organisations; ...
1
vote
1answer
291 views

Are the contents of ethereum storage private? [closed]

I know that the code is public, but is the contents of storage private?
1
vote
1answer
204 views

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

It's not a secret that a single contract could potentially store quite a large volume of data (1, 2). Of course, it takes some gas, but it doesn't seem to cap strictly the overall volume of data to be ...
1
vote
3answers
377 views

Where should I store GPS data on Ethereum?

Where should I store GPS (or other frequently changing, content searchable data on Ethereum)? Blockchain is not the best place for this kind of data, because it is expensive, but swarm is not ...
1
vote
1answer
26 views

Smart contract DB

Is it a good practice to create a smart contract to serve as a DB table? For example, lets say that I have users that need to create Operations. My operations objects need to contain id, description,...
1
vote
1answer
104 views

Database connection with smart contract

I am developing a Dapp, which has a smart contract in solidity and uses truffle framework. My smart contract has a constructor that takes a value as an argument I want to initialize this smart ...
1
vote
1answer
86 views

Why transactions/contracts aren't priced/tracked based on computer running time

Amazon AWS and Google Cloud all base their pricing off of, among a few other things, the amount of compute and storage used. For compute, it's based on time, how much time the computer runs. This is ...
1
vote
2answers
71 views

Thinking through from traditional DB to ETH

I am looking for a data structure kind of like this: [ "data": { "id": 0, "hash" : "5feceb66ffc86f38d952786c6d696c79c2dbc239dd4e91b46729d73a27fb57e9", "owner" : 0, "status" : "...
1
vote
1answer
133 views

Web3 (python) - confirming transaction hash format

Due to the fact, that I am storing txId obtained from the user, before determining whether transaction has been ended or not, I want to make sure that the transaction hash, which will be stored in my ...
1
vote
1answer
1k views

Local caching database for fast retrieval

I'm currently working on dApps for a private blockchain based on ethereum. While it works fine and the dApps really show the power of the blockchain it lacks the speed and versatility of a SQL ...
1
vote
2answers
34 views

Better Platform to store data out of ethereum blockchain

What can be the better alternative for someone who is willing to store data off-chain? What smart-contract suppose to do is just sign a transaction and perform, while every piece of information needs ...
1
vote
1answer
30 views

What is the best way to store data/information while writing smartcontract?

Smart contracts are immutable. Unless we're 100% sure that our smart-contract is fully functional without any exception we never want to push that in the main net. That's why we have public test net. ...
1
vote
2answers
44 views

What happens if you modify the blockchain database out of band?

I understand that the data in a blockchain is stored in a database. E.g., this post states that Ethereum uses LevelDb or RocksDb. I expect that normally the only access to this database is through ...