Prompt color, config path, favorite queries

[rodskin]

Hi, I have been using mycli for years and love it still to this day :)

Some things bugged me lately:

• is there a way to put .mycli* files to .config/mycli/ ?
• I wish I could have my favorite queries in a separate file to easily send them to an external server
• changing prompt color for my local computer / production server is a great help to avoid some mistakes but I would love to be able to add a new color when I am in a transaction or not (also to avoid mistakes)

[rolandwalker]

Hi!

is there a way to put .mycli* files to .config/mycli/ ?

Yes, though it is a bit manual. ~/.myclirc can just be moved to ~/.config/mycli/myclirc where it will be also read. For other files such as ~/.mycli-history, you will need to change the relevant values in ~/.config/mycli/myclirc to relocate them.

I wish I could have my favorite queries in a separate file to easily send them to an external server

This was addressed in #2109!

changing prompt color for my local computer / production server is a great help to avoid some mistakes but I would love to be able to add a new color when I am in a transaction or not (also to avoid mistakes)

This is a great idea! Adding it in #2233 now and will release shortly. To incorporate a color, the example image uses the prompt value \u@\h:\d\x1b[31m\b\x1b[0m>\_.