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
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 ...
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/...
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) { ...
0 votes
2 answers
570 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 ...
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 ...
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 ...
0 votes
2 answers
29 views

Web3 Schema Update

I understand that web3 smart contracts are decentralised and the code once written cannot be updated. They are immutable. Imagine my app stores user profile in a smart contract. It has name in it for ...
1 vote
1 answer
60 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 ...
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 ...
1 vote
2 answers
285 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 ...
0 votes
2 answers
290 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.
0 votes
0 answers
167 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 ...
1 vote
0 answers
148 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 ...
1 vote
2 answers
299 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 ...
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?
0 votes
1 answer
44 views

Deploy of subgraph fails in Amazon EC2 Instance

I want to run graph-node (The Graph) in an Amazon EC2 Instance. I have setup everything with docker-compose and the 3 containers (graph-node, ipfs and postgres) are running smoothly. I have also setup ...
1 vote
2 answers
602 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 ...
0 votes
1 answer
31 views

How can I get a large amount of Ethereum transactions in a database without running my own node? Does a database like this exist already?

I am doing research into Ethereum transactions and I simply need a database of 1000 transactions or just about 10 blocks worth of transactions. What is the easiest and fastest way to acquire this? Do ...
2 votes
1 answer
355 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 ...
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 ...
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 ...
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 ...
0 votes
1 answer
108 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 ...
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 ...
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 ...
0 votes
1 answer
240 views

Can use smart contract as a CURD database?

I am a full stack enginer. I am going to develop a decentralized social app. Fully not have backend. My choises: Frontend: react or vue. Big content storage: arweave. Cheaper and faster chain: ...
0 votes
1 answer
218 views

How to add databases to smart contract?

I creating dApp and I want to add some sort of registration pannel(add nickname to wallet address) and its nessesary to store this data on db (public wallet address, nickname, email(optionally)). So ...
1 vote
1 answer
294 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 ...
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 ...
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 ...
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 ...
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 ...
1 vote
1 answer
239 views

How to securely decrypt game data inside smart contract

I have a problem I haven't been able to figure out, as follows: Suppose I have a game running on the blockchain (a solidity/smart contract game) where there are a limited number of plots of land that ...
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 ...
0 votes
2 answers
698 views

Physical location of Ethereum World State Trie

First of all, allow me to admit to a mistake I made on the other sites like this one, when I asked almost the same question. I feel it is ethical to explain this. I mistakenly asked this question on ...
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 ...
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 ...
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 ...
0 votes
1 answer
128 views

Are Transactions and Receipts 1-to-1?

Ethereum maintains an Transaction Trie and a Receipts Trie and I'm trying to visualize how that data would be contained in a relational database. I believe both Tries would have a primary key of ...
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 ...
0 votes
1 answer
403 views

Storing transactions result into database

I need to store the transaction details to my database. And here is my code: var rawTx = { nonce: nonce, gas: estimate_gas, to: contract_add, value: '0x0', ...
0 votes
0 answers
219 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 ...
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 ...
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 vote
1 answer
856 views

How to convert Postgres BYTEA format to Ethereum string address (PYTHON)?

Bytea (hex) is format of PSQL. It is used by many explorers/dapps/apps to store ethereum address. how to convert this format to Python String? By default it is read as a memory view. More on Bytea: ...
1 vote
0 answers
17 views

Verification system for vaccination, medicine [closed]

Project Idea, Need Guidance. Verification system for vaccination. Vaccination confirmation per individual, multiple times, different locations. Can also be used for ticketing, voucher confirmation, ...
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 ...
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 ...
1 vote
2 answers
2k views

Accessing database in solidity

I am developing a voting application using blockchain (ganache). So basically i am registering the candidates by a web form and storing the data in phpmyadmin database. Now i want to access this data ...
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. ...