Category: Database

Laravel Doctrine – Best of Both Worlds?

Laravel Doctrine is a drop-in implementation of the famous ORM for the Laravel 5.X Framework, and a really interesting alternative to the default choice, Eloquent. In this article, we will learn how to use it, and when.Why Doctrine, and not Eloquent? Those of us who have used Laravel at least once, have probably used...

How To Use Airtable as a Front End Developer

I came across Airtable at a recent hackathon-esque event, when a fellow developer suggested we use it as a way to store and use our data. I was super into it. For the first time, I felt like: “This is a database for me. This is what I want out of a data storage system.”In a nutshell… Airtable lets ...

Phinx – the Migration Library You Never Knew You Needed

You’re building an application, and you need to share the database’s structure with your team. After all, you want everyone to be up and running as soon as possible. What do you do? SQL dumps of table structures? You could… but that’s so very primitive – and can be time consuming to import...

Sourcehunt: Cron Management, Hackathon Starters, PHP-GUI…

Ready for a new edition of sourcehunt? Get those starring-fingers ready!lavary/crunz [15 ★] crunz is a Laravel scheduler-inspired cron manager for PHP, fully framework agnostic and independent. In many ways, it’s similar to Jobby and cron-manager, so we’ll leave the comparisons up to you… for now. Laravel Hac...

PredictionIO: Bootstrapping a Movie Recommendation App

In this tutorial, I’m going to walk you through PredictionIO, an open-source machine learning server, which allows you to create applications that could do the following:recommend items (e.g. movies, products, food) predict user behavior identify item similarity rank itemsYou can pretty much build any machine le...

Your First Drupal 8 Migration

Migrate is one of the most established modules in the Drupal ecosystem. So much so that with Drupal 8, a decision has been made to get some of its functionality ported and added to Drupal core. An important reason was that the traditional upgrade between major releases was replaced with a migration of Drupal 6 […...

Building a Hacker News Reader with Lumen

In this tutorial, we’re going to build a reader for Hacker News. We will be using the Hacker News API and the Lumen framework to implement this. The final output looks something like this:If you’re excited, let’s go ahead and jump right into it. Installing and Configuring Lumen The first thing that you need to ...

3 More Joins You Should Be Familiar With

There are many ways to JOIN data from two database tables and filter the information you require. Craig Buckler wrote a popular piece on understanding JOINs; namely INNER, LEFT, RIGHT, and FULL OUTER. This article is an extension of that one. Let’s recap these real quick. Picture two tables, one for customers and one...

Quick Tip: How to Permanently Change SQL Mode in MySQL

I was working on a legacy project recently and needed to import some data from MySQL 5.5. All the queries in the code worked perfectly in MySQL 5.5, so I assumed an upgrade to 5.7 would be seamless. Not so.First I got errors due to DateTime columns being populated with zeros during import, then when running this quer...