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.

46 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
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
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
1 vote
1 answer
63 views

Does any one have the archive node data?

I want to analyze the archive node data in geth, but the sync seems slow, is there any archive node data? node data with a very lower height will be ok.I just want to run the cmd 'geth db inspect' in ...
user2712's user avatar
1 vote
0 answers
153 views

Does the graph-node re-sync all blocks every time it gets restarted?

I am running an EC2 instance with graph-node, using docker. Let's assume that I have a list of smart contracts that I want my subgraph to track and, at some point, that list gets updated; so I have to ...
Falcon Stakepool's user avatar
1 vote
2 answers
310 views

indexing all Ethereum fullnode data in a relational database

I want to develop a web app like etherscan. I realized I have to extract and index all datas in a relational database. I have chosen Posturesql. All Datas I want to save are: block uncle transaction ...
Shahab's user avatar
  • 11
1 vote
0 answers
27 views

What is the process through which transactions and transaction receipts are found on a Ethereum database

Transactions and transaction receipts are constructed into Merkle Patricia Tries using the rlp encoded index with which they appear in a block. Once all tx information is rlp & hex prefix encoded ...
Andreas Dilaveris's user avatar
1 vote
1 answer
296 views

What Is The Best Way To Retrieve All Transactions of a Certain Token?

I am currently trying to better understand purchasing trends of certain NFTs (ERC-721). Currently, I am doing this using EtherScan's API. Now, the API calls return "up to a maximum of the last ...
curiousHuman's user avatar
1 vote
2 answers
137 views

Store encrypted data on-chain VS on cloud

So, I am currently doing research for a project and an interesting question was born. If I have data that I want to store encrypted, why to choose blockchain instead of a cloud provider? Since the ...
John's user avatar
  • 35
1 vote
0 answers
344 views

Read data from parity .sst Files

I'm working on a c# application that reads the data from ethereum parity and parses it. As of present i managed to read the key value pairs from the files and convert them to hex. While looking at the ...
K.Bezz's user avatar
  • 21
1 vote
0 answers
133 views

How to open Parity database from javascript (how to open column families)?

I am trying to connect to Parity database at var dbPath = 'C:\\Users\\username\\AppData\\Local\\Parity\\Ethereum\\chains\\ethereum\\db\\906a34e69aec8c0d\\overlayrecent\\db' form javascript using npm ...
jabone's user avatar
  • 241
1 vote
0 answers
631 views

how do you handle token value data type in database?

Ones who do exchange / Investment platforms development, all ERC20 tokens has its atomic unit and only moved by specifying value in its atomic form. for eg: 1 BuritoToken with unit decimals as 18, ...
Shanthakumar's user avatar
1 vote
0 answers
347 views

Listen for Solidity Event With X Number of Confirmations

I presume Solidity events are fired the moment the block that includes its transaction is mined -- please correct me if I'm wrong. I need to sync the transaction status locally but wish to only save ...
Jerry Ji's user avatar
  • 361
1 vote
2 answers
286 views

What data should be stored in contracts or tokens

After watching a sales force movie where they have a session on how they are integrating their product into the blockchain they talk of an example on capturing all the data from the supply chain ...
Matt's user avatar
  • 163
1 vote
0 answers
31 views

How load out data from blockchain when it occupies too much space?

If the blockchain working long enough it fills the memory of the mining device, how to load out the data and then rerun the system? and why does my mining device has different miner address every time ...
Nurbolat K's user avatar
1 vote
1 answer
1k views

Where do you save the application data of a Dapp?

Let's say that I want to implement a Dapp similar to Facebook. Each user has its own profile, pictures and information. Usually you would use a database to store all this data. This guarantees that ...
David's user avatar
  • 405
1 vote
0 answers
433 views

For what data does Ethereum use Memory Database, and for what does it use Level Database

Ethereum uses two databases Memory database and Level Database. Is data stored in MemoryDatabase different than LevelDb? In what cases is one database used over other? The question is different from -...
Shubham Chaudhary's user avatar
1 vote
1 answer
48 views

Best Practice for Arrays you will Write to Often

I want to build an App with an array data structure that I would like to keep private. So far, I've wanted to build it between IPFS and Ethereum. But what would be best practice for an array that I ...
user3321729's user avatar
1 vote
0 answers
324 views

Largest Ethereum Transactions

Does anyone know of a database of large Ethereum transactions (in terms of Gas)? I am looking for large transactions on the testnet (Ropsten) or mainnet for analysis, ideally in the hundreds of ...
Gawnie's user avatar
  • 331
1 vote
0 answers
237 views

Ethereum raw data files folder

Where is the folder on Mac OSX where Ethereum put raw blockchain data? I find only *.ldb files, but as I understand it is only the index of full database. For example, in Bitcoin there is blk*.dat ...
Denis Leonov's user avatar
0 votes
1 answer
14 views

Foundry Anvil (local test network) database

I am using the Foundray Anvil local network to test my application. Is there an option while initiating the test network to store data of blockchain in a specific location? Similar to this --db /my/...
111Seven's user avatar
0 votes
0 answers
13 views

How to do data analytics on-chain

as I understand it, data analytics (like calculating averages etc) on blockchain data is usually done off-chain (ie. you obtain data from the blockchain via say a third party API call or directly from ...
Qustack's user avatar
0 votes
2 answers
593 views

Sepolia Testnet

I am using Sepolia testnet to work and develop my dapp. I created the contract and deployed to the Sepolia network. I will be making several transactions in this similar manner. I know it is possible ...
111Seven's user avatar
0 votes
0 answers
171 views

Calculate uniswap v3 fees for position from swap events

I need to calculate uncollected fees for uniswapV3 position let's say from yesterday. I scanned for all swap events in the liquidity pool and saved them to my DB. Also I have in the database all ...
Denis's user avatar
  • 1
0 votes
0 answers
15 views

Blockchain Layer on top of a database for Query Processing

Is it possible to have a blockchain layer on top of a database? I have heard about bigchainDB doing exactly the same but I wanted to know if there lies any advantage in doing so?
Suvam Tamang's user avatar
0 votes
1 answer
109 views

How to automate tokenomics research and data collection?

I want to create a tokenomics database. I want to build a bot to automate data collection that answers for each token on the blockchain some of the questions asked and answered in this article. I am a ...
Mowzer's user avatar
  • 211
0 votes
1 answer
39 views

What Database (or maybe the whole stack) should I use for a webapp?

I am thinking of making a webapp where I have to save some private data and other data that could be public. For simplicity let's say it's a quizzes page but it logs in with Metamask. We are going to ...
Tomas Marengo's user avatar
0 votes
1 answer
321 views

Fetching data from smart contract to show on front end

So right now i have a function in my smart contract that is able to fetch all open listings(nft marketplace). It looks like this: function fetchListings() external view returns (Listing[] memory) { ...
Zercon's user avatar
  • 26
0 votes
1 answer
69 views

How does an NFT marketplace give a verified badge?

I am trying to build an NFT marketplace. I see that Opensea provides a verifiable account badge. Here is the link for documentation I wonder how Opensea uniquely identifies the user if it is qualified ...
Yilmaz's user avatar
  • 1,570
0 votes
1 answer
1k views

Database column type (postgres) for storing erc20 token balances the correct way

I have an app that is pulling all erc20 tokens for each address. Now I want to store these values already calculated to the right amount into my postgres db. Right now, I am using the column type of ...
user16780074's user avatar
0 votes
0 answers
44 views

How could I have a custom, stored in database currency be a requirement to call a smart contract function for my NFT Game?

Im currently developing an NFT Game, where our idea is to have a custom currency that is stored in the database and serves to buy some items(stored in database aswell), and to breed the NFTs, how can ...
Edudino's user avatar
0 votes
0 answers
59 views

Storage systems for massive quantities of data

I'm creating a decentralized social media protocol and have begun trying to figure out the right data storage scheme. It feels like storing directly on chain would prove costly, inefficient, and ...
Matt's user avatar
  • 21
0 votes
2 answers
94 views

Backend for DApp

I'm developing a DApp, and I need some logic to handle events. This shouldn't be done in the Frontend of the application, right? So what would a good approach look like. I thought about a Java-Backend ...
Luex's user avatar
  • 51
0 votes
0 answers
107 views

Index and Search Archive node database for method hash

I want to find similar method hashes, either from contract bytecode or transaction hashes (which in theory are the same because the contract bytecode comes from a contract creation transaction) I have ...
CQM's user avatar
  • 167
0 votes
0 answers
221 views

NULL value returned when trying to fetch data from solidity smart contract from react js

I'm trying to make a Student Management System using Ethereum blockchain. I've linked my smart contract (solidity) with react frontend. I try to get the setted value from the smart contract, but this ...
Shru's user avatar
  • 1
0 votes
0 answers
39 views

How to store private data on blockchain application using a database?

I'm doing a project on healthcare data management Dapp. My project contains the actors as the doctor, patient and hospital. Actors have the attributes them self like name, id, age, hospital ...
hunter21actual's user avatar
0 votes
2 answers
152 views

Data validation using Ethereum

I'm pretty new to the BC and specifically Ethereum world and I'm just starting to scratch the surface of the potential applications of this powerful technology. As I'm approaching to build my first ...
Erik Capoccetta's user avatar
0 votes
1 answer
145 views

Saving huge volumes of data in Ethereum

I would like to save daily prices of about 3000 items (about 2mb in size) on a public blockchain, and I would like to create a DAPP to retrieve the data. I am considering saving the data on Ethereum. ...
Pongal's user avatar
  • 1
0 votes
0 answers
37 views

Get Submitted Data from Blockchain

I'm using a html code connected to my smart contract via testrpc node, where users submit temperature data. How can I view that data from the smart contract, each time I view from the contract I see ...
user51821's user avatar
  • 159
0 votes
1 answer
94 views

Fast access of any given transaction in the blockchain

That is a conceptual question that I am asking here. We are trying to developp an application to securely store the hashes of some files in the blockchain. Everything is automated (taking a file as ...
user avatar
0 votes
2 answers
291 views

How can i read transation data from ethereum to file or database?

I want read transations data "input" field from ethereum to file.How can i do it?thanks.
Yinglong Zhang's user avatar
0 votes
0 answers
32 views

Is it possible to migrate your db(users login credentials) to ethereum private network?

I am thinking of migrating db to any of blockchain technologies for security purposes. I have to opt from hyperledger or ethereum private network. Is it good idea or any trades off I should be aware ...
Anam Nizami's user avatar