Ethereum: To create a blockchain using MySQL database [closed]
I cann’t help. She said the step by step by certificates to creator Ethereum simulating Blockchchain using Myeql:
Conditions necessary:
- You have basic understanding of mysql and thets data type (eg Int, Warchar, Data).
- You do Node.js and the Mysql2 package installation.
- You do create a new Mysql database.
Database Scheme:
Blockchchain will use the folling scheme:
quote Colume | Data type | Descript |
quote — | — | — |
quote ID (main key) Int | Unquesing denial for each block
quote Times Datetime | TIngth thoroughly be added
quote dating Varchar (255) | Data in the block
Create a MySQL table:
Sql
Create a Blockchain table (
ID intprious key auto_increment,
TIMstamp Date TI’s default Current_timestep On Update Current_timestep,
Data Warchar (255)
),
Placement of starting blocks:
To crate block blocks to indicated previous blocks, we will use the concept of a "previous block" or "block link". We win protect the ID of each block to separate lines and create a foreign key link tourselves.
Sql
Inserted into Blockchain (data) values (“initial blocks”);
Inserts of another block:
To add new blocks tour circuit, we will insert a new line with the currency time tag and dad locked in the Block line. We witht that each blocks with the previous block using the column ID column.
Sql
Inserted into Blockchain (data) values (new blocks data);
Insert to the another block:
To crate a new block by specifying the examination, we will insert a new line with the currency time tag and the previous block ID. This will determinee the link to tact previous block.
Sql
Inserted into Blockchain (data) values (“other block data”);
Using MySQL requests:
He’s how you can use SQL inquiries to create and control blocks:
Sql
- Create a new block by specified
Insert Blockchain (data)
Select "New Block Data"
From Blockchain
Where = last_insert_id ();
- Insert to the another block link
Insert Blockchain (data)
Fales ("other block data”);
- Check curent block data and links
Select * floll Blockchain, waxe ID = last_insert_id ();
How does it work:
- When as a new block, it crees to new line in the Blockchchain table with the currency.
- To added a new block, specify the lust, select the latest ID lutt the previous line (usinglast_insert_d ()’) and inserting a nw line updaated data.
- We continue this to create subsequent blocks based on previous ones.
Conclusion:
In this article, we leave created a simplified Etherreal Blockchain using the MYSQL daable tables. By protecting each block ID separate links and creating foreign keys vessel keys, we can swing the control theour blockchain. This method alllows use to assoly add new blocks, and by specifying exposures, ensurmented tomors of valid reminins.
Example Use case:
- Development of Development of Programs (DAPP) whirls safe data store and receipt.
- Creating a consensus (POS) consensus algorithm (POS) of the Cryptocomrency or Blockchain platform (POS).
- Development of a stym baseed on as to the smart cott that belong.
Leave a Reply
Want to join the discussion?Feel free to contribute!