I know how to setup a classical relational database. How can I use Multichain to practical do the same?

+2 votes
Is there a GUI similar to e.g. Microsoft Access?

I know SQL and know design a DB using a graphical tool (MS or Oracle WebDB). How can I try to create some simple relational tables (e.g. Individuals, Cars) in order to learn and test Blockchain?

Is that possible to import a SQL definition o a relational db and migrate data to MultiChain?

Thank you!
asked Aug 7, 2017 by George P.

2 Answers

+3 votes
Its not a relational database and doesnt work that way.

Read https://www.multichain.com/getting-started/ and https://www.multichain.com/white-paper/

and watch Gideon on https://www.youtube.com/watch?v=NK5Fz3w-H4o&t=1012s
answered Aug 7, 2017 by MaSsv
+1 vote
MultiChain does not have a relational database model, but MultiChain streams can be used in the same was as a key-value NoSQL database. A good place to start is the 'Getting Started' tutorial: https://www.multichain.com/getting-started/
answered Aug 7, 2017 by MultiChain
Thank you!
However, is it possible to implement a single one table, e.g. People (id; name)? Or People, Cars and CarOwners?

Concerning a tool to create tables, I found this info about Catena. Am I wrong?
Yes, it's certainly possible to implement an SQL database model on a blockchain, it's just that MultiChain does not currently support this. You can use streams to write items, but currently each item has one key only, which can used to retrieve that item later on. The content of the item itself can be any structure you like (tab-delimited, JSON, etc...) to contain the database entry.