{"id":15443,"date":"2023-04-02T15:40:55","date_gmt":"2023-04-02T12:10:55","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/database-architecture-history-over-state-3m8o\/"},"modified":"2023-04-02T15:40:55","modified_gmt":"2023-04-02T12:10:55","slug":"database-architecture-history-over-state-3m8o","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/database-architecture-history-over-state-3m8o\/","title":{"rendered":"\ud83c\udffa\u0645\u0639\u0645\u0627\u0631\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 &#8211; \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0628\u0631 \u0627\u06cc\u0627\u0644\u062a"},"content":{"rendered":"<div data-article-id=\"1405874\" id=\"article-body\">\n<p>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f\u061f  \u062f\u0648 \u0631\u0648\u0634 \u06a9\u0644\u06cc \u0628\u0631\u0627\u06cc \u062a\u0641\u06a9\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n<ol>\n<li>\u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u062d\u0627\u0644\u062a \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f<\/li>\n<li>\u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f<\/li>\n<\/ol>\n<p>\u0645\u0647\u0646\u062f\u0633\u0627\u0646 \u062a\u0645\u0627\u06cc\u0644 \u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0630\u062e\u06cc\u0631\u0647\u200c\u06a9\u0646\u0646\u062f\u0647 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u0646\u062f <strong>\u062d\u0627\u0644\u062a<\/strong>.  \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0648\u0627\u0636\u062d \u062a\u0631 \u0627\u0633\u062a \u0648 \u06a9\u0645\u06cc \u0633\u0627\u062f\u0647 \u062a\u0631 \u0627\u0633\u062a.<\/p>\n<p>\u0627\u0645\u0627 \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f \u06a9\u0647 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0630\u062e\u06cc\u0631\u0647 \u0627\u0632 <em>\u062a\u0627\u0631\u06cc\u062e<\/em> \u062f\u0631 \u0639\u0648\u0636 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u0631\u0627 \u0628\u0633\u06cc\u0627\u0631 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u062a\u0631 \u0648 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u062a\u0631 \u06a9\u0646\u062f.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0646\u06af\u0627\u0647\u06cc \u0628\u06cc\u0646\u062f\u0627\u0632\u06cc\u0645 &#8230;<\/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\/database-architecture-history-over-state-3m8o\/#%D8%AA%D9%81%D8%A7%D9%88%D8%AA_%D8%AF%D8%B1_%DA%86%DB%8C%D8%B3%D8%AA%D8%9F\" >\u062a\u0641\u0627\u0648\u062a \u062f\u0631 \u0686\u06cc\u0633\u062a\u061f<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/database-architecture-history-over-state-3m8o\/#%D8%A7%DA%AF%D8%B1_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B1%D8%A7_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%DB%8C%DA%A9_%D9%81%D8%B1%D9%88%D8%B4%DA%AF%D8%A7%D9%87_%D8%AF%D9%88%D9%84%D8%AA%DB%8C_%D8%AF%D8%B1_%D9%86%D8%B8%D8%B1_%D8%A8%DA%AF%DB%8C%D8%B1%DB%8C%D8%AF\" >\u0627\u06af\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0648\u0644\u062a\u06cc \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/database-architecture-history-over-state-3m8o\/#%D8%A7%DA%AF%D8%B1_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B1%D8%A7_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%DB%8C%DA%A9_%D9%81%D8%B1%D9%88%D8%B4%DA%AF%D8%A7%D9%87_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D8%AF%D8%B1_%D9%86%D8%B8%D8%B1_%D8%A8%DA%AF%DB%8C%D8%B1%DB%8C%D8%AF\" >\u0627\u06af\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/database-architecture-history-over-state-3m8o\/#%D8%A7%D8%B4%DA%A9%D8%A7%D9%84%D8%A7%D8%AA_%D9%88_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D8%AC%D8%AF%DB%8C%D8%AF_%D8%AF%D8%B1_%D8%B1%D8%A7%D9%87_%D8%A7%D8%B3%D8%AA\" >\u0627\u0634\u06a9\u0627\u0644\u0627\u062a \u0648 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 \u0631\u0627\u0647 \u0627\u0633\u062a<\/a><\/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\/database-architecture-history-over-state-3m8o\/#%DA%A9%D8%A7%D8%B1%D8%A7%DB%8C%DB%8C\" >\u06a9\u0627\u0631\u0627\u06cc\u06cc<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/database-architecture-history-over-state-3m8o\/#%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D9%85%D8%A7%D8%AF%DB%8C_%D8%B4%D8%AF%D9%87\" >\u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647<\/a><\/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\/database-architecture-history-over-state-3m8o\/#%D9%86%DA%AF%D9%87%D8%AF%D8%A7%D8%B1%DB%8C_%D8%A7%D8%B2_%D9%86%D9%85%D8%A7%DB%8C_%D8%A7%D9%81%D8%B2%D8%A7%DB%8C%D8%B4%DB%8C_IVM\" >\u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0627\u0632 \u0646\u0645\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634\u06cc (IVM)<\/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\/database-architecture-history-over-state-3m8o\/#%D9%86%D8%AA%DB%8C%D8%AC%D9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AA%D9%81%D8%A7%D9%88%D8%AA_%D8%AF%D8%B1_%DA%86%DB%8C%D8%B3%D8%AA%D8%9F\"><\/span>\n<p>  \u062a\u0641\u0627\u0648\u062a \u062f\u0631 \u0686\u06cc\u0633\u062a\u061f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0648\u0627\u0646\u0645\u0648\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u06cc\u06a9 \u0628\u0627\u0632\u06cc \u0648\u0628 \u0633\u0627\u062f\u0647 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u062e\u0648\u062f \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u0645.  \u0647\u0631 \u0645\u0633\u0627\u0628\u0642\u0647 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0628\u0627\u0632\u06cc\u06a9\u0646 \u062f\u0627\u0631\u062f \u0648 \u0647\u0631 \u0628\u0627\u0632\u06cc\u06a9\u0646 \u0635\u0641\u0631 \u06cc\u0627 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0645\u062a\u06cc\u0627\u0632 \u06a9\u0633\u0628 \u0645\u06cc \u06a9\u0646\u062f.  \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0631\u062a\u0628\u0647\u200c\u0628\u0646\u062f\u06cc \u0628\u0627\u0632\u06cc\u06a9\u0646\u0627\u0646 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062a\u0639\u062f\u0627\u062f \u0627\u0645\u062a\u06cc\u0627\u0632\u06cc \u06a9\u0647 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0633\u0628 \u06a9\u0631\u062f\u0647\u200c\u0627\u0646\u062f \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u0645:<\/p>\n<div class=\"table-wrapper-paragraph\">\n<table>\n<thead>\n<tr>\n<th>\u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc<\/th>\n<th>\u0646\u06a9\u062a\u0647 \u0647\u0627<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u062c\u0627\u0646<\/td>\n<td>150<\/td>\n<\/tr>\n<tr>\n<td>\u0627\u06af\u0631<\/td>\n<td>125<\/td>\n<\/tr>\n<tr>\n<td>\u0627\u0645\u06cc\u0631<\/td>\n<td>98<\/td>\n<\/tr>\n<tr>\n<td>\u062c\u06cc\u0646<\/td>\n<td>50<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A7%DA%AF%D8%B1_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B1%D8%A7_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%DB%8C%DA%A9_%D9%81%D8%B1%D9%88%D8%B4%DA%AF%D8%A7%D9%87_%D8%AF%D9%88%D9%84%D8%AA%DB%8C_%D8%AF%D8%B1_%D9%86%D8%B8%D8%B1_%D8%A8%DA%AF%DB%8C%D8%B1%DB%8C%D8%AF\"><\/span>\n<p>  \u0627\u06af\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0648\u0644\u062a\u06cc \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u0647\u0646\u062f\u0633 \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062d\u0627\u0644\u062a \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f\u060c \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0648\u0636\u0639\u06cc\u062a \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0645\u06cc \u0633\u0627\u0632\u062f:<\/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\">leaderboard<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">username<\/span> <span class=\"nb\">VARCHAR<\/span> <span class=\"k\">UNIQUE<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">points<\/span> <span class=\"nb\">INTEGER<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span>\n<span class=\"p\">);<\/span>\n\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">points_idx<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">leaderboard<\/span> <span class=\"p\">(<\/span><span class=\"n\">points<\/span> <span class=\"k\">DESC<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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>\u0622\u0646\u0647\u0627 \u0647\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0647 \u0628\u0627\u0632\u06cc\u06a9\u0646\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632 \u06a9\u0633\u0628 \u06a9\u0646\u062f \u0634\u0631\u0648\u0639 \u0628\u0647 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644 \u062c\u062f\u06cc\u062f \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0627\u062f\u0647 \u0631\u0648\u06cc \u0622\u0646 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u0646\u062f \u062a\u0627 20 \u0628\u0627\u0632\u06cc\u06a9\u0646 \u0628\u0631\u062a\u0631 \u0631\u0627 \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">leaderboard<\/span>\n<span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">points<\/span> <span class=\"k\">DESC<\/span>\n<span class=\"k\">LIMIT<\/span> <span class=\"mi\">20<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<h3><span class=\"ez-toc-section\" id=\"%D8%A7%DA%AF%D8%B1_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B1%D8%A7_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%DB%8C%DA%A9_%D9%81%D8%B1%D9%88%D8%B4%DA%AF%D8%A7%D9%87_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D8%AF%D8%B1_%D9%86%D8%B8%D8%B1_%D8%A8%DA%AF%DB%8C%D8%B1%DB%8C%D8%AF\"><\/span>\n<p>  \u0627\u06af\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u0647\u0646\u062f\u0633\u064a \u0643\u0647 \u0628\u0627 \u067e\u0627\u064a\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u064a\u0643 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u064a\u062e\u064a \u0628\u0631\u062e\u0648\u0631\u062f \u0645\u064a\u200c\u0643\u0646\u062f\u060c \u0628\u0647 \u0627\u064a\u0646 \u0645\u0648\u0636\u0648\u0639 \u0628\u0633\u064a\u0627\u0631 \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0631\u062e\u0648\u0631\u062f \u0645\u064a\u200c\u0643\u0646\u062f.  \u0622\u0646\u0647\u0627 \u0648\u0636\u0639\u06cc\u062a \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0646\u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0628\u0644\u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0645\u0633\u0627\u0628\u0642\u0647 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0622\u0646\u0647\u0627 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0645\u0627\u0646\u0646\u062f \u0632\u06cc\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0646\u062f:<\/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=\"nv\">\"match\"<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">match_id<\/span> <span class=\"nb\">INTEGER<\/span> <span class=\"k\">UNIQUE<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">start_time<\/span> <span class=\"nb\">TIMESTAMP<\/span> <span class=\"k\">WITHOUT<\/span> <span class=\"nb\">TIME<\/span> <span class=\"k\">ZONE<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">end_time<\/span> <span class=\"nb\">TIMESTAMP<\/span> <span class=\"k\">WITHOUT<\/span> <span class=\"nb\">TIME<\/span> <span class=\"k\">ZONE<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">map_name<\/span> <span class=\"nb\">VARCHAR<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">game_mode<\/span> <span class=\"nb\">VARCHAR<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span>\n<span class=\"p\">);<\/span>\n\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">match_player<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">match_id<\/span> <span class=\"nb\">INTEGER<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">username<\/span> <span class=\"nb\">VARCHAR<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">points<\/span> <span class=\"nb\">INTEGER<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">FOREIGN<\/span> <span class=\"k\">KEY<\/span> <span class=\"p\">(<\/span><span class=\"n\">match_id<\/span><span class=\"p\">)<\/span> <span class=\"k\">REFERENCES<\/span> <span class=\"nv\">\"match\"<\/span> <span class=\"p\">(<\/span><span class=\"n\">match_id<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u0645\u0633\u0627\u0628\u0642\u0647 \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f\u060c \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637\u0647 \u062f\u0631 \u0622\u0646 \u062f\u0631\u062c \u0645\u06cc \u0634\u0648\u062f <code>match<\/code> \u0648 <code>match_player<\/code> \u062c\u062f\u0627\u0648\u0644  \u0627\u06a9\u0646\u0648\u0646\u060c \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a\u060c \u0645\u0647\u0646\u062f\u0633 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u062a\u0645\u0627\u0645 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0645\u0633\u0627\u0628\u0642\u0627\u062a \u0631\u0627 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u0648\u06cc\u0627 \u06cc\u06a9 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">username<\/span><span class=\"p\">,<\/span> <span class=\"k\">SUM<\/span><span class=\"p\">(<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">match_player<\/span>\n<span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">username<\/span>\n<span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"k\">SUM<\/span><span class=\"p\">(<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span> <span class=\"k\">DESC<\/span>\n<span class=\"k\">LIMIT<\/span> <span class=\"mi\">20<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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 \u0645\u0647\u0646\u062f\u0633 \u0628\u0647 \u062c\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0641\u06a9\u0631 \u06a9\u0646\u062f &#8220;\u0645\u0646 \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u0645&#8221;\u060c \u0641\u06a9\u0631 \u0645\u06cc \u06a9\u0646\u062f &#8220;\u0645\u0646 \u0628\u0627\u06cc\u062f \u062a\u0627 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0641\u06cc\u062f \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u0645. \u0627\u0648\u0647 \u0648 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u06a9\u0646\u0627\u0631\u060c \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627\u06cc\u062f \u062d\u062f\u0627\u0642\u0644 \u06a9\u0627\u0641\u06cc \u0628\u0627\u0634\u0646\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a&#8221;.<\/p>\n<p>\u0634\u0627\u06cc\u062f \u0645\u062a\u0648\u062c\u0647 \u0634\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u06a9\u0648\u0626\u0631\u06cc \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0622\u0646\u0647\u0627 \u062d\u062a\u06cc \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0645\u06cc \u06a9\u0646\u062f <code>match<\/code> \u062c\u062f\u0648\u0644 (\u0641\u0642\u0637 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>match_player<\/code>).  \u0628\u0627 \u0648\u062c\u0648\u062f \u0639\u062f\u0645 \u0646\u06cc\u0627\u0632 <code>game_mode<\/code> \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u06cc\u06af\u0631 \u062f\u0631 \u0622\u0646\u062c\u0627 \u0628\u0644\u0627\u0641\u0627\u0635\u0644\u0647\u060c \u0627\u06cc\u0646 \u0645\u0647\u0646\u062f\u0633 \u062a\u0635\u0645\u06cc\u0645 \u06af\u0631\u0641\u062a \u06a9\u0647 \u0628\u062e\u0634 \u0645\u0647\u0645\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0633\u062a\u060c \u0648 \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0628\u0627\u06cc\u062f \u0630\u062e\u06cc\u0631\u0647 \u0634\u0648\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0645\u06cc \u0622\u0633\u0627\u0646 \u062a\u0631 \u0634\u0648\u062f\u060c \u0627\u06cc\u0646 \u0645\u0647\u0646\u062f\u0633 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062a\u0635\u0645\u06cc\u0645 \u0628\u06af\u06cc\u0631\u062f \u06a9\u0647 \u06cc\u06a9 <code>leaderboard<\/code> view\u060c \u06a9\u0647 \u062f\u0631 \u0627\u0635\u0644 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u0627\u0646\u0646\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0634\u0648\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">VIEW<\/span> <span class=\"n\">leaderboard<\/span> <span class=\"k\">AS<\/span> <span class=\"p\">(<\/span>\n  <span class=\"k\">SELECT<\/span> <span class=\"n\">username<\/span><span class=\"p\">,<\/span> <span class=\"k\">SUM<\/span><span class=\"p\">(<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span>\n  <span class=\"k\">FROM<\/span> <span class=\"n\">match_player<\/span>\n  <span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">username<\/span>\n  <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"k\">SUM<\/span><span class=\"p\">(<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span> <span class=\"k\">DESC<\/span>\n  <span class=\"k\">LIMIT<\/span> <span class=\"mi\">20<\/span>\n<span class=\"p\">);<\/span>\n\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">leaderboard<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B4%DA%A9%D8%A7%D9%84%D8%A7%D8%AA_%D9%88_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D8%AC%D8%AF%DB%8C%D8%AF_%D8%AF%D8%B1_%D8%B1%D8%A7%D9%87_%D8%A7%D8%B3%D8%AA\"><\/span>\n<p>  \u0627\u0634\u06a9\u0627\u0644\u0627\u062a \u0648 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 \u0631\u0627\u0647 \u0627\u0633\u062a<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>\u062d\u0634\u0631\u0647 &#8211;<\/strong> \u06cc\u06a9 \u0631\u0648\u0632 \u0645\u062a\u0648\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u062f \u06a9\u0647 \u06cc\u06a9 \u0628\u0627\u06af \u062f\u0631 \u0628\u0627\u0632\u06cc \u0634\u0645\u0627 \u0645\u0648\u0631\u062f \u0633\u0648\u0621 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f \u0648 \u0628\u0631\u062e\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u062a\u0648\u0627\u0646\u0633\u062a\u0647 \u0627\u0646\u062f \u0627\u0645\u062a\u06cc\u0627\u0632\u0647\u0627\u06cc \u0646\u0627\u0639\u0627\u062f\u0644\u0627\u0646\u0647 \u0627\u06cc \u06a9\u0633\u0628 \u06a9\u0646\u0646\u062f.  \u0634\u0645\u0627 \u0628\u0647 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 git \u062e\u0648\u062f \u0646\u06af\u0627\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0648 \u062a\u0634\u062e\u06cc\u0635 \u0645\u06cc\u200c\u062f\u0647\u06cc\u062f \u06a9\u0647 \u0627\u0634\u06a9\u0627\u0644 \u062f\u0631 4 \u0622\u0648\u0631\u06cc\u0644 \u0645\u0639\u0631\u0641\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a. \u0634\u0645\u0627 \u0628\u0647 \u0639\u0642\u0628 \u062f\u0631 \u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0646\u06af\u0627\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0648 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0634\u0646\u0627\u0633\u0647\u200c\u0647\u0627\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u0631\u0627 \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u0637\u0645\u0626\u0646\u0627\u064b \u0627\u0632 \u0628\u0627\u06af \u0645\u0648\u0631\u062f \u0633\u0648\u0621 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0627\u0633\u062a\u060c \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0627\u06af\u0631 \u06a9\u0633\u06cc \u062a\u0648\u0627\u0646\u0633\u062a\u0647 \u0627\u0633\u062a \u0628\u06cc\u0634 \u0627\u0632 50 \u0627\u0645\u062a\u06cc\u0627\u0632 \u06a9\u0633\u0628 \u06a9\u0646\u062f. \u0622\u0646\u0647\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u06cc\u06a9 \u0645\u0633\u0627\u0628\u0642\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u0646\u062f.<\/p>\n<p>\u0686\u0647 \u06a9\u0627\u0631 \u0645\u06cc\u06a9\u0646\u06cc\u061f  \u0627\u06af\u0631 \u0634\u0645\u0627 \u0641\u0642\u0637 \u06cc\u06a9 Stateful \u062f\u0627\u0631\u06cc\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644\u060c \u0648\u0636\u0639\u06cc\u062a \u0633\u062e\u062a \u062a\u0631 \u0627\u0633\u062a.  \u0628\u0647 \u0646\u0648\u0639\u06cc \u0628\u0627\u06cc\u062f \u062a\u0644\u0627\u0634 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f \u06a9\u062f\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0632 \u0627\u06cc\u0646 \u0628\u0627\u06af \u0633\u0648\u0621 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647 \u0627\u0646\u062f.  \u0628\u0639\u062f \u0686\u06cc\u061f  \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0627\u0645\u0644 \u0627\u0632 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f\u061f  \u0628\u0631\u062e\u06cc \u0627\u0632 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0622\u0646\u0647\u0627 \u0631\u0627 \u06a9\u0633\u0631 \u06a9\u0646\u0645\u061f  \u0686\u0646\u062f \u062a\u0627\u061f<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0645\u0647\u0646\u062f\u0633 \u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0645\u0633\u0627\u0628\u0642\u0627\u062a \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a\u060c \u0648\u0636\u0639\u06cc\u062a \u0622\u0633\u0627\u0646 \u062a\u0631 \u0627\u0633\u062a.  \u0622\u0646\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0645\u0633\u0627\u0628\u0642\u0627\u062a \u0628\u0627\u06af \u0634\u062f\u0647 \u0648 \u0647\u0631 \u0627\u062a\u0641\u0627\u0642\u06cc \u06a9\u0647 \u067e\u0633 \u0627\u0632 \u06f4 \u0622\u0648\u0631\u06cc\u0644 \u0631\u062e \u062f\u0627\u062f\u0647 \u0627\u0633\u062a \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u0646\u062f \u0648 \u0628\u0627\u0632\u06cc\u06a9\u0646\u06cc \u0628\u06cc\u0634 \u0627\u0632 \u06f5\u06f0 \u0627\u0645\u062a\u06cc\u0627\u0632 \u06a9\u0633\u0628 \u06a9\u0646\u062f.  \u0645\u0634\u06a9\u0644 \u062d\u0644 \u0634\u062f.<\/p>\n<p><strong>\u0648\u06cc\u0698\u06af\u06cc \u062c\u062f\u06cc\u062f &#8211;<\/strong> \u06cc\u06a9 \u0631\u0648\u0632 \u062a\u0635\u0645\u06cc\u0645 \u0645\u06cc \u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0627\u0628\u0644\u0648\u0647\u0627\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0645\u0627\u0647\u0627\u0646\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.  \u0627\u06af\u0631 \u0628\u0627 \u0645\u0639\u0645\u0627\u0631\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0648\u0644\u062a\u06cc \u0631\u0641\u062a\u0647\u200c\u0627\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u062d\u062f\u0627\u0642\u0644 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0645\u0644\u0627\u064b \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f\u060c \u0648 \u0646\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0645\u0627\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0642\u0628\u0644\u0627\u064b \u06af\u0630\u0634\u062a\u0647 \u0627\u0633\u062a\u060c \u062a\u0627\u0628\u0644\u0648\u0647\u0627\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0631\u0627 \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u062f.  \u0627\u06af\u0631 \u0645\u0639\u0645\u0627\u0631\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u06cc\u062f\u060c \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631 \u062a\u0645\u0627\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u0627\u0633\u0628\u0642 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u062f\u0627\u0631\u06cc\u062f\u060c \u0648 \u0641\u0642\u0637 \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u062c\u062f\u06cc\u062f \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f.<\/p>\n<p>\u0645\u0627 \u0647\u0631\u06af\u0632 \u0646\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u062f\u0627\u0646\u06cc\u0645 \u06a9\u0647 \u0622\u06cc\u0646\u062f\u0647 \u0686\u0647 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f\u060c \u0627\u0645\u0627 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u0645\u060c \u0645\u0647\u0646\u062f\u0633\u06cc \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f\u060c \u0628\u0631\u0627\u06cc \u0631\u0648\u06cc\u0627\u0631\u0648\u06cc\u06cc \u0628\u0627 \u0647\u0631 \u0646\u06cc\u0627\u0632\u06cc \u06a9\u0647 \u0633\u0631 \u0631\u0627\u0647\u0634 \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f\u060c \u0628\u0633\u06cc\u0627\u0631 \u0645\u062c\u0647\u0632\u062a\u0631 \u0627\u0633\u062a!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%DA%A9%D8%A7%D8%B1%D8%A7%DB%8C%DB%8C\"><\/span>\n<p>  \u06a9\u0627\u0631\u0627\u06cc\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0634\u0627\u06cc\u062f \u0628\u062a\u0648\u0627\u0646 \u0627\u0634\u0627\u0631\u0647 \u06a9\u0631\u062f \u06a9\u0647 \u062a\u062c\u0645\u06cc\u0639 \u062f\u0627\u0626\u0645\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0645\u0644 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0645\u0633\u0627\u0628\u0642\u0627\u062a \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u06a9\u0627\u0631\u0622\u0645\u062f \u0646\u06cc\u0633\u062a.  \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0641\u0631\u0627\u062a\u0631 \u0627\u0632 \u0622\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0641\u06a9\u0631 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0642\u0639 \u0648\u0627\u0642\u0639\u0627\u064b \u0628\u06cc\u0634 \u0627\u0632 \u062d\u062f \u0645\u06cc \u0634\u0648\u062f.  \u0627\u0648\u0646\u0648\u0642\u062a \u0628\u0627\u06cc\u062f \u0686\u06cc\u06a9\u0627\u0631 \u06a9\u0646\u06cc\u0645\u061f<\/p>\n<p>\u062e\u0648\u0634\u0628\u062e\u062a\u0627\u0646\u0647 \u0646\u06cc\u0627\u0632\u06cc \u0646\u06cc\u0633\u062a \u06a9\u0647 \u0645\u0639\u0645\u0627\u0631\u06cc \u062a\u0627\u0631\u06cc\u062e \u0645\u062d\u0648\u0631 \u0631\u0627 \u06a9\u0646\u0627\u0631 \u0628\u06af\u0630\u0627\u0631\u06cc\u0645.  \u062d\u062f\u0627\u0642\u0644 \u0686\u0646\u062f \u0627\u0633\u0644\u062d\u0647 \u0628\u0632\u0631\u06af \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u0628\u0647 \u0645\u06cc\u0632\u0627\u0646 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D9%85%D8%A7%D8%AF%DB%8C_%D8%B4%D8%AF%D9%87\"><\/span>\n<p>  \u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u062e\u06cc \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647\u060c \u0645\u0627\u0646\u0646\u062f PostgreSQL\u060c \u0627\u0632 \u0645\u0641\u0647\u0648\u0645\u06cc \u0628\u0647 \u0646\u0627\u0645 \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<\/p>\n<p>\u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u062c\u062f\u0648\u0644\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u062d\u062a\u0648\u0627\u06cc \u0622\u0646 \u0628\u0631 \u0627\u0633\u0627\u0633 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u0627\u06af\u0631 \u0628\u0627 \u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc (\u063a\u06cc\u0631 \u0645\u0627\u062f\u06cc) \u0622\u0634\u0646\u0627 \u0647\u0633\u062a\u06cc\u062f\u060c \u062a\u0641\u0627\u0648\u062a \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u0631\u0648\u06cc \u062f\u06cc\u0633\u06a9 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u0645\u062d\u062a\u0648\u06cc\u0627\u062a \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0641\u0642\u0637 \u062f\u0631 \u0635\u0648\u0631\u062a \u062f\u0631\u062e\u0648\u0627\u0633\u062a\u060c \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u062c\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647\u060c \u0645\u062c\u062f\u062f\u0627\u064b \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc \u0634\u0648\u062f <code>REFRESH MATERIALIZED VIEW<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647.<\/p>\n<p>\u062f\u0631 \u0645\u062b\u0627\u0644 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a\u060c \u0645\u0647\u0646\u062f\u0633\u06cc \u06a9\u0647 \u0645\u0639\u0645\u0627\u0631\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u062f\u0642\u06cc\u0642\u0627\u064b \u0645\u0627\u0646\u0646\u062f \u0646\u0645\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f\u060c \u0641\u0642\u0637 \u0628\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 <code>MATERIALIZED<\/code> \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"n\">MATERIALIZED<\/span> <span class=\"k\">VIEW<\/span> <span class=\"n\">leaderboard<\/span> <span class=\"k\">AS<\/span> <span class=\"p\">(<\/span>\n  <span class=\"k\">SELECT<\/span> <span class=\"n\">username<\/span><span class=\"p\">,<\/span> <span class=\"k\">SUM<\/span><span class=\"p\">(<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span>\n  <span class=\"k\">FROM<\/span> <span class=\"n\">match_player<\/span>\n  <span class=\"k\">GROUP<\/span> <span class=\"k\">BY<\/span> <span class=\"n\">username<\/span>\n  <span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"k\">SUM<\/span><span class=\"p\">(<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span> <span class=\"k\">DESC<\/span>\n  <span class=\"k\">LIMIT<\/span> <span class=\"mi\">20<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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>\u0648 \u0622\u0646\u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0627\u06cc\u0646 \u0631\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u0646\u062f <code>leaderboard<\/code> \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u062f\u0642\u06cc\u0642\u0627\u064b \u0647\u0645\u0627\u0646\u06af\u0648\u0646\u0647 \u06a9\u0647 \u0627\u0632 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u062d\u062a\u06cc \u0627\u06af\u0631 <code>match_player<\/code> \u062c\u062f\u0648\u0644 \u062f\u0627\u0631\u0627\u06cc \u062a\u0639\u062f\u0627\u062f \u0632\u06cc\u0627\u062f\u06cc \u0631\u06a9\u0648\u0631\u062f \u0627\u0633\u062a\u060c \u0648\u0627\u06a9\u0634\u06cc 20 \u06af\u0644\u0632\u0646 \u0628\u0631\u062a\u0631 \u0633\u0631\u06cc\u0639 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f\u060c \u0632\u06cc\u0631\u0627 \u0633\u0637\u0631\u0647\u0627 \u062f\u0631 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0627\u0632 \u0642\u0628\u0644 \u0645\u062d\u0627\u0633\u0628\u0647 \u0634\u062f\u0647 \u0648 \u0631\u0648\u06cc \u062f\u06cc\u0633\u06a9 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u062c\u062f\u062f \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0647\u0631 \u0633\u0627\u0639\u062a\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <code>pg_cron<\/code> \u0628\u0631\u0627\u06cc \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06cc\u06a9 \u06a9\u0627\u0631 cron \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"n\">EXTENSION<\/span> <span class=\"n\">IF<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">EXISTS<\/span> <span class=\"n\">pg_cron<\/span><span class=\"p\">;<\/span>\n\n<span class=\"k\">SELECT<\/span> <span class=\"n\">cron<\/span><span class=\"p\">.<\/span><span class=\"n\">schedule<\/span><span class=\"p\">(<\/span>\n  <span class=\"s1\">'leaderboard-refresh'<\/span><span class=\"p\">,<\/span>\n  <span class=\"s1\">'0 * * * *'<\/span><span class=\"p\">,<\/span>\n  <span class=\"s1\">'REFRESH MATERIALIZED VIEW CONCURRENTLY leaderboard'<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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\u0635\u0628 PostgreSQL \u0634\u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0642\u0628\u0644\u0627\u064b \u0646\u0635\u0628 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f <code>pg_cron<\/code> \u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0627\u06af\u0631 \u0646\u0647\u060c \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f)<\/p>\n<p>\u0633\u067e\u0633 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0634\u0645\u0627 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0647\u0631 \u0633\u0627\u0639\u062a \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u06cc\u06a9 \u0646\u0642\u0635 \u0622\u0634\u06a9\u0627\u0631 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062a\u0627 \u06cc\u06a9 \u0633\u0627\u0639\u062a \u0642\u062f\u06cc\u0645\u06cc \u0628\u0627\u0634\u062f.  \u0645\u0648\u0631\u062f \u062f\u06cc\u06af\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647\u060c \u062d\u062a\u06cc \u0627\u06af\u0631 \u0641\u0642\u0637 \u06cc\u06a9 \u0628\u0627\u0631 \u062f\u0631 \u0633\u0627\u0639\u062a \u0645\u0646\u0638\u0631\u0647 \u0631\u0627 \u062a\u0627\u0632\u0647 \u06a9\u0646\u06cc\u0645\u060c \u0647\u0646\u0648\u0632 \u0646\u0642\u0637\u0647\u200c\u0627\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u0646\u0638\u0631 \u0639\u0645\u0644\u06a9\u0631\u062f \u0646\u0627\u067e\u0627\u06cc\u062f\u0627\u0631 \u0634\u0648\u062f (\u0627\u062d\u062a\u0645\u0627\u0644\u0627\u064b \u0642\u0628\u0644 \u0627\u0632 \u0631\u0633\u06cc\u062f\u0646 \u0628\u0647 \u0622\u0646\u062c\u0627 \u0645\u06cc\u0644\u06cc\u0627\u0631\u062f\u0647\u0627 \u0645\u0633\u0627\u0628\u0642\u0647 \u0637\u0648\u0644 \u0645\u06cc\u200c\u06a9\u0634\u062f\u060c \u0627\u0645\u0627 \u0627\u06cc\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u0631\u062a\u0628\u0637\u200c\u062a\u0631 \u0628\u0627\u0634\u062f. \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f\u060c \u0647\u0631 \u067e\u0646\u062c \u062b\u0627\u0646\u06cc\u0647 \u06cc\u06a9\u0628\u0627\u0631).<\/p>\n<p>\u0639\u0644\u06cc\u0631\u063a\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0633\u062a\u06cc \u0647\u0627\u060c \u062f\u06cc\u062f\u06af\u0627\u0647 \u0645\u0627\u062f\u06cc \u0627\u063a\u0644\u0628 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0639\u0627\u0644\u06cc \u0627\u0633\u062a.  \u0627\u0645\u0627 \u0627\u06af\u0631 \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06a9\u0627\u0645\u0644\u0627\u064b \u0628\u0647\u200c\u0631\u0648\u0632 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f\u060c \u06cc\u0627 \u062d\u062c\u0645 \u0639\u0638\u06cc\u0645\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u062c\u0645\u0639\u200c\u0622\u0648\u0631\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u062a\u06a9\u0646\u06cc\u06a9 \u0628\u0639\u062f\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u06a9\u0646\u062f&#8230;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%DA%AF%D9%87%D8%AF%D8%A7%D8%B1%DB%8C_%D8%A7%D8%B2_%D9%86%D9%85%D8%A7%DB%8C_%D8%A7%D9%81%D8%B2%D8%A7%DB%8C%D8%B4%DB%8C_IVM\"><\/span>\n<p>  \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0627\u0632 \u0646\u0645\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634\u06cc (IVM)<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06af\u0631 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0646\u0637\u0642\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646 \u0641\u06a9\u0631 \u06a9\u0646\u06cc\u0645\u060c \u0648\u0642\u062a\u06cc \u06cc\u06a9 \u0628\u0627\u0632\u06cc\u06a9\u0646 \u062f\u0631 \u06cc\u06a9 \u0645\u0633\u0627\u0628\u0642\u0647 \u0628\u0631\u0646\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0622\u06cc\u0627 \u0648\u0627\u0642\u0639\u0627\u064b \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a \u06a9\u0647 \u06a9\u0644 \u062c\u062f\u0648\u0644 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u0645\u061f  \u0622\u06cc\u0627 \u0646\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0631\u06a9\u0648\u0631\u062f \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0622\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u0645\u061f<\/p>\n<p>\u0628\u0644\u0647 \u0648\u0627\u0642\u0639\u0627\u064b \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645!  \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u06af\u0627\u0647\u06cc \u0627\u0648\u0642\u0627\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062a\u0639\u0645\u06cc\u0631 \u0648 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0627\u0641\u0632\u0627\u06cc\u0634\u06cc \u0646\u0627\u0645\u06cc\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u0627\u06cc\u0646 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0648\u06cc\u0698\u06af\u06cc \u062f\u0631\u062c\u0647 \u06cc\u06a9 \u062f\u0631 PostgreSQL \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0647\u0646\u0648\u0632 \u0627\u0631\u0633\u0627\u0644 \u0646\u0634\u062f\u0647 \u0627\u0633\u062a.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u062e\u0648\u062f\u0645\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0622\u0646 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0631\u0627\u0647 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0622\u0646 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0627\u0633\u062a <code>leaderboard<\/code> \u062c\u062f\u0648\u0644\u060c \u0633\u067e\u0633 \u0647\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0647 \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u062c\u062f\u06cc\u062f \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f <code>match_player<\/code> \u062c\u062f\u0648\u0644\u060c \u0634\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u06a9\u062f\u06cc \u0628\u0631\u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u062f\u0631 \u0622\u0646 \u062f\u0627\u0631\u06cc\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644 \u0628\u0631\u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0631\u06a9\u062a \u06a9\u0646\u0646\u062f\u06af\u0627\u0646.<\/p>\n<p>\u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06cc\u06a9 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062e\u0648\u0628 \u0628\u0627\u0634\u062f\u060c \u0627\u0645\u0627 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0647\u0648\u0634\u06cc\u0627\u0631\u06cc \u062f\u0627\u0631\u062f \u062a\u0627 \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u062f \u0634\u0645\u0627 \u0647\u0645\u06cc\u0634\u0647 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u06a9\u0646\u062f <code>match_player<\/code> \u062c\u062f\u0648\u0644.  \u0631\u0627\u0647 \u0628\u0647\u062a\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062d\u0631\u06a9 \u0647\u0627 \u0627\u0633\u062a.  \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0645\u0627\u0634\u0647 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u06a9\u0647 \u0647\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f <code>match_player<\/code> \u062c\u062f\u0648\u0644.  \u0686\u0647 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u062c\u062f\u06cc\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0686\u0647 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f\u060c \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0627\u0634\u0647 \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644 \u0645\u0646\u0627\u0633\u0628  \u0628\u0647\u062a\u0631 \u0627\u0632 \u0647\u0645\u0647\u060c \u062a\u0627\u0628\u0639 \u0645\u0627\u0634\u0647 \u062f\u0631 \u062e\u0648\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0632\u0646\u062f\u06af\u06cc \u0645\u06cc \u06a9\u0646\u062f\u060c \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0631\u0627\u0642\u0628 \u0627\u062c\u0631\u0627\u06cc \u0622\u0646 \u062f\u0631 \u0647\u0631 \u0632\u0645\u0627\u0646 \u0627\u0633\u062a <code>match_player<\/code> \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062c\u062f\u0648\u0644  \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0645\u0627\u0634\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0633\u0646\u0627\u0631\u06cc\u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">OR<\/span> <span class=\"k\">REPLACE<\/span> <span class=\"k\">FUNCTION<\/span> <span class=\"n\">update_leaderboard_function<\/span><span class=\"p\">()<\/span>\n<span class=\"k\">RETURNS<\/span> <span class=\"k\">TRIGGER<\/span> <span class=\"k\">AS<\/span> <span class=\"err\">$$<\/span>\n<span class=\"k\">BEGIN<\/span>\n  <span class=\"n\">IF<\/span> <span class=\"p\">(<\/span><span class=\"n\">TG_OP<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'INSERT'<\/span><span class=\"p\">)<\/span>\n  <span class=\"k\">THEN<\/span>\n    <span class=\"c1\">-- If a new match record is being inserted, we<\/span>\n    <span class=\"c1\">-- do an upsert on the leaderboard table to increase<\/span>\n    <span class=\"c1\">-- the points of the leaderboard record corresponding<\/span>\n    <span class=\"c1\">-- to that use username in the new match record.<\/span>\n    <span class=\"c1\">-- IMPORTANT: The leaderboard table must have a unique<\/span>\n    <span class=\"c1\">-- index on the username column<\/span>\n    <span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">leaderboard<\/span> <span class=\"p\">(<\/span><span class=\"n\">username<\/span><span class=\"p\">,<\/span> <span class=\"n\">points<\/span><span class=\"p\">)<\/span> \n    <span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"k\">NEW<\/span><span class=\"p\">.<\/span><span class=\"n\">username<\/span><span class=\"p\">,<\/span> <span class=\"k\">NEW<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">ON<\/span> <span class=\"n\">CONFLICT<\/span> <span class=\"p\">(<\/span><span class=\"n\">username<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">DO<\/span> <span class=\"k\">UPDATE<\/span> <span class=\"k\">SET<\/span> <span class=\"n\">points<\/span> <span class=\"o\">=<\/span> <span class=\"n\">leaderboard<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span> <span class=\"o\">+<\/span> <span class=\"k\">NEW<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span><span class=\"p\">;<\/span>\n  <span class=\"n\">ELSEIF<\/span> <span class=\"p\">(<\/span><span class=\"n\">TG_OP<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'DELETE'<\/span><span class=\"p\">)<\/span>\n  <span class=\"k\">THEN<\/span>\n    <span class=\"c1\">-- If a match record is being deleted, we update<\/span>\n    <span class=\"c1\">-- the leaderboard table and decrease the leaderboard<\/span>\n    <span class=\"c1\">-- points of the user whose match record was deleted.<\/span>\n    <span class=\"k\">UPDATE<\/span> <span class=\"n\">leaderboard<\/span>\n    <span class=\"k\">SET<\/span> <span class=\"n\">points<\/span> <span class=\"o\">=<\/span> <span class=\"n\">leaderboard<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span> <span class=\"o\">-<\/span> <span class=\"k\">OLD<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span>\n    <span class=\"k\">WHERE<\/span> <span class=\"n\">leaderboard<\/span><span class=\"p\">.<\/span><span class=\"n\">username<\/span> <span class=\"o\">=<\/span> <span class=\"k\">OLD<\/span><span class=\"p\">.<\/span><span class=\"n\">username<\/span><span class=\"p\">;<\/span>\n  <span class=\"n\">ELSEIF<\/span> <span class=\"p\">(<\/span><span class=\"n\">TG_OP<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'UPDATE'<\/span><span class=\"p\">)<\/span>\n  <span class=\"k\">THEN<\/span>\n    <span class=\"c1\">-- If a match record is being updated, we calculate<\/span>\n    <span class=\"c1\">-- the difference in points between the new record<\/span>\n    <span class=\"c1\">-- and the old record and add that to the points of<\/span>\n    <span class=\"c1\">-- the user whose match record was update (the difference<\/span>\n    <span class=\"c1\">-- might be negative, in which case the user's position<\/span>\n    <span class=\"c1\">-- on the leaderboard would go down)<\/span>\n    <span class=\"k\">UPDATE<\/span> <span class=\"n\">leaderboard<\/span>\n    <span class=\"k\">SET<\/span> <span class=\"n\">points<\/span> <span class=\"o\">=<\/span> <span class=\"n\">leaderboard<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span> <span class=\"o\">+<\/span> <span class=\"p\">(<\/span><span class=\"k\">NEW<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span> <span class=\"o\">-<\/span> <span class=\"k\">OLD<\/span><span class=\"p\">.<\/span><span class=\"n\">points<\/span><span class=\"p\">)<\/span>\n    <span class=\"k\">WHERE<\/span> <span class=\"n\">leaderboard<\/span><span class=\"p\">.<\/span><span class=\"n\">username<\/span> <span class=\"o\">=<\/span> <span class=\"k\">OLD<\/span><span class=\"p\">.<\/span><span class=\"n\">username<\/span><span class=\"p\">;<\/span>\n  <span class=\"k\">END<\/span> <span class=\"n\">IF<\/span><span class=\"p\">;<\/span>\n\n  <span class=\"k\">RETURN<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">END<\/span><span class=\"p\">;<\/span>\n<span class=\"err\">$$<\/span> <span class=\"k\">LANGUAGE<\/span> <span class=\"n\">plpgsql<\/span><span class=\"p\">;<\/span>\n\n<span class=\"k\">CREATE<\/span> <span class=\"k\">OR<\/span> <span class=\"k\">REPLACE<\/span> <span class=\"k\">TRIGGER<\/span> <span class=\"n\">update_leaderboard_trigger<\/span>\n<span class=\"k\">AFTER<\/span> <span class=\"k\">INSERT<\/span> <span class=\"k\">OR<\/span> <span class=\"k\">UPDATE<\/span> <span class=\"k\">OR<\/span> <span class=\"k\">DELETE<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">match_player<\/span>\n<span class=\"k\">FOR<\/span> <span class=\"k\">EACH<\/span> <span class=\"k\">ROW<\/span>\n<span class=\"k\">EXECUTE<\/span> <span class=\"k\">FUNCTION<\/span> <span class=\"n\">update_leaderboard_function<\/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>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\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 \u0642\u0628\u0644\u0627\u064b \u0628\u0627 \u062a\u0631\u06cc\u06af\u0631\u0647\u0627 \u06a9\u0627\u0631 \u0646\u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0632\u0631\u06af \u0648 \u062a\u0631\u0633\u0646\u0627\u06a9 \u0628\u0647 \u0646\u0638\u0631 \u0628\u0631\u0633\u062f\u060c \u0627\u0645\u0627 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\u0627\u06af\u0631 \u0634\u0645\u0627 <code>INSERT<\/code> \u0628\u0647 \u062f\u0631\u0648\u0646 <code>match_player<\/code> \u062c\u062f\u0648\u0644\u060c \u0627\u0645\u062a\u06cc\u0627\u0632 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644.<\/li>\n<li>\u0627\u06af\u0631 \u0634\u0645\u0627 <code>DELETE<\/code> \u0627\u0632 <code>match_player<\/code> \u062c\u062f\u0648\u0644\u060c \u0627\u0645\u062a\u06cc\u0627\u0632 \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 \u06a9\u0633\u0631 \u0645\u06cc \u06a9\u0646\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644.<\/li>\n<li>\u0627\u06af\u0631 \u0634\u0645\u0627 <code>UPDATE<\/code> \u0631\u0627 <code>match_player<\/code> \u062c\u062f\u0648\u0644\u060c \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0631 \u0646\u0642\u0627\u0637 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc \u06a9\u0646\u062f (\u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0647\u0631 \u062f\u0648 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0631\u062f <code>NEW<\/code> \u0648 <code>OLD<\/code> \u0646\u0633\u062e\u0647 \u0631\u062f\u06cc\u0641) \u0648 \u062a\u0641\u0627\u0648\u062a \u0631\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u06a9\u0646\u062f <code>leaderboard<\/code> \u062c\u062f\u0648\u0644.<\/li>\n<\/ol>\n<p>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0627\u06cc\u0646 \u0645\u0627\u0634\u0647 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062a\u0627\u0628\u0644\u0648\u06cc \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0634\u0645\u0627 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0646\u06af\u0647 \u0645\u06cc \u062f\u0627\u0631\u062f!  (\u062a\u0627 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0646\u06a9\u0646\u06cc\u062f <code>TRUNCATE<\/code> \u0622\u0646\u060c \u062d\u062f\u0627\u0642\u0644).<\/p>\n<p>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0646\u0645\u0627\u0647\u0627 \u0648\/\u06cc\u0627 \u0645\u062d\u0631\u06a9 \u0647\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647\u060c \u06a9\u0645 \u0648 \u0628\u06cc\u0634 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0647\u0631 \u062f\u0648 \u062c\u0647\u0627\u0646 \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc \u06a9\u0646\u06cc\u062f.  \u0639\u0645\u0644\u06a9\u0631\u062f\u06cc \u062a\u0642\u0631\u06cc\u0628\u0627\u064b \u0628\u0647 \u062e\u0648\u0628\u06cc \u0645\u0639\u0645\u0627\u0631\u06cc \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0648\u0644\u062a\u06cc \u062f\u0627\u0631\u062f\u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u0627\u0646\u0639\u0637\u0627\u0641\u200c\u067e\u0630\u06cc\u0631\u06cc \u0645\u0639\u0645\u0627\u0631\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u0627\u0633\u062a.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D8%AA%DB%8C%D8%AC%D9%87\"><\/span>\n<p>  \u0646\u062a\u06cc\u062c\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0622\u06cc\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u062d\u0627\u0644\u062a \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f \u06cc\u0627 \u0628\u0627\u06cc\u062f \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f \u0648 \u0648\u0636\u0639\u06cc\u062a \u0631\u0627 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f\u061f  \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f \u06a9\u0647 \u0645\u0639\u0645\u0627\u0631\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u062f\u0627\u0631\u0627\u06cc \u0645\u0632\u0627\u06cc\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0642\u0627\u0646\u0639 \u06a9\u0646\u0646\u062f\u0647 \u0627\u06cc \u0627\u0633\u062a.  \u0645\u0646 \u0634\u062e\u0635\u0627\u064b \u0627\u06a9\u0646\u0648\u0646 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0637\u0631\u0627\u062d\u06cc \u0645\u06cc \u06a9\u0646\u0645\u060c \u0627\u06af\u0631\u0686\u0647 \u0645\u0637\u0645\u0626\u0646\u0627\u064b \u062f\u0631 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0633\u0646\u0627\u0631\u06cc\u0648\u0647\u0627 \u0645\u0635\u0627\u0644\u062d\u0647 \u0645\u06cc \u06a9\u0646\u0645.<\/p>\n<p>\u0634\u0645\u0627 \u0686\u06cc \u0641\u06a9\u0631 \u0645\u06cc\u06a9\u0646\u06cc\u062f\u061f  \u0622\u06cc\u0627 \u0628\u0627 \u0647\u0631 \u062f\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0639\u0645\u0627\u0631\u06cc \u0647\u0627 \u0622\u0634\u0646\u0627\u06cc\u06cc \u062f\u0627\u0631\u06cc\u062f\u061f  \u0622\u06cc\u0627 \u0645\u0648\u0631\u062f \u0633\u0648\u0645\u060c \u0686\u0647\u0627\u0631\u0645 \u06cc\u0627 \u067e\u0646\u062c\u0645\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646 \u0635\u062d\u0628\u062a \u06a9\u0646\u06cc\u0645\u061f<\/p>\n<p><em>\u0645\u0646 \u0627\u0632 \u0686\u0646\u062f \u0645\u06cc\u0627\u0646\u0628\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0645 \u062a\u0627 \u06cc\u06a9 \u062e\u0637 \u06a9\u062f \u0631\u0627 \u0627\u06cc\u0646\u062c\u0627 \u0648 \u0622\u0646\u062c\u0627 \u06a9\u0645 \u06a9\u0646\u0645\u060c \u0645\u0627\u0646\u0646\u062f \u0627\u06cc\u0646\u06a9\u0647 \u0647\u0645\u06cc\u0634\u0647 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u0627\u0635\u0644\u06cc \u0631\u0627 \u0645\u0634\u062e\u0635 \u0646\u06a9\u0631\u062f\u0647 \u0648 \u0627\u0632 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0645.  \u0627\u06cc\u0646\u0647\u0627 \u0631\u0627 \u0646\u0628\u0627\u06cc\u062f \u0627\u0642\u062f\u0627\u0645\u0627\u062a \u062e\u0648\u0628 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f\u061f \u062f\u0648 \u0631\u0648\u0634 \u06a9\u0644\u06cc \u0628\u0631\u0627\u06cc \u062a\u0641\u06a9\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f: \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u062d\u0627\u0644\u062a \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u06cc\u062f \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f \u0645\u0647\u0646\u062f\u0633\u0627\u0646 \u062a\u0645\u0627\u06cc\u0644 \u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0630\u062e\u06cc\u0631\u0647\u200c\u06a9\u0646\u0646\u062f\u0647 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u0646\u062f \u062d\u0627\u0644\u062a. \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0648\u0627\u0636\u062d \u062a\u0631 \u0627\u0633\u062a &hellip;<\/p>\n","protected":false},"author":2,"featured_media":15444,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-15443","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\/15443","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=15443"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/15443\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/15444"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=15443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=15443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=15443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}