Ikhorali Elingayekethisi: Isiqondiso Njengesindla - sisekelo Semininingwane Ye - SQL

I-tradeus imisa ukubusa kwayo ngokusonga i-SQL yakho ekhona ngaphandle kokuguqula umugqa owodwa we-proprietary propritary noma izihluthulelo ze-data. Ngokungafani nama-CMS avamile acindezela isakhiwo esiqinile, i-Draidus ibona i-SQL i-schema yakho ye-SQL. U-Relate PostgreSQL, MYSQL, noma SQLite/AN ngaphandle kokushintsha umugqa owodwa we-imfihlo we-inter SQL. Loluphetho lwesisekelo lwesisekelo nikeza amaqembu angabonakali indawo ezungezile ekwazi ukulawula izinto ezijwayelekile zemishini enjengemitayela yezemitayela neWSIYG. Amandla angempela akhona awenzisa i-data yakho engekho umthetho osukile.

Imvelaphi Ye - WYSIWG Nezimo Ezikuqukethe

I-dmin umlawuli unikeza ukufinyelela okusekelwe-engxenyeni kumakhi obonakalayo lapho abahleli bengaphatha khona imniningo ehlangeneyo, ukuqoqa amaqoqo, nokudonsa-okanye-odola emtatsheni wezincwadi wengcebo. Okuzenzekelayo--okhefinev( okusekelwe kwizinhlobo ze-' imibhalo[, [[FLT]]] [[FLT]]] JSON [[FLD]] [[FLT]], , , noma filefile] izikhombo [[[[FLD:]]] [[FLT]] [iqembu] amaqembu okuhamba ngokushesha ngaphandle kokubhala phambi kwe-omkhondo. [indlela] Izimiso zokwaziswa ezihlanganisa amathensi, ama-mime, ama-exmotemplet, ne-octivern, imithetho ezimiso, ngisho nemithetho, nalectus, nalectus

Ngokwesibonelo, inkampani yabadayisi ingakha uhlu lomkhiqizo olunezindawo ezisemthethweni ezifana ne-, , , kanye ngqo ku-ne-dmin umlawuli. I-SQL database ihlala ingashintshiwe, kodwa i-projekthi ye-projekthi iyazivumela ngokushesha. Lokhu kususa ama-tekthi aqinile e-CMS amaqophathishi futhi kunikeza amaqembu inkululeko yokubeka i-data yesibonelo ngendlela edingekayo kanye kanye nange-commerce, umlondolozo wezindaba, noma imniningwane yokucwaninga kwezesayensi. Umlawuli usekela imisebenzi emikhulu, ukungenisa/ukuthumela-export, futhi ngisho nokuqondisa i-SLProphithiwe bonke abasebenzisi, kuyilapho bonke abakwazi ukuhlelwa ngokushesha.

Ukulingisa Imininingwane Ngaphandle Kokwesaba

I-Teach ebonakalayo Studio ivumela amaqembu ukuba asebenzise izisekelo zokuhlela eziyinkimbinkimbi ngaphandle kokubhala amafayela e-SQL afudukayo. Abasebenzisi bangadala amathebula, bachaze [[FL:0]] ngobungane obuningi , iqoqo, futhi alawule amachashaza e-geostialial, i-JSON, futhi asebenzise izisekelo ze-JSON, futhi asebenzise i-arhesstion-droadrom-meter. Lokhu kuveza noma yini ethathwe kuyi-injini elula ukuya kwisisetshenziswa esincane se-IT, ukugcina i-data nesejwayekile lapho inqubo yokuveza inqubo iqhubeka iqhutshwa ngokubonakalayo. Ngenxa yokuthi amabala awe amabala enziwe ngokuqondile nge-UI abonakala ngokushesha emfucushweni efihlekile. Lokhu kusho ukuthi i-DBA i-DBA ikwazi ukuphatha ngokuqondile futhi iqoqo lezekethensi, iqoqo leze itala yemishi yemishi ezindaweni entsha ingekho umkhankaso yomkhankaso.

Ukuphaphama: Ukwamukela Indida Engenakhanda

Ushintsho olubalulekile kuhambo luka-Fraceus luwukwamuka okugcwele kwe-paradigm engaphethe. Nakuba umlawuli wendawo esebenzela abasebenzisi babantu, umgangatho ngokuzenzekelayo wenza amandla kanye ne-Graph [[FLT]L] AP] AP] Arem ebonisa ushintsho lwesayensi yemininingwane esikhathini sangempela. Longqimba lwe-API alusona indawo engaphandle noma emiswa ngesandla; luphila, luveza indlela yakho yokubhala ngesibonelo se-data yakho. Yonke indawo entsha, ubuhlobo, noma ukunyathela i-apba i-aI. Lolu mshini awukhonzi olusukanga phambili kwe-aP.

IREST Negrafu QL: Izipho Ezimbili

Isizukulwane sezindawo ezizisebenzelayo ze-RETST sinika amandla abathuthukisi abakhi be-CRUD ukuba benze imisebenzi yokuhluza okujulile, ukuhlela okuyinkimbinkimbi, kanye nezinga eliqinisekisiwe. Ama-paramitha anjenge , , , futhi [[FLT:]] bavezwe ngokuqondile, babonisa ukuvuleka kwe-SQLTH uma bevikele ukuhlasela okungaqondani kwemijovo ngokusebenza. I-Graclectus ivumela ukuhoshoza okuncane kokugxaba ngomjovo ngokusebenza kwayo. I-injini ivumela ukuhoxa i-oka, umlobi, i-echacingle, ngaphandle kokubukeza i-i-evi yeqiniso.

Isimiso sesiqiniseko sisekela izimpawu ze-JWT, izimpawu ezisendaweni ephezulu, kanye nama-SSO universes, iqinisekisa ukuthi zonke izinsongo zithinta izimvume zomgqa-mqoka ezichazwe ehlungweni lika mlawuli. Lenhlanganisela yokuvumelana nokuphepha isho u-Draictus ingasebenza njengendawo yokusekela i-data yezinhlelo zokuthengisa, ama-tept, noma ama-crosts angaphakathi ngaphandle kwemimetains. Abathuthukisi bangasebenzisa futhi ama-accounting izihloko kanye nezicelo zemibandela yokunciphisa ukufaka emtatsheni. I-API ngokwayo ihlelwe ngokugcwele futhi isekela kokubili ukusabela okuvamile kwe-JSON kanye no-CVSVSV kudinga i-data yempi.

Ithuba Lesikhathi Sangempela kanye nokusekela kwesikhoxe

Inwebeka ngalé kwemikhondo-yokucela, i-Draiceus manje isekela izikhokhelo zangempela zesikhathi nge-Web Sickers. Uma umniningo ushintsha uhlelo olusha noma isihloko esikhishweyo. /abaxhumanisi bathola izingeniso ezisheshayo ngaphandle kokuhlola. Lesici sibaluleke kakhulu kuma-crossboard, izinhlelo ezisebenzisana, kanye nezimiso zokuqaphelisa. I-Web - shopperndicendice ikhuselwa ngokusebenzisa isiqinisekiso esifanayo nesibonelo semvume, iqinisekisa ukuthi abasebenzisi kuphela abagunyazi abathola izimvume zokubona ukwaziswa. Le nguquko esuka ekusebenziseni i-API elula izikhombisweni zemininingwane ye-Drectus zezenstructions zezemklayo yanamuhla, izakhiwo zezezezezezezenzakalo.

Injini Yokuhlanganisa: Ukulingisa Ukwaziswa Nokuzihambela

Njengoba okuhlangenwe nakho kwemitapo kuya ngokuyinkimbinkimbi, i-Fraidus isuka emthonjeni wemininingwane engasebenzi ibe injini yokuqukethe esebenzayo. I-Visual Data Studio ivumela amaqembu ukuba athole izitayela eziyinkimbinkimbi ngaphandle kokubhala amafayela e-SQL afudukayo. Abasebenzisi bangakha amatafula, bachaze amathebula amaningi-ukuhlangana, ukuqoqa, futhi balawule amachashaza e-geospatial, JSON izinto, futhi basebenzise i-mfono-mfono-mfono. Le mishini isuka kwi-mfakthalela ekhoneni elula kuya kwi-injini elula ye-IOT, igcina i-data nesilinganiso lapho inqubo yokubeka ilokhu ihamba. Ngaphezu kwalokho, isekela [FLT:] indawo eqinile [FLD] kanye ne-mfoswom, idinga ama-ex-tempss, futhi i-mo-hene ye-temptive-thensial produt.

Ukugeleza Ngokuzenzakalelayo

Isethulo se- Flows iguqula i-Draices injini yesakhi. Lokhu kuhamba ngendikima kubangela ukuhluzeka komqondo ngokwezenzakalo njengokubhalisa komsebenzisi, ukukhipha izihloko zezihloko, noma amazinga ama-stock afinyelele ezixekweni. Ugebezo lungahlanganisa ulwembu lokwazisa u-Srecree noma u-Flute, ukwenza ukuqondisisa okunemibandela ngokufaka i-dictives, ukushintsha imininingwane ngomayela osuzi zokusebenza okuhleliwe, noma ukuguqula ngemidwebo. Ngokwesibonelo, inkampani ye SaaS yayinganikeza izimpawu ezintsha zabasebenzisi be-imeyili ngokufaka ucingo lokuthumela ngemibandela yohlobo lomsebenzisi. I-Frectus isebenza njengensula yohlobo lomsebenzisi.

Inhlanganisela yokuveza nokuhlela izenzakalo inciphisa kakhulu isikhathi sokuthuthukisa. Amaqembu angajikeleza kusukela ekukhiqizeni ngemishini embalwa phakathi kwe-II kanye neminyango yokuthengisa. Imisebe futhi isekela izimpawu ezishukumisayo[ zokubulala ngokuzenzakalelayo, kanye nezenzo zomthetho [[FLT] ezisuthiwe ngokusebenzisa izinkulumo ze-cron zemisebenzi efana ne-minist syncs. Ukunyakaza ngezimiso zangaphandle kulula ngokwengeziwe ngokuxhumana kwangaphambili okwakhiwe nekhono lokubhala imisebenzi yesiko ngokunwebela isimiso senqubo.

Imininingwane Yokubuyisela Nokubuza Okuqhubekayo

Ngaphezu kwe-CRUD, i-FRACUD ingcono kakhulu ekuphatheni ulwazi olujulile. Iqophelo lisekela [[FLT:] eziningi-kuya-ku-noma yi, ukuhumusha izihluthulelo zangaphandle ezingeni eliphansi kanye nokukhetha izimpawu eziningi. Izimo eziphambili, abasebenzisi bangachaza amatheku [onke] anemimetha yokuxhumana (umk., i-"fullse" itafula elixhuzula "abenzi" ne"imiboniso-mbili"). I-API ibonisa ngokuzenzekelayo lokhu buhlobo, ivumela imisebenzi ebanzi ethatha isikhathi eside. Isibonelo, ukuhamba kwencwadi ingabukeza izikhundla, i-ka, i-fushalo, futhi icela isicelo esisodwa se-frence. Lokhu kwenza ukubamba engokwemvelo yezezezezezezezezezezezezezezempilo, futhi i-intensi yeze yeze-ence, i-ogno-og.

Ubuciko Nolawulo: Indima, Imvume, Nobubusi

Ngamandla amakhulu kuvela isidingo sokulawula okuqinile. I-FLT:0 isebenzisa i-Role-sed Access Control (RBAC) ngokulungisa kokuhlinza, ihambisa ngalé kwemingcele elula yetebula-tepu ekubekeni imingcele yensimu nesilinganiso semigqa. Abaphathi bachaza imvume ezisemthethweni yokufinyelela yonke indima esebenzayo ngokusebenzisa i-galelo le-metafe elinamandla eliyi-API. Ngokwesibonelo, umkhandisi ongabekelwa ukubuka kuphela indawo yabo, kuyilapho umphathi wemikhiqizo engakwazi ukuhlela amasimu emali kodwa angashintsha uhlu. Lokhu kuhlanganisa i-freactived ku-odhlu lwe-omgatem. I-omfont kuyakwazi ukufihla zonke izingxenye ze-UI ezisemisebenzi ethile.

Ukulawula ukufinyelela ko Granes

Ungqimba lwemvume lusekela ukulondeka okumahhala ngezihluzo eziqondile. Imithetho esemthethweni kanye ne-openID kuqinisekisa ukuqondisa kolwazi ngezimiso zebhizinisi. Iplatfomu futhi isekela isibonakaliso ngaphandle [[FLT]] Ku-(SOLT][[FL:3]] izisekeli ezihlanganisa i-SAML, i-OUT2, kanye ne-OUPRID, okwenza ukuba kuqinisekiswe izimbobo zolwazi ezinamabhodi ezilawulayo ezisebenza kahle eqenjinini lezentengiselwano. hlelo luhlola zonke izinguquko ezizenze , lapho, futhi izilinganiso zakudala nezintsha zaziwumlando ezibonisayo zenguquko zokulungisa nokubuyisela. Izinga lokulawula imvume emalini (HA) futhi zisekela ukugcinwa kwemisebe yezezimali (HA).[FFFFFotences] futhi iziqondiso ezigunyaziwe.[5]

Ukunamathela Nenjongo Yokwaziswa

I-tractus ivumela abaphathi-maya ukuba balinganise izimiso ezizenzekelayo zokubuyisela imniningo, ukukhipha noma ukufihla amarekhodi e-active asekelwe emikhawulweni e-opending. Ihlanganiswe nezingodo zokuhlola nokubhala ngesilinganiso sensimu (i-vita ] amasimu asheshiwe [ ama-password noma ] amakhomputha ayimfihlo [[FLT] amaqoqo [[FLTLD:3]] emininingwane ezwelayo)), inikeza isisekelo esibanzi semininingwane elawulayo eqondiswe kahle. Izinhlangano zezesayensi zezesayensi, i-GDPR, abaphathi bengathumela noma ukususa kalula ukwaziswa komsebenzisi nge-mibhosholo-omthethweno-omthethweno-omthethweno-omciso-om. Lokhu kwakhiwe ngethuluzi lokulungisa i-octive-octive zenzayo ethembekile, ne-encwadi yezezezezezezezezezezezezezezimali.

Okwangaphandle Nezimiso Zokusebenza: Amandla Okuzihlela

Akukho platifomu engaxazulula wonke amaphethelo. I-tradeus ivula indlela yayo yokwakha i- ehlanganisa i-extension nge- Directus Compatices SDK. Abathuthukisi bangakha izimo ezisemthethweni, izikhongozeli, amagophe, nezigwegwe ezinwebeka zonke izingxenye ze-injini(ukusuka kwi-API ukuya ku-UI. Umthuthukisi angadala i-Drectus yewidget yewidget, ugwegwegwe olubangela ukuba umfanekiso ofundwa ngezithombe uthunyelwe, noma indawo entsha yokuhlela eyinkimbinkimbi yezentengo. I-SDK inikeza i-scread-scroad, uhlobo lwe-Scriptic, uhlobo lokuhlola.

Okwandiswa I - SDK

I-SDK inikeza isakhiwo esihlelwe kahle samaphakethe omzimba. Imisebenzi esemthethweni ingafakwa e-stables Sounds, noma amabhodi emininingwane akhiwe nge-Ve.js ingxenye yethuluzi eliguqulelwa ngaphakathi kwe-studio. I-decurus iba yindwangu ye-data emhlophe ethunyelwa kunoma iyiphi imboni, kusukela embonini yempilo kuya ezinhlanganoni zokudala, ngaphandle kokuphula indlela ehleliwe yokuhlela. Ukuhlukaniswa komqondo oqinile nenjini engaphakathi kuqinisekisa ukuthi ipulatifomu ihlala iqinile futhi isesimweni esilula ukugcinwa. Amazandisi athunyelwa njengamaphakethe angafakwa kuleyo ndawo embonini esetshenziswa nge-ENUNI noma nge-npm, futhi asekela izinguqulo zokuqondisa i-m.

Ngokwesibonelo, i-ecommerce platifomu ingakha indawo yokugcina esemthethweni ehlangene nenani elifanele lemithetho-mithetho yokuhlanganisa, bese iyidalula njengendawo yokugcina i-webrock ukuze ilungise inani langempela. Lokhu kusebenza kunika amandla abaphuhlisi amandla okunezela ukusebenza okuyingqayizivele kuyilapho i-openthic compression ihlala ilungile. I-eosethis ihlanganisa futhi nokuhlanganisa amaphakethe omphakathi ahlukene agcwele ukuhlanganisa i-Prime, i-Algolia, ne-Twulio, ukuthuthukisa intuthuko engaphezulu. Isibopho sika-Frecus sokwenza intellioble idinga ukuguqulwa, indawo yesikhulumime ingakhula nawe ngaphandle kokufuna ukufuduka okuphelele.

Ifu Eliqondisiwe Nemfucumfucu Yanamuhla

Isiphetho sokuziphendukela kwemvelo kuka-Draidus i-Directus ehlangene ne-Devops yanamuhla nge- i-Directus Ifu elimnyama. Ngokuphatha isakhiwo, ukulinganiswa kwempahla okuzenzekelayo, ne CDN-emuva kwe-registers, i-Frecus List idla iqophe iqophe i-Prive-aa-Service ngokusebenza kakhulu. Ukulawula i-CMS ephethe i-mouse ebanzi ne-evel nobubanzi bembulunga yonke kuthatha imizuzu, ukuthatha i-mcacibilibo nokwe. Izenzakalo zamafu zilandela i-tektho, izivikelo ezizizenzekelayo, kanye nokucweba okuzikhulula i-injini lapho isebenza ngokugcwele lapho ilawula i-data yayo.

Isizinda Sokuziphendukela Kwemvelo Kwenkonzo

Ngaphansi kwegumbi, iNode.js kanye ne Vue.js amaqembu esimiso esisodwa asebenza i-dmin commission. Izakhiwo zivunyelelwe ukusabela nokuzimisela kokungabonisi isineke, okusho izilinganiso zezimoto zomkhankaso wegciwane azilokothi zilulaze okuhlangenwe nakho komhleli. Ukulayisha eqongeni kuphelelisa isiyingi solwazi oluphethwe ngokugcwele. Amaqembu emininingwane angagxila ekufanekiseni nasekulinganiseni imishini kunokuhlela imicimbi. Itshe lezehlakalo linikeza futhi indawo ezungezile ye-[ egcwele indawo yomhleli. ngokuthatha umfanekiso ofinyene, okwenza amaqembu ahlole ukufuduka nokulungisa ngaphambi kokukhiqiniswa kwenqubo.

Ukusebenza Ngesilinganiso

Amasu athuthukile okusungula agcwele wonke ungqimba oluphakathi, kusukela ekukhonondeni okucushwayo kanye nokukhishwa kweschema kuya ekudlulisweni okuhlelwe kahle kwe CDN elungiselelwe igrafu QL caching. I-tradeus ingaxhumanisa ukuba ilawule i-SQL iziqinisi njengoku [[[FL:0]] Planet Chamet[[[[FLL:1] noma NTY[FL:3], iqinisekisa ukuthi i-panel'ss ay simont futhi ayisebenzi. Izikhathi zokusabela kuhlala ziqinile ngisho nangezigidi zemibhalo eyinkimbinkimbi enqamule izihlahla. Iqonga futhi isekela [FLT:] [FLT] [FLD:5] ukuhlanganisa nezihlophelo ezixwe-evene, iqinisekisa ukuthi izimpawu zokudluliswa ngokushesha zihlala ziqinile ekudlulisweni kwemitho ye-onkanyezi.

Uhambo Lokushintsha Izinombolo

Ukuhlola i-arc ngenxanxathela ephakathi kokunyathelisa okulula ukuya esiteshini sokwaziswa esikwazi ukuhlanganiswa, esizihambelayo, nesisebenza ngefu kwembula i-Draiceus yeqiniso. Ukuguqulwa kuchazwa ngokunamathela ngokungaguquguquki ekuhlanzekeni kwe-SQL nakuba kuthatha ukuyinkimbinkimbi kwentuthuko yanamuhla. Amandla okuqala okuhlola i-data kanye nokuphatha izinto ahlanganisene ne-orchestratecs, ukubusa ukwaziswa esigabeni, nokuhambisa i-GracQL izikhodi ezisekelwe ngokulinganisa igebe. Lohambo oluqhubekayo luqinisekisa izakhiwo zakho zokwakha zanamuhla amanani amanani amanani alinganiselwe kuphela ngekhono okwazi ukubonelela, hhayi ngezindonga zedayisa.

Njengoba indawo ye-mini idinga ukuhlanganiswa okukhulu kanye nokuhlanganiswa kwemininingwane yesikhathi sangempela, indlela engaphambili cishe ihlanganisa ukuhlangana kwezenzakalo zomdabu nokuqina kwe-Web sickting. Kakade, i-Directus izama ukuhlanganisa [ isikhathi esingokoqobo] izici ezifanayo[ nezikhona ozitholayo eGoogle Docs, ukuvumela abahleli abaningi ukuba basebenze embhalweni ofanayo ngesikhathi esisodwa. Isisekelo sokwaziswa okuvulekile nokubonakala kusekuqaleni kakade ukuveza i-Diroundationus njengesimiso esiqinile, kodwa njengenjini ehlala njalo yokusungula. Ushintsho oluqhubekayo luyisibopho senkululeko, ukubonakala, nokulandela okungapheli kongqimba oluthambile. Ukuba uqala ukwakha umkhiqizo osebenzayo noma umshini ojikelezayo, ukuguqula indlela ebumbene, ukuhleleka kwe-AP, i-struplust.