04:23 "Which is one of, I think, the nicest farts - TJ, 2024
@teej_dv7 ай бұрын
LOL
@daredude1236 ай бұрын
Sounds like a good tshirt print.
@boreddad4207 ай бұрын
dadbod might be the best plugin name of all time
@dooZyz7 ай бұрын
I love it. Reject modernity. SQL >>> &&& NVIM>>>>>
@kristijanhusak7 ай бұрын
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_dv7 ай бұрын
hahaha wonderful plugin and well deserved!!
@rainerborene7 ай бұрын
Just joined your membership. Keep rocking!
@thijsyo7 ай бұрын
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😉)
@JefCollier7 ай бұрын
This made my day.
@componhead7 ай бұрын
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.
@florentcigolotti80237 ай бұрын
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
@TlatoaniItzcoatl7 ай бұрын
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Ай бұрын
Appreciated your explanation! Thanks TJ!
@艾曦-e4g7 ай бұрын
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-jv2bx7 ай бұрын
Man 2 videos back to back!!! BTW, Expect a reply in your mail, in a week when i am done adding dadBod.
@steveaguay7 ай бұрын
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.
@mikeyim99857 ай бұрын
Awesome plugin will use today!
@teej_dv7 ай бұрын
LETS GOOOOO
@PainfulBBQ7 ай бұрын
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
@deanrumsby6 ай бұрын
Thanks for another great video TJ... Looking forward to giving this setup a whirl
@jackevansevo7 ай бұрын
I knew about Dadbod, but never knew about dadbod-ui. The UI is a gamechanger!
@wesleychaffin40297 ай бұрын
I was wondering what this plugin was in an earlier video! Thanks for sharing
@daltonyon7 ай бұрын
I'll take a look in dadbod because I have been used DBeaver and is heavy, let's do it!! Thanks for the tip
@dimitardimitrov34212 ай бұрын
What a cool video! Thanks, Teej!
@jefferymuter46594 ай бұрын
As a recent convert from Goland to Nvim, this is incredible.
@xthebumpx7 ай бұрын
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.
@hernancervera66217 ай бұрын
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-xh6mo6 ай бұрын
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.
@CNich904 ай бұрын
This plugin is cool but dbeaver for database work is the cream of the crop
@gjermundification7 ай бұрын
Fantastic plugin, I will have to learn how to add other data sources for this.
@noomondai7 ай бұрын
Love these vids please keep them coming teej
@teej_dv7 ай бұрын
will do :) another one went live today!
@fredlthefred7 ай бұрын
this is fantastic - thx TJ for the tipp!!!
@devopsphilosopher7 ай бұрын
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.
@TylerTriesTech7 ай бұрын
Another great terminal based SQL tool to check out is Harlequin
@xthebumpx7 ай бұрын
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.
@VarunMehrishi7 ай бұрын
Cool, using this with DuckDB should make analysing large csv files a breeze!
@crow-dont-know6 ай бұрын
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.
@chrisjames2787 ай бұрын
Great looking plugin. Thanks for the info!
@teej_dv7 ай бұрын
No problem 😁
@roberfuentesg7 ай бұрын
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.
@markuslanggeng7 ай бұрын
oh my.. this plugin is so cool!
@TheMurinDeventa7 ай бұрын
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_dv7 ай бұрын
Nice, I might try that out next week
@KevinNitro4 ай бұрын
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.
@hamm89347 ай бұрын
Another great db tool i love is pgcli. Its a modern version of psql. Love it
@jabawack817 ай бұрын
ok one more plugin to add to my neovim, thanks.
@akshettrj7 ай бұрын
The man delivered
@bugabinga7 ай бұрын
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
@simonlauer93797 ай бұрын
uh I have been using that one for a while already. it’s great
@maladroitthief7 ай бұрын
Mind doing a mongodb setup? I struggled with that last time I looked into DBUI
@ChrisCox-wv7oo7 ай бұрын
Didn't know this was possible. Super neat
@bluehorizon95476 ай бұрын
You were the chosen one! You were supposed to destroy emacs-all-in-one-paradigm not join it!
@spicybaguette77067 ай бұрын
Got that Oracle drip
@Peter-el7fn7 ай бұрын
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_dv7 ай бұрын
I haven't yet - that'd be a good test case (the buffer completion at least would work OK)
@Peter-el7fn7 ай бұрын
@@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.
@TankorSmash7 ай бұрын
`: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.7 ай бұрын
Nice video. Setting up WSL2 + MSSQL (sadly) + Arch Linux would be entertaining video.
@letanoname29667 ай бұрын
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
@sarojregmi2007 ай бұрын
Great just was looking for a sql client in linux, found it in vim. Damn!! what a coincidence.
@tomasertola7 ай бұрын
This is gold!
@andrewiglinski1487 ай бұрын
I'm so curious as to whether or not you put on the corporate fit just for this video...
@patrickstival61797 ай бұрын
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
@TheTmLev7 ай бұрын
What about `dbee`?
@driden19877 ай бұрын
Is this a Take Tuesday? Is it back? Going to get dadbod, looks awesome
@m47h4r7 ай бұрын
What would we do if tj didn't post actually useful amazing videos! THANK YOU!
@hectororopesa0016 ай бұрын
corporate tj should do more videos!
@afroboi74547 ай бұрын
man, I must really say,, neovim is soooooo fuckin awesome.
@Readraid_2 ай бұрын
(you linked your config in the description twice instead of the gh repo)
@Dawalhasa2 ай бұрын
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.
@BorisBrodski7 ай бұрын
Can it follow foreign key constraints? I mean, jump from the id in the result column to the corresponding row in another table?
@metin4yt3 ай бұрын
Does it work with random .sql files? Will it provide completion in those, or only if inside the DBUI?
@s-xatya50883 ай бұрын
It doesn't work well with sqlserver. The query result doesn't format. Is there any way to fix it?
@kowalkem7 ай бұрын
What about dbee? Seen it in your config before ;)
@teej_dv7 ай бұрын
I tried it, but the completion experience wasn't as good (at least for now)
@kowalkem7 ай бұрын
@@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 😁
@kamalelbalaidi491428 күн бұрын
but why can we start these plugins with containers databases ?
@DaibertDiego7 ай бұрын
I would love if they release the Snowflake support for this plugin.
@noxalbelnox7 ай бұрын
great stuff
@martinroa7 ай бұрын
I didn't know about Dadbod. I've been using vim sqlls for this purpose. Any idea of how these two compare?
@vaisakh_km7 ай бұрын
This could have been an email.... do you have a newsletter???
@kingradical-x3 ай бұрын
Can we get a video where you actually did your set up please? How do you alias the connections?
@bambitsunami41657 ай бұрын
Really cool
@albert219947 ай бұрын
awesome!
@user-ex9ip7zw9e4 ай бұрын
could anyone tell me how to use save_query?
@cattohappy92637 ай бұрын
What's happening? Two videos in a row?
@Cethris7 ай бұрын
Would be nice to see how to add a db to the list in the video. But good stuff anyway
@simracing_evolve7 ай бұрын
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_dv7 ай бұрын
Can't really be wrong about something that's personal preference 😁 if you like it, I wouldn't switch!
@lipepaniguel7 ай бұрын
🤯
@jaswdrTheDev4 ай бұрын
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???!??!?!!?!?
@josecarloscirqueirajunior29147 ай бұрын
nice plugin
@datoxx79777 ай бұрын
Nice
@neeeeni7 ай бұрын
I missing docker support
@RazoBeckett.7 ай бұрын
you know what i am going to say "remember me ?"
@teej_dv7 ай бұрын
yes razo, of course :)
@HarshKumar-kv3xs7 ай бұрын
been using dbeaver for years, time to switch
@teej_dv7 ай бұрын
haha heard a lot of people say that in the comments, had never heard of it before
@qwfp7 ай бұрын
Of course it's from TPope. Who else could make something so great? (Other than TJ, of course)
@teej_dv7 ай бұрын
haha tpope inspired me to write plugins, so probably wouldn't have written any if he never did!
@qwfp7 ай бұрын
@@teej_dv we're all standing on the shoulders of giants
@simonlauer93797 ай бұрын
imagine the suffering of dbeaver plebs 😄
@SayfSentinel7 ай бұрын
No more pgadmin for me since i discovered this plugin
@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.
@ryanvelbon7 ай бұрын
lowercase SQL keywords? ... HARAM
@Lars-ce4rd7 ай бұрын
Thanks for those API keys, please don't revoke them. :)