4

I am following this tutorial: https://genieframework.com/docs/tutorials/Developing-MVC-Web-Apps.html#gettingstarted-creatingtheapp where I created my MVC app and selected a MySQL backend. However, I am having issues with MySQL so I want to switch the app to SQLite as the tutorial uses. Is there any way I can switch the app to use that or would I have to manually re-create a new project? If I can switch it, what files need to be manually modified or is there a function that can help me?

logankilpatrick
  • 13,148
  • 7
  • 44
  • 125

2 Answers2

3

You switch it manually, it's quite easy:

1/ add support for SQLite via SearchLightSQLite:

pkg> add SearchLightSQLite

2/ edit db/connection.yml and set adapter to SQLite and database to the path where you want to store the DB, ex:

dev:
  adapter: SQLite
  database: db/dev.sqlite

3/ Restart the app

essenciary
  • 401
  • 2
  • 3
0

For anyone that might face the same challenge, You need to add SearchLightMySQL to the project by running Pkg add SearchLightMySQL

CHINONSO
  • 1
  • 1