Litecli: CLI for SQLite Databases with auto-completion and syntax highlighting

https://github.com/dbcli/litecli

by tosh • 2 years ago

162 27 2 years ago

github.com

walthamstow• 2 years ago

This whole suite of DBCLIs are brilliant. I use litecli and pgcli most often but they're all good.

pdyc• 2 years ago

is there a binary only utility like this that does not requires messing up with python?

rented_mule2• 2 years ago

If you install 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• 2 years ago

I assume it works like pipx, caches the download until a new reboot

hprotagonist4• 2 years ago

`pipx run litecli`

dbtablesorrows2• 2 years ago

What's wrong with pipx install?

saghm3• 2 years ago

The fact that there are already multiple comments with different tools recommended for how to easily deal with Python packages is a perfect example of why people like the parent commenter don't want to deal with Python in the first place. I'm sure that "just use pipx" works well for you and others, but for those of us who don't know the difference between the half dozen or so different package managers that seem to be mentioned whenever Python comes up, we don't have any clue whether pipx is the "right" choice or if "uv"/"uvx" like the sibling commenter recommends is better. We could spend time researching to figure that out, but that's exactly what we're trying to avoid in the first place!

djbusby• 2 years ago

I 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.

senkora2• 2 years ago

This 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• 2 years ago

Yep ! ...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.

darkteflon3• 2 years ago

prompt_toolkit looks good. Have you tried Textual? Any thoughts on how they compare?

senkora2• 2 years ago

I 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• 2 years ago

Downloaded 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• 2 years ago

Thanks for sharing.

I should check out pgcli too when I use Postgres in the future.

Litecli: CLI for SQLite Databases with auto-completion and syntax highlighting

Related Stories