Tableland offers a web3 native SQL database solution for blockchain and NFT game developers. Some common use cases from web3 game developers include: dynamic, playable NFTs, global leaderboards & asset tracking, lootboxes and more.
Tableland for Gaming
Tableland is a web3 native SQL database that enables mutability, unlocking new, dynamic possibilities for blockchain games.
Tableland provides a permissionless, relational database of SQL tables that can be easily read, queried or joined by a wallet powered app. Data is mutable, but mutability is restricted based on rules written into the smart contract. It is designed for web3 builders, addressing some critical needs including:
Gaming Use Case Spotlight
Some common use cases for Tableland by blockchain games include:
Solving Builder Pain Points
The following is a compilation of solutions and ideas for using Tableland to solve various industry challenges for game developers. They are compiled in response to market research and feedback from builders.*
- Scenario 1: Token A & B Belong to the Same Project:
- If NFT A is combined with NFT B, you could mint a new NFT C and burn the others: A + B = C. There are ways you could insert Tableland into the equation to make things more sophisticated, like instead of burning both A and B, you mutate A’s metadata so that it turns into C (while only burning B). Or, maybe you dynamically “downgrade” A and B metadata to a stock items while minting C.
- Scenario 2: Token A & B Belong to Different Projects. i.e. the following is a cross-collab idea:
- Token A’s metadata is “watching” (via a SQL query) a project that mints token B. token A’s metadata gets updated automatically if token B is collected, thus, crafting it into a “new” token via dynamic metadata. Namely, NFT metadata is a SQL query, so you could construct the query to return a specific ERC721 compliant response based on all of the table data.
- Current ERC721 NFT standards are not well suited for the application of web3 games. ERC721’s non-fungible characteristics make it nearly impossible for there to be a trustless third-party minting interface. This makes it difficult for in-game use cases such as crafting (combining NFTs to generate a new NFT), burning (deleting NFTs), and other functionalities trustlessly onchain. (pg 13 https://cdn.game7.io/reports/Game-Developer-Report-by-Game7.pdf)
- Chainlink’s VRF gets randomness on-chain, with the smart contract asking the VRF for a random number, emitting an event. The Chainlink nodes hear the event and write the random number back-on chain. With a loot box, VRF usually updates a state storage variable which changes what the lootbox will reward.
- Tableland can be inserted to make this cheaper since it actually mutates the NFT through ways that are less expensive than writing to on-chain storage. This can be especially beneficial in scenarios where there are multiple lootboxes in an experience (e.g. spin 3 times and the combination of outcomes determines the NFT mutations). Tableland also makes it super easy for frontend dapps to update according to any NFT changes.
- With Tableland, on-chain actions will update a table, and a game developer’s app can reflect this change in real time. In other words, simply query the Tableland network, and all live state from on-chain interactions will be displayed in the frontend.
Leading Builders Choose Tableland
Get in touch and learn more!
Set up a call to explore Tableland for your project: