In this post, I’ll explain how we can use the Laravel’s Builder Object to improve code reusability when creating a series of complex queries.
Recently I was tasked with the seemingly simple task of running an alter table to update the data type of a table. However, because the table had tens of millions of rows I soon discovered the task would not be so easy to solve. In this post, I'll explain the solution: creating an archive version of the table.
When building an application that develops a heavy dependency on database interaction, it's easy to start with some basic queries that eventually require refactoring due to performance reasons. In this post, I'll walk through an example query which leverages a SQL left join to improve database response time.
Recently, I was working on a Laravel website that is powered by a Wordpress CMS with a lot of static content. While developing the site, performance was never really an issue but once we started getting a lot of users the page speed got much worse. In order to solve this problem, we implemented Laravel’s caching facade. In this post, I’ll explain how to did so.
In this post, I’m going to dive into the weird and wacky world of Regular Expressions to breakdown how to replace the contents of an HTML string using PHP.