Dev builds Solana fundraising platform that auto-refunds backers if a project fails

·1 views

An independent developer has launched Keep, a non-custodial fundraising platform built on Solana that offers automatic refunds to backers when a project does not meet its success criteria. Builders set a fixed USDC fundraising target, and backers receive tokens at a fixed price during the raise window. If the token's price fails to hold a defined threshold at day 7 or day 30 post-launch, the protocol automatically unwinds the liquidity pool and distributes recovered USDC back to token holders on a burn-to-claim basis. No third party holds the funds at any point; the smart contract manages all disbursements autonomously. Backers who sold their tokens during the hold period forfeit their share of the refund pool, which is instead split among those who continued holding.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Developer Masters SQL Regular Expressions on Day 89 of 100-Day MERN Stack Journey

A developer documenting a 100-day full-stack engineering challenge reached Day 89, focusing on SQL regular expressions and string anchors. The session built on a recently started competitive problem-solving streak on HackerRank. The learner tackled filtering city names from a database table using REGEXP instead of chaining multiple LIKE operators, which can produce repetitive and messy code. Using the caret anchor in a regular expression, they queried distinct city names beginning with vowels in a single, clean SQL statement. The exercise highlighted how REGEXP offers a more elegant solution for pattern-based text filtering in real-world data pipelines.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Structure a Product Variants API for E-Commerce Denim Catalogs

A developer on DEV Community has shared a practical database design pattern for handling complex product variants in e-commerce APIs, using a denim collection as the example. The approach separates a parent products table from a variants table, where each variant stores sellable attributes like size, color, wash, and inseam length. This normalized schema allows a single SQL query to filter across multiple attributes without requiring multiple API calls from the frontend. The author also recommends returning a flattened JSON structure to simplify rendering on the client side, and suggests adding materialized views to optimize performance at scale. The pattern is intended to balance flexibility and query efficiency for catalogs with potentially hundreds of SKUs per product style.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer builds 434 free browser-based tools to replace ad-heavy, login-gated sites

A developer launched The Calcu, a free platform offering 434 tools spanning calculators, converters, formatters, and validators, after growing frustrated with cluttered, ad-heavy alternatives. The platform covers categories including finance, health, math, and developer utilities, and requires no account or login to use. All calculations run entirely in the browser, meaning no data is sent to servers, which keeps the service free to operate at scale and ensures user privacy. URLs automatically encode calculation inputs, allowing users to bookmark or share results without any extra steps. The site went live about a month ago at thecalcu.com, and the developer is actively seeking feedback on missing tools or inaccurate results.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

16-Year-Old Pakistani Developer Publishes Free 10,000-Word Node.js Guide

Zabi, a 16-year-old developer from Pakistan, has self-published a comprehensive Node.js learning guide exceeding 10,000 words on his platform ZabiTech Community. He created the resource over three weeks, motivated by frustration with short online tutorials that he felt skipped important concepts. The guide covers topics ranging from the JavaScript event loop and Express.js to performance optimization and over 50 interview questions with answers. It also includes code examples, diagrams, and a deployable project aimed at taking learners from beginner to production-ready level. The guide is available for free on his website and a summary roadmap was shared on the DEV Community platform.

0 comments Read more at DEV Community