SShortSingh.
Back to feed

Laravel 13.x Adds whereBinary() for Case-Sensitive MySQL Queries

0
·3 views

Laravel 13.x has introduced four new Query Builder methods — whereBinary(), whereNotBinary(), orWhereBinary(), and orWhereNotBinary() — to simplify case-sensitive database queries. The addition addresses a long-standing MySQL behaviour where string comparisons are case-insensitive by default, causing queries to return unintended matches across different letter cases. Previously, developers had to use raw SQL expressions such as BINARY comparisons, which reduced code readability and tied application logic to database-specific syntax. The new methods, merged via Laravel framework pull request #61261, generate binary comparison SQL under the hood while keeping the query builder syntax clean and expressive. This change is particularly useful in scenarios where exact character casing matters, such as matching usernames or tokens.

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 ·

Docker Model Runner Enables Contract Testing Across Three AI API Formats Locally

Docker Model Runner exposes OpenAI-, Anthropic-, and Ollama-compatible API formats through a single local model environment, making it a practical target for testing protocol adapters without relying on remote providers. Developers can define a shared adapter interface that normalizes responses across all three formats, isolating domain code from provider-specific wire details. Contract tests can then verify properties the application actually depends on, such as non-empty responses, finish reasons, error shapes, and streaming behavior, rather than assuming API compatibility from a shared base URL alone. The approach also recommends explicitly declaring adapter capabilities, such as tool support or token usage availability, so applications can fail fast when a feature is unsupported rather than encountering silent failures mid-execution. Differences in request translation and sampling mean generated text may still vary across adapters even when all three target the same underlying model.

0
ProgrammingDEV Community ·

Developer Builds KiwiEngine as a Reusable Foundation for Music, Hardware, and Beyond

A developer has built KiwiEngine not as an end product, but as a reusable digital infrastructure designed to support a wide range of future projects. The goal is to eliminate repetitive groundwork — such as login systems, routing, and configuration — so that each new build can focus on its unique, interesting problems. The creator plans to apply this foundation across diverse ventures including print-on-demand stores, artist platforms, and electronics like guitar pedals and amplifiers. A project called Blackwater Sound is being used as a testing ground, potentially serving musicians, studios, and producers with tailored tools. The broader philosophy shifts the developer's starting point from 'what software can I build' to 'what am I trying to accomplish,' treating code as one tool among many.

0
ProgrammingHacker News ·

Poem Tribute to the Intel 8088 Chip Surfaces on Hacker News

A creative piece titled '16-bit Intel 8088 chip' was shared on Hacker News, linking to a poem published on AllPoetry.com. The submission paid homage to the iconic Intel 8088 processor, a landmark chip in computing history. The post garnered 19 points and sparked a small discussion with 2 comments on the platform. The Intel 8088, originally released in 1979, powered early IBM personal computers and helped shape the modern PC era.