Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
V
V
VladimirDronik2021-04-16 18:30:16
SQLite
VladimirDronik, 2021-04-16 18:30:16

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

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

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
D
DevMan, 2021-04-16
@VladimirDronik

The project needed to get rid of the DBMS in general.
a nicho that sqlite is a DBMS?

Similar questions
S
Studentka19962020-02-04 00:06:58
What is the error when writing to the database? 1Reply
P
Philip Bondarev2017-10-01 23:22:09
Is it possible to write multiple FOREIGN KEYs in one SQL cell? 1Reply
N
Neonoviiwolf2017-10-04 22:27:56
How is it usually determined whether the database in the application is up to date? 0Reply
S
Sergey Kamyshev2017-10-23 13:26:29
How to correctly formulate a sql query with two or more arguments (SQLite)? 1Reply
R
redduckrobot2017-11-06 16:38:43
How to sort with Ukrainian subset of Cyrillic characters in Django + SQLite? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question