Before we start; there are going to be many many ways to approach this, but this is a super quick tutorial. So expect action rather than perfection. I’m going to assume we’re running an Ubuntu box, and that everything is running on a single LAMP server. You’re free to modify any of these to suit …
Read more “Super Quick Tutorial: Backing Up Database with Laravel Artisan on the Scheduler”
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
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, …
Hi folks, It’s no secret that I love Laravel, and especially love Eloquent. This post isn’t about why various people don’t like Eloquent, etc, etc. but just some “life hacks” of working with Eloquent. #1 – Naming Conventions I personally like to use the following naming convention on my databases (using a forum as an …
Tonight is just a quick one, not my usual essay. I was just curious to see what other people though. Being a PHP Developer I primarily work within LAMP environments. Occasionally having swapped out Apache for Nginx, but I am by far a specialist. Until recently I was able to jump around through the Linux …