9 ms·
Litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
- faangguyindia 2y ago[flagged]
- walthamstow 2y agoThis whole suite of DBCLIs are brilliant. I use litecli and pgcli most often but they're all good.
- pdyc 2y agois there a binary only utility like this that does not requires messing up with python?
- rented_mule 2y agoIf you install https://github.com/astral-sh/uv https://github.com/astral-sh/uv (it's really just two binaries... uv and uvx), then you can run many Python CLIs, and it will manage everything for you. This means resolving and downloading dependencies without touching your system Python. In this case, you'd type `uvx litecli`. If uvx can't find a suitable Python already installed, it will do its best to download a privately managed version. And it's very fast at doing all this.
- synergy20 2y agoI assume it works like pipx, caches the download until a new reboot
- rented_mule 2y agoYes, uvx's behavior is a lot like pipx, but much faster to start up programs (just as uv is much faster than pip), whether cached or not.
- darkteflon 2y agoHuh, I’m a big rye user but had no idea that uvx was a drop-in replacement for pipx. Thanks!
- hprotagonist 2y ago`pipx run litecli`
- dbtablesorrows 2y agoWhat's wrong with pipx install?
- hprotagonist 2y agonothing!
- CRConrad 2y agoLots. Perhaps not with pipx itself, but as a symptom of what's wrong with Python (and most software nowadays) there are lots of problems with it: Everything is such huge stacks of stuff built on other stuff built on other stuff built on other stuff... All huge tottering heaps of infrastructure where shit can (and does) go wrong in every layer. It's package managers running in containers calling dynamically-linked libraries running on virtual machines calling package managers running in containers calling dynamically-linked libraries running on virtual machines... With, say, Turbo Pascal you compiled your code into a .COM file, copied it to a floppy, and people ran it. Just your program. On their OS. No heaps of layers of infrastructure and toolchains to get knotted into a tangle of failing interdependencies. How the fuck can it be so impossible to build stuff like that nowadays?!? Not that I'm blaming pipx (whatevertheheck that is; judging from the name seems to be a relative of pip's, which I've heard of) in particular, or even Python itself, more than anything else. Almost everything nowadays seems to be that way. I just wrote all this in the hope that it might explain why a lot of us (like for instance your interlocutor saghm in a sibling thread) are rather reluctant to pick up all the New[1] Shiny stuff. It all seems to so inevitably bring with it rat's nests -- colonies of rat's nests! -- of interdependent cruft tangled up into tight balls of mud and misery. You lose the will to even start trying anything out. ___ [1]: And yeah, OK, calling Python "New" might be problematic... If we'd gotten around to picking it up some fifteen years ago it might still have been. And maybe not accrued as many layers of cruft.
- djbusby 2y agoI do all my Python stuff in a container. I've found it easier than the N+ other methods. As a bonus when creating the container one can basically just use the tools the project author likes (pip, ,etc) even legacy things from older scripts.
- senkora 2y agoThis uses the same TUI library as IPython, called prompt_toolkit. It’s the best one for Python in my opinion. Pretty easy to work with.
- devnonymous 2y agoYep ! ...and if you want the same ux with Postgresal, MySQL or Mariadb you have pgcli and mycli. There also a tmux and vim clone that uses prompt_toolkit iirc.
- darkteflon 2y agoprompt_toolkit looks good. Have you tried Textual? Any thoughts on how they compare?
- senkora 2y agoI haven't tried Textual but I just gave it a look and it seems good as well. My usecase involves embedding a text editor widget inside my TUI app with vim keybindings enabled, and I don't think that Textual yet has a way to do that. But on the other hand it looks like Textual has a way bigger library of pre-built widgets for full-screen applications. prompt_toolkit started as a tool for REPLs and eventually grew a basic full-screen application mode, so there's excellent support for text editing and the widget stuff is a lot less mature. It looks like Textual started as a tool for full-screen apps and has a great widget library but the text-editing widget is much less mature. My application started as a CLI and I gradually added TUI elements around the command bar, and prompt_toolkit is definitely the best for something like that. I think that if your plan is something more similar to a webapp and you want to rely on a component library then Textual would probably be better.
- prudentpomelo 2y agoDownloaded it this morning on my work machine and it worked like a dream. Multiline mode and vim bindings were the chefs kiss that brought it all together.
- frays 2y agoThanks for sharing. I should check out pgcli too when I use Postgres in the future.