Using an SQLite database

mccloud

Which files need to be changed in order to use an SQLite database instead of MySQL? and which directory does the SQLite database have to be uploaded to?

allan

I'm afraid I'm not entirely sure what you are referring to, could you be more specific? Is this for the SSP demo class in DataTables' demos, or Editor, or something else?

Allan

mccloud

This is in the Editor. At the moment the generator only offers MySQL and MSSQl. I need to use the Editor with an SQLite database. I gather the the DB details are stored in the config file, but do any other files need changing in order to use the generated code on an SQLite database.

allan

Thanks for the clarification. You would need to change the type parameter in the $sql_details array to be Sqlite per the instructions here.

You would also need to modify the SQL that Generator creates to be valid for Sqlite. That should be all you need to do.

Allan