Mhoro! Ngatitarisei zvinhu zvitsva mu- . Ngatikuyeuchidzei kuti mashandiro eDataGrip anosanganisirwa mune mamwe maIDE edu akabhadharwa, kunze kweWebStorm.
Tsigiro yedatabase itsva
Mukuburitswa uku, dhatabhesi ina dzakagamuchira rutsigiro rwepamutemo mumidziyo yedu:
Apache Mukoko - dhatabhesi manejimendi system yakavakirwa paHadoop papuratifomu.
Greenplum -Ongororo DBMS yenzvimbo dzekuchengetera data yakavakirwa paPostgreSQL.
Vertica - columnar dhatabhesi yekuongorora kukuru kwedata.
Snowflake - Cloud data kuchengetedza. Kana tikataura nezve hukama dhatabhesi, ipapo Snowflake . Mukuburitswa uku takatsigira SQL chete, tichazoburitsa rairo gare gare.
Mukomboni
Isu takaita shanduko kune dhatabhesi yekubatanidza dialog box: takaedza kuita kuti ive yakajeka uye nyore.
General
Iyi tebhu yakanyanya kugadziridzwa.
munda Kubatanidza mhando aimbonzi URL mhando uye rakanga riri pazasi chaipo. Asi, sezvo kukosha mumunda uyu kunogadzirisa imwe nzira, ikozvino iri pamusoro.
munda Database yakaiswa mushure mekuisa yako yekuisa uye password, nekuti chokwadi chinodiwa kuitira kuratidza rondedzero yedhatabhesi na Ctrl/Cmd+Space.
Mune zvakataurwa kune yapfuura post kuchengetedza password. Isu takawedzera sarudzo nyowani uye takaita yekudonha-pasi rondedzero. Izvo zvakakosha zvechinyorwa ndeizvi:
- Usachengeta password.
- Chengetedza kusvika DataGrip yatangwazve (kare iyi ndiyo nzira iyo "usachengete" sarudzo yakashanda).
- Chengetedza chikamu: kusvika wabvisa kubva kune data sosi.
- Perpetuate.
Kuti udzivise kuvhiringidzika, isa password isina chinhu kuburikidza nemenu yemukati.
Mhinduro Test Connection zvave kuratidzwa pahwindo pacharo, hapana kuwedzera kudzvanya kana nhaurirano.
Uye kana vatyairi vasina kutorwa pasi, DataGrip ichapa kuzviita. Kare bhatani Test Connection yakavharwa munyaya iyi, iyo yakavhiringidza vashandisi.
Options
Settings dzatamiswa pano kubva kuGeneral tab Verenga-chete, auto sync, Transaction control.
Nyowani:
- Mhanya chengetedzo-chirikubvunza imwe neimwe N masekonzi: ichabaya iyo data sosi netsvimbo yega N masekonzi. Kune dhatabhesi dzatisingatsigire, unogona kunyora chikumbiro chekuchengeta uri mupenyu iwe pachako. Izvi zvinoitwa muzvirongwa zvemutyairi.
- Ini-kubvisa mushure meN masekondi: Kukosha mumasekonzi akaiswa pano kunoudza DataGrip mushure menguva yakareba sei kuti uzvibvise kubva kune data sosi.
- Kutanga script: Pano unogona kuisa mubvunzo unozoitwa pese panogadzirwa kubatana. Ngatiyeukei kuti kana Single connection
rudzi haina kugoneswa, kubatana kutsva kunogadzirwa kune yega yega console.
Schemas
Sefa yezvinhu zvaratidzwa mumuti yatama pano.
Navigation uye kutsvaga
Rondedzero yenzvimbo dzichangoburwa
Iwindo idzva renzvimbo dzazvino rinoratidza kwawakamboenda. Rondedzero zvinhu zvidiki zvidimbu zvekodhi zvawachangobva kugadzirisa kana kuona. Izvi zvinobatsira kana ukarangarira mamiriro acho asi usingayeuke zita refaira. Izvi zvinoitika zvakanyanya muDataGrip nekuti ese maconsoles anodaidzwa zvakafanana :) Iyo yekudimbudzira kiibhodhi nzira ndeye:
Ctrl/Cmd+Shift+E.
Kana wakamboshandisa nzira yekudimbudzira iyi yekhibhodi kuratidza runyoro rwemafaira achangobva kugadziridzwa, ikozvino ndapota tinya kaviri Ctrl/Cmd+E.
Tsvaga nenzira
Isu takabvisa zvisina basa sarudzo dzata "wana" kubva pachikuva: Module ΠΈ purojekiti. Iye zvino nekusarudzika Tsvaga munzira DataGrip inotsvaga kwese kwese. Takawedzerawo nzvimbo itsva yekutsvaga Akanamatira Directories - inosanganisira chete mafaera uye maforodha kubva kuFiles panel.
Zviito kubva mumibairo yekufambisa
Navigation results ikozvino inopa zviito zvinoshanda kune zvinhu zviri mukodhi kana muti. Somuenzaniso, uri kutsvaga tafura. Hezvino zvaunogona kuita kubva pahwindo remhinduro.
- Ona DDL: Ctrl/Cmd+B.
- Vhura data: F4.
- Vhura iyo Modify Tafura hwindo: Ctrl/Cmd+F6.
- Ratidza mune imwe mamiriro: Alt + F1 (semuenzaniso, ratidza mumuti).
- Ona ruzivo rwakakwana: Ctrl+Q/F1.
- Gadzira SQL: Ctrl/Cmd+Alt+G.
Kushanda nekodhi
Zvinhu zvakasanganiswa mukupedzisa otomatiki
nokuti CREATE ΠΈ DROP autocomplete inopa zvakasanganiswa sarudzo.
Usakanganwa nezve acronyms.
Kuongorora kutsva
DataGrip ichakuyambira kana uri kushandisa chitubu chisina kuvhurika.
Kuongorora kuviri kunotevera kwakavharwa nekukasira, asi vamwe vangazvida.
Kana ukashandisa nharo dzisina mazita, izvi zvichasimbiswa.
Kuongorora kunonyunyuta nezve GOTO chirevo.
Kushanda nemafaira
Yakawedzera marongero eiyo default purojekiti folda. Mapurojekiti matsva achagadzirwa mune iyi folda.
kushanda Sevha se... kune iyo console ikozvino:
- Inopa zano dhairekitori reprojekiti.
- Anorangarira sarudzo yekupedzisira.
Chiito chakawedzerwa pamuti wefaira Detach Directory: Bvisa faira. Pakutanga, kusunungura folda (kureva kuti, kusairatidza mumuti uyu), waifanira kudzvanya Kudzima, uye DataGrip yakabvunza: unoda kudzima kana kusapinira? Zvakanga zvisingaite uye zvisinganzwisisiki :)
Database tree
Isu takanyora yedu introspection yeDB2. Izvi zvinoreva kuti tinowana ruzivo nezvezvinhu zve database tichishandisa mibvunzo, uye kwete kuburikidza nemutyairi weJDBC, sepakutanga. Nokudaro, zvinhu zvakaonekwa mumuti izvo zvakanga zvisipo kare: zvinokonzera, marudzi, nzira, modules, counters, mabasa uye vamwe.
Muti unochengeta mamiriro: zita re data sosi rakanamira pamusoro.
Zvidhori zvakadhonzerwa madhatabhesi asina kutsigirwa: avo vane data masosi akagadzirwa kune akadaro dhatabhesi havachazovhiringika.
Isu takadhirowawo zvidhori zvidhori zvinogona kushandiswa mumagadzirirwo emutyairi.
Zorora
Custom themes
Vashandisi veDataGrip ikozvino vane kugona kugadzira chero ruvara chirongwa chavanoda. Iyo itsva scheme iplugin inofanirwa kuiswa kubva muchikamu Plugins muzvirongwa.
Verenga nezve maitiro ekugadzira ako matema pano:
.
Takaedza kugadzira vaviri vatsva isu pachedu. Vanotaridzika seizvi:
Cyan
Yepepuru yakasviba
Data editor
Iyo sefa inoratidza kukosha kubva pa clipboard.
Zvese!
- Tsamba tinoverenga: [email inodzivirirwa]
- Mhinduro dzatinoverenga βββ
DataGrip Team
Source: www.habr.com