by Bruno Calza

This week we released a new version of Basin CLI that includes a bunch of features:

• You can attach a timestamp to your file upload

basin publication upload --name [namespace.relation_name] --private-key [PRIVATE_KEY] --timestamp 1699984703 filepath

• You can filter deals by timestamp

# examples basin publication deals --publication demotest.data --at 1699569502 basin publication deals --publication demotest.data --before 2023-11-09T19:38:23-03:00 basin publication deals --publication demotest.data --after 2023-11-09

• You can format your output

basin publication deals --publication demotest.data --latest 10 --format json

• You can retrieve a file by cid

basin publication retrieve bafybeifr5njnrw67yyb2h2t7k6ukm3pml4fgphsxeurqcmgmeb7omc2vlq

• You can retrieve the public key given the private key

  basin wallet pubkey

basin wallet pubkey [pk filepath]

by Jim Kosem

This past week in Istanbul at DevConnect and IPFS Connect there was a lot of discussion about the end user experience, which was pleasantly surprising and I believe shouldn't be. If there is one deserved criticism within the dweb, p2p and web3 worlds it's that there is no shortage of discussion and pleas to build, build and build. However, as is clear by now if you build it, they won't necessarily come. While rebuilding a private and secure web as originally envisioned is clearly important, it is of course meaningless if it's all built and not used.

by Dan Buchholz

We've updated our docs with a number of additions based on feedback from the community and recent hackathons:

• Made examples more coherent with the same table name and setup.

• Improved SQL examples, including expressions/operators, aggregate/scalar function compatibility, and more compound select examples.

• Added a Next.js quickstart and updated the existing ones with a clearer flow.

• Added more docs around SDK query statement methods and database batch methods, including new support for polling controllers as well as updating for @tableland/sdk recent breaking changes.

• More docs on ORM support, including Drizzle and @database/sql.

• New docs that walk through the Tableland registry contract and access control in more detail.

• Improved explainers for SQL helpers and Tableland Deployments contracts.

• New docs for the @tableland/sqlparser usage.

• Updated the SDK compatibility page with Node and ethersjs v5 requirements.

• Adjusted the Chainlink tutorial for onchain reads due to the deprecation of Arbitrum Goerli, and updated the Chainlink dNFT tutorial.

• Updated SDK aliases docs with new @tableland/node-helpers usage.

As always, if there's anything you're looking for in our docs but can't find, feel free to reach out!

• If you haven’t already, check out our blog post about our partnership with WeatherXM and how they’re using Tableland Basin in the DePIN sector: here.

• We’re about halfway through the Rebuild Ownership hackathon, so keep an eye out in the coming weeks for results, and feel free to hop in our Discord if you’re a hacker!

Want to dive deeper, ask questions, or just nerd out with us? Jump into our Discord for weekly research office hours. Or, for hands-on technical support, you can join our weekly developer office hours.

And if you’d like to discuss any of these topics in more detail, comment on the issue over in GitHub!