Quix

Quix

  • Docs
  • Blog
  • GitHub

›Supported datasources

Introduction

  • About
  • Architecture

Getting Started

  • Installation

Supported datasources

  • Athena
  • BigQuery
  • ClickHouse
  • Jdbc
  • MariaDB
  • MySQL
  • Oracle
  • PostgreSQL
  • Presto
  • Python
  • Redshift

PostgreSQL

Features

Work with PostgreSQL straight from Quix, execute multiple queries in parallel, explore the db tree, visualize and download the results into csv.

Setup

To setup PostgreSQL note you have to perform the following two steps :

1. Pick new name and update .env

Add/update following properties to .env file to configure your new postgresql note

VariablesMeaningExample
MODULESlist of registered notesfoo,boo,prod,qa
MODULES_FOO_ENGINEnote typejdbc
MODULES_FOO_DRIVERjdbc driver classorg.postgresql.Driver
MODULES_FOO_URLjdbc urljdbc:postgresql:postgres
MODULES_FOO_USERdb usernameuser
MODULES_FOO_PASSdb passwordpass
MODULES_FOO_SYNTAXsyntax markeransi_sql

example of postgresql jdbc note that will be named foo in the UI

MODULES=<comma separated list of your modules>,foo

MODULES_FOO_ENGINE=jdbc
MODULES_FOO_DRIVER=org.postgresql.Driver
MODULES_FOO_URL=jdbc:postgresql:postgres
MODULES_FOO_USER=your-user
MODULES_FOO_PASS=your-password
MODULES_FOO_SYNTAX=ansi_sql

Troubleshooting

← OraclePresto →
  • Features
  • Setup
    • 1. Pick new name and update .env
  • Troubleshooting
Quix
Docs
Quick StartInstallation
Social
BlogQuix
Contact Us
By Email
© 2023 Wix.com, Inc