{"id":105834,"date":"2025-04-13T11:40:53","date_gmt":"2025-04-13T07:10:53","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/"},"modified":"2025-04-13T11:40:53","modified_gmt":"2025-04-13T07:10:53","slug":"%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/","title":{"rendered":"\u062f\u0631\u06a9 \u0627\u062a\u0645\u06cc: \u0627\u0648\u0644\u06cc\u0646 \u0633\u062a\u0648\u0646 \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0627\u0633\u06cc\u062f\u06cc"},"content":{"rendered":"<div data-article-id=\"2403684\" id=\"article-body\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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=\"\u062a\u063a\u06cc\u06cc\u0631 \u0648\u0636\u0639\u06cc\u062a \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628\"><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\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D9%85%D9%82%D8%AF%D9%85%D9%87\" >\u0645\u0642\u062f\u0645\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\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D8%A7%D8%AA%D9%85%DB%8C_%D8%AF%D8%B1_%D8%A8%D8%A7%D9%86%DA%A9%D9%87%D8%A7%DB%8C_%D8%A7%D8%B7%D9%84%D8%A7%D8%B9%D8%A7%D8%AA%DB%8C_%DA%86%DB%8C%D8%B3%D8%AA%D8%9F\" >\u0627\u062a\u0645\u06cc \u062f\u0631 \u0628\u0627\u0646\u06a9\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0686\u06cc\u0633\u062a\u061f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D8%A7%D8%AA%D9%85%DB%8C_%D8%AF%D8%B1_%D8%B9%D9%85%D9%84_%DB%8C%DA%A9_%D8%A8%D8%B3%D8%AA%D8%B1_%D8%AF%D8%B3%D8%AA%D9%88%D8%B1_%D8%A7%D9%84%D8%B9%D9%85%D9%84_%D9%85%D8%B4%D8%AA%D8%B1%DA%A9\" >\u0627\u062a\u0645\u06cc \u062f\u0631 \u0639\u0645\u0644: \u06cc\u06a9 \u0628\u0633\u062a\u0631 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0645\u0634\u062a\u0631\u06a9<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D8%B3%D9%86%D8%A7%D8%B1%DB%8C%D9%88_%D8%A8%D8%B3%D8%AA%D8%B1_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D8%AF%D8%B3%D8%AA%D9%88%D8%B1_%D8%A7%D9%84%D8%B9%D9%85%D9%84_%D9%85%D8%B4%D8%AA%D8%B1%DA%A9\" >\u0633\u0646\u0627\u0631\u06cc\u0648: \u0628\u0633\u062a\u0631 \u0627\u06cc\u062c\u0627\u062f \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0645\u0634\u062a\u0631\u06a9<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D9%85%D8%AB%D8%A7%D9%84_%D9%85%D8%B9%D8%A7%D9%85%D9%84%D9%87_%D8%A7%D8%AA%D9%85%DB%8C\" >\u0645\u062b\u0627\u0644 \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u062a\u0645\u06cc:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D9%85%D8%B4%DA%A9%D9%84_%D8%A8%D8%AF%D9%88%D9%86_%D8%A7%D8%AA%D9%85%DB%8C\" >\u0645\u0634\u06a9\u0644 \u0628\u062f\u0648\u0646 \u0627\u062a\u0645\u06cc:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D9%85%D8%AB%D8%A7%D9%84_SQL_%D8%B9%D9%85%D9%84%DB%8C\" >\u0645\u062b\u0627\u0644 SQL \u0639\u0645\u0644\u06cc<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%DA%86%DA%AF%D9%88%D9%86%D9%87_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%A7%D8%AA%D9%85%DB%8C_%D8%B1%D8%A7_%D8%AA%D8%B6%D9%85%DB%8C%D9%86_%D9%85%DB%8C_%DA%A9%D9%86%D9%86%D8%AF_%D8%B2%DB%8C%D8%B1_%DA%A9%D8%A7%D9%BE%D9%88%D8%AA\" >\u0686\u06af\u0648\u0646\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u062a\u0645\u06cc \u0631\u0627 \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u0646\u062f (\u0632\u06cc\u0631 \u06a9\u0627\u067e\u0648\u062a)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D9%88%D8%B1%D9%88%D8%AF_%D8%A8%D9%87_%D8%B3%DB%8C%D8%B3%D8%AA%D9%85_%D9%BE%DB%8C%D8%B4_%D8%AA%D9%88%D8%B6%DB%8C%D8%AD_%D8%AA%D9%88%D8%B6%DB%8C%D8%AD_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B4%D8%AF%D9%87\" >\u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u067e\u06cc\u0634 \u062a\u0648\u0636\u06cc\u062d \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%D8%B4%D8%A8%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D9%88%D8%A7%D9%84_%D8%AF%D8%B1_GO\" >\u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0648\u0627\u0644 \u062f\u0631 GO<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/%d8%af%d8%b1%da%a9-%d8%a7%d8%aa%d9%85%db%8c-%d8%a7%d9%88%d9%84%db%8c%d9%86-%d8%b3%d8%aa%d9%88%d9%86-%d9%85%d8%b9%d8%a7%d9%85%d9%84%d8%a7%d8%aa-%d8%a7%d8%b3%db%8c%d8%af%db%8c\/#%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%85%D9%82%D8%AF%D9%85%D9%87\"><\/span>\n<p>  \u0645\u0642\u062f\u0645\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06af\u0631 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u064b \u0627\u06cc\u0646 \u0627\u0635\u0637\u0644\u0627\u062d \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f <strong>\u0627\u0633\u06cc\u062f<\/strong>&#8211; \u0645\u062e\u0641\u0641 \u0645\u062e\u0641\u0641 \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647. \u0647\u0631 \u062d\u0631\u0641 \u062f\u0631 \u0627\u0633\u06cc\u062f \u0645\u0639\u0646\u0627\u06cc \u0648 \u0627\u0647\u0645\u06cc\u062a \u0639\u0645\u06cc\u0642\u06cc \u062f\u0627\u0631\u062f: <strong>\u0627\u062a\u0645\u06cc<\/strong>\u0628\u0627 <strong>\u062b\u0628\u0627\u062a<\/strong>\u0628\u0627 <strong>\u0627\u0646\u0632\u0648\u0627<\/strong>\u0648\u062a <strong>\u062f\u0648\u0627\u0645<\/strong>\u0628\u0634\u0631<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u060c \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u0631\u0648\u06cc \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u062a\u0645\u0631\u06a9\u0632 \u06a9\u0646\u06cc\u0645: <strong>\u0627\u062a\u0645\u06cc<\/strong>\u0628\u0634\u0631 \u0634\u0645\u0627 \u0645\u06cc \u0641\u0647\u0645\u06cc\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u0628\u0647 \u0686\u0647 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u060c \u0686\u0631\u0627 \u0627\u0647\u0645\u06cc\u062a \u062f\u0627\u0631\u062f \u0648 \u0686\u06af\u0648\u0646\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u062f\u0627\u062e\u0644 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u0646\u062f. \u0627\u06cc\u0646 \u067e\u0633\u062a \u0634\u0627\u0645\u0644 \u06cc\u06a9 \u0642\u06cc\u0627\u0633 \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u060c \u0627\u062c\u0631\u0627\u06cc SQL \u0648 \u062d\u062a\u06cc \u06cc\u06a9 \u062f\u0633\u062a \u0648 \u067e\u0627 \u0627\u0633\u062a <strong>Go Simulation of Writ-Ahead (WAL)<\/strong>&#8211; \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646\u06cc\u0633\u0645 \u06a9\u0644\u06cc\u062f\u06cc \u0645\u0627\u0646\u0646\u062f <strong>\u067e\u0633 \u0627\u0632<\/strong> \u0628\u0631\u0627\u06cc \u062a\u0636\u0645\u06cc\u0646 \u0627\u062a\u0645\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<blockquote>\n<p>\u0627\u06af\u0631 \u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f \u0628\u0647 \u063a\u0648\u0627\u0635\u06cc \u062f\u0631 \u0628\u0642\u06cc\u0647 \u062e\u0635\u0648\u0635\u06cc\u0627\u062a \u0627\u0633\u06cc\u062f \u0647\u0633\u062a\u06cc\u062f \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u0627\u0648\u0634 \u06a9\u0646\u06cc\u062f:<\/p>\n<\/blockquote>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0639\u0645\u06cc\u0642 \u0634\u0648\u06cc\u0645 \u0628\u0647:<\/p>\n<ol>\n<li>\u0627\u062a\u0645\u06cc \u062f\u0631 \u0628\u0627\u0646\u06a9\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0686\u06cc\u0633\u062a\u061f<\/li>\n<li>\u0627\u062a\u0645\u06cc \u062f\u0631 \u0639\u0645\u0644: \u06cc\u06a9 \u0628\u0633\u062a\u0631 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0645\u0634\u062a\u0631\u06a9<\/li>\n<li>\u0686\u06af\u0648\u0646\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u062a\u0645\u06cc \u0631\u0627 \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u0646\u062f (\u0632\u06cc\u0631 \u06a9\u0627\u067e\u0648\u062a)<\/li>\n<li>\u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u067e\u06cc\u0634 \u062a\u0648\u0636\u06cc\u062d \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647<\/li>\n<li>\u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0648\u0627\u0644 \u062f\u0631 GO<\/li>\n<li>\u067e\u0627\u06cc\u0627\u0646<\/li>\n<\/ol>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%AA%D9%85%DB%8C_%D8%AF%D8%B1_%D8%A8%D8%A7%D9%86%DA%A9%D9%87%D8%A7%DB%8C_%D8%A7%D8%B7%D9%84%D8%A7%D8%B9%D8%A7%D8%AA%DB%8C_%DA%86%DB%8C%D8%B3%D8%AA%D8%9F\"><\/span>\n<p>  \u0627\u062a\u0645\u06cc \u062f\u0631 \u0628\u0627\u0646\u06a9\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0686\u06cc\u0633\u062a\u061f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0647\u062f\u0627\u0641 \u062a\u0638\u0627\u0647\u0631\u0627\u062a \u060c \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0641\u0631\u0636 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u062a\u0646\u0647\u0627 \u0628\u0627 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062c\u0632\u0626\u06cc \u060c \u0647\u0645\u0627\u0646 \u0627\u0635\u0648\u0644 \u0648 \u062a\u06a9\u0646\u06cc\u06a9 \u0647\u0627 \u062a\u0642\u0631\u06cc\u0628\u0627\u064b \u062f\u0631 \u062a\u0645\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0646\u062a\u06cc SQL \u0645\u0627\u0646\u0646\u062f MySQL \u060c Mariadb \u0648 SQL Server \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<\/blockquote>\n<p><strong>\u0627\u062a\u0645\u06cc<\/strong> \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u06af\u0631\u0648\u0647\u06cc \u0627\u0632 \u0639\u0645\u0644\u06cc\u0627\u062a \u062f\u0631 \u06cc\u06a9 \u0645\u0639\u0627\u0645\u0644\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0648\u0627\u062d\u062f \u0648\u0627\u062d\u062f \u0648 \u063a\u06cc\u0631\u0642\u0627\u0628\u0644 \u062a\u0641\u06a9\u06cc\u06a9 \u0631\u0641\u062a\u0627\u0631 \u0645\u06cc \u0634\u0648\u0646\u062f. \u0647\u0631 \u06cc\u06a9 <strong>\u0647\u0645\u0647<\/strong> \u0639\u0645\u0644\u06cc\u0627\u062a \u0645\u0648\u0641\u0642 \u060c \u06cc\u0627 <strong>\u0647\u06cc\u0686 \u06a9\u062f\u0627\u0645<\/strong> \u0627\u0646\u062c\u0627\u0645 \u0647\u06cc\u0686 \u062d\u0627\u0644\u062a \u0646\u06cc\u0645\u0647 \u0631\u0627\u0647 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f.<\/p>\n<p>\u0628\u0647 \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u06cc \u0645\u0627\u0646\u0646\u062f \u0633\u0648\u0626\u06cc\u0686 \u0641\u06a9\u0631 \u06a9\u0646\u06cc\u062f &#8211; \u06cc\u0627 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0627\u0645\u0644 \u062a\u0644\u0646\u06af\u0631 \u0645\u06cc \u0632\u0646\u062f \u06cc\u0627 \u0627\u0635\u0644\u0627\u064b. \u0627\u06cc\u0646 \u0627\u0645\u0631 \u0627\u0632 \u0641\u0633\u0627\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f \u060c \u0628\u0647 \u0648\u06cc\u0698\u0647 \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0686\u0646\u062f\u06cc\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a \u0628\u0647 \u0634\u062f\u062a \u0628\u0627 \u0647\u0645 \u0647\u0645\u0631\u0627\u0647 \u0647\u0633\u062a\u0646\u062f.<\/p>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%AA%D9%85%DB%8C_%D8%AF%D8%B1_%D8%B9%D9%85%D9%84_%DB%8C%DA%A9_%D8%A8%D8%B3%D8%AA%D8%B1_%D8%AF%D8%B3%D8%AA%D9%88%D8%B1_%D8%A7%D9%84%D8%B9%D9%85%D9%84_%D9%85%D8%B4%D8%AA%D8%B1%DA%A9\"><\/span>\n<p>  \u0627\u062a\u0645\u06cc \u062f\u0631 \u0639\u0645\u0644: \u06cc\u06a9 \u0628\u0633\u062a\u0631 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0645\u0634\u062a\u0631\u06a9<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u0632 \u062f\u0627\u0633\u062a\u0627\u0646 \u06a9\u0644\u0627\u0633\u06cc\u06a9 &#8220;\u0627\u0646\u062a\u0642\u0627\u0644 \u0628\u0627\u0646\u06a9\u06cc&#8221; \u067e\u0631\u0634 \u06a9\u0646\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u06cc\u06a9 \u0633\u0646\u0627\u0631\u06cc\u0648\u06cc \u062a\u0627\u0632\u0647 \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f <strong>\u0686\u0631\u0627 \u0627\u062a\u0645\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0627\u0633\u062a<\/strong>:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D9%86%D8%A7%D8%B1%DB%8C%D9%88_%D8%A8%D8%B3%D8%AA%D8%B1_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D8%AF%D8%B3%D8%AA%D9%88%D8%B1_%D8%A7%D9%84%D8%B9%D9%85%D9%84_%D9%85%D8%B4%D8%AA%D8%B1%DA%A9\"><\/span>\n<p>  <strong>\u0633\u0646\u0627\u0631\u06cc\u0648: \u0628\u0633\u062a\u0631 \u0627\u06cc\u062c\u0627\u062f \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0645\u0634\u062a\u0631\u06a9<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0633\u062a\u0631\u06cc \u06a9\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u0645\u0634\u062a\u0631\u06a9 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0647\u0627 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0648 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84_%D9%85%D8%B9%D8%A7%D9%85%D9%84%D9%87_%D8%A7%D8%AA%D9%85%DB%8C\"><\/span>\n<p>  \u0645\u062b\u0627\u0644 \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u062a\u0645\u06cc:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0648\u0642\u062a\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0645\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f\u06cc \u0631\u0627 \u0628\u0647 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0628\u0627\u06cc\u062f \u0633\u0647 \u0645\u0648\u0631\u062f \u0627\u062a\u0641\u0627\u0642 \u0628\u06cc\u0641\u062a\u062f:<\/p>\n<ol>\n<li>\n<p>\u0627\u06cc\u0646 \u0645\u0627\u062f\u0647 \u0628\u0647 \u0644\u06cc\u0633\u062a \u0645\u0648\u0627\u062f \u062a\u0634\u06a9\u06cc\u0644 \u062f\u0647\u0646\u062f\u0647 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<\/li>\n<li>\n<p>\u062c\u062f\u0648\u0644 \u0632\u0645\u0627\u0646\u06cc &#8220;\u0622\u062e\u0631\u06cc\u0646 \u0627\u0635\u0644\u0627\u062d \u0634\u062f\u0647&#8221; \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<\/li>\n<li>\n<p>&#8220;\u0634\u0645\u0627\u0631\u0634 \u0645\u0634\u0627\u0631\u06a9\u062a&#8221; \u0645\u0634\u0627\u0631\u06a9\u062a \u06a9\u0646\u0646\u062f\u0647 \u0627\u0641\u0632\u0627\u06cc\u0634 \u06cc\u0627\u0641\u062a\u0647 \u0627\u0633\u062a.<\/p>\n<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%D8%B4%DA%A9%D9%84_%D8%A8%D8%AF%D9%88%D9%86_%D8%A7%D8%AA%D9%85%DB%8C\"><\/span>\n<p>  \u0645\u0634\u06a9\u0644 \u0628\u062f\u0648\u0646 \u0627\u062a\u0645\u06cc:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<p>\u0627\u06cc\u0646 \u0645\u0627\u062f\u0647 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0627\u0645\u0627 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u062f\u06cc\u06af\u0631 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f.<\/p>\n<\/li>\n<li>\n<p>\u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062a\u0639\u062f\u0627\u062f \u0645\u0634\u0627\u0631\u06a9\u062a \u06a9\u0646\u0646\u062f\u0647 \u060c \u0627\u0645\u0627 \u0627\u06cc\u0646 \u0645\u0627\u062f\u0647 \u0647\u0631\u06af\u0632 \u0630\u062e\u06cc\u0631\u0647 \u0646\u0645\u06cc \u0634\u0648\u062f.<\/p>\n<\/li>\n<li>\n<p>\u06cc\u06a9 \u0642\u0633\u0645\u062a \u0645\u0648\u0641\u0642 \u0645\u06cc \u0634\u0648\u062f \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0628\u062e\u0634 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062e\u0648\u0631\u0646\u062f <strong>\u0646\u0627\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/strong>\u0628\u0634\u0631<\/p>\n<\/li>\n<\/ul>\n<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u0628\u06cc\u0646\u06cc\u062f \u060c \u0628\u062f\u0648\u0646 \u0627\u062a\u0645\u06cc \u060c \u062e\u0637\u0631 \u0648\u0627\u0642\u0639\u06cc \u0646\u0627\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f &#8211; \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0642\u0633\u0645\u062a \u0647\u0627\u06cc \u0645\u0639\u0627\u0645\u0644\u0647 \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0628\u0631\u062e\u06cc \u062f\u06cc\u06af\u0631 \u0646\u06cc\u0633\u062a\u0646\u062f \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f. \u062f\u0631 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u0633\u0627\u062f\u0647 \u060c \u0641\u0642\u0637 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0647 \u0645\u0639\u0646\u0627\u06cc \u06cc\u06a9 \u0645\u0627\u062f\u0647 \u0645\u0641\u0642\u0648\u062f \u0634\u062f\u0647 \u06cc\u0627 \u062a\u0639\u062f\u0627\u062f \u0645\u0634\u0627\u0631\u06a9\u062a \u06a9\u0646\u0646\u062f\u0647 \u0646\u0627\u062f\u0631\u0633\u062a \u0628\u0627\u0634\u062f. \u0627\u0645\u0627 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0645\u0647\u0645-\u0645\u0627\u0646\u0646\u062f \u0628\u0627\u0646\u06a9\u062f\u0627\u0631\u06cc \u060c \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9\u06cc \u06cc\u0627 \u0645\u0631\u0627\u0642\u0628\u062a \u0647\u0627\u06cc \u0628\u0647\u062f\u0627\u0634\u062a\u06cc-\u062d\u062a\u06cc \u0646\u0627\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0647\u0627\u06cc \u06a9\u0648\u0686\u06a9 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u0646\u062c\u0631 \u0628\u0647 \u0639\u0648\u0627\u0642\u0628 \u062c\u062f\u06cc \u0634\u0648\u062f. \u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0627\u0639\u062a\u0645\u0627\u062f \u06a9\u0627\u0631\u0628\u0631 \u0622\u0633\u06cc\u0628 \u0628\u0631\u0633\u0627\u0646\u062f \u060c \u062e\u0637\u0627\u0647\u0627\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0631\u0627 \u062a\u062d\u0631\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0628\u0627\u0639\u062b \u0627\u0632 \u0628\u06cc\u0646 \u0631\u0641\u062a\u0646 \u0645\u0627\u0644\u06cc \u06cc\u0627 \u0634\u0647\u0631\u062a \u0634\u0648\u062f. \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0627\u062a\u0645\u06cc \u0641\u0642\u0637 \u06cc\u06a9 \u0686\u06cc\u0632 \u062e\u0648\u0628 \u0646\u06cc\u0633\u062a-\u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a.<br \/>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u060c \u0686\u06af\u0648\u0646\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0648\u0627\u0642\u0639 \u0627\u062a\u0645\u06cc \u0631\u0627 \u062f\u0631 \u062d\u06cc\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u0646\u062f\u061f \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0627\u062a\u0645\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0639\u0627\u0645\u0644\u0627\u062a SQL \u062f\u0631 \u06cc\u06a9 \u0633\u0646\u0627\u0631\u06cc\u0648\u06cc \u0639\u0645\u0644\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u06a9\u0646\u06cc\u0645.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84_SQL_%D8%B9%D9%85%D9%84%DB%8C\"><\/span>\n<p>  \u0645\u062b\u0627\u0644 SQL \u0639\u0645\u0644\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u062f\u0631 SQL \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f <strong>\u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0627\u062a\u0645\u06cc<\/strong>:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">BEGIN<\/span><span class=\"p\">;<\/span>  <span class=\"c1\">-- Start the transaction<\/span>\n\n<span class=\"c1\">-- Step 1: Check if the recipe exists and lock it<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">recipe_id<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">recipes<\/span> \n<span class=\"k\">WHERE<\/span> <span class=\"n\">recipe_id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span> \n<span class=\"k\">FOR<\/span> <span class=\"k\">UPDATE<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Step 2: Add a new ingredient<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">ingredients<\/span> <span class=\"p\">(<\/span><span class=\"n\">recipe_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">added_by<\/span><span class=\"p\">)<\/span> \n<span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Garlic'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Step 3: Update the recipe's timestamp<\/span>\n<span class=\"k\">UPDATE<\/span> <span class=\"n\">recipes<\/span> \n<span class=\"k\">SET<\/span> <span class=\"n\">last_modified<\/span> <span class=\"o\">=<\/span> <span class=\"n\">NOW<\/span><span class=\"p\">()<\/span> \n<span class=\"k\">WHERE<\/span> <span class=\"n\">recipe_id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Step 4: Increment user's contribution count<\/span>\n<span class=\"k\">UPDATE<\/span> <span class=\"n\">users<\/span> \n<span class=\"k\">SET<\/span> <span class=\"n\">contribution_count<\/span> <span class=\"o\">=<\/span> <span class=\"n\">contribution_count<\/span> <span class=\"o\">+<\/span> <span class=\"mi\">1<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">user_id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">2<\/span><span class=\"p\">;<\/span>\n\n<span class=\"k\">COMMIT<\/span><span class=\"p\">;<\/span>  <span class=\"c1\">-- Commit only if all operations succeed<\/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\u06af\u0631 <strong>\u0647\u0631 \u0642\u062f\u0645 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062e\u0648\u0631\u062f<\/strong>\u060c \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0642\u0628\u0644\u0627\u064b \u0647\u0645\u0647 \u0686\u06cc\u0632 \u0631\u0627 \u0628\u0647 \u062d\u0627\u0644\u062a \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f <code>BEGIN<\/code>\u0628\u0634\u0631<\/p>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%DA%86%DA%AF%D9%88%D9%86%D9%87_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%A7%D8%AA%D9%85%DB%8C_%D8%B1%D8%A7_%D8%AA%D8%B6%D9%85%DB%8C%D9%86_%D9%85%DB%8C_%DA%A9%D9%86%D9%86%D8%AF_%D8%B2%DB%8C%D8%B1_%DA%A9%D8%A7%D9%BE%D9%88%D8%AA\"><\/span>\n<p>  \u0686\u06af\u0648\u0646\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u062a\u0645\u06cc \u0631\u0627 \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u0646\u062f (\u0632\u06cc\u0631 \u06a9\u0627\u067e\u0648\u062a)<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062d\u0627\u0644\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062a\u0639\u062c\u0628 \u06a9\u0646\u06cc\u062f \u060c <strong>\u0686\u06af\u0648\u0646\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u0631\u0641\u062a\u0627\u0631 \u0647\u0645\u0647 \u06cc\u0627 \u0647\u06cc\u0686 \u0686\u06cc\u0632 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f<\/strong>\u060c \u0628\u0647 \u062e\u0635\u0648\u0635 \u0627\u06af\u0631 \u0633\u06cc\u0633\u062a\u0645 \u062f\u0631 \u0628\u06cc\u0646 \u062e\u0631\u0627\u0628 \u0634\u0648\u062f\u061f<\/p>\n<p>\u062c\u0648\u0627\u0628 \u062f\u0631 \u0686\u06cc\u0632\u06cc \u0628\u0647 \u0646\u0627\u0645 a \u0646\u0647\u0641\u062a\u0647 \u0627\u0633\u062a <strong>\u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0646\u0648\u0634\u062a\u0646 (WAL)<\/strong>\u0628\u0634\u0631<\/p>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D9%88%D8%B1%D9%88%D8%AF_%D8%A8%D9%87_%D8%B3%DB%8C%D8%B3%D8%AA%D9%85_%D9%BE%DB%8C%D8%B4_%D8%AA%D9%88%D8%B6%DB%8C%D8%AD_%D8%AA%D9%88%D8%B6%DB%8C%D8%AD_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B4%D8%AF%D9%87\"><\/span>\n<p>  \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u067e\u06cc\u0634 \u062a\u0648\u0636\u06cc\u062d \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 postgresql \u060c <strong>\u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0646\u0648\u0634\u062a\u0646 (WAL)<\/strong> \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0647\u0631 \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f <strong>\u0647\u0645\u0647 \u06cc\u0627 \u0647\u06cc\u0686 \u0686\u06cc\u0632<\/strong>&#8211; \u0647\u0633\u062a\u0647 \u0627\u0635\u0644\u06cc <strong>\u0627\u062a\u0645\u06cc<\/strong>\u0628\u0634\u0631 \u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0631\u06af\u0648\u0646\u0647 \u062a\u063a\u06cc\u06cc\u0631 \u0648\u0627\u0642\u0639\u06cc \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f \u060c \u0627\u0628\u062a\u062f\u0627 <strong>\u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0647 \u06cc\u06a9 \u067e\u0631\u0648\u0646\u062f\u0647 \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u062e\u0627\u0635 \u0645\u06cc \u0646\u0648\u06cc\u0633\u062f<\/strong> (\u0648\u0627\u0644). \u0642\u0628\u0644 \u0627\u0632 \u0627\u0631\u0633\u0627\u0644 \u0622\u0646 \u060c \u0628\u0647 \u0622\u0646 \u0641\u06a9\u0631 \u06a9\u0646\u06cc\u062f \u0645\u0627\u0646\u0646\u062f \u062a\u0647\u06cc\u0647 \u067e\u06cc\u0627\u0645 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627\u06cc \u062e\u0648\u062f &#8211; \u0627\u06af\u0631 \u062a\u0644\u0641\u0646 \u0634\u0645\u0627 \u062e\u0631\u0627\u0628 \u0627\u0633\u062a \u060c \u0647\u0646\u0648\u0632 \u067e\u06cc\u0634 \u0646\u0648\u06cc\u0633 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f.<\/p>\n<p>\u0627\u06af\u0631 \u0633\u06cc\u0633\u062a\u0645 \u062f\u0631 \u0648\u0633\u0637 \u0645\u0639\u0627\u0645\u0644\u0647 \u062e\u0631\u0627\u0628 \u0634\u0648\u062f \u060c PostgreSQL \u0627\u0632 \u0622\u0646 \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u0628\u0641\u0647\u0645\u062f \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0628\u0627 \u062e\u06cc\u0627\u0644 \u0631\u0627\u062d\u062a \u062a\u0645\u0627\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0646\u0628\u0648\u062f. \u0645\u0646 <strong>\u0641\u0642\u0637 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0627\u0645\u0644 \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u06a9\u0646\u062f<\/strong>\u060c \u0648 \u0647\u0631 \u0686\u06cc\u0632 \u062f\u06cc\u06af\u0631\u06cc \u0631\u0627 \u0628\u0647 \u0639\u0642\u0628 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f. \u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 \u060c \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0631\u06af\u0632 \u062f\u0631 \u062d\u0627\u0644\u062a \u0634\u06a9\u0633\u062a\u0647 \u06cc\u0627 \u0646\u06cc\u0645\u0647 \u0628\u0647 \u0631\u0648\u0632 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0646\u0645\u06cc \u0631\u0633\u062f.<\/p>\n<p>\u0648\u0627\u0644 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0644\u0645\u0633 \u0645\u06cc \u06a9\u0646\u062f <strong>\u062f\u0648\u0627\u0645<\/strong>\u060c \u0632\u06cc\u0631\u0627 \u062d\u062a\u06cc \u0627\u06af\u0631 \u0628\u0631\u0642 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0631\u0648\u062f \u060c \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0646\u0648\u0632 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u0631\u0627 \u0645\u0627\u0646\u0646\u062f \u06af\u0630\u0634\u062a\u0647 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B4%D8%A8%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D9%88%D8%A7%D9%84_%D8%AF%D8%B1_GO\"><\/span>\n<p>  \u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0648\u0627\u0644 \u062f\u0631 GO<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight go\"><code><span class=\"k\">package<\/span> <span class=\"n\">main<\/span>\n\n<span class=\"k\">import<\/span> <span class=\"p\">(<\/span>\n    <span class=\"s\">\"bufio\"<\/span>\n    <span class=\"s\">\"fmt\"<\/span>\n    <span class=\"s\">\"os\"<\/span>\n<span class=\"p\">)<\/span>\n\n<span class=\"k\">type<\/span> <span class=\"n\">WriteAheadLog<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\n    <span class=\"n\">logFile<\/span> <span class=\"kt\">string<\/span>\n<span class=\"p\">}<\/span>\n\n<span class=\"k\">func<\/span> <span class=\"n\">NewWriteAheadLog<\/span><span class=\"p\">(<\/span><span class=\"n\">filename<\/span> <span class=\"kt\">string<\/span><span class=\"p\">)<\/span> <span class=\"o\">*<\/span><span class=\"n\">WriteAheadLog<\/span> <span class=\"p\">{<\/span>\n    <span class=\"k\">return<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">WriteAheadLog<\/span><span class=\"p\">{<\/span><span class=\"n\">logFile<\/span><span class=\"o\">:<\/span> <span class=\"n\">filename<\/span><span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">wal<\/span> <span class=\"o\">*<\/span><span class=\"n\">WriteAheadLog<\/span><span class=\"p\">)<\/span> <span class=\"n\">LogWrite<\/span><span class=\"p\">(<\/span><span class=\"n\">transaction<\/span> <span class=\"kt\">string<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\n    <span class=\"n\">file<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">os<\/span><span class=\"o\">.<\/span><span class=\"n\">OpenFile<\/span><span class=\"p\">(<\/span><span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">logFile<\/span><span class=\"p\">,<\/span> <span class=\"n\">os<\/span><span class=\"o\">.<\/span><span class=\"n\">O_APPEND<\/span><span class=\"o\">|<\/span><span class=\"n\">os<\/span><span class=\"o\">.<\/span><span class=\"n\">O_CREATE<\/span><span class=\"o\">|<\/span><span class=\"n\">os<\/span><span class=\"o\">.<\/span><span class=\"n\">O_WRONLY<\/span><span class=\"p\">,<\/span> <span class=\"m\">0644<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">!=<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\n        <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Error writing log:\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span><span class=\"p\">)<\/span>\n        <span class=\"k\">return<\/span>\n    <span class=\"p\">}<\/span>\n    <span class=\"k\">defer<\/span> <span class=\"n\">file<\/span><span class=\"o\">.<\/span><span class=\"n\">Close<\/span><span class=\"p\">()<\/span>\n\n    <span class=\"n\">_<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span> <span class=\"o\">=<\/span> <span class=\"n\">file<\/span><span class=\"o\">.<\/span><span class=\"n\">WriteString<\/span><span class=\"p\">(<\/span><span class=\"n\">transaction<\/span> <span class=\"o\">+<\/span> <span class=\"s\">\"<\/span><span class=\"se\">\\n<\/span><span class=\"s\">\"<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">==<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\n        <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Logged:\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">transaction<\/span><span class=\"p\">)<\/span>\n    <span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">wal<\/span> <span class=\"o\">*<\/span><span class=\"n\">WriteAheadLog<\/span><span class=\"p\">)<\/span> <span class=\"n\">LogRecover<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\n    <span class=\"n\">file<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">os<\/span><span class=\"o\">.<\/span><span class=\"n\">Open<\/span><span class=\"p\">(<\/span><span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">logFile<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">!=<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\n        <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Error reading log:\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span><span class=\"p\">)<\/span>\n        <span class=\"k\">return<\/span>\n    <span class=\"p\">}<\/span>\n    <span class=\"k\">defer<\/span> <span class=\"n\">file<\/span><span class=\"o\">.<\/span><span class=\"n\">Close<\/span><span class=\"p\">()<\/span>\n\n    <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Recovering transactions...\"<\/span><span class=\"p\">)<\/span>\n    <span class=\"n\">scanner<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">bufio<\/span><span class=\"o\">.<\/span><span class=\"n\">NewScanner<\/span><span class=\"p\">(<\/span><span class=\"n\">file<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">for<\/span> <span class=\"n\">scanner<\/span><span class=\"o\">.<\/span><span class=\"n\">Scan<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\n        <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Recovered:\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">scanner<\/span><span class=\"o\">.<\/span><span class=\"n\">Text<\/span><span class=\"p\">())<\/span>\n    <span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">wal<\/span> <span class=\"o\">*<\/span><span class=\"n\">WriteAheadLog<\/span><span class=\"p\">)<\/span> <span class=\"n\">Commit<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\n    <span class=\"n\">err<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">os<\/span><span class=\"o\">.<\/span><span class=\"n\">WriteFile<\/span><span class=\"p\">(<\/span><span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">logFile<\/span><span class=\"p\">,<\/span> <span class=\"p\">[]<\/span><span class=\"kt\">byte<\/span><span class=\"p\">{},<\/span> <span class=\"m\">0644<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">if<\/span> <span class=\"n\">err<\/span> <span class=\"o\">!=<\/span> <span class=\"no\">nil<\/span> <span class=\"p\">{<\/span>\n        <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Error committing log:\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span><span class=\"p\">)<\/span>\n    <span class=\"p\">}<\/span> <span class=\"k\">else<\/span> <span class=\"p\">{<\/span>\n        <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Committed transactions.\"<\/span><span class=\"p\">)<\/span>\n    <span class=\"p\">}<\/span>\n<span class=\"p\">}<\/span>\n\n<span class=\"k\">func<\/span> <span class=\"n\">main<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\n    <span class=\"n\">wal<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">NewWriteAheadLog<\/span><span class=\"p\">(<\/span><span class=\"s\">\"wal_log.txt\"<\/span><span class=\"p\">)<\/span>\n\n    <span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">LogWrite<\/span><span class=\"p\">(<\/span><span class=\"s\">\"INSERT INTO users VALUES(1, 'Alice')\"<\/span><span class=\"p\">)<\/span>\n    <span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">LogWrite<\/span><span class=\"p\">(<\/span><span class=\"s\">\"UPDATE users SET name=\"Bob\" WHERE id = 1\"<\/span><span class=\"p\">)<\/span>\n\n    <span class=\"n\">fmt<\/span><span class=\"o\">.<\/span><span class=\"n\">Println<\/span><span class=\"p\">(<\/span><span class=\"s\">\"<\/span><span class=\"se\">\\n<\/span><span class=\"s\">Simulating system restart...<\/span><span class=\"se\">\\n<\/span><span class=\"s\">\"<\/span><span class=\"p\">)<\/span>\n    <span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">LogRecover<\/span><span class=\"p\">()<\/span>\n\n    <span class=\"n\">wal<\/span><span class=\"o\">.<\/span><span class=\"n\">Commit<\/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<hr\/>\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><strong>\u0627\u062a\u0645\u06cc<\/strong> \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a \u062f\u0627\u062f\u0647 \u0634\u0645\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0631 \u062d\u0627\u0644\u062a \u0634\u06a9\u0633\u062a\u0647 \u06cc\u0627 \u0645\u062a\u0646\u0627\u0642\u0636 \u0642\u0631\u0627\u0631 \u0646\u062f\u0647\u062f. \u0627\u06cc\u0646 \u06a9\u0647 \u0622\u06cc\u0627 \u0634\u0645\u0627 \u062f\u0631 \u062d\u0627\u0644 \u0633\u0627\u062e\u062a\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u062c\u062a\u0645\u0627\u0639\u06cc \u060c \u06cc\u06a9 \u0628\u0633\u062a\u0631 \u062f\u0633\u062a\u0648\u0631 \u0627\u0644\u0639\u0645\u0644 \u06cc\u0627 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u0627\u0644\u06cc &#8211; \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0627\u062a\u0645\u06cc \u0647\u0633\u062a\u06cc\u062f <strong>\u0627\u0639\u062a\u0645\u0627\u062f \u0648 \u06cc\u06a9\u067e\u0627\u0631\u0686\u06af\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062d\u0641\u0638 \u06a9\u0646\u06cc\u062f<\/strong>\u0628\u0634\u0631<\/p>\n<p>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062f\u0631\u0646 \u060c \u0628\u0647 \u0648\u06cc\u0698\u0647 postgreSQL \u060c \u0627\u0632 \u0645\u06a9\u0627\u0646\u06cc\u0633\u0645 \u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>\u0648\u0644\u06af\u0631\u062f<\/strong> \u0628\u0631\u0627\u06cc \u062a\u0636\u0645\u06cc\u0646 \u0627\u062a\u0645\u06cc \u062d\u062a\u06cc \u062f\u0631 \u0645\u0648\u0627\u062c\u0647\u0647 \u0628\u0627 \u062a\u0635\u0627\u062f\u0641\u0627\u062a \u063a\u06cc\u0631 \u0645\u0646\u062a\u0638\u0631\u0647. \u0628\u0627 \u062f\u0631\u06a9 \u0627\u06cc\u0646 \u062f\u0627\u062e\u0644\u06cc \u0647\u0627 \u060c \u0634\u0645\u0627 \u0628\u0631\u0627\u06cc \u0637\u0631\u0627\u062d\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u0648 \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631 \u0645\u062c\u0647\u0632 \u0645\u06cc \u0634\u0648\u06cc\u062f.<\/p>\n<p>\u062f\u0631 \u0645\u0642\u0627\u0644\u0627\u062a \u0628\u0639\u062f\u06cc \u060c \u0645\u0627 \u0628\u0647 \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u0628\u0627\u0642\u06cc\u0645\u0627\u0646\u062f\u0647 \u0627\u0633\u06cc\u062f \u0634\u06cc\u0631\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u0645 &#8211;<strong>\u062b\u0628\u0627\u062a \u060c \u0627\u0646\u0632\u0648\u0627 \u0648 \u062f\u0648\u0627\u0645<\/strong>&#8211; \u0647\u0631\u0686\u0647 \u0628\u0647 \u062e\u0648\u062f\u06cc \u062e\u0648\u062f \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0628\u0627\u0634\u062f.<\/p>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u067e\u0627\u06cc\u0627\u0646 \u0627\u06cc\u0646 \u067e\u0633\u062a \u060c \u0645\u06cc \u062e\u0648\u0627\u0647\u0645 \u0644\u062d\u0638\u0647 \u0627\u06cc \u0628\u0631\u0627\u06cc \u0627\u0628\u0631\u0627\u0632 \u0639\u0634\u0642 \u0639\u0645\u06cc\u0642 \u0648 \u062d\u0645\u0627\u06cc\u062a \u0628\u06cc \u0628\u062f\u06cc\u0644 \u062e\u0648\u062f \u0627\u0632 \u0628\u0631\u0627\u062f\u0631\u0627\u0646 \u0648 \u062e\u0648\u0627\u0647\u0631\u0627\u0646 \u0645\u0633\u0644\u0645\u0627\u0646 \u0641\u0644\u0633\u0637\u06cc\u0646\u06cc \u062e\u0648\u062f \u0628\u06af\u0630\u0627\u0631\u0645. \u0632\u0646\u062f\u06af\u06cc \u0622\u0646\u0647\u0627 \u060c \u0645\u0628\u0627\u0631\u0632\u0627\u062a \u0622\u0646\u0647\u0627 \u0648 \u0635\u062f\u0627\u06cc \u0622\u0646\u0647\u0627 \u0627\u0647\u0645\u06cc\u062a \u062f\u0627\u0631\u062f. \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc\u06cc \u06a9\u0647 \u063a\u0627\u0644\u0628\u0627\u064b \u0686\u0634\u0645 \u06a9\u0648\u0631 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0635\u062d\u0628\u062a \u06a9\u0631\u062f\u0646 \u0648 \u0627\u06cc\u0633\u062a\u0627\u062f\u0646 \u0628\u0627 \u0645\u0638\u0644\u0648\u0645 \u0628\u067e\u0631\u062f\u0627\u0632\u06cc\u0645. \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0639\u062f\u0627\u0644\u062a \u0627\u0641\u0632\u0627\u06cc\u0634 \u06cc\u0627\u0628\u062f \u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0635\u0644\u062d \u067e\u06cc\u0631\u0648\u0632 \u0634\u0648\u062f \u060c \u0648 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u0631\u062f\u0645 \u0641\u0644\u0633\u0637\u06cc\u0646 \u0628\u0627 \u0639\u0632\u062a \u060c \u0622\u0632\u0627\u062f\u06cc \u0648 \u0627\u0645\u06cc\u062f \u0632\u0646\u062f\u06af\u06cc \u06a9\u0646\u0646\u062f. \u0634\u0645\u0627 \u0641\u0631\u0627\u0645\u0648\u0634 \u0646\u0645\u06cc \u0634\u0648\u06cc\u062f &#8211;<strong>\u0632\u0646\u062f\u06af\u06cc \u0634\u0645\u0627 \u0645\u0647\u0645 \u0627\u0633\u062a<\/strong>\u0627\u0641\u0632\u0627\u06cc\u0634 \u0627\u062e\u06cc\u0631 \u0641\u0639\u0627\u0644\u06cc\u062a \u0647\u0627\u06cc \u062a\u0631\u0648\u0631\u06cc\u0633\u062a\u06cc \u0648 \u0627\u0642\u062f\u0627\u0645\u0627\u062a \u0648\u062d\u0634\u06cc\u0627\u0646\u0647 \u0627\u0633\u0631\u0627\u0626\u06cc\u0644 \u0628\u0647 \u0637\u0648\u0631 \u0648\u0627\u0636\u062d \u0645\u062d\u06a9\u0648\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u0642\u062f\u0645\u0647 \u0627\u06af\u0631 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u064b \u0627\u06cc\u0646 \u0627\u0635\u0637\u0644\u0627\u062d \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u0627\u0633\u06cc\u062f&#8211; \u0645\u062e\u0641\u0641 \u0645\u062e\u0641\u0641 \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0642\u0627\u0628\u0644 \u0627\u0639\u062a\u0645\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647. \u0647\u0631 \u062d\u0631\u0641 \u062f\u0631 \u0627\u0633\u06cc\u062f \u0645\u0639\u0646\u0627\u06cc \u0648 \u0627\u0647\u0645\u06cc\u062a \u0639\u0645\u06cc\u0642\u06cc \u062f\u0627\u0631\u062f: \u0627\u062a\u0645\u06cc\u0628\u0627 \u062b\u0628\u0627\u062a\u0628\u0627 \u0627\u0646\u0632\u0648\u0627\u0648\u062a \u062f\u0648\u0627\u0645\u0628\u0634\u0631 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u060c \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u0631\u0648\u06cc \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u062a\u0645\u0631\u06a9\u0632 \u06a9\u0646\u06cc\u0645: \u0627\u062a\u0645\u06cc\u0628\u0634\u0631 \u0634\u0645\u0627 \u0645\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":105835,"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%2Fbs2ow85nxx0qj5dpe9ix.jpeg","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-105834","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\/105834","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=105834"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/105834\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/105835"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=105834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=105834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=105834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}