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
0answers
7 views

Ethereum and DBMS

If Ethereum is a database, does that make smart contracts or decentralized applications a DBMS? If not, what kind of DBMS is related to Ethereum? Or any other blockchain?
1
vote
2answers
201 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
1answer
183 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
0answers
14 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 ...
1
vote
1answer
627 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
2answers
218 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
0answers
16 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
2answers
2k views

Database used for Parity

Specific to Geth the database used is LevelDB. But what is the database used for parity?
1
vote
1answer
433 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: ...
2
votes
1answer
230 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
1answer
90 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 ...
4
votes
1answer
196 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
0answers
12 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
1answer
72 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
0answers
12 views

Get past events or store them in traditional databases

I have a question about showing some results to users. I have a smart contract which has multiple arrays and mappings. I use events to store their data when I set data in functions. is it better to ...
0
votes
2answers
58 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
1answer
44 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
2answers
486 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
1answer
57 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. ...
6
votes
2answers
194 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 ...
2
votes
3answers
660 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 ...
0
votes
1answer
44 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-...
1
vote
2answers
79 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 ...
1
vote
1answer
56 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. ...
1
vote
2answers
60 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 ...
2
votes
1answer
92 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
1
vote
1answer
32 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,...
0
votes
1answer
48 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?
1
vote
1answer
520 views

Storing structured data in private blockchain

The task. Develop distributed registry on blockchain network that can store public data of the certain objects. For example: { "id": 123456789012345, "title": "Big black box (not more than 100 ...
4
votes
2answers
632 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 ...
0
votes
1answer
94 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.
1
vote
2answers
175 views

What happens if you modify the blockchain database out of band?

I understand that the data in a blockchain is stored in a database. E.g., this post states that Ethereum uses LevelDb or RocksDb. I expect that normally the only access to this database is through ...
0
votes
1answer
106 views

Is there an indexed database for ERC20 allowances?

For instance, I'd like to make the following query: Return all the addresses that have approved spender x on a particular token It seems that I can only query for a specific (address, spender) ...
0
votes
0answers
34 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 ...
1
vote
1answer
419 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
1answer
207 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 ...
2
votes
1answer
619 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 ...
0
votes
1answer
390 views

How can I store the hash of a record stored in mysql, as a transaction in ethereum network?

Suppose, I have a database that stores all the student details in mysql. To confirm and seal any manipulation in the database I want to store the changes in the blockchain network as a transaction and ...
1
vote
0answers
187 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 ...
1
vote
1answer
167 views

Database connection with smart contract

I am developing a Dapp, which has a smart contract in solidity and uses truffle framework. My smart contract has a constructor that takes a value as an argument I want to initialize this smart ...
0
votes
1answer
37 views

Trigger manual DB UPSERTs through smart contract

Can I add a trigger to smart contract to insert/update data to my traditional DB. E.g. Let's say I have students private blockchain where each student has to update their info. Once they insert/update ...
1
vote
2answers
138 views

How can I read/write ethereum as a database by python code? [closed]

I am a startup in this domain. I see some article about Ethereum could save data as a contract. But they are too complex to me. If I already have an Ethereum account with some ETH. Is there some ...
1
vote
1answer
1k views

Ideal way to store hash on the ethereum blockchain

I would like to store a certificate on the blockchain. I only need to store its hash and if its been verified by both parties or not. Should I create a struct that is made up of bytes32 for the hash, ...
1
vote
1answer
87 views

Why transactions/contracts aren't priced/tracked based on computer running time

Amazon AWS and Google Cloud all base their pricing off of, among a few other things, the amount of compute and storage used. For compute, it's based on time, how much time the computer runs. This is ...
1
vote
2answers
128 views

Set and Get of a large amount of data

I created a contract that insert one number (uint) in blockchain with set function but how can i retrieve all numbers inserted? This is my html, i put 1 number in a blockchain and i will see just the ...
3
votes
0answers
1k 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 ...
0
votes
1answer
51 views

How Ethereum stores its data in the blockchain [duplicate]

I am new to ethereum and the blockchain, but I am wondering about blockchain databases. Mainly I am wondering how exactly the database data and the blockchain merge. For instance, in a database you ...
2
votes
2answers
326 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 ...
2
votes
1answer
77 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 ...
3
votes
1answer
29 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 ...