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
2
votes
1answer
205 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 ...
0
votes
2answers
242 views

Is there a way to store data on ethereum blockchain without anybody knowing about it [duplicate]

Lets say I am building a contract where I want to store some important information on ethereum blockchain. The data should be hidden and people shouldn't have a way to see it. As per my knowledge, ...
1
vote
1answer
25 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
757 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 (...
0
votes
2answers
125 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
165 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 ...
1
vote
1answer
145 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
118 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 ...
3
votes
1answer
145 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
84 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 ...
1
vote
0answers
194 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
255 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 ...
0
votes
1answer
39 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 ...
1
vote
0answers
220 views

Ethereum raw data files folder

Where is the folder on Mac OSX where Ethereum put raw blockchain data? I find only *.ldb files, but as I understand it is only the index of full database. For example, in Bitcoin there is blk*.dat ...
0
votes
1answer
504 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 ...
3
votes
0answers
297 views

BigChaindb + Ethereum

In BigChaindb paper, it's mentioned that it's compatible with Ethereum and is complementary to Ethereum. But BigChaindb has has its own consensus. Question 1: How can BigChaindb work with Ethereum (...
1
vote
0answers
197 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 ...
35
votes
5answers
14k views

Exploring and Analyzing the Ethereum blockchain

I would like to explore the data inside of the Ethereum blockchain. All transactions and contracts of the Ethereum Blockchain are stored there. So it's an interesting open dataset and I'd like to get ...
0
votes
2answers
103 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
551 views

Do we have any control over sharding in IPFS?

Suppose I have a huge N-dimensional database and want to store it using IPFS, is there any way I can shard my dataset in such a way that I get N hashes each for single dimension using IPFS?
0
votes
2answers
436 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.
2
votes
0answers
148 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 ...
1
vote
1answer
88 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 ...
1
vote
0answers
27 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 ...
16
votes
4answers
9k views

If a blockchain is a distributed database, where is the data?

There are a lot of articles describing how Ethereum is just another database, and a number of posts here on this site that talk about storing data on the blockchain itself (e.g., [1], [2]). However, ...
1
vote
1answer
294 views

Are the contents of ethereum storage private? [closed]

I know that the code is public, but is the contents of storage private?
2
votes
2answers
3k views

How to save data in my private blockchain?

I am running a private blockchain using geth as the client. I want to save some custom variables in my chain. I know there is a practical limitation on the storage capabilities as it would require ...
2
votes
1answer
3k views

How to store small database, editable data on blockchain accessible by smart contract?

New to blockchain and smart contracts. Been doing research and I realize I can't update my transaction smart contract. Is it possible to store database data as an entry to the ledger or in another ...
2
votes
0answers
359 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
vote
0answers
273 views

For what data does Ethereum use Memory Database, and for what does it use Level Database

Ethereum uses two databases Memory database and Level Database. Is data stored in MemoryDatabase different than LevelDb? In what cases is one database used over other? The question is different from -...
0
votes
2answers
862 views

Store all sort of data in blockchain

I have some questions that need clarification. Lets say if I create a trade-in website using blockchain technology, First, do I store all sort of data into blockchain such as user credentials, user ...
1
vote
1answer
899 views

Should I use smart contract for storing huge data and real-time updates? [duplicate]

Scenario : Lets say I have DApp on ethereum which has two parties or two types of users , User A will update his status (uptime or storage or ip address...etc). User B will be able to browse a ...
1
vote
3answers
392 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 ...
2
votes
0answers
204 views

What is the physical location of Blockchain?

Hello everyone i am new in this technology and i am confused please clear my few doubts. Thanks in advance. Blockchain consist of Blocks but where these blocks are stored, i mean what is the physical ...
0
votes
1answer
97 views

Data retrieval from geth node

How does a smart contract fetch stored data (for example, EmployeeName) from the node? Does it search through the entire chain? But searching through the entire chain would take just too long. There ...
15
votes
2answers
8k views

How to reduce chaindata database size?

Currently chaindata size is more then 10.02 GB. Is there any solution to reduce the size of stored data? Is there a way to store particular database and keep entirely the functionality of client (e.g....
0
votes
0answers
27 views

Is it possible to migrate your db(users login credentials) to ethereum private network?

I am thinking of migrating db to any of blockchain technologies for security purposes. I have to opt from hyperledger or ethereum private network. Is it good idea or any trades off I should be aware ...
7
votes
1answer
4k views

LDB files reading

I'm looking for the format of the LDB files in order to fetch all the contracts created by my account. I read in a post on reddit (https://www.reddit.com/r/ethereum/comments/64hhp1/...
1
vote
0answers
305 views

Largest Ethereum Transactions

Does anyone know of a database of large Ethereum transactions (in terms of Gas)? I am looking for large transactions on the testnet (Ropsten) or mainnet for analysis, ideally in the hundreds of ...
2
votes
2answers
473 views

data size on ethereum blockchain

can I store a big data size, like 100TB on ethereum blockchain? and then, is this mean that all clients should download 100TB to get full blockchain data!?
1
vote
1answer
1k views

Local caching database for fast retrieval

I'm currently working on dApps for a private blockchain based on ethereum. While it works fine and the dApps really show the power of the blockchain it lacks the speed and versatility of a SQL ...
0
votes
1answer
397 views

what is the difference between Swarm and BigchainDB?

Are both Swarm and BigchainDB complementary to ethereum or do they function independently? What are their applications?
2
votes
1answer
440 views

How to do searching in Ethereum's Ledge? (SQL)

Recently, I have a question about searching function in blockchain. Blockchain is a distributed database and as a database, there should be some searching functions such as "Select", "Join". I am ...
4
votes
1answer
1k views

Django, Ethereum, Sqlite

I am creating blockchain application in django with 6 main entities .By entities I mean to say these 6 entities will replicate data or you can say consensus mechanism will evolve around these entities ...
10
votes
2answers
7k views

Fatal: Could not open database: resource temporarily unavailable

I get this error when I run the geth upgradedb command: I0317 08:29:57.792433 4202 chaincmd.go:137] Upgrading blockchain database I0317 08:29:57.792491 4202 database.go:71] Alloted 16MB cache ...
6
votes
1answer
1k views

Database used for Parity

Specific to Geth the database used is LevelDB. But what is the database used for parity?
2
votes
2answers
256 views

Best way to store data on the chain

Follow up on: Web3J: TypeError: MyContract is not a constructor Here is how my contract looks like: contract OrganisationsFactory { mapping(string => OrganisationObject[]) organisations; ...
8
votes
1answer
2k views

Is Ethereum suitable for a storage application?

I'm interested to make an app to store some data and I'd rather think that the blockchain might not be the only or the right solution for me. I'd like the users to contribute data and to make that ...
8
votes
1answer
893 views

What is the composition of the blockchain database?

From axic's explanation of the structure of the ethereum database, we learned that data is stored in Merkle Patricia tries, usually inside a LevelDB store. It consists of structures such as blocks, ...
3
votes
1answer
156 views

Unable to start parity: database migration fails repeatedly

I am unable to start Parity, the database migration fails repeatedly. How in Parity on MacOS (1.4.5 already installed) do I eliminate this error so that my Parity will run? Geth is fine but not ...