PostgREST: sabar gidan yanar gizo da RESTful API don kowane bayanan PostgreSQL

Karin bayani

PostgREST yana ba da cikakken RESTful API daga kowane bayanan PostgreSQL da ke wanzu. Yana ba da mafi tsafta, mafi dacewa API

A yau za mu yi magana ne a kai Karin bayani, wanda yake uwar garken gidan yanar gizo kadai wanda ke canzawa tushen bayanai PostgreSQL kai tsaye a cikin API RESTful. Ƙuntataccen tsari da izini na bayanai sun ƙayyade ƙarshen API da ayyuka.

A cewar masu zanen sa, yin amfani da PostgREST shine madadin shirye-shiryen CRUD Littafin Jagora. Ka tuna cewa gajartar kwamfuta ta CRUD (Create, Read, Update, Share) tana zayyana muhimman ayyuka guda huɗu don dagewar bayanai, musamman ma adana bayanai a cikin rumbun adana bayanai.

“PostgREST yana da ƙarfi, tsayayye kuma bayyananne. Yana ba mu damar fara ayyuka da sauri kuma mu mai da hankali kan bayananmu da aikace-aikacenmu maimakon gina layin ORM. A cikin gungu na k8s, muna gudanar da ƴan kwas ɗin kowane tsari wanda muke son fallasa da haɓaka sama ko ƙasa bisa ga buƙata. 

Ga waɗanda ba su san PostgreSQL ba, ya kamata ku san cewa wannan tsarin sarrafa bayanai ne wanda aka san shi da aminci da ƙarfi, yana amfana daga sama da shekaru 25 na ci gaban buɗaɗɗen tushe ta al'ummar haɓaka ta duniya. Yana ɗaya daga cikin mafi ci gaba tsarin sarrafa bayanan tushen tushen bayanai. Yana da wadataccen fasali, tare da nau'ikan bayanai masu ƙarfi, ƙididdigewa mai ƙarfi, da fa'idar ginanniyar ayyuka da yawa waɗanda za a iya amfani da su don sauƙaƙe tarin bayanan da ba masu haɓaka damar mai da hankali kan gina ƙa'idarsu.

PostgREST kunkuntar iyaka ce, kuma yana aiki da kyau tare da wasu kayan aikin kamar sabar gidan yanar gizo na Nginx. Wannan yana tilasta rarrabuwar kawuna na ayyukan CRUD na tushen bayanai daga wasu abubuwan damuwa.

Karin bayani Tabbatar da tabbatarwa (ta hanyar JSON Web Tokens) kuma wakilai suna ba da izini ga bayanin rawar da aka bayyana a cikin rumbun adana bayanan. Wannan yana tabbatar da cewa akwai hanya daya tak wacce take bayyana gaskiya don tsaro.

Lokacin ma'amala da bayanan, sabar tana ɗauke da asalin mai amfani a halin yanzu kuma yayin haɗin ba zai iya yin wani abu da mai amfani da kansa ba zai iya yi ba. Sauran hanyoyin tabbatarwa za'a iya gina su a cikin JWT na farko.

A gefe guda, idan yazo da mutuncin data, PostgREST maimakon dogaro da Mapper na Dangantakar Abubuwan (ORM) da tsarin sanya lambar sirri, wannan tsarin yana sanya takunkumi na bayyanawa kai tsaye akan rumbun adana bayanan ku.

Tare da PostgREST, babu ORM (taswirar alaƙar abu) da ke ciki, da ƙirƙirar sabbin ra'ayoyi ana yin su a cikin SQL, tare da sanannun sakamakon aiki. Mai gudanar da bayanai zai iya ƙirƙirar API daga karce, ba tare da shirye-shirye na al'ada ba.

ORM wani nau'i ne na shirin kwamfuta wanda aka sanya shi azaman mu'amala tsakanin shirin aikace-aikacen da kuma bayanan da ke da alaƙa don kwaikwayi bayanan da ke kan abu. Wannan shirin yana bayyana taswira tsakanin tsarin bayanai da kuma azuzuwan shirin aikace-aikace.

a karshe idan kun kasance mai sha'awar ƙarin sani game da shi, zaka iya duba bayanan A cikin mahaɗin mai zuwa.

Yadda ake girka PostgREST akan Linux?

An fito da sigar 10.1.1 a watan Nuwamban da ya gabata tare da sabbin ƙari da wasu canje-canje. Ana iya samun wannan sigar daga github. Haɗin haɗin shine wannan.

Hakazalika, ga masu sha'awar iya sanya PostgREST, ya kamata su san cewa ana iya samun sigar ta yanzu a yanzu tare da taimakon mai kawo ƙarshe. A ciki ne kawai za mu buga:

wget https://github.com/PostgREST/postgrest/releases/download/v10.1.1/postgrest-v10.1.1-linux-static-x64.tar.xz

Yanzu kawai zasu cire kunshin ɗin tare da umarni mai zuwa:

tar Jxf postgrest-v10.1.1-linux-static-x64.tar.xz

Duk da yake a cikin batun na musamman na waɗanda suke amfani da sigar 64-bit ta Ubuntu:

wget https://github.com/PostgREST/postgrest/releases/download/v10.1.1/postgrest-v10.1.1-ubuntu-aarch64.tar.xz
tar Jxf postgrest-v10.1.1-ubuntu-aarch64.tar.xz

Kuma zasu iya gudu tare da:

./postgrest --help

Wata hanyar shigarwa tana tare da hoton Docker wanda ke shirye, zaku iya samun ta ta buga:

docker pull postgrest/postgrest

A ƙarshe zaku iya samun ƙarin bayani game da yadda aka tsara ta, daga takaddun da ke kan shafin yanar gizon ta. Haɗin haɗin shine wannan.


Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Alhakin bayanai: AB Internet Networks 2008 SL
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.