Do you actually use a dedicated SQL IDE? I'd be curious to know why, if that's the case! BTW, this shortcut also works great for Python if you want to avoid relying on Jupyter notebooks.
Pretty good video, I'm one of those who started using DataGrip, then switched to DBeaver. But this video really makes me rethink the option to get rid of it.
I am working in Jetbrains IDEs (mostly Rider), and it became my go to SQL tool also. It can do anything you want, it even checks the SQL you write in C# or Python or whatever. It also has a killer feature I haven't seen anywhere else - a green box. When you put your cursor on any SQL, it will draw a green box around the stuff that will be executed. No more "I forgot ; at the end, so I also dropped the db" - it's awesome
@mehdio i didn't really like vscode or eclipse. I got it when i was in school for Database Admin and Big Data; I was using Jupyter Notebooks with Oracle Database. I only paid for a year and canceled my subscription (not really into subscription if im only using it to learn) after playing with the trial.
I need the production DB connection to be on a separate program so under no circumstance I execute something that I shouldn't 😂 Plus proxy configuration, credentials stored securely, browsing the schemas and tables etc.
Browsing schemas and tables is one thing, but you could still do these through commands right ? I think one valuable thing is rather autocomplete on table + columns names when writing queries.
Getting started with Lazyvim was super easy. Then I was playing around with dadbod-ui for sql queries etc. Honestly will probably just map the same "send sql to terminal" command you use though
Do you actually use a dedicated SQL IDE? I'd be curious to know why, if that's the case!
BTW, this shortcut also works great for Python if you want to avoid relying on Jupyter notebooks.
Pretty good video, I'm one of those who started using DataGrip, then switched to DBeaver. But this video really makes me rethink the option to get rid of it.
I am working in Jetbrains IDEs (mostly Rider), and it became my go to SQL tool also. It can do anything you want, it even checks the SQL you write in C# or Python or whatever. It also has a killer feature I haven't seen anywhere else - a green box.
When you put your cursor on any SQL, it will draw a green box around the stuff that will be executed. No more "I forgot ; at the end, so I also dropped the db" - it's awesome
I like DataSpell, but it's for Jupyter Notebooks and does support DB.
Wow, first time I heard a DataSpell user! Any reason why DataSpell over anything else ?
@mehdio i didn't really like vscode or eclipse. I got it when i was in school for Database Admin and Big Data; I was using Jupyter Notebooks with Oracle Database.
I only paid for a year and canceled my subscription (not really into subscription if im only using it to learn) after playing with the trial.
I need the production DB connection to be on a separate program so under no circumstance I execute something that I shouldn't 😂 Plus proxy configuration, credentials stored securely, browsing the schemas and tables etc.
Browsing schemas and tables is one thing, but you could still do these through commands right ? I think one valuable thing is rather autocomplete on table + columns names when writing queries.
My dude, you are so close to moving to Nvim ;)
Ahah - ive been dreaming about it. If devcontainer is supported smoothly, I may do the jump
@@mehdio Do it! There are a few plugins, videos and blog posts about how to do this though I don't need it myself so haven't tried them out :)
Getting started with Lazyvim was super easy. Then I was playing around with dadbod-ui for sql queries etc.
Honestly will probably just map the same "send sql to terminal" command you use though
"you don't need a fancy IDE". You lost me at "the first thing we're going to do is open VSCode"
If you had stayed 2 more seconds, I said that the strategy works with any coding editor. Worked with just a terminal, tmux and vim too!
for example java in vscode is not really ideal comparing with intellij