Sawubona! Ake sibheke izinto ezintsha ku-
Ukusekelwa kolwazi olusha
Kulokhu kukhululwa, isizindalwazi ezine zithole ukwesekwa okusemthethweni kumathuluzi ethu:
Isidleke se-Apache - uhlelo lokuphatha i-database esekelwe ku-platform ye-Hadoop.
I-Greenplum - I-DBMS yokuhlaziya yezindawo zokugcina idatha ezisuselwe ku-PostgreSQL.
I-Vertica - I-database yekholomu yokuhlaziywa kwedatha enkulu.
Snowflake - isitoreji sedatha yamafu. Uma sikhuluma ngemininingwane yokuxhumana, bese kuba yi-Snowflake
Ukuxhumana
Senze izinguquko ebhokisini lengxoxo yoxhumano lwesizindalwazi: sizamile ukulenza licace futhi libe lula.
General
Le thebhu ngokuvamile yenziwe kabusha.
Insimu Uhlobo lokuxhuma ejwayele ukubizwa Uhlobo lwe-URL futhi yayingaphansi impela. Kodwa, njengoba inani kulo mkhakha linquma inqubo eyengeziwe, manje seliphezulu.
Insimu Database ibekwe ngemva kokufaka igama lakho lokungena nephasiwedi, ngoba ubuqiniso buyadingeka ukuze ubonise uhlu lwemininingwane egciniwe nge Ctrl/Cmd+Space.
Emazwaneni kokuthunyelwe kwangaphambilini
- Ungalondolozi iphasiwedi.
- Londoloza kuze kube yilapho i-DataGrip iqalwa kabusha (ngaphambilini lena yindlela "ungalondolozi" inketho esebenze ngayo).
- Londoloza iseshini: uze unqamule emthonjeni wedatha.
- Qhubeka.
Ukuze ugweme ukudideka, faka iphasiwedi engenalutho ngemenyu yokuqukethwe.
Imiphumela Ukuxhuma kokuhlola manje aboniswa efasiteleni ngokwalo, akukho ukuchofoza okwengeziwe noma izingxoxo.
Futhi uma abashayeli bengakalandwa, i-DataGrip izonikela ngokwenza kanjalo. Inkinobho yangaphambilini Ukuxhuma kokuhlola ivinjiwe kulokhu, okudide abasebenzisi.
Izinketho
Izilungiselelo zisusiwe lapha kuthebhu ethi Okujwayelekile Funda kuphela, Ukuvumelanisa okuzenzakalelayo, Ukulawula okwenziwayo.
Kusha:
- Qalisa umbuzo wokugcina uphila imizuzwana engu-N ngayinye: izonyakazisa umthombo wedatha ngenduku njalo ngemizuzwana engu-N. Ngemininingwane yolwazi esingayisekeli, ungazibhalela wena isicelo sokuthi ungaphila. Lokhu kwenziwa kuzilungiselelo zomshayeli.
- Okuzenzakalelayonqamula ngemva kwemizuzwana engu-N: Inani kumasekhondi afakwe lapha lizotshela i-DataGrip ngemva kwesikhathi esingakanani yokunqamula ngokuzenzakalelayo emthonjeni wedatha.
- Iskripthi sokuqalisa: Lapha ungafaka umbuzo ozokwenziwa ngaso sonke isikhathi lapho kwakhiwa uxhumano. Ake sikhumbule ukuthi uma Ukuxhumana okukodwa
imodi ayinikiwe amandla, kwakhiwa uxhumano olusha kukhonsoli entsha ngayinye.
Izikimu
Isihlungi sezinto eziboniswe esihlahleni sithuthele lapha.
Ukuzulazula nokusesha
Uhlu lwezindawo zakamuva
Iwindi lezindawo zakamuva libonisa ukuthi usanda kuba kuphi. Izinto zohlu izingcezu ezincane zekhodi osanda kuzihlela noma ozibukile. Lokhu kuyasiza uma ukhumbula umongo kodwa ungakhumbuli igama lefayela. Lokhu kwenzeka kakhulu ku-DataGrip ngoba wonke ama-consoles aqanjwe ngendlela efanayo :) Isinqamuleli sekhibhodi esizenzakalelayo sithi:
Ctrl/Cmd+Shift+E.
Uma ngaphambilini usebenzise lesi sinqamuleli sekhibhodi ukuze ubonise uhlu lwamafayela alungiswe kamuva, manje sicela uchofoze kabili Ctrl/Cmd+E.
Sesha ngendlela
Sisuse izinketho ezingadingekile βesizitholeβ endaweni yesikhulumi: I-module ΠΈ Project. Manje ngokuzenzakalelayo Thola endleleni I-DataGrip isesha yonke indawo. Siphinde sengeza indawo entsha yokusesha Izikhombisi-ndlela Ezinamathiselwe β kuhlanganisa kuphela amafayela namafolda asuka kuphaneli Yamafayela.
Izenzo ezivela kumiphumela yokuzulazula
Imiphumela yokuzulazula manje inikeza izenzo ezisebenza ezintweni ezikukhodi noma esihlahleni. Isibonelo, ufuna itafula. Nakhu ongakwenza ewindini lemiphumela.
- Buka i-DDL: Ctrl/Cmd+B.
- Vula idatha: F4.
- Vula iwindi le-Modify Table: Ctrl/Cmd+F6.
- Bonisa komunye umongo: I-Alt + F1 (isibonelo, khombisa esihlahleni).
- Bona ulwazi olujwayelekile: Ctrl+Q/F1.
- Khiqiza i-SQL: Ctrl/Cmd+Alt+G.
Ukusebenza ngekhodi
Izinto ezihlanganisiwe ekuqedeleni ngokuzenzakalela
Ukuze CREATE
ΠΈ DROP
Ukuqedela ngokuzenzakalela ukunikezwa kwezinketho ezihlanganisiwe.
Ungakhohlwa ngama-acronyms.
Ukuhlola okusha
I-DataGrip izokuxwayisa uma usebenzisa ikhesa engavuliwe.
Ukuhlola okubili okulandelayo kukhutshaziwe ngokuzenzakalela, kodwa okunye kungase kukudinge.
Uma usebenzisa izimpikiswano ezingashiwongo, lokhu kuzogqanyiswa.
Ukuhlolwa okukhononda ngesitatimende se-GOTO.
Ukusebenza ngamafayela
Kwengezwe ukulungiselelwa kwefolda yephrojekthi ezenzakalelayo. Amaphrojekthi amasha azodalwa kule folda.
Isenzo Igcine njenge⦠okwekhonsoli manje:
- Iphakamisa ifolda yephrojekthi ezenzakalelayo.
- Ikhumbula ukukhetha kokugcina.
Isenzo sengeziwe esihlahleni sefayela Hlukanisa uhla lwemibhalo: Susa ukuphina ifolda. Ngaphambilini, ukuze ususe ukuphina ifolda (okungukuthi, ungayibonisi kulesi sihlahla), bekufanele uchofoze Susa, futhi i-DataGrip yabuza: ingabe ufuna ukususa noma ukususa ukuphina? Kwakungalungile futhi kungacacile :)
Isihlahla sesizindalwazi
Sibhale eyethu isethulo se-DB2. Lokhu kusho ukuthi sithola ulwazi mayelana nezinto zesizindalwazi sisebenzisa imibuzo, hhayi ngomshayeli we-JDBC, njengangaphambili. Ngakho, izinto zavela esihlahleni ezazingekho ngaphambili: izimbangela, izinhlobo, izindlela, amamojula, izinto zokubala, izindima nabanye.
Isihlahla sigcina umongo: igama lomthombo wedatha linamathele phezulu.
Izithonjana zenzelwe izizindalwazi ezingasekelwe: labo abanemithombo yedatha edalelwe leyo mininingwane ngeke besadideka.
Siphinde sadweba izithonjana ezingabonakali ezingasetshenziswa kuzilungiselelo zomshayeli.
Phumula
Izingqikithi ngokwezifiso
Abasebenzisi be-DataGrip manje banamandla okudala noma yiluphi uhlelo lombala abalufunayo. Uhlelo olusha luyi-plugin okufanele ifakwe kusukela esigabeni Ama-Plugin kuzilungiselelo.
Funda mayelana nendlela yokudala amatimu akho lapha:
Sazama ukwenza abasha abambalwa ngokwethu. Zibukeka kanje:
I-Cyan
Onsomi omnyama
Umhleli wedatha
Isihlungi siphakamisa amanani asuka ebhodini lokunamathisela.
Konke!
Imininingwane eyengeziwe lapha (ngesiNgisi) Landa isivivinyo senyanga Twitter sifunda - Imeyili siyayifunda: [i-imeyili ivikelwe]
I-tracker yesiphazamisi - Amazwana esiwafundile βββ
Ithimba le-DataGrip
Source: www.habr.com