Our great sponsors
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Using neovim + https://github.com/kassio/neoterm I have a similar, possibly simpler, workflow that doesn't require any other program (especially listening willy nilly with no authentication/authorization whatsoever) other than your normal SQL client running:
* I open a :Term window, in which I run the sql client (i.e. ":Texec sqlite\ foo.sqlite" or ":Texec mysql foo", etc)
See also Dadbod UI on (neo)vim to interact with databases: https://github.com/kristijanhusak/vim-dadbod-ui
I used dadbod[0] and the following in my vimrc[1] to do a similar thing, only I haven't make the shortcuts for sending a block yet.
Looks nice though, maybe I'll try it out sometime!
[0] https://github.com/tpope/vim-dadbod
[1] au FileType sql nmap d :%:DB g:db
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
Related posts
- Any handy plug-ins to set up a workflow for Java?
- Advice for r and rmarkdown using vim?
- Do you give use Vim for SQL. It took me a while to setup this. sqls - lang server (auto complete), dadbodUI (view table, execute and save query), prettier-sql (format code on save).
- Using SonarLint language server in Vim?
- Need help to set up the pbkit language server