Incubator-superset: Unable to add a SQLite DB

[hc128168]

I tried to add a db located at "/home/hc/superset/db/test.db" to superset via "Sources->Databases->Add a new record". I set "sqlite:////home/hc/superset/db/test.db" as SQLAlchemy URI, and hit "Test Connection". And it says, "ERROR: SQLite database cannot be used as a data source for security reasons."

• superset version: 0.36.0
• python version: 2.7.5 (I have python 3.6 installed as well but not sure which one superset uses)
• node.js version: not installed as it is not listed as required here nor as optioal
• npm version: not installed.

Make sure these boxes are checked before submitting your issue - thank you!

• [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
• [x] I have reproduced the issue with at least the latest released version of superset.
• [x] I have checked the issue tracker for the same issue and I haven't found one similar.

[dpgaspar]

Superset is going to drop support for SQLLite, for now you can override this by setting PREVENT_UNSAFE_DB_CONNECTIONS = False on the config

[hc128168]

@dpgaspar Thanks. It works!

While I looked up the setting, I found the pull request. It seems like it doesn't convert the examples to use another database tho.

[mjsabby]

Is there a reason to drop sqlite?