Uko ukoresha Modej

Modej ifata dabase yawe (Firebird, MySQL, PostgreSQL, Oracle, SQL Server, n’izindi) hamwe — bidasabwa — na kode y’umuzi iyikoresha, ikaguha:

• ishusho ya ER ishobora gusuzumwa ifite imbonerahamwe zose, inkingi, urufunguzo n’isano;
• ikarita y’aho kode ikoresha imbonerahamwe zihe (n’uko: gusoma, kwandika, guhindura);
• inyandiko zikorwa mu buryo bwikora zikozwe na AI;
• raporo za PDF z’umwuga ziteguye guhabwa umukiriya cyangwa mugenzi wawe.

Modej isoma DDL - script ya SQL isobanura imiterere ya dabase (imbonerahamwe, inkingi, urufunguzo, indeksi, trigger, stored procedure). Ntibisaba na rimwe guhuza ako kanya na dabase yawe: dosiye y'inyandiko ifite imiterere irahagije.

Access, dBase na Paradox nta DDL y’inyandiko zishobora kohereza mu buryo butaziguye — ni dabase zishingiye kuri dosiye z’imikorere. Kuri izi hakenewe script yo guhindura ikorera kuri mudasobwa aho dosiye ya dabase iherereye, mbere yo koherezwa kuri Modej.

Kohereza na kode y’umuzi (Delphi, C#, Java, PHP...) bituma Modej isobanukirwa ni ibihe bice bya porogaramu bikoresha imbonerahamwe zihe — ishingiro rya Isesengura rya AI, Kode↔DB, Ikarita y’inzira na Raporo za Tekiniki zuzuye.

file.pas | NomUnit | NomClasse | SQL_STRING:SELECT * FROM TABELA WHERE...

Buri mbonerahamwe ihinduka ikarita ishobora kururwa ifite inkingi zayo zose, urufunguzo nyamukuru (PK) n’urufunguzo rw’inyongera (FK) byerekanwe. Isano zishushanywa mu buryo bwikora: imirongo indigo ku FK nyazo zatangajwe muri dabase, imirongo za orange ku FK zakozwe intoki wowe wongeraho.

Kusanya imbonerahamwe mu "duce" dufite amabara (urugero: Ububiko, Kugurisha, Ibaruramari) ukurura buri mbonerahamwe ku gace kayo mu rukuta rw’ibumoso. Aya mabara agaragara ahantu hose: Schema ER, Ibisobanuro, Raporo ya Tekiniki.

• Kora uduce dushya ufite izina n’ibara byihariye;
• Yungurura ukurikije "Byahawe" / "Bidahawe" kugira ngo urangize vuba ishyirwa mu byiciro;
• Ragwa amabara avuye muri verisiyo yabanjirije iy’iyi dabase, niba uri kuvugurura schema isanzwe yashyizwe mu byiciro.

Dabase nyinshi za kera ntizitangaza isano zose ku rwego rwa SQL — isano ibaho gusa "mu mitwe y’abakoze porogaramu" cyangwa muri kode ya porogaramu. FK zakozwe intoki zikwemerera kuzandika mu buryo bugaragara, kandi zigaragara muri Schema ER nk’imirongo ya orange itandukanye.

Hitamo imbonerahamwe n’inkingi y’inkomoko, hanyuma imbonerahamwe n’inkingi y’icyerekezo, wongereho icyitonderwa kitari ngombwa hanyuma ubike.

Ohereza ZIP ya kode y’umuzi: Modej iyisesengura hakoreshejwe algorithm za AI ikanakora raporo ku byiciro 4 bitandukanye, bishobora gutoranywa mu ntangiriro:

Bitandukanye n’Isesengura rya AI (ritanga incamake rusange), Deep Analysis isuzuma buri dosiye ku giti cyayo mu mushinga, ikamenya inzira y’ubucuruzi iyihuriyeho (urugero: "Gucunga Amabwiriza", "Amakuru y’Abakiriya") hanyuma igatanga mu buryo bwikora ikarita y’inzira iteguye gushyirwa mu bikorwa.

Nyuma yo kurangiza, kanda "Shyira mu nzira" kugira ngo wimure ishyirwa mu byiciro ako kanya mu Ikarita y’Inzira, ukizigama akazi ko gukurura intoki.

Bitandukanye n’Isesengura rya AI (ryitegereza kode), AnalisiDB ni ifite igenamiterere rihamye, ntabwo ikoresha AI: ikurikiza amategeko ahamye ku rufunguzo, urufunguzo rw’inyongera, ubwoko bw’amakuru, kwita amazina, indeksi n’urwego rwo gutunganya schema yinjijwe.

• Amanota rusange na badge OK / Bisanzwe / Bibi kuri dabase yose;
• buri kibazo cyabonetse gishyirwa mu byiciro ukurikije imbonerahamwe, hamwe n’uburemere n’ubusobanuro bworoshye;
• script ya SQL yo gukosora iteguye gukoporwa — yisuzumire kandi uyihuze mbere yo kuyikoresha, ntukoreshe mu buryo bw’impumyi kuri dabase ikora.

Kuri buri gace ka kode kinjijwe ubona urutonde rw’imbonerahamwe gakoresha, hamwe n’ubwoko bw’igikorwa (SELECT, INSERT, UPDATE, DELETE, cyangwa "bivanze" niba gakora byinshi) n’izina rinonosoye ry’uburyo. Imibare hejuru isobanura urugero rusange: isano zose, kangana SELECT/INSERT/UPDATE/DELETE, imbonerahamwe n’uduce bikubiyemo.

Hamwe na Plus Gukura Query ushobora kohereza iyi shusho yose muri CSV, JSON cyangwa SQL — bifasha mu nyandiko, isuzuma cyangwa impinduka.

Kora inzira (urugero: "Kubara Fagitire") n’udusigazwa (urugero: "Gutanga Fagitire"), hanyuma ukurure uduce twa kode tutarahabwa mu nkingi y’ibumoso ubijyane mu gace kabo nyako. Cyangwa ukoreshe "Sesengura na AI" kugira ngo uhabwe mu buryo bwikora imiterere yose ishingiye ku mazina y’uduce.

Wibuke gukanda Bika nyuma ya buri mpinduka — ubutumwa bwatsi bwemeza ko kubika byagenze neza.

Igihe Ikarita y’Inzira yuzuye, uru rupapuro rukora mu buryo bwikora ishusho ya SVG ifite imiterere yuzuye: inzira hejuru, udusigazwa munsi yazo, n’uduce twa kode duhawe buri kimwe munsi.

Bifasha kubona incamake vuba, cyangwa kuyisohora nk’ifoto y’inyandiko.

Reba verisiyo zose zinjijwe kuri buri dabase, hamwe n’umubare w’imbonerahamwe, itariki yo kwinjiza n’ingano. Hindura izina rya DB ukanda kabiri ku izina, siba verisiyo zishaje (niba hari zirenze imwe), cyangwa ujye ako kanya kuri Schema ER cyangwa Kugereranya kuri buri verisiyo.

Hitamo verisiyo shingiro na verisiyo nshya: uzabona imbonerahamwe zongewemo (icyatsi), zavanyweho (umutuku) n’izahinduwe (orange) mu rukuta rw’ibona kabiri. Kanda ku mbonerahamwe yahinduwe kugira ngo urebe neza ni izihe nkingi zahindutse, hamwe n’ubwoko mbere/nyuma.

Isa na Kugereranya Verisiyo, ariko yateguwe ku nyandiko: ikora impinduka mu buryo bwa "release notes" hamwe n’igihe cyerekanwe, ishobora gusohorwa muri .md kugira ngo yinjizwe ako kanya mu bubiko bwa Git bw’umushinga.

Igereranya imbonerahamwe za dabase n’izikoreshwa nyazo muri kode yinjijwe. Imbonerahamwe "zitakoreshwa" zishobora kuba iza kera cyangwa zitagifite agaciro — intego nziza yo gusukura mbere y’impinduka, zishyizwe mu byiciro ukurikije agace hamwe na %.

Urutonde rutondekanyijwe uhereye ku mbonerahamwe ikoreshwa cyane kugeza ku idakoreshwa cyane, hamwe n’imirongo ifite amabara (ubururu=gake, icyatsi=hagati, orange=kenshi, umutuku=ingenzi) na badge ku bwoko bw’igikorwa. Yungurura ukurikije SELECT/INSERT/UPDATE/DELETE ku isesengura ryihariye (urugero: DELETE gusa ku isuzuma ry’umutekano).

Kuri buri mbonerahamwe wandike (cyangwa ukore na AI) ubusobanuro mu rurimi rw’ubucuruzi, atari urwa tekiniki — bifasha uwo wese ugomba gusobanukirwa na dabase adakoze porogaramu. Buto "AI ikora byose" yuzuza mu buryo bwikora imbonerahamwe zose zikiri nta busobanuro. Ishobora gusohorwa muri PDF.

Manura isano zose za agace↔imbonerahamwe muri CSV (kuri Excel), JSON (izindi porogaramu) cyangwa SQL (query zitaziguye). Byiza cyane ku nyandiko za tekiniki cyangwa kugaburira ibikoresho by’isesengura by’inyuma.

PDF y’impapuro 20-30 ikozwe yose muri navigateri yawe (nta makuru asohoka kuri mudasobwa mu gihe cyo kuyikora), iteguye guhabwa umukiriya cyangwa kubikwa:

Amanota kuva kuri 0 kugeza kuri 100 abazwe hashingiwe ku mubare w’imbonerahamwe, FK zakozwe intoki, inkingi zisanzwe kuri buri mbonerahamwe n’igihano ku mbonerahamwe zitakoreshwa zirenga 20%. Reba na uko byifashe mu gihe: niba wanyinjije verisiyo nyinshi za dabase imwe, igishushanyo cyerekana niba sisitemu igenda igorana cyangwa igenda yoroha uko verisiyo zigenda.

Ihindura amakuru y’umushinga muri slide zuzuye ecran: ipaji ya mbere, incamake ifite ibipimo 7 (imbonerahamwe, inkingi, FK, trigger, stored procedure, view, indeksi), schema ER ishobora gusuzumwa, slide imwe kuri buri nzira y’ubucuruzi hamwe n’utusigazwa n’uduce byayo, heatmap, na slide ya nyuma.

Yobora hakoreshejwe utubuto ← → twa keyboard, sohoka na ESC. Byiza cyane ku nama n’abakiriya cyangwa kwerekana kuzima.

Buri Plus iguzwa ukwayo kandi ikaba ifite agaciro amezi 12 uhereye igihe wayiguze. Urutonde ruri hepfo rusomwa ako kanya kuri marketplace, kubw’ibyo buri gihe ruhuye n’ibyo ubona nyabyo ku rupapuro rwa Plus — amazina, ibiciro n’ibisobanuro bikomeza kuba mu Cyitaliyani uko ururimi rw’iyi buyobozi rwaba rumeze kose, kuri ubu.

Analisi

Analisi AI

Codice DB

Compliance

Migrazione

Report

Schema DB

Storage

Team

Ibikorwa bifite ikimenyetso 🕐 Coming soon biri kuza: isuzuma ry’umutekano ryimbitse, kugereranya verisiyo za kode, inyandiko zikorwa mu buryo bwikora, igishushanyo cy’ubwisanzure n’ibindi — urutonde rwaguka buri gihe.

Buto ☀/🌙 hejuru iburyo muri menu nyamukuru ihindura hagati y’ibara ryijimye n’iryeruye. Icyo uhisemo kibikwa mu buryo bwikora kandi gikoreshwa kuri impapuro zose, harimo na Schema ER ituye mu rukuta rutandukanye — nta gusaba kabiri.

Icyitaliyani, Icyongereza, Igiporutugali, Icyesipanyoli, Ikidage, Igifaransa n’Ikinyarwanda. Buri ukoresha ahitamo ururimi rwe muri menu nyamukuru, bitewe n’ abandi bakoresha ba konti imwe — buri wese abona Modej mu rurimi arushaka.

Ibirimo bikozwe na AI (ibisobanuro, raporo, ibisobanuro) bikorwa ako kanya mu rurimi rwatoranyijwe. N’iyi buyobozi ikurikiza ururimi rumwe rwashyizwe muri menu.

• Ijambobanga, urufunguzo rwa API n’amakuru yo kwinjira muri kode bihishwa mu buryo bwikora mbere yo koherezwa kuri AI;
• Kode y’umuzi ntibikwa kuri seriveri nyuma y’isesengura;
• Script zo gukura DDL kuri dabase za kera zikorera kuri mudasobwa yawe — nta makuru yo kwinjira yoherezwa kuri Modej;
• Reba Amabwiriza y’Ikoreshwa n’Politiki y’Ubwigenge ku makuru yuzuye.

Nyir’ubwite bwa konti ashobora gutumira abandi bakoresha no guha buri wese kimwe mu burenganzira butatu bwo mu rwego rw’imbere. Uburenganzira bugenzurwa na kuri seriveri, ntabwo ari uguhisha utubuto muri interfaces gusa.

Muri Itsinda Nyir’ubwite abona abakoresha bose, uko bahagaze (bakora/bahagaritswe) n’igihe baherukira kwinjira.

Ubwiyandikishe shingiro (gahunda y’ukwezi cyangwa iy’umwaka) bushobora kwishyurwa ubusubize mu minsi 14 uhereye igihe wabuguriye: fungura gusa icyifuzo uhereye ku mwirondoro wawe, ushobora kuvuga impamvu, hanyuma itsinda rya Modej rirasuzuma — nirimara kwemezwa, kwishyurwa ubusubize bizagera binyuze kuri Stripe mu minsi 5-10 y’akazi ku buryo bumwe bwo kwishyura.

Isiba burundu umushinga n’amakuru yose ayihuriyeho — dabase, kode, inzira, FK zakozwe intoki. Ku mutekano ugomba kwandika izina ryuzuye ry’umushinga kugira ngo wemeze. Igikorwa ntigishobora gusubizwaho kandi kirinzwe na transaction: niba hari ikitagenze neza hagati mu nzira, nta kintu gisibwa.