Doug Stevenson

Shell should not provide auth token in the URL query string

1

Currently the shell specifies the auth token as `jwt` in the database URL. This can be problematic downstream. Instead, perhaps it should be using the `AuthToken` field of the `ShellConfig`...

What the CLI should do is: - Detect when it's invoked non-interactively (not having a TTY) - Suppress all normal output (welcome message, prompts, tabular output) - Define what the...

Should shell `.dump` use a transaction?

1

sqlite3 `.dump` wraps the entire SQL output (after `PRAGMA foreign_keys=OFF;`) in `BEGIN TRANSACTION;` and `COMMIT;`. Turso's shell does not. Should it? That would defend against a partial set of statements...

Refer to https://github.com/libsql/sqld/issues/256. This issue is filed so the CLI can handle this situation correctly (by ignoring the error and outputting nothing) if there are changes to sqld to detect...

``` $ brew install turso ==> Fetching chiselstrike/tap/turso ==> Downloading https://github.com/chiselstrike/homebrew-tap/releases/download/v0.39.0/homebrew-tap_Linux_x86_64.tar.gz Already downloaded: /home/doug/.cache/Homebrew/downloads/28de2b726b0d076addf705e5b834fb77b8ecb9d0d0729eada9b157aa703a7a43--homebrew-tap_Linux_x86_64.tar.gz ==> Installing turso from chiselstrike/tap Error: The following formula cannot be installed from bottle and must...

``` $ uname -a Linux tbd 5.10.16.3-microsoft-standard-WSL2 #1 SMP Fri Apr 2 22:23:49 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux ``` ``` $ turso --version turso version v0.39.0 ``` ``` $...

There's nothing stopping people from dropping internal tables

4

I don't know if this is the right repo for this issue, apologies if this is wrong. ``` → select * from sqlite_schema; TYPE NAME TBL_NAME ROOTPAGE SQL table libsql_wasm_func_table...

Hung HTTP endpoint causes CLI shell to hang, can't recover with ctl-c, can only use ctl-\ to kill

3

Basically I expect that I can terminate the shell (or terminate the sent SQL command, staying in the shell) with ctl-c when hung on sending a command. Or in other...

CLI should automatically refresh a signed-in users token instead of requiring a new auth

3

The general expectation for CLIs that retain a signed-in status for the user is that the user stay signed in indefinitely until they explicitly sign out. Internally, this means the...

``` import LibsqlP from 'libsql-experimental/promise' ``` ``` src/both.ts:3:21 - error TS7016: Could not find a declaration file for module 'libsql-experimental/promise'. 'path/to/node_modules/libsql-experimental/promise.js' implicitly has an 'any' type. If the 'libsql-experimental' package...