logoalt Hacker News

no_news_isyesterday at 3:18 AM3 repliesview on HN

Very nice, works well.

It seems you put some menu items behind what I'll call "[space] mode," where you you have to press the spacebar first to open the command menu, then use the command.

This is not reflected properly in the help text shown when you press ? and that was a source of confusion for me.

Especially since I managed to activate the fullscreen mode for one pane AND turn it off, but then couldn't figure out how I did it; and also, I did not find the space-Q option to Quit at first.)

Edit to add, I prefer installing with pipx.

These commands worked for me, to get Postgresql and MariaDB database plugins:

  pipx install sqlit-tui
  cd ~/.local/pipx/venvs/sqlit-tui
  source bin/activate
  bin/python3 -m pip install psycopg2
  sudo apt-get install -y libmariadb-dev  # On Debian
  bin/python3 -m pip install mariadb
I didn't try installing system-wide as per the GitHub instructions, I don't know if that would have worked just as well with pipx or not.

Replies

MaxTeabagtoday at 7:47 PM

Great UX feedback, that's going to be sorted out in the next release.

Also the pipx comment made me decide to put much more thought into how sqlit helps with package installation on runtime, and I'm going to suggest pipx by default and it's also going to give the correct commands for every popular package manager.

Thanks!

zahlmanyesterday at 9:27 PM

> These commands worked for me, to get Postgresql and MariaDB database plugins:

I haven't tried this, but I'm familiar with pipx. It provides a higher-level interface, so something like this should work:

  pipx install sqlit-tui
  sudo apt-get install -y libmariadb-dev
  pipx inject sqlit-tui psycopg2 mariadb
Ref.: https://pipx.pypa.io/stable/#inject-a-package

> I don't know if that would have worked just as well with pipx or not.

I don't actually see anything in the GitHub instructions about system-wide installation? But yes, since version 1.5 (https://pipx.pypa.io/stable/changelog/#150-2024-03-29) Pipx can do a `--global` install that by default puts the managed venv in /opt and executable symlink in /usr/local/bin.

oulipo2today at 9:33 AM

Using uv you can do

uvx --with psycopg2-binary --from sqlit-tui sqlit