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.
139
questions
2
votes
3
answers
869
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 ...
- 75
0
votes
1
answer
189
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) ...
- 103
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 ...
- 149
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 ...
- 11
1
vote
1
answer
774
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: ...
- 416
2
votes
1
answer
1k
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 ...
- 121
0
votes
1
answer
866
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
0
answers
283
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 ...
- 21
1
vote
1
answer
409
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
1
answer
52
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 ...
- 115
1
vote
2
answers
218
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 ...
- 11
1
vote
1
answer
2k
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
1
answer
89
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 ...
- 165
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 ...
- 165
1
vote
2
answers
263
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 ...
- 59
0
votes
1
answer
64
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 ...
- 115
3
votes
1
answer
34
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 ...
- 133
0
votes
1
answer
275
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 ...
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 ...
- 31
2
votes
2
answers
865
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 ...
- 21
1
vote
2
answers
95
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" : "...
- 193
1
vote
1
answer
44
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.
...
- 169
0
votes
1
answer
2k
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
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 ...
- 71
1
vote
1
answer
454
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 ...
- 169
0
votes
2
answers
181
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
1
answer
331
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 ...
- 157
0
votes
1
answer
271
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 ...
- 800
1
vote
0
answers
131
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 ...
- 241
3
votes
1
answer
190
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 ...
- 2,638
1
vote
0
answers
558
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, ...
- 63
4
votes
1
answer
1k
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 ...
- 339
1
vote
1
answer
570
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 ...
- 11
0
votes
1
answer
68
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 ...
- 317
0
votes
1
answer
854
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 ...
- 101
0
votes
1
answer
119
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 ...
- 191
2
votes
1
answer
240
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 ...
- 231
1
vote
0
answers
337
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 ...
- 361
0
votes
2
answers
146
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
2
answers
964
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.
- 407
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 ...
- 239
1
vote
2
answers
277
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 ...
- 153
2
votes
0
answers
202
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 ...
- 441
0
votes
1
answer
93
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 ...
user36745
1
vote
0
answers
29
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 ...
- 21
1
vote
1
answer
153
views
Query multiple derived contracts from contract factory
Say a contract factory is used to spawn multiple child contracts, each with associated data within them. The contract factor stores all addresses of the derived contracts along with a unique name of ...
2
votes
4
answers
3k
views
Would it make sense to use a SQL database to store the data of a Dapp?
Let's say that I want to develop a Dapp and I need to store different information about the users. This information must not be public as not all the users are allowed to see all the information ...
- 395
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 ...
- 395
1
vote
1
answer
340
views
Are the contents of ethereum storage private? [closed]
I know that the code is public, but is the contents of storage private?
- 279
2
votes
0
answers
389
views
What is the best way to store and access large volume of data in blockchain? [duplicate]
I was creating a Dapp which will get KYC information from the user, I want to store this data in the blockchain. This data will be accessible through API and it will be used to do KYC process.
In ...
- 1,156