Ikhorali Enganikezeliyo: Isikhokelo njengoMaleko wogcino-lwazi lweSQL

I-Gradeus imisa ulawulo lwayo ngokugquma i-SQL isiseko sakho sedata esikhoyo ngaphandle kokubeka i-proprietary schema okanye izitshixo ze-data. Ngokungafaniyo nemigangatho yeCMS enyanzelisa isakhiwo somxholo esiqinileyo, i-Draidus ibona i-SQL istyres yakho ye-SQL .

Imvelaphi yeWYSIWG neModeli yokuqulathiweyo

Iqela lolawulo linikezela ngonikezelo olusekelwe kwindima yomakhi ababonakalayo apho abahleli benolawulo lwe data enxulumeneyo, ingqokelela yesihluzi, kunye nokutsala- phantsi media kwithala leefama yedata ephakathi. Auto-generated systems(isekelwe kwiintlobo zoluhlu ezifana [ imibhalo[, [[FLT]] [2] JY] [[FLT]] [[FLT]], [[FLT:]] [4]], okanye inters]file iimbekisekiso-[[[FLT:] [[FLT]] [[FLT]] [iiiiiiiiiiiinter', [iiiiiiiiiindlela], [iiiiiiindlela] , ithumela [iindlela] imiyalelo yokuhamba ngaphandle ko bhala ikhowudi zangaphambili, amacandelo, amacandelo, amacandelo, amacandelo, amaqua

Umzekelo, inkampani yentengiso ingenza ikhathegothi yemveliso enamasimi aqhelekileyo afana , , , kunye ngqo] ukusuka kwi-dmin yolawulo. I-database engaphantsi ye-SQL ihlala ingatshintshanga, kodwa ujongano lweqela luzitshintsha ngoko nangoko. Oku kuphelisa iisikhokelo eziqinileyo ze CMS kwaye kunika amaqela inkululeko kwimodeli yedata kanye njengoko i-e-commerce ifuneka, uvimba wesixhobo sokugcina ulwazi, okanye ugcino-lwazi lwenzululwazi. Umlawuli uxhasa imisebenzi emikhulu, ukurhweba/indawo ephakathi, kunye nokujongisa ngokungqalileyo kwe-SL e-echnnertiokence, ngexesha eligcina amava angazinzileyo.

Ugcino - lwazi Olufuzisela Ngaphandle Koloyiko

I-Studio yogcino-lwazi olubonakalayo ivumela amaqela ukuba adwelise ii-database ezintsonkothileyo ze-accomplican ngaphandle kokubhala iifayile ze-SQL. Abasebenzisi bangadala iitafile, bachaze [[FL:0]] ulwalamano oluninzi oluya kulwandiso , iqokelelo, kwaye alawule iincam ze-geostatial, JSON izinto, kwaye i-arhesss transfreftive transfy ireams. Oku kuthetha ukuba nayiphi na into ekhoyo esuka kwibrorho elula yesixhobo se IOT i-IT i-rective, igcina isiseko sogcino nesemgangathweni xa inkqubo yemodeli iqhubeka ingabonakali ngqo.

Ukuvuka KweAPI: Ukwamkela Umvuzo Ongenantloko

Utshintsho olubalulekileyo kuhambo Oluthe ngqo lukwalatha okupheleleyo kwe-paradigm engantloko. Ngelixesha iqela lolawulo lolawulo lisebenza abasebenzisi babantu, iqonga ngokuzenzekelayo lenza amandla HEST[FL:1] kunye GRAphQL[[FL]][FL:3] AP] AP ebonakalisa utshintsho lwesiseko sedata kwixesha lokwenene. Lo maleko we-API awulo ncam ecacileyo yokurhweba ngaphandle okanye isiphelo esimiswa ngesandla; uphila, ukungenisa isango lobuqu obuvela kwimode yogcino-lwazi lwakho. Zonke iindawo ezintsha, ulwalamano, okanye ukunyanzela kuwe ukuchaza kwi-data ephuma ngokukhawuleza kwi AP. Olu phawu oluqhelekileyo lwebhombumbumbu yokukhula.

I-REST negrafuQL: Iintsika Ezibini

Isizukulwana esizenzekelayo sesiphelo se RETT sinika amandla abaphuhlisi abakwazi ukwenza imisebenzi ye CRUD ngokucola okunzulu, ngokuntsonkothileyo, kunye nedabi lokuqinisekisa. Amapharamitha afana , , , [[FLT:]] kwaye ibonakalisa uthambeko lwe SQL iingxaki ngelixa ukhuseli lwezitokhwelo olusuka kwimijelo ekhoyo. Ibonisa ukukhusela ukuhlasela ngemijozo ejikayo. IgrafuQL ixhasa ukutsiba okunzima: ngokucofa kanye, abaphuhlisiixesha elinye ukubuza nge-exakeka, ngaphandle kokuchaza uqwalaselo oluqhelekileyo. Xa i- khowudi engundoqo i- khowudi ecacileyo i-----ective i-gney-----exaney i------thectory i--thectory ichaza ngqo.

Inkqubo yoqinisekiso ixhasa umqondiso we JWT, imiqondiso emileyo, kunye ne SSO idibanisa, iqinisekisa ukuba yonke imiba yombuzo ithetha imigca- yomgangatho wolawulo. Olu dibaniso lobubhetye-bhadu nokhuseleko luthetha i-Draice lungasebenza njengesiseko sogcino-lwazi lwenkqubo zothengiso, amaqonga e-media, okanye iibhodi ezinqamlezileyo zangaphakathi ngaphandle kongezelelweyo. Kwiziphelo ezibonisa umgangatho we- nkonzo, abaphuhlisi bangasebenzisa i-ASICACHING[ izihloko kunye nezicelo zemiqathango zokunciphisa umthwalo emqulukweni. I-API ngokwayo ikhutshwa ngokupheleleyo kwaye ixhasa zombini iimpendulo ezisezantsi ze-JSON kunye neCSVSV kugcino-lwazi lwemfazwe.

Ithuba lokwenene lexesha kunye neNkxaso yeSiseko se-Web

Inwena ngaphaya kwesicelo- spremponse methods, iDirectus ngoku ixhasa izinikezeli zexesha lokwenene zigqitha kwi Web Coskets. Xa ugcino-lwazi lutshintsha kwisiseko sedata . Njengendlela entsha ebekweyo okanye inqaku elipapashwayo. /iindlela ezidityanisiweyo zifumana uhlaziyo olukhawulezileyo ngaphandle kokuphosa. Lo msebenzi ubalulekileyo kubomi bodwi beebhodi, izicelo ezisebenzisa isalathisi sesiphelo sokwaziswa zikhuselekile ngokusebenzisa uqinisekiso olufanayo kunye nemodeli yemvume, iqinisekisa ukuba abasebenzisi kuphela abagunyaziyo bamkela ulungiso lwe data abavunyelwa ukuba bajonge. Le ndaleko ukusuka kwimijelo esebenzayo ye data yemida edityanisiweyo yemiculo- processs zangoku, iprojective- systnation.

Injini yokuqulathiweyo: Ukufuzisela ugcino-lwazi kunye nosebenziso oluzenzekelayo

Njengoko amava amanani ekhula entsonkothile, i-Directus isuka kwimvelaphi yogcino-lwazi engasebenziyo kwinjini yolwakhiwo olusebenzayo. I-Ugcino-lwazi olubonakalayo Studio luvumela amaqela ukuba adwelise iisiseko sogcino-lwazi esintsonkothileyo ngaphandle kokubhala iifayile ze SQL ezifudukayo. Abasebenzisi bangenza iitafile, bachaze ulwalamano oluninzi, ukuqokelela, kwaye balawule iincam ze-geospatial, JSON, kwaye basebenzisa i-intebon, kwaye basebenzisa imodeli kwisixhobo esilula sokubhala iifayile ze-IOT, bagcina isiseko sogcino-lwazi esicocekileyo kunye nomgangatho xa inkqubo yemodeli isoloko iqhutywa. Ngaphezu koko, uxhasa umgangatho wento esebenzayo kunye ne-extrans, iiflegi ezifunekayo kwi-'i-'igropu esebenzayo.

Ukujinga okuzenzekelayo

Isiqalo se Flows iguqula idireyidis kwinjini yesandisi. Ezi zingena khowudi-equation ixhobisa uluvo lwento ekwiziganeko ezifana nobhaliso lomsebenzisi, impapasho, okanye imigangatho yamacandelo afikelela kwi qanda. Uqukuqelo lungadibanisa iiwebrozi ukudibanisa ii-webroks ukwazisa okanye i-Rode, yenza uluvo olunento kwimigxubeko yokuhlawula, iguqula ugcino-data ngomakhi abasebenzayo, okanye ujikelezo lwemicu. Umzekelo, inkampani ye SaaS iyakwazi ukuchaza abasebenzisi abatsha ngokubotshelelwa kwe we we we web ukuthumela iGrid ngovavanyo lwemicimbini yohlobo lomsebenzisi. Ngoku isebenza njenge gluel-okie, ukusasayo, ukusasaza ngaphandle kokusasa komsebenzi weseva.

Intlanganisela yemodeli yokubona kunye nesiganeko-sokwenza uphando lomatshini ozenzekelayo lunciphisa ixesha lophuhliso. Amaqela angajika-jika ukusuka ekuphumeleni kunye nezixhobo ezimbalwa phakathi kwe-IA kunye namasebe okuthengisa. Ukujija kukwaxhasa [[FLT: 0] iingcinga ezixhobisayo zoqhaqho loqhaqho-zi, kunye nezixhobisayo [[FLT]] ezidityanisiweyo [[FLT]] zisebenzisa iintetho zeqela lemisebenzi efana nogcino-data syncs. Udityaniso kunye neenkqubo zangaphandle luye luye lucaciswe ngakumbi kunxulumano olungaphambili olwakhiwe kunye namandla okubhala imisebenzi yesiqhelo kusetyenziswa ngokwendlela yokusebenza.

Ugcino-lwazi olugobeyo kunye nombuzo oqhubela phambili

Ngaphezu kwesiseko seCRUD, iDirecus ingaphezulu ekuphatheni idata enzulu. Iqonga lixhasa [[FLT:] ezininzi- ukuya-kunonye, ukuguqulela izitshixo zesiseko sogcino-lwazi kwamanye amazwe kwithambeka lento eyenzekayo kunye nokukhetha imida emininzi. Kwimo ephambili, abasebenzisi bangachaza [[FLT:] iitafile ze-fritantion [ kunye nezongezelelweyo kwemibathatha (umz., i"furse" itafile enxulumanisa "abasebenzisi" kunye "nemida"). I-API ngokwayo ibonakalisa ezi ntshukumo, ivumela imilinganiso ehambayo yomgama emininzi. Umzekelo, ukuhamba kwendlela yokuhamba, ukubukeza, nokusebenzisa i-freyimoni ye-Greyimoni yendalo yenza i-Geneeat transfties, i- projectives, i-types transtivements, iprojectives, i-type yenk

Ubuchule Nolawulo: Indima, Iimvume, noLawulo

Ngemfuno enkulu yolawulo olungqongqo. Abaphathi bachaza iimvume eziqhelekileyo zolawulo olunamandla Role- esekelwe kwisiseko solawulo lonikezelo (RBAC) ngobuchule botyando, ihamba ngaphaya komgangatho wetafile- kumgangatho wesithintelo kumgangatho webala nomgangatho wokhuseleko. Abalawuli bachaza iimvume zonikezelo lomthetho wolwazi lwendawo nganye esebenzisa icebo elinamandla lokulungisa imbonakalo elikwizipili ze-API. Umzekelo, umxhasi wentengiso unakho ukumiswa kuphela ukukhokelela ekuboneleni kwimimandla yabo, lo mphathi wemveliso akanakutshintsha amasitalato kodwa angatshintsha kwiqela lenjongo ethile. Olu phawu lwaphezulu lukwabela kwindawo yolawulo lomlawuli ngokwalo.

Ulawulo lokufumana okune Grane

Iimvume zomaleko zixhasa ukhuseleko olude ngemiqolo ecacileyo yezihluzi. Imithetho eqhelekileyo yokusebenza kunye nomo wommandla obonakalayo iqinisekisa ulungiso logcino-lwazi lobuchule benkqubela yoshishino. Iplatfomu ixhasa kwakhona isalathisi esingaphandle [[FL:2] ku- SOLT] [[FLT]] [[FLT]] izinikezeli eziquka i-SAMLL, OUT2] kunye ne OuluID, ezinceda ukukhusela ulawulo lwemijelo yebhodi ekhuselekileyo kulwando olunesidima lwamaqela ehamba kakuhle. dibanisa zonke iindlela inguqulelo, xa zisenziwa, kwaye namaxabiso amadala nezintsha ebeziyimbali zemeko ezicacileyo zolungiso lwendlela yokulungisa nokulungisa. Umlinganiselo wokulawula ulawulo lwe-data olunee-ACPI)[5] kunye nokuxhasa ulawulo oluseko-e-e-e-e-FT.[FT]

Inkxalabo kunye nenjongo yogcino-lwazi

Isalathisi sivumela abalawuli ukuba baqwalasele iinkqubo ezizenzekelayo zogcino-lwazi, ukukhupha okanye ukufunyana iirekhodi zebugocigo ngokusekelwe kwimiqobo eqwalaselweyo. Idityaniswe neeplagi kunye nomphakamo wendawo efihlakeleyo (indawo efihlakeleyo amasimi atyhafisiweyo amagama ayimfihlo okanye iikhom ezifihlakeleyo iikholam [[FLT: 3] zedata enzima] yogcino-lwazi oluchuliweyo), iplatfomu inikeza ulawulo olubanzi logcino-lwazi oluluntsonkothile. Abalawuli be GDPR, bayakwazi ukurhoxisa okanye ukususa ugcino-lwazi kwiqela lomsebenzisi kwifayile okanye i- API, ulwanelise ekunene- izicelo zekhowudi eziqhelekileyo. Oku kwenziwa kwisixhobo sokunxibelelana kwendlela esezantsi, kunye nemali.

Ulwandiso kunye neenkqubo ze-Ecosystem: Amandla okwenziwa kuqheleke

Akukho qonga lingasombulula yonke incam. Abaphuhlisi bangakha iimodyuli zesithethe, iincam, kunye nerhintyela elinwebekayo kwimo ye-injini( nge U-. Umbhekisi phambili angadala umdibaniso wendlela yesixhobo sokulinganisa, isikhonkwane somatshini obangela ukuba ufunde kwimodeli yemifanekiso, okanye isiphelo se REX se-SK inika iprojekthi ye-scrected ezisekwe phambili ze-'injini(ukusuka kwi- API ukuya kwi UI'. Umbhekisi phambili angadala umdibaniso wesixhobo sokulinganisa isantya, irhintyela esemva ebangela ukuba umatshini bafunde kwimodeli yemifanekiso elayisha icebo elintsonkothile. I SDK inikeza udidi lwe- scd-scd- traptting, udidi lophuhlisopt.

Isongezo Se-SDK

I SDK inikeza isakhiwo esicwangcisiweyo sempahla yosasazo. Imisebenzi yomthengi ifakwa kwimida ehambayo, okanye iibhodi zogcino-lwazi ezakhiweyo zisebenzisa i Vue.js isixhobo sesixhobo sokunikezela ngaphakathi kwe scadio. Isalathisi siba yilaphu le data elimhlophe elithunyelelwa nakweyiphi na ishishini, ukusuka kwisebe lobuphini lokwakha, ngaphandle kokwaphula umgangatho wobuchule obusezantsi kwi- injini engundoqo iqinisekisa iqonga elihlala liqinileyo kwaye kulula ukuligcina. Ulwandiso lusasazwa njengempahla enokuthi ifakwe kwiqela lenjongo ye-DMFS okanye kwinpm, kwaye ixhasa uguqulelo lolawulo lobuphini.

Umzekelo, iqonga le e-commerce lingakha isiphelo sendlela esiqhelekileyo esidibanisa ixabiso elipheleleyo le-algorithm, ngoko lityhile njengendawo ephelela kuyo iwebhaki ukwenzela uhlaziyo lokwenene lwexabiso. Oku kusebenza kookruthalela abaphuhlisi bobuchule bokongeza imisebenzi eyodwa ngexesha ugcina ikhowudi engundoqo icocekile. Ulwandiso luquka iimpahla zoluntu ezibhaliswe ngokudibanisa iimpahla zoluntu eziqhelekileyo ezifana ne-Prime, Algolia, kunye no-Twilio, ukunciphisa uphuhliso oluqhubekayo ngaphezulu. Ukuzinikela kobuchule bokwenza intengiso kuthetha ukuba njengoko ushishino lwakho lufuna ukuguquka, iqonga likhula nawe ngaphandle kokuba ufuna ukufuduka okupheleleyo.

Ilifu Elithe Tyhidileyo Nemfumba Yale Mihla

Incopho yendaleko yeNgqongqo-moya kukudibana kwayo kwi Devop yale mihla ngakwi iDirectus Lifu elipheleleyo . Ngokuphatha izibonelelo, ulinganiso oluzenzekelayo, kunye ne-CDN-engasemva kwe-active trans translate amaqela asebenzisa iqonga njengendawo esemva-a-Service. Ukunyusa i-CMS esebenzayo ngokupheleleyo enobubanzi bomhlaba wonke kuthatha imizuzu, ukushwampulula kwebhokisi yebhokisi kunye neqela le-enodenti. Iimeko zamafu zivela ngokuvavanywa kolwa olwakhiweyo, okuzenzekelayo kogcino-mthetho, kunye noclo olusuka kumsebenzi wogcino lwenqanawa olupheleleyo xa ulawulo olupheleleyo.

Isiphumezi se-data se-Evolution yenkonzo

Phantsi kwekhusi, iNode.js kunye ne Vue.js yephepha enye yesicelo amandla umlawuli weqela. Ukwakhiwa kulungelelwaniso lolwamkelo kunye nokuzilungiselela okungenayo iseva, ithetha izikhonkwane zetrafiki kwiphulo lentsholongwane azize ziwathobe amava omhleli. Ukulayisha iDevops ukuya kwiqonga kugqiba isangqa sesamvo solwazi olulawuleke ngokupheleleyo. Amaqela ogcino-lwazi angajolisa kwimodelidi kunye nokhuphiso lwe-am. Ilifu likwakhomba ukubeka [[[FLT: 0]] okungqongileyo okunento ecacileyo, okwenza asebenze amaqela avavanye ukufuduka notshintsho loqwalaselo phambi kokukhutshwa kwemveliso.

Imisebenzi

Ubuchule obuphambili bokwenza uphatho lolwahlulo-mali luchaphazela wonke umaleko, ukusuka kumbuzo wangaphakathi kunye ne-schema sisasaziso sokuqulathiweyo sidlula kwi CDNS elungele iGrafkQL caching. I-tradeus inganxulumana nolawulo lwe SQL izinikezeli njenge [[[FL:0]] Planet Paquel[ okanye NT][FLT]], iqinisekisa ukuba ithambo lomzimba likwimo eliphakathi alisebenzi kwaye linexesha eliqinileyo lokusebenza. Iindlela zokuphendula zihlala ziqinile namaxesha amaninzi ngokunqamle kwemithi entsoko. Iqonga ixhasa [[FLTLT:] i-'evet [FLD] ukutyhubela i-evelk-evective-actives transtiesties, iqinisekisa ukuba iziphumo ezithe ukunikezelwa kwe-data eziphezulu zichaziko.

Uhambo Lokutshintsha Amanani

Ukujonga isiqingatha sesazinge ukusuka kwingingqi elula yokupapasha imidibaniso yesiseko sogcino-lwazi olucacileyo, oluzenzekelayo, kunye nomgangatho wogcino-lwazi osetyenziswa ngamafu utyhila ugcino-lwazi lokwenyaniso luka-Dixelo. Utshintsho luchazwa ngokumathelela okungaguquguqukiyo kwi-SQL ngelixesha lufakela ubunkimbi benkqubela-phambili yangoku. Amandla okuqala esiseko sogcino-lwazi kunye nolawulo lwezixhobo adityaniswe kwi-okhestracs ecureaces, ulawulo lwe-data kumgangatho wasemasimini, kwaye ithumela igrafuQL izibo zoqwalaselo ngoqwalaselo lwezicwangciso zoqwalaselo. Olu hambo oluqhubekayo luqinisekisa ukwakhiwa kwakho kobugcisa bobugcisa bobugcisa obunemicinenke luthintelwe kuphela ngemicineno, hayi ngamadonga abathengi.

Njengokuba ukwenziwa kwemisebenzi kunye nokusebenza ngaxeshanye kwedata yexesha lokwenene kufuna ukuba kubekho uphakamiso oluphezulu, indlela engaphambili iquka isiganeko sokwemdabu esiqukuqela kunye nokuqina kwe-Web sisock. Sele, iKhorale izama nge enyanileyo] imisebenzi yentsebenziswano yexesha elikhoyo [ efana noko ukufumana kuGoogle Docs, ukuvumela abahleli abaninzi basebenze kwirekhodi enye. Isiseko sogcino-data evuliweyo nobuchule sele simisela ideleteus hayi njengenkqubo eqinileyo, kodwa njengenjini engapheliyo yokuqalisa. Utshintsho oluqhubekayo luzibophelele kwinkululeko, ukubonakala, nokulandela okungapheliyo kogcino-data oluthambileyo. Ukuba uqala ulwakhiwo oluthambileyo olusebenzayo okanye olunembuyiseleko olujikelezayo, olunengcekelele kwindlela ye-edistrustrust, AP, ulawulo oluchuzungeyo oluguqu-lukileyo oluguqukileyo oluguqukileyo