Students gather in Dartmouth to pitch ocean solutions

Lim Local: an offline contract checker for freelancers, built with Gemma 4

This is a submission for the Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle What I Built Imagine you are a freelance developer and a new client sends you a contract.

• Lim Local is an offline contract checker for freelancers.
• Built with Gemma 4, an open-source model from Google.
• Helps identify risky contract terms and negotiate better terms.

1d ago ·dev.to

How to find your Android Advertising ID (GAID) and register a test device

If you work on an Android app with ads, sooner or later someone asks you for your "advertising ID", "GAID" or "AAID". This short guide shows where to find it and how to use it to register a test…

• Advertising ID, also known as GAID or AAID, is a unique identifier for Android ads.
• Locate ID in device settings or through GAID app; disable delete ID or opt-out settings.
• Register test device by entering Advertising ID in ad network or attribution dashboard.

1d ago ·dev.to

SQL CONCEPTS - Window Functions, Joins, Common Table Expressions & Subqueries

1. SQL Window Functions These are functions that are used to perform calculations. They return one output row per one input row.

1d ago ·dev.to

48-Hour Field Notes: My Stream Ended Without [DONE] and the Client Called It Success

Why does a truncated model answer look exactly like a finished one when the only thing you check is the HTTP status code? That question cost me most of a weekend.

• Assumed 200 status code guaranteed completed streaming response
• Stream ended without [DONE] sentinel, causing abrupt mid-sentence outputs
• Probe harness recorded time, finishreason, DONE sentinel, socket state

1d ago ·dev.to