Yanar gizo masu amfani guda 10 don Koyon Tsarin Bayanan Bayanan PostgreSQL


PostgreSQL (wanda aka fi sani da Postgres) shine mafi mashahuri da ci gaba na tushen buɗe-tushen sha'anin kasuwancin-tsarin tsarin gudanar da bayanai (ORDMS). PostgreSQL yana da zaɓuɓɓuka iri-iri na al'umma da zaɓuɓɓukan tallafi na kasuwanci masu sauƙi ga masu amfani.

Postungiyar PostgreSQL da sauran masu samar da hanyoyin ilmantarwa kan layi, suna ba da albarkatu da yawa don saba da PostgreSQL, gano yadda yake aiki, da koya/ƙware yadda ake amfani dashi.

A cikin wannan labarin, za mu raba shafukan yanar gizo masu amfani da albarkatun kan layi game da PostgreSQL.

1. Yanar Gizo na PostgreSQL na Yanar Gizo

Wurin farko da za a fara shine https://www.postgresql.org/, gidan PostgreSQL, wanda ke dauke da bayanai masu yawa game da PostgreSQL, gami da yadda ake girka da amfani da shi.

Anan ga wasu hanyoyi masu amfani/shafuka masu amfani:

  • Takardun hukuma - shafi tare da hanyoyin haɗin kai zuwa takardun hukuma don nau'ikan daban-daban na PostgreSQL.
  • Saukewa na PostgreSQL - shafi ne da ya zo tare da wasu hanyoyi masu amfani ga fakitin PostgreSQL da masu sakawa.
  • Littafin Ka'idodin Software (Kayan Kayan Samfu) - shafi ne wanda ke taimaka muku samun hanyoyin musayar PostgreSQL, kari, da kuma masarrafai daga dama daga ayyukan Open Source, kamfanoni da masu amfani, da kuke buƙata.
  • PostgreSQL Wiki - shafi ne da ke dauke da bayanan mai amfani, da yadda-tos, da kuma dabaru ‘n’ dabaru masu nasaba da PostgreSQL.
  • Planet PostgreSQL - sabis na tattara abubuwan yanar gizo wanda al'ummar PostgreSQL ke gudanarwa.

Bayan wannan kuma zaku iya kaiwa ga PostgreSQL al'umma anan.

2.Babayani

Abu na biyu, muna da 2Quadrant. Simon Riggs ne ya kafa shi a shekara ta 2001 (babban mai haɓaka aikin PostgreSQL) amma kwanan nan ya sami EDB (Enterprise DB). 2ndQuadrant shine babban mai tallafawa aikin PostgreSQL, banda maganar sama da kashi 20% na lambar PostgreSQL da injiniyoyin 2ndQuadrant suka rubuta. Ita ce mafi girma kuma ƙwararrun mashahuran duniya waɗanda masana ke samarda mafita, sabis, da horo na PostgreSQL.

3. PostgreSQL Tutorial

Kamar yadda sunan yake karantawa, PostgreSQL Tutorial yana da amfani da shahararren gidan yanar gizo don koyarwar PostgreSQL wanda zai taimaka muku fahimtar PostgreSQL cikin sauri da sauƙi. An sadaukar da shi ga masu haɓakawa da masu kula da bayanai waɗanda ke aiki a kan tsarin sarrafa bayanai na PostgreSQL. Suna ba da albarkatu don farawa da sauri tare da PostgreSQL.

4. Nunin Koyawa

Tutorialspoint yana da koyarwa mai amfani game da PostgreSQL, wanda aka shirya don masu farawa don taimaka musu fahimtar asali zuwa ingantattun ra'ayoyi masu alaƙa da Bayanan Bayanan PostgreSQL. Zai ba ku hanzari farawa tare da PostgreSQL kuma ya sa ku dace da shirye-shiryen PostgreSQL da ƙari.

5. w3adogara

W3resource yana da koyarwar PostgreSQL wanda ke ba da kwas ɗin PostgreSQL na kan layi wanda ya haɗa da ra'ayoyin tushen bayanai, tambayoyin tambayoyi, da tambayoyi don taimaka muku fahimtar harshen PostgreSQL mafi kyau.

6. Guru99

Hakanan zaka iya ƙarin sani game da Postgres kuma koya yadda ake amfani dashi daga koyarwar PostgreSQL akan Guru99.com. An tsara shi don masu farawa tare da ƙarancin ƙwarewar PostgreSQL.

7. Jagoran Postgres

Jagorar Postgres jagora ce mai taimako wacce aka kiyaye akan "mafi kyawun ƙoƙari". An tsara shi azaman taimako ga masu farawa da ƙwarewar masu amfani don nemo takamaiman nasihu da bincika kayan aikin da ake dasu a cikin yanayin halittun Postgres.

8. PGTune

PGTune kayan aiki ne na kan layi don taimaka muku ƙirƙirar sanyi don PostgreSQL dangane da ƙimar aiki don daidaitaccen kayan aikin kayan aiki. Koyaya, bisa ga PGTune game da shafi, kayan aikin ba harsashin azurfa bane don inganta PostgreSQL saboda akwai abubuwa da yawa da za'ayi la'akari dasu don cikakken tsarin ingantaccen tsarin bayanai na PostgreSQL gami da, amma ba'a iyakance ga kayan aikin kayan aiki ba.

9. Postgres a Mako-mako

Postgres Weekly shine zagaye na imel na mako-mako wanda zaku iya biyan kuɗi don karɓar labarai da labarai na PostgreSQL.

10. linux-console.net

Mu a PostgreSQL mu ma muna jagorantar, kamar shigarwa da daidaitaccen tsarin tsarin bayanai na PostgreSQL da sauran kayan aikin gudanarwa/ci gaba gami da pgAdmin, a kan rarraba Linux na yau da kullun.

Shi ke nan! A cikin wannan labarin, mun raba rukunin yanar gizon da ke ba da albarkatu masu amfani da yawa don saba da tsarin bayanan PostgreSQL, gano yadda yake aiki, da kuma koyon yadda ake amfani da shi. Idan kun san kowane rukunin yanar gizo ko kayan yanar gizo muna buƙatar ƙarawa a nan, bari mu sani ta hanyar fom ɗin da ke ƙasa.