Please add/edit doc's re installing and running and add more support for mysql data types

[drhuffman12]

(I got some errors when attempting to install queryit with Crystal 1.1.1 and connecting to mysql databases. In particular, this was on a fairly fresh install of Linux Mint 20.2 Mate; so I added notes below for what I had to install; but am having some issues with mysql db data.)

Installation Dependencies

I think you might want to note some dependencies in either https://github.com/hugopl/queryit and/or in https://github.com/hugopl/textui/ . In my local clone of the queryit repo, I found the following were needed for my OS (Linux Mint):

• python (python3 worked for me as symlinked somewhere in my PATH and the symlink (re-)named to just python)
• libyaml (and possibly others noted in https://crystal-lang.org/install/on_linux_mint/ under The following packages are not required, but recommended for using the respective features in the standard library:)
• libevent-dev (or as however the development package is named in your distro)
• libsqlite3-dev (or as however the development package is named in your distro)
• an applicable rails or amber database configuration (otherwise you get Could not find rails or amber database configuration.)

per Database Dependencies

• mysql-client (if/for connections to mysql db's)

per Rails database.yml settings for adapter (TBD; see errors noted in #2)

Connecting to database

via --uri option

• Mysql The uri is defined my mysql at: https://dev.mysql.com/doc/dev/mysqlsh-api-python/8.0/connection_data.html as [scheme://][user[:password]@]<host[:port]|socket>[/schema][?option=value&option=value...]

Moved more mysql support comments to separate issue: https://github.com/hugopl/queryit/issues/2

[hugopl]

I pushed recent patches that solve few things but not yet the better mysql support:

https://github.com/hugopl/queryit/commit/d7c705c816341fe0590daab145a03ce9ca3a5159 Updates the readme with dependencies. https://github.com/hugopl/queryit/commit/01cb88d8068cde404c778b9e48fc14086105cf45 Fix the problem with mysql2 adapter and probably others. https://github.com/hugopl/queryit/commit/d6f4d3e84840c6620e58246521265fd4b938c2d5 Don't mess with terminal when an database connection error happen.

I'll see if I remove the mouse support, since it blocks text selection with mouse, then I can release a new version with this... and maybe with more :heart: to MySQL if I find time to install it and do at least some basic tests.

I'll leave the issue open, since the MySQL issues still there.

Thanks for reporting.

[drhuffman12]

Thanks @hugopl ! I probably should have split this issue for docs vs mysql support; see https://github.com/hugopl/queryit/issues/2. I look forward to you noted updates.