Ad

Which Database Engine Type Should Be Specified For Microsoft SQL Database In Laravel?

I am working on a web application using OctoberCMS which sits on Laravel 5.5.40 and is using a Microsoft SQL Database.

Database migrations are managed using the standard Blueprint objects which allow a database engine to be specified. Currently all the migrations are using InnoDB, which I believe is only supported by MySQL.

Does this mean that the engine type is being ignored? Also is it possible to specify different engine types for Microsoft SQL Database tables and what options are available?

Ad

Answer

The concept of "database engine" or "storage engine" is quite specific to MySQL; most database systems have a single back end which everything is built on. There are sometimes special types of database or table for specialist circumstances - e.g. adapters for importing data from other systems, or column-oriented stores for analysing large data sets - but they're rarely encountered.

For Microsoft SQL Server, there really isn't an equivalent option you need to specify. There may be other options you can set about how to configure the table for performance, but I would expect the ORM choose reasonable defaults and there isn't a single parameter with lots of tradeoffs like changing a MySQL engine.

Ad
source: stackoverflow.com
Ad