Muva nje kwembulwa iphrojekthi ye-Dolt, okuthuthukayo uhlelo lokuphathwa kwedatha oluhlanganisa ukusekelwa kwe-SQL nokulawulwa kwenguqulo yedatha yesitayela se-Git. Into ethokozisayo ngeDolt ukuthi ivumela umsebenzisi ukuthi ahlanganise amatafula, igatsha, ahlanganise amatafula futhi enze imisebenzi yokudonsa nokudonsa efana naleyo yokugcina izinto ze-git.
Ngasikhathi sinye, lolu hlelo lokuphathwa kwedatha isekela imibuzo ye-SQL futhi iyahambisana ne-MySQL ezingeni lesibonisi seklayenti. Amathuba wokwenza idatha avumela umsebenzisi ukuthi akwazi ukuthola umsuka wedatha, kanye nesixhumanisi esiqinisekisa esivumela ukulungisa isimo ukuthola imiphumela efanayo, okuthi, noma ngabe isimo samanje, singaphindwa kanjani kwezinye izinhlelo kunoma iyiphi umzuzwana.
Ngaphezu kwalo Abasebenzisi banesikhungo sokuzulazula ngomlando, kanye nokugcina ithrekhi yezinguquko ematafuleni kusetshenziswa i-SQL ngaphandle kwesidingo sokuvumelanisa izipele, izinguquko zokucwaningwa kwamabhuku, futhi kuphinde kudale nemibuzo efinyelela idatha endaweni ethile.
Ekhasini eligcina iphrojekthi umdali uchaza iDolt kanjena:
I-Dolt iyi-database ye-SQL ongayenza imfoloko, i-clone, imfoloko, ihlangane, i-Push bese idonsa njengendawo yokugcina izinto ze-git. Xhuma ku-Dolt njenganoma iyiphi i-database ye-MySQL ukuze usebenzise imibuzo noma uvuselele idatha usebenzisa imiyalo ye-SQL. Yonke imiyalo oyaziyo yeGit isebenza ngokufana ncamashi neDolt. Amafayela wenguqulo yeGit, amatafula wenguqulo yeDolt. Kufana neGit ne-MySQL inengane!
Mayelana neDolt
I-DBMS kInikeza izindlela ezimbili zokusebenza: ungaxhunywanga naku-inthanethi.
- Kwimodi engaxhunyiwe kwi-inthanethi ngemuva kokunqamula, okuqukethwe kwedatha kutholakala njengendawo yokugcina izinto, lapho ungenza khona isenzo usebenzisa insiza yomugqa womyalo we-git.
- I-Dolt SQL Server yethulwa ngemodi "eku-inthanethi", evumela ukukhwabanisa kwedatha kusetshenziswa ulimi lwe-SQL. I-interface enikeziwe iseduze ne-MySQL futhi ingasetshenziswa ngokuxhuma amaklayenti ahambisanayo we-MySQL noma ukusebenzisa i-interface ye-CLI.
Isebenza ngokufana ne-git futhi kwehluka kakhulu ekutheni ushintsho alulandelelwa kumafayili, kepha ngokuqukethwe amatafula. Nge-CLI ehlongozwayo, ungangenisa idatha kusuka kumafayela we-CSV noma we-JSON, engeza ukwenza ngezinguquko, ukhombise umehluko phakathi kwezinguqulo, dala izinguqulo, setha amathegi, thumela izicelo kumaseva angaphandle, futhi uhlanganise izinguquko ezilethwe abanye abanikeli.
Uma umsebenzisi efisa, idatha ingafakwa enkombeni ye-DoltHub, engabukwa njenge-analog yeGitHub yokusingatha idatha nokusebenzisana nedatha. Abasebenzisi bangafaka amakhosombe wedatha, baphakamise izinguquko, futhi bahlangane nedatha yabo.
Isibonelo, ku-DoltHub, ungathola imininingwane ehlukahlukene enezibalo ze-coronavirus, ukuqoqwa kwedatha okuchazwayo kwezinhlelo zokufunda ngomshini, yolwazi olune-lexical yolimi, ukuqoqwa kwezithombe, amakhithi wokuhlukaniswa kwezinto, kanye nemininingwane yendawo yekheli le-IP.
Lokho kusho, I-Dolt ingaphezulu kwethuluzi lokukhohlisa idatha kunesistimu yokucubungula imibuzo. Isibonelo, ngokuzenzakalela, iseva ye-SQL ingaphatha ukuxhumana okukodwa okusebenzayo komsebenzisi endaweni yokugcina etholakala enkombeni yamanje (lokhu kuziphatha kungashintshwa ngokucushwa). Kungenzeka ukubeka iseva kumodi yokufunda kuphela. Izenzo eziningi ezihlobene nokulawulwa kwenguqulo nazo zingenziwa nge-SQL, njengokuzibophezela noma ukushintsha phakathi kwamagatsha.
Ekugcineni, uma unentshisekelo yokwazi kabanzi ngakho yalolu hlelo lokuphathwa kwedatha, kufanele bakwazi lokho ikhodi yephrojekthi ikuGitHub, Kubhalwe ngolimi lweGo futhi kukhishwa ngaphansi kwelayisense le-Apache 2.0.
Ungayifaka kanjani i-Dolt ku-Linux?
Kulabo abanesifiso sokukwazi ukufaka le DBMS kusistimu yabo, kufanele bazi ukuthi i-Dolt iyi-multiplatform futhi uma thina esisebenzisa i-Linux singenza ukufakwa ngokuvula i-terminal bese sisebenzisa umyalo olandelayo:
sudo bash -c 'curl -L https://github.com/dolthub/dolt/releases/latest/download/install.sh | bash'