Testing your DOM in Laravel.

Published: 2022-11-10 Author: Tray2

Testing your views, yes I said, testing your views. This is something that is both boring and quite tricky to get right.

Using table triggers to log changes in your database tables.

Published: 2022-10-22 Author: Tray2

Tracking changes in a table or several tables for that matter can be essential for your application, and we are going to take a look on how to do that using only the MySQL/MariaDB database.

Use a view instead of a complex Eloquent query in your Laravel application

Published: 2022-10-01 Author: Tray2

What is a database view, and how can we use it to make our code cleaner?.

Using a datalist instead of a dropdown in your forms

Published: 2022-09-30 Author: Tray2

Have you ever had a huge list of values that the users needs to scroll through to get to the item they wanted, you know the classic `Country` dropdown, and for me who lives in Sweden will have to scroll through a load of countries to get to the desired one.

Properly formed foreign keys are your best friends

Published: 2022-09-14 Author: Tray2

A few days ago a user at the Laracasts forum had performance issue with one of his queries that used joins. While a join can cause some performance slow-downs, it shouldn't be anywhere near the 12 seconds he claimed that the query took. This post here will explain what the issue probably was and how to speed that up.

Speed up the creation of new Laravel projects

Published: 2022-08-18 Author: Tray2

Speed up the creation of new Laravel projects.

Database Design (Part 2)

Published: 2022-02-26 Author: Tray2

This is a continuation of my earlier post on Database Design. This time I will talk about some nuts and bolts in a database, and how many of them can help, and sometimes even break your application

Recommended Web Development Courses

Published: 2021-11-14 Author: Tray2

Just a small collection of recommended courses for web developers.

The value of a good database model

Published: 2021-11-13 Author: Tray2

You might think that the way your store your data isn't really that important. Well it's more important than you think it is. A good database design just like good clean code is the key to performance, not only for the end user but also for you the developer. A poor database model just like poorly written code will slow you down and furthermore it will slow your database queries down which results in a slow application. Just like with the SOLID principles there are some things to consider when developing a database model.

Common SQL errors for Laravel Developers

Published: 2021-11-13 Author: Tray2

Why write this little guide since Laravel uses Eloquent to talk to the database? The answer is simple, the errors the database returns are SQL errors and if you don't know how to interpret them then your life as a developer will be harder.