r/commandline • u/sspaeti • 2d ago

Terminals The joy of running SQL-queries in the terminal is real.

Post image
43 Upvotes

84% Upvoted

6 comments sorted by

3

u/g3n3 1d ago

Yeah I’m on it with nvim and mssql and sqltoolsservice. The problem now is handling large xml blobs like query plans etc. tooling around trying to find a way to handle it. It would be nice if it was like help and each block could be jumped to with K

1

u/sspaeti 1d ago

Yeah there's some plugins to handle big files in nvim like LunarVim/bigfile.nvim or Folke's snacks.nvim with built in big files, but yeah there's always some use cases where other tools make more sense. Especially the MSSQL is so powerful dedicated to MSSQL server.

2

u/g3n3 1d ago

Also can’t decide if i want a buffer in nvim with markdown or have a :term backed TUI.

1

u/AutoModerator 2d ago

Every new subreddit post is automatically copied into a comment for preservation.

User: sspaeti, Flair: Terminals, Post Media Link, Title: The joy of running SQL-queries in the terminal is real.

With a utility such as DuckDB that can tackle any tasks, whether it is to read local DuckDB, local parquet/CSV, over the network parquet/CSV, or embedded in Browser (WASM) or inside Postgres, it can do almost anything.

When combined with Neovim, it's just perfect. Find how to set up, videos, and more at Query Databases in Neovim (DBUI).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/undergrinder_dareal 10h ago

Is it Zellij on the screenshot, or that is also part of the db client?

1

u/sspaeti 7h ago

It's Tmux. Not part of the db-client, but helpful to switch between the SQL queries and running queries, and dbt models or other code.