Does anyone know of any accessible SQL programs for Slint?

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Hi guys,
Subject pretty much says it all. I am looking for an accessible SQL program to use on my Slint system. Does anyone know of any options I might have?
Thanks,

Ashley Breger

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

> On May 1, 2022, at 12:11,Ashley Breger wrote:
> 
> ... I am looking for an accessible SQL program to use on my Slint system. ...

tl;dr - no real answers, but some questions and ideas...

I'm assuming that you're referring to SQL, a language for interacting with relational databases (https://en.wikipedia.org/wiki/SQL).  If not, please indicate what else you have in mind.

There are lots of databases that support SQL, though the features and syntactic details can vary a lot.  However, most of them have a command-line interface which you can use to submit SQL queries, etc.  So, they should be pretty blind-accessible, at least on the input side.

Output is another question.  Because relational databases operate on rectangular tables, they tend to use text-based formatting to delineate rows and columns.  So, for example, you might get long strings of spaces and vertical bars such as this:

|   foo |   bar |   baz |
|   123 |   456 |   789 |
|  1234 |  4567 |  7890 |

Unless you have a screen reader that can let you navigate this sort of thing, finding the relevant table cells could be pretty tedious.

Of course, with a sufficiently clever query, you can (sometimes :-) pare down the output to just a few cells.  I do something like this when writing debugging trace code, to avoid having to dig through large piles of output.

One thought I have had, from time to time, is that it would be nice to have tooling that transforms various tabular output formats into HTML tables.  This could let the user employ screen reader navigation to crawl around the table.  However, I have no idea if anything of this sort exists.

Assuming that there are some blind-accessible spreadsheet programs, you might be able to dump the tabular output into a file (e.g. CSV) and then examine it using the spreadsheet program.  Might this work for you?

- Rich Morin

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Hello, I?m not sure if this would work. I started taking a database class for college and most of the things that we do now I am unable to read unless they are copied into the notepad and pasted into a word document so I was just curious if there was anything for Linux. 

Ashley Breger

> On May 1, 2022, at 3:44 PM, Linux for blind general discussion <blinux-list at redhat.com> wrote:
> 
> ?
>> 
>> On May 1, 2022, at 12:11,Ashley Breger wrote:
>> 
>> ... I am looking for an accessible SQL program to use on my Slint system. ...
> 
> tl;dr - no real answers, but some questions and ideas...
> 
> I'm assuming that you're referring to SQL, a language for interacting with relational databases (https://en.wikipedia.org/wiki/SQL).  If not, please indicate what else you have in mind.
> 
> There are lots of databases that support SQL, though the features and syntactic details can vary a lot.  However, most of them have a command-line interface which you can use to submit SQL queries, etc.  So, they should be pretty blind-accessible, at least on the input side.
> 
> Output is another question.  Because relational databases operate on rectangular tables, they tend to use text-based formatting to delineate rows and columns.  So, for example, you might get long strings of spaces and vertical bars such as this:
> 
> |   foo |   bar |   baz |
> |   123 |   456 |   789 |
> |  1234 |  4567 |  7890 |
> 
> Unless you have a screen reader that can let you navigate this sort of thing, finding the relevant table cells could be pretty tedious.
> 
> Of course, with a sufficiently clever query, you can (sometimes :-) pare down the output to just a few cells.  I do something like this when writing debugging trace code, to avoid having to dig through large piles of output.
> 
> One thought I have had, from time to time, is that it would be nice to have tooling that transforms various tabular output formats into HTML tables.  This could let the user employ screen reader navigation to crawl around the table.  However, I have no idea if anything of this sort exists.
> 
> Assuming that there are some blind-accessible spreadsheet programs, you might be able to dump the tabular output into a file (e.g. CSV) and then examine it using the spreadsheet program.  Might this work for you?
> 
> - Rich Morin
> 
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://listman.redhat.com/mailman/listinfo/blinux-list
> 

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Tim here.  Depends on the degree of accessibility, which database
engine, and whether you're looking for a CLI, TUI, GUI, or web
interface.

All the major players (MySQL/MariaDB, PostgreSQL, and sqlite) have
command-line clients ("mysql", "psql", and "sqlite3" respectively).
Some of them have special directives to edit the current query in
your $EDITOR (such as suffixing queries with "\e" in psql) while they
should all allow you to read in an external file (such as psql's "\i
filename.sql" or sqlite's ".read filename.sql").

Most also allow you to change the output format.  Depending on the
volume of data I expect, I prefer either column-aligned output (often
the default) or line-oriented (like sqlite's `.mode line`) where each
column is on its own line, prefixed with the column-name, and each
record is separated by a blank line.

For my own use, I tend to author queries primarily in my editor, save
it, and then flip over to the CLI client and source that query to
produce the results, usually all with a tmux session (though you
could just as easily use GNU screen if that's your preference).  This
also has the advantage that the query is stored on the disk and can
thus be version-controlled with your favorite (git, svn, rcs, fossil,
whatever).

I haven't found (though haven't looked for) any sort of SQL-specific
TUI or back-end-agnostic CLI client, and I've seen some web-client
interfaces that might also be accessible, but the standard CLI tools
are readily available, accessible, and well-documented, so I tend to
stick to them.

-Tim


On May  1, 2022, Linux for blind general discussion wrote:
> Hi guys,
> Subject pretty much says it all. I am looking for an accessible SQL
> program to use on my Slint system. Does anyone know of any options
> I might have? Thanks,
> 
> Ashley Breger
> 
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://listman.redhat.com/mailman/listinfo/blinux-list
> 

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Hi Ashley,

in Slint you have mariadb (drop-in replacement of mysql, commands are named
mysql-something) and sqlite3.

Both are command line applications. You can always get the output as text files
then read it in a text editor like pluma or geany or in the command any text editor.

Cheers

Didier Spaier

Le 01/05/2022 ? 21:57, Linux for blind general discussion a ?crit?:
> Hello, I?m not sure if this would work. I started taking a database class for college and most of the things that we do now I am unable to read unless they are copied into the notepad and pasted into a word document so I was just curious if there was anything for Linux. 
> 
> Ashley Breger
> 
>> On May 1, 2022, at 3:44 PM, Linux for blind general discussion <blinux-list at redhat.com> wrote:
>>
>> ?
>>>
>>> On May 1, 2022, at 12:11,Ashley Breger wrote:
>>>
>>> ... I am looking for an accessible SQL program to use on my Slint system. ...
>>
>> tl;dr - no real answers, but some questions and ideas...
>>
>> I'm assuming that you're referring to SQL, a language for interacting with relational databases (https://en.wikipedia.org/wiki/SQL).  If not, please indicate what else you have in mind.
>>
>> There are lots of databases that support SQL, though the features and syntactic details can vary a lot.  However, most of them have a command-line interface which you can use to submit SQL queries, etc.  So, they should be pretty blind-accessible, at least on the input side.
>>
>> Output is another question.  Because relational databases operate on rectangular tables, they tend to use text-based formatting to delineate rows and columns.  So, for example, you might get long strings of spaces and vertical bars such as this:
>>
>> |   foo |   bar |   baz |
>> |   123 |   456 |   789 |
>> |  1234 |  4567 |  7890 |
>>
>> Unless you have a screen reader that can let you navigate this sort of thing, finding the relevant table cells could be pretty tedious.
>>
>> Of course, with a sufficiently clever query, you can (sometimes :-) pare down the output to just a few cells.  I do something like this when writing debugging trace code, to avoid having to dig through large piles of output.
>>
>> One thought I have had, from time to time, is that it would be nice to have tooling that transforms various tabular output formats into HTML tables.  This could let the user employ screen reader navigation to crawl around the table.  However, I have no idea if anything of this sort exists.
>>
>> Assuming that there are some blind-accessible spreadsheet programs, you might be able to dump the tabular output into a file (e.g. CSV) and then examine it using the spreadsheet program.  Might this work for you?
>>
>> - Rich Morin
>>
>> _______________________________________________
>> Blinux-list mailing list
>> Blinux-list at redhat.com
>> https://listman.redhat.com/mailman/listinfo/blinux-list
>>
> 
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://listman.redhat.com/mailman/listinfo/blinux-list

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Tim here.  I know that at least sqlite's CLI interface lets you use

  .mode line

which turns data into a linear format that's much more understandable
when read aloud, data like

  sqlite> .mode line
  sqlite> select id, name from users;

  Id = 1
  Name = Tim

  Id = 2
  Name = Rich

  Id = 3
  Name = Ellen

PostgreSQL has a similar "expanded" format.

I find it particularly useful when there are lots of columns and
things start wrapping weirdly, making it hard to trace which column
is which.

If you really *do* want HTML output, the sqlite ".mode" command does
also offer HTML output as an option:

  sqlite> .mode html

which you can then pipe to your favorite HTML viewer.  Similarly,
PostgreSQL's "psql" client has an HTML output mode which you can
invoke either as a CLI option

  $ psql --html

or by enabling the option interactively

  (psql) \pset format html

Hopefully this gives you some options for getting more useful output
from sqlite or postgresql.  I don't use mysql/mariadb much, so I can't
speak as to whether it offers similar features.

-Tim


> One thought I have had, from time to time, is that it would be nice
> to have tooling that transforms various tabular output formats into
> HTML tables.  This could let the user employ screen reader
> navigation to crawl around the table.  However, I have no idea if
> anything of this sort exists.

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Hi,
To get the mysql client to print the output in vertical format, put the 
--vertical option on the command line.
By the way, I think the windows version of the mysql client should also be 
accessible, although I never use windows.
Perhaps you should give an example of the kind of stuff you cannot read 
nicely.
HTH, Willem


On Sun, 1 May 2022, Linux for blind general discussion wrote:

> Hello, I?m not sure if this would work. I started taking a database class for college and most of the things that we do now I am unable to read unless they are copied into the notepad and pasted into a word document so I was just curious if there was anything for Linux. 
>
> Ashley Breger
>
>> On May 1, 2022, at 3:44 PM, Linux for blind general discussion <blinux-list at redhat.com> wrote:
>> 
>> ?
>>> 
>>> On May 1, 2022, at 12:11,Ashley Breger wrote:
>>> 
>>> ... I am looking for an accessible SQL program to use on my Slint system. ...
>> 
>> tl;dr - no real answers, but some questions and ideas...
>> 
>> I'm assuming that you're referring to SQL, a language for interacting with relational databases (https://en.wikipedia.org/wiki/SQL).  If not, please indicate what else you have in mind.
>> 
>> There are lots of databases that support SQL, though the features and syntactic details can vary a lot.  However, most of them have a command-line interface which you can use to submit SQL queries, etc.  So, they should be pretty blind-accessible, at least on the input side.
>> 
>> Output is another question.  Because relational databases operate on rectangular tables, they tend to use text-based formatting to delineate rows and columns.  So, for example, you might get long strings of spaces and vertical bars such as this:
>> 
>> |   foo |   bar |   baz |
>> |   123 |   456 |   789 |
>> |  1234 |  4567 |  7890 |
>> 
>> Unless you have a screen reader that can let you navigate this sort of thing, finding the relevant table cells could be pretty tedious.
>> 
>> Of course, with a sufficiently clever query, you can (sometimes :-) pare down the output to just a few cells.  I do something like this when writing debugging trace code, to avoid having to dig through large piles of output.
>> 
>> One thought I have had, from time to time, is that it would be nice to have tooling that transforms various tabular output formats into HTML tables.  This could let the user employ screen reader navigation to crawl around the table.  However, I have no idea if anything of this sort exists.
>> 
>> Assuming that there are some blind-accessible spreadsheet programs, you might be able to dump the tabular output into a file (e.g. CSV) and then examine it using the spreadsheet program.  Might this work for you?
>> 
>> - Rich Morin
>> 
>> _______________________________________________
>> Blinux-list mailing list
>> Blinux-list at redhat.com
>> https://listman.redhat.com/mailman/listinfo/blinux-list
>> 
>
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://listman.redhat.com/mailman/listinfo/blinux-list

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

For the HTML output, am I correct that she could have that HTML output to a file?  That way, she could open the file in a browser like Firefox?  That way, I would think she would be able to read the HTML tables with Orca.
Ryan


Sent from my iPhone

> On May 1, 2022, at 4:47 PM, Linux for blind general discussion <blinux-list at redhat.com> wrote:
> 
> ?Tim here.  I know that at least sqlite's CLI interface lets you use
> 
>  .mode line
> 
> which turns data into a linear format that's much more understandable
> when read aloud, data like
> 
>  sqlite> .mode line
>  sqlite> select id, name from users;
> 
>  Id = 1
>  Name = Tim
> 
>  Id = 2
>  Name = Rich
> 
>  Id = 3
>  Name = Ellen
> 
> PostgreSQL has a similar "expanded" format.
> 
> I find it particularly useful when there are lots of columns and
> things start wrapping weirdly, making it hard to trace which column
> is which.
> 
> If you really *do* want HTML output, the sqlite ".mode" command does
> also offer HTML output as an option:
> 
>  sqlite> .mode html
> 
> which you can then pipe to your favorite HTML viewer.  Similarly,
> PostgreSQL's "psql" client has an HTML output mode which you can
> invoke either as a CLI option
> 
>  $ psql --html
> 
> or by enabling the option interactively
> 
>  (psql) \pset format html
> 
> Hopefully this gives you some options for getting more useful output
> from sqlite or postgresql.  I don't use mysql/mariadb much, so I can't
> speak as to whether it offers similar features.
> 
> -Tim
> 
> 
>> One thought I have had, from time to time, is that it would be nice
>> to have tooling that transforms various tabular output formats into
>> HTML tables.  This could let the user employ screen reader
>> navigation to crawl around the table.  However, I have no idea if
>> anything of this sort exists.
> 
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://listman.redhat.com/mailman/listinfo/blinux-list
> 

Does anyone know of any accessible SQL programs for Slint?

[blinux-list]

Tim here.  Yep, output defaults to the screen (well, standard-out),
but each should have options for redirecting output to a file during
an interactive session, and you can then open that resulting file in
your favorite browser to navigate the tables in your preferred way.

-Tim

On May  2, 2022, Linux for blind general discussion wrote:
> For the HTML output, am I correct that she could have that HTML
> output to a file?  That way, she could open the file in a browser
> like Firefox?  That way, I would think she would be able to read
> the HTML tables with Orca. Ryan
> 
> 
> Sent from my iPhone
> 
> > On May 1, 2022, at 4:47 PM, Linux for blind general discussion
> > <blinux-list at redhat.com> wrote:
> > 
> > ?Tim here.  I know that at least sqlite's CLI interface lets you
> > use
> > 
> >  .mode line
> > 
> > which turns data into a linear format that's much more
> > understandable when read aloud, data like
> >   
> >  sqlite> .mode line
> >  sqlite> select id, name from users;  
> > 
> >  Id = 1
> >  Name = Tim
> > 
> >  Id = 2
> >  Name = Rich
> > 
> >  Id = 3
> >  Name = Ellen
> > 
> > PostgreSQL has a similar "expanded" format.
> > 
> > I find it particularly useful when there are lots of columns and
> > things start wrapping weirdly, making it hard to trace which
> > column is which.
> > 
> > If you really *do* want HTML output, the sqlite ".mode" command
> > does also offer HTML output as an option:
> >   
> >  sqlite> .mode html  
> > 
> > which you can then pipe to your favorite HTML viewer.  Similarly,
> > PostgreSQL's "psql" client has an HTML output mode which you can
> > invoke either as a CLI option
> > 
> >  $ psql --html
> > 
> > or by enabling the option interactively
> > 
> >  (psql) \pset format html
> > 
> > Hopefully this gives you some options for getting more useful
> > output from sqlite or postgresql.  I don't use mysql/mariadb
> > much, so I can't speak as to whether it offers similar features.
> > 
> > -Tim
> > 
> >   
> >> One thought I have had, from time to time, is that it would be
> >> nice to have tooling that transforms various tabular output
> >> formats into HTML tables.  This could let the user employ screen
> >> reader navigation to crawl around the table.  However, I have no
> >> idea if anything of this sort exists.  
> > 
> > _______________________________________________
> > Blinux-list mailing list
> > Blinux-list at redhat.com
> > https://listman.redhat.com/mailman/listinfo/blinux-list
> >   
> 
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://listman.redhat.com/mailman/listinfo/blinux-list