sqls VS vim-dadbod-ui

I am talking about this LS: https://github.com/lighttiger2505/sqls which is written in Go.

Has anyone successfully connected to Amazon Redshift using sqls (https://github.com/lighttiger2505/sqls)

I've been trying the neovim plugin (vim plugin available as well) for the sqls language server lately as an alternative to Dadbod, I like it so far: https://github.com/lighttiger2505/sqls#editor-plugins

Does https://github.com/lighttiger2505/sqls work?

To work with SQL databases already there are a huge number of excellent tools. Every IDE I’m familiar with has database plugins. Vim is included. LSP server already exists. But sometimes I just need to run a simple query, without getting distracted by going to other tools, looking for the right connection, or the prepared SQL query. Therefore, using the getCurrentParagraph function discussed above, I implemented a simple and fast start of SQL queries for PostgreSQL

I used sqls as lang server for LSP, after install you config your localhost with config.yml as the doc said https://github.com/lighttiger2505/sqls

sorry for late reply, i used sqls as lang server. https://github.com/lighttiger2505/sqls

Only plain SQL a T-SQL, see https://microsoft.github.io/language-server-protocol/implementors/servers/ . Is https://github.com/lighttiger2505/sqls completely hopeless?

I am a newbie of Nix, and I want to install some packages of Go for development, like sqls and efm-langserver . sqls can be go get github.com/lighttiger2505/sqls , and efm-langserver need to be built from source.

I installed the plugin following the instructions in https://github.com/kristijanhusak/vim-dadbod-ui and I'm able to connect to the database and execute queries, the only problem I have is that vim-dadbod-completion is not working.

You might check out hurl for a RestAPI tool replacement. There is also a vim plugin for it, although I have not used it. Someone already mentioned dadbod (which I think works great on its own), but if you are curious there is also a plugin to add a UI on top of it.

Hello. I'm trying to finds any good terminal solution to work with databases. There are a lot of great db tools for GUI (e.g datagrip) but not a lot for the terminal. The only one tool which I find usable excepted the raw cli queries is https://github.com/kristijanhusak/vim-dadbod-ui . Do you know anything better? Thanks.

See also Dadbod UI on (neo)vim to interact with databases: https://github.com/kristijanhusak/vim-dadbod-ui

Maybe that helps with autocompletion in dadbod: ```lua Plug 'https://github.com/tpope/vim-dadbod.git' Plug 'https://github.com/kristijanhusak/vim-dadbod-ui.git' Plug 'https://github.com/kristijanhusak/vim-dadbod-completion.git'

I did get vim-dadbod-ui kinda working at one point but wasn't able to get completion to work and the results output for MSSQL wasn't great (looks like it's better for PostgresSQL and MySQL, they have better CLI tools I guess?).

vim-dadbod-ui (https://github.com/kristijanhusak/vim-dadbod-ui) is really nice. Not written in lua and doesn't integrate with Telescope (AFAIK) but still really clean and easy to use.