Skip to content

Instantly share code, notes, and snippets.

View andrewxhill's full-sized avatar

Andrew W. Hill andrewxhill

288 followers · 21 following
View GitHub Profile
@andrewxhill
andrewxhill / Random Access File Formats.md
Last active August 27, 2024 16:59
example random access formats
File Format Indices (within file) Index Types Sharding Analysis Library DB Interfaces (Examples) Performance Granularity Compression Data Types Durability Security Community/Support Maturity Cost/License Basin Use-cases
Nimble Columns and streams Block encoding, cascading (recursive/composite) encoding, pluggable encoding selection policies Supported Flatbuffers, SIMD, GPU Designed for wide workloads, extensibility APIs Thousands to tens of thousands of columns and streams Flatbuffers, block encoding, recursive/composite encoding Many, with extensibility for additional encodings In development, no stability/versioning guarantees yet Focus on a single unified library to prevent fragmentation Work in progress, community support through Meta Active development, no stable release yet Open-source, dependenc
@andrewxhill
andrewxhill / README.md
Last active September 3, 2024 15:36
A list of frameworks for decision making and where they are most helpful.
Framework (starter video) Internal & External Factors Analysis Competitive Environment Analysis Product/Market Growth Strategy Performance Measurement Decision Path Analysis Financial Evaluation Risk Identification & Management Organizational Alignment
SWOT Analysis ✔
PESTLE Analysis ✔
@andrewxhill
andrewxhill / Chain Of Trust (but verify).ipynb
Last active November 8, 2023 06:14
Chain of Trust - but verify...
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@andrewxhill
andrewxhill / TransferLogs.sol
Created May 4, 2023 18:53
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 an…
// SPDX-License-Identifier: MIT
pragma solidity ^0.8.12;
import "@openzeppelin/contracts@4.8.3/token/ERC721/ERC721.sol";
import "@openzeppelin/contracts@4.8.3/token/ERC721/extensions/ERC721Burnable.sol";
import "@openzeppelin/contracts@4.8.3/token/ERC721/utils/ERC721Holder.sol";
import "@openzeppelin/contracts@4.8.3/access/Ownable.sol";
import "@openzeppelin/contracts@4.8.3/utils/Counters.sol";
import "@tableland/evm/contracts/ITablelandTables.sol";
import "@tableland/evm/contracts/utils/TablelandDeployments.sol";
@andrewxhill
andrewxhill / resources.md
Last active January 3, 2023 21:13
Tableland game workshop
@andrewxhill
andrewxhill / ReadTablelandValue.sol
Last active November 29, 2022 00:24
Uses midpointapi.com to return a single cell value from any table or sql request on Tableland
// SPDX-License-Identifier: UNLICENSED
pragma solidity ^0.8.17;
import "@openzeppelin/contracts/utils/Strings.sol";
import "@openzeppelin/contracts/utils/structs/EnumerableMap.sol";
interface IMidpoint {
function callMidpoint(uint64 midpointId, bytes calldata _data) external returns(uint256 requestId);
}
@andrewxhill
andrewxhill / addDeposit.js
Created August 27, 2021 21:21
// trigger bridge deposit for a user with their wallet
const onSubmit = () => {
api
.addDeposit()
.then(() => setDeposit(true))
.catch((err: Error) => alert(err.message));
};
@andrewxhill
andrewxhill / go.mod
Created March 16, 2021 21:36
hello-remote-threads.go
module github.com/textileio/hello-go-threads
go 1.15
require (
github.com/textileio/go-datastore v0.4.5-0.20200819232101-baa577bf9422 // indirect
github.com/textileio/textile v1.0.14 // indirect
github.com/textileio/textile/v2 v2.6.5 // indirect
github.com/wangjia184/sortedset v0.0.0-20160527075905-f5d03557ba30 // indirect
)
@andrewxhill
andrewxhill / index.md
Last active June 5, 2022 13:42
Powergate Workshop

Introduction to Filecoin app building

This document: https://tinyurl.com/hackfs-pow

Slides from intro presentation: https://speakerdeck.com/andrewxhill/intro-to-filecoin-building-apps-with-powergate

In this workshop, we are going to introduce you to Filecoin through the use of the Powergate. While you can develop using Lotus or other Filecoin implementations directly, the Powergate is designed to provide the necessary abstractions to build Filecoin storage into your application. Some features of the Powergate include fast data retrieval with IPFS serving as a caching layer, deal management, multi-tenant wallet APIs, and more. The system comes set up to run locally in Docker or deploy to your servers.

We'll cover the Powergate CLI and the Powergate JavaScript Client in the two parts of the workshop. To prepare, we encourage you to install a few things before we get started.

@andrewxhill
andrewxhill / index.html
Last active July 17, 2020 19:15
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
<meta name="description" content="Template cloned from https://github.com/erengy/under-construction.">
<title>textile.io</title>
<style type="text/css">
html, body {
height: 100%;