{"id":107002,"date":"2025-05-01T03:27:19","date_gmt":"2025-04-30T22:57:19","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/"},"modified":"2025-05-01T03:27:19","modified_gmt":"2025-04-30T22:57:19","slug":"%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/","title":{"rendered":"\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627\u06cc \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u062f\u0631 JSON (\u0627\u0633\u0646\u0627\u062f Postgresql JSONB \u0648 MongoDB)"},"content":{"rendered":"<div data-article-id=\"2449915\" id=\"article-body\">\n<p>\u0647\u0646\u06af\u0627\u0645 \u06a9\u0627\u0631 \u0628\u0627 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0627\u0633\u0646\u0627\u062f \u060c \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0631\u06cc\u0634\u0647 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u0628\u06cc\u0627\u0646 \u0633\u0627\u062f\u0647 \u0641\u0647\u0631\u0633\u062a \u0628\u0646\u062f\u06cc \u06a9\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u062f\u0631 \u0645\u0633\u06cc\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u060c \u06a9\u0647 \u0646\u0645\u0627\u06cc\u0627\u0646\u06af\u0631 \u06cc\u06a9 \u0631\u0627\u0628\u0637\u0647 \u06cc\u06a9 \u0628\u0647 \u06cc\u06a9 \u0627\u0633\u062a \u060c PostgreSQL \u0628\u0647 \u06cc\u06a9 \u0634\u0627\u062e\u0635 GIN \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u067e\u0631\u0627\u062a\u0648\u0631\u0647\u0627\u06cc \u0645\u0633\u06cc\u0631 JSON \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u060c \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631 \u0627\u0632 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc SQL\/JSON \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/#%D9%86%D9%85%D9%88%D9%86%D9%87\" >\u0646\u0645\u0648\u0646\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/#%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D9%86%D8%A7%DA%A9%D8%A7%D8%B1%D8%A2%D9%85%D8%AF_%D8%A8%D8%A7_SQL_%D9%BE%DB%8C%D9%88%D8%B3%D8%AA%D9%86\" >\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0646\u0627\u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0627 SQL \u067e\u06cc\u0648\u0633\u062a\u0646<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/#%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%DA%A9%D8%A7%D8%B1%D8%A2%D9%85%D8%AF_%D8%A8%D8%A7_%D8%A7%D9%BE%D8%B1%D8%A7%D8%AA%D9%88%D8%B1%D9%87%D8%A7%DB%8C_JSON\" >\u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0627 \u0627\u067e\u0631\u0627\u062a\u0648\u0631\u0647\u0627\u06cc JSON<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/#%D9%85%D9%82%D8%A7%DB%8C%D8%B3%D9%87_%D8%A8%D8%A7_%DB%8C%DA%A9_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B3%D9%86%D8%AF\" >\u0645\u0642\u0627\u06cc\u0633\u0647 \u0628\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0646\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/%d9%be%d8%b1%d8%b3-%d9%88-%d8%ac%d9%88-%d8%a2%d8%b1%d8%a7%db%8c%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%d8%b9%d8%a8%db%8c%d9%87-%d8%b4%d8%af%d9%87-%d8%af%d8%b1-json-%d8%a7%d8%b3%d9%86%d8%a7%d8%af-postgresql\/#%D9%BE%D8%A7%DB%8C%D8%A7%D9%86\" >\u067e\u0627\u06cc\u0627\u0646<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D9%88%D9%86%D9%87\"><\/span>\n<p>  \u0646\u0645\u0648\u0646\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u0646 \u062c\u062f\u0648\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u06a9\u062a\u0627\u0628 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0645. \u0645\u0646 \u062a\u0635\u0645\u06cc\u0645 \u06af\u0631\u0641\u062a\u0645 \u06a9\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u0637\u0631\u062d \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u062c\u0627\u0633\u0627\u0632\u06cc \u06a9\u0646\u0645 \u0648 \u06cc\u06a9 \u0633\u062a\u0648\u0646 &#8220;\u062f\u0627\u062f\u0647&#8221; \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc JSON \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">create<\/span> <span class=\"k\">table<\/span> <span class=\"n\">books<\/span> <span class=\"p\">(<\/span>  \n   <span class=\"k\">primary<\/span> <span class=\"k\">key<\/span><span class=\"p\">(<\/span><span class=\"n\">book_id<\/span><span class=\"p\">),<\/span>  \n   <span class=\"n\">book_id<\/span> <span class=\"nb\">bigint<\/span><span class=\"p\">,<\/span>  \n   <span class=\"n\">title<\/span> <span class=\"nb\">text<\/span><span class=\"p\">,<\/span>  \n   <span class=\"k\">data<\/span> <span class=\"n\">jsonb<\/span>  \n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0646 \u06cc\u06a9 \u06a9\u062a\u0627\u0628 \u0631\u0627 \u0648\u0627\u0631\u062f \u0645\u06cc \u06a9\u0646\u0645 \u0648 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0646\u0638\u0631\u0627\u062a \u0631\u0627 \u062f\u0631 \u0633\u0646\u062f \u0637\u0631\u062d \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">insert<\/span> <span class=\"k\">into<\/span> <span class=\"n\">books<\/span> <span class=\"k\">values<\/span> <span class=\"p\">(<\/span>  \n   <span class=\"mi\">8675309<\/span><span class=\"p\">,<\/span>  \n   <span class=\"s1\">'Brave New World'<\/span><span class=\"p\">,<\/span>  \n   <span class=\"s1\">'{ \"reviews\":[  \n      { \"name\": \"John\", \"text\": \"Amazing!\" },  \n      { \"name\": \"Jane\", \"text\": \"Incredible book!\" }  \n   ] }'<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u062c\u062f\u0648\u0644 \u062f\u06cc\u06af\u0631\u06cc \u0646\u06cc\u0633\u062a \u060c \u0632\u06cc\u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0647\u0627 \u0630\u0627\u062a\u0627\u064b \u0628\u0627 \u06a9\u062a\u0627\u0628\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646\u0647\u0627 \u0628\u062d\u062b \u0645\u06cc \u06a9\u0646\u0646\u062f \u0645\u0631\u062a\u0628\u0637 \u0627\u0633\u062a. \u06cc\u06a9 \u06a9\u062a\u0627\u0628 \u0628\u062f\u0648\u0646 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0631 \u06a9\u0646\u0627\u0631 \u0628\u0631\u0631\u0633\u06cc \u0622\u0646 \u0642\u0627\u0628\u0644 \u0628\u0631\u0631\u0633\u06cc \u0646\u06cc\u0633\u062a \u060c \u0648 \u0647\u0631 \u062c\u062f\u0648\u0644 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u06cc \u0631\u0627 \u063a\u06cc\u0631 \u0636\u0631\u0648\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0645\u0646 \u0645\u06cc \u062f\u0627\u0646\u0645 \u06a9\u0647 \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f \u0646\u0642\u0636 \u0627\u0648\u0644\u06cc\u0646 \u0641\u0631\u0645 \u0639\u0627\u062f\u06cc \u0627\u0633\u062a \u060c \u0627\u0645\u0627 \u0647\u06cc\u0686 \u0646\u0627\u0647\u0646\u062c\u0627\u0631\u06cc \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u0645\u06a9\u0627\u0646 \u067e\u0630\u06cc\u0631 \u0646\u06cc\u0633\u062a \u0632\u06cc\u0631\u0627 \u0647\u06cc\u0686 \u062a\u06a9\u062b\u06cc\u0631 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f. \u0627\u0632 \u0646\u0638\u0631 \u0639\u0627\u062f\u06cc \u0633\u0627\u0632\u06cc \u060c \u0627\u06cc\u0646 \u0628\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u062a\u0646 \u060c \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 \u06cc\u0627 \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u06a9\u0647 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627\u06cc\u06cc \u0627\u0632 \u0627\u0639\u062f\u0627\u062f \u0647\u0633\u062a\u0646\u062f \u060c \u062a\u0641\u0627\u0648\u062a \u0686\u0646\u062f\u0627\u0646\u06cc \u0646\u062f\u0627\u0631\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D9%86%D8%A7%DA%A9%D8%A7%D8%B1%D8%A2%D9%85%D8%AF_%D8%A8%D8%A7_SQL_%D9%BE%DB%8C%D9%88%D8%B3%D8%AA%D9%86\"><\/span>\n<p>  \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0646\u0627\u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0627 SQL \u067e\u06cc\u0648\u0633\u062a\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06af\u0631 \u0628\u0627 SQL \u0631\u0627\u062d\u062a \u0647\u0633\u062a\u06cc\u062f \u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f. \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u0622\u0631\u0627\u06cc\u0647 \u0633\u0646\u062f JSON \u0631\u0627 \u063a\u06cc\u0631\u0642\u0627\u0646\u0648\u0646\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0622\u0646 \u0645\u0627\u0646\u0646\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"k\">DISTINCT<\/span> <span class=\"n\">title<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">books<\/span>    \n<span class=\"k\">JOIN<\/span> <span class=\"k\">LATERAL<\/span> <span class=\"n\">jsonb_array_elements<\/span><span class=\"p\">(<\/span><span class=\"n\">books<\/span><span class=\"p\">.<\/span><span class=\"k\">data<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'reviews'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">review<\/span> \n<span class=\"k\">ON<\/span> <span class=\"n\">review<\/span><span class=\"o\">-&gt;&gt;<\/span><span class=\"s1\">'name'<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'John'<\/span>\n<span class=\"p\">;<\/span>  \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><code>jsonb_array_elements<\/code>  \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 JSON \u0631\u0627 \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc SQL \u062f\u0631 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u06af\u0633\u062a\u0631\u0634 \u0645\u06cc \u062f\u0647\u062f. The Lateral Join \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u06a9\u062a\u0627\u0628 \u060c \u0641\u06cc\u0644\u062a\u0631\u0647\u0627\u06cc \u0628\u0646\u062f OR \u06cc\u0627 Where Where \u0631\u0627 \u0628\u0627 \u0646\u0627\u0645 Reverseer \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0639\u0646\u0627\u0648\u06cc\u0646 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0646\u062d\u0648 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f SQL \u0627\u0633\u062a \u0627\u0645\u0627 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0627\u0632 \u06cc\u06a9 \u0641\u0647\u0631\u0633\u062a \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u0646\u0627\u0645 \u0628\u0627\u0632\u0631\u0633\u0627\u0646 \u0642\u0628\u0644 \u0627\u0632 \u0639\u062f\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u062f \u060c \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062e\u0648\u0627\u0646\u062f\u0646 \u0647\u0645\u0647 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0648 \u0627\u0633\u0646\u0627\u062f \u062f\u0627\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code>                              <span class=\"n\">QUERY<\/span> <span class=\"n\">PLAN<\/span>                               \n<span class=\"c1\">-----------------------------------------------------------------------<\/span>\n <span class=\"k\">Unique<\/span>\n   <span class=\"o\">-&gt;<\/span>  <span class=\"n\">Sort<\/span>\n         <span class=\"n\">Sort<\/span> <span class=\"k\">Key<\/span><span class=\"p\">:<\/span> <span class=\"n\">books<\/span><span class=\"p\">.<\/span><span class=\"n\">title<\/span>\n         <span class=\"o\">-&gt;<\/span>  <span class=\"n\">Nested<\/span> <span class=\"n\">Loop<\/span>\n               <span class=\"o\">-&gt;<\/span>  <span class=\"n\">Seq<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">books<\/span>\n               <span class=\"o\">-&gt;<\/span>  <span class=\"k\">Function<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">jsonb_array_elements<\/span> <span class=\"n\">review<\/span>\n                     <span class=\"n\">Filter<\/span><span class=\"p\">:<\/span> <span class=\"p\">((<\/span><span class=\"n\">value<\/span> <span class=\"o\">-&gt;&gt;<\/span> <span class=\"s1\">'name'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">)<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'John'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u06cc\u06a9 \u0646\u062d\u0648 \u0645\u0639\u062a\u0628\u0631 SQL \u0627\u0633\u062a \u060c \u0648 JSON \u06cc\u06a9 \u062f\u0627\u062f\u0647 SQL \u0645\u0639\u062a\u0628\u0631 \u0627\u0633\u062a \u060c \u0627\u0645\u0627 \u0622\u0646\u0647\u0627 \u0686\u0646\u062f\u0627\u0646 \u062f\u0648\u0633\u062a\u0627\u0646\u0647 \u0646\u06cc\u0633\u062a\u0646\u062f \u0632\u06cc\u0631\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u0646\u0627\u062f \u0646\u06cc\u0633\u062a. \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0633\u0646\u0627\u062f \u062f\u0631 PostgreSQL \u060c \u0628\u0627\u06cc\u062f \u06cc\u0627\u062f \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0622\u0646\u0647\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0641\u0647\u0631\u0633\u062a \u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 <code>jsonb_array_elements<\/code> \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f SQL \u0646\u06cc\u0633\u062a \u060c \u0627\u0645\u0627 PostgreSQL 17 JSON_TABLE \u0631\u0627 \u0645\u0639\u0631\u0641\u06cc \u06a9\u0631\u062f \u06a9\u0647 APRT \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0627\u0633\u062a. \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u0648\u0628\u0627\u0631\u0647 \u0646\u0648\u0634\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">books<\/span><span class=\"p\">.<\/span><span class=\"n\">title<\/span>  \n<span class=\"k\">FROM<\/span> <span class=\"n\">books<\/span>  \n<span class=\"k\">JOIN<\/span> <span class=\"n\">JSON_TABLE<\/span><span class=\"p\">(<\/span>  \n  <span class=\"n\">books<\/span><span class=\"p\">.<\/span><span class=\"k\">data<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'reviews'<\/span><span class=\"p\">,<\/span>  \n  <span class=\"s1\">'$[*]'<\/span> <span class=\"n\">COLUMNS<\/span> <span class=\"p\">(<\/span>  \n    <span class=\"n\">name<\/span> <span class=\"nb\">TEXT<\/span> <span class=\"n\">PATH<\/span> <span class=\"s1\">'$.name'<\/span> \n  <span class=\"p\">)<\/span>  \n<span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">review<\/span>  \n<span class=\"k\">ON<\/span> <span class=\"n\">review<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'John'<\/span>\n<span class=\"p\">;<\/span>  \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f SQL\/JSON \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u0627\u0633\u0646\u0627\u062f \u0627\u0633\u062a. \u0645\u062a\u0623\u0633\u0641\u0627\u0646\u0647 \u060c \u06a9\u0627\u0631\u0622\u0645\u062f \u0646\u06cc\u0633\u062a \u0632\u06cc\u0631\u0627 \u0627\u0633\u06a9\u0646 \u0634\u0627\u062e\u0635 \u0627\u0645\u06a9\u0627\u0646 \u067e\u0630\u06cc\u0631 \u0646\u06cc\u0633\u062a. \u0641\u0631\u0627\u0645\u0648\u0634 \u0646\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc SQL \u0628\u062e\u0634\u06cc \u0627\u0632 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f SQL \u0646\u06cc\u0633\u062a\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%DA%A9%D8%A7%D8%B1%D8%A2%D9%85%D8%AF_%D8%A8%D8%A7_%D8%A7%D9%BE%D8%B1%D8%A7%D8%AA%D9%88%D8%B1%D9%87%D8%A7%DB%8C_JSON\"><\/span>\n<p>  \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0627 \u0627\u067e\u0631\u0627\u062a\u0648\u0631\u0647\u0627\u06cc JSON<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc JSONB \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u062a\u0648\u0633\u0637 \u06cc\u06a9 \u0634\u062e\u0635 \u062e\u0627\u0635 \u060c \u0645\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0627\u067e\u0631\u0627\u062a\u0648\u0631 \u0645\u0647\u0627\u0631 PostgreSQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>@&gt;<\/code> \u0628\u0647 \u062c\u0627\u06cc \u062a\u06a9\u06cc\u0647 \u0628\u0631 SQL \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">title<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">books<\/span>  \n<span class=\"k\">WHERE<\/span> <span class=\"k\">data<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'reviews'<\/span> <span class=\"o\">@&gt;<\/span> <span class=\"s1\">'[{\"name\": \"John\"}]'<\/span>\n<span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0628\u062f\u0648\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0633\u0646\u062f \u0631\u0648\u06cc \u062c\u062f\u0648\u0644 \u0641\u06cc\u0644\u062a\u0631 \u0645\u06cc \u06a9\u0646\u0645 \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u06cc\u06a9 \u0641\u0647\u0631\u0633\u062a \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u0645. \u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0686\u0646\u062f\u06cc\u0646 \u06a9\u0644\u06cc\u062f \u062f\u0631 \u0647\u0631 \u0631\u062f\u06cc\u0641 \u062c\u062f\u0648\u0644 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a \u060c \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u0644\u0627\u0632\u0645 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">books<\/span> <span class=\"k\">USING<\/span> <span class=\"n\">gin<\/span> <span class=\"p\">((<\/span><span class=\"k\">data<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'reviews'<\/span><span class=\"p\">)<\/span> <span class=\"n\">jsonb_path_ops<\/span><span class=\"p\">)<\/span>\n<span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u062f\u0627\u0634\u062a\u0646 \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u0628\u0631\u0627\u06cc \u0627\u067e\u0631\u0627\u062a\u0648\u0631\u0647\u0627\u06cc \u0645\u0633\u06cc\u0631 JSON \u060c \u0647\u0631 \u06a9\u0644\u06cc\u062f \u0628\u0627 \u06cc\u06a9 \u0645\u0648\u0631\u062f \u062f\u0631 \u0622\u0631\u0627\u06cc\u0647 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u062f. \u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0647\u0646\u06af\u0627\u0645 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0627 \u0641\u06cc\u0644\u062a\u0631 \u0628\u0631\u0627\u0628\u0631\u06cc \u062f\u0631 \u0642\u0633\u0645\u062a \u0622\u0631\u0627\u06cc\u0647 \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code>                                   <span class=\"n\">QUERY<\/span> <span class=\"n\">PLAN<\/span>                                   \n<span class=\"c1\">--------------------------------------------------------------------------------<\/span>\n <span class=\"n\">Bitmap<\/span> <span class=\"n\">Heap<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">books<\/span>\n   <span class=\"k\">Recheck<\/span> <span class=\"n\">Cond<\/span><span class=\"p\">:<\/span> <span class=\"p\">((<\/span><span class=\"k\">data<\/span> <span class=\"o\">-&gt;<\/span> <span class=\"s1\">'reviews'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">)<\/span> <span class=\"o\">@&gt;<\/span> <span class=\"s1\">'[{\"name\": \"John\"}]'<\/span><span class=\"p\">::<\/span><span class=\"n\">jsonb<\/span><span class=\"p\">)<\/span>\n   <span class=\"o\">-&gt;<\/span>  <span class=\"n\">Bitmap<\/span> <span class=\"k\">Index<\/span> <span class=\"n\">Scan<\/span> <span class=\"k\">on<\/span> <span class=\"n\">books_expr_idx<\/span>\n         <span class=\"k\">Index<\/span> <span class=\"n\">Cond<\/span><span class=\"p\">:<\/span> <span class=\"p\">((<\/span><span class=\"k\">data<\/span> <span class=\"o\">-&gt;<\/span> <span class=\"s1\">'reviews'<\/span><span class=\"p\">::<\/span><span class=\"nb\">text<\/span><span class=\"p\">)<\/span> <span class=\"o\">@&gt;<\/span> <span class=\"s1\">'[{\"name\": \"John\"}]'<\/span><span class=\"p\">::<\/span><span class=\"n\">jsonb<\/span><span class=\"p\">)<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062c\u06cc\u0646 (\u0634\u0627\u062e\u0635 \u0645\u0639\u06a9\u0648\u0633 \u062a\u0639\u0645\u06cc\u0645 \u06cc\u0627\u0641\u062a\u0647) \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0627\u06cc \u0637\u0631\u0627\u062d\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0634\u0627\u0645\u0644 \u0686\u0646\u062f\u06cc\u0646 \u06a9\u0644\u06cc\u062f \u0645\u0627\u0646\u0646\u062f \u0645\u0648\u0627\u0631\u062f \u0622\u0631\u0627\u06cc\u0647 \u06cc\u0627 \u06a9\u0644\u0645\u0627\u062a \u060c \u0633\u0627\u0642\u0647 \u0647\u0627 \u06cc\u0627 TRIGRAM \u062f\u0631 \u0645\u062a\u0646 \u0627\u0633\u062a. \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0627\u0633\u062a \u060c \u062c\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc\u06cc \u062f\u0627\u0631\u062f: \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062f\u0627\u0645\u0646\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u06a9\u0646\u062f \u060c \u062a\u0631\u062a\u06cc\u0628 \u0631\u0627 \u0628\u0627 \u0628\u0646\u062f\u0647\u0627 \u0628\u0647\u06cc\u0646\u0647 \u06a9\u0646\u062f \u060c \u06cc\u0627 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627\u06cc \u067e\u0648\u0634\u0634 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f (\u0628\u062f\u0648\u0646 \u0627\u0633\u06a9\u0646 \u0641\u0642\u0637 \u0634\u0627\u062e\u0635).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D9%82%D8%A7%DB%8C%D8%B3%D9%87_%D8%A8%D8%A7_%DB%8C%DA%A9_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B3%D9%86%D8%AF\"><\/span>\n<p>  \u0645\u0642\u0627\u06cc\u0633\u0647 \u0628\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0646\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 PostgreSQL \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0630\u062e\u06cc\u0631\u0647 \u0648 \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0627\u0633\u0646\u0627\u062f JSON \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f \u060c \u0627\u06cc\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0646\u062f \u0631\u0627 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0646\u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0627\u0633\u0646\u0627\u062f \u0627\u0646\u0648\u0627\u0639 \u0628\u0648\u0645\u06cc \u0647\u0633\u062a\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u062f\u0631 MongoDB \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0645\u0627\u0646\u0646\u062f \u0647\u0631 \u0632\u0645\u06cc\u0646\u0647 \u062f\u06cc\u06af\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0645\u0646 \u0633\u0646\u062f \u0645\u0634\u0627\u0628\u0647 \u0631\u0627 \u062f\u0631 MongoDB \u0648\u0627\u0631\u062f \u0645\u06cc \u06a9\u0646\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">books<\/span><span class=\"p\">.<\/span><span class=\"nf\">insertOne<\/span><span class=\"p\">({<\/span>  \n  <span class=\"na\">book_id<\/span><span class=\"p\">:<\/span> <span class=\"mi\">8675309<\/span><span class=\"p\">,<\/span>  \n  <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">Brave New World<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span>  \n  <span class=\"na\">reviews<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>  \n    <span class=\"p\">{<\/span> <span class=\"na\">name<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">John<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span> <span class=\"na\">text<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">Amazing!<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">},<\/span>  \n    <span class=\"p\">{<\/span> <span class=\"na\">name<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">Jane<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span> <span class=\"na\">text<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">Incredible book!<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">}<\/span>  \n  <span class=\"p\">]<\/span>  \n<span class=\"p\">});<\/span> \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0627\u067e\u0631\u0627\u062a\u0648\u0631\u0647\u0627\u06cc \u0648\u06cc\u0698\u0647 \u0646\u06cc\u0633\u062a \u0648 \u0645\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u0645\u0627\u0646\u0646\u062f \u0647\u0631 \u0632\u0645\u06cc\u0646\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0627\u0632 \u0632\u0645\u06cc\u0646\u0647 \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">books<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span>\n  <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">reviews.name<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">John<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">}<\/span> <span class=\"c1\">\/\/ filter<\/span>\n<span class=\"p\">,<\/span> <span class=\"p\">{<\/span> <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"na\">_id<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span> <span class=\"p\">}<\/span>      <span class=\"c1\">\/\/ projection<\/span>\n<span class=\"p\">);<\/span>  \n\n<span class=\"p\">[<\/span> <span class=\"p\">{<\/span> <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">Brave New World<\/span><span class=\"dl\">'<\/span> <span class=\"p\">}<\/span> <span class=\"p\">]<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0646\u0648\u0639 \u0634\u0627\u062e\u0635 \u062e\u0627\u0635 \u0646\u06cc\u0633\u062a \u0648 \u0645\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u0645\u0627\u0646\u0646\u062f \u0647\u0631 \u0632\u0645\u06cc\u0646\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0642\u0633\u0645\u062a \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u0631\u0627 \u0641\u0647\u0631\u0633\u062a \u0628\u0646\u062f\u06cc \u06a9\u0646\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">books<\/span><span class=\"p\">.<\/span><span class=\"nf\">createIndex<\/span><span class=\"p\">({<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">reviews.name<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">})<\/span>\n<span class=\"p\">;<\/span>  \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u062c\u0631\u0627\u06cc \u062a\u0623\u06cc\u06cc\u062f \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0641\u0647\u0631\u0633\u062a \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u062f\u0631 &#8220;\u0628\u0631\u0631\u0633\u06cc \u0647\u0627&#8221; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">books<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span>\n  <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">reviews.name<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">John<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">}<\/span> <span class=\"c1\">\/\/ filter<\/span>\n<span class=\"p\">,<\/span> <span class=\"p\">{<\/span> <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"na\">_id<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span> <span class=\"p\">}<\/span>      <span class=\"c1\">\/\/ projection<\/span>\n<span class=\"p\">).<\/span><span class=\"nf\">explain<\/span><span class=\"p\">().<\/span><span class=\"nx\">queryPlanner<\/span><span class=\"p\">.<\/span><span class=\"nx\">winningPlan<\/span>\n<span class=\"p\">;<\/span> \n\n<span class=\"p\">{<\/span>\n  <span class=\"na\">isCached<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n  <span class=\"na\">stage<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">PROJECTION_SIMPLE<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n  <span class=\"na\">transformBy<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"na\">_id<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span> <span class=\"p\">},<\/span>\n  <span class=\"na\">inputStage<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n    <span class=\"na\">stage<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">FETCH<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n    <span class=\"na\">inputStage<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n      <span class=\"na\">stage<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">IXSCAN<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">keyPattern<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name<\/span><span class=\"dl\">'<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">},<\/span>\n      <span class=\"na\">indexName<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name_1<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">isMultiKey<\/span><span class=\"p\">:<\/span> <span class=\"kc\">true<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">multiKeyPaths<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name<\/span><span class=\"dl\">'<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews<\/span><span class=\"dl\">'<\/span> <span class=\"p\">]<\/span> <span class=\"p\">},<\/span>\n      <span class=\"na\">isUnique<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">isSparse<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">isPartial<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">indexVersion<\/span><span class=\"p\">:<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">direction<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">forward<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">indexBounds<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name<\/span><span class=\"dl\">'<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">[\"John\", \"John\"]<\/span><span class=\"dl\">'<\/span> <span class=\"p\">]<\/span> <span class=\"p\">}<\/span>\n    <span class=\"p\">}<\/span>\n  <span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u0645\u0639\u0645\u0648\u0644\u06cc \u0627\u0633\u062a \u060c \u062a\u0646\u0647\u0627 \u062e\u0627\u0635\u06cc\u062a \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0648\u0631\u0648\u062f\u06cc \u0647\u0627\u06cc \u0686\u0646\u062f \u06a9\u0644\u06cc\u062f \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f. <\/p>\n<p>\u0628\u0631 \u062e\u0644\u0627\u0641 \u0634\u0627\u062e\u0635 GIN PostgreSQL \u060c \u06a9\u0647 \u0628\u0647 \u0627\u0633\u06a9\u0646 Bitmap \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f \u06a9\u0647 \u0633\u0641\u0627\u0631\u0634 \u0648\u0631\u0648\u062f \u0631\u0627 \u062d\u0641\u0638 \u0646\u0645\u06cc \u06a9\u0646\u062f \u060c MongoDB \u0627\u0632 \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u0645\u0639\u0645\u0648\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0627\u0632 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u0627\u0645\u0646\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u0627\u06af\u0631 \u0645\u0646 \u0641\u0642\u0637 \u0627\u0632 \u0622\u063a\u0627\u0632 \u06cc\u06a9 \u0646\u0627\u0645 \u0645\u06cc \u062f\u0627\u0646\u0645 \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u0627\u0632 \u06cc\u06a9 \u0639\u0628\u0627\u0631\u062a \u0645\u0646\u0638\u0645 \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u0646\u062a\u0627\u06cc\u062c \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">books<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span>  \n  <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">reviews.name<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"na\">$regex<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">^Joh<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">}<\/span> <span class=\"p\">},<\/span> <span class=\"c1\">\/\/ filter using regex  <\/span>\n  <span class=\"p\">{<\/span> <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"na\">_id<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span> <span class=\"p\">}<\/span>                    <span class=\"c1\">\/\/ projection  <\/span>\n<span class=\"p\">).<\/span><span class=\"nf\">explain<\/span><span class=\"p\">().<\/span><span class=\"nx\">queryPlanner<\/span><span class=\"p\">.<\/span><span class=\"nx\">winningPlan<\/span>\n<span class=\"p\">;<\/span>  \n\n<span class=\"p\">{<\/span>\n  <span class=\"na\">isCached<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n  <span class=\"na\">stage<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">PROJECTION_SIMPLE<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n  <span class=\"na\">transformBy<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"na\">title<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"na\">_id<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span> <span class=\"p\">},<\/span>\n  <span class=\"na\">inputStage<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n    <span class=\"na\">stage<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">FETCH<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n    <span class=\"na\">inputStage<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n      <span class=\"na\">stage<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">IXSCAN<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">keyPattern<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name<\/span><span class=\"dl\">'<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span> <span class=\"p\">},<\/span>\n      <span class=\"na\">indexName<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name_1<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">isMultiKey<\/span><span class=\"p\">:<\/span> <span class=\"kc\">true<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">multiKeyPaths<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name<\/span><span class=\"dl\">'<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews<\/span><span class=\"dl\">'<\/span> <span class=\"p\">]<\/span> <span class=\"p\">},<\/span>\n      <span class=\"na\">isUnique<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">isSparse<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">isPartial<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">indexVersion<\/span><span class=\"p\">:<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">direction<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">forward<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\n      <span class=\"na\">indexBounds<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">reviews.name<\/span><span class=\"dl\">'<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">[\"Joh\", \"Joi\")<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">[\/^Joh\/, \/^Joh\/]<\/span><span class=\"dl\">'<\/span> <span class=\"p\">]<\/span> <span class=\"p\">}<\/span>\n    <span class=\"p\">}<\/span>\n  <span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>MongoDB \u0627\u0632 \u0634\u0627\u062e\u0635 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f \u060c \u0632\u06cc\u0631\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u06cc\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u06cc\u0627\u0646 \u0645\u0646\u0638\u0645 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f <code>\/^Joh\/<\/code> \u0628\u0647 \u0637\u0648\u0631 \u062e\u0627\u0635 \u0628\u0647 \u06cc\u06a9 \u0627\u0633\u06a9\u0646 \u062f\u0627\u0645\u0646\u0647 <code>[\"Joh\", \"Joi\")<\/code>\u0628\u0634\u0631<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%BE%D8%A7%DB%8C%D8%A7%D9%86\"><\/span>\n<p>  \u067e\u0627\u06cc\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0647\u0646\u06af\u0627\u0645 \u0645\u0642\u0627\u06cc\u0633\u0647 PostgreSQL \u0648 MongoDB \u060c \u062f\u0631\u06a9 \u0645\u06a9\u0627\u0646\u06cc\u0633\u0645 \u0647\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0648 \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0622\u0646\u0647\u0627 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u0648 \u0641\u0642\u0637 \u0628\u0647 \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc \u0622\u0646\u0647\u0627 \u062f\u0631 \u0630\u062e\u06cc\u0631\u0647 JSON \u062a\u06a9\u06cc\u0647 \u0646\u0645\u06cc \u06a9\u0646\u0646\u062f.<br \/>\u0645\u0627\u0646\u0646\u062f \u0633\u0627\u06cc\u0631 RDBMS \u060c PostgreSQL \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0645\u062a\u0645\u0631\u06a9\u0632 \u0648 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u06a9\u0647 \u062a\u0648\u0633\u0637 \u0686\u0646\u062f\u06cc\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0628\u0631\u062a\u0631\u06cc \u0645\u06cc \u06cc\u0627\u0628\u062f. \u0628\u0627 \u062a\u0648\u0627\u0628\u0639 \u062a\u062e\u0635\u0635\u06cc JSONB \u0648 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u06cc\u0646 \u060c \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0631\u0627 \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u0639\u0627\u062f\u06cc \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f.<br \/>MongoDB \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u0686\u0627\u0628\u06a9\u06cc \u0628\u0647 \u0648\u06cc\u0698\u0647 \u062f\u0631 \u0645\u06cc\u06a9\u0631\u0648\u0633\u0631\u0648\u06cc\u0633 \u0648 \u0637\u0631\u0627\u062d\u06cc \u062f\u0627\u0645\u0646\u0647 \u0645\u062d\u0648\u0631 \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0627\u0633\u062a \u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u062e\u0648\u0628\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0627\u0645\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0627 \u0633\u0631\u0639\u062a \u0628\u0627\u0644\u0627 \u062a\u06a9\u0627\u0645\u0644 \u0645\u06cc \u06cc\u0627\u0628\u062f. \u0645\u062f\u0644 \u0633\u0646\u062f \u0622\u0646 \u0628\u0647 \u062e\u0648\u0628\u06cc \u0628\u0627 \u0627\u0634\u06cc\u0627\u0621 \u062a\u062c\u0627\u0631\u06cc \u0647\u0645\u0627\u0647\u0646\u06af \u0627\u0633\u062a.<\/p>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u060c \u0627\u0646\u062a\u062e\u0627\u0628 \u06cc\u06a9 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0628\u0627\u06cc\u062f \u0628\u0631 \u0627\u0633\u0627\u0633 \u062a\u062e\u0635\u0635 \u062a\u06cc\u0645 \u0634\u0645\u0627 \u060c \u0631\u0627\u062d\u062a\u06cc \u0628\u0627 \u0646\u062d\u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u060c \u0645\u062f\u0644 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u060c \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0648 \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0648 \u0645\u0646\u0627\u0628\u0639 \u0622\u0645\u0648\u0632\u0634\u06cc \u0628\u0627\u0634\u062f. \u0627\u06af\u0631 \u0647\u06cc\u0686 \u062a\u062e\u0635\u0635\u06cc \u0628\u0631\u0627\u06cc \u06a9\u062f\u06af\u0630\u0627\u0631\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f \u060c \u062e\u0648\u0627\u0646\u062f\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u0648 \u0641\u0647\u0631\u0633\u062a \u06a9\u0631\u062f\u0646 \u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f \u060c \u0628\u0647\u062a\u0631\u06cc\u0646 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u0628\u0627\u0631 \u06a9\u0627\u0631\u06cc \u062e\u0627\u0635 \u0627\u0646\u062c\u0627\u0645 \u0646\u0645\u06cc \u0634\u0648\u062f. \u06cc\u06a9 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u06cc\u06af\u0631 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 \u06a9\u0627\u0641\u06cc \u062e\u0648\u0628 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0628\u0627 \u0633\u0627\u0632\u0645\u0627\u0646 \u062a\u0648\u0633\u0639\u0647 \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627\u0634\u062f \u0648 \u062a\u062c\u0631\u0628\u0647 \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u0647 \u0628\u0647\u062a\u0631\u06cc \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u0631\u0627 \u0633\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0647\u0646\u06af\u0627\u0645 \u06a9\u0627\u0631 \u0628\u0627 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0627\u0633\u0646\u0627\u062f \u060c \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0631\u06cc\u0634\u0647 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u0628\u06cc\u0627\u0646 \u0633\u0627\u062f\u0647 \u0641\u0647\u0631\u0633\u062a \u0628\u0646\u062f\u06cc \u06a9\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u062f\u0631 \u0645\u0633\u06cc\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u060c \u06a9\u0647 \u0646\u0645\u0627\u06cc\u0627\u0646\u06af\u0631 \u06cc\u06a9 \u0631\u0627\u0628\u0637\u0647 \u06cc\u06a9 \u0628\u0647 \u06cc\u06a9 \u0627\u0633\u062a \u060c PostgreSQL \u0628\u0647 \u06cc\u06a9 \u0634\u0627\u062e\u0635 GIN &hellip;<\/p>\n","protected":false},"author":2,"featured_media":107003,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fslnvuraxhtytnbzi730f.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-107002","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/107002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=107002"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/107002\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/107003"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=107002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=107002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=107002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}