This note captures practical translation patterns from Grafana Prometheus panels to Betterstack SQL charts when data is coming from a Prometheus push metrics source.
For Prometheus-style metrics in Betterstack, values are usually stored as aggregate states, not plain numeric columns.
Common columns:
value_avg (AggregateFunction(avg, Nullable(Float64)))
| #!/usr/bin/env tsx | |
| /** | |
| * Create empty datasets for each approved provider on the given network | |
| * | |
| * Usage: | |
| * PRIVATE_KEY=0x... tsx debug/create-datasets-for-all-providers.ts [--mainnet] | |
| * | |
| * This script will: | |
| * 1. Connect to the network (default: Calibration testnet, use --mainnet for mainnet) |
| ;(async () => { | |
| const { ethers } = await import('https://cdn.jsdelivr.net/npm/ethers@6.9.0/dist/ethers.min.js') | |
| const abi = [ | |
| 'event PieceAdded(uint256 indexed dataSetId,uint256 indexed pieceId,tuple(bytes raw) pieceCid,string[] metadataKeys,string[] metadataValues)', | |
| ] | |
| const iface = new ethers.Interface(abi) | |
| const event = iface.getEvent('PieceAdded') | |
| const getFieldNode = (container, label) => { |
| async function* makeGenerator() { | |
| try { | |
| let i = 0 | |
| while (true) { | |
| yield i++ | |
| await new Promise(r => setTimeout(r, 10)) | |
| } | |
| } finally { | |
| console.log(">>> GENERATOR CLEANED UP (finally ran)") | |
| } |
| #!/usr/bin/env node | |
| import { execSync } from 'child_process' | |
| // Function to extract package updates from git diff | |
| function getPackageUpdates (startCommit, endCommit) { | |
| try { | |
| let diff | |
| if (!startCommit && !endCommit) { | |
| // No arguments: show HEAD commit changes |
| # When consuming changes that are currently in PR for a dependency, run the following: | |
| PKG=ipfs/go-log/v2 | |
| COMMIT=174cfdbd11a553230949ce958e66a90f07772ab6 | |
| go get github.com/$PKG@$COMMIT && go mod tidy | |
| # IF there are multiple go.mod files to update, like in ipfs/kubo for instance, use the following | |
| PKG=ipfs/go-log/v2 | |
| COMMIT=174cfdbd11a553230949ce958e66a90f07772ab6 | |
| go get github.com/$PKG@$COMMIT && find . -name go.mod -execdir go mod tidy \; |
getSlackTranscript() in the console
| /** | |
| * Simple feature‑detection helpers | |
| * (exported so test code can get 100 % coverage). | |
| */ | |
| export const hasBroadcastChannel = (): boolean => | |
| typeof globalThis.BroadcastChannel === "function"; | |
| export const hasMessageChannel = (): boolean => | |
| typeof globalThis.MessageChannel === "function"; |
please note the ordering of "helia:verified-fetch:trace Invoking plugin:"
| const fs = unixfs(helia) | |
| let barDir = await fs.addDirectory({ path: './bar' }) | |
| const aFileHtml = await fs.addFile({ path: './bar/a-file.html', content: uint8ArrayFromString('<html><body>Hello world</body></html>') }) | |
| barDir = await fs.cp(aFileHtml, barDir, 'a-file.html') | |
| let fooDir = await fs.addDirectory({ path: './foo' }) | |
| fooDir = await fs.cp(barDir, fooDir, 'bar') | |
| let deepDirCid = await fs.addDirectory({}) | |
| deepDirCid = await fs.cp(fooDir, deepDirCid, 'foo') |