Blockchain From Scratch with Rust Day 2 Ledger Schema скачать в хорошем качестве

Blockchain From Scratch with Rust Day 2 Ledger Schema

We are writing our own blockchain, starting from scratch. The main goal today is to design the database schema for our ledger, which will live in an SQLite file. We'll call it schema dot SQL for now and keep things simple. Our schema needs fields for a from address and to address, each as varchar with a length of 64, since that's the size of a public key using the Sphincs Plus signature scheme in Rust. We'll also add an amount field, which in SQLite will be a real type, allowing 64-bit floating point values. For extra info, we'll have a note field as varchar with a max size of 256, and support storing binary data as a blob. We'll want text fields for smart contract code, likely in Lua, and might add a code language field later if needed. We need to add a signature field with enough space, as signature bytes can be quite large; Sphincs Plus can need thousands of bytes. We'll include an integer timestamp using Unix time in 64 bits, a version field, and a few fields needed for blockchains: a difficulty field, a nonce field, and placeholders for things like Merkle roots as to-do items. We might add more based on how blockchains like Bitcoin do it, but for now, this should be a good start. We're coding this in Rust, and once this schema is finished and committed, we can move on to the next phase of our custom blockchain.