You Don't Need MySQL Clients Anymore! You Can Use VSCode Instead
HTML-код
- Опубликовано: 21 июл 2024
- If you are a VSCode developer like Me, well, you'll need to know this awesome extension that will make MySQL/MongoDB or PostgreSQL useless and will make you love using VSCode to access, manage and manipulate your databases without the need of the CLI or using custom software clients like (MySQL Workbench, MongoDB Compass or PGAdmin). This extension supports so many types of databases so you can have access to all your databases and debug data right from VSCode without leaving it or needing to learn and use another ugly software to view the data on the tables or even creating advanced views for joint tables or whatever you think you can do with SQL/NoSQL.
⭐ Timestamps ⭐
00:00 Intro
00:56 Why using VSCode to access your databases is much better?
05:37 Adding new Database connection (MySQL, PostgreSQL...)
06:17 Writing SQL Queries and Altering Tables
09:31 Database & Table Management inside of VSCode
10:45 NoSQL Databases too (MongoDB)?
💻MySQL Extension for VSCode:
marketplace.visualstudio.com/...
🧭 Watch Tutorial on Designing the website on Figma
• I Design a onecolor We...
🧭 Watch Create a Modern React Login/Register Form with smooth Animations
• Create a Modern React ...
🧭 Debug React Apps Like a Pro | Master Debugging from Zero to Hero with Chrome DevTools
• Debug React Apps Like ...
🧭 Master React Like Pro w/ Redux, Typescript, and GraphQL | Beginner to Advanced in React
• Master React Like Pro ...
🧭 Learn Redux For Beginners | React Redux from Zero To Hero build a real-world app
• Debug React Apps Like ...
🧭 Build Login/Register API Server w/ Authentication | JWT Express AUTH using Passport.JS and Sequelize
• Build Login/Register A...
🧭 Introduction to GraphQL with Apollo and React
• Introduction to GraphQ...
🐦 Follow me on Twitter: / ipenywis
💻 Github Profile: github.com/ipenywis
💡 My Blog: ipenywis.com
Made with 💗 by Coderone
Thank you! You're a life saver. You have no idea how much this shady dev charged me just to access my own DB. I am so happy
godlike extension!
I was struggling getting a client working on my machine it was driving me insane
Thank you :)
Wow!!! Damn I'm impressed! Thanks for such an awesome video!
Sequel is still in the market and improving massively even after 50 years.
Nice extension! Very handy indeed. The count next to table images showed 5, but the result showed 6 rows. Tiny bug
interesting layout on that extension.
i havent get any good extension for SFTP on vscode.
any recommendation?
I was a little stunned for awhile, you should be saying workbench, GUI interface on your title. Anyway, this is a nice video and thanks for sharing it.
Client is correct chief
Nice extension. Anyone has any idea on how does this compare to the SQLTools extension?
My favorite RUclipsr at the moment. Love your videos!
Until you decide to build your workflow from the ground up based on your personal needs and use VIM and get dadbod and hate the days you wasted on Vscode 🤷🏻♂️
@@MiguelLopez-mu1ss can‘t wait to get to this point :D
Does anyone know how this behaves querying large amount of data?
Hola, Cómo podría importar y anexar datos a una tabla. He buscado la opción y no lo pude encontrar.
Hi! your vscode theme (like how your file icons in file explorer panel) looks sick! how do you do it?
That is so cool. I just start learning MySQL queries and the person who is teaching said download pop SQL but then I thought why not use VScode that I am already familiar with, so I searched for it and got your video. it looks pretty cools. I will share my experience after using it.
so how was your experience bro??
Thank you so much. That is awesome!
Which color theme are you using?
Thank you very much. This is a new information for me.
Quite impressive, thanks for sharing!!!
Please show me how can I import an export data file in VS code
I don't know what the issue is with the title, but everyone seems pretty upset. Unless it's changed since this was originally released? As of the time of this comment the video title reads "You Don't Need MySQL Clients Anymore! You Can Use VSCode Instead". This makes perfect sense with what the video is about. You don't need "Clients" anymore, which are separate programs from the databases themselves, and people seem to be missing that point in the comments. The DB engines are still awesome, and still required, but the management tools (clients) are now integrated into VSCode. The title reads correctly and the video is as advertised.
Because the video title doesnt make sense that’s why i clicked on it. After seeing the first 30 seconds, i get now what he’s trying to say. It’s VS Code *as* MySQL client.
Still, pretty cool stuff.
First off "client" isn't really the right word. "client" doesn't mean "database management tool". Even if it were the right word, he would still be using it wrong. It's not that you no longer need a MySQL "client", VS Code + whatever extension is a "client". At one point he says something much worse: "you can use VS Code instead of MySQL". I want to say in response that words escape me, but that applies more to him.
@@stilldreamy5181 with this extension (plugin) installed, and acting as a "client", it then helps to save some time, by not having to toggle back and forth between VSCode and the preferred "DB Management Tool", be that another application, or logged in to the server on a webpage. It then helps to improve the efficiency of writing proper connect statements. An improvement in the older days of Notepad++, Notepad, or whatever standard text app one uses.
For someone that only uses one server source and type, it may not make that big a difference. However, if you have need of accessing to multiple servers, of different types, then this extension will definitely help consolidate that list.
As I've noted a nice feature that's been refined in VSCode itself, are the checks and balances amongst pages that have related data, to help correct any errors. 04-13-2023 0400 PT
can we import csv file data into our database using this extension?
Can i run Operate Mysql and SQL server ( MS SQL Management Studio ) on the same Laptop ?
This is awesome. I despise using the pg admin 😩
I ran in to problems with mongo db connect. Even though you can remove the 2000 limit, its still going to limit when you right click and press the entire collection.
you can use the official mongo db extension
Never Knew VSCode is this versatile!
Thanks!
Nor did I. And I just got back into web designing after about 4 years, having been the old ways of Notepad, then Notepad++. As I started watching Dani Krossing again, on his updated full length tutorials on website creation, it took me a few minutes to try and figure out that the program he is using, is VSCode. A definite game changer, especially over those programs that have bootstrap from about 5 years ago. A lot more flexibility for customizing a site, with less errors, or risk of errors. 04-13-2023 0344 PT
Can I connect to oracle database?
been watching mysql videos for days now wondering if its something i should learn rather than relying on my now sluggish excel file. Regardless I have no idea what you are talking about but feel like im learning something and enjoy your videos
This is incredible!
Personally not a big fan of sql extension in vscode. If a query is taking time, it can make the vscode stuck or slow loading. It is web editor so I try to keep it as lite as possible
This extension is good, but how can I turn off this error code the output keeps giving me.
Execute sql fail : SELECT datname "Database" FROM database name WHERE datistemplate = false order by datname ASC;
permission denied for table database name
how do you see the diagrams
can use it if my source file excel?
how do you initialize a db with vscode?
Please make a video on how we can connect the databases
Hi there,what about snowflake connections ?
yeah, i also use that extensions at my vscode and takes more RAM usage but it's worth
Thanks for the Great Show!!!
Looks amazing, but does it offer intellisense for table names columns etc?
Yes.
Why would anyone give this a thumbs down. My God this world is so sad.
Thanks for posting the content!!
It's actually good for the algorithm. The video ranks higher if there are not only thumbs up :)
Probably because the title is misleading. He actually meant MySQL workbench.
@@ziad_jkhan Yeah, I thought by the title there would be no DB engine... just VS Code to hold the data!
@@ziad_jkhan as I see it on 04-13-2023 0374 PT, the title is "You Don't Need MySQL Clients Anymore! You Can Use VSCode Instead". And though MySQL Workbench is the mainstay, currently within version 8, depending on the person's preferred OS, there are likely other programs (clients) out there for Unix / Mac / M$. So to me, it's not misleading.
Which theme is he using?
Why not use dbeaver?
Does it have http connector?
This IDE Becoming a beast🥰
Good title i thought mysql is gone when i read your title thanks look like everything is in vscode to day thanks i think we should practice laziness
Well..its a bit misleading..u still need the database..but not for example workbench..
The title says CLIENT. That is what a client is, an interface to interact with the SERVICE.
@@newmonengineering yeah now it says client..didnt originally
Its paid now do you have other extension like this to suggest or is the premium version is much better? i would love to support the developer if its the latter workbench lag the heck my laptop.
I found it "free" at version 6.3.7 as of 04-13-023 0325 PT. Same developer: cweijan (Weijan Chan)
Nice find
You are a life saver
In the beginning, when he was like “how cool is that!?” I (alone in my appt) blurted out “that’s f****n’ cool!!” ❤️ vsccode
I'm getting this error " Access denied for user 'root'@'localhost' (using password: NO)".
Can Anybody help me?
I have the same issue - did you find the solution? :D
no
He means there is a MySQL database management extension for vscode.
Thank you pal
Whats the name of the extension for the mongoDB ?
Everything is inside one extension. You don't need separate extension for this.
Please change the video title, it's completely misleading!
They called Database clients not MySql as you you use them to connect to database servers.
I like your videos
Otra razón para usar VSCode 👌😁
Thumb down for click bait
Indeed it's not a click bait, title says no need for database clients, but still you need database servers, however video is not worth to watch to learn about a vscode extension which does same job as every database clients
only need client to make backup and restore, this plugin can`t work correctly.
Thanks
I can't connect, someone may help me?
Plz. I wanna learn it. 🤦🏻♂️😭🙏🏻🙏🏻
What error are you getting?
這太好用了 竟然可以用ssh tunnel
Vscode is the best thing happened in the coding world
Do you mean the DB client tool?
Yes, vs code extension.
i fucking love you man u solved my problem
Sorry but developer say this "This project is no longer maintain for free and requires payment to unlock all features."
i DIDNT FIND THIS EXTENTION
Title You Don't Need MySQL Anymore, meanwhile shows u cant without MySql lol
And this is the level of upcoming developers 😂
Yeah)) like me 😂
@@shamilAliyev92 well... If you don't know the difference between MySQL and Visual Studio.... 🤷
@@yuriysemenikhin302 what you on about ?
Neet overview.
So this extension is called MySQL?
yes.
Only open one table or collection. tables not short by name :|
de-sssing is necessary for this vid )
Great
Ah yess, the click bait title
you should be explicit that you are using vscode to deal with database management and not to provide a database itself as the video title suggest
VS Code has gone further than what it meant to be. You can replace postman with it LOL
Bloat isn't always a good thing. Nor is having all your eggs in one basket.
@@tentaklaus9382 Options are.
助かった
I downloaded it but I am not gonna do the paywall. Gonna stick with the free sql on vscode instead
Misleading title....
Ah the title is confusing
Intellij has best db client
Why did you have to ruin your video with this title?
this extension is no longer free!
Or since you are making money with the editor. Spend a little and but one that has the database components built in like phpstorm.
😍
wow, could be condensed into 1 min video
What about security? You give all your db password to this extension… Think about that 🤦🏻♂️
so you mean there is AJAX call which passes you credentials to creator of extension... :}
Are you wrestler ?
Please just go straight to the point in your next video. Thanks a bunch!
oh it's not free anymore. i guess the author got wise.
Docker is better
U don't need mysql.
Ok,thanks 😒
Yea, who needs to know how to optimize queries...
explain "sql query " . command prompt /terminal but mostly depend on your database structure, the best create history table horizontal or some call it materilize view not live for statistical purpose
@@rebelsdeveloper367 You are rebelling against everything or just an effective DB architecture?
@@maxa8836 hmm? we rebel on slow thing. we want fast2 thing but people need to understand computer also not superman so stil has pro and con limitation in action
Boo
You may think that kind of clickbait title is worth it but I am not sure it will help your rep in the long run. I don't know you but I know you are either ready to say about anything to grab attention or missing some basic technical knowledge. And I don't think it is the latter. Either ways it makes you look more like a clown than a worthy source of information. :D
Dude, we could have just said that people that use Vs Code can get a better experience and one less program to use.
Because the explanation was ridiculous. "you can do a query in vc code and is so simple. In Workbench so complicated to write down"
Are you kidding me? It's an interface easy as VS Code....
Trying to denigrate other programs to your video look cooler, is just rubbish.