Vim Dadbod - My Favorite SQL Plugin

[@mrmaniac9905]

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

[@mbsurfer]

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

[@teej_dv]

LOL

[@daredude123]

Sounds like a good tshirt print.

[@boreddad420]

dadbod might be the best plugin name of all time

[@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!!

[@rainerborene]

Just joined your membership. Keep rocking!

[@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.

[@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.

[@componhead]

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.

[@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

[@SauravPrashar-xh6mo]

were you able to use it with MS Sql? I didn't see that in the "supported dbs" list and assumed It wouldn't be of much use to me atm, but if it even allows me to not open up MSSQL stdio and do stuff in the editor itself, I think it would still work for me.

[@CNich90]

This plugin is cool but dbeaver for database work is the cream of the crop

[@jefferymuter4659]

As a recent convert from Goland to Nvim, this is incredible.

[@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

[@mohitkumar-jv2bx]

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

[@deanrumsby]

Thanks for another great video TJ... Looking forward to giving this setup a whirl

[@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

[@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.

[@dimitardimitrov3421]

What a cool video! Thanks, Teej!

[@jackevansevo]

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

[@艾曦-e4g]

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!

[@crow-dont-know]

After years of using GUIs like Postico and DBeaver, I have been using dadbod on a daily basis for about a year. It’s neat.

[@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.

[@VarunMehrishi]

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

[@gjermundification]

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

[@devopsphilosopher]

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

[@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

[@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

[@mikeyim9985]

Awesome plugin will use today!

[@teej_dv]

LETS GOOOOO

[@bluehorizon9547]

You were the chosen one! You were supposed to destroy emacs-all-in-one-paradigm not join it!

[@noomondai]

Love these vids please keep them coming teej

[@teej_dv]

will do :) another one went live today!

[@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

[@KevinNitro]

Excute me I'm a new guys learning sql. Is that you have to connect to the database in dadbod ui, then to connect the database to the current query (using sqls)? Can I see your configuration? Thank you.

[@jabawack81]

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

[@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.

[@chrisjames278]

Great looking plugin. Thanks for the info!

[@teej_dv]

No problem 😁

[@ChrisCox-wv7oo]

Didn't know this was possible. Super neat

[@m47h4r]

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

[@maladroitthief]

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

[@traap.]

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

[@fredlthefred]

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

[@hamm8934]

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

[@simonlauer9379]

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

[@sarojregmi200]

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

[@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.

[@markuslanggeng]

oh my.. this plugin is so cool!

[@Readraid_]

(you linked your config in the description twice instead of the gh repo)

[@spicybaguette7706]

Got that Oracle drip

[@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

[@hectororopesa001]

corporate tj should do more videos!

[@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?

[@DaibertDiego]

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

[@akshettrj]

The man delivered

[@tomasertola]

This is gold!

[@afroboi7454]

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

[@driden1987]

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

[@metin4yt]

Does it work with random .sql files? Will it provide completion in those, or only if inside the DBUI?

[@TheTmLev]

What about `dbee`?

[@noxalbelnox]

great stuff

[@BorisBrodski]

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

[@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

[@andrewiglinski148]

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

[@vaisakh_km]

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

[@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 😁

[@martinroa]

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

[@albert21994]

awesome!

[@s-xatya5088]

It doesn't work well with sqlserver. The query result doesn't format. Is there any way to fix it?

[@bambitsunami4165]

Really cool

[@cattohappy9263]

What's happening? Two videos in a row?

[@Cethris]

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

[@Dawalhasa]

Can you please make a video on how to add the database properly. I'm having path trouble when I try to add a new database.

[@kingradical-x]

Can we get a video where you actually did your set up please? How do you alias the connections?

[@simracing_evolve]

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!

[@user-ex9ip7zw9e]

could anyone tell me how to use save_query?

[@RazoBeckett.]

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

[@teej_dv]

yes razo, of course :)

[@neeeeni]

I missing docker support

[@lipepaniguel]

🤯

[@datoxx7977]

Nice

[@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

[@josecarloscirqueirajunior2914]

nice plugin

[@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

[@jaswdrTheDev]

What is the command you used to run the query? Something that I hate on every single VIM/Neovim is that there is no QuickStart section just quickly showing how to use the plugin, instead I need to waste several minutes to read something that I even know is useful to me. Knowing how to execute the query is the most important action and is never mentioned in the Github README or documentation. WTF???!??!?!!?!?

[@SayfSentinel]

No more pgadmin for me since i discovered this plugin

[@simonlauer9379]

imagine the suffering of dbeaver plebs 😄

[@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)

[@ryanvelbon]

lowercase SQL keywords? ... HARAM

[@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.

[@elalemanpaisa]

where tf is your dutch accent

[@a_maxed_out_handle_of_30_chars]

.

[@mitchbet]

Downvoted, sql config should be all caps

[@teej_dv]

you're correct, my apologies