You can create a free database to connect to DataGrip and try out PlanetScale today. Once you merge your changes in PlanetScale, your production database in DataGrip will automatically update with the changes. Lastly, when you are ready to use the table in your production database, learn how to make a deploy request to merge your latest changes to your database. I created a users table in DataGrip, which I can see in the Console (located in PlanetScale as a tab within your database branch) when I run the query: show tables Next, after creating a table in DataGrip, you can see your new table in the PlanetScale Console. Select Execute, which will create the table in your PlanetScale database branch.(Reminder: PlanetScale does not support foreign key constraints, learn how to operate without them here.) In DataGrip, right-click on your database name and select New.So if you want to create a table, make sure you are doing it in a development branch, not a production branch.įirst, create a table in DataGrip. 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 with safe migrations enabled. 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 #
0 Comments
Leave a Reply. |