We Taught a Snowflake Warehouse to Judge World Cup Conviction and Write the Verdict Back to Solana
This is a submission for Weekend Challenge: Passion Edition Target categories: Best use of Snowflake...
找到 153 篇相关文章
This is a submission for Weekend Challenge: Passion Edition Target categories: Best use of Snowflake...
This is a submission for Weekend Challenge: Passion Edition What I Built Soccer is defined by passion, but that passion often turns toxic when fans and commentators do not understand the limits of human performance under extreme pressure. During a 90-minute World Cup match, when a team collapses in the final ten minutes, the narrative defaults to harsh judgments like, "they lost their nerve." BioTactix AI was born out of a passion to change that global conversation. It is a securely licensed, real-time sports analytics architecture designed to solve the " Human-Machine Bottleneck. " By quantifying the exact intersection of physical exhaustion, cognitive delay, and psychological pressure, it transforms raw biological telemetry into context-aware, Explainable AI (XAI). Instead of relying on static dashboards, **BioTactix AI **provides real-time narratives to foster empathy among fans, actionable tactical alerts to prevent defensive collapses for coaches, and critical 14G-impact safety overrides for referees. Demo You can view the full demonstration and the real-time terminal output of the BioTactix AI Master Engine here: Watch the Demo on YouTube VIDEO LINK: https://www.youtube.com/watch?v=LQbuIVqc8D0 ** **Code The complete project, including the core biotactix_ai_master_engine.py script, is hosted publicly in github repository. The repository is fully secured with a software license to ensure the intellectual property and architectural blueprint remain protected. https://github.com/minakshihub/BioTactix-AI How I Built It Building a system to process 100-Hertz live biological data across a 40-man roster without compute bottlenecks required moving beyond standard web development approaches and leaning heavily into advanced storage systems engineering. Sovereign Edge Compute & VFS Routing: Instead of wasting CPU cycles continuously scanning the entire roster, the architecture leverages a custom Sovereign Virtual File System (VFS). This enables highly efficient data inge
This is a submission for Weekend Challenge: Passion Edition What I Built The World Cup...
This is a submission for Weekend Challenge: Passion Edition What I Built I built Passion...
This is a submission for Weekend Challenge: Passion Edition What I Built This weekend, I...
This is a submission for Weekend Challenge: Passion Edition What I Built This weekend, I...
This is a submission for Weekend Challenge: Passion Edition AI Camera — Fan Edition 🏆📷 What I Built AI Camera is a phone-camera app that describes what it sees, out loud, in real time — powered by Google's Gemini vision model. It started as an assistive tool for blind and low-vision users (general scene description, reading text aloud, describing an item for a marketplace listing, describing a person's appearance). For this challenge, I added a fifth mode built specifically around passion : 🏆 Fan Mode — point your phone at a jersey, scarf, flag, or any fan gear, and the app turns into a hyped-up stadium commentator, calling out colors, team details, and team spirit with real enthusiasm. With the World Cup happening right now, it felt like the right moment to build it. 📱 Important: this is a mobile-first app. It's built around your phone's rear camera and needs to be held up and pointed at real things — please try it on a phone, not a desktop, for the intended experience. Demo 🔗 Live app (open on your phone): https://demirajvazi10-max.github.io/ai-camera-fan-edition/ You'll need a free Gemini API key from aistudio.google.com/app/apikey — paste it in when the app asks. It's stored only in your browser and never leaves your device except to call Google's API directly. (I wasn't able to put together a screen recording for this submission — camera-based apps are a bit awkward to record on a phone! Since the whole thing runs client-side with no backend, the live link above lets you try Fan Mode yourself on your own phone in about 30 seconds.) Code https://github.com/demirajvazi10-max/ai-camera-fan-edition How I Built It Passion shows up in different ways. Sometimes it's the quiet kind — building something so a person who can't see can still "see" the world around them. Sometimes it's the loud kind — losing your mind over your team's jersey during a World Cup year. I already had the first one built. Adding Fan Mode let the same engine carry both. Vanilla HTML/CSS/JS — no f
This is a submission for Weekend Challenge: Passion Edition What I Built As a QA engineer, I spend a lot of time reading requirements, questioning unclear business rules, and thinking about what could break before a feature reaches users. That part of quality engineering is something I genuinely enjoy, and it inspired me to build PassionQA . PassionQA is an AI-powered quality intelligence platform that turns product requirements into practical QA insights and executable test cases. The workflow is simple: Upload or paste a BRD (Excel or text) Run AI-assisted quality analysis Review the complete QA output in one dashboard: Requirement health and release readiness Missing rules and ambiguous requirements Positive, negative, boundary, security, and accessibility test cases Bug-risk insights and heatmap Requirements Traceability Matrix (RTM) Excel and PDF exports My goal was to reduce the repetitive part of requirement analysis so testers can spend more time thinking critically about product risk and quality. Demo Try it quickly Live app: https://passion-qa.vercel.app Click Explore Demo Preset to analyze the built-in insurance example. The application uses Gemini when available and automatically falls back to the local analysis engine if Gemini is unavailable. Or click Launch Platform (Free) , upload your own BRD, and select Run Quality Analysis . For my demo, I used an insurance Policy BRD. PassionQA analyzed the requirements, highlighted quality gaps, and generated executable positive, negative, boundary, security, and accessibility test scenarios across the policy workflow. Video Demo The demo shows the complete flow from Policy BRD upload to AI analysis, test-case generation, risk insights, RTM, and report export. Demo video: https://drive.google.com/file/d/1sAoOauTGCk66xAzY46zF8_lWBQbVM8Gr/view?usp=sharing Code GitHub repository: https://github.com/DhanashriQAEngineer/PassionQA/ Some of the key parts of the project are: src/lib/gemini.ts --- Gemini analysis and loc
This is a submission for Weekend Challenge: Passion Edition What I Built Loyalty Ledger — a fan loyalty tracker where your check-in streak, badges, and history live on Solana instead of some app's database. Live app: https://loyalty-ledger-blond.vercel.app Here's the problem I kept coming back to. Every sports app wants you to check in, engage, "prove your loyalty" — collect points, build a streak, unlock a badge. Cool. Except every single one of them throws that history away the second you stop opening the app. Switch apps and your streak resets to zero. Get banned, or the app shuts down, or they just quietly decide to wipe inactive accounts one day — and your history is just... gone. Because it was never actually yours. It was a number sitting in someone else's database, and they could reset it, inflate it, or delete it whenever they felt like it. You had zero say in it. And that bugged me way more than it probably should have. Like — we figured out how to make ownership portable for money, for domain names, for digital art. But "I've supported Argentina since 2019" 🇦🇷 still lives and dies inside one company's backend, and nobody's really questioned that. So I kept the weekend scope deliberately small: prove one fan's loyalty to one team, for real, end to end — instead of sketching ten features that are all half-fake. You connect a wallet, pick a sport and team, and check in. FIFA World Cup is the fully working path here ⚽ — that check-in sends an actual transaction that creates or updates a program-owned account, not a row in my database somewhere. Your streak count, your badge tier, the actual badge tokens — none of it exists anywhere I control. Which honestly felt a little weird to build, in a good way. Once that core loop worked, I built the rest of the identity around it: a Fan Passport that shows your streak, a derived "Fan Score," your tier (Rookie → Devoted → Veteran → Legend 🏆), a progress bar toward the next tier, an achievements grid with locked/unlocke
This is a submission for Weekend Challenge: Passion Edition What I Built Loyalty Ledger —...
This is a submission for Weekend Challenge: Passion Edition What I Built I told an agent Never write directly to the database . A long session later, context window full, it wrote directly to the database. The rule loading mark was still sitting in the prompt. The model had just stopped weighting and attending to it. It's an invisible failure. No error is being thrown. The task comes back subtly wrong, and the rule reads perfectly fine when you go back and check it. I wanted to make it visible, so I built an interactive field you can drag around. Every rule you write for an agent is a hill. Its height is how well the rule is written: a directive-led, backtick -anchored rule stands tall, a hedged and vague one sits low. Then you raise the water. The water is context load. As it rises the low rules go under first, in order of how well they were written. The weak ones drown while you watch. Three of the hills are high-stakes prohibitions, the Never... rules. They drown too. That is the whole point of the piece. A rule you cannot afford to lose does not belong in prose at all; it belongs on a runtime hook that runs as code, not attention. The field flags those in red the moment they go under. Underneath the field is a second tool: a client-side lint that reads an instruction and names the surface tells (hedges, shouting, politeness, a ban placed before its directive). It is deliberately not a score. It catches what a little regex can honestly catch, and points at the real analysis for the rest. Demo Play it on its own page. Drag to orbit, drag the load slider to raise the water: ▶ Open the live demo Each of the nine instruction patterns in the demo links to its rule page on reporails.com/rules . Code Code is available on Codepen: https://codepen.io/editor/G-bor-M-sz-ros-the-reactor/pen/019f4cad-e344-78bf-b7bc-919972f42a4e The whole thing is one self-contained HTML file: no build step, no dependencies, no backend. The CodePen above is the full source, so you can read eve
This is a submission for Weekend Challenge: Passion Edition What I Built Loyalty Ledger — a fan loyalty tracker where your check-in streak, badges, and history live on Solana instead of some app's database. Live app: https://loyalty-ledger-blond.vercel.app Here's the problem I kept coming back to. Every sports app wants you to check in, engage, "prove your loyalty" — collect points, build a streak, unlock a badge. And every single one of them throws that history away the moment you stop using it. Switch apps and your streak resets to zero. Get banned, or the app shuts down, or they just decide to wipe inactive accounts — your history is gone, because it was never really yours. It was a number in someone else's database, and they could reset it, inflate it, or delete it whenever they felt like it, and you'd have zero recourse. That felt like a weirdly solvable problem to just... not solve. We figured out how to make ownership portable for money, for domain names, for digital art. But "I've supported Argentina since 2019" still lives and dies inside one company's backend. So the scope for the weekend was deliberately narrow: prove one fan's loyalty to one team, for real, end to end, rather than sketch out ten features that are all half-fake. You connect a wallet, pick a sport and team, and check in. FIFA World Cup is the fully working path — that check-in sends a real transaction that creates or updates a program-owned account, not a row in my database. Your streak count, your badge tier, the actual badge tokens — none of it exists anywhere I control. Once that core loop worked, I built out the rest of the identity around it: a Fan Passport that shows your streak, a derived "Fan Score," your tier (Rookie → Devoted → Veteran → Legend), a progress bar toward the next tier, an achievements grid with locked/unlocked states, a recent-activity feed pulled from real on-chain transaction history, and a leaderboard ranking real fans by real streaks. There's also a "Demo Previe
Building the DSA Tracker I Wish I Had as a Student 🚀 #weekendchallenge This is a submission for Weekend Challenge: Passion Edition What I Built I built DSA Tracker , a platform designed to help students stay consistent with Data Structures and Algorithms practice while learning concepts in an organized way. Like many students preparing for placements and improving problem-solving skills, I often found myself asking: Which problems have I solved? Which topics am I weak at? How do I track consistency over months instead of days? Why do most trackers feel like spreadsheets rather than learning platforms? DSA Tracker was my attempt to solve these problems. The project started as a simple CRUD-based tracker but gradually evolved into a learning platform that combines: Problem tracking Progress monitoring Topic-based organization Interactive learning modules A foundation for future analytics and personalized recommendations The goal is simple: Help students focus less on managing their preparation and more on improving their problem-solving skills. As someone who is currently on the same journey, this project is deeply personal to me and perfectly matches the theme of Passion Edition . Demo Live Application https://dsatracker-51wk.vercel.app/ GitHub Repository https://github.com/ImGakash/dsatracker Code The entire source code is available on GitHub: https://github.com/ImGakash/dsatracker How I Built It Frontend React.js HTML CSS JavaScript Backend Node.js Express.js Database MongoDB Additional Technologies Google OAuth authentication Razorpay integration REST APIs The project evolved through multiple iterations. The earliest version was a simple tracker that allowed users to: Add problems Mark problems as solved Delete entries Track progress percentages Over time, it expanded into a more ambitious platform with authentication, user management, learning modules, and deployment infrastructure. Some interesting engineering challenges included: Designing scalable data models
This is a submission for Weekend Challenge: Passion Edition What I Built The theme was passion, and mine has always been the sky and everything beyond it. Day or night, there's a specific kind of awe in remembering that the sky isn't a backdrop. It's real, it's happening right now, and every point of light is an actual place. Night is simply when you can see the most of it. I wanted to put that feeling into a browser tab. Zenith takes your location, cinematically lowers you from orbit down onto your exact spot on Earth, and becomes a first-person view of your real sky, one you can drag to look around. Every star is where it actually is. The Sun, the Moon, and the visible planets are computed for your latitude, longitude, and this exact minute, and placed where they truly are. It isn't a fixed picture either: the whole sky rotates slowly in real time, so stars rise and set while you watch. Tap any object and you travel to it. The camera flies out through the real starfield, the object grows from a point into a detailed close-up, and a short, grounded briefing appears telling you what you're actually looking at, from where you're standing, right now. A warm voice reads it to you. Stay a while and Zenith reminds you that there are people over your head: it shows how many humans are in space this moment, by name, and draws the real International Space Station crossing your sky whenever it's above your horizon. Not information about space. The quiet, enormous wonder of looking up and knowing, for a moment, exactly what you're looking at. Demo Live: https://zenith-rgerjeki.vercel.app A short walkthrough: the descent to your location, dragging the real sky, and flying to a planet for an AI briefing read aloud in a warm voice. Code rgerjeki / Zenith Zenith The sky above you, right now. I've always been drawn to the sky, and everything beyond it. Zenith is a first-person view of yours : it takes your location, lowers you onto your exact spot on Earth, and gives you the real
This is a submission for Weekend Challenge: Passion Edition ❤️ Dedication This project is dedicated to every passionate developer out there grinding on late-night code, and to the incredible DEV Community team for creating a space that fuels our growth every single day. 🚀 What I Built I built DEV Passion Fuel Station —a minimalist, single-page HTML5 web app engineered to protect the fire driving our late-night side projects and hackathon builds. Developers can vent, drop logs, or copy-paste messy code frustrations directly into the interface. The system leverages the Gemini 1.5 Flash API to dynamically gauge developer sentiment, analyze burnout metrics, and return actionable, bite-sized tasks to keep project momentum going without overwhelming the builder. 🔗 Demo You can try the live web app directly in your browser here: 👉 https://projects-of-passion.netlify.app 💡 Journey & Inspiration As a beginner coder, diving into an AI hackathon was intimidating but incredibly exciting! Passion is the primary catalyst behind the DEV Community—we see it every day in the deep dives and side projects shared here. However, relentless passion often dances right on the edge of burnout. I wanted to build something exclusively tailored to our community: a safe space to dump developer blockages and get practical, AI-supported next steps to keep our engines running smoothly. 🛠️ Technical Execution The application targets the Best use of Google AI prize category. Frontend: A single-file HTML5 interface styled with an energetic, modern dark-mode DEV aesthetic. Backend Intelligence: Powered by the Gemini 1.5 Flash API using native JavaScript fetch . Hassle-Free Architecture: Since I wanted to keep it light, the entire app runs out of a single file hosted on Netlify . Anyone can paste their own Google AI Studio key directly into the UI to test it safely, keeping personal keys private while allowing judges to grade the app seamlessly.
This is a submission for the DEV Weekend Challenge: Passion Edition . What I Built Everyone will tell you about the passions they have. Nobody talks about the ones they quit. I played cricket every evening from age 11 to 17. I told everyone I'd play Ranji Trophy one day. Then the entrance exam years came, the bat went behind the cupboard, and I never went back. Eight years now. EMBER gives that abandoned passion a voice. You confess what you quit. AI forges its persona: the dusty object, the game itself, or the younger you. Then it talks back , out loud, in a voice matched to its temperament. It asks the question only it can ask: why did you really stop? Then it offers two doors: 🔥 Rekindle it. It negotiates the smallest possible first step ("Pick up your old bat and feel its weight. Sunday evening.") and you seal the pledge on-chain , where you can't quietly delete it. 🕯️ Lay it to rest. It says goodbye properly: a personal eulogy, spoken aloud, and a permanent on-chain stone. Closure is a feature, not a failure state. Every anonymized session joins the Atlas of Abandoned Passions , a live map of what humanity gives up, at what age, and what killed it. When I ran my own confession through it, the app decided my passion should speak as " Your old cricket kit bag ." Its first words: "It's been a while since you hoisted me up here, hasn't it? I still remember the thrill of a good cover drive, too." I built a thing and it emotionally wrecked me on the first test run. Working as intended. Demo 🔗 Live app: https://ember-himanshus-projects-acd54afd.vercel.app Try it in two clicks: tap an example confession (cricket at 17, the closet guitar, the novel at chapter three), headphones on. The voice is the point. A real pledge, sealed on Solana devnet: view the transaction . Code 🔗 Repo: https://github.com/himanshu748/ember How I Built It The loop is confess, converse, decide, commit, belong. Each stage is one sponsor technology doing what it is uniquely good at. Google AI (Gem
This is a submission for Weekend Challenge: Passion Edition While talking about AI workflow...
This is a submission for Weekend Challenge: Passion Edition What I Built I built a personal tribute website for my cat Juma. The goal of this project was to create a simple webpage to bring back the feeling of the old internet. I have always loved the creativity of old-school websites and things like Neocities pages, Tumblr blogs, pixel art, animated backgrounds... Websites made with personality instead of just functionality. So, I wanted to recreate that feeling by making a small corner of the internet dedicated to someone very special to me: my cat Juma Maruá Ganache. Demo Code You can check out my GitHub repository: thaisavieira / juma How I Built It I built this project using simple and classic web technologies: HTML for the structure of the page; CSS for animations, gradients, responsive design, and the retro visual style; JavaScript for interactive elements such as falling stars and dynamic effects. Prize Categories Not submitting to any prize categories.
What I built I wanted a workout timer that doesn't just beep at me. So this weekend I built one that writes the workout AND talks me through it, out loud, in a voice that actually sounds like it's yelling at you when things get hard. You give it a callsign, how long you've got, what you want to work, and how brutal you want it. It hands that to Gemini, which breaks the whole thing into 30-90 second intervals with a coaching line for each one. Then every one of those lines gets turned into real audio by ElevenLabs before it ever hits your browser. Nothing is pre-recorded, nothing is a fixed track. Ask for a different workout, get a completely different script and a completely different set of audio clips, generated on the spot. Demo Unedited screen recording, straight off my machine hitting the real APIs, sound included. Compose a routine, it comes back in a couple seconds, pacing curve draws itself as an SVG line, then hitting Start walks through each interval with the active one highlighted in red as it counts down and you actually hear it. The Maximum-intensity segments sound noticeably more unhinged because I turn the ElevenLabs stability knob way down for those specifically. Code https://github.com/marwankous/sonic-kinetic How I built it Go backend, one endpoint. It takes your workout params, sends a prompt to gemini-3.1-flash-lite with a JSON schema locked down tight enough that I don't have to think about parsing garbage back out of it, and gets back a full timeline plus a heart-rate pacing curve. The part I actually enjoyed was the audio pipeline. Every coaching line in the timeline gets fired off to ElevenLabs at the same time, one goroutine each behind a sync.WaitGroup , so a routine with a dozen segments doesn't take a dozen times longer than one with a single segment. Whatever comes back gets base64'd straight onto its segment. I also tie the eleven_flash_v2_5 stability setting to the segment's energy level, dropping it to 0.30 for anything marked Maximum
This is a submission for Weekend Challenge: Passion Edition What I Built I built PitchPassion AI , a web application that transforms text-based football match narratives into informative player performance visualizations using AI. The goal is to help fans quickly understand statistics without having to read lengthy reports. Demo I will include a video demo link below. Video Demo: Video File Code Back-End: Repository Back End Front-End: Repository Front End How I Built It Tech Stack: React for front end, Flask for back end, Google Gemini API. AI Integration: The biggest challenge in sports data analysis is the unstructured nature of the data sources. Match reports typically consist of lengthy paragraphs written by journalists or narratives from spectators. While humans can easily read them, computers (databases) cannot directly process such text into charts or graphs. This is where I utilize the Google Gemini API as a data extraction engine: Natural Language Processing (NLP): Gemini reads the match narrative to comprehend the context—identifying the players involved, the actions performed (goals, assists, tackles), and the quality of those actions. Structured Transformation: I provide specific instructions (prompts) to the model so that it not only understands the text but also transforms it into a JSON format. Data Cleaning: Since AI sometimes includes conversational text in its output, I implemented middleware in Flask to clean the response and ensure that only pure JSON data enters my application. Problem solving: API Stability Issues (Error 503) During development, I frequently encountered 503 Unavailable responses from the Google Gemini API. This was caused by traffic spikes on the server side. Solution: I didn't let the application simply fail. I implemented a retry strategy in my Flask backend. If the API failed due to server load, the system would automatically wait for 2 seconds and retry up to three times before returning an error message to the user. This