Iphrojekthi ye-Dolt ithuthukisa i-DBMS ehlanganisa ukwesekwa kwe-SQL namathuluzi enguqulo yedatha yesitayela se-Git. I-Dolt ikuvumela ukuthi uhlanganise amatafula, umfoloko futhi uhlanganise amatafula, futhi wenze ukusunduza nokudonsa imisebenzi efana nezenzo endaweni yokugcina ye-git. Ngesikhathi esifanayo, i-DBMS isekela imibuzo ye-SQL futhi iyahambisana ne-MySQL ezingeni lokusebenzelana kweklayenti. Ikhodi yephrojekthi ibhalwe ku-Go futhi isatshalaliswa ngaphansi kwelayisensi ye-Apache 2.0.
Ikhono lokuguqula idatha ku-database likuvumela ukuthi ulandele umsuka wedatha - ukubophezela ezenzweni kwenza kube nokwenzeka ukulungisa isimo ukuze uthole imiphumela efanayo, okuthi, kungakhathaliseki isimo samanje, ingaphindaphindwa kwamanye amasistimu nganoma yisiphi isikhathi. . Ngaphezu kwalokho, abasebenzisi bangazulazula emlandweni, balandelele izinguquko kumathebula besebenzisa i-SQL ngaphandle kokuvumelanisa izipele, izinguquko zokuhlola, nokudala imibuzo ehlanganisa idatha ngesikhathi esithile.
I-DBMS inikeza izindlela ezimbili zokusebenza - Okungaxhunyiwe ku-inthanethi ne-Online. Uma sekukhishwe kokungaxhunyiwe ku-inthanethi, okuqukethwe kusizindalwazi kutholakala njengendawo yokugcina, engasetshenziswa kusetshenziswa insiza yomugqa womyalo ofana ne-git. Umsebenzi ufana kakhulu ne-git futhi uyahluka ikakhulukazi ngokuthi izinguquko azilandelelwanga amafayela, kodwa okuqukethwe kwamathebula. Ngesixhumi esibonakalayo se-CLI esihlongozwayo, ungangenisa idatha isuka kumafayela e-CSV noma e-JSON, wengeze ukuzinikela ngezinguquko, ubonise umehluko phakathi kwezinguqulo, udale amagatsha, usethe amathegi, wenze izicelo zokucindezela eziphakelini zangaphandle, futhi uhlanganise izinguquko ezihlongozwe abanye abanikeli.
Ngokukhethekile, idatha ingagcinwa kukhathalogi ye-DoltHub, engabhekwa njengeplatifomu efana ne-GitHub yokubamba idatha nokusebenzisana. Abasebenzisi bangahlanganisa izindawo zokugcina idatha, baphakamise izinguquko, futhi bahlanganise idatha yabo. Isibonelo, i-DoltHub inikeza izizindalwazi ezahlukahlukene ezinezibalo ze-coronavirus, amaqoqo edatha enezichasiselo zezinhlelo zokufunda komshini, izizindalwazi zezilimi, amaqoqo ezithombe, amasethi okuhlukaniswa kwezinto, kanye nolwazi lobunikazi. Amakheli e-IP.
I-Dolt SQL Server isebenza ku-inthanethi, ikuvumela ukuthi ulawule idatha usebenzisa i-SQL. I-interface enikeziwe ifana ne-MySQL futhi ingasetshenziswa ngamakhasimende ahambisana ne-MySQL noma nge-interface ye-CLI. Kodwa-ke, i-Dolt iyithuluzi lokulawula idatha kunesistimu yokucubungula imibuzo. Isibonelo, ngokuzenzakalelayo, i-SQL Server ingaphatha uxhumano olulodwa lomsebenzisi olusebenzayo endaweni yokugcina etholakala kuhlu lwamanje (lokhu kuziphatha kungashintshwa ngezilungiselelo). Ukuhumusha kungenzeka. iseva kumodi yokufunda kuphela. Izenzo eziningi zokulawula izinguqulo zingenziwa nge-SQL, njengokufaka noma ukushintsha amagatsha.
Source: opennet.ru
