ProHoster > Блог > ozi ịntanetị > Mwepụta nke PostgREST 9.0.0, mgbakwunye maka ịtụgharị nchekwa data ka ọ bụrụ API RESTful

Mwepụta nke PostgREST 9.0.0, mgbakwunye maka ịtụgharị nchekwa data ka ọ bụrụ API RESTful

A tọhapụrụ PostgREST 9.0.0, sava weebụ na-arụ ọrụ iche yana mmejuputa ihe mgbakwunye dị fechaa na PostgreSQL DBMS, na-atụgharị ihe site na nchekwa data dị na API RESTful. Kama ịdepụta data mmekọrịta n'ime ihe (ORMs), PostgREST na-emepụta echiche ozugbo na nchekwa data. Akụkụ nchekwa data na-ejikwa usoro nke nzaghachi JSON, nkwado data, na ikike. Arụmọrụ sistemu zuru oke iji hazie arịrịọ 2000 kwa sekọnd na sava nkịtị. Edere koodu ọrụ ahụ na Haskell wee kesaa n'okpuru ikike MIT.

Dịka ọmụmaatụ, iji naanị usoro ihe ùgwù nchekwa data, ị nwere ike ịnye ohere ịnweta data (tebulu, ụdị nlele, na usoro echekwara) na HTTP. N'okwu a, ọ dịghị mkpa itinye koodu ntụgharị asụsụ dị otú ahụ ma na-abụkarị otu iwu GRANT na-ezuru iji mee ka tebụl dị site na API REST. Ọ ga-ekwe omume ịhazi ohere site na token (JWT) wee hazie “multitenancy” site na iji nchekwa larịị dị ike (Nchekwa Ọkwa Ahịrị).

N'usoro ihe owuwu, PostgREST na-aga n'ihu na ụlọ ọrụ dabere data (Data-oriented Architecture), ebe microservices anaghị echekwa steeti n'onwe ha, mana jiri otu ohere ịnweta data (Data Access Layer) maka nke a.

Mwepụta nke PostgREST 9.0.0, mgbakwunye maka ịtụgharị nchekwa data ka ọ bụrụ API RESTful

N'ime mgbanwe ndị dị na ụdị ọhụrụ:

  • Agbakwunyere tebụl ndị kewara ekewa na nchekwa nchekwa schema, nke mere ka o kwe omume maka tebụl ndị dị otú ahụ itinye ọrụ UPSERT na INSERT na nzaghachi ọnọdụ, mee ajụjụ OPTIONS, ma mejuputa nkwado OpenAPI.
  • Site na RPC POST a na-ahapụ ya ka ọ jiri otu oke akpọghị aha ya kpọọ ọrụ.
  • A na-ahapụ ya ka ọ jiri otu paramita JSON kpọọ ọrụ na-enweghị isi "mmasị: params=otu ihe" nkụnye eji isi mee.
  • A na-ahapụ ya ịkwanye data nke ụdị bytea n'ime ọrụ site na iji arịrịọ nwere "Ụdị Ọdịnaya: ngwa/octet-stream".
  • Enyere ohere ibunye ederede n'ime ọrụ site na iji ajụjụ nwere "Ụdị Ọdịnaya: ederede/plain".
  • agbakwunyere nkwado maka ịgbanarị mkpụrụedemede n'ime braket abụọ, dịka ọmụmaatụ, "?col=in."
  • Enyerela ikike iji nzacha akụrụngwa ọkwa mbụ dabere na nzacha arụnyere (“/projects?select=*,clients!inner(*)&clients.id=eq.12”
  • Onye ọrụ "bụ" na-enye ohere uru "amaghị".
  • Enwetala ndakọrịta na PostgreSQL 14 yana nkwado maka PostgreSQL 9.5 kwụsịrị.

isi: opennet.ru

Tinye a comment