SShortSingh.
TopTechnologyAI & MLStartupsProgrammingScienceBusinessFinanceCrypto & Web3World
Back to feed
Programming

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

0
·1 views

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.

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)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

n8n Guardrails Redacts PII Permanently, Leaving Gaps in Real Workflows

n8n's Guardrails node, launched in November, masks personally identifiable information before it reaches an LLM, but permanently deletes the original values rather than storing them. This creates a practical problem for workflows like support automation, where the real PII — such as a customer's name or email — is needed to write meaningful records to a CRM. The design is intentional: Guardrails is built as a content moderation tool, and discarding sensitive data is the correct behavior for jailbreak or NSFW filtering. However, that same behavior makes it unsuitable for workflows requiring PII to be recovered at a later, trusted stage. A tool called Privent is proposed as an alternative, using reversible tokenization so that masked values can be restored at a designated output point without ever exposing them to the LLM.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

AI tools steered developers away from protobuf.js using a competitor's README as source

The original creator of protobuf.js returned to the project in early 2026 to help address a surge of security reports, after previously handing maintenance to a Google team. While using AI coding assistants during this work, he noticed that LLM recommendations had shifted sharply against protobuf.js, citing specific technical criticisms. Tracing those criticisms back to their source, he found they originated from the README of a commercial rival, Buf's protobuf-es, which had recently undergone a significant tone change. The incident highlights how AI models trained on or retrieving from public documentation can inadvertently amplify competitor marketing as neutral technical advice. The author plans to explore the broader implications of this phenomenon for open-source projects and developer trust in AI recommendations.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Dev Builds Ledger-Based Loyalty Coin System for Waffle Kiosk to Drive Retention

A developer building a loyalty rewards feature for Glazed, a waffle kiosk brand running on Next.js and Supabase, ended up creating a full accounting-style ledger instead of a simple points counter. The core design philosophy centers on loss aversion, framing expiring coins as something customers stand to lose rather than rewards they might gain. Each rupee spent earns one coin redeemable at equal value, with every earn event carrying its own 21-day expiry countdown rather than a shared batch expiry date. The system uses an append-only coin_ledger database table where transactions are never edited or deleted, ensuring a complete and traceable history of every coin earned, redeemed, or expired. This architecture allows support queries to be resolved with a single database lookup, replacing an opaque mutable balance with a fully auditable transaction log.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Fitz claims to cut FastAPI observability setup from 60 lines to two decorators

A developer advocacy post published on DEV Community compares the effort required to implement full observability in FastAPI applications using OpenTelemetry versus a tool called Fitz. Achieving the so-called observability triangle — traces, metrics, and logs — in FastAPI traditionally requires installing seven packages and writing roughly 60 lines of configuration code. The article argues that Fitz reduces this to two decorators and a single environment variable, while automatically correlating trace IDs across logs and spans. The post highlights practical use cases such as identifying slow endpoints, tracking request failures, and debugging user-specific errors. It positions Fitz as a developer-friendly alternative to the standard OpenTelemetry setup for Python-based FastAPI services in 2025–2026.

0 comments Read more at DEV Community
Developer Masters SQL Regular Expressions on Day 89 of 100-Day MERN Stack Journey · ShortSingh