DBQuery App: MySQL, PostgreSQL, Oracle and Sqlite Query Editors

Published on 11 November 2013 in - 2 minutes read - Last modified on 06 March 2021

In Thailand, a brand new application that enables viewing data in MySQL, PostgreSQL, Oracle and Sqlite has been committed.

Inspired from the Beeswax application, it allows you to query a relational database and view it in a table.

Example of configuration in hue.ini:

[librdbms]

\# The RDBMS app can have any number of databases configured in the databases

\# section. A database is known by its section name

\# (IE sqlite, mysql, psql, and oracle in the list below).

[[databases]]

\# sqlite configuration.

[[[sqlite]]]

\# Name to show in the UI.

nice_name=SQLite

\# For SQLite, name defines the path to the database.

name=/home/romain/projects/hue/desktop/desktop.db

\# Database backend to use.

engine=sqlite

\# mysql, oracle, or postgresql configuration.

[[[mysql]]]

\# Name to show in the UI.

nice_name="My SQL DB"

\# For MySQL and PostgreSQL, name is the name of the database.

\# For Oracle, Name is instance of the Oracle server. For express edition

\# this is 'xe' by default.

#name=hue

\# Database backend to use. This can be:

\# 1. mysql

\# 2. postgresql

\# 3. oracle

engine=mysql

\# IP or hostname of the database to connect to.

\## host=localhost

\# Port the database server is listening to. Defaults are:

\# 1. MySQL: 3306

\# 2. PostgreSQL: 5432

\# 3. Oracle Express Edition: 1521

\## port=3306

\# Username to authenticate with when connecting to the database.

user=root

\# Password matching the username to authenticate with when

\# connecting to the database.

password=root

Note: you can look at the Hue database guide for installing the DB connectors

 


comments powered by Disqus

More recent stories

03 May 2023
Discover the power of Apache Ozone using the Hue File Browser
Read More
23 January 2023
Hue 4.11 and its new dialects and features are out!
Read More