Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
1 vote
0 answers
14 views

High efficiency method to query chain db

I am running two archive nodes, one is using Geth and the other Erigon. I have to run a pretty heavy duty indexing process, and making JSON-RPC calls to fetch the data is not fast enough, even if the ...
Riccardo Perego's user avatar
0 votes
0 answers
5 views

Cannot start Moralis self-hosted server

I tried self hosting the Moralis server using the tutorials in the website ,but I get the error referenceerror: indexeddb is not defined Since I am not into the backend servers,I could not comprehend ...
Raaghav Manivel's user avatar
0 votes
0 answers
7 views

For a custom trie that uses the state trie methods and functionality, can triestate.Set be skipped?

The Update method in the Database class in trie package, takes a parameter *triestate.Set. Is it possible to skip this variable, and simply pass &triestate.Set{} to it? I am using Update method ...
BipedalJoe's user avatar
0 votes
1 answer
48 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
2 answers
30 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
31 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 ...
Anuj Kumar's user avatar
0 votes
3 answers
893 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
3 votes
2 answers
28 views

Exploring LevelDB

I am a beginner studying blockchain in Korea. Recently, I completed 100% synchronization of the goerli testnet using geth as my client. I want to visualize the chaindata/.sst files. Also, I am curious ...
이주희's user avatar
1 vote
1 answer
81 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
0 votes
0 answers
175 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
1 vote
1 answer
195 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
385 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
0 votes
1 answer
48 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 ...
Falcon Stakepool's user avatar
0 votes
1 answer
34 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 ...
sagooding's user avatar
  • 111
2 votes
1 answer
391 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
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
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
0 votes
1 answer
133 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
41 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
260 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: ...
IceDog's user avatar
  • 3
0 votes
1 answer
225 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 ...
Dumbo's user avatar
  • 1
0 votes
1 answer
342 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
1 vote
2 answers
329 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
0 votes
1 answer
71 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,610
2 votes
2 answers
652 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
0 votes
2 answers
2k 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
97 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
  • 61
1 vote
1 answer
247 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 ...
Marc's user avatar
  • 267
3 votes
0 answers
384 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
0 votes
2 answers
757 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 ...
user3473330's user avatar
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
224 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
40 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
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, ...
BeyondGalaxy's user avatar
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
1 vote
2 answers
178 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 ...
NinjaMAN's user avatar
  • 419
0 votes
1 answer
48 views

Ethereum Smartcontracts with YottaChain

I am very much curious about this new storage system YottaChain. Can someone point me good articles/videos/sources as a reference to go through and understand its implementation with ethereum smart-...
NinjaMAN's user avatar
  • 419
2 votes
1 answer
742 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
  • 419
0 votes
2 answers
160 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
1 vote
2 answers
139 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
2 votes
1 answer
343 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
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 ...
Pari Deshpande's user avatar
1 vote
1 answer
40 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,...
eth_ethusiast's user avatar
0 votes
1 answer
140 views

How data is stored in Ethereum blockchain?

If I become a full node in Ethereum and retrieve the current state, how all this data is going to be stored in my physical drive?
John's user avatar
  • 35
0 votes
1 answer
146 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
3 votes
1 answer
580 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
0 votes
1 answer
188 views

Is there any chance to retrieve data on a database(sql) to a smart contract [duplicate]

I want to write a smart contract that gets id numbers as inputs and then retrieve data that are recorded in a database.Is there any specific database for that process.
lasitha431's user avatar
0 votes
1 answer
405 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', ...
superrman777's user avatar