/njs-sql-console

Interact with your database through a nodeJS app

Primary LanguageJavaScript

NodeJS MySql Console Interface

Interact with your database with single queries. Reply's are returned to a auto-generated Datatable. (CDN) Queries are 'formatted' by CodeMirror (CDN)

Features

  • Each user gets a tab
  • When a new user logs in, a new tab is created
  • When a user leaves the system, their tab is destroyed
  • Each tab is a shared session
    • Sessions will update across all clients
    • Session data is retrieved when tab is clicked
Dependencies

CDN

  • DataTables
  • DataTables - Table Tools
  • CodeMirror

Installation

  • run sudo npm install to install node_modules
  • copy config.js.example to config.json for both public and private directories
  • modify config.js's to reflect your server and ports

Configuration

private/config.json

{
"port": "3702",                     // Default port 3702
"hostname": "localhost",            // Loopback
"host": "database.hostname.com",    // Database location (aws endpoints should work)
"user": "user",                     // Database user
"password": "password",             // Database password
"database": "schema"                // Database schema
}

public/config.js

var port = 3702;                        // Must match private/config.json
var hostname = "www.hostname.com";       // Externally accessable URL

Use

CLI

node server.js

Browser

Point your browser to www.hostname.com:3702/ Use any username and the password stored in private/config.json