2

I want to create local blockchain for my application. New blocks should be created while giving reference to previous block. But I am not getting exactly how will I do it in MySQL? I got some idea from http://blog.theodorejb.me/sql-linked-lists/ . Now I want to retrieve top block every time I create a new block. But Is it possible in MySQL to retrieve Newly inserted row's primary key? Or Is is possible to implement stack(with reference) in MySQL ? So that I can retrieve top block.

Improve this question
3

I believe you are over complicating your life.

Having a BlockChain (a Linked Ledger) in SQL can be prototyped in the following manner

  1. Create a table, such as:

    CREATE TABLE IF NOT EXISTS 
MyBlockChain (
    LedgerID int(10) NOT NULL auto_increment,
    block varchar(255),
    datetimestamp datetime,
    guid varchar(255),   --Have a Default GUID Generated 
    PRIMARY KEY( `LedgerID` )
);

  2. Having an AutoGenerated Sequence Number (as a primary key) - This creates the sequence in your ledger.
    Assign Proper Security to only allow INSERTS to happen over a Public API.

  3. Only the GUID is used to access a Record (block) via ReadOnly permissions.
  4. When users can only INSERT Data (No DELETE or UPDATE) you, in essence, created a Ledger.
  5. And since the Sequence Number will be used to determine ordering of actions.

The biggest challenge to distributing the MySQL database over multiple instances an having an API interface and ensuring ReadOnly and Insert Only security.

That by default is a simple implementation of a BlockChain

Improve this answer
3
  • In order for this to be more blockchain-like, I believe you'd have to make guid the primary key instead of LedgerID, and then make a prev_guid the link to the previous block (row in this case). Of course, you'd have to uniquely generate each guid to keep database integrity. – Volomike Jan 9 '19 at 5:34
  • Meanwhile, for a faster table speed, you could move block to the end of the table and then even switch it from varchar(255) to text, mediumtext, or longtext. – Volomike Jan 9 '19 at 5:37
  • Permit no inserts unless no other block (row in this case) shares the same prev_guid, and your guid is unique. – Volomike Jan 9 '19 at 5:42

Not the answer you're looking for? Browse other questions tagged or ask your own question.