PostgreSQL tsari ne na daidaitaccen tsarin kula da bayanai kuma kyauta, an sake ta a ƙarƙashin lasisin PostgreSQL, kwatankwacin BSD ko MIT.
Kamar sauran ayyukan buɗe ido, Ci gaban PostgreSQL ba ya gudana ta kamfani ɗaya ko mutum, amma ƙungiyar masu haɓakawa ce ke gudanar da shi waɗanda ke aiki a cikin rashin son kai, son kai, kyauta ko ƙungiyoyin kasuwanci ke tallafawa.
Wasu daga cikin manyan halayen sa sune:
Babban halarta
Ta hanyar tsarin da ake kira MVCC (Multiversion Concurrent Access, don karancin sa a Turanci) PostgreSQL yana ba da damar cewa yayin aiwatar ɗaya rubutu zuwa tebur, wasu suna samun damar tebur ɗaya ba tare da buƙatar makullai ba. Kowane mai amfani yana samun daidaitaccen ra'ayi.
PostgreSQL na asali yana bada tallafi don:
- Lambobin daidaitattun daidaito.
- Unlimited tsawon rubutu.
- Figures na geometric (tare da nau'ikan ayyukan haɗin gwiwa).
- Adireshin IP (IPv4 da IPv6).
- Tubalan salon CIDR.
- Adireshin MAC.
Shirye-shiryen
.Ari masu amfani zasu iya ƙirƙirar nau'ikan bayanan su, wanda zai iya zama cikakke cikakke bisa ga albarkatun GiST na PostgreSQL. Wasu misalan sune nau'ikan bayanan GIS waɗanda aikin PostGIS ya kirkira.
Game da sabon sigar PostgreSQL 11.0
A ‘yan kwanakin da suka gabata an fitar da sabon sigar PostgreSQL wanda ya kai sigar PostgreSQL 11 da shi yana ƙara sabbin fasali kuma sama da dukkan gyaran bug daban-daban.
Babban sabon labarin shine cewa sun maida hankali kan gudanar da rumbunan adana bayanai tare da babban adadin bayanai.
Inganta bangare
PostgreSQL tuni yana ba da izinin raba lokaci na dogon lokaci, yana game da adana bayanai a tebur daban daban waɗanda suke da ma'ana a cikin tebur ɗaya.
Mai amfani da bayanan bai ga wannan shimfidar ba kuma wannan yana ba da damar adana bayanai a cikin tsarin fayil daban-daban don samun halaye daban-daban bisa ga bayanan. Misali, an adana bayanan kwanan nan akan SSD kuma an adana tsofaffin bayanai a rumbun kwamfutarka.
Zai yiwu a raba cikin jerin bayanai ko tazara. Yanzu yana yiwuwa a raba maɓallin zanta don rarraba bayanai.
Wannan yana ba da damar rarraba ayyukan karatu da rubutu a cikin shaguna da yawa.
Maballin farko da na waje, gami da fihirisa da abubuwan motsa jiki, yanzu ana iya ayyana su a matakin tebur na farko kuma za'a nuna su ko'ina cikin teburin memba a cikin ɓangaren.
PostgreSQL yanzu kuma zaka iya canza bayanan bangare kai tsaye idan aka canza maballin rarrabawa.
Hakanan an inganta aikin karanta teburin da aka raba tare da sabon dabarun cire bangare.
Halin halayyar TAMBAYA yanzu akwai don tebur masu rarraba.
Samuwar ma'amaloli a cikin hanyoyin da aka adana
Akwai wadatar hanyoyin da aka adana a cikin PostgreSQL na dogon lokaci, amma ba zai yiwu a ƙirƙira ma'amaloli a can ba. Yanzu yana yiwuwa.
Ingantaccen aiki
Yanzu ana iya aiwatar da ayyuka da yawa a layi daya don cin gajiyar mahimman abubuwan sarrafawar yau.
Saboda haka, ana iya karanta teburin da aka raba a layi daya, amma kuma lokacin da tambaya Select ya hada da magana UNION .
Ofirƙirar fihirisa suma suna cikin layi ɗaya, da kuma sauran umarnin Harshen Ma'anar BayanaiDDL), kamar yadda KIRKIRA BAYA o KIRKIRA RA'AYIN JARI.
Gina kan tafi
Akwai lokacin tarawa. Kuna iya inganta ƙididdigar rikitarwa don haɓaka saurin aiwatarwa. PostgreSQL yayi amfani da mai tattara LLVM don wannan dalili.
Don kunna shi, dole ne su ƙara shi jit = kan aiki fayil ɗin daidaitawa ko bayyana ma'anar zaman SET jit = a kan.
Sauƙaƙe = sauri
Babu buƙatar sake rubuta dukkan tebur lokacin da aka yi kira BAYANIN BAYA… DARARA OL KASHE … Tare da tsoho mai daraja wanda ba NULL ba. Wannan yana inganta saurin aiwatar da wannan umarnin, idan tebur babba ne.
Kwarewar mai amfani
Kalmomin ficewar quity yanzu ana gane su ta hanyar layin umarni (psql) don kammala aikin, ban da \ q.
Domin samun wannan sabon sigar zaku iya ziyarta mahada mai zuwa.