Some SQL Tricks of an Application DBA
Databases are the backbone of most modern systems, so taking some time to understand how they work is a good investment for any developer.
Read more [hakibenita.com]
Posts tagged with performance
How to clean up huge tables in Laravel with ease
Using our laravel-model-cleanup package, you can easily remove old unneeded records from your database. We recently released a new major version that adds support for safely cleaning out huge tables.
In this blog post, I'd like to introduce this new release of the package to you.
Join thousands of developers
Every two weeks, I share practical tips, tutorials, and behind-the-scenes insights from maintaining 300+ open source packages.
No spam. Unsubscribe anytime. You can also follow me on X.
Using pcov instead of XDebug for code coverage
Michael Dyrynda explains why and how you should install pcov
Read more [dyrynda.com.au]
PHP8's JIT performance in real-life web applications
My collegue Brent did some benchmarks of the upcoming JIT coming to PHP 8
Read more [stitcher.io]
Hands-on with Portals: seamless navigation on the Web
– web.dev
Wouldn't it be nice if users wouldn't see a blank screen when navigation to another URL? Portals allow you to preload the next page and transition to it with a nice animation.
Read more [web.dev]
Enable early access Metal support for JetBrains IDEs
Project Lanai is a joint effort between JetBrains and Oracle that looks to solve performance problems by utilizing Apple's Metal API for rendering the application instead of OpenGL. My colleague Alex tried using it in PhpStorm
Read more [alexvanderbist.com]
Ordering database queries by relationship columns in Laravel
Jonathan Reinink published another excellent blogpost on db performance.
Read more [reinink.ca]
Introducing new performance monitoring for your websites
We're excited to announce all Oh Dear users now have access to detailed performance metrics for all of their websites!
Read more [ohdear.app]
Application Instrumentation with Aspect Oriented Programming in PHP
– medium.com - submitted by Vasily
A nice introduction to AOP in PHP, with a focus on performance, with a lot of benchmarks.
Read more [medium.com]
Native image lazy-loading for the web!
Did you know modern browsers can lazy load images out of the box? Laravel-medialibrary now supports this too.
Read more [addyosmani.com]
Understanding PHP 8's JIT
PHP 8’s Just In Time compiler is implemented as part of the Opcache extension and aims to compile some Opcodes into CPU instructions in runtime. Nickolas Da Silva explains how it works.
Read more [thephp.website]
Lazy Collections in Laravel Excel
– stefanzweifel.io - submitted by Stefan Zweifel
Stefan Zweifel recently had to refactor an Excel export which deals with thousands of rows. Lazy Collections helped solve all performance problems.
Read more [stefanzweifel.io]
laravel-event-sourcing v3 has been released
Our spatie/laravel-event-sourcing package is probably the best starting point for event sourcing in Laravel. It has excellent docs, that explain event sourcing from scratch, support for aggregates, projectors, and much more! It's all beautifully integrated in Laravel.
Recently we released v3 of the package. In this blogpost I'd like to walk you through the changes.
Calculate the Carbon output of your website
– www.websitecarbon.com - submitted by Brent
How is your website impacting the planet?
Read more [www.websitecarbon.com]
PHP: Past and Future
Joe Watkins compares the execution speed of PHP 4 against PHP 8. It's amazing how far PHP has come.
Read more [blog.krakjoe.ninja]
The end of cold starts at AWS Lambda
Yan Cui explains a feature called "Provisioned concurrency" that Amazon recently launched
Read more [lumigo.io]
Memoizing stuff in PHP 7.4
Did you know that the null coalescing assignment operator in #PHP 7.4 can be used to make memoizing stuff a little more clean? pic.twitter.com/SWWJEXQBLx
— Brent (@brendt_gd) January 16, 2020
Read more [twitter.com]
PHP Performance Trivia
Nikita Popov discusses some low level performance optimizations in PHP.
Streaming a large export as a CSV file to the browser
A while ago, I created an easy to use framework agnostic PHP package to read and write CSV and Excel files called spatie/simple-excel. Behind the scenes, generators are used to ensure low memory usage, even when working with large files. Today I added a method that allows you to stream CSV files to the browser. In this small blog post, I'd like to demonstrate how you can use it.
Disable HTTP sessions in Laravel to speed up your API
My buddy Mattias recently improved the performance of the Oh Dear uptime checker servers by disabling the HTTP sessions.
If you run a Laravel application purely as a headless API, you can benefit from disabling the HTTP sessions. We use this setup for our Oh Dear monitoring service, where the remote servers that check for uptime are all headless Laravel setups.
Read more [ma.ttias.be]