{"id":37709,"date":"2019-10-31T22:19:14","date_gmt":"2019-10-31T19:19:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical\/"},"modified":"2019-10-31T22:19:14","modified_gmt":"2019-10-31T19:19:14","slug":"dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","title":{"rendered":"Dqlite 1.0, varianti i shp\u00ebrndar\u00eb i SQLite nga kompania Canonical, \u00ebsht\u00eb i disponuesh\u00ebm","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Kompania Canonical publikoi<\/a><\/noindex> n\u00eb m\u00ebnyr\u00eb t\u00eb konsiderueshme Dqlite 1.0<\/a><\/noindex> (SQLite e shp\u00ebrndar\u00eb), nj\u00eb motor SQL i integruar q\u00eb \u00ebsht\u00eb i pajtuesh\u00ebm me SQLite, q\u00eb mb\u00ebshtet replikimin e t\u00eb dh\u00ebnave, rikuperimin automatik nga d\u00ebshtimet dhe sigurimin e q\u00ebndrueshm\u00ebris\u00eb p\u00ebrmes shp\u00ebrndarjes s\u00eb trajtuesve n\u00eb disa nyje. Baza e t\u00eb dh\u00ebnave \u00ebsht\u00eb realizuar si nj\u00eb bibliotek\u00eb C q\u00eb e bashkangjitet me aplikacionet dhe shp\u00ebrndahet<\/a><\/noindex> n\u00eb p\u00ebrputhje me licenc\u00ebn Apache 2.0 (SQLite origjinale \u00ebsht\u00eb e disponueshme si pron\u00eb e p\u00ebrbashk\u00ebt). Ka lidhje t\u00eb disponueshme p\u00ebr gjuh\u00ebn Go<\/a><\/noindex>.<\/p>\n

Biblioteka \u00ebsht\u00eb nj\u00eb shtes\u00eb mbi baz\u00ebn e kodit ekzistues t\u00eb SQLite q\u00eb shton mb\u00ebshtetje p\u00ebr protokollin rrjet\u00ebsor p\u00ebr t\u00eb lidhur disa instance aplikacioni q\u00eb jan\u00eb duke u ekzekutuar n\u00eb hoste t\u00eb ndrysh\u00ebm. Nj\u00eb aplikacion i mbledhur me Dqlite mund t\u00eb funksionoj\u00eb si nj\u00eb klaster i q\u00ebndruesh\u00ebm, i pavarur nga bazat e t\u00eb dh\u00ebnave t\u00eb jashtme. N\u00eb praktik\u00eb, Dqlite p\u00ebrdoret nga Canonical n\u00eb sistemin e menaxhimit t\u00eb kontejner\u00ebve LXD<\/a><\/noindex>. Mes fushave t\u00eb aplikimit t\u00eb bibliotek\u00ebs p\u00ebrmenden gjithashtu krijimi i pajisjeve t\u00eb q\u00ebndrueshme t\u00eb internetit t\u00eb gj\u00ebrave dhe trajtues t\u00eb sistemeve
\nEdge<\/a><\/noindex>-t\u00eb llogaritjes<\/a><\/noindex>. <\/p>\n

P\u00ebr t\u00eb siguruar nj\u00eb q\u00ebndrim t\u00eb paansh\u00ebm gjat\u00eb replikimit t\u00eb t\u00eb dh\u00ebnave, aplikohet nj\u00eb metod\u00eb p\u00ebr t\u00eb arritur konsensus bazuar n\u00eb algoritmin Raft<\/a><\/noindex>, i cili p\u00ebrdoret n\u00eb projekte t\u00eb tilla si etcd, RethinkDB, CockroachDB dhe OpenDaylight. N\u00eb Dqlite aplikohet nj\u00eb realizim i ve\u00e7ant\u00eb asinkron i C-raft<\/a><\/noindex>, i shkruar n\u00eb gjuh\u00ebn C. P\u00ebr shum\u00ebfishimin e p\u00ebrpunimit t\u00eb lidhjeve dhe organizimin e fillimit t\u00eb korutinave p\u00ebrdoren biblioteka t\u00eb gatshme libuv<\/a><\/noindex> dhe libco<\/a><\/noindex>.<\/p>\n

N\u00eb krahasim me projektin e ngjash\u00ebm rqlite<\/a><\/noindex>, Dqlite siguron mb\u00ebshtetje t\u00eb plot\u00eb p\u00ebr transaksionet, mund t\u00eb lidhet me \u00e7do projekt n\u00eb gjuh\u00ebn C, lejon p\u00ebrdorimin e funksionit time() dhe aplicon replikim t\u00eb bazuar n\u00eb kadra n\u00eb vend t\u00eb replikimit t\u00eb bazuar n\u00eb transmetimin e shprehjeve SQL.<\/p>\n

Karakteristikat e Dqlite:<\/p>\n