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

21 September 2021
Access your data in ABFS without any credential keys!
Read More
14 September 2021
SSO for REST APIs with your custom JWT authentication
Read More
17 August 2021
Create Phoenix tables in Just 2 steps
Read More