|
From: Alarcón V. <vla...@ya...> - 2019-03-08 16:20:27
|
Well, I'll have some time next week to work on this. It seems I can code it myself. Shouldn't be a great amount of work. But first: is there any interest on this? Second, if there's interest, can someone: * Give me access to the source code repository. * Point me into the right direction where to intervene the code (which package or classes should I touch). * Tell me how to build Squirrel, so I can test it? Thank you, Vlad f there's interest on it, can you -------------------------------------------- On Thu, 2/21/19, Alarcón Vladimir via Squirrel-sql-develop <squ...@li...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Mateus Stock" <ms...@sp...>, squ...@li... Date: Thursday, February 21, 2019, 4:31 PM I was thinking about what features of the library can be of use for Squirrel SQL Client. The features I clearly see can help are: * Automatic width of the cells: no need to compute cell sizes; just add them to the table. Can also be set to min/max width range (with cropping styles). * Column separation: by default we can use one or two spaces, but could be any other char(s). * Column title underlining: uses dashes by default but can use any other char, even Unicode if supported by GUI. * Left, center, and right cell alignment. Maybe by default VARCHARs should be left aligned, NUMBERs right aligned, DATEs centered? Just a thought. Other library features that I don't see as very useful for Squirrel, but worth mentioning: * Custom and predefined styles for top, left, right, bottom borders. Probably Squirrel prefers minimalistic display without borders. * Implements colspan, so a cell can span few columns. Don't see any use case for this in Squirrel. * Streaming tables for large number of rows. Not sure Squirrel would ever display massive number of rows. Well, that's what I think of off the top of my head. Vlad -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:42 PM Yeah it stripped all the formatting. Not sure if my picture was sent either. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 2:33 PM Alarcón Vladimir <vla...@ya...> wrote: Yes, I was thinking in monospace font (as in the tab). My email client must have removed the formatting. -------------------------------------------- On Thu, 2/21/19, Mateus Stock <ms...@sp...> wrote: Subject: Re: [Squirrel-sql-develop] Improving Result as Text tab To: "Alarcón Vladimir" <vla...@ya...> Cc: squ...@li... Date: Thursday, February 21, 2019, 2:23 PM I would send that as a screenshot or with monospace font. Your suggestion does look better, but just looking at the email it seems to be worse: Original message: I would prefer the first option. Your suggestion: I would prefer your suggestion. Mateus Stock "With great power comes great responsibility." - Voltaire Mateus Stock IT Manager +1 813 649 2140 Speedling Incorporated On Thu, Feb 21, 2019 at 1:44 PM Alarcón Vladimir via Squirrel-sql-develop <squ...@li...> wrote: Hi, I wanted to explore the possibility of improving the "Result as Text" tab. IMHO as it is now its format is lacking quite a bit. A few years back I developed a library here at source forge called "Java Text Table Formatter" (https://sourceforge.net/projects/texttablefmt/) that could be put to good use. For example, the query: select id, name, type from account; Nowadays shows something like: id name type ----------------------------------------------------------------------------- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK With the new library, it could show something like: id name type ------- ------- ---- 1234001 CHK1004 CHK 1234004 SAV7018 SAV 1234005 CHK2301 CHK I don't know how to articulate this change or how to find out if there's interest for it. Is this the right email subscription? Thanks, Vlad _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. Confidentiality Caution: This email, including any attachment, is confidential and may contain privileged information, that is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately by reply email and then delete this message from your system. Any views or opinions presented are solely those of the author and do not necessarily represent those of Speedling Incorporated. Although this email and any attachments are believed to be free of any virus or other defects which might affect any computer or IT system into which they are received, no responsibility is accepted by Speedling Incorporated or any of its associated companies for any loss or damage arising in any way from the receipt or use thereof. _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop |
