DB CONSOLE

🔌 Izinhlobo ezimbili zesizindalwazi — yikhonbe kweyakho

• SQLite — isizindalwazi esiyifayela. Vula elilodwa ngqo, noma vumela ikhonsoli ikutholele zona: ugunyaza amafolda engawabuka, ihlola unhlokwana wobunikazi wefayela ngalinye eliyikhandidethi ukuqinisekisa ukuthi ngempela liyisizindalwazi se-SQLite, futhi ifaka ohlwini ngalinye elitholayo — nosayizi walo nenani lamathebula — kanye, noma ngabe livela ezindaweni ezimbili. Ibuka kuphela kumafolda owagunyazile; uhlelo lufika lungazi fofoda nhlobo.
• PostgreSQL — isizindalwazi esiyiseva. Gcwalisa ifomu elifushane: ikheli leseva, imbobo yayo, igama lesizindalwazi, igama lakho lomsebenzisi. Insimu yekheli ifika ingenalutho — ikheli lokuqala eliyoke libe nalo yilona owabhalayo — futhi uxhumano elwenzayo lungolwangempela, kuseva owayiqamba.

Ukuxhumana okugcina kubhalwa ngamagama, ngamazwi akho. Ukuxhumana okugciniwe kukhumbula indlela — ikheli, imbobo, igama lomsebenzisi, izindlela zamafayela — akusoze kwakhumbula iphasiwedi: ikhodi yokugcina uqobo ikhipha noma yini efana nephasiwedi ngaphambi kokuba uhlu luthinte idiski. Amaphasiwedi ahlala endaweni eyodwa kuphela: ivault engezansi.

👀 Ukubuka uzungeze — isihlahla, igridi, isakhiwo

• Isihlahla sesakhiwo — isizindalwazi njengohlaka: amathebula ayo nemibono, ngalinye livula likhombise amakholomu alo. Ibalazwe, ngaphambi kokuba uthinte noma yini.
• Igridi yedatha — imigqa yethebula elilodwa, engama-50 ekhasini. Chofoza unhlokwana wekholomu ukuze uhlele ngayo; ibhokisi lokusesha lizingela amazwi akho kuwo wonke amakholomu ngesikhathi esisodwa. Amaseli angenalutho abonisa njenge-NULL, idatha yebhayinari njengelebuli ecacile efana ne-[blob 12B] — iboniswa njengoba injalo, ayiqagelwa nhlobo.
• Umbono wesakhiwo — ithebula elilodwa lihlukaniswe: wonke amakholomu anohlobo lwawo nokuzenzakalelayo, ukhiye oyinhloko, okhiye bangaphandle abalixhuma kwamanye amathebula ngezindlela zombili, izinkomba zalo, nesitatimende salo sangempela se-CREATE, esifundekayo futhi esikopishwayo.

Ukubuka akushintshi lutho. Ungabuka usuku lonke futhi isizindalwazi asisoze sazi ukuthi ubulapho — yilokho okushiwo ukufunda kuphela, futhi yisimo oqala ngaso.

⌨️ Umhleli we-SQL

Bhala i-SQL — ulimi lwesizindalwazi uqobo — futhi usebenzise konke noma ingxenye oyikhethile kuphela. Izimpendulo zehlela kugridi yemiphumela, futhi imiphumela ingathunyelwa kufayela le-CSV noma le-JSON kudiski yakho uqobo. Umbuzo ungafana nemigqa eyisigidi; igridi ikhombisa engama-500 yokuqala futhi ikusho lokho — impendulo enomkhawulo ibhalwa ukuthi inomkhawulo, ayisoze yasikwa ngokuthula ukuze ibonakale iphelele.

Izitatimende zokufunda zisebenza ngqo. Ezishintshayo azenzi njalo — i-INSERT, UPDATE, DELETE, noma DROP ayisebenzi uma ucindezela ukusebenzisa. Iya kuthreyi yezinguquko ezisalindile, futhi uhlelo lokuphepha luthatha kusukela lapho. Lokho kuphambuka akukona ukwenqaba; kuwuhlelo olusebenza njengoba lwakhiwe.

🛡️ Uhlelo lokuphepha — isihloko esikhulu

• UKUFUNDA KUPHELA NGOKUZENZAKALELAYO — UHLAKA LWEGOLIDE. Konke ukuxhumana kuqala ngokufunda kuphela, futhi uhlaka lwewindi luthwala imodi ngombala ngaso sonke isikhathi: igolide lisho ukufunda kuphela — buka konke, shintsha lutho; unqenqema olubomvu lisho ukubhala kuvunyelwe — ukuxhumana owakushintsha wena siqu, ngokuxhumana ngakunye, okukhunjulwayo. Ungabona izinga lakho lengozi ukude negumbi.
• ITHREYI YEZINGUQUKO EZISALINDILE. Izinguquko zibuthana kuthreyi ekuhombisa, nge-SQL ecacile ncamashi njengoba izosebenza, zonke izitatimende ezizosebenza — nenesibali esibukhoma ohlakeni. Commit isebenzisa ithreyi; Discard iyayilahla futhi isizindalwazi asisoze sezwa ngakho. Vala iwindi kunezinguquko ezisalindile futhi ikhonsoli ikubuza, ngegama, ukuthi wenzeni ngazo.
• IKHOPHI NGAPHAMBI KOKUBHALA. Uma ucindezela u-Commit, isenzo sokuqala akusona ushintsho — yikhofi. Isizindalwazi se-SQLite sikopishwa sonke kufayela le-.bak elinesitembu sesikhathi ngaphambi kokuba noma yini isebenze, ukuze ikhophi ibe khona noma ukubhala kwehluleka phakathi; kugcinwa eziyishumi ezintsha kakhulu. Ukubhala okubi kuhlale kuhlehliseka: buyisela ikhophi, futhi umi lapho wawumi khona.
• ABALINDI. I-DELETE noma i-UPDATE engenayo i-WHERE ithola isitobhi samazwi acacile ngaphambi kokuba izibophezele: lokhu kuzoshintsha wonke umugqa ethebhuleni. I-DROP noma i-TRUNCATE ihlala ingahlomile uze ubhale igama eliqondile lethebula ukuze uhlomise u-Commit — alikho ibhokisi elingathikwa ngengozi ngokuchofoza okungalawuleki — futhi lowo mlindi uhlala enkabeni yekhonsoli, hhayi ezinkinobheni zayo kuphela, ukuze i-DROP engahlomile ingakwazi ukuzibophelela nganoma iyiphi indlela.

🔐 Ivault — lapho amaphasiwedi ahlala khona

Amaphasiwedi awasoze aba umbhalo ocacile, noma kuphi — hhayi ohlwini olugciniwe, hhayi kulogi, hhayi esikrinini ngemva kokuba uwabhalile. Ahlala kuvault evaliwe ngokubethela: ifayela elilodwa kukhompyutha yakho uqobo, elivalwe ngephasiwedi enkulu oyikhethayo. Iphasiwedi enkulu uqobo ayisoze yagcinwa — yikhohle, futhi ivault ihlala ivaliwe; lokho akusona isici esibi ekwakhiweni, lokho kuwukwakhiwa uqobo. Ngamazwi acacile, ukuvala kudlula iphasiwedi yakho emshinini ohamba-nendlela-eyodwa izikhathi ezingu-600,000 ukwenza ukhiye, bese kuvala izimfihlo nge-AES-GCM, ukubethela okuqinisekisiwe okujwayelekile — shintsha ibhithi elilodwa lefayela elivaliwe futhi ngeke livuleke, kunokuba livuleke ngokungeyikho. Ifayela levault likhiyelwe ku-akhawunti yakho kuphela (izimvume 0600), iphasiwedi engalungile yehluleka kakhulu, futhi indlela yokusekela eyakhelwe ngaphakathi ivala ivault ezinhlelweni ezingenayo umtapo wokubethela ojwayelekile — ayikho indlela kule hlelo egcina iphasiwedi ilele ifundeka kudiski.

⚖️ Imikhawulo eqotho

• Izinjini ezimbili namuhla. Lolu hlobo lukhuluma i-SQLite ne-PostgreSQL. I-MySQL ne-MariaDB zikuhlelo lwesigaba esizayo — azikho kulolu hlobo, futhi leli khasi ngeke lizenze zikhona.
• Izinguquko ziyabhalwa, azichofwa. Kulesi sigaba ushintsha idatha ngokubhala i-SQL kumhleli; ifomu lokuhlela umugqa ngokukhomba-nokuchofoza umsebenzi wesigaba esizayo. Uhlelo lokuphepha lwakhiwa kuqala, ngamabomu.
• Ikhophi iyindaba yefayela. I-.bak enesitembu sesikhathi ivikela izizindalwazi ze-SQLite, okungamafayela. Kuseva ye-PostgreSQL, inetha ukufunda-kuphela okuzenzakalelayo, ithreyi yokubuyekeza, nabalindi — kushiwo ngokucacile, ngoba ukuzenza sengathi ikhophi yefayela ikhona kuseva kungamanga anebha yenqubekelaphambili.
• Amawindi amancane, alungisiwe ku-1.0. Uhlobo lokuqala lokuhlola lwalunganqamula izinkinobho zekhasi legridi efasiteleni elincane (amaphikseli angu-800 ububanzi) futhi lucindezele isihlahla sesakhiwo kwelifushane (amaphikseli angu-600 ukuphakama). Uhlobo 1.0 lwakha kabusha isakhiwo samawindi amancane futhi luhlolwe ku-1024×600 naku-800×600 ngazo zonke izilimi eziyisithupha — imigqa yesihlahla, izinkinobho zekhasi, u-Commit no-Discard konke esikrinini.
• Kufakazelwe ezizindalwazini zokuhlola. Konke ukuvikela okungenhla kwafakazelwa ezizindalwazini zokuhlola ezakhelwe le njongo — ibhethri eliyinhloko lokuhlola okungu-37 liphumelele kulolu hlobo lokukhishwa ncamashi, futhi iwindi lahlolwa ngazo zonke izilimi eziyisithupha ku-1024×600 naku-800×600. Uhlelo aluzange lukhonjwe esizindalwazini sangempela esisebenzayo ekuhlolweni, ngamabomu.

🔒 Umshini wakho, ibhizinisi lakho

Awekho ama-akhawunti, akukho telemetry, akukho ukuhlolwa kwezibuyekezo — ikhonsoli ayisoze yabika kunoma ubani. Ithrafikhi yayo yenethiwekhi eyodwa kuphela ukuxhumana okuchaza wena, kumaseva esizindalwazi akho uqobo, uma uxhuma kuwo. Ngaphambi kokuba lolu hlobo luvunyelwe ukuphuma, ingaphakathi lalo laskanwa ngentambo ngentambo: alinawo amakheli akhelwe ngaphakathi nhlobo — hhayi awethu, hhayi awanoma ubani. Konke elikugcinayo — ukuxhumana okugciniwe, ivault, okuthumelayo — kuhlala kumafayela endawo acacile kumshini wakho uqobo, okuthumelayo nokususwayo, okwakho.

⬇️ Okudawunilodayo

🐧 Uhlelo — Linux

Dawuniloda i-DB Console ye-Linux — MAHHALA

Uhlobo 1.0 · Linux · 24 MB · Akukho kufaka: yikhiphe, vula ifolda, sebenzisa ./DBConsole. Ikhonsoli yonke ikhuluma English, Español, Deutsch, 中文, 日本語, nesiZulu — khetha eyakho phezulu kwesokunxele efasiteleni futhi iyakhumbula.
Yenziwe yi-777 Software — mahhala ngunaphakade — 777software.net · SHA-256 (tarball): d4a185d280d13cd9f47474c833ed462b2e1178850eb754364e12cc261382b685

MAHHALA NGUNAPHAKADE. I-DB Console iyithuluzi lokuphatha uhlelo, futhi asikhokhisi abantu ngokuzivikela ngamathuluzi ethu. Ayikho intengo, akukho kulinga, akukho sigaba se-premium — hhayi namuhla, hhayi naphakade.

Yakhiwe i-Linux kuqala, njengazo zonke izinhlelo ze-777 Software. I-Windows ilandela kuhlobo olufanayo olufakazelwe.

📖 Imanuwali (PDF)

Isithombe esigcwele sokuthi i-DB Console yenzani nokuthi ishayelwa kanjani — imanuwali efanayo uhlelo olwaphakanyiswa ngayo ekuhlolweni.

DB Console — How It Works (PDF) (ngesiNgisi)
Imanuwali yohlelo — ukuxhuma ezizindalwazini zakho ze-SQLite ne-PostgreSQL, imibono yesihlahla, igridi, nesakhiwo, umhleli we-SQL, ukufunda kuphela ngokuzenzakalelayo, ithreyi yezinguquko ezisalindile, ikhophi ngaphambi kokubhala, abalindi, ivault, nemikhawulo eqotho. Amakhasi angu-8 · SHA-256: c8dfb6cf83f87e4fd6beb65d3bc5fc04508fd10c80a8bd4be57ead0b061c08e6