Nushell missing command

[Marvin-LOUIS]

I've switched to Nushell as my primary shell and wanted to make a script taking advantage of the built-in db command allowing the user to query sqlite databases as nushell data. It's a feature available since the 0.62 release, however the command seems unavailable in the Termux package (version 0.65) and returns a command not found.

As stated it's supposed to be a built-in command and is available by default in the other platform I use Nushell in. I was wondering if perhaps this would be due to the package build process, a limitation on ARM based system or even a weird bug on my system. Do you guys have the same issue? If so any idea what the root cause might be?

[sylirre]

Should be fixed by 094648a. Run pkg upgrade.

However I don't think there is a command named exactly db. It is not available even in the official latest binaries, not only Termux. But there other commands for database.

│   6 │ and                      │ database               │ false     │ false     │ false      │ Includes an AND clause for a query          │ database, where                             │
│   7 │ and                      │ db-expression          │ false     │ false     │ false      │ Includes an AND clause for an expression    │ database, and, expression                   │
│  19 │ as                       │ database               │ false     │ false     │ false      │ Creates an alias for a column selection     │ database, alias, column                     │
│  21 │ as                       │ db-expression          │ false     │ false     │ false      │ Creates an alias for a column selection     │ database, alias, column                     │
│  35 │ collect                  │ database               │ false     │ false     │ false      │ Collects a query from a database database   │ database, collect                           │
│  67 │ describe                 │ database               │ false     │ false     │ false      │ Describes connection and query of the DB    │ database, SQLite, describe                  │
│ 103 │ field                    │ db-expression          │ false     │ false     │ false      │ Creates column expression for database      │ database, column, expression                │
│ 114 │ fn                       │ db-expression          │ false     │ false     │ false      │ Creates function expression for a select    │ database, function, expression              │
│ 118 │ from                     │ database               │ false     │ false     │ false      │ Select section from query statement for a   │ database, from                              │
│ 157 │ group-by                 │ database               │ false     │ false     │ false      │ Group by query                              │ database, select                            │
│ 175 │ into db                  │ database               │ false     │ false     │ false      │ Converts into an open db connection         │ database, into, db                          │
│ 195 │ join                     │ database               │ false     │ false     │ false      │ Joins with another table or derived table.  │ database, join                              │
│ 210 │ limit                    │ database               │ false     │ false     │ false      │ Limit result from query                     │ database, limit                             │
│ 257 │ open-db                  │ database               │ false     │ false     │ false      │ Open a database                             │ database, open                              │
│ 259 │ or                       │ db-expression          │ false     │ false     │ false      │ Includes an OR clause for an expression     │ database, or, expression                    │
│ 260 │ or                       │ database               │ false     │ false     │ false      │ Includes an OR clause for a query           │ database, where                             │
│ 261 │ order-by                 │ database               │ false     │ false     │ false      │ Orders by query                             │ database, order-by                          │
│ 263 │ over                     │ db-expression          │ false     │ false     │ false      │ Adds a partition to an expression function  │ database, over, expression                  │
│ 290 │ query                    │ database               │ false     │ false     │ false      │ Query a database using SQL.                 │ database, SQLite                            │
│ 319 │ schema                   │ database               │ false     │ false     │ false      │ Show sqlite database information, including │ database, info, SQLite, schema              │
│ 321 │ select                   │ database               │ false     │ false     │ false      │ Creates a select statement for a DB         │ database, select                            │
│ 387 │ testing-db               │ database               │ false     │ false     │ false      │ Temporal Command: Create query object       │ database, SQLite                            │
│ 426 │ where                    │ database               │ false     │ false     │ false      │ Includes a where statement for a query      │ database, where                             │

[sylirre]

Yes, looks like since 0.65 there are "simplified" db commands: https://www.nushell.sh/blog/2022-07-05-nushell-0_65.html#unification-continues-elferherrera

See this pull request: nushell/nushell#5838

[Marvin-LOUIS]

Indeed it works with the ˋopenˋ command now, thanks a lot. My other system is still on ˋ0.64ˋ which might have caused the confusion.