PhpStorm 2019.3 EAP build 193.4778.21 is now available!
This EAP build introduces WSL support. It also includes fixes for PHP and the latest updates from the WebStorm and DataGrip teams and the IntelliJ Platform.
What is better PhpStorm or DataGrip? If you wish to have a convenient way to decide which IDE Software product is better, our unique method gives PhpStorm a score of 8.9 and DataGrip a score of 8.9 for total quality and performance. Moreover, PhpStorm is rated at 99%, while DataGrip is rated 96% for their user satisfaction level. Some of the key DataGrip features include: Support for MongoDB, MySQL, PostgreSQL, and other databases. A powerful data editor that lets you modify data rows and navigate through data quickly. Coding assistance for queries similar to the one you get for your projects in WebStorm. Reset Intellij IDEA, WebStorm, DataGrip, PhpStorm, CLion, PyCharm, RubyMine, GoLand and Rider evaluation (2019 / 2020 / Mac OS) - liuxyCN/jetbrains-reset-trial-evaluation-mac. A cross-platform IDE that is aimed at DBAs and developers working with SQL databases. DataGrip is a tool in the Database Tools category of a tech stack. Remove/Backup – settings & cli for macOS (OS X) – DataGrip, AppCode, CLion, Gogland, IntelliJ, PhpStorm, PyCharm, Rider, RubyMine, WebStorm - README.md.
Download PhpStorm 2019.3 EAP from the EAP page or via the JetBrains Toolbox App. Or, if you have the previous PhpStorm 2019.3 EAP build installed, you should get a notification in your IDE about a patch update soon.
WSL Support
WSL (Windows Subsystem for Linux) is a compatibility layer for running Linux binary executables natively on Windows 10. PhpStorm will now support developing in a WSL environment, which is when you have launched your IDE on a Windows machine, but you target WSL/Linux in your development. You’ll be able to specify a remote PHP interpreter in the WSL and use it for running scripts, tests, Composer commands, and debugging.
- To get started, make sure you have installed the WSL on your Windows 10 machine, and the Linux distribution of your choice. See the installation guide.
- Depending on the distribution you may have PHP already preinstalled. If not, you’ll have to install it manually via the command line. For example in Ubuntu you can run something like this:
sudo apt update
sudo apt install php php-mbstring php-dom php-xml php-zip php-curl php-xdebug - When you have PHP in your WSL environment you’re ready to set up PhpStorm.
- Add a CLI interpreter under File | Settings | Languages & Frameworks | PHP
If you don’t see the WSL option in this dialog, it means you have no WSL installed. Check the previous steps.
You’ll see the list of WSL distributions that are installed and you may add as many interpreters as you wish.
And that’s it! Now you can specify this interpreter for running tests, Composer, or for other run-configurations that you have.
Let us know what you think of the WSL Support in PhpStorm! What would you like improved or added?
Better plugin management
Tired of restarting PhpStorm every time you add or remove a theme? The upcoming PhpStorm 2019.3 will allow you to install, uninstall, enable, and disable a theme plugin without restarting the IDE.
The keymap plugins also don’t need the IDE to be restarted anymore to work.
For the full list of changes in this build, please see the release notes.
Check out previous EAP blog posts for more updates and added features:
Please report any problems to our issue tracker or comment on this post. Your feedback is much appreciated!
Your JetBrains PhpStorm Team
The Drive to Develop
We’ve released our last EAP build before the official release of DataGrip 2021.1. Let’s see what’s new.
Context live templates
This is our solution for anyone wanting to generate simple statements straight from the database explorer. While general live templates cover many cases where you need to write a simple query quickly, we also understand that sometimes, when you are in the context of the database explorer and you are already focusing on the object you need, there is a better way to get a simple query using that object.
And of course, many other tools use this mechanism for reducing repetitive work, so many newcomers are already used to it.
We’ll start with a short video that shows how it works:
Every code snippet in this list is actually a live template, but they are all special ones that can be generated in the context of the chosen object. For example, let’s look at the template Select first N rows from a table.
Open the live templates setting and locate the template you need:
As you can see, it looks like a general template (and can be used as such). Since this particular syntax cannot be used in all databases, the corresponding dialects are set for the template. The major difference that makes this template applicable in the database explorer is the special expression dbObjectName which is used for the $table$ variable:
Obviously, you can add your own templates or edit existing ones, which makes this feature customizable.
Adding grants to user
The Modify user window, which is called by Cmd/Ctrl+F6, now has a UI for adding grants to objects:
This is available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, SQL Server, and Sybase.
Data source templates for unsupported databases
From 2021.1 it’s easier to add the data source for databases we don’t support. We now provide JDBC drivers for AWS Athena, Informix, MemSQL, Presto, SAP HANA, and Google Cloud Spanner. Look for these databases in the Other section of the database list.
We’ve made some additional improvements:
- You no longer need to download the driver yourself and manually create a data source based on it.
- New versions of the driver will be provided by DataGrip.
- Some new databases have their own dedicated icons.
Please note that support for these databases is limited. It is mainly dependent on the abilities of the JDBC driver and the SQL:2016 dialect support of DataGrip’s SQL editor.
Change field type in MongoDB
To make editing more flexible, we’ve introduced the ability to change the type of a field using the UI. This can be done both in the context menu of the field and in the value editor:
You are welcome to give us feedback using our Twitter or forum. We also have a simple way for you to quickly report issues straight from DataGrip, click Help -> Report problem… to create a new issue in our issue tracker.
Phpstorm Vs Datagrip
Phpstorm Include Datagrip
Thank you,
Datagrip Vs Phpstorm
Your DataGrip team