Sannu! Mu kalli sabbin abubuwa a ciki - . Bari mu tunatar da ku cewa an haɗa aikin DataGrip a cikin sauran IDEs ɗinmu da aka biya, ban da WebStorm.
Taimako don sababbin bayanan bayanai
A cikin wannan sakin, rumbun adana bayanai guda huɗu sun sami goyan bayan hukuma a cikin kayan aikin mu:
Apache Kado – tsarin sarrafa bayanai dangane da dandalin Hadoop.
Greenplum - DBMS na nazari don ɗakunan ajiya na bayanai dangane da PostgreSQL.
Vertica – columnar database don babban bayanai bincike.
Snowflake – girgije data ajiya. Idan muka yi magana game da bayanan bayanai, to Snowflake . A cikin wannan sakin mun goyi bayan SQL kawai, za mu saki umarnin daga baya.
Haɗin kai
Mun yi canje-canje ga akwatin maganganu na haɗin bayanai: mun yi ƙoƙarin ƙara bayyanawa da dacewa.
Janar
Wannan shafin galibi an sake gyara shi.
filin Nau'in haɗin da ake kira nau'in URL kuma yana can kasa. Amma, tun da darajar wannan filin ta ƙayyade ƙarin tsari, yanzu yana kan saman.
filin database sanya bayan shigar da login da kalmar sirri, saboda ana buƙatar tantancewa don nuna jerin bayanai ta hanyar Ctrl/Cmd+Space.
A cikin sharhin post ɗin da ya gabata adana kalmar sirri. Mun ƙara sababbin zaɓuɓɓuka kuma mun yi jerin zaɓuka. Darajar wannan jeri sune:
- Kar a ajiye kalmar sirri.
- Ajiye har sai an sake kunna DataGrip (a baya wannan shine yadda zaɓin "kada ku ajiye" yayi aiki).
- Ajiye don zama: har sai kun cire haɗin daga tushen bayanai.
- Dawwama.
Don guje wa rudani, shigar da kalmar sirri mara kyau ta cikin menu na mahallin.
Результаты Jirgin gwajin Yanzu ana nunawa a cikin taga kanta, babu ƙarin dannawa ko tattaunawa.
Kuma idan ba a sauke direbobi ba, DataGrip zai ba da damar yin hakan. Maɓallin baya Jirgin gwajin an toshe a cikin wannan yanayin, wanda ya rikitar da masu amfani.
Zabuka
An matsar da saituna anan daga Gaba ɗaya shafin Read-kawai, Daidaitawa ta atomatik, Ikon ciniki.
sabon:
- Gudun tambayar kiyaye rai kowane daƙiƙa N: zai ciro tushen bayanan tare da sanda kowane sakan N. Don bayanan bayanan da ba mu goyan bayansu, zaku iya rubuta buƙatar kiyayewa da kanku. Ana yin wannan a cikin saitunan direba.
- Kai tsayecire haɗin bayan dakika N: Ƙimar cikin daƙiƙa da aka shigar a nan za ta gaya wa DataGrip bayan tsawon lokacin da za a cire haɗin kai tsaye daga tushen bayanai.
- Rubutun farawa: Anan zaka iya shigar da tambayar da za a aiwatar a duk lokacin da aka ƙirƙiri haɗin gwiwa. Bari mu tuna cewa idan Haɗa guda ɗaya
yanayin ba a kunna ba, an ƙirƙiri sabon haɗi don kowane sabon na'ura wasan bidiyo.
Tsare-tsare
Tace abubuwan da aka nuna a itacen ya matsa nan.
Kewayawa da bincike
Jerin wuraren kwanan nan
Sabuwar taga wuraren kwanan nan yana nuna inda kuka kasance kwanan nan. Abubuwan jeri ƙananan lambobin lamba ne waɗanda kwanan nan ka gyara ko duba. Wannan yana da amfani idan kun tuna mahallin amma kar ku tuna sunan fayil ɗin. Wannan yana faruwa da yawa a cikin DataGrip saboda duk consoles ana kiransu iri ɗaya :) Tsohuwar hanyar gajeriyar madannai ita ce:
Ctrl/Cmd+Shift+E.
Idan a baya kayi amfani da wannan gajeriyar hanyar madannai don nuna jerin fayilolin da aka gyara kwanan nan, yanzu da fatan za a danna sau biyu Ctrl/Cmd+E.
Bincika ta hanya
Mun cire zaɓuɓɓukan da ba dole ba waɗanda muka “samu” daga dandamali: module и Project. Yanzu ta tsohuwa Nemo a hanya DataGrip yana bincika ko'ina. Mun kuma ƙara sabon wurin bincike Haɗe-haɗe Directories - ya ƙunshi fayiloli da manyan fayiloli kawai daga Fayilolin Fayilolin.
Ayyuka daga sakamakon kewayawa
Sakamakon kewayawa yanzu yana ba da ayyukan da suka shafi abubuwa a lambar ko itace. Misali, kuna neman tebur. Ga abin da za ku iya yi daga taga sakamako.
- Duba DDL: Ctrl/Cmd+B.
- Bude bayanai: F4.
- Bude Tagar Gyaran Tebu: Ctrl/Cmd+F6.
- Nuna a cikin wani mahallin: Alt F1 (misali, nuna a itace).
- Duba cikakken bayani: Ctrl+Q/F1.
- Ƙirƙirar SQL: Ctrl/Cmd+Alt+G.
Aiki tare da code
Abubuwan da aka haɗa a cikin kammalawa ta atomatik
domin CREATE и DROP autocomplete yana ba da zaɓuɓɓukan haɗin gwiwa.
Kar a manta game da gajarta.
Sabbin dubawa
DataGrip zai gargaɗe ku idan kuna amfani da siginan kwamfuta wanda baya buɗewa.
Ana kashe waɗannan binciken biyu ta tsohuwa, amma wasu na iya buƙatar su.
Idan kun yi amfani da dalilan da ba a bayyana sunansu ba, za a haskaka wannan.
Binciken da ya koka game da bayanin GOTO.
Aiki tare da fayiloli
Ƙara saitin don babban fayil ɗin aikin tsoho. Za a ƙirƙiri sababbin ayyuka a cikin wannan babban fayil ɗin.
sakamako Ajiye azaman… don console yanzu:
- Yana ba da shawarar babban fayil ɗin aikin tsoho.
- Ya tuna zabi na karshe.
An ƙara wani aiki a bishiyar fayil ɗin Jagorar Ragewa: Cire babban fayil. A baya, don cire babban fayil (wato, ba nuna shi a cikin wannan bishiyar ba), dole ne ku danna share, kuma DataGrip ya tambaya: kuna son sharewa ko cirewa? Ya kasance mara dadi kuma ba a sani ba :)
Itacen Database
Mun rubuta namu introspection don DB2. Wannan yana nufin cewa muna samun bayanai game da abubuwan bayanai ta amfani da tambayoyi, kuma ba ta wurin direban JDBC ba, kamar da. Don haka, abubuwa sun bayyana a cikin bishiyar waɗanda ba a can baya: masu jawo, nau'ikan, hanyoyin, kayayyaki, ƙira, matsayi da sauransu.
Itacen yana adana mahallin: sunan tushen bayanan yana makale a saman.
An zana gumaka don bayanan bayanai marasa tallafi: waɗanda ke da tushen bayanan da aka ƙirƙira don irin waɗannan bayanan ba za su ƙara ruɗe ba.
Mun kuma zana gumakan da za a iya amfani da su a cikin saitunan direba.
Huta
Jigogi na al'ada
Masu amfani da DataGrip yanzu suna da ikon ƙirƙirar kowane tsarin launi da suke so. Sabuwar makirci shine plugin wanda dole ne a shigar dashi daga sashin plugins a cikin saiti
Karanta yadda ake ƙirƙirar jigogin ku anan:
.
Mun yi ƙoƙari mu yi sababbi biyu da kanmu. Ga su kamar haka:
Cyan
Dark purple
Editan bayanai
Tace tana nuna ƙima daga allon allo.
Komai!
- Wasiku mun karanta: [email kariya]
- Sharhi mun karanta ↓↓↓
Ƙungiyar DataGrip
source: www.habr.com