Posts About MySQL
MySQL is an open-source relational database management system (RDBMS) widely used for storing and managing structured data. It offers high performance, scalability, and reliability, making it a popular choice for web applications and enterprise solutions.
Calling a MySQL Stored Procedure from Laravel
A reader once asked me whether you can call a database stored procedure from Laravel. You can, and these days it is clean. Eloquent itself doe...
Connecting Laravel to a SQL Server (MSSQL) Database
Connecting Laravel to Microsoft SQL Server is straightforward once the right PHP pieces are in place. The catch with SQL Server, unlike MySQL,...
Separate Read and Write Database Connections in Laravel
A reader once asked me whether Laravel can send read queries to one database and write queries to another. This is a common setup when you rep...
Building an Attendance Sheet with a MySQL Pivot in Laravel
I built this for an employee time attendance system. The requirement was a monthly sheet with each employee down the side and every day of the...
Connecting Laravel to a SQLite Database
SQLite is the simplest database to use with Laravel. There is no server to install and no credentials to manage. The whole database is a singl...
Connecting Laravel to a MySQL Database
MySQL is the default database for most Laravel apps, and connecting to it is mostly a matter of filling in your .env. Here is the whole thing....
Connecting Laravel to a PostgreSQL Database
PostgreSQL is a strong choice for a Laravel app, and Laravel supports it as a first class driver. Connecting to it follows the same pattern as...