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.
139
questions
37
votes
5
answers
15k
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 ...
- 1,368
28
votes
3
answers
10k
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 ...
- 21.9k
17
votes
4
answers
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, ...
- 281
16
votes
2
answers
10k
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....
- 611
10
votes
2
answers
8k
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 ...
- 779
8
votes
1
answer
990
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, ...
- 1,786
8
votes
2
answers
1k
views
Is it worth to store Ether at the full precision in database?
Ether has precision of 10^18 which makes it impossible to use BIGINT type in database to store values in weis: DECIMAL type should be used instead.
Is it worth to store values in Gwei to stay with ...
- 121
8
votes
1
answer
5k
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/...
- 151
8
votes
1
answer
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 ...
- 81
7
votes
2
answers
2k
views
Database used for Parity
Specific to Geth the database used is LevelDB. But what is the database used for parity?
- 1,784
6
votes
1
answer
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 ...
- 163
4
votes
1
answer
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 ...
- 373
4
votes
2
answers
794
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 ...
- 356
4
votes
1
answer
1k
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 ...
- 339
4
votes
1
answer
275
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....
- 2,710
4
votes
1
answer
943
views
geth error - Fatal: Database has receipts with a legacy format
I'm following this tutorial for testing an ethereum private blockchain using 3 nodes.
Everything works fine but if I stop the nodes I can't restart them using the same command. Each node was running ...
- 43
4
votes
0
answers
2k
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 ...
- 165
4
votes
1
answer
228
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 ...
- 249
3
votes
1
answer
34
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 ...
- 133
3
votes
1
answer
557
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 ...
- 201
3
votes
1
answer
195
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 ...
- 2,640
3
votes
1
answer
170
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 ...
- 223
3
votes
0
answers
368
views
How should a dapp store & query user profile data?
We are currently working on a dApp that will store user profile data and let its users query them. We haven't been able to figure out how to do that efficiently so far, and therefore we need to ask ...
- 31
3
votes
0
answers
29
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 ...
- 31
3
votes
0
answers
315
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 (...
- 31
2
votes
2
answers
915
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 ...
- 21
2
votes
1
answer
624
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.
...
- 409
2
votes
1
answer
1k
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 ...
- 121
2
votes
1
answer
89
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 ...
- 71
2
votes
1
answer
240
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 ...
- 231
2
votes
2
answers
501
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!?
- 21
2
votes
2
answers
4k
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 ...
- 331
2
votes
1
answer
477
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 ...
- 121
2
votes
1
answer
128
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?
- 161
2
votes
1
answer
304
views
Optimizing Backend with a lot of Ethers.js Event listeners
I've been building an nft marketplace backend, on top of a manager contract that manages all the permissioned nft collections.
The idea is that, manager can create erc721 or erc1155 contracts via this ...
- 23
2
votes
1
answer
333
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
- 21
2
votes
4
answers
3k
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 ...
- 395
2
votes
1
answer
4k
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 ...
- 21
2
votes
3
answers
879
views
Decentralized database for ethereum?
I'm looking for a way to store data in a decentralized way such that I can access any record from within the smart contract, probably through oracles I guess?
I've been looking into gundb but not ...
- 75
2
votes
0
answers
203
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 ...
- 441
2
votes
0
answers
389
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 ...
- 1,176
2
votes
0
answers
235
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
0
answers
60
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,795
1
vote
2
answers
324
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;
...
- 579
1
vote
3
answers
579
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 ...
- 133
1
vote
2
answers
525
views
How to interact between DB and smart contract?
I want to create a smart contract and when I transfer coin on it, it's automatically update on the DataBase (I use Cassandra), so you do your things on the website with it and you can win or loose ...
- 11
1
vote
1
answer
1k
views
how to identify a transaction?
I'm trying to store transactions in a database and want to generate a unique identifier from the transaction data. It must not change My data source is api.etherscan.io, and I am currently making ...
- 11
1
vote
1
answer
342
views
Are the contents of ethereum storage private? [closed]
I know that the code is public, but is the contents of storage private?
- 279
1
vote
1
answer
227
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 ...
- 148
1
vote
1
answer
2k
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 ...
