Config file with profiles and a setup prompt

[tconbeer]

Theme, extensions

Profiles, especially when we support multiple connection types.

Also startup scripts like #241

Also I want a CLI to walk me through setup. The file will be TOML but there should be a command to create a profile. It could be aware of the available plugins and the config each needs.

[tconbeer]

https://github.com/petereon/beaupy is based on Rich, which is nice.

harlequin config, etc.

update: it actually pins an old version of rich (<13), and isn't currently compatible. maintenance doesn't look great.

[tconbeer]

Questionary also looks good and lightweight deps wise.

[tconbeer]

default_profile = "my-duckdb-profile"

[profiles.my-duckdb-profile]
theme = "monokai"
limit = 100_000
adapter = "duckdb"
connections = [":memory:"]

[profiles.my-duckdb-profile.adapter_options]
read_only = false
allow_unsigned_extensions = false
extension = ["httpfs", "spatial"]
force_install_extensions = false
md_saas = false
init_path = "~/.duckdbrc"

[profiles.local-postgres]
theme = "fruity"
limit = 1_000
adapter = "postgres"
connections = []

[profiles.local-postgres.adapter_options]
host = "localhost"
user = "postgres"
password = "secretadminpassword"
database = "postgres"
port = 5432
init_path = "~/.psqlrc"