Skip to content

Instantly share code, notes, and snippets.

@joaodrp
Created April 14, 2018 20:48
Show Gist options
  • Save joaodrp/f2ba9fb114aeef58a50dae12366095e9 to your computer and use it in GitHub Desktop.
Save joaodrp/f2ba9fb114aeef58a50dae12366095e9 to your computer and use it in GitHub Desktop.
$ rqlite
127.0.0.1:4001> .help
.help Show this message
.indexes Show names of all indexes
.schema Show CREATE statements for all tables
.status Show status and diagnostic information for connected node
.expvar Show expvar (Go runtime) information for connected node
.tables List names of tables
.timer on|off Turn SQL timer on or off
127.0.0.1:4001> SELECT * FROM foo
+----+-------+
| id | name |
+----+-------+
| 1 | fiona |
+----+-------+
127.0.0.1:4001> .timer on
127.0.0.1:4001> SELECT * FROM foo
+----+-------+
| id | name |
+----+-------+
| 1 | fiona |
+----+-------+
Run Time: 0.00006418
127.0.0.1:4001> .timer off
127.0.0.1:4001> SELECT * FROM foo
+----+-------+
| id | name |
+----+-------+
| 1 | fiona |
+----+-------+
127.0.0.1:4001>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment