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
38 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 ...
wacax's user avatar
  • 1,388
29 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 ...
Jeff Coleman's user avatar
17 votes
4 answers
10k 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, ...
eykanal's user avatar
  • 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....
Alex Koz.'s user avatar
  • 621
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 ...
Kizito's user avatar
  • 779
8 votes
1 answer
1k 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, ...
MrChico's user avatar
  • 1,786
8 votes
2 answers
2k 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 ...
origaminal's user avatar
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/...
sbragagnolo's user avatar
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 ...
user1861388's user avatar
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?
Susmit's user avatar
  • 1,804
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 ...
tortuga's user avatar
  • 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 ...
mohammad obaid's user avatar
4 votes
2 answers
808 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 ...
Jus12's user avatar
  • 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 ...
Shubham Chadokar's user avatar
4 votes
1 answer
278 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....
ZMitton's user avatar
  • 2,740
4 votes
1 answer
1k 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 ...
Zigobs's user avatar
  • 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 ...
Lance's user avatar
  • 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 ...
Mustafa Khan's user avatar
3 votes
1 answer
35 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 ...
bitconfused's user avatar
3 votes
1 answer
574 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 ...
sherlock's user avatar
  • 201
3 votes
1 answer
211 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 ...
Questioner's user avatar
  • 2,670
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 ...
b glen's user avatar
  • 223
3 votes
0 answers
379 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 ...
Ay3914586's user avatar
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 ...
enodren's user avatar
  • 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 (...
user4564798's user avatar
2 votes
2 answers
1k 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 ...
Louis Lamia's user avatar
2 votes
1 answer
716 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. ...
NinjaMAN's user avatar
  • 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 ...
AleWolf's user avatar
  • 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 ...
Sienz Pz's user avatar
2 votes
1 answer
247 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 ...
Chaitanya Bapat's user avatar
2 votes
2 answers
506 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!?
Max's user avatar
  • 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 ...
anonymous's user avatar
  • 351
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 ...
happy crazy's user avatar
2 votes
1 answer
133 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?
Alex Martian's user avatar
2 votes
1 answer
360 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 ...
Rafael's user avatar
  • 23
2 votes
1 answer
342 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
user60604's user avatar
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 ...
David's user avatar
  • 405
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 ...
Chris's user avatar
  • 21
2 votes
3 answers
886 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 ...
Sc4R's user avatar
  • 75
2 votes
0 answers
206 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 ...
Tomachi's user avatar
  • 451
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 ...
Karthikeyan Thangavel's user avatar
2 votes
0 answers
245 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 ...
ramkrishna kushwaha's user avatar
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 ...
ethereal's user avatar
  • 1,805
1 vote
2 answers
339 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; ...
0xtuytuy's user avatar
  • 599
1 vote
3 answers
594 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 ...
Faz's user avatar
  • 153
1 vote
2 answers
606 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 ...
Louis HUORT's user avatar
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 ...
iampomo's user avatar
  • 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?
jazzhole's user avatar
  • 279
1 vote
1 answer
228 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 ...
sainr's user avatar
  • 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 ...
just_trying_stuff's user avatar