6 comments

  • debarshri1 hour ago
    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.<p>I&#x27;m wondering if thats true.
    • baq1 hour ago
      Admins don’t ever close the tool, it’s always open on some RDP. Devs have different usage patterns.<p>SSMS is super duper nice if you’re an admin or a power SQL server user&#x2F;dev. Nothing I’ve seen in Postgres world is comparable.
      • debarshri5 minutes ago
        What you are describing is access via a PAM. Via RDP is one way to accessing it.
  • yoavm1 hour ago
    Looks great, congrats! Also check out <a href="https:&#x2F;&#x2F;github.com&#x2F;achristmascarl&#x2F;rainfrog" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;achristmascarl&#x2F;rainfrog</a> which seems to have similar goals, though is Postgres only.
    • kej2 minutes ago
      It looks like rainfrog has branched out from just postgres, but still doesn&#x27;t cover the range that sqlit does.
  • no_news_is19 hours ago
    Very nice, works well.<p>It seems you put some menu items behind what I&#x27;ll call &quot;[space] mode,&quot; where you you have to press the spacebar first to open the command menu, then use the command.<p>This is not reflected properly in the help text shown when you press ? and that was a source of confusion for me.<p>Especially since I managed to activate the fullscreen mode for one pane AND turn it off, but then couldn&#x27;t figure out how I did it; and also, I did not find the space-Q option to Quit at first.)<p>Edit to add, I prefer installing with pipx.<p>These commands worked for me, to get Postgresql and MariaDB database plugins:<p><pre><code> pipx install sqlit-tui cd ~&#x2F;.local&#x2F;pipx&#x2F;venvs&#x2F;sqlit-tui source bin&#x2F;activate bin&#x2F;python3 -m pip install psycopg2 sudo apt-get install -y libmariadb-dev # On Debian bin&#x2F;python3 -m pip install mariadb </code></pre> I didn&#x27;t try installing system-wide as per the GitHub instructions, I don&#x27;t know if that would have worked just as well with pipx or not.
    • zahlman52 minutes ago
      &gt; These commands worked for me, to get Postgresql and MariaDB database plugins:<p>I haven&#x27;t tried this, but I&#x27;m familiar with pipx. It provides a higher-level interface, so something like this should work:<p><pre><code> pipx install sqlit-tui sudo apt-get install -y libmariadb-dev pipx inject sqlit-tui psycopg2 mariadb </code></pre> Ref.: <a href="https:&#x2F;&#x2F;pipx.pypa.io&#x2F;stable&#x2F;#inject-a-package" rel="nofollow">https:&#x2F;&#x2F;pipx.pypa.io&#x2F;stable&#x2F;#inject-a-package</a><p>&gt; I don&#x27;t know if that would have worked just as well with pipx or not.<p>I don&#x27;t actually see anything in the GitHub instructions about system-wide installation? But yes, since version 1.5 (<a href="https:&#x2F;&#x2F;pipx.pypa.io&#x2F;stable&#x2F;changelog&#x2F;#150-2024-03-29" rel="nofollow">https:&#x2F;&#x2F;pipx.pypa.io&#x2F;stable&#x2F;changelog&#x2F;#150-2024-03-29</a>) Pipx can do a `--global` install that by default puts the managed venv in &#x2F;opt and executable symlink in &#x2F;usr&#x2F;local&#x2F;bin.
  • slimebot8020 hours ago
    This looks lovely.... does it support remote D1?
  • alsetmusic20 hours ago
    Very attractive design.