I-PostgREST ibonelela nge-API egcweleyo ye-RESTful nakweyiphi na i-database ye-PostgreSQL ekhoyo. Ibonelela nge-API ecocekileyo, ehambelana ngakumbi
Namhlanje siza kuthetha ngayo Iposti yeposi, oko ikukuthi umncedisi wewebhu ozimeleyo oguqulayo isiseko sedatha I-PostgreSQL ngqo kwi-RESTful API. Izithintelo zesakhiwo kunye neemvume zedathabheyisi zimisela isiphelo se-API kunye nokusebenza.
Ngokutsho kwabaqulunqi bayo, ukusebenzisa iPostgREST yi enye iprogram yeCRUD Incwadi yesandla. Khumbula ukuba i-CRUD yesifinyezo sekhompyutheni (Yenza, Funda, Uhlaziywa, Cima) ichaza imisebenzi emine esisiseko sokuzingisa kwedatha, ngokukodwa ukugcinwa kolwazi kwisiseko sedatha.
“I-PostgREST inamandla, izinzile kwaye iselubala. Ivumela ukuba siqale iiprojekthi ngokukhawuleza kwaye sigxile kwidatha yethu kunye nezicelo endaweni yokwakha umaleko we-ORM. Kwiqela lethu le-k8s, siqhuba iipod ezimbalwa kwi-schema nganye esifuna ukuyiveza kunye nokunyuka okanye ukuhla ngokusekwe kwimfuno.
Kwabo bangayazi i-PostgreSQL, kuya kufuneka uyazi ukuba oku yinkqubo yolawulo lwedatha eyaziwa ngokuthembeka kunye nokomelela kwayo, Izibonelelo ukusuka kwiminyaka engama-25 yophuhliso lomthombo ovulekileyo luluntu lwabaphuhlisi behlabathi. Yenye yeendlela eziphambili zolawulo lwesiseko sedatha evulekileyo. Inomsebenzi ocebileyo, kunye neentlobo zedatha ezomeleleyo, isalathisi esinamandla, kunye noluhlu olubanzi lwemisebenzi eyakhelweyo engasetyenziselwa ukwenza lula isitakhi sedatha kunye nokuvumela abaphuhlisi ukuba bagxininise ekwakheni i-app yabo.
I-PostgREST imxinwa kumda, kwaye isebenza kakuhle nezinye izixhobo ezifana ne-Nginx web server. Oku kunyanzelisa ukuhlukana okucacileyo kwedatha-centric CRUD imisebenzi kwezinye iinkxalabo.
Iposti yeposi iphatha ukungqinisisa (ngeJSON Web Tokens) kunye nabathunywa abagunyazisiweyo kwindima yolwazi echazwe kwiziko ledatha. Oku kuqinisekisa ukuba inye kuphela into enokubhengezwa yinyaniso yokhuseleko.
Xa ujongene nesiseko sedatha, umncedisi uthatha isazisi somsebenzisi wangoku oqinisekisiweyo kwaye ngexesha loqhagamshelo alunakwenza nantoni na umsebenzisi angenakho ukwenza. Ezinye iindlela zokungqinisisa zinokwakhiwa kwi-JWT yokuqala.
Ngakolunye uhlangothi, xa kufikwa kwingqibelelo yedatha, Iposi endaweni yokuxhomekeka kwi-Object Relative Mapper (ORM) kunye nokubhalwa kwesiko kunyanzelekile, le nkqubo inyanzelisa imiqobo eqinisekileyo kwisiseko sedatha yakho.
Nge-PostgREST, akukho ORM (imephu yobudlelwane bento) ebandakanyekayo, kunye nokwenziwa kweembono ezintsha kwenziwa kwi-SQL, eneziphumo ezaziwayo zokusebenza. Umlawuli wedatha ngoku unokwenza i-API ukusuka ekuqaleni, ngaphandle kwenkqubo yesiko.
I-ORM luhlobo lwenkqubo yekhompyuter ebekwe njengojongano phakathi kwenkqubo yesicelo kunye nesiseko sedatha esinxulumeneyo ukulinganisa isiseko sedatha ejolise kwinto. Le nkqubo ichaza iimappings phakathi kwe-schemas yedatabase kunye neeklasi zeprogram yesicelo.
ekugqibeleni ukuba ukhona unomdla wokwazi ngakumbi ngayo, ungajonga iinkcukacha Kule khonkco ilandelayo.
Uyifaka njani iPostgREST kwiLinux?
Inguqulelo 10.1.1 yakhutshwa ngoNovemba ophelileyo kunye nezongezo ezintsha kunye nolunye utshintsho. Le nguqulo inokufumaneka kwi-github. Ikhonkco yile.
Ngokufanayo, kwabo banomdla wokukwazi ukufaka iPostgREST, Kuya kufuneka bazi ukuba inguqulelo yangoku inokufumaneka ngoku ngoncedo lwesiphelo. Kuphela kuyo siza kuchwetheza:
wget https://github.com/PostgREST/postgrest/releases/download/v10.1.1/postgrest-v10.1.1-linux-static-x64.tar.xz
Ngoku kufuneka bavule iziphu ipakethe ngalo myalelo ulandelayo:
tar Jxf postgrest-v10.1.1-linux-static-x64.tar.xz
Ngelixa kwimeko ekhethekileyo yabo basebenzisa u-64-bit uguqulelo lwe-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
Kwaye bangabaleka nge:
./postgrest --help
Enye indlela yokufakela inomfanekiso weDocker osele ulungile, ungawufumana ngokuchwetheza:
docker pull postgrest/postgrest
Okokugqibela unokufumana ulwazi ngakumbi malunga nokuqwalaselwa kwayo, kumaxwebhu kwiwebhusayithi yayo. Ikhonkco yile.