home.social

#eloquent — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #eloquent, aggregated by home.social.

  1. 🗂️ 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
    github.com/AmazingBV/laravel-g

  2. 🗂️ 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
    github.com/AmazingBV/laravel-g

  3. 🗂️ 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
    github.com/AmazingBV/laravel-g

  4. 🗂️ 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
    github.com/AmazingBV/laravel-g

  5. 🗂️ 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
    github.com/AmazingBV/laravel-g

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

    #Music, #Eloquent

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

    #Music, #Eloquent

  8. 55 Times in a 3 hour span is excessive even for a demented pyscho. In moments of anger or frustration i might do 5 posts in a day .

    5150 in shells might be a good thing .

    ( The person must be deemed a danger to self (DTS), danger to others (DTO), or gravely disabled.) Fits?

    #trump #cognitive #obama #nobelpeaceprize #eloquent #narcicissm
    #mentalHealthMatters

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

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

  11. Song Review: Eloquent – “Checkered Past”

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

    aeschtunes.com/2026/04/07/song

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

  12. Song Review: Eloquent – “Checkered Past”

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

    aeschtunes.com/2026/04/07/song

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

  13. #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

  14. #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

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

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

    habr.com/ru/articles/1010822/

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

  16. 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

  17. 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

  18. 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

  19. While there are many tutorials like dudi.dev/optimize-laravel-data to create better queries to read data in Laravel, there are only very few to optimize writes.

    Probably most underrated feature is "isDirty()" to save data only if it got changed, e.g.

    // Retrieve a user from the database
    $user = User::find(1);

    // Change the name attribute
    $user->name = 'Some Name';

    // Save only if there are changes
    if ($user->isDirty()) {
    $user->save();
    }

    #laravel #eloquent

  20. 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 🤔

    laravel.com/docs/12.x/eloquent

    Any thoughts?

    #Laravel #Eloquent #PHP

  21. 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 🤔

    laravel.com/docs/12.x/eloquent

    Any thoughts?

    #Laravel #Eloquent #PHP

  22. #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

  23. #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

  24. 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.

    youtube.com/watch?v=MTM23bWsyzU

    #Music, #Eloquent, #AeschTunes

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

  26. • 📊 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

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

  28. • 📊 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

  29. 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.
    🧵👇

  30. 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.
    🧵👇

  31. I have a recommendation for those who use in the locally. I often get many error messages. I discovered (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.

  32. I have a recommendation for those who use #languagetool in the locally. I often get many error messages. I discovered #Eloquent (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.

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

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

    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: help.libreoffice.org/latest/pt
    - Firefox (extensão): addons.mozilla.org/en-US/firef

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

    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: help.libreoffice.org/latest/pt
    - Firefox (extensão): addons.mozilla.org/en-US/firef

  36. 🚀 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

    bit.ly/4fPjKkO

  37. 🚀 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

    bit.ly/4fPjKkO

  38. 🧵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: github.com/strangebuzz/MicroSy ⬇️