#eloquent — Public Fediverse posts

I've made a new release: DuckDB driver for Laravel

Support for views
Bugfixes: year default expression, parameter serialization
CI tests: project setup, macOS, Windows
more examples in the readme:
- read and write Parquet files
- copy data from MySQL/MariaDB/PostgreSQL to Parquet
- community extensions
- performance example
- read public data
- Eloquent Models, schema and query builder for special types

https://github.com/thomas-0816/laravel-pdo-duckdb

#php #laravel #analytics #duckdb #eloquent #bigdata

⚡ Type config('app.time and get completions with resolved values shown inline (app.timezone → UTC). A wrong key surfaces instantly as a diagnostic: "Config [ap] not found."

🎯 Coverage spans routes, Blade views, translations, config, env vars, assets & Mix, middleware, #Inertia, #Livewire, auth & policies, container bindings, validation rules, controller actions and #Eloquent.

Ducks are now loving Laravel!

I've built a Laravel DuckDB driver.

It brings the whole DuckDB ecosystem to Laravel (types, extensions, parquet, data lakes, etc.).
Now you can run high performance analytics directly on your laptop or webserver together with Laravel Query Builder and Eloquent ORM!
Releases are available on GitHub and Packagist.

https://github.com/thomas-0816/laravel-pdo-duckdb
https://packagist.org/packages/thomas-0816/laravel-pdo-duckdb

#php #laravel #analytics #duckdb #eloquent #bigdata

🔗 Improving Laravel Architecture With Expressive
https://wendelladriel.com/blog/improving-laravel-architecture-with-expressive
#php #laravel #architecture #eloquent #typing

🔗 Eloquent Query Classes Pattern
https://wendelladriel.com/blog/eloquent-query-classes-pattern
#php #laravel #database #designpatterns #eloquent

🗂️ Use #GoogleSheets as a #Laravel database! laravel-google-sheets-database-driver maps spreadsheet = DB, tab = table, row 1 = columns. Full #Eloquent & Query Builder support. #PHP #opensource
https://github.com/AmazingBV/laravel-google-sheets-database-driver

Album Cover: Eloquent - "Sound Theatre" (2026)

#Music, #Eloquent

Google sort une application de dictée par IA gratuite, et elle fonctionne sans internet, sauf que...
https://mac4ever.com/195546
#Mac4Ever #eloquent #Google

Song Review: Eloquent – “Checkered Past”

In April 2026, synthpop duo Eloquent released “Checkered Past,” the lead-off single from their album, Sound Theatre.

http://aeschtunes.com/2026/04/07/song-review-eloquent-checkered-past/

#Music, #MusicReview, #Eloquent, #2020s, #2020sMusic, #Synthpop, #ElectronicMusic, #AeschTunes

#DelegatedTypes in #Laravel — Smarter Alternative to STI #PHP #Eloquent #opensource #webdev

🏗️ Model class hierarchies via polymorphic relationships & delegation — composition over inheritance, done right

🧵👇

🔄 Each subtype keeps its own table while sharing a common root Entry model — no more nullable column bloat like with STI
🎯 Comments, likes & reactions attach to the Entry — one route, one controller, no endpoint explosion

Eloquent Guard: как ловить N+1 и медленные запросы в Laravel, не зарываясь в vendor

Проблема N+1 стара как мир. Инструментов много: Debugbar хорош локально, Telescope тяжеловат для продакшена. Мне хотелось решения, которое будет «стучать» в Slack или Telegram именно тогда, когда проблема случилась на проде, и при этом сразу показывать пальцем на виновную строку кода.

https://habr.com/ru/articles/1010822/

#laravel #eloquent #php #sql #mysql #postgresql #database_optimization #database_performance #database_monitoring

Uff, I've been bit by a quirky Eloquent issue. The worse part is that I know why it happens but I don't know how to "fix it" (I've found a workaround, but Id like to prevent it from happening in the future, ideally with a patch upstream).

It involves relationships, macros for the Builder and eloquent silently overriding an `id` column because the results from the SQL query contain 2 different `id` columns (because of a join).

I'll try to create a sample project with minimum code to reproduce and see if I can manage a fix.

#Laravel #Eloquent

A great option to optimize database writes in Laravel is using bulk operations.
E.g. "upsert()" can insert/update multiple rows with _one_ query using "on duplicate" logic:

User::upsert(values: [
['email' => 'foo@domain', 'name' => 'Foo'],
['email' => 'bar@domain', 'name' => 'Bar'],
], uniqueBy: ['email'], update: ['name']);

becomes:

INSERT INTO users (email, name),
VALUES
('foo@example', 'Foo'),
('bar@example', 'Bar')
ON DUPLICATE KEY UPDATE name = values(name);

#laravel #eloquent

When adding the type for the Query Builder that's passed as an argument to an Eloquent's scope, do you use `Illuminate\Database\Eloquent\Builder` or `Illuminate\Contracts\Database\Eloquent\Builder`.

I just realized they were being used interchangeably on a project I've been working on.

My initial thought would be to use always the contract (the interface is implemented by `Eloquent\Builder` and by `Eloquent/Relations/Relation`), but looking at the docs, the official stance is to import the Builder object 🤔

https://laravel.com/docs/12.x/eloquent#local-scopes

Any thoughts?

#Laravel #Eloquent #PHP

Christine Jorgensen was so eloquent.

https://www.youtube.com/watch?v=fyh8BxPxtnw

#sofiaflorina #ソフィアフロリナ #transgender #transgenders #transwoman #transwomen #christinejorgensen #interview #interviews #lgbt #lgbtq #lgbtqia #lgbti #eloquent #queer

#3 🔒 Use #Eloquent ORM and query builder to prevent #SQL injection attacks
🧼 Escape all output with #Blade syntax to avoid #XSS vulnerabilities
🛡️ Implement #CSRF protection middleware in all forms and state-changing requests

During the AeschTunes Top 40's run, two songs tied for the record of spending the most weeks at #1 (which was five weeks).

I'll reveal the first song with this post, and the other will be revealed as a response to this one.

The first of the two songs is "Carte Blanche" by Eloquent.

https://www.youtube.com/watch?v=MTM23bWsyzU

#Music, #Eloquent, #AeschTunes

#Laravel #Eloquent Performance Tips: Key Database Optimization Tactics 🚀
Measure your database performance:
• 🔍 Use #LaravelDebugBar and #LaravelTelescope to monitor memory usage, query time, and duplicates

• 📊 Watch for high RAM consumption (>1MB per request) as sign of inefficient queries
• 🧮 Track loaded #Eloquent models count to prevent memory bloat
Optimize memory usage and queries:
• 🎯 Select only needed columns instead of retrieving all fields

Lessons From #Laravel #Eloquent Performance Patterns (Cheatsheet)

Optimize DB performance with LaravelDebugBar: track memory, duplicates, and models. Minimize RAM by selecting necessary columns using subqueries. Try chaperone() for circular relationships. Index columns for faster queries.
🧵👇

I have a recommendation for those who use #languagetool in the locally. I often get many error messages. I discovered #Eloquent (https://github.com/sonnyp/Eloquent/) which works quite nicely and hooks easily into KMail and LibreOffice and even Firefox.

This application is based on languagetool but it seems that it manages everything very efficiently. It's easy to install and easy to run.

Hulk Hodn dans Chat with a DJ
https://www.youtube.com/watch?v=6AVMnUgjhN0
#youtube_arteconcert #Hulk_Hodn #Hodini #Retrogott_Hulk_Hodn #Eloquent #Twit_One #Chat_with_aDJ #Berlin #DJ_Set #Techno #Electro #Konzert #Concert #ARTE #ARTE_Concert

It would be nice, if #Tusky could support the usage of #LanguageTool .
I use it through the app #Eloquent and off course offline 🤓

Novo app na área pro pessoal do 🐧: #Eloquent https://flathub.org/apps/re.sonny.Eloquent

Ele resolve algo que eu sinto falta desde que cheguei no Linux, análise gramatical de escrita! Basta colar o texto que escreveu nele para revisão, mas mais importantemente, ele roda um servidor baseado no protocolo do #LanguageTool localmente na sua máquina ao qual você pode apontar para que programas como o LibreOffice e Firefox integrem 🧩🫶

- LibreOffice: https://help.libreoffice.org/latest/pt-BR/text/shared/optionen/languagetools.html
- Firefox (extensão): https://addons.mozilla.org/en-US/firefox/addon/languagetool/

• #Blade components support
• #Livewire and #Inertia integration
• #Eloquent support
• Test file navigation

https://github.com/laravel-ls/laravel-ls

🚀 Improved workflow in #Laravel: New Reservable trait enables atomic locking for models, preventing race conditions & managing task overlaps.

Demo uses #YouTube video processing with #PHP #cache locks.

🔐 Key Implementation Features:
• Built on #Laravel's atomic locking system for guaranteed single-process execution
• Custom trait 'Reservable' simplifies model reservation management
• Flexible interface supporting multiple duration formats & key types
• Integrated with #Eloquent scopes for streamlined queries

⚡️ Developer Benefits:
• Prevents duplicate processing of models in concurrent operations
• Manages failure rates through automatic lock duration
• Reduces external API request frequency on errors
• Supports both manual and scheduled task execution

🛠️ Technical Highlights:
• Compatible with various cache drivers including database
• Implements force release functionality for specific use cases
• Includes collection & builder macros for cleaner syntax
• Seamless integration with existing #Laravel commands

🔄 Real-world Applications:
• Video processing pipelines
• External API integrations
• Background job management
• Resource-intensive operations

https://bit.ly/4fPjKkO

🧵5/14 | You can test #eloquent the #Laravel ORM. It uses the wouterj-nl/symfony-eloquent bundle. Thanks, @wouterjnl, for the pieces of advice and the code reviews. Feature branch: https://github.com/strangebuzz/MicroSymfony/pull/65 ⬇️

$appends is an ant-pattern

#Laravel #Eloquent