{"id":103715,"date":"2022-04-05T15:36:50","date_gmt":"2022-04-05T13:36:50","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-ferretdb-0-1-realizaczii-mongodb-na-baze-subd-postgresql"},"modified":"2022-04-05T15:36:50","modified_gmt":"2022-04-05T13:36:50","slug":"vypusk-ferretdb-0-1-realizaczii-mongodb-na-baze-subd-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-ferretdb-0-1-realizaczii-mongodb-na-baze-subd-postgresql","title":{"rendered":"Lansarea FerretDB 0.1, implementarea MongoDB bazat\u0103 pe sistemul de gestionare a bazelor de date PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

A fost publicat lansarea proiectului FerretDB 0.1 (fost MangoDB), care permite \u00eenlocuirea sistemului de gestionare a bazelor de date orientate pe documente MongoDB cu PostgreSQL f\u0103r\u0103 a aduce modific\u0103ri \u00een codul aplica\u021biilor. FerretDB este implementat ca un server proxy, care translateaz\u0103 cererile c\u0103tre MangoDB \u00een interog\u0103ri SQL c\u0103tre PostgreSQL, permi\u021b\u00e2nd utilizarea PostgreSQL ca depozit efectiv. Codul este scris \u00een limbajul Go \u0219i este distribuit sub licen\u021ba Apache 2.0. <\/p>\n

Necesitatea migra\u021biei poate ap\u0103rea din cauza trecerii MongoDB la o licen\u021b\u0103 neagr\u0103 SSPL, care se bazeaz\u0103 pe licen\u021ba AGPLv3, dar nu este deschis\u0103, deoarece con\u021bine o cerin\u021b\u0103 discriminatorie de livrare sub licen\u021ba SSPL nu doar a codului aplica\u021biei \u00een sine, ci \u0219i a codurilor surs\u0103 ale tuturor componentelor implicate \u00een furnizarea unui serviciu cloud. <\/p>\n

Ca audien\u021b\u0103 \u021bint\u0103, FerretDB vizeaz\u0103 utilizatorii care nu folosesc \u00een aplica\u021biile lor func\u021bionalit\u0103\u021bile avansate ale MongoDB, dar doresc s\u0103 foloseasc\u0103 un stiv\u0103 software complet deschis\u0103. \u00cen stadiul actual de dezvoltare, FerretDB suport\u0103 doar o parte din func\u021bionalit\u0103\u021bile MongoDB, cele mai utilizate \u00een aplica\u021bii tipice. \u00cen viitor, se preconizeaz\u0103 atingerea unei compatibilit\u0103\u021bi complete cu driverele pentru MongoDB \u0219i oferirea posibilit\u0103\u021bii de a folosi FerretDB ca o \u00eenlocuire transparent\u0103 pentru MongoDB. <\/p>\n

Amintim c\u0103 MongoDB ocup\u0103 o ni\u0219\u0103 \u00eentre sistemele rapide \u0219i scalabile care opereaz\u0103 date \u00een format cheie\/valoare \u0219i sistemele relationale, func\u021bionale \u0219i convenabile pentru formarea interog\u0103rilor. MongoDB suport\u0103 stocarea documentelor \u00een format similar JSON, are un limbaj destul de flexibil pentru formarea interog\u0103rilor, poate crea indec\u0219i pentru diferite atribute stocate, asigur\u0103 eficient stocarea obiectelor binare mari, suport\u0103 jurnalizarea opera\u021biunilor de modificare \u0219i ad\u0103ugare a datelor \u00een baza de date, poate func\u021biona conform paradigmei Map\/Reduce, suport\u0103 replicarea \u0219i construirea unor configura\u021bii tolerante la erori. <\/p>\n

\u00cen versiunea FerretDB 0.1.0, metoda de extragere a datelor din PostgreSQL a fost complet ref\u0103cut\u0103. Anterior, pentru fiecare cerere primit\u0103 de la MongoDB, se genera o singur\u0103 interogare SQL c\u0103tre PostgreSQL, utiliz\u00e2nd func\u021bii pentru a lucra cu formatul JSON \u0219i efectu\u00e2nd filtrarea rezultatelor la nivelul PostgreSQL. Din cauza diferen\u021belor \u00een semantica func\u021biilor json ale PostgreSQL \u0219i MongoDB, s-au observat discrepan\u021be \u00een comportament la compararea \u0219i sortarea diferitelor tipuri. Pentru a rezolva aceast\u0103 problem\u0103, acum se extrage un set de date redundant din PostgreSQL, iar filtrarea rezultatelor se realizeaz\u0103 la nivelul FerretDB, ceea ce a permis replicarea comportamentului MongoDB \u00een majoritatea situa\u021biilor. <\/p>\n

Pre\u021bul cre\u0219terii compatibilit\u0103\u021bii a fost sc\u0103derea performan\u021bei, pe care se inten\u021bioneaz\u0103 s\u0103 o compenseze \u00een viitoarele versiuni prin filtrarea selectiv\u0103 pe partea FerretDB doar a interog\u0103rilor pentru care se observ\u0103 abateri de comportament. De exemplu, interogarea «db.collection.find({_id: ‘some-id-value’})» poate fi procesat\u0103 integral \u00een PostgreSQL. Obiectivul principal al proiectului \u00een aceast\u0103 etap\u0103 de dezvoltare este atingerea compatibilit\u0103\u021bii cu MongoDB, \u00een timp ce performan\u021ba este momentan secundar\u0103. Printre schimb\u0103rile func\u021bionale din noua versiune se num\u0103r\u0103 suportul pentru to\u021bi operatorii bitwise, operatorul de compara\u021bie «$eq», precum \u0219i operatorii «$elemMatch» \u0219i «$bitsAllClear».
\n
Sursa: opennet.ro<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 FerretDB 0.1 (\u0431\u044b\u0432\u0448\u0438\u0439 MangoDB), \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0435\u0433\u043e \u0437\u0430\u043c\u0435\u043d\u0438\u0442\u044c \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e-\u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0421\u0423\u0411\u0414 MongoDB \u043d\u0430 PostgreSQL \u0431\u0435\u0437 \u0432\u043d\u0435\u0441\u0435\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u043a\u043e\u0434 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439. FerretDB \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d \u043a\u0430\u043a \u043f\u0440\u043e\u043a\u0441\u0438-\u0441\u0435\u0440\u0432\u0435\u0440, \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0440\u0443\u044e\u0449\u0438\u0439 \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u044f \u043a MangoDB \u0432 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043a PostgreSQL, \u0447\u0442\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c PostgreSQL \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0444\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430. \u041a\u043e\u0434 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 Go \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2.0. \u041f\u043e\u0442\u0440\u0435\u0431\u043d\u043e\u0441\u0442\u044c \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0438 \u043c\u043e\u0436\u0435\u0442 \u0432\u043e\u0437\u043d\u0438\u043a\u043d\u0443\u0442\u044c […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-103715","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Lansarea FerretDB 0.1, implementarea MongoDB bazat\u0103 pe SGBD-ul PostgreSQL | ProHoster","description":"A fost publicat\u0103 versiunea 0.1 a proiectului FerretDB (fost MangoDB), care permite \u00eenlocuirea SGBD-ului documentar MongoDB cu PostgreSQL f\u0103r\u0103 a aduce modific\u0103ri \u00een codul aplica\u021biilor.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-ferretdb-0-1-realizaczii-mongodb-na-baze-subd-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a FerretDB 0.1, \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 MongoDB \u043d\u0430 \u0431\u0430\u0437\u0435 \u0421\u0423\u0411\u0414 PostgreSQL | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 FerretDB 0.1 (\u0431\u044b\u0432\u0448\u0438\u0439 MangoDB), \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0435\u0433\u043e \u0437\u0430\u043c\u0435\u043d\u0438\u0442\u044c \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e-\u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0421\u0423\u0411\u0414 MongoDB \u043d\u0430 PostgreSQL \u0431\u0435\u0437 \u0432\u043d\u0435\u0441\u0435\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u043a\u043e\u0434 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439.","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-ferretdb-0-1-realizaczii-mongodb-na-baze-subd-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2022-04-05T13:36:50+00:00","article:modified_time":"2022-04-05T13:36:50+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"103715","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2022-04-05 13:37:13","updated":"2022-10-02 21:35:28","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/103715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=103715"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/103715\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=103715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=103715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=103715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}