tethysplatform / tethys

The Tethys Platform main Django website project repository.
http://tethysplatform.org/
BSD 2-Clause "Simplified" License
92 stars 49 forks source link

Enable PersistentStoreService to support multiple database engines #926

Open sdc50 opened 1 year ago

sdc50 commented 1 year ago

Currently the PersistentStoreService model has only one option (PostgreSQL) for the engine. It would be great to enable additional engines (e.g. MySQL, SQLite and possibly MS SQL Server).

The PersistentStoreDatabaseSetting class would also need to be updated to support multiple engines. It currently has hard-coded SQL statements in persistent_store_database_exists and drop_persistent_store_database