Small ways to show up for someone you care about.
Beside turns “I’m here for you” into a thoughtful offer of listening, company, practical help, or reconnection. Choose what feels manageable, explore 42+ gestures, and personalize a message before sharing it.
I used Snowflake to store the gestures, message templates, and source references. I created embeddings with AI_EMBED and used VECTOR_COSINE_SIMILARITY to find gestures relevant to the selected situation. SQL filters keep the suggestions within the time, distance, budget, and kind of care someone can offer.
I built the interface with React, TypeScript, Vite, and pnpm, and deployed it on Cloudflare Workers. The Worker connects to Snowflake using credentials stored in Cloudflare secrets. Message edits stay in the browser.
Use Node.js 24 and pnpm. Copy .dev.vars.example to .dev.vars and add your Snowflake service-account settings for live matching.
pnpm install
pnpm devTo build and deploy to your own Cloudflare account:
pnpm build
pnpm exec wrangler login
pnpm deploySet production credentials in Cloudflare Worker secrets; .dev.vars stays on your computer. The Snowflake scripts set up the app login, fictional test actions, and content tables. Replace YOUR_PUBLIC_KEY in the login script with your own public key. The data:* scripts use private preparation batches and are not required to build the app.
I used AI to help adapt published guidance into everyday gestures and message templates. Each gesture links to its sources. Beside offers everyday support ideas, not professional or crisis care.
Built for the Weekend Challenge: Generosity Edition, entering Best Use of Snowflake.
