frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Show HN: Sqlit – A lazygit-style TUI for SQL databases

https://github.com/Maxteabag/sqlit
83•MaxTeabag•1d ago
I work mostly in the terminal but found myself constantly switching to bloated GUIs like SSMS only for the simple task of browsing tables and run queries. And I didn't find Existing SQL TUIs intuitive, having to read documentation to learn keybindings and CLI flags to connect. Given I had recently switched to linux, I found myself using vs code's sql database extension. Something was awfully wrong.

I wanted something like lazygit for databases – run it, connect, and query and frankly just make it enjoyable to access data.

  Sqlit is a keyboard-driven SQL TUI with:

  - Context-based keybindings (always visible)
  - Neovim-like interface with normal and insert mode for query editing
  - Browse databases, tables, views, stored procedures
  - Adapters for SQL Server, SQLite, PostgreSQL, Turso & more
  - SSH tunneling support
  - Themes (Tokyo Night, Nord, Gruvbox etc.)

  Inspired by lazygit, neovim and lazysql. Built with Python/Textual.
Feedback welcome – especially on which adapters to prioritize next. My vision of sqlit is to make a tool that makes it easy to connect and query data, and to do that, and that thing only, really well.

https://github.com/Maxteabag/sqlit

Comments

alsetmusic•20h ago
Very attractive design.
slimebot80•20h ago
This looks lovely.... does it support remote D1?
no_news_is•19h ago
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.
zahlman•51m ago
> 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.

yoavm•1h ago
Looks great, congrats! Also check out https://github.com/achristmascarl/rainfrog which seems to have similar goals, though is Postgres only.
debarshri•1h 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.

I'm wondering if thats true.

baq•1h ago
Admins don’t ever close the tool, it’s always open on some RDP. Devs have different usage patterns.

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.

debarshri•4m ago
What you are describing is access via a PAM. Via RDP is one way to accessing it.

Show HN: Sqlit – A lazygit-style TUI for SQL databases

https://github.com/Maxteabag/sqlit
84•MaxTeabag•1d ago•9 comments

Show HN: Deterministic PCIe Diagnostics for GPUs on Linux

https://github.com/parallelArchitect/gpu-pcie-diagnostic
6•gpu_systems•1h ago•1 comments

Show HN: Interactive Common Lisp: An Enhanced REPL

https://github.com/atgreen/icl
76•atgreen•2d ago•5 comments

Show HN: Solving the ~95% legislative coverage gap using LLM's

https://lustra.news/
26•fokdelafons•7h ago•15 comments

Show HN: My Tizen multiplayer drawing game flopped, but then hit 100M drawings

https://www.drawize.com/
14•lombarovic•6h ago•2 comments

Show HN: I built the fastest RSS reader in Zig

https://github.com/superstarryeyes/hys
6•superstarryeyes•2h ago•0 comments

Show HN: Zenflow – orchestrate coding agents without "you're right" loops

https://zencoder.ai/zenflow
21•andrewsthoughts•5h ago•10 comments

Show HN: A real-time 4D fractal explorer in the browser using WebGPU

https://bryanjj.github.io/nebula/
20•bryan0•5d ago•7 comments

Show HN: I designed my own 3D printer motherboard

https://github.com/KaiPereira/Cheetah-MX4-Mini
125•kaipereira•1w ago•37 comments

Show HN: Dev Tools – 24 browser-based utilities with no signup or tracking

https://dev-tools.online
2•ghdj•2h ago•0 comments

Show HN: AI Generated SVG's

https://vectorart.ai
2•tm11zz•3h ago•0 comments

Show HN: Picknplace.js, an Alternative to Drag and Drop

https://jgthms.com/picknplace.js/
22•bbx•6h ago•12 comments

Show HN: Ducktape – a tiny HTTP/2 wrapper around DuckDB's Appender API

https://github.com/artie-labs/ducktape
9•williamhaw•6h ago•0 comments

Show HN: A pager

https://www.udp7777.com/
99•keepamovin•2d ago•42 comments

Show HN: Pothole Detection System (YOLOv8 – FastAPI – Docker – React Native)

https://github.com/PeterHdd/pothole-detection-yolo
2•peterhddcoding•5h ago•0 comments

Show HN: DuckDB Table Visualizer –> Iceberg

https://duckdb.org/visualizer/
2•carlopi•6h ago•0 comments

Show HN: Search the lyrics of 500 HÖR Berlin techno sets

https://hor.greg.technology/
15•gregsadetsky•4d ago•10 comments

Show HN: WindMouse Algorithm in Python

2•AsfhtgkDavid•3h ago•0 comments

Show HN: Cordon – Reduce large log files to anomalous sections

https://github.com/calebevans/cordon
16•calebevans•1d ago•0 comments

Show HN: WeekInPapers – A Modern ArXiv Reader

https://www.weekinpapers.com/
3•mox111•8h ago•0 comments

Show HN: MP3 File Editor / Player for Windows

https://github.com/cutandjoin/Cjam/releases/tag/v2350
3•cutandjoin•9h ago•4 comments

Show HN: Building a full-stack Cloudflare starter kit (Hono and D1 and Stripe)

https://cf-stack-kit.hy-dev.workers.dev/
3•hy_wondercoms•9h ago•2 comments

Show HN: Open-source Markdown research tool written in Rust – Ekphos

https://github.com/hanebox/ekphos
2•haneboxx•9h ago•0 comments

Show HN: Building a small psychedelic twin-stick shooter in the browser

https://www.jamesdrandall.com/posts/building-a-webgpu-twinstick-psychedelic-shooter/
2•jamesrandall•11h ago•0 comments

Show HN: Hugity – Notion-style static docs editor with GitHub/Hugo auto-deploy

https://app.hugity.com
2•vladimiras•12h ago•0 comments

Show HN: Cargo-rail: graph-aware monorepo tooling for Rust; 11 deps

https://github.com/loadingalias/cargo-rail
61•LoadingALIAS•6d ago•7 comments

Show HN: DeviceLab – Turn phones across offices into one device lab

3•omnarayan•13h ago•0 comments

Show HN: Footywhoops – MIDI Sequencer Software

https://github.com/system32-ai/footywhoops
2•debarshri•14h ago•0 comments

Show HN: Open-Source Notion MCP Server (TypeScript, SSE, Apify)

https://github.com/piskunproject/notion-mcp-server
9•piskunlab•1d ago•0 comments

Show HN: Autograd.c – a tiny ML framework built from scratch

https://github.com/sueszli/autograd.c
5•sueszli•15h ago•0 comments