Uses midpointapi.com to return a single cell value from any table or sql request on Tableland

Generate queryable ownership records and transfer logs in any ERC721. This example is extending OpenZepplin functions. You can see the contract here https://mumbai.polygonscan.com/address/0xB837771546756D58d2EB79CDb0281Bc5F84bC704 and the owner logs here https://testnets.opensea.io/assets/mumbai/0x4b48841d4b32c4650e4abc117a03fe8b51f38f68/5969 and transfer logs here https://testnets.opensea.io/assets/mumbai/0x4b48841d4b32c4650e4abc117a03fe8b51f38f68/5970.

This example extends OpenZeppelin’s ERC721 contract to automatically generate queryable ownership records and transfer logs for any NFT. It uses the Tableland EVM SDK’s `ITablelandTables` and `TablelandDeployments` to create and update two SQL tables: one storing the current owner per token ID, and another recording each transfer’s timestamp, block, from, and to addresses. Every mint and transfer operation triggers a `runSQL` insert or upsert, making the full history visible on PolygonScan and OpenSea’s testnet interfaces.

Aandrewxhill

50% match

Exploring smart contract with a web interface using Ethereum and solidity for the Blockchain workshop at iMAL

This example demonstrates a web interface for exploring a smart contract on the Ethereum blockchain, showing account balances, block information, and gas prices retrieved via the Web3.js API. It initializes a connection to an Ethereum node, queries the first four accounts and their balances, and displays details about the latest block and available compilers. The code then defines a ballot contract using an ABI and includes the compiled bytecode for deploying it, enabling interactive voting and delegation functions within the browser.

UUtopiah

48% match

Tableland game workshop

Tableland game workshop demonstrates a live blockchain game state managed through Tableland tables, displaying player positions and interactions on a dynamic map. The React app uses the Tableland SDK to query and update rows in real time, with smart contracts deployed on Arbitrum Goerli handling game logic. It integrates w3link for decentralized content storage and references an NFT minting dapp starter, while the visualization renders through React components styled with CSS, pulling data directly from on-chain table reads via ethers.js.

Aandrewxhill

47% match

example script to upload any csv and run sql queries against the data in the browser

This example loads a user-selected CSV file through an HTML file input and stores its contents in an in-browser SQL database using the sql.js library, which compiles SQLite to JavaScript. It infers each column’s data type—integer, float, boolean, date, or text—from the first non-empty value, then dynamically creates a table and inserts rows. After import, the code runs a sample SQL query with a bound parameter (e.g., counting rows by a last name) and logs the result to the console, demonstrating how to execute arbitrary SQL against uploaded tabular data entirely client-side.

Aandrewfulrich

Gist a3dd5d0e98ee18894491144540592304

This example displays a simple Ethereum smart contract written in Solidity 0.4.4. The contract, named `HelloEthSalon`, stores a hardcoded string message and exposes a `GetMessage()` function that returns it. The code demonstrates the basic structure of a Solidity contract, including a constructor and a public getter method. It does not use any visualization libraries or data sources, focusing solely on the contract's logic and syntax.

Gist d00d13698a6324d359246407b1fb8857

This example presents a minimal Ethereum smart contract written in Solidity 0.4.4, defining a `HelloEthSalon` contract with a string message and a `GetMessage()` function that returns it. The code illustrates basic contract structure, including a constructor and a public getter, using the Solidity compiler’s pragma directive for version control. The rendering is plain source code, with no visual encoding or data manipulation, serving as a straightforward reference for contract syntax and function declaration.

Gist 3478a3e5a0c6a4f52d4f41a3756647ed

This example renders a minimal Solidity smart contract named `HelloEthSalon` that stores a string message and exposes a `GetMessage()` function to return it. The contract uses the pragma directive `solidity ^0.4.4` and defines a constructor, though the visualization primarily displays the source code itself. No external visualization libraries or rendering APIs appear in the provided file; the focus is on the contract’s structure and syntax rather than graphical output. The data source is the embedded Solidity code, presented as a static text example.

Gist fa78071b46ba1f01b38694303132d2e7

This example demonstrates a blockchain transaction workflow using the Web3.js library, showing how to send a contract method call from an Ethereum account. It retrieves the available accounts with `web3.eth.getAccounts()`, then creates a contract instance using `new web3.eth.Contract(ABI, address)`. The code invokes a specified contract function via `instance.methods.functionName(params).send()`, specifying the sender as the first account and setting a gas limit of 1,000,000. The visualization highlights the asynchronous nature of blockchain interactions, where the transaction is initiated but its result depends on network confirmation.