Iphrojekthi ye-Dolt isanda kumenyezelwa, yakha uhlelo lokuphathwa kwedatha oluhlanganisa ukwesekwa kwe-SQL nokulawulwa kwenguqulo yesitayela se-Git. Okuthakazelisayo nge-Dolt ukuthi ivumela abasebenzisi ukuthi bakopishe amatafula, bahlanganise amatafula ngefoloko, futhi benze imisebenzi yokusunduza nokudonsa efana naleyo esesitorejini se-Git.
Ngesikhathi esifanayo, lolu hlelo lokuphatha isizindalwazi lusekela imibuzo ye-SQL futhi luhambisana ne-MySQL ezingeni lesixhumi esibonakalayo seklayenti. Amakhono okuguqula avumela abasebenzisi ukuthi balandelele umsuka wedatha, futhi ukuxhumanisa kwe-commit kwenza ukulungiswa kufinyelele imiphumela efanayo, okungaphindaphindwa kwezinye izinhlelo nganoma yisiphi isikhathi, kungakhathaliseki ukuthi isimo samanje sinjani.
Ngaphezu kwalokho, abasebenzisi bangazulazula kalula emlandweni, kanye nokulandelela izinguquko kumathebula besebenzisa i-SQL ngaphandle kwesidingo sokuvumelanisa ama-backups, izinguquko zokuhlola, kanye nokukhiqiza imibuzo ehlanganisa idatha endaweni ethile.
Ekhasini eligcina iphrojekthi umdali uchaza iDolt kanjena:
I-Dolt iyisizindalwazi se-SQL esingaxhuma, sihlanganise, sihlanganise, sisunduze, futhi sidonse njenge-repository ye-Git. Xhuma ku-Dolt njenganoma iyiphi isizindalwazi se-MySQL ukuze usebenzise imibuzo noma ubuyekeze idatha usebenzisa imiyalo ye-SQL. Yonke imiyalo oyaziyo ye-Git isebenza ngendlela efanayo kumafayela enguqulo ye-Dolt. Git, amathebula enguqulo ye-Dolt. Kufana nokuthi i-Git ne-MySQL babe nomntwana!
Mayelana neDolt
I-DBMS inikeza izindlela ezimbili zokusebenza: ungaxhunyiwe ku-inthanethi kanye nongaxhunyiwe ku-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 ngendlela efanayo kakhulu ne-Git , ehluke kakhulu ngokuthi izinguquko azilandelwa amafayela, kodwa okuqukethwe amathebula. Nge-CLI ehlongozwayo, ungangenisa idatha kusuka kumafayela e-CSV noma e-JSON, ungeze ama-commits anezinguquko, ubonise umehluko wenguqulo, udale izinguqulo, usethe amathegi, uthumele izicelo kumaseva angaphandle, futhi uhlanganise izinguquko ezithunyelwe 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.
Nokho, i-Dolt iyithuluzi lokulawula idatha kakhulu kunesistimu yokucubungula imibuzo . Isibonelo, ngokuzenzakalelayo, iseva ye-SQL ingaphatha uxhumano olulodwa lomsebenzisi olusebenzayo endaweni yokugcina etholakala kufolda yamanje (lokhu kuziphatha kungashintshwa ngokucushwa). Kungenzeka ukufaka iseva kwimodi yokufunda kuphela. Izenzo eziningi zokulawula izinguqulo zingenziwa nge-SQL, njengokufaka noma ukushintsha phakathi kwamagatsha.
Okokugcina, uma unesithakazelo sokufunda kabanzi ngalolu hlelo lokuphathwa kwedatha, kufanele wazi ukuthi ikhodi yephrojekthi iku-GitHub, ibhalwe ngolimi lwe-Go futhi isatshalaliswa ngaphansi kwelayisensi ye-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'