sqlectron-core
sqlectron-core
Last updated 2 months ago by masterodinbot .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install sqlectron-core 
SYNC missed versions from official npm registry.

sqlectron-core

Build Status npm

The common code used by all sqlectron clients.

Requires node 6 or higher.

How to pronounce

It is pronounced "sequelectron" - https://translate.google.com/?source=osdd#en/en/sequelectron

Current supported databases

Do you want to support another SQL database? Please follow these steps.

Installation

Install via npm:

$ npm install sqlectron-core --save

Configuration

SQLECTRON keeps a configuration file in the directory

  • MacOS: ~/Library/Preferences/Sqlectron
  • Linux ($XDG_CONFIG_HOME or ~/.config) + /Sqlectron
  • Windows ($LOCALAPPDATA or %USERPROFILE%\AppData\Local) + \Sqlectron\Config

For older versions it was stored as .sqlectron.json at the user's home directory (~/ osx and linux; %userprofile% windows ).

Although you can change this file manually, most of time you should not worry about it because SQLECTRON will manage the configuration for you.

Example

{
  "resultItemsPerPage": 50,
  "limitQueryDefaultSelectTop": 100,
  "servers": [
    {
      "id": "c48890d8-5d87-4085-8b22-94981f8d522c",
      "name": "pg-vm-ssh",
      "client": "postgresql",
      "host": "localhost",
      "port": 5432,
      "user": "user",
      "password": "password",
      "database": "company",
      "ssh": {
        "host": "10.10.10.10",
        "port": 22,
        "privateKey": "~/.vagrant.d/insecure_private_key",
        "user": "core"
      }
    },
    {
      "id": "0f6536a1-c232-4515-942a-c0fb56d362b2",
      "name": "vm-ssh",
      "client": "mysql",
      "host": "localhost",
      "port": 3306,
      "user": "root",
      "password": "password",
      "database": "authentication"
    }
  ]
}

Fields

resultItemsPerPage

The limit of items per page (default on sqlectron-gui: 100) The paging is not done in SQL query. Instead its is done during the results rendering.

limitQueryDefaultSelectTop

The limit used in the default query (default: 1000)

servers

Array with all servers connection.

  • id: in case including a new server manually there is no need setting an id field because SQLECTRON will do it for you
  • name
  • client: postgresql, mysql or sqlserver
  • host
  • port
  • user
  • password
  • database
  • ssh
    • host
    • user
    • port
    • privateKey
    • privateKeyWithPassphrase

Contributing

Please check out it here.

License

Copyright (c) 2015 The SQLECTRON Team. This software is licensed under the MIT License.

Current Tags

  • 8.1.1                                ...           latest (2 months ago)

44 Versions

  • 8.1.1                                ...           2 months ago
  • 8.1.0                                ...           3 months ago
  • 8.0.0                                ...           3 years ago
  • 7.10.0                                ...           3 years ago
  • 7.9.0                                ...           3 years ago
  • 7.8.1                                ...           3 years ago
  • 7.8.0                                ...           3 years ago
  • 7.7.0                                ...           4 years ago
  • 7.6.0                                ...           4 years ago
  • 7.5.1                                ...           4 years ago
  • 7.5.0                                ...           4 years ago
  • 7.3.1                                ...           4 years ago
  • 7.3.0                                ...           4 years ago
  • 7.2.0                                ...           4 years ago
  • 7.1.2                                ...           4 years ago
  • 7.1.1                                ...           4 years ago
  • 7.1.0                                ...           4 years ago
  • 7.0.0                                ...           4 years ago
  • 6.3.1                                ...           4 years ago
  • 6.3.0                                ...           4 years ago
  • 6.2.0                                ...           4 years ago
  • 6.1.1                                ...           4 years ago
  • 6.1.0                                ...           4 years ago
  • 6.0.1                                ...           4 years ago
  • 6.0.0                                ...           4 years ago
  • 5.0.0                                ...           4 years ago
  • 4.0.0                                ...           4 years ago
  • 3.6.0                                ...           4 years ago
  • 3.5.0                                ...           4 years ago
  • 3.4.0                                ...           4 years ago
  • 3.3.0                                ...           4 years ago
  • 3.2.0                                ...           4 years ago
  • 3.1.0                                ...           4 years ago
  • 3.0.0                                ...           5 years ago
  • 2.0.0                                ...           5 years ago
  • 1.4.0                                ...           5 years ago
  • 1.3.1                                ...           5 years ago
  • 1.3.0                                ...           5 years ago
  • 1.1.0                                ...           5 years ago
  • 1.0.0                                ...           5 years ago
  • 0.3.1                                ...           5 years ago
  • 0.3.0                                ...           5 years ago
  • 0.2.0                                ...           5 years ago
  • 0.1.0                                ...           5 years ago
Downloads
Today 0
This Week 0
This Month 2
Last Day 0
Last Week 2
Last Month 58
Dependencies (13)

Copyright 2014 - 2016 © taobao.org |