Vim Dadbod - My Favorite SQL Plugin

Continuing on with my neovim config rewrite, we've got a video about vim dadbod
-- Dad Bod Plugins
return {
"tpope/vim-dadbod",
"kristijanhusak/vim-dadbod-completion",
"kristijanhusak/vim-dadbod-ui",
}
Configuration: github.com/tjdevries/config.nvim
Dadbod: github.com/tjdevries/config.n...
Links
Twitch: / teej_dv
Twitter: / teej_dv
Github: github.com/tjdevries
Neovim: BTW
#neovim #programming #lua

[@mbsurfer]

04:23 "Which is one of, I think, the nicest farts - TJ, 2024

[@teej_dv]

LOL

[@rainerborene]

Just joined your membership. Keep rocking!

[@mrmaniac9905]

I love it. Reject modernity. SQL >>> &&& NVIM>>>>>

[@emiliano19746]

Oh, boy, your videos are awesome. I use dadbod from a long time, nonetheless the video is great (the bunch of minutes length works really well)! Thank you so much. Little feedback: sometimes could be useful see the file path at right.

[@thijsyo]

Thanks for circling this back to the bigger group, TJ! Feeling really good about our Q2 OKR's, especially once we start to leverage gen-AI. By the way, Chris on floor 6 has brought donuts today (you didn't hear this from me😉)

[@JefCollier]

This made my day.

[@IntelligentStaffingSystems]

I'm officially niche having absolutely enjoyed this video and understood everything you said. I feel like I'm amongst some of the coolest people on Earth.

[@wesleychaffin4029]

I was wondering what this plugin was in an earlier video! Thanks for sharing

[@boreddad420]

dadbod might be the best plugin name of all time

[@fredlthefred]

this is fantastic - thx TJ for the tipp!!!

[@PainfulBBQ]

thank you so much, it looks really cool. One thing I’d hoped you would cover is configuring the connection between the plugin and something like Postgresql or Mysql

[@xthebumpx]

SQL (specifically MS Sql Server) is one of my biggest pain points with Neovim. Dadbod/Dadbod-ui/Dadbod-ui-completion do what they do well, but the completion experience is still pretty limited compared even to vscode let alone something like Datagrip.

[@hernancervera6621]

I use DBeaver with the Vrapper (Vim emulation) plugin and it has worked very nicely for me. There is some limited config that can be provided in VimScript. I have not used Datagrip but since that is from JetBrains I imagine the plugin IdeaVim is available there

[@kristijanhusak]

Nice video TJ, I was wondering where are all those stars coming from :) I'll link this video in the readme on both plugins.

[@teej_dv]

hahaha wonderful plugin and well deserved!!

[@TlatoaniItzcoatl]

man the results output for sqlite is so pretty. I bet MySQL and PosgreSQL look great too. Unfortunately MS SQL Server looks terrible. It's the only reason I don't really use it, that, plus the completion is not robust enough to handle cross database queries and or good enough for large sql scripts. But it's great for simple dml or ddl stuff.

[@user-xd5gd4pc9h]

LOVE Tj! Feature I want is the comments string to work with comments.nvim plugin. So `gcc` or other shortcuts works fine in sql file too. Thanks Tj!

[@akshettrj]

The man delivered

[@mohitkumar-jv2bx]

Man 2 videos back to back!!! BTW, Expect a reply in your mail, in a week when i am done adding dadBod.

[@florentcigolotti8023]

Very nice video! I have been using it in my day to day job since a long time, so great experience so far. My preferred keymap is to run a query under the cursor with something like rq (for run query) set to "vipS". It selects the current paragraph en run the default DBUI_ExecuteQuery binded on S by vim-dadbod-ui. With that it is awesome! No more needs to comment SQL queries

[@noomondai]

Love these vids please keep them coming teej

[@teej_dv]

will do :) another one went live today!

[@mikeyim9985]

Awesome plugin will use today!

[@teej_dv]

LETS GOOOOO

[@steveaguay]

I gotta give it another try. That looked like a great experience. My sql viewer has been gui based forever and I find it hard to switch off dbeaver. It's so good.

[@m47h4r]

What would we do if tj didn't post actually useful amazing videos! THANK YOU!

[@daltonyon]

I'll take a look in dadbod because I have been used DBeaver and is heavy, let's do it!! Thanks for the tip

[@traap.]

Nice video. Setting up WSL2 + MSSQL (sadly) + Arch Linux would be entertaining video.

[@chrisjames278]

Great looking plugin. Thanks for the info!

[@teej_dv]

No problem 😁

[@jackevansevo]

I knew about Dadbod, but never knew about dadbod-ui. The UI is a gamechanger!

[@tomasertola]

This is gold!

[@markuslanggeng]

oh my.. this plugin is so cool!

[@gjermundification]

Fantastic plugin, I will have to learn how to add other data sources for this.

[@VarunMehrishi]

Cool, using this with DuckDB should make analysing large csv files a breeze!

[@roberfuentesg]

Hola Tj gracias por todos tu videos. Sabes he estado buscando algun plugin que pueda hacer lo que hace postman, he intentado con rest.nvim y console.nvim (creo que se llama asi no recuerdo bien) y nunca he podido hacerlos funcionar de la mejor manera. Tienes uno de tu preferencia? Saludos desde Chile.

[@ChrisCox-wv7oo]

Didn't know this was possible. Super neat

[@jabawack81]

ok one more plugin to add to my neovim, thanks.

[@bugabinga]

I feel this irrational aversion to adding a non-lua plugin to the config. but this one is just too good to pass up xD

[@noxalbelnox]

great stuff

[@TylerTriesTech]

Another great terminal based SQL tool to check out is Harlequin

[@xthebumpx]

Ooh. That looks neat, I need to give it a try. Edit: Tried it. It's really cool. Unfortunately, at work I need completions from multiple databases at the same time, which isn't supported.

[@bambitsunami4165]

Really cool

[@hamm8934]

Another great db tool i love is pgcli. Its a modern version of psql. Love it

[@albert21994]

awesome!

[@simonlauer9379]

uh I have been using that one for a while already. it’s great

[@letanoname2966]

It would be great if you could also cover formatting and connections, especially to 'picky' DBs, like the ones from Oracle Overall, great video! :D

[@TankorSmash]

`:set ft?` prints out the values too. I dunno about cmp, but `` already does buffer completions. Does Cmp do fuzzy search there too maybe?

[@spicybaguette7706]

Got that Oracle drip

[@lipepaniguel]

🤯

[@TheMurinDeventa]

Mine a bit different, I have sqls lsp running when inside dadbod buffer so I have formatting and completion source and other lsp utilities

[@teej_dv]

Nice, I might try that out next week

[@maladroitthief]

Mind doing a mongodb setup? I struggled with that last time I looked into DBUI

[@Peter-el7fn]

Thanks for all your great content! Have you tried how the completion works with CTES? E.g with my_songs as( select title as song_title , length as duration where artist 'primegean' from theme_songs ) select... (Do the completion pick up the name of the cte and the aliased col names..?

[@teej_dv]

I haven't yet - that'd be a good test case (the buffer completion at least would work OK)

[@Peter-el7fn]

@@teej_dv I tried it and it seems like it is the buffer that handles it - i.e. columns in the cte does show up in the completion but it does not seem to be able to distinguish the scope (the cte) of the column.

[@driden1987]

Is this a Take Tuesday? Is it back? Going to get dadbod, looks awesome

[@BorisBrodski]

Can it follow foreign key constraints? I mean, jump from the id in the result column to the corresponding row in another table?

[@afroboi7454]

man, I must really say,, neovim is soooooo fuckin awesome.

[@sarojregmi200]

Great just was looking for a sql client in linux, found it in vim. Damn!! what a coincidence.

[@datoxx7977]

Nice

[@patrickstival6179]

It would be nice if it was possible to do ctrl + enter to execute the query under cursor. Having to comment out other sql staments feels a bit awkward

[@martinroa]

I didn't know about Dadbod. I've been using vim sqlls for this purpose. Any idea of how these two compare?

[@RoadsterRhapsody]

Im a little bit confused about this plugin. I already tried it about a month ago in this set of config and its ideal for write fast querries. But for serious company work i rather use dbeaver or access. Am i wrong here?

[@teej_dv]

Can't really be wrong about something that's personal preference 😁 if you like it, I wouldn't switch!

[@andrewiglinski148]

I'm so curious as to whether or not you put on the corporate fit just for this video...

[@DaibertDiego]

I would love if they release the Snowflake support for this plugin.

[@josecarloscirqueirajunior2914]

nice plugin

[@TheTmLev]

What about `dbee`?

[@beest_]

I like the plug-in very much, but I'm not a VIM/newVIM user. know the basics but never configured it. To add more complexity I'm on a windows system. Any Instructions? Help is very much apprecieated.

[@kowalkem]

What about dbee? Seen it in your config before ;)

[@teej_dv]

I tried it, but the completion experience wasn't as good (at least for now)

[@kowalkem]

@@teej_dv sqls works for completion quite well 👌made a simple config to read a connection config file from the repo on LSP client start. Happy with it so far 😁

[@Cethris]

Would be nice to see how to add a db to the list in the video. But good stuff anyway

[@vaisakhkm783]

This could have been an email.... do you have a newsletter???

[@RazoBeckett.]

you know what i am going to say "remember me ?"

[@teej_dv]

yes razo, of course :)

[@neeeeni]

I missing docker support

[@HarshKumar-kv3xs]

been using dbeaver for years, time to switch

[@teej_dv]

haha heard a lot of people say that in the comments, had never heard of it before

[@cattohappy9263]

What's happening? Two videos in a row?

[@qwfp]

Of course it's from TPope. Who else could make something so great? (Other than TJ, of course)

[@teej_dv]

haha tpope inspired me to write plugins, so probably wouldn't have written any if he never did!

[@qwfp]

@@teej_dv we're all standing on the shoulders of giants

[@simonlauer9379]

imagine the suffering of dbeaver plebs 😄

[@SayfSentinel]

No more pgadmin for me since i discovered this plugin

[@ryanvelbon]

lowercase SQL keywords? ... HARAM

[@Lars-ce4rd]

Thanks for those API keys, please don't revoke them. :)

[@Lars-ce4rd]

gotcha

[@teej_dv]

o o f

[@Lars-ce4rd]

Ultimate smartass attention seeker (this guy)

[@a_maxed_out_handle_of_30_chars]

.

[@mitchbet]

Downvoted, sql config should be all caps

[@teej_dv]

you're correct, my apologies