Vim Dadbod - My Favorite SQL Plugin

  Рет қаралды 41,596

TJ DeVries

TJ DeVries

Күн бұрын

Пікірлер
@mbsurfer
@mbsurfer 7 ай бұрын
04:23 "Which is one of, I think, the nicest farts - TJ, 2024
@teej_dv
@teej_dv 7 ай бұрын
LOL
@daredude123
@daredude123 6 ай бұрын
Sounds like a good tshirt print.
@boreddad420
@boreddad420 7 ай бұрын
dadbod might be the best plugin name of all time
@dooZyz
@dooZyz 7 ай бұрын
I love it. Reject modernity. SQL >>> &&& NVIM>>>>>
@kristijanhusak
@kristijanhusak 7 ай бұрын
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
@teej_dv 7 ай бұрын
hahaha wonderful plugin and well deserved!!
@rainerborene
@rainerborene 7 ай бұрын
Just joined your membership. Keep rocking!
@thijsyo
@thijsyo 7 ай бұрын
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
@JefCollier 7 ай бұрын
This made my day.
@componhead
@componhead 7 ай бұрын
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.
@florentcigolotti8023
@florentcigolotti8023 7 ай бұрын
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
@TlatoaniItzcoatl
@TlatoaniItzcoatl 7 ай бұрын
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.
@ascourter
@ascourter Ай бұрын
Appreciated your explanation! Thanks TJ!
@艾曦-e4g
@艾曦-e4g 7 ай бұрын
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!
@mohitkumar-jv2bx
@mohitkumar-jv2bx 7 ай бұрын
Man 2 videos back to back!!! BTW, Expect a reply in your mail, in a week when i am done adding dadBod.
@steveaguay
@steveaguay 7 ай бұрын
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.
@mikeyim9985
@mikeyim9985 7 ай бұрын
Awesome plugin will use today!
@teej_dv
@teej_dv 7 ай бұрын
LETS GOOOOO
@PainfulBBQ
@PainfulBBQ 7 ай бұрын
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
@deanrumsby
@deanrumsby 6 ай бұрын
Thanks for another great video TJ... Looking forward to giving this setup a whirl
@jackevansevo
@jackevansevo 7 ай бұрын
I knew about Dadbod, but never knew about dadbod-ui. The UI is a gamechanger!
@wesleychaffin4029
@wesleychaffin4029 7 ай бұрын
I was wondering what this plugin was in an earlier video! Thanks for sharing
@daltonyon
@daltonyon 7 ай бұрын
I'll take a look in dadbod because I have been used DBeaver and is heavy, let's do it!! Thanks for the tip
@dimitardimitrov3421
@dimitardimitrov3421 2 ай бұрын
What a cool video! Thanks, Teej!
@jefferymuter4659
@jefferymuter4659 4 ай бұрын
As a recent convert from Goland to Nvim, this is incredible.
@xthebumpx
@xthebumpx 7 ай бұрын
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
@hernancervera6621 7 ай бұрын
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
@SauravPrashar-xh6mo 6 ай бұрын
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
@CNich90 4 ай бұрын
This plugin is cool but dbeaver for database work is the cream of the crop
@gjermundification
@gjermundification 7 ай бұрын
Fantastic plugin, I will have to learn how to add other data sources for this.
@noomondai
@noomondai 7 ай бұрын
Love these vids please keep them coming teej
@teej_dv
@teej_dv 7 ай бұрын
will do :) another one went live today!
@fredlthefred
@fredlthefred 7 ай бұрын
this is fantastic - thx TJ for the tipp!!!
@devopsphilosopher
@devopsphilosopher 7 ай бұрын
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.
@TylerTriesTech
@TylerTriesTech 7 ай бұрын
Another great terminal based SQL tool to check out is Harlequin
@xthebumpx
@xthebumpx 7 ай бұрын
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.
@VarunMehrishi
@VarunMehrishi 7 ай бұрын
Cool, using this with DuckDB should make analysing large csv files a breeze!
@crow-dont-know
@crow-dont-know 6 ай бұрын
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.
@chrisjames278
@chrisjames278 7 ай бұрын
Great looking plugin. Thanks for the info!
@teej_dv
@teej_dv 7 ай бұрын
No problem 😁
@roberfuentesg
@roberfuentesg 7 ай бұрын
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.
@markuslanggeng
@markuslanggeng 7 ай бұрын
oh my.. this plugin is so cool!
@TheMurinDeventa
@TheMurinDeventa 7 ай бұрын
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
@teej_dv 7 ай бұрын
Nice, I might try that out next week
@KevinNitro
@KevinNitro 4 ай бұрын
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.
@hamm8934
@hamm8934 7 ай бұрын
Another great db tool i love is pgcli. Its a modern version of psql. Love it
@jabawack81
@jabawack81 7 ай бұрын
ok one more plugin to add to my neovim, thanks.
@akshettrj
@akshettrj 7 ай бұрын
The man delivered
@bugabinga
@bugabinga 7 ай бұрын
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
@simonlauer9379
@simonlauer9379 7 ай бұрын
uh I have been using that one for a while already. it’s great
@maladroitthief
@maladroitthief 7 ай бұрын
Mind doing a mongodb setup? I struggled with that last time I looked into DBUI
@ChrisCox-wv7oo
@ChrisCox-wv7oo 7 ай бұрын
Didn't know this was possible. Super neat
@bluehorizon9547
@bluehorizon9547 6 ай бұрын
You were the chosen one! You were supposed to destroy emacs-all-in-one-paradigm not join it!
@spicybaguette7706
@spicybaguette7706 7 ай бұрын
Got that Oracle drip
@Peter-el7fn
@Peter-el7fn 7 ай бұрын
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
@teej_dv 7 ай бұрын
I haven't yet - that'd be a good test case (the buffer completion at least would work OK)
@Peter-el7fn
@Peter-el7fn 7 ай бұрын
@@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.
@TankorSmash
@TankorSmash 7 ай бұрын
`:set ft?` prints out the values too. I dunno about cmp, but `` already does buffer completions. Does Cmp do fuzzy search there too maybe?
@traap.
@traap. 7 ай бұрын
Nice video. Setting up WSL2 + MSSQL (sadly) + Arch Linux would be entertaining video.
@letanoname2966
@letanoname2966 7 ай бұрын
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
@sarojregmi200
@sarojregmi200 7 ай бұрын
Great just was looking for a sql client in linux, found it in vim. Damn!! what a coincidence.
@tomasertola
@tomasertola 7 ай бұрын
This is gold!
@andrewiglinski148
@andrewiglinski148 7 ай бұрын
I'm so curious as to whether or not you put on the corporate fit just for this video...
@patrickstival6179
@patrickstival6179 7 ай бұрын
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
@TheTmLev
@TheTmLev 7 ай бұрын
What about `dbee`?
@driden1987
@driden1987 7 ай бұрын
Is this a Take Tuesday? Is it back? Going to get dadbod, looks awesome
@m47h4r
@m47h4r 7 ай бұрын
What would we do if tj didn't post actually useful amazing videos! THANK YOU!
@hectororopesa001
@hectororopesa001 6 ай бұрын
corporate tj should do more videos!
@afroboi7454
@afroboi7454 7 ай бұрын
man, I must really say,, neovim is soooooo fuckin awesome.
@Readraid_
@Readraid_ 2 ай бұрын
(you linked your config in the description twice instead of the gh repo)
@Dawalhasa
@Dawalhasa 2 ай бұрын
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.
@BorisBrodski
@BorisBrodski 7 ай бұрын
Can it follow foreign key constraints? I mean, jump from the id in the result column to the corresponding row in another table?
@metin4yt
@metin4yt 3 ай бұрын
Does it work with random .sql files? Will it provide completion in those, or only if inside the DBUI?
@s-xatya5088
@s-xatya5088 3 ай бұрын
It doesn't work well with sqlserver. The query result doesn't format. Is there any way to fix it?
@kowalkem
@kowalkem 7 ай бұрын
What about dbee? Seen it in your config before ;)
@teej_dv
@teej_dv 7 ай бұрын
I tried it, but the completion experience wasn't as good (at least for now)
@kowalkem
@kowalkem 7 ай бұрын
@@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 😁
@kamalelbalaidi4914
@kamalelbalaidi4914 28 күн бұрын
but why can we start these plugins with containers databases ?
@DaibertDiego
@DaibertDiego 7 ай бұрын
I would love if they release the Snowflake support for this plugin.
@noxalbelnox
@noxalbelnox 7 ай бұрын
great stuff
@martinroa
@martinroa 7 ай бұрын
I didn't know about Dadbod. I've been using vim sqlls for this purpose. Any idea of how these two compare?
@vaisakh_km
@vaisakh_km 7 ай бұрын
This could have been an email.... do you have a newsletter???
@kingradical-x
@kingradical-x 3 ай бұрын
Can we get a video where you actually did your set up please? How do you alias the connections?
@bambitsunami4165
@bambitsunami4165 7 ай бұрын
Really cool
@albert21994
@albert21994 7 ай бұрын
awesome!
@user-ex9ip7zw9e
@user-ex9ip7zw9e 4 ай бұрын
could anyone tell me how to use save_query?
@cattohappy9263
@cattohappy9263 7 ай бұрын
What's happening? Two videos in a row?
@Cethris
@Cethris 7 ай бұрын
Would be nice to see how to add a db to the list in the video. But good stuff anyway
@simracing_evolve
@simracing_evolve 7 ай бұрын
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
@teej_dv 7 ай бұрын
Can't really be wrong about something that's personal preference 😁 if you like it, I wouldn't switch!
@lipepaniguel
@lipepaniguel 7 ай бұрын
🤯
@jaswdrTheDev
@jaswdrTheDev 4 ай бұрын
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???!??!?!!?!?
@josecarloscirqueirajunior2914
@josecarloscirqueirajunior2914 7 ай бұрын
nice plugin
@datoxx7977
@datoxx7977 7 ай бұрын
Nice
@neeeeni
@neeeeni 7 ай бұрын
I missing docker support
@RazoBeckett.
@RazoBeckett. 7 ай бұрын
you know what i am going to say "remember me ?"
@teej_dv
@teej_dv 7 ай бұрын
yes razo, of course :)
@HarshKumar-kv3xs
@HarshKumar-kv3xs 7 ай бұрын
been using dbeaver for years, time to switch
@teej_dv
@teej_dv 7 ай бұрын
haha heard a lot of people say that in the comments, had never heard of it before
@qwfp
@qwfp 7 ай бұрын
Of course it's from TPope. Who else could make something so great? (Other than TJ, of course)
@teej_dv
@teej_dv 7 ай бұрын
haha tpope inspired me to write plugins, so probably wouldn't have written any if he never did!
@qwfp
@qwfp 7 ай бұрын
@@teej_dv we're all standing on the shoulders of giants
@simonlauer9379
@simonlauer9379 7 ай бұрын
imagine the suffering of dbeaver plebs 😄
@SayfSentinel
@SayfSentinel 7 ай бұрын
No more pgadmin for me since i discovered this plugin
@beest_
@beest_ 7 ай бұрын
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.
@ryanvelbon
@ryanvelbon 7 ай бұрын
lowercase SQL keywords? ... HARAM
@Lars-ce4rd
@Lars-ce4rd 7 ай бұрын
Thanks for those API keys, please don't revoke them. :)
@Lars-ce4rd
@Lars-ce4rd 7 ай бұрын
gotcha
@teej_dv
@teej_dv 7 ай бұрын
o o f
@Lars-ce4rd
@Lars-ce4rd 7 ай бұрын
Ultimate smartass attention seeker (this guy)
@elalemanpaisa
@elalemanpaisa 4 ай бұрын
where tf is your dutch accent
@a_maxed_out_handle_of_30_chars
@a_maxed_out_handle_of_30_chars 7 ай бұрын
.
@mitchbet
@mitchbet 7 ай бұрын
Downvoted, sql config should be all caps
@teej_dv
@teej_dv 7 ай бұрын
you're correct, my apologies
I Rewrote My Entire Neovim Config...
11:09
TJ DeVries
Рет қаралды 51 М.
The Ultimate Database Control. Right WITHIN NEOVIM
9:35
DevOps Toolbox
Рет қаралды 62 М.
КОНЦЕРТЫ:  2 сезон | 1 выпуск | Камызяки
46:36
ТНТ Смотри еще!
Рет қаралды 3,7 МЛН
Automatically Execute *Anything* in Nvim
11:03
TJ DeVries
Рет қаралды 76 М.
lazy.nvim explained
14:17
TJ DeVries
Рет қаралды 24 М.
My neovim autocomplete setup: explained
11:32
TJ DeVries
Рет қаралды 40 М.
AWK - A Tool That Does Too Much
11:10
The Exhausted Programmer
Рет қаралды 22 М.
30 Vim commands you NEED TO KNOW (in just 10 minutes)
10:27
typecraft
Рет қаралды 134 М.
(Neo)Vim Made Me a Better Software Developer
40:27
vim-jp
Рет қаралды 47 М.
simple neovim debugging setup (in 10 minutes)
9:36
TJ DeVries
Рет қаралды 59 М.
The Holy Grail of Neovim Note Taking
14:38
DevOps Toolbox
Рет қаралды 360 М.
tree-sitter explained
15:00
TJ DeVries
Рет қаралды 97 М.
Ultimate Quickfix List Guide
10:15
Andrew Courter
Рет қаралды 26 М.