Laracon DB
Laracon DB
Talks for "database"
Keeping Eloquent Eloquent

A comprehensive talk about writing better Laravel code by focusing on proper use of Eloquent ORM features. The speaker discusses model defaults, relationship management, custom collections, and report generation patterns. He emphasizes the importance of making code readable and semantic, using real-world furniture-making analogies to illustrate concepts of craftsmanship in software development.

Eloquent Performance Patterns

The talk focuses on database performance optimization in Laravel applications, specifically around Eloquent queries. Using a demo fishing social media app, the speaker demonstrates common performance pitfalls when working with Eloquent and presents solutions using sub-queries and relationship optimization. The presentation emphasizes the importance of monitoring metrics like memory usage, query count, and model hydration while showing how to avoid N+1 problems and excessive PHP memory usage when dealing with large datasets.

Livewire Beyond the Basics

A technical deep dive into Laravel Livewire best practices and advanced concepts by Foil, focusing on performance optimization, security considerations, and database architecture. The talk covers strategies for improving Livewire component performance, implementing optimistic UIs, handling database replication for global applications, and securing public properties in Livewire components.

Discovering ElasticSearch

A comprehensive talk about integrating Elasticsearch with Laravel applications, covering search functionality implementation, scaling considerations, and practical integration patterns. The speaker explains how Elasticsearch provides powerful search capabilities beyond traditional SQL databases, demonstrates implementation approaches using Laravel's Eloquent, and discusses best practices for data indexing and querying.

Making the most out of MySQL

A comprehensive talk about MySQL 5.7 features and improvements, focusing on online DDL changes, strict modes, generated columns, and performance monitoring. The speaker explains how these features can improve data consistency and application performance while highlighting important migration considerations from MySQL 5.5/5.6 to 5.7.

How to avoid database migration hell

Claire Smith from Pop Point presents a comprehensive talk on database migrations and seeding in Laravel applications. She discusses best practices for managing database schemas, implementing different seeding strategies, and sharing database migrations/seeds between multiple Laravel applications using Composer packages.

Denormalization With Eloquent: How, Why and When

The talk discusses database denormalization in Laravel applications, focusing on improving read performance while maintaining data integrity. The speaker explains how to use materialized views and event-driven updates to create denormalized data structures that can significantly improve query performance without sacrificing the benefits of normalized databases. The presentation includes practical examples of implementing denormalization using Laravel's eloquent ORM and queue system.

Things every developer absolutely, positively needs to know about database indexing

A comprehensive talk about database indexing fundamentals and best practices, focusing on MySQL/MariaDB. The speaker explains how B-tree indexes work, demonstrates common indexing pitfalls, and shows how to properly design indexes based on query patterns. Through live coding examples, he illustrates how to analyze query execution plans and optimize index usage for better performance.

Scaling Databases

Tobias Petri discusses database scaling strategies in Laravel applications, focusing on the progression from single server to read replication to sharding. He emphasizes the importance of optimizing existing setups before moving to more complex solutions, warns about common pitfalls in each scaling approach, and explains how different scaling solutions fit different application needs. The talk includes practical examples using a hypothetical Laravel e-commerce platform selling conference tickets.

Abusing Laravel for Fun and Profit

David Hemphill gives a talk about creative ways to use and reuse Laravel's built-in components for solving common development problems. He shares approaches for handling front-end filtering, database testing, data access patterns, and model scheduling by leveraging existing Laravel features like pipelines, database seeders, form requests, and the scheduler rather than reaching for third-party packages.

Verbs and Livewire in action

Josh Hanley presents a talk about building a common language between UI and database using actions, focusing on how Livewire and Verbs can work together. He demonstrates how to implement event sourcing in Laravel applications using the Verbs package, showing how to capture user actions as events and process them consistently throughout the application stack.