Thread: New font for testing in Query Editor tool

New font for testing in Query Editor tool

From
Shirley Wang
Date:
Hello

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

Thanks!
Shirley & Pivotal Team

AW: New font for testing in Query Editor tool

From
Date:

Hello,

 

the new font looks more cleaner and is easier to read then the previous one. So I like the change. (this is of course my personal opinion)

 

Somehow the leading (distance between the lines) looks too high. So sometimes I need to look closely.

 

I will test the new build some more time tomorrow, but for now it looks much nicer.

 

Tested on Windows 7 x64 VM.

 

 

Are you planning to update the font in SQL view to?

 

 

 

The problem with tab width is still not improved, but this might be not the font’s fault.

 

pgAdmin4 v1.4

 

 

pgAdmin4 1.6 (this test build)

 

 

Notepad++ (example for correct tab width)

 

 

 

 

Von: Shirley Wang [mailto:swang@pivotal.io]
Gesendet: Dienstag, 18. Juli 2017 15:31
An: pgAdmin Support
Betreff: New font for testing in Query Editor tool

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

Re: New font for testing in Query Editor tool

From
Anthony DeBarros
Date:
I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

Anthony




Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

Re: New font for testing in Query Editor tool

From
Dave Page
Date:


On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:
I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

Yeah, something was bugging me about it too - I think it was the line height.
 

Anthony




Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: New font for testing in Query Editor tool

From
Mike Surcouf
Date:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

From
Dave Page
Date:


On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?


It does. The question is, *which* fixed width font.
 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

From
matshyeq
Date:
What are the options?

On 19 July 2017 at 10:37, Dave Page <dpage@pgadmin.org> wrote:


On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?


It does. The question is, *which* fixed width font.
 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

From
Dave Page
Date:
Monospace, which we currently use, and Menlo, the proposed new default.

On Wed, Jul 19, 2017 at 12:58 PM, matshyeq <matshyeq@gmail.com> wrote:
What are the options?

On 19 July 2017 at 10:37, Dave Page <dpage@pgadmin.org> wrote:


On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?


It does. The question is, *which* fixed width font.
 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: New font for testing in Query Editor tool

From
Mike Surcouf
Date:

Is that font available on all browsers iPad etc?

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 13:11
To: matshyeq
Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

Monospace, which we currently use, and Menlo, the proposed new default.

 

On Wed, Jul 19, 2017 at 12:58 PM, matshyeq <matshyeq@gmail.com> wrote:

What are the options?

 

On 19 July 2017 at 10:37, Dave Page <dpage@pgadmin.org> wrote:

 

 

On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?

 

It does. The question is, *which* fixed width font.

 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

From
Dave Page
Date:
Possibly not, but then it will fall back to the old one.

On Wed, Jul 19, 2017 at 1:13 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Is that font available on all browsers iPad etc?

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 13:11
To: matshyeq
Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang


Subject: Re: New font for testing in Query Editor tool

 

Monospace, which we currently use, and Menlo, the proposed new default.

 

On Wed, Jul 19, 2017 at 12:58 PM, matshyeq <matshyeq@gmail.com> wrote:

What are the options?

 

On 19 July 2017 at 10:37, Dave Page <dpage@pgadmin.org> wrote:

 

 

On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?

 

It does. The question is, *which* fixed width font.

 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

From
matshyeq
Date:
Just a thought, if v4 is web based - why don't you use webfonts, like whatever is available on https://fonts.google.com/?category=Monospace
with the option to fall back to the old ones?
Also, could this be easily configurable?

On 19 July 2017 at 14:14, Dave Page <dpage@pgadmin.org> wrote:
Possibly not, but then it will fall back to the old one.


On Wed, Jul 19, 2017 at 1:13 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Is that font available on all browsers iPad etc?

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 13:11
To: matshyeq
Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang


Subject: Re: New font for testing in Query Editor tool

 

Monospace, which we currently use, and Menlo, the proposed new default.

 

On Wed, Jul 19, 2017 at 12:58 PM, matshyeq <matshyeq@gmail.com> wrote:

What are the options?

 

On 19 July 2017 at 10:37, Dave Page <dpage@pgadmin.org> wrote:

 

 

On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Maybe I’m missing something,

 

Shouldn’t all code including SQL use fixed width font?

 

It does. The question is, *which* fixed width font.

 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 19 July 2017 09:00
To: Anthony DeBarros
Cc: pgAdmin Support; Shirley Wang
Subject: Re: New font for testing in Query Editor tool

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Anthony

 

 

 

 

Hello

 

We're testing out a new font for the SQL in the Query Editor tool. Here is a link to test builds for both windows and mac: https://developer.pgadmin.org/~dpage/query_tool_font_test/

 

Let us know what your thoughts are on these font changes along with why you think these changes need to occur. 

 

Thanks!

Shirley & Pivotal Team

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: New font for testing in Query Editor tool

From
Shirley Wang
Date:
Thanks for the feedback everyone

On Wed, Jul 19, 2017 at 8:18 AM matshyeq <matshyeq@gmail.com> wrote:
Just a thought, if v4 is web based - why don't you use webfonts, like whatever is available on https://fonts.google.com/?category=Monospace
with the option to fall back to the old ones?
Also, could this be easily configurable?

I had only ever used the hosted versions of Google fonts so I wrote off this option for cases where there is no internet connection. However it does seem like you can download them - we can potentially package the application with a Google font rather than rely on native fonts that come with the OS.


 

Monospace, which we currently use, and Menlo, the proposed new default.


Menlo only applies for Macs, Consolas is the new proposed font for Windows. 
 


 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 


Yeah, line height is a little wonky now because we're working with two fonts with different x-heights. I'm looking into Google fonts now, it would be so great if both applications could rely on the same font.


 

RE: New font for testing in Query Editor tool

From
Mike Surcouf
Date:

> Menlo only applies for Macs, Consolas is the new proposed font for Windows. 

 

How are you going to tell what OS.

Bear in mind the server version (which I find runs much better than desktop) only has the concept of a browser agent.

I think the concept of specific font on a cross platform tool is not good IMHO.

 

As long as you fall back to

 

font-family: “monospace”;

 

 

From: Shirley Wang [mailto:swang@pivotal.io]
Sent: 19 July 2017 15:10
To: matshyeq; Dave Page
Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support
Subject: Re: New font for testing in Query Editor tool

 

Thanks for the feedback everyone

On Wed, Jul 19, 2017 at 8:18 AM matshyeq <matshyeq@gmail.com> wrote:

Just a thought, if v4 is web based - why don't you use webfonts, like whatever is available on https://fonts.google.com/?category=Monospace

with the option to fall back to the old ones?
Also, could this be easily configurable?

 

I had only ever used the hosted versions of Google fonts so I wrote off this option for cases where there is no internet connection. However it does seem like you can download them - we can potentially package the application with a Google font rather than rely on native fonts that come with the OS.

 

 

 

Monospace, which we currently use, and Menlo, the proposed new default.

 

Menlo only applies for Macs, Consolas is the new proposed font for Windows. 

 

 

 

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros <adebarros@gmail.com> wrote:

I like it! I agree with the earlier poster that the line height could be decreased -- but not by much. Perhaps a pixel or two.

 

Yeah, something was bugging me about it too - I think it was the line height.

 

 

Yeah, line height is a little wonky now because we're working with two fonts with different x-heights. I'm looking into Google fonts now, it would be so great if both applications could rely on the same font.