SQL CLI MySQL Driver
An SQLite Driver for the SQL CLI package!
Lets you connect to SQLite Databases using the SQL CLI. This can be installed globally (allowing you to use it everywhere) or locally (to be used within a specific package).
Install
$ npm install [-g] sqlclid-sqlite
For most use cases, you'll want to install this globally so you can take full advantage of sqlcli anywhere on your computer, however, you can also save it to your dev dependencies to make sure your colleagues are on the same page when inspecting the DB.
$ npm install --save-dev sqlcli-repl sqlclid-sqlite
Usage
Open a connection using a URI or through args
$ sqlcli sqlite:///:memory:
OR
$ sqlcli -d sqlite -b :memory:
Find out more help using sqlcli --help
Execute typical SQL queries:
user@localhost> SELECT 1 AS `One`, 2 AS `Two`;
|-----|-----|
| One | Two |
|-----|-----|
| 1 | 2 |
|-----|-----|
Execute multi-line SQL queries:
user@localhost> SELECT
... 3 AS `Three`,
... 4 AS `Four`
... ;
|-------|------|
| Three | Four |
|-------|------|
| 3 | 4 |
|-------|------|
Execute JS on results:
user@localhost> SELECT 1 AS `One`, 2 AS `Two`;sh
user@localhost> >$0
[
{
"One": 1,
"Two": 2
}
]
More Info
Find out more info at the SQL CLI repo!
License
MIT