Retrieving 3+ million MySQL records, in less than 2 minutes
Looking at how I modified a SQL query to retrieve 3.2 million records from a database (paginated) in about 10% of the time of a traditional paginated query
Handling large data with cron jobs and queue workers
One problem a lot of developers seem to come into, from reading their code, is when they try to handle large sets of data with background scripts. There are a few common mistakes that I have seen from inheriting the code of my predecessors, and I thought I would offer some solutions to the problems …
Read more “Handling large data with cron jobs and queue workers”
Using MySQL to return complex tagged results
Hi everyone In this article I thought I would tackle complex tag searching, using MySQL. There are lots of ways this can be achieved at a PHP level, through looping and checking/comparing. However, if you are working with a large dataset, and tagging is a required piece of functionality, for example in an enterprise blog, …
Model Search and Filtering in Laravel
Hi guys, as I have written this functionality a few times at this point, and I have been asked how to do it a couple of times, too. That is Laravel searching and filtering, I am going to develop a simple composer package which I can use to allow users to search and filter Laravel …
An introduction to Checksums
Hi everyone This is a quick introduction into checksums, and practically how to use them, at the request of someone through the Ask Johno section of the blog. I know what a checksum is, but I’m not sure how to implement or use one (in PHP) to achieve what I need. Anonymous Asker They go …
Amazon Web Services – EC2 Quickstart
Good afternoon everyone Today I am going to give a super-quick recipe to get your first EC2 up and running; if you’ve worked with virtual or dedicated servers before the cloud architecture thing can feel a bit overwhelming, or if you’ve not had to manage your own environments before. In any case, as you don’t …
Bringing OOP functionality into WordPress
So if, like me, you’re an object orientated programmer and are suddenly asked to build functionality into WordPress it can feel like you’re trapped into procedural code and functions. Consequently; I thought I would whip up a little tutorial of how to work within WordPress, whilst maintaining your OOP integrity. The reason this is important …
PHP Interfaces, Traits, and Inheritance, how and when to use them
Hi all So this one is going to be fairly short and simple, I hope! What I am going to cover, and this does assume so prior knowledge, is what interfaces, traits, and inheritance are; and some different use cases for them. So the first one, and maybe the easiest one to cover, first: Inheritance …
Read more “PHP Interfaces, Traits, and Inheritance, how and when to use them”
Quick and Easy PHP Singleton
Hi guys A really short one today, just because someone asked me about it a couple of days ago. I also though it potentially best to avoid something as controversial as my last post about Eloquent and the Single Responsibility Principle, which caused a bit of a stir during the week. So, you want to …
Using Git to effectively manage your code
Hi everyone This time I thought I would give a quick insight into the ways which I have found to be best when working with Git. Especially if you’re in the position where you’ve never had to manage or decide the direction of how to use source control. I’m sure you all know the benefits …