This enables developers to make schema changes without the fear of dropping columns, locking tables, or causing downtime in your app. Important: PlanetScale does not allow create, drop and alter statements on production branches. If you don’t, please feel free to reach out to us here!Īnd you are ready to start using your PlanetScale database in DataGrip! Creating a table in PlanetScale with DataGrip # You can Test Connection in the DataGrip module.PlanetScale will only connect to a database over SSL. Since DataGrip is JDBC-based, it uses your system’s root CA certificate, so you do not need to fill in the CA file or any other file locations.
#PYCHARM DATAGRIP FULL#
In the SSH/SSL tab, make sure to check the Use SSL box and set the Mode to Full Verification. I like to use the following format: (), which would look like ecommerce-store (development). This makes it easier to identify the different branches you are working with in DataGrip. We recommend a name that includes what branch you are connecting to in PlanetScale. You will also need to give your database a Name in DataGrip.
Back in DataGrip, you will copy over the following information from your new password in the General tab: Navigate to the database and branch of your choice, select the Connect dropdown and Generate a new password. In PlanetScale, you can either create a new PlanetScale database or use an existing database. In DataGrip, go to File > New… > Data Source… > MySQL You will create a new Data Source in DataGrip and use the connection information provided by PlanetScale to have a secure connection. If you have connected to a database with DataGrip as a MySQL GUI before, this experience will likely be pretty familiar to you. Using DataGrip as a MySQL GUI for PlanetScale #
#PYCHARM DATAGRIP UPDATE#
Once you are ready to go live, non-blocking schema changes provide a schema change workflow that allows users to update database tables without locking or causing downtime for production databases. This enables experimenting with schemas in an isolated environment. Database Branches™ allow you to branch your database schemas like you branch your code. If you aren’t familiar with DataGrip, it is a popular, cross-platform IDE for databases that works nicely with PlanetScale databases.Īlongside DataGrip, you can manage your database changes easier with branching in PlanetScale.
Connect your PlanetScale databases and their branches to manage and run queries from JetBrains DataGrip in a few small steps.
0 kommentar(er)
