O Laravel is a framework that offers many facilities in the database connection. It has several advanced features to help deal with the most diverse database systems, combining the ease of accessing the information needed for our applications. This framework does this through its query builder (consultation builder) and through ORM (object-relative mapping) eloquent .

Query Builder

Laravel Query Builder offers a simple form to create and run consultations in databases. They can work well with all databases supported by Laravel ( and listed below in the article ).

besides, the query builder is also safe , because it uses pdo (&&] php data objects ), which is already the recommended standard for the safe connection and with databases using databases using php , through parameters for protection against attacks of sql injection Query Builder is also highly

, allowing the database interaction without changing large code sections when changing from one database to another (as long as the databases in question are supported by Laravel, obvious). ELOCENT ORM

The

is an object-reaction mapping tool used by Laravel for interaction between databases and object-oriented applications more abstractly and flexiblely, making the differences between the object-oriented data model used by applications and the relational model used by SGBDRS ( Database management systems Relational ) become "transparent" to developers and without writing a line of code sql directly in the application. ELOQUENT does this through the use of a class model (from the MVC concept) for each database table. It is through this model that we can perform the operations with the database from class methods, such as the famous operations crud ( create, read, update and delete data ) Currently in its new version (11.x) Laravel supports the following databases:

• mysql version 5.7 or higher
• PostgreSQL Version 10.0 or higher
• sqlite version 3.26.0 or higher
• SQL Server version 2017 or higher
Laravel stands out as a complete and flexible solution for database management, offering a range of resources that simplify developers' lives and increase applications efficiency. With powerful tools such as Query Builder and Eloquent ORM, the framework offers everything necessary to develop robust and scalable applications while ensuring safety and performance. Whatever the chosen database, Laravel is prepared to deliver a quick and reliable development experience.