An saki PostgREST 9.0.0, uwar garken gidan yanar gizo daban mai aiki tare da aiwatar da ƙara nauyi zuwa PostgreSQL DBMS, fassara abubuwa daga bayanan da ke akwai zuwa API RESTful. Maimakon yin taswirar bayanan alaƙa cikin abubuwa (ORMs), PostgREST yana ƙirƙirar ra'ayoyi kai tsaye a cikin bayanan. Bangaren ma'ajin bayanai kuma yana gudanar da jerin martanin JSON, ingantattun bayanai, da izini. Ayyukan tsarin ya isa don aiwatar da buƙatun 2000 a kowane daƙiƙa akan sabar na yau da kullun. An rubuta lambar aikin a Haskell kuma an rarraba ta ƙarƙashin lasisin MIT.
Misali, ta amfani da tsarin gata na bayanai kawai, zaku iya ba da damar samun bayanai (tebura, nau'ikan duba, da hanyoyin da aka adana) akan HTTP. A wannan yanayin, babu buƙatar ɓoye irin wannan fassarar kuma yawanci umarnin GRANT ɗaya ya isa don samar da tebur ta hanyar REST API. Yana yiwuwa a daidaita hanyar shiga ta alamar (JWT) da tsara "yawan yawa" ta hanyar amfani da matakan tsaro mai ƙarfi (Tsaron matakin Row).
A tsarin gine-gine, PostgREST yana turawa zuwa tsarin gine-ginen bayanai (Data-Oriented Architecture), inda microservices ba sa adana jihohi da kansu, amma suna amfani da damar samun bayanai guda ɗaya (Layer Access Layer) don wannan.
Daga cikin canje-canje a cikin sabon sigar:
- An saka allunan da aka raba cikin ma'ajin tsarin ajiya, wanda ya ba da damar irin waɗannan teburan su haɗa ayyukan UPSERT da INSERT a cikin martanin Wuri, aiwatar da tambayoyin OPTIONS, da aiwatar da tallafin OpenAPI.
- Ta hanyar RPC POST ana ba da izinin kiran ayyuka tare da siga ɗaya mara suna.
- An ba da izinin kiran ayyuka tare da ma'aunin JSON ɗaya ba tare da taken "Prefer: params= single-object" header.
- Ana ba da izini don loda bayanan nau'in bytea cikin ayyuka ta amfani da buƙatun tare da "Nau'in Abun ciki: aikace-aikacen/octet-rafi".
- An ba da izinin loda rubutu zuwa ayyuka ta amfani da tambayoyi tare da "Nau'in Abun ciki: rubutu/bayani".
- Ƙara goyon baya don guje wa haruffa a cikin maɓalli biyu, misali, "?col=in.("Biyu"Quote"),
- An samar da ikon tace albarkatun matakin farko bisa ginanniyar tacewa ("/projects?select=*,abokan ciniki!inner(*)&clients.id=eq.12"
- Mai aiki da "is" yana ba da damar ƙimar "ba a sani ba".
- An cimma daidaituwa tare da PostgreSQL 14 kuma an dakatar da goyan bayan PostgreSQL 9.5.
source: budenet.ru