Defaults

Set a default instance so you don’t need -i every time:

dclient default instance latest

Now commands will use latest automatically:

dclient databases
dclient tables -d fixtures

Set a default database for an alias or instance URL:

dclient default database latest fixtures
dclient default database https://latest.datasette.io fixtures

Now you can run bare SQL queries directly:

dclient "select * from facetable limit 5"

This uses the default instance and default database.

dclient default –help

Usage: dclient default [OPTIONS] COMMAND [ARGS]...

  Manage default instance and database

Options:
  --help  Show this message and exit.

Commands:
  database  Set or show the default database for an instance
  instance  Set or show the default instance

dclient default instance –help

Usage: dclient default instance [OPTIONS] [ALIAS_OR_URL]

  Set or show the default instance

  Example usage:

      dclient default instance prod
      dclient default instance https://myapp.datasette.cloud
      dclient default instance
      dclient default instance --clear

Options:
  --clear  Clear default instance
  --help   Show this message and exit.

dclient default database –help

Usage: dclient default database [OPTIONS] ALIAS_OR_URL [DB]

  Set or show the default database for an instance

  Example usage:

      dclient default database prod main
      dclient default database https://myapp.datasette.cloud main
      dclient default database prod
      dclient default database prod --clear

Options:
  --clear  Clear default database for this instance
  --help   Show this message and exit.