The Ultimate Database Control. Right WITHIN NEOVIM

Another way to remove mental stress and load is removing that from connecting to DBs while working / debugging. Instead of annoying CLIs or reosurce-consuming GUIs, I'm taking Tim Pope's plugin "dadbod", adding a plugin for the UI, adding another one for autocompletion, and making treesitter play nice for syntax highlighting! Come!

LINKS

MY FAVOURITE GEAR
* If you enjoy my content, using the links below will help me with a small commission, so thank you!

CONSIDER SUPPORTING THIS CHANNEL

MY KEY LINKS

⏱ Timestamps
00:00 - Intro
00:52 - The Problem
01:24 - Time Pope's vim-dadbod
03:02 - Dadbod UI
05:25 - Dadbod Completion
06:44 - Making Treesitter play nice with SQL
07:24 - Configurations
08:13 - Why Bother?

#neovim #vim #productive #program #dev #devops #software #softwareengineer #sysops #linux #terminal #console #cli #keyboard #commandline #sql #database

[frypy]

I thought WHY did I not know about this!? *Realizes video was posted "29 minutes ago". Can't wait to try this out. -excited neovim user

[traap.]

Very nice dadbod demonstration. I enjoyed how you walked us through each plugin you were using to create an outstanding environment which definitely reduces one's cognitive load when switching contexts. Excellent work!

[lukerogers]

Wow! I’ve been looking for a decent terminal based UI for SQLite and I couldn’t find anything good enough. I didn’t even think about using a Neovim plugin, but this looks amazing! Really well produced video as well.

[jorgenolck]

I've spent like 6 hours trying to configure the completion on it. This video made it sound so easy.

[friorento]

I'll probably still prefer DBeaver for the most part. Maybe when I get more used to nvim, but being able to export results in different formats / to the clipboard, UI changes color depending if I'm in staging or production, and having two different environments for coding and database access is better for now.

[mohitkumar-jvbx]

Tysm. I regularly switch between neovim and dbeaver. This would make the workflow so better.

[nikensss]

oooh, man, this is nice! I kept using psql because I wanted to stay in the terminal, but at some point it gets in the way... Thanks for the vid!

The only thing I didn't manage to get right is the autocompletions in the sql buffer :(

[ProphylacticGizzard]

this was great, I see so many people talking about how great neovim is but I haven't seen anyone working with databases in a way that seems reasonable. I spend almost as much time messing with DBs as I do writing actual code, so I never felt like vim could be a viable replacement for intellij (or datagrip) before seeing this.

[shimongb]

Im working with dbui for 3 month and there are only 2 things I'm missing to make it perfect replacement to dbeaver.
1. Need an option to group connections in folders or by env since I'm working with prod and staging instances and would be ideal to seperate them and know that I'm not running any dangerous sql on the wrong env. + having some color for prod like in DBeaver where any connection type can have specific background color in the connections nav panel and also in the query tab title, it helps avoiding mistakes.
2. Maybe the most used feature in DBeaver (for me) is the option to copy the results from a query in a variety of formats, I mostly use csv and JSON but also SQL format which generates and INSERT command from the data in the resultset. When I need to send data to developers or create it in a different environments it is really making my life easier.
Still trying to decide if to solve it with autocmd or create some plugin. The first one should be possible by replacing the connection file stored by dadbod ui via a shorbut or command.
The second one should be also possible by running some python script on the tmp result .dbout file and convert it using pandas... Just didn't have the time to do it yet.

Great video and great to see another hhkb user.

[ronitgandhi]

Nice quality of videos. Getting to know new tools and techniques by your videos. If you take a little suggestion then i think it would be great to watch a day-to-day activities of devops. Part 2 of kubernetes tools or devops, because in the kubernetes video of yours i found many tools that were very much good but never heard.

[AScribblingTurtle]

Thanks, this is super helpful. Until now I have relied on MyCli (for autocompletion) and TMUX to kind of combine it with NeoVim. Having the Database management directly in Vim will make things so much easier. Thank you. ❤

[iduran]

Awesome! Thanks a lot for sharing a very nice workflow and plugins for working with databases. Those plugins were completely new to me! Btw, I hope you start making dev tutorials as well, of course using neovim.

[colemichae]

The best video on this explains each plugin easily and WOW love it just been doing Dbstuff from the command line :)

[yashshinde]

I recommend using cli tools provided by a few database platforms that open a database preview inside the browser. Ex- supabase, prisma, etc. Have this feature

[nkodoko]

the story was 🔥! Nice job. And man, I wish I knew about this plugin 2 years ago...

[nerik]

You just made my life 10x easier, many thanks to you and the plugins devs

[thehibbi]

Hahaha, the intro is literally gold ^^

[garciajero]

hahahah the intro, you went for it this time!

[kriscpg]

FINALLY! been using an external DB client and it's been absolutely horrible. Nice to know there's a nvim solution

[_ryan]

Amazing! Thanks for sharing, I am excited to start using these plugins in my own configuration, great video keep up the good work 🙂