
Isomo rigufi 10 kuri 30 · Gutuma urubuga rwawe rugira akamaro
Sobanura icyo kubika bivuze
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.
Inyandiko igomba kubaho hanze y'urupapuro rwa mushakisha rufunguye ubu.
Intego y'iri somo
- Ohereza inyandiko y'ifishi mu bubiko nyabwo.
- Emeza ko ibitswe bigumaho ubirebeye mu mbonerahamwe ya serivisi.
- Anga ibyinjijwe bitemewe utagaragaje inyandiko za buri wese.
Ibisobanuro, urugero rusobanuye n'imyitozo
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.
Reba ubumenyi bwo gutangiriraho
Ni ubumenyi bw’ingirakamaro, si amasomo utegetswe kubanza kurangiza. Niba ubuzi, tangirira hano; niba utabwuzi, fungura amasomo y’imyiteguro. Dosiye zo gutangira ziratanzwe; ntukeneye urubuga rwawe wari usanganywe.
- Uko wasohora urubuga rwawe uhereye kuri GitHub
Huza ububiko bw'umwitozo na serivisi yakira imbuga.
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.
Sobanukirwa igitekerezo
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.Dosiye z'iyi ntambwe
Tangirira hanoDosiye z'imyitozo
Fungura cyangwa umanure dosiye zikurikira. Iyo ubika umushinga, komeza imiterere y’ububiko igaragazwa mu mazina ya dosiye.
Gerageza ubwawe
Uzareba he kugira ngo wemeze ko ubutumwa bwawe bwabitswe koko?
Erekana igisubizo gisobanuye
Igisubizo cy’icyitegererezo: ndohereza inyandiko y’impimbano “D1 — blue notebook”, nshake ubwo butumwa nyirizina mu mbonerahamwe feedback ya nyir’umushinga, hanyuma mfunge nongere mfungure porogaramu ndebe ko bukirimo. Ikirango ku ifishi ni igisubizo cya mbere kigaragara gusa.
Ibigize igisubizo gikwiye
- Agaragaza inyandiko ijyanye yabitswe kuri serivisi y’ububiko bw’amakuru nka gihamya yo kubika.
- Ashyiramo kongera gufungura cyangwa gupakira aho kwishingikiriza ku kimenyetso cy’intsinzi cy’igihe gito.
Uko bikora (si itegeko)
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
Undi mwitozo wa tekiniki
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 1 · Uko wabika ibyoherejwe binyuze muri fomu muri database
Tegura umushinga w'ububiko utandukanye
Saba umufasha gushyiraho ibyatanzwe mu mutekano.
Ibisobanuro, urugero rusobanuye n'imyitozo
Sobanukirwa igitekerezo
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.
Dosiye z'iyi ntambwe
Tangirira hanoDosiye z'imyitozo
Fungura cyangwa umanure dosiye zikurikira. Iyo ubika umushinga, komeza imiterere y’ububiko igaragazwa mu mazina ya dosiye.
Gerageza ubwawe
Ni uwuhe mushinga w'umwitozo wateguye, kandi ushobora kumenya aho nyirawo arebera imbonerahamwe?
Erekana igisubizo gisobanuye
Inyandiko y’igenamiterere y’icyitegererezo: umufasha yakoresheje schema.sql mu mushinga wanjye ushobora gusibwa gusa, ategura indangagaciro z’ibanga za seriveri atangiza porogaramu yatanzwe. Nshobora kureba feedback nka nyir’umushinga muri Table Editor. Abashyitsi rusange ntibashobora gusoma iyo mbonerahamwe.
Ibigize igisubizo gikwiye
- Agaragaza umushinga wo kwitoza ushobora gusibwa n’ibyarangiye cyangwa ibyahagaze mu gutegura schema na seriveri byatanzwe.
- Abona feedback muri Table Editor ya nyir’umushinga atafunguye uburenganzira bwo gusoma bw’abashyitsi.
Uko bikora (si itegeko)
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
Undi mwitozo wa tekiniki
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 2 · Uko wabika ibyoherejwe binyuze muri fomu muri database
Ohereza inyandiko ivuye ku rupapuro
Reka seriveri yiteguye ikore kwandika mu bubiko.
Ibisobanuro, urugero rusobanuye n'imyitozo
Sobanukirwa igitekerezo
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
Tangirira hanoDosiye z'imyitozo
Fungura cyangwa umanure dosiye zikurikira. Iyo ubika umushinga, komeza imiterere y’ububiko igaragazwa mu mazina ya dosiye.
Gerageza ubwawe
Ni iki cyagaragaye mu ifishi no muri serivisi kuri D1?
Erekana igisubizo gisobanuye
Inyandiko yo kubika y’icyitegererezo: ifishi yavuze ko ubutumwa bwabitswe. Mu mbonerahamwe feedback ya serivisi y’umwitozo nabonye “D1 — blue notebook” ifite ID n’igihe byakozwe na sisitemu. Nabitse iyo ID mu nyandiko zanjye z’ibanga kugira ngo menye uwo murongo nyuma.
Ibigize igisubizo gikwiye
- Ahuza inyandiko D1 yoherejwe nyirizina n’umurongo wa serivisi ufite ID n’igihe byakozwe na sisitemu.
- Avuga ibisubizo by’urupapuro n’iby’ububiko ukwabyo atagaragaje igenamiterere ry’ibanga.
Uko bikora (si itegeko)
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.
Undi mwitozo wa tekiniki
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 3 · Uko wabika ibyoherejwe binyuze muri fomu muri database
Genzura kugumaho no kunanirwa
Subiramo igikorwa umaze gufunga urupapuro rwa mbere.
Ibisobanuro, urugero rusobanuye n'imyitozo
Sobanukirwa igitekerezo
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
Tangirira hanoDosiye z'imyitozo
Fungura cyangwa umanure dosiye zikurikira. Iyo ubika umushinga, komeza imiterere y’ububiko igaragazwa mu mazina ya dosiye.
Gerageza ubwawe
Ni izihe nyandiko zagumyeho nyuma yo kongera gufungura, kandi byagenze bite ku magerageza yawe atemewe?
Erekana igisubizo gisobanuye
Inyandiko yo kwanga y’icyitegererezo: nyuma yo gufunga no kongera gufungura urupapuro, D1 yagumye mu mbonerahamwe ya serivisi. Ubutumwa busa n’ubusa, bunini birenze n’ikode itari yo ntibyaremye imirongo mishya. Igerageza ryabiranye ryerekanye ikosa aho gusiga Saved message ya mbere igaragara nk’aho yongera gukoreshwa.
Ibigize igisubizo gikwiye
- Agenzura ko inyandiko yemewe yagaragajwe igumaho nyuma yo kongera gufungura.
- Yemeza ko ubusabe butemewe bw’amakuru cyangwa uburenganzira butongeramo imirongo kandi ntibusige ikimenyetso cy’intsinzi kibeshya.
Uko bikora (si itegeko)
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.
Undi mwitozo wa tekiniki
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 4 · Uko wabika ibyoherejwe binyuze muri fomu muri database
Ongeramo ingingo utahaye bose amakuru
Koresha umufasha ahindure umwanya usuzume ibivuyemo.
Ibisobanuro, urugero rusobanuye n'imyitozo
Sobanukirwa igitekerezo
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
Tangirira hanoDosiye z'imyitozo
Fungura cyangwa umanure dosiye zikurikira. Iyo ubika umushinga, komeza imiterere y’ububiko igaragazwa mu mazina ya dosiye.
- schema.sqlKuramo iyi dosiye
- netlify/functions/mini-feedback.mjsKuramo iyi dosiye
- storage-record.txtKuramo iyi dosiye
- worksheet.htmlKuramo iyi dosiye
- reference/assignment-walkthrough.txtKuramo iyi dosiye
- reference/START-HERE.txtKuramo iyi dosiye
- reference/public/index.htmlKuramo iyi dosiye
- reference/public/app.jsKuramo iyi dosiye
- reference/netlify/functions/mini-feedback.mjsKuramo iyi dosiye
- reference/add-topic.sqlKuramo iyi dosiye
Gerageza ubwawe
Tanga impinduka y'ingingo n'ibisubizo wiboneye byo kubika ibyemewe no kwanga ibitemewe.
Ibyo ugomba gukora: Inyandiko y'ububiko yakuwemo amakuru y'ibanga igaragaza kugumaho kw'ibyemewe n'iyangwa ry'amagerageza atemewe.
Erekana igisubizo gisobanuye
Inyandiko y’inyongera y’icyitegererezo: “D2 — project test” yagumanye ingingo project; “D3 — question test” yagumanye ingingo question. Agaciro katemewe other karanze nta murongo mushya karema. Nabisuzumye nka nyir’umushinga; uburenganzira bw’abashyitsi bwo gusoma imbonerahamwe yose bwakomeje kubuzwa.
Ibigize igisubizo gikwiye
- Abika indangagaciro za Project na Question hamwe n’inyandiko z’igerageza zihuye na zo.
- Yanga ingingo itemewe ariko abashyitsi bagakomeza kutabasha gusoma imbonerahamwe feedback.
Uko bikora (si itegeko)
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'));Undi mwitozo wa tekiniki
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.