In this tutorial we will be introducing how to set up a new database, blockchain, and perform your first mutation. If you
prefer to learn in a video format, you can watch the tutorial online.
We will be:
- Creating a new database
- Starting a session on that database
- Creating a blockchain
- Populating your blockchain
- Reading from your blockchain
After selecting the "open IDE button" you will automatically navigate to the IDE. A few things are important to note:
- You will need to provide your username and password to connect to bSQL
- Once you connect, a session will be started on the master database, a hub for system metadata where work and application logic should not be performed
Once you have the master database open in the IDE we can run a CREATE DATABASE command to build a database.
I will be calling mine marketplace, and will create a new database by running the following statement:
CREATE DATABASE marketplace;
After we have created a database, it is bSQL convention to begin a session on our working database. To do this we run a
USE statement followed by the name of our database. Now marketplace is used as the default database
for all subsequent statements.
Creating an immutable Blockchain is as simple as creating a table in other SQL databases. There are four types
of blockchain in bSQL. Before defining the schema, we specified that the blockchian would be of type TRADITIONAL.
Reference the CREATE BLOCKCHAIN documentation for full syntax and keywords.
CREATE BLOCKCHAIN contracts TRADITIONAL ( id UINT64 PRIMARY, unique_identifier STRING PACKED, issuer STRING PACKED, owner STRING PACKED, currency STRING PACKED, amount FLOAT32 );
DESCRIBE marketplace.contracts SCHEMA;
We can use an INSERT statement to add immutable data to our blockchain. Insert a new contract into the blockchain we
created by running the following statement. Once data is added, it can't be modified or illicitly changed.
INSERT contracts VALUES ( 0, "25c3d24f-0fc3-4a99-a292-98302dc0b5d0", "bank", "joe", "USD", 120.0 );
If we want to change values in bSQL we can write an AMEND statement. It is important to note that
this statement doesn't modify existing values, only updates the current version relative to the primary key.
AMEND contracts VALUES ( 0, "36e55e77-3ef2-4d8c-9f74-58895f4193b5", "joe", "kate", "USD", 120.0 );
To prove that data hasn't been illicitly modified we can run a CHECK VALIDITY command to
validate our data digests.
To query from the current state of the database, use a SELECT statement.
SELECT * FROM contracts;
Additionally, we can access the record history of the blockchain by applying the LIFETIME keyword to the contracts blockchain.
SELECT * FROM LIFETIME contracts;