Database-like Tables in Blockchain

Table smart contract storage
Table smart contract constructor
Adding a row of bytes32 using assembly
An extended table could manage strings and define comparisonoperators
  • A database smart contract, that contains the names and address of tables
  • Code generation of extended tables, based on columns definitions (types), so the query functions are generated
  • Write a precompiled contract to manage any Table smart contract storage (the recommendation is that this contract has only the cells I described at the beginning of this post: no of rows, no of columns, data offset and field cells)
  • Add to that precompiled contract some capacity to parse and execute a simplified SQL statement
  • Write a “to do dapp” but I’m not yet confident writing such project

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store