{"id":121505,"date":"2025-01-27T15:46:01","date_gmt":"2025-01-27T13:46:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/microsoft-otkryl-kod-subd-documentdb-osnovannoj-na-postgresql"},"modified":"2025-01-27T15:46:01","modified_gmt":"2025-01-27T13:46:01","slug":"microsoft-otkryl-kod-subd-documentdb-osnovannoj-na-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/microsoft-otkryl-kod-subd-documentdb-osnovannoj-na-postgresql","title":{"rendered":"Microsoft ka hapur kodi i DB DocumentDB, i bazuar n\u00eb PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Microsoft shpalli hapjen e kodit t\u00eb projektit DocumentDB, i cili mund t\u00eb p\u00ebrdoret si nj\u00eb DB NoSQL e ve\u00e7ant\u00eb, si nj\u00eb platform\u00eb p\u00ebr t\u00eb nd\u00ebrtuar sisteme t\u00eb veta ruajtjeje, ose si nj\u00eb shtes\u00eb p\u00ebr ruajtjen e t\u00eb dh\u00ebnave n\u00eb formatin BSON n\u00eb DB PostgreSQL. N\u00eb praktik\u00eb, DocumentDB p\u00ebrdoret n\u00eb Microsoft si baza e produktit \"Azure Cosmos DB for MongoDB\", q\u00eb ofron nj\u00eb nd\u00ebrfaqe n\u00eb p\u00ebrputhje me DB-n\u00eb dokumentore MongoDB. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT. Motori DocumentDB \u00ebsht\u00eb realizuar si nj\u00eb shtes\u00eb mbi DB-n\u00eb PostgreSQL. <\/p>\n
Si n\u00eb MongoDB, p\u00ebr ruajtjen e dokumenteve t\u00eb strukturuara n\u00eb DocumentDB p\u00ebrdoret formati BSON (Binary JSON), q\u00eb lejon krijimin e strukturave hierarkike, ku disa dokumente dhe grupe mund t\u00eb inkorporohen n\u00eb dokumente dhe grupe t\u00eb tjera. Dallimi kryesor nga JSON \u00ebsht\u00eb p\u00ebrdorimi i serializimit t\u00eb t\u00eb dh\u00ebnave n\u00eb p\u00ebrfaq\u00ebsimin e binar. Projekti ofron si operacione NoSQL p\u00ebr krijimin, leximin, p\u00ebrdit\u00ebsimin dhe fshirjen e t\u00eb dh\u00ebnave n\u00eb formatin BSON, ashtu edhe nj\u00eb API p\u00ebr PostgreSQL standarde (DocumentDB mund t\u00eb shqyrtohet si nj\u00eb variant i PostgreSQL me mb\u00ebshtetje p\u00ebr BSON). N\u00eb DocumentDB mund t\u00eb p\u00ebrdoren funksionalitetet e k\u00ebrkimit t\u00eb plot\u00eb, operacionet mbi llojet e t\u00eb dh\u00ebnave vektoriale dhe gjeop\u00ebrkat\u00ebse. <\/p>\n
Projekti p\u00ebrb\u00ebhet nga dy komponente: <\/p>\n
\n
pg_documentdb_core \u2014 nj\u00eb zgjerim p\u00ebr PostgreSQL me implementimin e tipit BSON dhe operacioneve p\u00ebr pun\u00ebn me t\u00eb dh\u00ebnat BSON n\u00eb PostgreSQL.\n
pg_documentdb \u2014 nj\u00eb API publik DocumentDB me operacione baz\u00eb p\u00ebr pun\u00ebn me dokumentet n\u00eb formatin BSON, p\u00ebrpunimin e k\u00ebrkesave dhe menaxhimin e indekseve. <\/ul>\n
L\u00ebshimi i par\u00eb i DocumentDB ofron mb\u00ebshtetje p\u00ebr operacionet CRUD (krijim, lexim, azhurnim, fshirje), indekse p\u00ebr fusha t\u00eb ve\u00e7anta BSON, indekse p\u00ebr k\u00ebrkim t\u00eb plot\u00ebtekstit (t\u00eb pajtueshme me RUM), k\u00ebrkesa vektoriale dhe gjeospaciale (t\u00eb pajtueshme me pg_vector dhe postgis), mund\u00ebsi p\u00ebr krijimin e k\u00ebrkesave dhe agregimin e t\u00eb dh\u00ebnave BSON. <\/p>\n
Projekti FerretDB, i cili po zhvillon zbatimin e SGBD-s\u00eb MongoDB mbi baz\u00ebn e SGBD-s\u00eb PostgreSQL, ka kaluar tashm\u00eb n\u00eb p\u00ebrdorimin e DocumentDB. FerretDB lejon z\u00ebvend\u00ebsimin e sistemit proprietar t\u00eb menaxhimit t\u00eb dokumenteve MongoDB me nj\u00eb grumbull softuerik plot\u00ebsisht t\u00eb hapur, t\u00eb bazuar n\u00eb PostgreSQL, pa b\u00ebr\u00eb ndryshime n\u00eb kodin e aplikacioneve. Nevoja p\u00ebr z\u00ebvend\u00ebsimin e MongoDB shpjegohet me kalimin e k\u00ebtij SGBD n\u00eb licenc\u00ebn SSPL, e cila bazohet n\u00eb licenc\u00ebn AGPLv3, por nuk \u00ebsht\u00eb e hapur, pasi p\u00ebrmban nj\u00eb k\u00ebrkes\u00eb diskriminuese p\u00ebr dor\u00ebzimin jo vet\u00ebm t\u00eb kodit t\u00eb aplikacionit, por edhe t\u00eb burimeve t\u00eb t\u00eb gjith\u00eb komponenteve t\u00eb p\u00ebrfshir\u00eb n\u00eb ofrimin e sh\u00ebrbimit n\u00eb cloud. <\/p>\n
Fillimisht, puna e FerretDB p\u00ebrfshinte p\u00ebrkthimin e thirrjeve ndaj MongoDB n\u00eb k\u00ebrkesat SQL p\u00ebr PostgreSQL, por duke filluar nga versioni FerretDB 2.0, i cili \u00ebsht\u00eb n\u00eb faz\u00ebn e kandidat\u00ebve p\u00ebr l\u00ebshim, \u00ebsht\u00eb p\u00ebrdorur zgjerimi DocumentDB n\u00eb PostgreSQL p\u00ebr t\u00eb mb\u00ebshtetur formatin BSON. Kalimi n\u00eb p\u00ebrdorimin e DocumentDB ndihmoi p\u00ebr t\u00eb rritur m\u00eb shum\u00eb se 20 her\u00eb performanc\u00ebn e FerretDB p\u00ebr disa lloje ngarkesash. Nga risit\u00eb e tjera, FerretDB 2.0 p\u00ebrmendet p\u00ebr p\u00ebrmir\u00ebsimin e p\u00ebrputhshm\u00ebris\u00eb me MongoDB, mund\u00ebsin\u00eb e replikimit dhe mb\u00ebshtetje p\u00ebr k\u00ebrkimin vektorial. Kodi FerretDB \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Go dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"