Isomo rigufi · Kinyarwanda

Uko wabika ibyoherejwe binyuze muri fomu muri database

Bika ifishi y'urubuga mu mushinga w'ububiko bw'amakuru w'umwitozo watanzwe, hanyuma wemeze ko inyandiko ikihari nyuma yo kongera gufungura urupapuro.

Tangira isomo rikorwamo imyitozoSoma inyandiko z’isomo

Ibi bigenewe nde?

Abashaka ko ibyoherezwa ku rubuga bibikwa. Umufasha wo kwandika kode ashobora gushyiraho igenamiterere ryatanzwe no guhuza ifishi; nta kwandika SQL cyangwa kode ya seriveri bisabwa.

Mbere yo gutangira

Umushinga wawe wa Supabase ushobora gusibwa n’umushinga wa Netlify-function wo kwitoza. Koresha dosiye zose watanzwe n’umufasha wo kwandika kode mu gutegura. Amabanga ya konti y’ububiko bw’amakuru agume kuri seriveri; gerageza ubutumwa bw’impimbano gusa. Ibisubizo by’icyitegererezo si amagerageza yakorewe kuri konti yawe. Simbuza ibyo byabonetse n’ibyo wiboneye cyangwa uvuge intambwe ikiguhagaritse.

Igihe kigereranyijwe: 20–37 min

Igihe kigereranyijwe ukoresheje dosiye zo gutangiriraho zatanzwe, konti n’ibikoresho bikenewe byamaze gutegurwa. Gutegura, gutegereza gushyira urubuga kuri interineti, imeli cyangwa DNS bishobora gufata ikindi gihe. Gutunganya konti ni umurimo wiyongera kuri uyu. Uyu mwitozo ugenzurwa si serivisi rusange yo kwakira ibitekerezo bitazwi ababitanze; suzuma imipaka irambye yo kurwanya ikoreshwa nabi mbere yo kuwuhindura uwo gukoresha ku mugaragaro.

Ibyo uziga

  • Ohereza inyandiko y'ifishi mu bubiko nyabwo.
  • Emeza ko ibitswe bigumaho ubirebeye mu mbonerahamwe ya serivisi.
  • Anga ibyinjijwe bitemewe utagaragaje inyandiko za buri wese.

Dosiye z'imyitozo

Intambwe 1

Sobanura icyo kubika bivuze

Inyandiko igomba kubaho hanze y'urupapuro rwa mushakisha rufunguye ubu.

Fungura ifishi yiteguye uri kumwe n'umufasha uhitemo ubutumwa bw'impimbano bwihariye. Tuzabubika binyuze kuri seriveri yatanzwe mu bubiko bw'amakuru butandukanye bw'umwitozo.

Agaciro kakigaragara ku rupapuro si gihamya ko kabitswe mu bubiko bw'amakuru. Teganya kubona ubutumwa bumwe muri serivisi na nyuma yo kongera gufungura.

Urugero rufatika

Imbonerahamwe ya serivisi n’urupapuro rwa mushakisha uriho ni ahantu hatandukanye. Ubutumwa bukiguma mu mbonerahamwe umaze gufunga porogaramu bwerekana byinshi kurusha interuro ikigaragara iruhande rwa buto yo kohereza.

Koresha umushinga wo kubika ibitekerezo watanzwe. Mfasha gushyira imiterere yawo yatanzwe gusa mu bubiko bwanjye butandukanye bwa Supabase bw'umwitozo no gushyiraho ibanga ry'ibidukikije bya seriveri. Komeza kubuza abashyitsi kugera ku mbonerahamwe y'ibitekerezo. Tangiza ifishi, unyobore ku mbonerahamwe ya serivisi kandi umfashe kugenzura ko amakuru yemewe agumaho naho ubusabe butemewe ntibukore umurongo. Sobanura amagenzura yanjye, si imyandikire ya SQL.

Supabase: ububiko bw'amakuru bwa database

Dosiye z'iyi ntambwe

Start hereDosiye z'imyitozo

Open or download the files below. When saving a project, keep the folder paths shown in the filenames.

How it works (optional)

Bika inyandiko hanze ya mushakisha

Umurongo wabitswe muri database ugomba gukomeza kubaho nyuma yo gufunga paji.

Variable ya JavaScript ibura iyo paji yayo ifunzwe. Local storage ya mushakisha iguma muri iyo mushakisha. Database ibika inyandiko kuri serivisi porogaramu yawe ishobora kugeraho hakurikijwe uburenganzira bwasobanuwe neza.

Turakoresha imbonerahamwe yihariye ya Supabase na server function. Mushakisha yohereza ubutumwa bugufi; seriveri ikabugenzura kandi ikandika umurongo. Iri somo ntirishyira hanze endpoint rusange itondeka ubutumwa bwa buri wese.

Urugero rusobanuye

Nyuma yo kohereza “Database test D1” (ubutumwa bwo kugerageza database D1), funga paji ushake ubwo butumwa nyine muri table editor y'umushinga wawe. Ubutumwa bugaragara muri paji gusa si gihamya yo kubikwa.

Supabase: ububiko bw'amakuru bwa database

Extra implementation exercise

Paji yawe yerekana ubutumwa bwoherejwe ikoresheje variable yayo. Ese ibyo byemeza ko database yabubitse?

Erekana igisubizo gisobanuye

Oya. Genzura umurongo nyawo muri database. Mushakisha yashobora kwerekana ibyanditswe n'ubwo nta busabe bwagiye kuri seriveri.

  • Atandukanya ibigaragara kuri paji no kubikwa.
  • Agenzura umurongo uhuye na byo binyuze mu buryo bwo kureba database bufitiwe uburenganzira.

Intambwe 2

Tegura umushinga w'ububiko utandukanye

Saba umufasha gushyiraho ibyatanzwe mu mutekano.

Kora cyangwa uhitemo umushinga wawe wa Supabase ushobora kujugunywa. Saba umufasha gusuzuma no gufasha gushyiramo schema.sql, gushyiraho indangagaciro z'ibanga no gukoresha umushinga wuzuye akurikije run-locally.txt.

Emeza umushinga ukwiye mbere yo gushyiraho impinduka. Ntukemere ko abashyitsi rusange bareba ibitekerezo byose; koresha Table Editor ya nyir'umushinga usuzume umurongo w'igerageza.

Urugero rufatika

Imbonerahamwe feedback yatanzwe ifite ubutumwa, ID yakozwe na sisitemu n’igihe cyaremwe. Nyir’umushinga ashobora kuyireba muri serivisi; iri gerageza ntirisaba ko abashyitsi basoma ubutumwa bwa buri wese.

Supabase: umutekano ku rwego rw'umurongo · Node.js: imimerere y'uburyo busohotse bushyigikiwe

Dosiye z'iyi ntambwe

Start hereDosiye z'imyitozo

Open or download the files below. When saving a project, keep the folder paths shown in the filenames.

How it works (optional)

Kora imbonerahamwe yihariye yo kwigiraho

Fungura row-level security kandi ugumane gufunga uburenganzira butaziguye bwa mushakisha muri ubu buryo bw'icyitegererezo.

Koresha iyi schema gusa mu mushinga wa Supabase wo kwigiraho witandukanyije n'indi, wavuzwe mu byo watunganyije. Uburenganzira bwa mushakisha buragabanywa ku bushake; genzura umurongo nka nyir'umushinga muri Dashboard → Table Editor. Ntukoreshe schema y'uyu mwitozo kuri database ikoreshwa mu bikorwa nyabyo.

Kora umushinga wa Supabase wo kwigiraho utandukanye kandi ukoreshe schema.sql muri SQL editor yawo. Imbonerahamwe ifite ID yikora, ubutumwa bufite imipaka n'igihe gishyirwaho na seriveri. Ntukoreshe impinduka za schema y'icyitegererezo kuri database y'ibikorwa nyabyo idafitanye isano na yo.

Script ifungura row-level security kandi ikambura inshingano za mushakisha uburenganzira ku mbonerahamwe. Secret/service-role key ya seriveri ishobora kwandika ifite uburenganzira bwo hejuru; igomba kuguma kuri seriveri. Publishable browser key iratandukanye kandi ntitanga ubwo burenganzira bw'ubuyobozi.

Fungura Table Editor muri dashboard y'umushinga wa Supabase usuzume umurongo wawe w'igerageza; aha si developer console ya mushakisha. Iyo kwinjiza byanze, suzuma igisubizo cya seriveri n'imiterere ya database/schema y'umushinga. Ntufungure SELECT ku batinjiye muri konti gusa kugira ngo urebe niba kwinjiza byagenze neza.

Ku ruhererekane rwuzuye rwo kuri mudasobwa yawe, fungura run-locally.txt: tegura igenamiterere ry'ibanga rya seriveri muri dosiye .env iri mu bubiko shingiro bw'umushinga, hanze ya public/ kandi idakurikiranwa na Git; huza gusa umushinga wo kwitoza kandi utangize proxy ya Netlify functions. server-env.example.txt itondeka amazina ya variables idafite amabanga nyayo. Gufungura HTML gusa ntibishobora gukoresha seriveri.

Urugero rusobanuye

Nta tegeko rigari rya “allow all” rikenewe muri uyu mwitozo unyura kuri seriveri. Gufungura SELECT ku batinjiye muri konti kugira ngo usuzume ikosa byanashyira ubutumwa bwoherejwe ku mugaragaro.

create table public.feedback (
 id uuid primary key default gen_random_uuid(),
 message text not null check (char_length(message) between 1 and 1000),
 created_at timestamptz not null default now()
);
alter table public.feedback enable row level security;
revoke all on public.feedback from anon, authenticated;
grant insert on public.feedback to service_role;
-- No browser read/write policies: the practice server uses its secret key.

Supabase: umutekano ku rwego rw'umurongo · Node.js: imimerere y'uburyo busohotse bushyigikiwe

Extra implementation exercise

Ubusabe bwa mushakisha bwaranzwe. Ese ugomba kubikemura wemera ko abatinjiye muri konti basoma imbonerahamwe yose y'ibitekerezo?

Erekana igisubizo gisobanuye

Oya. Ubu buryo bwanga gusoma kwa mushakisha ku bushake. Genzura imiterere yo kwandika ya seriveri kandi usuzume imbonerahamwe nka nyirayo.

  • Arinda umupaka wateganyijwe w'amakuru yihariye.
  • Akoresha inzira ya seriveri cyangwa dashboard ifitiwe uburenganzira aho gufungurira bose gusoma.

Intambwe 3

Ohereza inyandiko ivuye ku rupapuro

Reka seriveri yiteguye ikore kwandika mu bubiko.

Fungura porogaramu nyayo y'umwitozo ikora kuri mudasobwa cyangwa yakirwa na serivisi, wohereze ubutumwa nka D1. Saba umufasha kugumana gusa imyanya y'umushyitsi igamijwe mu nyandiko ibitswe.

Shaka inyandiko nyayo ya D1 mu mbonerahamwe ya serivisi usuzume ikiranga n'igihe byayo byakozwe. Ntushyire amabanga ya konti mu mafoto ya ecran cyangwa inyandiko zisangizwa.

Urugero rufatika

Ohereza D1, hanyuma ushake iyo nyandiko nyirizina muri feedback. ID yakozwe na sisitemu itandukanya uyu murongo n’ubutumwa bwa kera busa; umushyitsi ntagomba kwihitiramo cyangwa kwandika hejuru y’iyo ID.

Dosiye z'iyi ntambwe

Start hereDosiye z'imyitozo

Open or download the files below. When saving a project, keep the folder paths shown in the filenames.

How it works (optional)

Huza uburyo bwo kwandika kuri seriveri bubanza kugenzura amakuru

Seriveri ihitamo imbonerahamwe n'imyanya yemewe; usaba atanga ubutumwa gusa.

Tunganya variables eshatu za seriveri zavuzwe maze utangaze cyangwa ukoreshe umushinga utandukanye wa function. Ugerageza yinjiza kode y'uburenganzira bw'umwitozo. Iyo kode yemerera gukoresha iyi endpoint igenzurwa, si konti ya Supabase.

Soma mini-feedback.mjs: function igenzura method, kode y'uburenganzira, ingano n'ubutumwa mbere yo guhamagara serivisi. Yirengagiza IDs cyangwa amazina y'imbonerahamwe yatanzwe n'usaba, kandi isubiza ko kubika byagenze neza gusa nyuma y'igisubizo cyemeza kwinjiza byagenze neza.

Urugero rusobanuye

Ubusabe burimo umwanya w'inyongera wa admin ntibuhinduka ivugurura ry'ubuyobozi: seriveri ikora object nshya irimo message gusa.

Extra implementation exercise

Kuki gukora {message} aho kohereza muri database object yose ya JSON ivuye muri mushakisha?

Erekana igisubizo gisobanuye

Bituma schema seriveri yemera isobanurwa neza kandi bikarinda ko imyanya itateganyijwe yandikwa. Na message igomba kugenzurwa; gutoranya imyanya byonyine ntibihagije.

  • Agabanya imyanya ishobora kwandikwamo.
  • Ntiyizera IDs, ibihe cyangwa uburenganzira bigenzurwa na porogaramu y'umukoresha.

Intambwe 4

Genzura kugumaho no kunanirwa

Subiramo igikorwa umaze gufunga urupapuro rwa mbere.

Funga wongere ufungure porogaramu, hanyuma wemeze ko D1 ikiri mu bubiko. Gerageza ibyabuze, ibirenze ingano na kode y'umwitozo itari yo mu mushinga ushobora kujugunywa.

Amagerageza atemewe ntagomba gukora imirongo mishya. Ubutumwa bw'intsinzi bwa mbere ntibugomba kugumaho nk'aho igerageza ryakurikiyeho ryananiranye na ryo ryabitswe.

Urugero rufatika

Andika umurongo wemewe mbere y’amagerageza yo kwanga, hanyuma wongere urebe imbonerahamwe. “Ifishi yerekanye ikosa” na “nta murongo utemewe wongeweho” ni ibice bibiri by’igenzura bifite akamaro.

Dosiye z'iyi ntambwe

Start hereDosiye z'imyitozo

Open or download the files below. When saving a project, keep the folder paths shown in the filenames.

How it works (optional)

Genzura ko amakuru agumaho n'ibyanze

Koresha inyandiko zitandukana kandi usuzume database utisunze ibigaragara kuri paji.

Ohereza D1 ukoresheje kode nyayo y'umwitozo kandi usuzume umurongo uyihuye muri table editor. Funga wongere ufungure paji, hanyuma wemeze ko umurongo ugihari. Andika ID n'igihe byawo utamennye cyangwa ngo usangize abandi amabanga ya konti.

Gerageza ubutumwa butarimo, ubutumwa burengeje ingano na kode y'uburenganzira itari yo. Nta na kimwe kigomba gukora umurongo mushya. Mu mushinga ushobora gusibwa nyuma, genzura ko kubura imiterere ya seriveri bitanga igisubizo cy'ukuri cyo kunanirwa.

Urugero rusobanuye

Inyandiko imwe yemewe hamwe n'ubusabe bubiri butemewe bwanzwe bitanga amakuru arenze gukanda gatatu bigenda neza gusa. Mu mwitozo wa mbere, irinde gukoresha ibitekerezo nyabyo by'abantu.

Extra implementation exercise

Endpoint isubije ikosa, ariko mushakisha iracyavuga “Saved” (byabitswe) bivuye ku igerageza ryabanjirijeho. Ni iki ugomba kugenzura?

Erekana igisubizo gisobanuye

Genzura niba agaciro gashya gafite umurongo. UI igomba kwerekana kunanirwa kw'ubu, kandi intsinzi yabanje ntigomba kubarwa nk'igisubizo cy'iri gerageza.

  • Agenzura igisubizo cy'ubu n'agaciro gashya k'igerageza gatandukanye n'akabanje.
  • Ntongera gukoresha ubutumwa bw'intsinzi bwa kera nk'igihamya cy'ubusabe bwanze.

Intambwe 5

Ongeramo ingingo utahaye bose amakuru

Koresha umufasha ahindure umwanya usuzume ibivuyemo.

Saba umufasha kongeramo ingingo ebyiri Project na Question mu ifishi, mu gutegura ububiko no mu kugenzura kuri seriveri. Indangagaciro zibikwa ni project na question. Urugero watanzwe ni urwo kugereranya nyuma y’igerageza ryawe, si aho ugomba gushakira igisabwa.

Kora inyandiko imwe y’igerageza ugenzura kuri buri ngingo, ugerageze n’itemewe other ufashijwe n’umufasha. Genzura indangagaciro zabitswe no kwangwa, ugumane imbonerahamwe feedback idasomwa n’abashyitsi.

Urugero rufatika

Ongeramo ingingo ebyiri zemewe Project na Question. Buri gaciro kahiswemo kabikwe iruhande rw’ubutumwa bwako. Other ni igerageza ryo kwanga, bityo urutonde rwiza rwo guhitamo rwonyine ntirurangiza guhindura ububiko.

Dosiye z'iyi ntambwe

Start hereDosiye z'imyitozo

Open or download the files below. When saving a project, keep the folder paths shown in the filenames.

How it works (optional)

Umukoro wawe: bika topic yabanje kugenzurwa

Ongera icyitegererezo cy'amakuru na seriveri icyarimwe udafunguye uburenganzira bwa mushakisha.

Ongeramo inkingi ya topic yemera gusa project cyangwa question. Hindura seriveri igenzure urutonde rw'ibyemewe kandi ikore object yo kwinjiza mu buryo busobanutse. Ongeramo umwanya wa fomu uhura na byo.

Kora inyandiko imwe kuri buri topic yemewe kandi wange agaciro katemewe. IDs n'ibihe byikora bigume kugenzurwa na database.

Muri uyu mwitozo DEFAULT iha question imirongo isanzwe. Iyo nta gaciro cyangwa default ihari, kongeramo inkingi ya NOT NULL bishobora kwanga mu gihe hari imirongo isanzwe. Mu kwimura schema nyabyo, hitamo agaciro ko kuzuza amakuru asanzwe ukurikije ayo makuru aho gukoporora default y'uyu mwitozo.

Urugero rusobanuye

Igisabwa cya database gishyigikira igenzura rya seriveri. Nta na kimwe gisimbura uruhare rw'ikindi mu gutanga amakosa yumvikana no kurinda ukuri kw'amakuru.

Ubuyobozi bwuzuye bw'urugero buri muri reference/assignment-walkthrough.txt. Gereranya intambwe zabwo n'ibyo wakoze; uzuza inyandiko y'igerageza ukurikije ibyo wabonye mu mushinga wawe.

-- Existing rows need a value when the new column is NOT NULL.
alter table public.feedback add column topic text not null default 'question';
alter table public.feedback add constraint feedback_topic_allowed
 check (topic in ('project','question'));

Extra implementation exercise

Ongeramo umwanya wa topic kandi wemeze ko amakuru yemewe agumaho, mu gihe atemewe yangwa.

Erekana igisubizo gisobanuye

Kongeramo topic bisaba ko ibice bitatu bihuza: select yo muri mushakisha, urutonde rw'ibyemewe rwa seriveri n'inkingi ya database ifite check constraint. ALTER TABLE y'icyitegererezo ikemura imirongo isanzwe y'umushinga watangiranye na wo, iyigenera topic ya default yasobanuwe mbere yo gushyira mu bikorwa igisabwa.

Seriveri yandika {message,topic} gusa. Igomba kwanga topic itemewe mbere yo gukoresha ibanga ry'uburenganzira bwa database. Igomba kandi kwirengagiza IDs n'amazina y'imbonerahamwe yatanzwe n'usaba, kandi ikagaragaza kwandika kwa serivisi kwanze nk'ukunaniwe.

Suzuma message/topic nyayo yabitswe muri Table Editor ya dashboard ya Supabase, aho kwishingikiriza ku gika cy'intsinzi cyo muri porogaramu y'umukoresha. Ongera upakire paji cyangwa ufunge mushakisha, wemeze ko inyandiko imwe yabitswe igihari. Koresha uburyo bwo gusuzuma bugenzurwa na nyiri konti; ntufungure gusoma ku batinjiye muri konti kugira ngo ukemure ikibazo.

  • Igenzura rya topic riri kuri seriveri no muri database.
  • Imirongo yemewe ihuye n'ibyoherejwe igumaho, kandi agaciro katemewe ntigakora imirongo.

Iri somo ryagufashije?

Kanda ko urikunze, cyangwa urisangize uwo ryafasha.

Komeza kwiga

Reba andi masomo