I-PostgREST isebenzisa i-RESTful API egcwele kunoma iyiphi isizindalwazi se-PostgreSQL esikhona. Ihlinzeka nge-API ehlanzekile, ehambisana kakhulu
Namuhla sizokhuluma ngakho I-PostgREST, okuyi iseva yewebhu ezimele eshintshayo isizinda sedatha I-PostgreSQL ngqo ku-RESTful API. Imikhawulo yesakhiwo kanye nezimvume zesizindalwazi zinquma izindawo zokugcina ze-API kanye nokusebenza.
Ngokusho kwabaqambi bayo, ukusebenzisa i-PostgREST kuyinto enye indlela ye-CRUD Incwadi yesandla. Khumbula ukuthi isifinyezo sekhompyutha esithi CRUD (Dala, Funda, Buyekeza, Susa) sichaza imisebenzi emine eyisisekelo yokuphikelela kwedatha, ikakhulukazi ukugcinwa kolwazi kusizindalwazi.
“I-PostgREST inamandla, izinzile futhi isobala. Kusivumela ukuthi siqale amaphrojekthi ngokushesha okukhulu futhi sigxile kudatha yethu nezinhlelo zokusebenza esikhundleni sokwakha isendlalelo se-ORM. Kuqoqo lethu le-k8s, sisebenzisa ama-pods ambalwa ku-schema ngasinye esifuna ukudalula futhi sikhuphuke noma phansi ngokususelwa ekudingeni.
Kulabo abangazi nge-PostgreSQL, kufanele wazi ukuthi lokhu iwuhlelo lokuphatha idatha elaziwa ngokwethembeka nokuqina, izinzuzo kusukela eminyakeni engaphezu kwengu-25 yokuthuthukiswa komthombo ovulekile ngumphakathi wonjiniyela womhlaba wonke. Ingolunye lwezinhlelo ezithuthuke kakhulu zokuphatha isizindalwazi somthombo ovulekile. Inothile ngesici, inezinhlobo zedatha eziqinile, ukukhomba okunamandla, kanye nenhlobonhlobo yemisebenzi eyakhelwe ngaphakathi engasetshenziswa ukwenza isitaki sedatha ibe lula futhi ivumele onjiniyela ukuthi bagxile ekwakheni uhlelo lwabo lokusebenza.
I-PostgREST inciphile ngobubanzi, futhi isebenza kahle namanye amathuluzi afana neseva yewebhu ye-Nginx. Lokhu kuphoqa ukuhlukaniswa okucacile kwedatha ye-CRUD kwezinye izinto ezikhathazayo.
I-PostgREST usingatha ubuqiniso (ngeJSON Web Tokens) futhi idlulise ukugunyazwa kolwazi lwendima oluchazwe ku-database. Lokhu kuqinisekisa ukuthi kukhona umthombo owodwa kuphela weqiniso wokuvikela.
Lapho usebenza nedathabheyisi, iseva ithatha ubunikazi bomsebenzisi oqinisekisiwe njengamanje futhi ngesikhathi sokuxhuma ayikwazi ukwenza noma yini umsebenzisi ngokwakhe angenakukwenza. Ezinye izinhlobo zokufakazela ubuqiniso zingakhiwa ku-JWT yokuqala.
Ngakolunye uhlangothi, uma kukhulunywa ngobuqotho bedatha, I-PostgREST esikhundleni sokuncika ku-Object Relational Mapper (ORM) nokufakwa kwekhodi okudingekayo ngokwezifiso, lolu hlelo lubeka izingqinamba ezinciphisayo ngqo ku-database yakho.
Nge-PostgREST, ayikho i-ORM (imephu ehlobene yento) ehilelekile, kanye nokwakhiwa kokubuka okusha kwenziwa ku-SQL, nemiphumela yokusebenza eyaziwayo. Umqondisi wesizindalwazi manje usengakwazi ukudala i-API kusukela ekuqaleni, ngaphandle kokwenza izinhlelo ngokwezifiso.
I-ORM iwuhlobo lohlelo lwekhompuyutha olubekwe njengesixhumi esibonakalayo phakathi kohlelo lohlelo lokusebenza kanye nesizindalwazi esihlobene ukuze silingise isizindalwazi esigxile entweni. Lolu hlelo luchaza ukufana phakathi kwama-schema esizindalwazi kanye namakilasi ohlelo lohlelo lokusebenza.
ekugcineni uma ukhona unentshisekelo yokwazi okwengeziwe ngayo, ungabheka imininingwane Kulesi sixhumanisi esilandelayo.
Ungayifaka kanjani iPostgREST kuLinux?
Inguqulo engu-10.1.1 ikhishwe ngoNovemba odlule inezengezo ezintsha kanye nezinguquko ezithile. Le nguqulo ingatholakala ku-github. Isixhumanisi yilokhu.
Ngokufanayo, kulabo abanentshisekelo yokukwazi ukufaka iPostgREST, kufanele bazi ukuthi inguqulo yamanje ingatholakala okwamanje ngosizo lokuphela. Kukulo kuphela esizokuthayipha:
wget https://github.com/PostgREST/postgrest/releases/download/v10.1.1/postgrest-v10.1.1-linux-static-x64.tar.xz
Manje kufanele nje bavule uziphu iphakethe ngomyalo olandelayo:
tar Jxf postgrest-v10.1.1-linux-static-x64.tar.xz
Ngenkathi kwenzeka ngokukhethekile kulabo abasebenzisa inguqulo engu-64-bit ye-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
Futhi bangagijima nge:
./postgrest --help
Enye indlela yokufaka inesithombe se-Docker esilungile, ungasithola ngokubhala:
docker pull postgrest/postgrest
Ekugcineni ungathola eminye imininingwane mayelana nokumiswa kwayo, kusuka kumadokhumenti akuwebhusayithi yayo. Isixhumanisi yilokhu.