SShortSingh.
Back to feed

Laravel 13 Adds Native Vector Search for MariaDB, MySQL Users Still Excluded

0
·3 views

A pull request merged into Laravel's 13.x branch on August 20 extended the framework's native vector search capabilities — including methods like whereVectorSimilarTo and orderByVectorDistance — to MariaDB, after previously supporting only PostgreSQL with pgvector. The update refactored vector distance logic from a hardcoded PostgreSQL check in the query builder into driver-level grammar methods, making it easier to add support for additional databases. MariaDB gains this support because it ships a native vec_distance_cosine() function and VECTOR column type since version 11.7 Community. Standard MySQL installations remain unsupported because MySQL lacks a native vector distance function outside of Oracle's HeatWave and MySQL AI cloud offerings. Notably, the Laravel team chose to throw a clear RuntimeException rather than implement a silent in-memory PHP fallback, which would have broken pagination semantics and query performance guarantees.

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 ·

Poetry: A Smarter Way to Manage Python Project Dependencies

Poetry is an open-source package management tool for Python that simplifies project setup, dependency handling, and environment isolation. It automatically generates configuration files like pyproject.toml and poetry.lock, making projects easier to share and reproduce across systems. Developers can create a new project using a single command, then add, update, or remove dependencies with straightforward CLI instructions. Poetry also creates isolated virtual environments per project, preventing version conflicts between different codebases. Its built-in dependency resolver reduces compatibility issues, making it a practical choice for both beginner and experienced Python developers.

0
ProgrammingDEV Community ·

Prompt Engineering or Fine-Tuning? How to Know When to Switch

Teams building LLM applications typically begin with prompt engineering, which requires no infrastructure, is instantly reversible, and costs little compared to model training. Prompt engineering works by modifying the input to the model, while fine-tuning directly updates the model's weights to embed desired behaviour by default. Experts recommend staying in prompt-engineering mode until evaluation scores stop improving across three to four consecutive changes, signalling a performance plateau. Fine-tuning becomes viable only when the task is narrow, thousands of real labelled examples are available, and cost or latency constraints make a leaner model preferable. Common warning signs that prompting has hit its limit include diminishing eval gains, conflicting instructions, bloated system prompts, and the same corrections being resent on every API call.

0
ProgrammingHacker News ·

French High Schools Test Whether Reading Newspapers Shapes Teen Habits

A nationwide experiment was conducted in French high schools to study the effects of making teenagers read newspapers regularly. The initiative, documented in a CEPR discussion paper, aimed to examine whether structured news consumption influences students' reading habits, civic awareness, or academic outcomes. The study represents a large-scale policy intervention targeting adolescents across France. Researchers sought to understand the broader educational and social implications of integrating print media into school curricula.

0
ProgrammingHacker News ·

Developer Builds Interactive Tool to Visualize LLM Attention Mechanisms

A developer has released an open-access tool that visually demonstrates how large language models (LLMs) distribute attention across input tokens. The project, shared on Hacker News under 'Show HN', allows users to explore the internal attention patterns that influence how LLMs process and respond to text. The tool is hosted at ishamf.dev and appears aimed at making model interpretability more accessible to researchers and curious users. Such visualizations can help demystify how transformer-based models weigh relationships between words or tokens during inference.