Wow look at all the things that are baked in here. Can't imagine creating all these small details and have them work as well as they do on your IDEs. Very well done!
Wow, I'm impressed. I had a brief look at DataGrip a while ago, and was overwhelmed and stuck with simpler tools. No more! You just have to put the time in to learn how to use the epic JetBrains suite. This stuff makes the rest look like kids on training wheels.
Awesome video, thank you for all the effort. I have not yet fully replaced visual studio/ssms with jetbrains tools yet due to the lack of sqlproj support, or some easy way to migrate from sqlproj (may be possibile but the documentation on such a thing is slim) but have been beyond excited after hearing about the intention to add support. Many of us will likely watch parts of this video multiple times due to the productivity gains datagrip has the potential to provide
"I press 'do refactor' ... (12:25) ... hard to follow screen sometimes, but with each step vocalized, and at least know what to look for. Extremely helpful video for new users.
Coming from SQL Server management studio, this is a huge upgrade! Especially how you can share data between sql languages. Question. Is there a way to generate an alter version of an existing routine/store-procedure instead of create?
Hello, i have some problems with testing the connection, what can i do? DBMS: PostgreSQL (no ver.) Case sensitivity: plain=mixed, delimited=exact Connection to localhost:5433 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Hi. What does the JDBC connection string for this data source look like? Are you able to connect to the DBMS using SQL Shell (psql)? Are you able to `telnet localhost 5433` from the command line?
I'm using CLion instead of DataGrip, but when using the SQL Generator clicking Save after picking a path and layout does . . . absolutely nothing. A bit annoying to put it mildly. Edit: works fine with DataGrip, so it must be a CLion bug. Edit2: Seems to be fixed with 2022.1.1
I've using SQL Server Management for years. I just watched some parts of this video and I installed DataGrip. I'm pretty sure that I won't look back...
i use 2016 version, and i really love that version, but i need to upgrade to a beast machine to run two jetbrains softwares side by side (webstorm and datagrip)
One thing that I didn't get is that when you write SQLs in the console how can you save your work? i.e. you can write tons of SQL code in there and then accidentally close the tab. Do you loose your work? I expect to be a file inspector where you see your stored file
Console instances are saved automatically whenever you type something in it. You can see them as files under consoles - Database Consoles in Files view. You can check your consoles either in Recent Files (Ctrl + E) or under Services showing the consoles tree based on your data source.
Hello! We've checked and verified that Naming the result tabs feature works correctly. However, if you happen to encounter any issues, it would be greatly appreciated if you could create a ticket in our task tracker: youtrack.jetbrains.com/issues/DBE. This will enable us to provide you with direct assistance and resolve any problems you may be facing. Thank you!
Hi Patrik, Is this happening for all database objects of your data source where you attempt to view the diagram via Show Visualization? What is your current DataGrip version? We'd encourage you to create a support ticket so we can analyze your issue in greater detail.
Hi, I cant connect database. I have take error "Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections." does anyone have an idea
3:37 Welp. I was looking for a way to copy a datasource WITH the password -.- I get the safety concern. But please allow for easy transferring of certain non-critical connections within a team without sending other people on a quest for a password.
The session handling in Datagrip is really garbage. You can configure whatever you want, but in the end a pop-up always appears somewhere asking which connection should be used. Even if you have already stored configurations in the project settings. I prefer to stick with Navicat.
Hmmm.... Why the hell is the "script"-file execution-result displayed in "services" and not in the top window like other queries? Why has Jetbrains - again - deleted all my db sources, files etc. after Updating? Can you imagine how much work this is? Why does Jetbrains need dozens of folders to store "configs" in (~/.jetbrains, ~./data-grip, ~/AppData/local, ~/AppData/roaming...)? What is the diff between scratches/files/consoles/queries? Why can i config a "project-dir" which i always must search by hand (again and again and again)? Until 2020.2 DG was a really cool DB-Tool - but featurities and marketing made it broken ....
Nice preview, but useless in details. Sqlite3 can't use db file via SSH. Simple it won't connect, even if SSH test works fine. Visualization is fine, but in big DB you are lost, because you can't easilly pick table with relations in separate tab and organize (even free DBever can do in one click!)... aso. DataGrip can be fine as just another free software with paid bonuses. Nothing more than MySQLWorkbench, DBeaver and such sw can do too, but for free or donation.
Do these interactions with the DB in Datagrip affect the codes in your platform (PHP) Script? In other words, I may need to ensure that changes made in Datagrip are also in harmony with Scripts in IDE?
@@maximsobolevskiy5595 Connection with a DB is initiated by the Script (PHP). Queries, often dynamic, are also determined by the Script. They may conflict with the changes manually implemented in Datagrip! I am just wondering.
All I want is a toolbar where I can assign a stored procedure to a click button. In Microsoft world, such an idea is blasphemy that will get you ex-communicated; they only do conquering the Universe.
Wow look at all the things that are baked in here. Can't imagine creating all these small details and have them work as well as they do on your IDEs. Very well done!
Thanks so much 😊
Thank you DataGrip team for your great demonstration video with such a powerful tool you have to know how to use its full features.
Wow, I'm impressed. I had a brief look at DataGrip a while ago, and was overwhelmed and stuck with simpler tools. No more! You just have to put the time in to learn how to use the epic JetBrains suite. This stuff makes the rest look like kids on training wheels.
Thanks for your feedback!
Thank you so much for this thorough overview, today completes my transition from Aqua Data Studio to DataGrip!
I have been CLI user with various databases for over 20 years. Now there is a tool that is worth switching to. Thx!
There are few videos about datagrip. Although I am actively using the software, I learned a lot of new things. Thanks.
3:34 amazing, thats why i love datagrip and its autocompletes
Would like all tutorials be like this. good job.
Awesome video, thank you for all the effort. I have not yet fully replaced visual studio/ssms with jetbrains tools yet due to the lack of sqlproj support, or some easy way to migrate from sqlproj (may be possibile but the documentation on such a thing is slim) but have been beyond excited after hearing about the intention to add support. Many of us will likely watch parts of this video multiple times due to the productivity gains datagrip has the potential to provide
We're working on sqlproj support now
@@moscas85 i cannot wait! Love the tools, just still trying to figure out the best way to use them
Really well done! DataGrip is awesome :-)
Wow this is amazing, well done. When SQlproj is available then I can switch off VS completely!
Very helpful walkthrough! TY
Thanks!
This is literally awesome.
DataGrip makes writing SQL to the next level 🔥
Thanks!
as someone fairly new to SQL, it's just insane how powerful this software is.
as someone fairly old to SQL, it's just insane how powerful this software is. 😉
Wonderful tutorial and walkthrough, what a tool!!!!
this is pure gold.
Thank you bro very good tutorial
comments in console to name result tabs, recognition of CamelCase! (13:40) -- pretty great!
Loved this tutorial 🔥
Thank you 🙌
"I press 'do refactor' ... (12:25) ... hard to follow screen sometimes, but with each step vocalized, and at least know what to look for. Extremely helpful video for new users.
At the bottom-left corner of the screen.
love it
What an amazing tool🎉
lol why have I been using SSMS.
24:19 WTF, this is amazing!
Too bad I only found out about this now haha
Coming from SQL Server management studio, this is a huge upgrade! Especially how you can share data between sql languages. Question. Is there a way to generate an alter version of an existing routine/store-procedure instead of create?
Hello, i have some problems with testing the connection, what can i do?
DBMS: PostgreSQL (no ver.) Case sensitivity: plain=mixed, delimited=exact
Connection to localhost:5433 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Hi. What does the JDBC connection string for this data source look like?
Are you able to connect to the DBMS using SQL Shell (psql)?
Are you able to `telnet localhost 5433` from the command line?
POPPIN OFF
I'm using CLion instead of DataGrip, but when using the SQL Generator clicking Save after picking a path and layout does . . . absolutely nothing. A bit annoying to put it mildly.
Edit: works fine with DataGrip, so it must be a CLion bug.
Edit2: Seems to be fixed with 2022.1.1
아주 좋아요!!!!
감사합니다!
Thank you for the demo. I was just wondering what theme is being used here?
Dark Purple
@@maximsobolevskiy5595 I resentlly switched to it too
Looking for a theme that is light & sparse (while not wanting to go extreme with high contrast)? Try eclipse light
I've using SQL Server Management for years. I just watched some parts of this video and I installed DataGrip. I'm pretty sure that I won't look back...
Thank you!
I can't believe I say down and watched a 40 minute "tutorial" Anyway, great tool!
Divide it into several parts :)
@@moscas85 Its already divided into several parts by youtube
24:17 Modify table: Why is reordering the columns not working?
It is not supported by the database
i use 2016 version, and i really love that version, but i need to upgrade to a beast machine to run two jetbrains softwares side by side (webstorm and datagrip)
datagrip is only a thin layer on top of the database plugin you get for webstorm.
So you may not need 2 tools
How come creating a new folder is so difficult in datagrip, please make it easier
Pressing F6 isn't super difficult, is it?
@@moscas85 it's unintuitive to be hidden from the + sign
This is 2 years old, can we get a new version with all the new feature ❤🎉?
Yes, we will do it, but perhaps it will be an additional video not to repeast all this
One thing that I didn't get is that when you write SQLs in the console how can you save your work? i.e. you can write tons of SQL code in there and then accidentally close the tab. Do you loose your work?
I expect to be a file inspector where you see your stored file
Console instances are saved automatically whenever you type something in it. You can see them as files under consoles - Database Consoles in Files view. You can check your consoles either in Recent Files (Ctrl + E) or under Services showing the consoles tree based on your data source.
Tab naming (in DataGrip) doesn't work. Still get 'Result xxxx'😥
Hello! We've checked and verified that Naming the result tabs feature works correctly. However, if you happen to encounter any issues, it would be greatly appreciated if you could create a ticket in our task tracker: youtrack.jetbrains.com/issues/DBE. This will enable us to provide you with direct assistance and resolve any problems you may be facing. Thank you!
Please share a screenshot
25:39 - Generate DDL files for the schema - I am able to generate files, but they are NOT saving to my local disk.
Show the Live Template List in Windows: Ctrl - j.
Hi, how to disable index update when datagrip is opened? Because it takes a long time. Thank you.
On opening, it reads files from disk. For how long does it take for you?
wow
Is there a feature like Microsoft management studio’s diagram to sql code i mean i want to create with diagram then it will generate queries for me?
There's no feature like that. We believe that using the coding assistance will always be faster than building the diagram.
@@maximsobolevskiy5595 thank you for reply
Is it possible with Datagrip to create visualizations similar to EER diagrams in MySQL workbench?
It is possible: 03:21
Can you debug Postgresql stored procedures from within DataGrip?
Not yet: youtrack.jetbrains.com/issue/DBE-4377
3:21 Showing diagrams no longer works for me in Intelij (it's grayed out), how can one find what's the problem?
Hi Patrik,
Is this happening for all database objects of your data source where you attempt to view the diagram via Show Visualization? What is your current DataGrip version? We'd encourage you to create a support ticket so we can analyze your issue in greater detail.
@@JetBrainsTV Thank you for the reply. For some reason the built-in "addon" Diagrams, had been disabled. Now it's working again.
Thanks for the update, good to hear it's working now.
Datagrip is indexing the entire here, anyone knows how I limit this indexing only to the sql files folders? thanks
So the thing is you have many folders attached, but you want just some of them to be indexed?
Hi,
I cant connect database.
I have take error
"Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."
does anyone have an idea
What database is it?
CMD+G on Apple is Control+J on Windows. Alright.
15:08 I would like to see this editor more like jupyter notebook
What do you mean precisely?
3:37 Welp. I was looking for a way to copy a datasource WITH the password -.- I get the safety concern. But please allow for easy transferring of certain non-critical connections within a team without sending other people on a quest for a password.
Hi! Is anybody who switched to DG from SSMS? Everything is Ok or there is a desire to return back to SSMS?
what is the corresponding theme for Intellij idea?
Dark Purple. Please download it as a plugin.
@@moscas85 thank you so much. 😍
Great video...but whats the theme ?
Dark Purple. You can download it as a plugin.
The session handling in Datagrip is really garbage. You can configure whatever you want, but in the end a pop-up always appears somewhere asking which connection should be used. Even if you have already stored configurations in the project settings. I prefer to stick with Navicat.
Agree! We will drastically simplify this in future releases. There will be no such pop-up soon.
SQLSERVER's Explain plan diagram is better than datagrip.
Datagrip is so advanced that should be marked as an illegal weapon
Với server có nhiều database, nhiều table thì load cực lâu, chờ mỏi cổ
What database do you use?
@@maximsobolevskiy5595 im use MS SQL Server
@@maximsobolevskiy5595 im use MS SQL Server
Hmmm....
Why the hell is the "script"-file execution-result displayed in "services" and not in the top window like other queries?
Why has Jetbrains - again - deleted all my db sources, files etc. after Updating? Can you imagine how much work this is? Why does Jetbrains need dozens of folders to store "configs" in (~/.jetbrains, ~./data-grip, ~/AppData/local, ~/AppData/roaming...)?
What is the diff between scratches/files/consoles/queries? Why can i config a "project-dir" which i always must search by hand (again and again and again)?
Until 2020.2 DG was a really cool DB-Tool - but featurities and marketing made it broken ....
Please clarify the point one.
How we get password
It is for your db admin to manage that
Nice preview, but useless in details. Sqlite3 can't use db file via SSH. Simple it won't connect, even if SSH test works fine. Visualization is fine, but in big DB you are lost, because you can't easilly pick table with relations in separate tab and organize (even free DBever can do in one click!)... aso. DataGrip can be fine as just another free software with paid bonuses. Nothing more than MySQLWorkbench, DBeaver and such sw can do too, but for free or donation.
Do these interactions with the DB in Datagrip affect the codes in your platform (PHP) Script? In other words, I may need to ensure that changes made in Datagrip are also in harmony with Scripts in IDE?
What changes do you mean? Refactorings?
@@maximsobolevskiy5595
Connection with a DB is initiated by the Script (PHP). Queries, often dynamic, are also determined by the Script. They may conflict with the changes manually implemented in Datagrip! I am just wondering.
@@NedumEze if I get you right, DataGrip cannot track changes in your dynamically built SQL
@@maximsobolevskiy5595
Yes, I am asking the question. Whether Datagrip tracks Script codes?
@@NedumEze Sorry, it is still not very clear. What codes? Where? Please give an example.
What? No Lotus Notes option? lol
Консоль запросов на максималках. 1сники поймут
All I want is a toolbar where I can assign a stored procedure to a click button. In Microsoft world, such an idea is blasphemy that will get you ex-communicated; they only do conquering the Universe.
Post-gresssssssss-Q-L !!!
It has never been Postgre!
19:16
Yes, that' very powerful!
I should probably watch this since I think this is the least intuitive software I've ever encountered for databases...
What makes you feel this way?
Yes, we will appreciate the details about that