How to set SQLite Query Configurations in Hue

Question

Hi. I am using Hue and SQLite database. Now I want to add the configurations of SQLite in the Hue configuration. Where do I configure this?

Answer 1

To set the query configurations, you will have to add the properties of your SQLite database in the Hue configuration file. In this file, search for the [[databases]] section and then under [[[sqlite]]] add the following properties:

# Name to show in the UI.      
## nice_name=SQLite      

# For SQLite, name defines the path to the database.      
## name=/tmp/sqlite.db      

# Database backend to use.      
## engine=sqlite