Theme support

ansgar's profile image ansgar posted 5 years ago in News Permalink

The latest nightly builds of HeidiSQL have support for themes, and some quite nice themes included.

image description

If you'd like to have a dark theme for example, feel free to update to the latest build. After starting HeidiSQL, you can select a theme under Tools > Preferences > General. For fitting colors in the SQL editors, there are two new color presets - one for dark themes, and the old default preset for light themes.

Enjoy!

[expired user #11385]'s profile image [expired user #11385] posted 5 years ago Permalink

This is fantastic! Been waiting for this for years now!

I'm running this on Ubuntu 18.10 with Wine, and the dark themes look quite nice.

I hope we'll have better support for theming in the future, and maybe a native linux application.

Thanks for the update :)

yucikala's profile image yucikala posted 5 years ago Permalink

Super. On win 7 I have a troubl in dark theme. After a while (I use MSSQL and MySql active connection) Heidy freeze. See attachemnt. Only restart (kill processs) Heidi help.

1 attachment(s):
  • heidy
ansgar's profile image ansgar posted 5 years ago Permalink

Is that freezing reproducible, so it happened more than once?

yucikala's profile image yucikala posted 5 years ago Permalink

Yes. I dont know what to do, what ever when I work for an hour or half hour, it is. It looks like suddenty some parts of app are at "standard" them and some not. If you know, where the button is, you can work.You only not see an text at buttons and menu. And headers at grid are mismashed...

ansgar's profile image ansgar posted 5 years ago Permalink

Could you also watch out whether heidisql.exe consumes much more memory than usual, via task manager?

yucikala's profile image yucikala posted 5 years ago Permalink

No. Only I can see, that after that you can use buttons, not icons (100% delete row icon) or close. I have always data window opened with data.

yucikala's profile image yucikala posted 5 years ago Permalink

With window theme is all ok.

daugaard47's profile image daugaard47 posted 5 years ago Permalink

Love the new theme option! What is the name of the theme you are using in your post at the top of this thread? Thanks!

yucikala's profile image yucikala posted 5 years ago Permalink

Windows10 Dark

ansgar's profile image ansgar posted 5 years ago Permalink

That was the "Carbon" theme.

yucikala's profile image yucikala posted 5 years ago Permalink

Yes - the dark theme. What ever very often this theme freeze... (see attachment above)

[expired user #11917]'s profile image [expired user #11917] posted 5 years ago Permalink

Thanks so much! I've been waiting and hoping for theme support to help with eye strain. Beautiful!

yucikala's profile image yucikala posted 5 years ago Permalink

Windows10 SlateGray - table size is not readable - see attachment

1 attachment(s):
  • obr-zek-5
yucikala's profile image yucikala posted 5 years ago Permalink

the same - see attachment. Windows 10 Dark.

1 attachment(s):
  • obr-zek-6
ansgar's profile image ansgar posted 5 years ago Permalink

You can select a different color for these otherwise green bars, in Tools > Preferences > General.

I should probably use clInfoBk as a default color here, which is then theme dependent. But as soon as the user sets a different color for the bars, he's alone responsible for such issues.

Code modification/commit c1f9c18 from Ansgar Becker <anse@heidisql.com>, 5 years ago, revision 5358
Issue #8: Remove color selection for inline progress bars in grid cells, and make that color theme compatible. See https://www.heidisql.com/forum.php?t=25952#p26136
ansgar's profile image ansgar posted 5 years ago Permalink

The next nightly build uses a variation of the cell color, just a bit darker. This should make it compatible to all themes.

Charlie's profile image Charlie posted 5 years ago Permalink

Is it included in portable version ? I can't find it ?

ansgar's profile image ansgar posted 5 years ago Permalink

The portable version on the download page is from the official last release, so it doesn't yet have themes. But you can use the auto-updater in Help > Check for updates to get it.

Charlie's profile image Charlie posted 5 years ago Permalink

Amazing, thanks!

just a little thing, how can I change font color in left bar, in size text ?

1 attachment(s):
  • Annotation-2018-12-12-091739
ansgar's profile image ansgar posted 5 years ago Permalink

You can't - this is yet hardcoded in HeidiSQL. I should change this to leave it at the default color, or?

Code modification/commit 4f3390d from Ansgar Becker <anse@heidisql.com>, 5 years ago, revision 5399
Dim text in database tree using the system color clGray instead of a hardcoded one, so it hopefully gets theme compatible. See https://www.heidisql.com/forum.php?t=25952#p26172
ansgar's profile image ansgar posted 5 years ago Permalink

Just changed that hardcoded color into the system/theme color for dimmed text. Hopefully compatible / readable on dark themes.

Charlie's profile image Charlie posted 5 years ago Permalink

Awesome ! Just a last thing, the auto increment label is dark blue and doesn't seem to be customizable...

1 attachment(s):
  • Annotation-2018-12-18-121748
Code modification/commit f24d524 from Ansgar Becker <anse@heidisql.com>, 5 years ago, revision 5409
Use text color of integer data type for AUTO_INCREMENT flag in table editor. See https://www.heidisql.com/forum.php?t=25952#p26223
ansgar's profile image ansgar posted 5 years ago Permalink

I just changed that, so this flag uses the INTEGER type color, which is customizable.

Also, I am trying to find a reasonable approach to switch between light and dark data type colors after switching between a dark and a light theme. I have no idea how to make these color selecting less annoying to the user.

Charlie's profile image Charlie posted 5 years ago Permalink

Why don't you force colors to change with the theme ? You could include text colors inside themes, and/or offer the possibility to switch between text colors themes.

Maybe you could use some popular themes here : http://color-themes.com

For example, I personnaly love Material Theme here: http://color-themes.com/?view=theme&id=5746be34333ecc1800c39714

Material Theme colors are:

C3CEE3

263238

C792EA

FFCB6B

CAD3DE

F77669

80CBC4

C3E887

FF5370

546E7A

82B1FF

798194

92BDEC

6DC2B8

505C63

I found these colors with this nice tool: https://dotcolors.co/

Charlie's profile image Charlie posted 5 years ago Permalink

Sorry for big headings, I didn't expect markdown and it seems I can't edit my post... Better like this:

#C3CEE3

#263238

#C792EA

#FFCB6B

#CAD3DE

#F77669

#80CBC4

#C3E887

#FF5370

#546E7A

#82B1FF

#798194

#92BDEC

#6DC2B8

#505C63

ansgar's profile image ansgar posted 5 years ago Permalink

Ideas for theme text colors can go to issue #425

ansgar's profile image ansgar posted 5 years ago Permalink

Thanks to Charlie for the "Material" theme!

1 attachment(s):
  • theme-material
adhayward's profile image adhayward posted 5 years ago Permalink

Any chance of getting a Theme Preview of some sort? Even if it is just a webpage with screenshots showing each theme it would be very helpful.

I understand the need to restart after picking one but when you're trying to choose a theme you like it can be very time consuming. A screenshot for each theme would make it so much easier to determine what themes you'd like to try.

yucikala's profile image yucikala posted 5 years ago Permalink

Any chance of getting a Theme Preview of some sort? Even if it is just a webpage with screenshots showing each theme it would be very helpful.

I understand the need to restart after picking one but when you're trying to choose a theme you like it can be very time consuming. A screenshot for each theme would make it so much easier to determine what themes you'd like to try.

Thats right!

ansgar's profile image ansgar posted 5 years ago Permalink

Yes, I suppose a preview image or something makes sense. Please file an issue in the bugtracker.

adhayward's profile image adhayward posted 5 years ago Permalink

Added, it won't let me link to it but it's issue 513.

jan's profile image jan posted 5 years ago Permalink

please add an theme for touchscreen: small fonts but larger buttons und clickable areas.

[expired user #12125]'s profile image [expired user #12125] posted 5 years ago Permalink

Unfortunately, my Material Theme is looking like the image attached. There's a way to change the sidebar color? Thanks!

1 attachment(s):
  • Screenshot_108
ansgar's profile image ansgar posted 5 years ago Permalink

Go to File > "Select session background color", and change that color from white to some darker color.

A future version of Heidi will allow to "remove" that color, so it's transparent, always using the default background color. Currently, once that color is set, you cannot remove it, which potentially makes it look ugly after selecting a different theme.

mtjmohr's profile image mtjmohr posted 5 years ago Permalink

Hello, Ansgar,

using version 10.1.0.5550, there is no longer an option to go to File > "Select session background color", and change that color from white to some darker color.

I still have the same problem now again although version 10.0 had included this color changing element for the current session background color.

The "Material" background is very nice, but the left side with the database and table display, e. g. in white, is a heavy contrast for your eyes plus it makes this list illegible.

How can that be tweaked with version 10.1.0.5550?

Best regard

Markus

ansgar's profile image ansgar posted 5 years ago Permalink

The background color setting is still there, it just has moved to where it should be: in the session manager.

1 attachment(s):
  • session-background-setting
Charlie's profile image Charlie posted 5 years ago Permalink

If you can't go back to original session background, and want it the same color as material theme background color, here are the color codes you need to set:

HEX => #263238

RGB => rgb(38, 50, 56)

HSL => hsl(200, 19%, 18%)

mtjmohr's profile image mtjmohr posted 5 years ago Permalink

Hello, Ansgar,

thank you, I saw this, but only after expanding the default vertical display size - fine, it works.

@Charlie: thank you very much for your help.

Best regards

Markus

kapitannwel's profile image kapitannwel posted 5 years ago Permalink

please see attachment, a vertical and horizontal scroll bars appear after i run a query. I just populate an '@' character for the scroll bars to become more visible. I am using "Charcoal Dark Slate" theme.

1 attachment(s):
  • HEIDISQL
Enissay's profile image Enissay posted 4 years ago Permalink

I want to set back the default theme but I forgot the name, can someone remind please ? ^_^"

ansgar's profile image ansgar posted 4 years ago Permalink

"Windows" is the default theme :)

Enissay's profile image Enissay posted 4 years ago Permalink

"Windows" is the default theme :)

Thanks, maybe tag it as such in future releases &lt;3

Please login to leave a reply, or register at first.