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

Question

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!

Answer 1

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

Answer 2

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/

Comments

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?
https://pixelspark.nl/2017/catena-sql-on-a-blockchain

---

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.