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
1answer
20 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.
0
votes
1answer
31 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', ...
1
vote
2answers
20 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
2answers
33 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
34 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
30 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 ...
0
votes
0answers
20 views

Block-chain data retrieval

I'm using a testrpc to test my sensor contract, where many account get to submit data to the block-chain whether using an html client side application or using the smart contract is self. How can I ...
0
votes
1answer
39 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 ...
0
votes
1answer
82 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: ...
0
votes
0answers
29 views

where is data store in blockchain? [duplicate]

for example we have contract like this: contract Sample { string public name = "Moore ath John Yuur Gha"; function set(string memory _name) public { name = _name; } ...
2
votes
1answer
106 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
63 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
60 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
47 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
17 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
35 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
235 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
78 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 ...
2
votes
0answers
299 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
2answers
57 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 ...
0
votes
1answer
32 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 ...
3
votes
1answer
27 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 ...
0
votes
1answer
84 views

dApp Tech Stack

So I'm looking into building a dApp with standard app I functionality like user login/posts/likes/comments etc. Along with harnessing the power of ethereum to support betting and donations. Here is ...
2
votes
0answers
19 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 ...
2
votes
2answers
85 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 ...
1
vote
2answers
60 views

Thinking through from traditional DB to ETH

I am looking for a data structure kind of like this: [ "data": { "id": 0, "hash" : "5feceb66ffc86f38d952786c6d696c79c2dbc239dd4e91b46729d73a27fb57e9", "owner" : 0, "status" : "...
1
vote
1answer
20 views

Dapp SDK - Hardcoded ABIs vs Dynamic ABIs

I am developing a Javascript SDK to allow for integration of external services with our Dapp. The SDK calls the smart contracts' methods and therefore needs to know contracts addresses and ABIs. ...
0
votes
1answer
379 views

How can I make a database and smart contract interact?

I started to code a smart contract which was supposed to store some datas from corporations. These datas (mostly names and dates) were organized like that : ├── Client1(Contract) │ ├── Year2018 (...
2
votes
1answer
58 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 ...
1
vote
1answer
134 views

Syncing events on Database - Dealing with blockchain reorganization

My Dapp relies on live events synchronization on a centralized database. There is always a server side script polling the blockchain for new events, parsing then and do the corresponding operations on ...
0
votes
2answers
117 views

How would you render this structure of data?

I have coded a smart contract which allows one to store a certain type of structure of datas which can be described as something like that : ├── Client1(Contract) │ ├── Year2018 (Struct containing ...
1
vote
1answer
108 views

Web3 (python) - confirming transaction hash format

Due to the fact, that I am storing txId obtained from the user, before determining whether transaction has been ended or not, I want to make sure that the transaction hash, which will be stored in my ...
0
votes
1answer
68 views

How to use Ethereum as a database for an order book? [closed]

I hope this question is not too general. I would like to have a few opinions. What is the best way to work with data in Ethereum? Lets say we build a decentralized exchange on a small scale. How ...
1
vote
0answers
56 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 ...
3
votes
1answer
103 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 ...
1
vote
0answers
66 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, ...
3
votes
1answer
121 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 ...
1
vote
1answer
432 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 ...
0
votes
1answer
32 views

Deploy contract from browser but ensure details saved to server

I'm very new to blockchain/Ethereum development and would like to allow users to directly deploy contracts from a site using MetaMask, however, I want to make sure that I can keep a record of contract ...
0
votes
1answer
320 views

Loading External data (in Excel/CSV) to blockchain engine [closed]

I am new to solidity blockchain. I have transaction dataset in csv files. I want to load it automatically to blockchain using ethereum solidity. How can I do it? Is there any UI available? Any guide ...
0
votes
1answer
64 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 ...
2
votes
1answer
185 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 ...
1
vote
0answers
141 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 ...
0
votes
2answers
79 views

Is it necessary to store transaction data into a database?

I am wondering if there are no security risks if i store transaction data in a database besides the fact that is stored on the ethereum blockchain. I am using an API to manage my smart contracts and ...
0
votes
2answers
294 views

smart contract as a huge database

I know we cannot use Smart contract to be used as large database. But my client is asking for proof. Can you guys provide any link that will support this.
3
votes
1answer
178 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
1answer
148 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 ...
2
votes
0answers
127 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 ...
0
votes
1answer
60 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 ...
1
vote
0answers
25 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 ...