What difficulties are expected when converting a project from mysql to sqlite in Laraver?

V

VladimirDronik2021-04-16 18:30:16

SQLite

VladimirDronik, 2021-04-16 18:30:16

There are thoughts to transfer the project from mysql to sqlite. The project needed to get rid of the DBMS in general.

What pitfalls are expected?
I guess I'll have to rewrite all migrations at the very least.
To what extent does sqlite support tables being related by keys? I know that there seems to be no JOIN LEFT and other things. What other surprises await?
Will requests be severely affected? Or will ORM itself figure out how to generate queries for the desired database?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

DevMan, 2021-04-16
@VladimirDronik

The project needed to get rid of the DBMS in general.

a nicho that sqlite is a DBMS?