
Isomo rigufi · Kinyarwanda
Uko wakora kopi y’ingoboka kandi ugasubizaho amakuru y’urubuga rwawe
Manura kopi nyayo y'ingoboka y'inyandiko z'umwitozo watanzwe, uyigarure ahantu hatandukanye h'umwitozo hari ubusa ugenzure indangagaciro zagaruwe.
Ibi bigenewe nde?
Abashaka gusobanukirwa no kwemeza igarura ry'amakuru y'urubuga. Umwitozo wa mbere ukorera muri mushakisha ufite amakuru yiteguye; PostgreSQL, Bash n'amabwiriza yo kwimura imiterere ni inyigisho zimbitse z'ubushake.
Mbere yo gutangira
Mushakisha n'umwitozo wo kuri mudasobwa wa kopi y'ingoboka watanzwe. Nta konti, amakuru y'ibanga cyangwa gushyiraho ububiko bw'amakuru bikenewe kuri uwo mwitozo. Kopi y'ingoboka y'urubuga nyarwo rwakirwa na serivisi yongera gukenera ibikoresho bishyigikiwe na serivisi yawe n'uburenganzira; umwitozo w'ububiko bw'amakuru w'ubushake ukoresha ahantu ho kujugunywa gusa.
Igihe kigereranyijwe: 24–41 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. Uyu ni umwitozo wo gusohora imbonerahamwe imwe mu buryo bwa logical export, si igisubizo cyuzuye cya kopi z'ubutabazi zo mu kazi nyako cyangwa PITR. Konti z'ububiko bw'amakuru no kwinjiza ibikoresho bifata igihe cyiyongera.
Ibyo uziga
- Kora kopi y'ingoboka imanurwa aho kwishingikiriza kuri kode y'urubuga ibitswe.
- Garura ahantu hatandukanye h'umwitozo ugereranye inyandiko nyazo.
- Vuga amakuru n'uburenganzira by'urubuga nyabyo uyu mwitozo utareba.
Intambwe 1
Hitamo icyo kopi y'ingoboka irinda
Kode y'urubuga n'inyandiko zibitswe ni ibintu bitandukanye.
Fungura practice/index.html usuzume inyandiko z'inkomoko watanzwe n'ahantu hatandukanye hari ubusa ho kugarura. Izi ni inyandiko z'impimbano zo kuri mudasobwa, si ububiko bw'amakuru bw'urubuga rwawe nyarwo.
Kubika ububiko bwa kode y'urubuga gusa ntibyemeza ko inyandiko z'ifishi cyangwa ibyoherejwe bishobora kugarurwa. Vuga amakuru nyirizina uyu mwitozo ureba.
Urugero rufatika
Kode y'urubuga ishobora kuba muri Git mu gihe inyandiko z'abakiriya ziri mu yindi serivisi gusa.
Inkomoko yo muri mushakisha itangirana n’inyandiko ebyiri z’icyitegererezo: ID 1, “Practice note: first visitor task”, na ID 2, “Practice note: saved contact preference”. Akabuto ko kongeraho kazana ID 3, “Restore check: turquoise notebook”. Aya magambo y’icyitegererezo ari mu Cyongereza ni amakuru yo kugereranya uko yakabaye, si kode ugomba kwandika.
Fungura umwitozo wo kuri mudasobwa wa kopi y'ingoboka watanzwe. Mfasha kumanura kopi y'ingoboka y'inyandiko z'inkomoko, kuyigarura ahantu hayo hatandukanye hari ubusa no kugereranya ibiranga n'inyandiko nyirizina. Sobanura imbibi zo kuri mudasobwa mu kuri: iyi si kopi y'ingoboka yarangiye y'ububiko bw'amakuru bwakirwa na serivisi. Ninkoresha scripts za PostgreSQL z'ubushake nyuma, banza usuzumire hamwe nanjye inkomoko n'aho kugarura hari ubusa, kandi ntuzigere ukoresha amabwiriza asenya cyangwa ngo ugire icyo ukora ku rubuga nyarwo.Dosiye z'iyi ntambwe
Open or download the files below. When saving a project, keep the folder paths shown in the filenames.
How it works (optional)
Kora kopi y'ubutabazi y'amakuru werekana ko ushobora kuyasubizaho
Dosiye ya kopi y'ubutabazi igira akamaro gusa iyo ibirimo byayo bishobora kugarura imimerere ukeneye.
Ububiko bwawe bwa Git bushobora kugarura kode y'urubuga kandi butarimo inyandiko n'imwe z'ububiko bw'amakuru cyangwa dosiye zoherejwe. Kugarura amakuru bikenera gahunda yabyo.
Iri somo risohora imbonerahamwe imwe nto ya porogaramu ya PostgreSQL rikayisubiza mu bubiko bw'amakuru bwihariye burimo ubusa. Kugarukira kuri ayo makuru make bituma igerageza rya mbere ryo kugarura ryumvikana; imbonerahamwe igaragaza amakuru kopi ikubiyemo inasobanura neza ibyo itarinda.
Urugero rusobanuye
Inyandiko izwi ni «Restore check: turquoise notebook». Nyuma yo gusubizaho, tugomba gusoma ako gaciro nyine na ID yako aho twasubije amakuru, aho kubona gusa dosiye ya dump itarimo ubusa.
Extra implementation exercise
Kode y'umwimerere wawe iri muri Git. Ibyo byemeza ko ushobora kugarura amakuru yoherejwe muri fomu ejo hashize?
Erekana igisubizo gisobanuye
Oya. Inyandiko ziba mu bubiko bw'amakuru buri hanze y'ububiko bwa kode. Ukeneye inkomoko yo kugarura amakuru n'ibimenyetso ko isubizaho inyandiko zitezwe.
- Kode ya porogaramu itandukanywa n'amakuru abitswe.
- Hasabwa kopi y'ubutabazi y'amakuru n'igenzura ryo kuyasubizaho.
Ikosa rikunze gukorwa
Kwita Git clone kopi y'ubutabazi y'ububiko bw'amakuru bwo hanze na dosiye zoherejwe.
Intambwe 2
Manura kopi y'ingoboka ushobora gusuzuma
Kora dosiye nyayo mbere yo gusiba cyangwa guhindura ahantu hagamijwe aho ari ho hose.
Hitamo “Download backup” mu mwitozo wa hafi. Ikora practice-backup.json ivuye mu nyandiko z’inkomoko. Bika dosiye yamanutse; saba umufasha cyangwa igikoresho gisanzwe kureba ID ebyiri n’amagambo yazo atabihinduye.
Inkomoko n’aho kugarura biba muri uru rupapuro rufunguye gusa. Manura mbere yo kuruvamo cyangwa kongera gupakira, kuko uru rugero atari ububiko buramba kuri serivisi. Intambwe ikurikira igarura dosiye wamanuriye ahantu hatandukanye.
Urugero rufatika
Mbere yo kongera inyandiko, dosiye yasohowe igomba kugira inyandiko ebyiri: ID 1 na 2 n’amagambo y’inkomoko nyirizina. Izina rya dosiye umenyereye rifite izindi nyandiko cyangwa izibura si kopi y’ingoboka yifuzwa.
Gerageza ubwawe
Ni iyihe dosiye wasohoye, kandi ni izihe nyandiko wemeje ko irimo?
Ganira ku gisubizo cyawe n’umufasha w’isomo
Erekana igisubizo gisobanuye
Umwitozo umanura practice-backup.json. Mbere yo gukoresha Add, ntegereje ID 1 “Practice note: first visitor task” na ID 2 “Practice note: saved contact preference”. Nasuzuma izo ndangagaciro nyirizina muri dosiye yamanutse nkayibika mbere yo gufunga urupapuro.
- Agaragaza dosiye JSON yamanutse koko n’ibikubiyemo by’inkomoko.
- Yemeza ID n’amagambo byombi aho gufata izina rya dosiye ryonyine nka gihamya.
Dosiye z'iyi ntambwe
Open or download the files below. When saving a project, keep the folder paths shown in the filenames.
How it works (optional)
Sohora ibyo wagambiriye gusa
Hitamo amakuru ubigambiriye kandi ugumishe dosiye n'ibyangombwa byo kwinjira ari ibanga.
Kurikiza START-HERE.txt utegure ububiko bw'amakuru bubiri bwo kwitoza ushobora gusiba. Koresha seed.sql ku nkomoko gusa, hanyuma export.sh ukoresheje URL yayo y'ibanga yo guhuza. Dosiye y'ububiko yakozwe mu buryo bwa custom irimo imbonerahamwe yatoranyijwe; urutonde rw'ibirimo rukwemerera kugenzura neza amakuru yasohowe.
Scripts zikoresha no-owner/no-privileges kugira ngo dosiye zimurwe byoroshye. Ntizongera gukora uruhare rwa konti cyangwa uburyo bw'uburenganzira bwo mu kazi nyako. Gumisha dosiye z'ubutabazi ari ibanga kuko muri porogaramu nyayo zishobora kugira amakuru yihariye, kandi ukoreshe ibikoresho by'ububiko bw'amakuru bihuye.
Soma backups/contents.txt mbere yo gusubizaho. Kuri aya makuru yo kugerageza, shaka inyandiko zivuga TABLE public backup_practice_notes na TABLE DATA public backup_practice_notes, hamwe n'inzitizi yayo ya primary-key. ID z'imibare zo mu bubiko bwa dosiye n'amagambo biterwa n'uburyo bw'igikoresho. Urutonde rurimo indi mbonerahamwe gusa si ikimenyetso ko iyi mbonerahamwe yasohowe.
Urugero rusobanuye
Checksum ishobora gufasha kubona ihinduka rya dosiye ryabaye nyuma. Ntiyemeza ko ububiko bwa dosiye burimo imbonerahamwe zose zisabwa cyangwa ko hari umuntu ushobora kuyisubizaho.
PostgreSQL: gusohora amakuru na pg_dump · Supabase: ibyo kopi y'ubutabazi y'ububiko bw'amakuru ikubiyemo
Extra implementation exercise
Checksum y'ububiko bwa dosiye irakwiye. Ni ibihe bibazo bibiri by'ingenzi bigisigaye?
Erekana igisubizo gisobanuye
Amakuru yose yasabwaga yashyizwemo, kandi ashobora gusubizwaho neza mu buryo yari agenewe? Kuba dosiye itarahindutse cyangwa ngo yangirike bitandukanye no kuba yuzuye no kuba amakuru ashobora kugarurwa.
- Harabazwa niba ibyasabwaga byose byashyizwemo.
- Hasabwa gusubizaho koko n'igenzura ry'amakuru n'uburenganzira.
Ikosa rikunze gukorwa
Kohereza dump y'ububiko bw'amakuru mu bubiko bwa rusange kugira ngo byorohe kuyisangiza abandi.
Intambwe 3
Garura ahantu hatandukanye hagamijwe
Emeza indangagaciro zagaruwe aho kwemeza ubutumwa bwo kwinjiza gusa.
Muri “Separate restore target”, hitamo practice-backup.json wamanuriye. Gereranya buri ID n’amagambo byagaruwe n’inkomoko ikigaragara; aho kugarura hagomba ubu kugira izo nyandiko ebyiri zimwe, inkomoko idahindutse.
Hanyuma koresha urugero invalid-backup.json watanzwe, ruboneka kuri “Download an invalid example”. Rugomba kwangwa aho kugarura hamaze kuzura hagakomeza kuba uko hari. Uragerageza ko dosiye mbi idashobora gusimbuza amakuru meza yagaruwe.
Urugero rufatika
Kugarura inyandiko ebyiri kwatsinze kugira ID 1 na 2 ku mpande zombi. Nyuma yo kugerageza dosiye itemewe, izo nyandiko zimwe zigomba kugumaho; ikosa rigakurikirwa n’ahantu hasigayemo ubusa byananirwa igenzura ry’uburinzi.
Gerageza ubwawe
Garura kopi y’ingoboka y’inyandiko ebyiri, hanyuma ugerageze dosiye itemewe. Ni iki kigomba kuguma aho kugarura no mu nkomoko nyuma ya buri gerageza?
Ganira ku gisubizo cyawe n’umufasha w’isomo
Erekana igisubizo gisobanuye
Nyuma yo kugarura kwemewe, ahagenewe kugarura hagomba kugira amagambo amwe ya ID 1 na ID 2 nk’inkomoko. Nyuma ya invalid-backup.json, izo nyandiko ebyiri zigomba kugumaho hakerekanwa ubutumwa ko kopi itemewe. Inkomoko igomba kuguma idahindutse mu magerageza yombi. Ni amagenzura ategerejwe yo kugereranya n’ibyo mbona kuri ecran yanjye.
- Agereranya ID n’amagambo byagaruwe nyirizina akemeza ko inkomoko itahindutse.
- Yemeza ko amakuru atemewe asiga amakuru meza asanzwe aho kugarura uko ari.
Dosiye z'iyi ntambwe
Open or download the files below. When saving a project, keep the folder paths shown in the filenames.
How it works (optional)
Subizaho mu bubiko bwihariye burimo ubusa
Kwitoza kugarura ntibikwiye gusimbuza kopi yonyine ikora.
Koresha restore.sh ku bubiko bwihariye burimo ubusa kandi usuzume umwirondoro w'ububiko bw'amakuru yerekana mbere yo kwemeza. Ntikoresha --clean cyangwa DROP; imbonerahamwe isanzwe ihari ihurirana igomba gutuma binanirwa aho gusimbuzwa bucece.
Nyuma yo gusubizaho, suzuma imirongo yombi n'agaciro kayo nyako. Emeza ko inkomoko itahindutse. Kuri porogaramu nyayo, genzura kandi indexes, inzitizi, amasano, uruhare n'amategeko y'uburenganzira; uyu mwitozo muto ntuvuga ko utanga ibyo byemezo byagutse ku bushake.
Urugero rusobanuye
Aho usubiza amakuru hari iyo mbonerahamwe isanzwe si ububiko bwo kwitoza burimo ubusa iyi script yiteze. Banza usuzume aho kongeramo flags zisiba gusa kugira ngo ucecekeshe ikosa.
PostgreSQL: gusubizaho amakuru na pg_restore
Extra implementation exercise
Gusubizaho birananiwe kubera ko imbonerahamwe y'aho usubiza isanzwe ihari. Ugomba guhita wongeraho --clean?
Erekana igisubizo gisobanuye
Oya. Emeza ko wahisemo ububiko bw'amakuru burimo ubusa bwagenewe kwitoza ushobora gusiba. Koresha ahandi hashya harimo ubusa kuri uyu mwitozo aho kongeramo uburyo busiba utumva ingaruka zabwo.
- Habanzwa kugenzura umwirondoro w'aho usubiza n'imimerere yagenewe.
- Hirindwa gusiba cyangwa gusimbuza amakuru yari asanzweho mu buryo buyangiza nk'inzira yihuse yo gukemura ikibazo.
Ikosa rikunze gukorwa
Kwitoza kugarura usubiza amakuru hejuru y'ububiko bw'amakuru bwo mu kazi nyako bukora.
Intambwe 4
Subiramo wongeyemo inyandiko imwe nshya uvuge ibibuze
Umuco wa kopi y'ingoboka urimo kongera kugerageza amakuru yahindutse.
Hitamo “Add the third record”; inkomoko yunguka ID 3, “Restore check: turquoise notebook”. Manura kopi nshya uyibike itandukanye n’iya mbere y’inyandiko ebyiri. Hitamo “Empty target” mbere yo kugarura dosiye nshya; inkomoko igomba kuguma ifite inyandiko eshatu.
Gereranya ID n’amagambo by’inyandiko eshatu zagaruwe. Hanyuma ukoreshe recovery-plan.csv wandike ibindi urubuga nyarwo rukeneye: ububiko bw’amakuru nyabwo, dosiye zoherejwe, isano ry’amakuru, uburenganzira n’inzira yo kugarura ya serivisi. Scripts za PostgreSQL zikurikira ni umwitozo w’inyongera wihariye ku bubiko bwemejwe ko bushobora gusibwa.
Urugero rufatika
Dosiye ishaje ishobora kugarura neza ID 1 na 2 gusa. Kugira ngo ugarure inyandiko nshya ya turquoise notebook, ukeneye dosiye nshya y’inyandiko eshatu. Kugarura neza dosiye ishaje si gihamya ko amakuru mashya yagiriwe kopi y’ingoboka.
Gerageza ubwawe
Ibikoresho byo gutangiriraho
Dosiye n’amakuru yo kugerageza byaratanzwe. Kugenzura serivisi nyayo bisaba konti, imeli cyangwa domene yawe nk’uko ibisabwa bibivuga. Ushobora gusuzuma kuri mudasobwa; intambwe yo kuri serivisi utakoze uyandike ko itarageragejwe.
Tanga ibyo wiboneye bishya bya kopi y'ingoboka n'igarura n'urutonde rw'ibice birebwa by'urubuga nyarwo.
Ibyo ugomba gukora Dosiye ya kopi y'ingoboka y'umwitozo, inyandiko zagaruwe wiboneye n'ibisobanuro bisobanutse by'imbibi zo kuri mudasobwa ugereranyije n'urubuga nyarwo.
Ganira ku gisubizo cyawe n’umufasha w’isomo
Erekana igisubizo gisobanuye
Kopi nshya y’ingoboka yo kuri mudasobwa yanjye igomba kugarura ID 1 na 2 hamwe na ID 3 “Restore check: turquoise notebook” aho kugarura nasize ubusa. Dosiye ya mbere y’inyandiko ebyiri ntishobora kugarura ID 3. Ku rubuga nyarwo nateganya ukwabyo kugarura ububiko bw’amakuru na dosiye zoherejwe, nkagenzura isano n’amategeko yo kugeraho nkagerageza inzira ya serivisi yo kugarura; nta na kimwe muri ibyo cyemezwa n’iki gisubizo cya mushakisha.
- Agarura dosiye nshya y’inyandiko eshatu akagenzura amagambo ya ID 3 nyirizina hamwe na ID 1 na 2.
- Avuga amakuru y’urubuga nyarwo n’amagenzura yo kugarura umwitozo w’inyandiko za hafi utareba.
Dosiye z'iyi ntambwe
Open or download the files below. When saving a project, keep the folder paths shown in the filenames.
How it works (optional)
Umukoro wawe: gerageza kopi nshya y'ubutabazi kandi wandike ibibura
Garagaza uko amakuru yagaruwe ari aya vuba n'amakuru nyayo kopi ikubiyemo.
Ongeraho inyandiko ya gatatu yihariye ku nkomoko, ukore ububiko bwa dosiye bushya kandi ubusubize ahandi harimo ubusa. Andika igihe/hash byabwo, ID n'agaciro bizwi n'igihe gusubizaho byafashe.
Uzuza gahunda yo kugarura ku rubuga rw'igitekerezo rufite n'amafoto yoherejwe n'abakoresha binjira muri konti. Garagaza ibikoresho bya serivisi cyangwa izindi dosiye zisohorwa byarinda ibyo bice bibura, n'amagenzura yakwemeza ko byasubijweho.
Urugero rusobanuye
Umurongo w'ububiko bw'amakuru werekeza ku ifoto nturimo bytes z'ikintu cy'ifoto. Byombi bishobora gukenerwa kugira ngo urubuga rukore nyuma yo kugarura.
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.
Extra implementation exercise
Emeza ko inyandiko nshya isubizwaho kandi wandike urutonde nyarwo rw'ibirimo n'igenzura ryo kugarura.
Erekana igisubizo gisobanuye
Shyira imirongo ibiri izwi mu bubiko bw'amakuru bw'inkomoko bwo kwitoza gusa. Sohora imbonerahamwe yiswe, usuzume urutonde rw'ibirimo urebe inyandiko z'imbonerahamwe/amakuru/inzitizi kandi ubike hash yayo mu ibanga. Ibi bisohorwa ntibirimo izindi mbonerahamwe, uruhare, uburenganzira, kwemeza umwirondoro cyangwa bytes za dosiye zoherejwe.
Subizaho mu bundi bubiko bw'amakuru burimo ubusa bwo kwitoza ushobora gusiba umaze kugenzura umwirondoro wabwo. Soma ID 1 n'inyandiko nyayo 'Restore check: turquoise notebook', hamwe na ID 2. Genzura ko inkomoko itahindutse. Ikosa rivuga ko imbonerahamwe isanzwe ihari ni impamvu yo gukoresha ahandi harimo ubusa, si iyo kongeramo flags zo gusukura zisiba.
Ongeraho ID 3 ifite inyandiko nshya yihariye, ukore ububiko bwa dosiye bushya kandi usubize ahandi hashya. Genzura imirongo itatu yose neza uko iri. Uzuza gahunda yihariye yo kugarura dosiye zoherejwe/kwemeza umwirondoro/uburenganzira bibura; ntuvuge ko uyu mwitozo w'imbonerahamwe imwe wagaruye izo sisitemu.
- Amakuru mashya asomwa mu bubiko bwihariye bwasubijwemo amakuru.
- Dosiye, kwemeza umwirondoro n'uburenganzira bibura biragaragazwa mu buryo bweruye.
Ikosa rikunze gukorwa
Kwibwira ko gusubizaho imbonerahamwe byagenze neza byemeza ko serivisi yose ishobora kugarurwa.
Iri somo ryagufashije?
Kanda ko urikunze, cyangwa urisangize uwo ryafasha.
Komeza kwiga
- Uko wakora urubuga rwawe rwa mbere
- Uko wasohora urubuga rwawe uhereye kuri GitHub
- Uko wahuza domeni yawe n'urubuga rwawe
- Uko wategura imeli kuri domeni yawe
- Uko watuma urubuga rwawe rukoreshwa kuri telefoni
- Uko watuma amafoto y'urubuga afunguka vuba
- Uko wakwakira ibitekerezo byo ku rubuga muri inbox yawe
- Uko wakongeramo kwiyandikisha kwakira email ku rubuga rwawe
- Uko wakohereza emails zikora ku buryo bwikora ziva ku rubuga rwawe
- Uko wabika ibyoherejwe binyuze muri fomu muri database
- Uko wakwemerera abantu kwinjira muri konti ku rubuga rwawe
- Uko wagumisha urupapuro ari ibanga
- Uko wakwemerera abakoresha guhindura amakuru y'umwirondoro wabo
- Uko wakwemerera abakoresha kohereza amashusho
- Uko wakumira imfunguzo za API muri frontend yawe
- Uko wakwerekana amakuru ava muri API yo hanze ku rubuga rwawe
- Uko wakongeramo AI chatbot ku rubuga rwawe
- Uko watuma chatbot isubiza ishingiye ku birimo byawe
- Uko wakongeramo blog ku rubuga rwawe
- Uko wakongeramo ishakisha ku rubuga rwawe
- Uko wakongeramo urundi rurimi ku rubuga rwawe
- Uko wafasha Google kubona urubuga rwawe
- Uko wakosora iyerekanwa ry'urubuga rwawe igihe usangiza umurongo
- Uko wapima gusurwa n'ibikorwa by'ingirakamaro ku rubuga rwawe
- Uko wakwemerera abarusura gufata gahunda yo guhura nawe
- Uko wakwakira ubwishyu ku rubuga rwawe
- Uko wareba impinduka z'urubuga mbere yo kuzisohora
- Uko wasubira inyuma nyuma yo gusohora urubuga rwangiritse
- Uko wabona kandi ugakosora amakosa ku rubuga rwawe ruri ku murongo