I've built a similar app but for desktop GUI. The UI is very similar to this app because I like TUI style UI due to the efficient use of UI space.
It focuses more on editing and exploring data for power users. UI space is utilized well. Exploring millions of rows is a breeze. Writing SQLs and managing them is pleasant with the multi-tab approach.
I'm working through adding the shortcuts and modal mode. I want to make it more like vim where you just use shortcuts to do things.
This looks awesome! Is there a way to log in some way that doesn't leave your credentials saved in a text file or your bash history? I would use this at work, but I think my sysadmin would eat me alive if I was storing the login credentials in plaintext
I was surprised to find that I could not run it with uvx:
% uvx sqlit
Built unicodecsv==0.14.1
Built sqlit==0.1.6
Installed 2 packages in 1ms
Traceback (most recent call last):
File "/Users/john/.cache/uv/archive-v0/AP7XgAQ1v0HpPxXUi-hs4/bin/sqlit", line 7, in <module>
from sqlit.main import main
File "/Users/john/.cache/uv/archive-v0/AP7XgAQ1v0HpPxXUi-hs4/lib/python3.12/site-packages/sqlit/main.py", line 125
print sql
^^^^^^^^^
SyntaxError: Missing parentheses in call to 'print'. Did you mean print(...)?
One of the feedback i have heard from people using SSMS is that it has all the admin operations available in the UI as compared to doing it yourself. Lot of admins i deal with day to day do not want to use the terminal or sqlcmd.
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:
> 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.
It focuses more on editing and exploring data for power users. UI space is utilized well. Exploring millions of rows is a breeze. Writing SQLs and managing them is pleasant with the multi-tab approach.
I'm working through adding the shortcuts and modal mode. I want to make it more like vim where you just use shortcuts to do things.
It supports postgres, click house, and sqlite
I'm looking for early beta users. If you are interested in a GUI version, here: https://github.com/tanin47/backdoor
I'm wondering if thats true.
SSMS is super duper nice if you’re an admin or a power SQL server user/dev. Nothing I’ve seen in Postgres world is comparable.
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:
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.I haven't tried this, but I'm familiar with pipx. It provides a higher-level interface, so something like this should work:
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.
First error: "Connection failed, no module named 'psycopg2'"
Not sure if this is what is being used here though.