Hi, I am new to blockchain but an experienced sql developer - am trying to build a legal contracts blockchain. Is it possible to create multiple "tables" similar to a database? And is it possible to "join" tables together - say one list has parties, and the second list has contracts.
I would just use an oltp database but interested in the immutability features of a ledger.
Thanks
Top comments (4)
Stick to
SELECTandINSERT. Done."Private blockchain" is an oxymoron of intentions. It's also not immutable.
You might be interested in functional databases.
Then how do blockchain games do it? There is more than just a single 1-dimensional item ledger.
Funny you should ask about blockchain games.
Don't get me wrong, you can absolutely have "multiple tables" on a blockchain. A blockchain is just a strategy for achieving consensus about order of operations within a variable group of untrusted parties. So it's not a replacement for tables, but for journals. It's pointless when "private", because you have no variable group of untrusted parties. It's pointless for smart contracts because you have no trusted parties to observe the world.
thank you for your answer...let me digest that