search

dina-web-nrm / mediaserver-module

Mediaserver core module (source).
Other
1 stars 3 forks source link

SQLite3 support #1

Open gnewton opened 8 years ago

gnewton commented 8 years ago

How difficult would it to modify to allow SQLite3 backend instead of MySql? Advantage is that a site would not need to have a MySql server instance running.

mskyttner commented 8 years ago

+1 and a follow up question by the way - how complex would it be to consider supporting SQLite3 elsewhere? For example also in the dw-cco and dw-classifications... We often aim at supporting postgres, mariadb, mysql for RDMS, shouldn't SQLite3 be prominent in that list, too? Or are there good reasons to aim at supporting for example mysql but not SQLite3 in general?

IcingInk commented 8 years ago

I have not tried this but there seem to be support for SQLite3 in Liquibase. http://www.liquibase.org/sqlite.html The jdbc-jar seems to be here :+1: https://bitbucket.org/xerial/sqlite-jdbc