Kuburitswa kwePostgREST 9.0.0, ma-add-ons ekushandura dhatabhesi kuita RESTful API.

Kuburitswa kwePostgREST 9.0.0 kwakaitika, sevha yewebhu inoshanda yakaparadzana pamwe nekushandiswa kweakareruka rekuwedzera kuPostgreSQL DBMS, kushandura zvinhu kubva kudhatabhesi iripo kuita RESTful API. Panzvimbo pekugadzira data rehukama muzvinhu (ORMs), PostgREST inogadzira maonero zvakananga mudhatabhesi. Iyo dhatabhesi yedivi zvakare inobata serialization yeJSON mhinduro, kusimbiswa kwedata, uye mvumo. Maitiro ehurongwa anokwana kugadzirisa kusvika ku2000 zvikumbiro pasekondi pane yakajairika server. Iyo kodhi kodhi yakanyorwa muHaskell uye yakagoverwa pasi peMIT rezinesi.

Semuyenzaniso, uchishandisa chete dhizabheti ropafadzo meshini, unogona kupa mukana kune data (matafura, ekuona mhando, uye akachengetwa maitiro) pamusoro peHTTP. Muchiitiko ichi, hapana chikonzero chekuisa kodhi shanduro yakadai uye kazhinji murairo mumwe weGRANT wakakwana kuti tafura iwanikwe kuburikidza neREST API. Zvinogoneka kugadzirisa kupinda nechiratidzo (JWT) uye kuronga "multitenancy" kuburikidza nekushandiswa kwesimba rekuchengetedza mutsara mutsara (Row Level Security).

Nekuvakwa, PostgREST inosundira yakanangana nedata-yakatarisana nedhizaini (Data-Oriented Architecture), uko mamicroservices asingazvichengetedze ivo pachavo, asi shandisa imwe chete yekuwana data (Data Access Layer) yeizvi.

Pakati pekuchinja mushanduro itsva:

• Matafura akapatsanurwa akawedzerwa kune yekuchengetedza schema cache, izvo zvakaita kuti zvikwanisike kuti matafura akadaro kunyura UPSERT uye INSERT mashandiro muNzvimbo mhinduro, ita OPTIONS mibvunzo, uye kushandisa OpenAPI rutsigiro.
• Kuburikidza neRPC POST inotenderwa kudaidza mabasa neparamita imwe isina kudomwa zita.
• Inotenderwa kudaidza mabasa neimwe JSON paramende isina "Sarudzo: params=chimwe-chinhu" musoro.
• Inotenderwa kurodha data yerudzi bytea mumabasa uchishandisa zvikumbiro zvine "Zviri-Type: application/octet-stream".
• Inotenderwa kurodha mavara mumabasa uchishandisa mibvunzo ine "Content-Type: text/plain".
• Yakawedzerwa rutsigiro rwemavara ari kutiza mukati memabhuraketi maviri, semuenzaniso, "?col=in.("Kaviri\"Quote"), ?col=in.("Kumashure\\slash").
• Kugona kusefa zviwanikwa zvechikamu chekutanga zvichibva pamasefa akavakirwa mukati (“/projects?select=*,clients!inner(*)&clients.id=eq.12” akapihwa.
• Iyo "is" mushandisi inobvumira kukosha "kusingazivikanwe".
• Kuenderana nePostgreSQL 14 kwave kuwanikwa uye kutsigirwa kwePostgreSQL 9.5 kwakamiswa.

Source: opennet.ru