{"id":27235,"date":"2023-06-17T03:38:22","date_gmt":"2023-06-17T00:08:22","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/"},"modified":"2023-06-17T03:38:22","modified_gmt":"2023-06-17T00:08:22","slug":"visualize-real-time-data-with-python-dash-and-risingwave-33g0","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/","title":{"rendered":"\u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0627 \u067e\u0627\u06cc\u062a\u0648\u0646\u060c \u062f\u0627\u0634 \u0648 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0645\u0648\u062c"},"content":{"rendered":"<div data-article-id=\"1467016\" id=\"article-body\">\n<p>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0628\u0631\u0627\u06cc \u06a9\u0633\u0628 \u0648 \u06a9\u0627\u0631\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u0635\u0645\u06cc\u0645 \u06af\u06cc\u0631\u06cc \u0633\u0631\u06cc\u0639 \u0645\u0647\u0645 \u0627\u0633\u062a.  \u062f\u06cc\u062f\u0646 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0628\u0635\u0631\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u062a\u0635\u0645\u06cc\u0645 \u06af\u06cc\u0631\u06cc \u0633\u0631\u06cc\u0639\u062a\u0631 \u06a9\u0645\u06a9 \u06a9\u0646\u062f.  \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u06cc\u0627 \u062f\u0627\u0634\u0628\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u0646\u0645\u0627\u06cc\u0634 \u0647\u0627\u06cc \u0628\u0635\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u062f\u0627\u0634 \u0627\u0633\u062a <strong>\u06cc\u06a9 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u067e\u0627\u06cc\u062a\u0648\u0646<\/strong> \u06a9\u0647 \u0637\u06cc\u0641 \u0648\u0633\u06cc\u0639\u06cc \u0627\u0632 \u0627\u062c\u0632\u0627\u06cc \u062f\u0627\u062e\u0644\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627\u06cc \u062a\u0639\u0627\u0645\u0644\u06cc\u060c \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627\u060c \u062c\u062f\u0627\u0648\u0644 \u0648 \u0633\u0627\u06cc\u0631 \u0639\u0646\u0627\u0635\u0631 \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f.  RisingWave \u06cc\u06a9 \u0627\u0633\u062a <strong>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u0631\u06cc\u0627\u0646 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 SQL<\/strong> \u0628\u0631\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc  \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Python\u060c \u067e\u0631\u0648\u0698\u0647 \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 Dash \u0648 RisingWave \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%86%D8%AD%D9%88%D9%87_%D8%AA%D8%AC%D8%B3%D9%85_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%AF%D8%B1_%D8%B2%D9%85%D8%A7%D9%86_%D9%88%D8%A7%D9%82%D8%B9%DB%8C\" >\u0646\u062d\u0648\u0647 \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc<\/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\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%86%D9%85%D8%A7%DB%8C%D8%B4_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D8%AA%D8%AD%D9%88%DB%8C%D9%84_%D8%B3%D9%81%D8%A7%D8%B1%D8%B4_%D8%B1%D8%A7_%D8%AA%D8%AC%D8%B3%D9%85_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634 \u0631\u0627 \u062a\u062c\u0633\u0645 \u06a9\u0646\u06cc\u062f<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%82%D8%A8%D9%84_%D8%A7%D8%B2_%D8%A7%DB%8C%D9%86%DA%A9%D9%87_%D8%B4%D8%B1%D9%88%D8%B9_%DA%A9%D9%86%DB%8C\" >\u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_1_%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%D8%AE%D9%88%D8%B4%D9%87_%D9%86%D9%85%D8%A7%DB%8C%D8%B4%DB%8C_RisingWave\" >\u0645\u0631\u062d\u0644\u0647 1: \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u062e\u0648\u0634\u0647 \u0646\u0645\u0627\u06cc\u0634\u06cc RisingWave<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_2_%DA%A9%D8%AA%D8%A7%D8%A8%D8%AE%D8%A7%D9%86%D9%87_%D9%87%D8%A7%DB%8C_Dash_%D9%88_Psycopg2_%D8%B1%D8%A7_%D9%86%D8%B5%D8%A8_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 2: \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc Dash \u0648 Psycopg2 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_3_%DB%8C%DA%A9_%D9%85%D9%86%D8%A8%D8%B9_%D8%AF%D8%A7%D8%AF%D9%87_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 3: \u06cc\u06a9 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/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\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_4_%DB%8C%DA%A9_%D9%86%D9%85%D8%A7%DB%8C_%D9%85%D8%A7%D8%AF%DB%8C_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 4: \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_5_%D8%B3%D8%A7%D8%AE%D8%AA_%D8%A7%D9%BE%D9%84%DB%8C%DA%A9%DB%8C%D8%B4%D9%86_Dash\" >\u0645\u0631\u062d\u0644\u0647 5: \u0633\u0627\u062e\u062a \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 Dash<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_6_%D9%86%D8%AA%D8%A7%DB%8C%D8%AC_%D8%B1%D8%A7_%D9%85%D8%B4%D8%A7%D9%87%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 6: \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\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-10\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D8%AE%D9%84%D8%A7%D8%B5%D9%87\" >\u062e\u0644\u0627\u0635\u0647<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D9%86%D8%A7%D8%A8%D8%B9_%D9%85%D8%B1%D8%AA%D8%A8%D8%B7\" >\u0645\u0646\u0627\u0628\u0639 \u0645\u0631\u062a\u0628\u0637<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D9%85%D8%AD%D8%AA%D9%88%D8%A7%DB%8C_%D9%BE%DB%8C%D8%B4%D9%86%D9%87%D8%A7%D8%AF%DB%8C\" >\u0645\u062d\u062a\u0648\u0627\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D8%A7%D9%86%D8%AC%D9%85%D9%86\" >\u0627\u0646\u062c\u0645\u0646<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/nabfollower.com\/blog\/visualize-real-time-data-with-python-dash-and-risingwave-33g0\/#%D8%AF%D8%B1%D8%A8%D8%A7%D8%B1%D9%87_%D9%86%D9%88%DB%8C%D8%B3%D9%86%D8%AF%D9%87\" >\u062f\u0631\u0628\u0627\u0631\u0647 \u0646\u0648\u06cc\u0633\u0646\u062f\u0647<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D8%AD%D9%88%D9%87_%D8%AA%D8%AC%D8%B3%D9%85_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%AF%D8%B1_%D8%B2%D9%85%D8%A7%D9%86_%D9%88%D8%A7%D9%82%D8%B9%DB%8C\"><\/span>\n<p>  \u0646\u062d\u0648\u0647 \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u0627 \u0645\u06cc \u062f\u0627\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0644\u0627\u0641\u0627\u0635\u0644\u0647 \u062a\u0648\u0644\u06cc\u062f \u0648 \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u0634\u0648\u0646\u062f\u060c \u0632\u06cc\u0631\u0627 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f.  \u0645\u0646\u0627\u0628\u0639 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0639\u0645\u0648\u0644\u06cc \u0645\u0627\u0646\u0646\u062f Postgres \u06cc\u0627 MySQL \u0648 \u0648\u0627\u0633\u0637\u0647 \u0647\u0627\u06cc \u067e\u06cc\u0627\u0645 \u0645\u0627\u0646\u0646\u062f \u06a9\u0627\u0641\u06a9\u0627 \u0628\u0627\u0634\u0646\u062f.  \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0634\u0627\u0645\u0644 \u0686\u0646\u062f \u0645\u0631\u062d\u0644\u0647 \u0627\u0633\u062a\u060c \u0627\u0628\u062a\u062f\u0627 \u0645\u0627 <strong>\u0628\u0644\u0639\u06cc\u062f\u0646\u060c<\/strong> \u0633\u067e\u0633 <strong>\u067e\u0631\u062f\u0627\u0632\u0634 \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u062f<\/strong> \u062f\u0631 \u06cc\u06a9 \u062f\u0627\u0634\u0628\u0648\u0631\u062f<\/p>\n<p>\u062f\u0631 \u0645\u0648\u0631\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634\u060c \u062a\u062c\u0633\u0645 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u06cc\u0646\u0634 \u0627\u0631\u0632\u0634\u0645\u0646\u062f\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u06cc\u06a9 \u0631\u0633\u062a\u0648\u0631\u0627\u0646 \u06cc\u0627 \u062e\u062f\u0645\u0627\u062a \u062a\u062d\u0648\u06cc\u0644 \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u062f.  \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u06cc\u200c\u062f\u0631\u0646\u06af \u0628\u0631\u0627\u06cc \u0646\u0638\u0627\u0631\u062a \u0628\u0631 \u0645\u062f\u062a \u0632\u0645\u0627\u0646 \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634\u200c\u0647\u0627\u060c \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062a\u0646\u06af\u0646\u0627\u0647\u0627 \u062f\u0631 \u0641\u0631\u0622\u06cc\u0646\u062f \u062a\u062d\u0648\u06cc\u0644 \u0648 \u067e\u06cc\u06af\u06cc\u0631\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062d\u062c\u0645 \u0633\u0641\u0627\u0631\u0634 \u062f\u0631 \u0637\u0648\u0644 \u0632\u0645\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645.  \u0647\u0646\u06af\u0627\u0645 \u0628\u0631\u062e\u0648\u0631\u062f \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0627\u0626\u0645\u0627\u064b \u062f\u0631 \u062d\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u0647\u0633\u062a\u0646\u062f\u060c \u067e\u06cc\u06af\u06cc\u0631\u06cc \u0647\u0645\u0647 \u0686\u06cc\u0632\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f \u0648 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0627\u0644\u06af\u0648\u0647\u0627 \u06cc\u0627 \u0631\u0648\u0646\u062f\u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u0634\u0648\u0627\u0631 \u0628\u0627\u0634\u062f.  \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0631\u0627\u06cc\u06af\u0627\u0646 \u0645\u0627\u0646\u0646\u062f Dash \u0648 RisingWave\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u062a\u062c\u0633\u0645\u200c\u0647\u0627\u06cc \u062a\u0639\u0627\u0645\u0644\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u0626\u0645\u0627\u064b \u062f\u0631 \u062d\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u0645. <\/p>\n<p>\u0648\u0642\u062a\u06cc \u0635\u062d\u0628\u062a \u0627\u0632 \u06a9\u0627\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0627\u0648\u0644\u06cc\u0646 \u0632\u0628\u0627\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0647 \u0622\u0646 \u0641\u06a9\u0631 \u06a9\u0646\u06cc\u062f \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u0633\u062a\u060c \u0632\u06cc\u0631\u0627 \u062f\u0627\u0631\u0627\u06cc \u0637\u06cc\u0641 \u0648\u0633\u06cc\u0639\u06cc \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627 \u0627\u0633\u062a.  Dash \u06cc\u06a9\u06cc \u0627\u0632 \u0622\u0646\u0647\u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc \u063a\u0646\u06cc \u0648 \u0642\u0627\u0628\u0644 \u062a\u0646\u0638\u06cc\u0645 \u0641\u0642\u0637 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u062f \u067e\u0627\u06cc\u062a\u0648\u0646 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  Dash \u0628\u0631 \u0631\u0648\u06cc Flask\u060c Plotly.js \u0648 React.js \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0645\u062d\u0628\u0648\u0628 \u062a\u0648\u0633\u0639\u0647 \u0648\u0628 \u0647\u0633\u062a\u0646\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u062f\u0627\u0646\u0633\u062a\u0646 HTML\u060c CSS \u06cc\u0627 \u0633\u0627\u06cc\u0631 \u0686\u0627\u0631\u0686\u0648\u0628 \u0647\u0627\u06cc \u062c\u0627\u0648\u0627 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0646\u062f\u0627\u0631\u06cc\u062f.<\/p>\n<p>\u0628\u0627 RisingWave\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 <strong>\u0645\u0635\u0631\u0641 \u062c\u0631\u06cc\u0627\u0646 \u062f\u0627\u062f\u0647<\/strong> \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0645\u062e\u062a\u0644\u0641\u060c \u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0647\u06cc\u0646\u0647 \u0634\u062f\u0647 \u0627\u0646\u062f \u0648 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.  \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 RisingWave \u0628\u0627 PostgreSQL \u0633\u0627\u0632\u06af\u0627\u0631 \u0627\u0633\u062a\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>[psycopg2](https:\/\/pypi.org\/project\/psycopg2\/)<\/code> (\u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0645\u0634\u062a\u0631\u06cc PostgreSQL \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646) \u062f\u0631\u0627\u06cc\u0648\u0631 \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 RisingWave\u060c \u0627\u0646\u062c\u0627\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648.  \u062f\u0631 \u0628\u062e\u0634 \u0628\u0639\u062f\u06cc \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/p>\n<p><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C%D8%B4_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D8%AA%D8%AD%D9%88%DB%8C%D9%84_%D8%B3%D9%81%D8%A7%D8%B1%D8%B4_%D8%B1%D8%A7_%D8%AA%D8%AC%D8%B3%D9%85_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634 \u0631\u0627 \u062a\u062c\u0633\u0645 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0622\u0645\u0648\u0632\u0634 \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc\u060c \u0645\u0627 \u0627\u0632 \u0645\u062e\u0632\u0646 GitHub \u0632\u06cc\u0631 \u0628\u0627 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634\u06cc RisingWave \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0641\u0631\u0636 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u062a\u0645\u0627\u0645 \u0645\u0648\u0627\u0631\u062f \u0636\u0631\u0648\u0631\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Docker compose \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647\u200c\u0627\u0646\u062f.  \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0631\u0627\u0647 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0627\u062c\u0631\u0627\u06cc RisingWave \u0631\u0627 \u062f\u0631 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0631\u0633\u0645\u06cc \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.  \u0645\u0627 \u06cc\u06a9 \u0645\u0648\u0636\u0648\u0639 \u06a9\u0627\u0641\u06a9\u0627 \u062f\u0627\u0631\u06cc\u0645 \u0628\u0647 \u0646\u0627\u0645 <code>delivery_orders<\/code> \u06a9\u0647 \u0634\u0627\u0645\u0644 \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0647\u0631 \u0633\u0641\u0627\u0631\u0634\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u06cc\u06a9 \u0648\u0628 \u0633\u0627\u06cc\u062a \u062a\u062d\u0648\u06cc\u0644 \u063a\u0630\u0627 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f.  \u0647\u0631 \u0631\u0648\u06cc\u062f\u0627\u062f \u0634\u0627\u0645\u0644 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0633\u0641\u0627\u0631\u0634\u060c \u0645\u0627\u0646\u0646\u062f <code>order ID<\/code>\u060c <code>restaurant ID<\/code>\u060c \u0648 <code>delivery status<\/code>.  \u0645\u0648\u0644\u062f \u0628\u0627\u0631 \u06a9\u0627\u0631\u06cc (\u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0647 \u0646\u0627\u0645 Datagen) \u062a\u0648\u0644\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u06af\u06cc \u062a\u0635\u0627\u062f\u0641\u06cc \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u062f\u0627\u0648\u0645 \u0634\u0628\u06cc\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627 \u067e\u062e\u0634 \u0645\u06cc\u200c\u06a9\u0646\u062f.  \u062f\u0631 \u0648\u0627\u0642\u0639\u060c \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u06af\u06cc \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0648\u0628 \u06cc\u0627 \u0633\u0631\u0648\u06cc\u0633 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u0634\u0645\u0627 \u0645\u06cc \u0622\u06cc\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0631\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%82%D8%A8%D9%84_%D8%A7%D8%B2_%D8%A7%DB%8C%D9%86%DA%A9%D9%87_%D8%B4%D8%B1%D9%88%D8%B9_%DA%A9%D9%86%DB%8C\"><\/span>\n<p>  \u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u062a\u06a9\u0645\u06cc\u0644 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f.<\/p>\n<ul>\n<li>\u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 Docker \u0648 Docker Compose \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u062e\u0648\u062f \u0646\u0635\u0628 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f.<\/li>\n<li>\u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u062a\u0639\u0627\u0645\u0644\u06cc PostgreSQL\u060c psql\u060c \u062f\u0631 \u0645\u062d\u06cc\u0637 \u0634\u0645\u0627 \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a.  \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644 \u0647\u0627\u06cc \u062f\u0642\u06cc\u0642\u060c \u062f\u0627\u0646\u0644\u0648\u062f PostgreSQL \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/li>\n<li>\u067e\u0627\u06cc\u062a\u0648\u0646 3 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u062e\u0648\u062f \u062f\u0627\u0646\u0644\u0648\u062f \u0648 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f. <code>pip<\/code> \u062f\u0633\u062a\u0648\u0631 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0646\u0635\u0628 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/li>\n<\/ul>\n<p>\u0646\u0633\u062e\u0647 \u06cc \u0646\u0645\u0627\u06cc\u0634\u06cc \u06a9\u0647 \u0645\u0646 \u0631\u0648\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0648\u06cc\u0646\u062f\u0648\u0632 \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0631\u062f\u0645\u060c \u062f\u0633\u06a9\u062a\u0627\u067e Docker \u0648 \u0646\u0633\u062e\u0647 3.10.11 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_1_%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%D8%AE%D9%88%D8%B4%D9%87_%D9%86%D9%85%D8%A7%DB%8C%D8%B4%DB%8C_RisingWave\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 1: \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u062e\u0648\u0634\u0647 \u0646\u0645\u0627\u06cc\u0634\u06cc RisingWave<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0645\u062e\u0632\u0646 \u0646\u0645\u0648\u0646\u0647 RisingWave \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u0645\u062d\u0644\u06cc \u062e\u0648\u062f \u06a9\u0644\u0648\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>git clone https:\/\/github.com\/risingwavelabs\/risingwave.git\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>\u0633\u067e\u0633 <code>integration_tests\/delivery<\/code> \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0648 \u06a9\u0644\u0627\u0633\u062a\u0631 \u062f\u0645\u0648 \u0631\u0627 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0646\u0648\u0634\u062a\u0646 docker \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code><span class=\"nb\">cd <\/span>risingwave\/integration_tests\/delivery\ndocker compose up <span class=\"nt\">-d<\/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>\u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0647\u0645\u0647 \u06a9\u0627\u0646\u062a\u06cc\u0646\u0631\u0647\u0627 \u0622\u0645\u0627\u062f\u0647 \u0648 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u0646\u062f!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_2_%DA%A9%D8%AA%D8%A7%D8%A8%D8%AE%D8%A7%D9%86%D9%87_%D9%87%D8%A7%DB%8C_Dash_%D9%88_Psycopg2_%D8%B1%D8%A7_%D9%86%D8%B5%D8%A8_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 2: \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc Dash \u0648 Psycopg2 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u062f\u0634 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0646\u0635\u0628 \u062f\u0634 \u062f\u0631 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0646\u06cc\u0632 \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f.  \u0627\u0635\u0648\u0644\u0627\u064b \u0628\u0627\u06cc\u062f \u062f\u0648 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 (\u062e\u0648\u062f \u062f\u0627\u0634 \u0648 \u067e\u0627\u0646\u062f\u0627\u0647\u0627) \u0631\u0627 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u0645 <code>pip install<\/code> \u062f\u0633\u062a\u0648\u0631:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code><span class=\"c\"># This also brings along the Plotly graphing library.<\/span>\n<span class=\"c\"># Plotly is known for its interactive charts<\/span>\n<span class=\"c\"># Plotly Express requires Pandas to be installed too.<\/span>\npip <span class=\"nb\">install <\/span>dash pandas\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>\u0645\u0627 \u0647\u0645 \u0628\u0627\u06cc\u062f \u0646\u0635\u0628 \u06a9\u0646\u06cc\u0645 <code>[psycopg2](https:\/\/pypi.org\/project\/psycopg2\/)<\/code> \u0628\u0631\u0627\u06cc \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u0631\u06cc\u0627\u0646 RisingWave:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"n\">pip<\/span> <span class=\"n\">install<\/span> <span class=\"n\">psycopg2<\/span><span class=\"o\">-<\/span><span class=\"n\">binary<\/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=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_3_%DB%8C%DA%A9_%D9%85%D9%86%D8%A8%D8%B9_%D8%AF%D8%A7%D8%AF%D9%87_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 3: \u06cc\u06a9 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0628\u0627 RisingWave\u060c \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f.  \u062f\u0631 \u067e\u0631\u0648\u0698\u0647 \u0646\u0645\u0627\u06cc\u0634\u06cc\u060c \u06a9\u0627\u0641\u06a9\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u062a\u0639\u0631\u06cc\u0641 \u0634\u0648\u062f.  \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u062c\u062f\u06cc\u062f \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 <code>create-a-source.py<\/code> \u062f\u0631 \u0647\u0645\u0627\u0646 <code>integration_tests\/delivery<\/code> \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0628\u0627 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u067e\u0627\u06cc\u062a\u0648\u0646 \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0628\u0647 RisingWave \u0645\u062a\u0635\u0644 \u0645\u06cc\u200c\u0634\u0648\u06cc\u0645 \u0648 \u062c\u062f\u0648\u0644\u06cc \u0628\u0631\u0627\u06cc \u0645\u0635\u0631\u0641 \u0648 \u0645\u0627\u0646\u062f\u06af\u0627\u0631\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645. <code>delivery_orders<\/code> \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627  \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u062c\u062f\u06cc\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">psycopg2<\/span>\n\n<span class=\"n\">conn<\/span> <span class=\"o\">=<\/span> <span class=\"n\">psycopg2<\/span><span class=\"p\">.<\/span><span class=\"n\">connect<\/span><span class=\"p\">(<\/span><span class=\"n\">database<\/span><span class=\"o\">=<\/span><span class=\"s\">\"dev\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">user<\/span><span class=\"o\">=<\/span><span class=\"s\">\"root\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">password<\/span><span class=\"o\">=<\/span><span class=\"s\">\"\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">host<\/span><span class=\"o\">=<\/span><span class=\"s\">\"localhost\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">port<\/span><span class=\"o\">=<\/span><span class=\"s\">\"4566\"<\/span><span class=\"p\">)<\/span> <span class=\"c1\"># Connect to RisingWave.\n<\/span>\n<span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">autocommit<\/span> <span class=\"o\">=<\/span> <span class=\"bp\">True<\/span> <span class=\"c1\"># Set queries to be automatically committed.\n<\/span>\n<span class=\"k\">with<\/span> <span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">cursor<\/span><span class=\"p\">()<\/span> <span class=\"k\">as<\/span> <span class=\"n\">cur<\/span><span class=\"p\">:<\/span>\n    <span class=\"n\">cur<\/span><span class=\"p\">.<\/span><span class=\"n\">execute<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\"\"\nCREATE TABLE delivery_orders_source (\n    order_id BIGINT,\n    restaurant_id BIGINT,\n    order_state VARCHAR,\n    order_timestamp TIMESTAMP\n) WITH (\n    connector=\"kafka\",\n    topic=\"delivery_orders\",\n    properties.bootstrap.server=\"message_queue:29092\",\n    scan.startup.mode=\"earliest\"\n) ROW FORMAT JSON;\"\"\"<\/span><span class=\"p\">)<\/span> <span class=\"c1\"># Execute the query.\n<\/span>\n<span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">close<\/span><span class=\"p\">()<\/span> <span class=\"c1\"># Close the connection.\n<\/span><\/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>\u067e\u0633 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u0641\u0627\u06cc\u0644\u060c \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u06cc\u062f <code>python create-a-source.py<\/code> \u0648 \u062c\u062f\u0648\u0644 \u0645\u0646\u0628\u0639 \u0631\u0627 \u062f\u0631 RisingWave \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_4_%DB%8C%DA%A9_%D9%86%D9%85%D8%A7%DB%8C_%D9%85%D8%A7%D8%AF%DB%8C_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 4: \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0645\u0627 \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u062c\u062f\u06cc\u062f \u0645\u0634\u0627\u0628\u0647 \u0646\u062d\u0648\u0647 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645\u060c \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u062c\u062f\u06cc\u062f \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>create-a-materialized-view.py<\/code> \u0648 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc SQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>psycopg2<\/code>  \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0627\u062f\u063a\u0627\u0645 \u062f\u0648 \u0645\u0631\u062d\u0644\u0647 \u0622\u062e\u0631 \u062f\u0631 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u067e\u0627\u06cc\u062a\u0648\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">psycopg2<\/span>\n\n<span class=\"n\">conn<\/span> <span class=\"o\">=<\/span> <span class=\"n\">psycopg2<\/span><span class=\"p\">.<\/span><span class=\"n\">connect<\/span><span class=\"p\">(<\/span><span class=\"n\">database<\/span><span class=\"o\">=<\/span><span class=\"s\">\"dev\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">user<\/span><span class=\"o\">=<\/span><span class=\"s\">\"root\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">password<\/span><span class=\"o\">=<\/span><span class=\"s\">\"\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">host<\/span><span class=\"o\">=<\/span><span class=\"s\">\"localhost\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">port<\/span><span class=\"o\">=<\/span><span class=\"s\">\"4566\"<\/span><span class=\"p\">)<\/span>\n<span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">autocommit<\/span> <span class=\"o\">=<\/span> <span class=\"bp\">True<\/span>\n\n<span class=\"k\">with<\/span> <span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">cursor<\/span><span class=\"p\">()<\/span> <span class=\"k\">as<\/span> <span class=\"n\">cur<\/span><span class=\"p\">:<\/span>\n    <span class=\"n\">cur<\/span><span class=\"p\">.<\/span><span class=\"n\">execute<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\"\"CREATE MATERIALIZED VIEW restaurant_orders_view AS\nSELECT\n    window_start,\n    restaurant_id,\n    COUNT(*) AS total_order\nFROM\n    HOP(delivery_orders_source, order_timestamp, INTERVAL '1' MINUTE, INTERVAL '15' MINUTE)\nWHERE\n        order_state=\"CREATED\"\nGROUP BY\n    restaurant_id,\n    window_start;\"\"\"<\/span><span class=\"p\">)<\/span>\n\n<span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">close<\/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>\u062f\u0631 \u0628\u0627\u0644\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc SQL \u062a\u0639\u062f\u0627\u062f \u06a9\u0644 \u0633\u0641\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u0631\u0633\u062a\u0648\u0631\u0627\u0646 \u062e\u0627\u0635 \u062f\u0631 15 \u062f\u0642\u06cc\u0642\u0647 \u06af\u0630\u0634\u062a\u0647 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.  \u0627\u06af\u0631 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u062f\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u062a\u0641\u0627\u0642 \u0628\u06cc\u0641\u062a\u062f \u06cc\u0627 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u062c\u062f\u06cc\u062f \u06a9\u0627\u0641\u06a9\u0627 \u0627\u0632 \u0631\u0627\u0647 \u0628\u0631\u0633\u062f\u060c RisingWave <strong>\u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0648 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0645\u06cc \u0634\u0648\u062f<\/strong> \u0646\u062a\u06cc\u062c\u0647 \u0646\u06af\u0627\u0647 \u0645\u0627\u062f\u06cc \u0634\u062f\u0647  \u067e\u0633 \u0627\u0632 \u062a\u0646\u0638\u06cc\u0645 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647\u060c \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0634\u0631\u0648\u0639 \u0628\u0647 \u062f\u0631\u06cc\u0627\u0641\u062a \u062f\u0627\u062f\u0647 \u0647\u0627 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Dash \u062a\u062c\u0633\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_5_%D8%B3%D8%A7%D8%AE%D8%AA_%D8%A7%D9%BE%D9%84%DB%8C%DA%A9%DB%8C%D8%B4%D9%86_Dash\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 5: \u0633\u0627\u062e\u062a \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 Dash<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u0645\u0627 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Dash \u062e\u0648\u062f \u0631\u0627 \u0645\u06cc\u200c\u0633\u0627\u0632\u06cc\u0645 \u062a\u0627 \u0645\u062d\u062a\u0648\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647\u200c\u0627\u06cc \u06a9\u0647 \u062f\u0631 RisingWave \u062f\u0627\u0631\u06cc\u0645 \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u0648 \u062a\u062c\u0633\u0645 \u06a9\u0646\u06cc\u0645.  \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0645\u0648\u0632\u0634 Dash \u0631\u0627 \u062f\u0631 20 \u062f\u0642\u06cc\u0642\u0647 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0644\u0648\u06a9 \u0647\u0627\u06cc \u0627\u0635\u0644\u06cc Dash \u0631\u0627 \u062f\u0631\u06a9 \u06a9\u0646\u06cc\u062f.  \u06a9\u062f \u0628\u0631\u0646\u0627\u0645\u0647 \u0645\u062b\u0627\u0644 \u0645\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0641\u0627\u0631\u0634\u0627\u062a \u0631\u0633\u062a\u0648\u0631\u0627\u0646 \u0631\u0627 \u062f\u0631 \u062f\u0648 \u0642\u0627\u0644\u0628 \u062c\u062f\u0648\u0644 \u0648 \u0646\u0645\u0648\u062f\u0627\u0631 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u062f.  \u06a9\u062f \u067e\u0627\u06cc\u062a\u0648\u0646 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f <code>dash-example.py<\/code> :<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">psycopg2<\/span>\n<span class=\"kn\">import<\/span> <span class=\"nn\">pandas<\/span> <span class=\"k\">as<\/span> <span class=\"n\">pd<\/span>\n<span class=\"kn\">import<\/span> <span class=\"nn\">dash<\/span>\n<span class=\"kn\">from<\/span> <span class=\"nn\">dash<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">dash_table<\/span>\n<span class=\"kn\">from<\/span> <span class=\"nn\">dash<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">dcc<\/span>\n<span class=\"kn\">import<\/span> <span class=\"nn\">dash_html_components<\/span> <span class=\"k\">as<\/span> <span class=\"n\">html<\/span>\n<span class=\"kn\">import<\/span> <span class=\"nn\">plotly.express<\/span> <span class=\"k\">as<\/span> <span class=\"n\">px<\/span>\n\n<span class=\"c1\"># Connect to the PostgreSQL database\n<\/span><span class=\"n\">conn<\/span> <span class=\"o\">=<\/span> <span class=\"n\">psycopg2<\/span><span class=\"p\">.<\/span><span class=\"n\">connect<\/span><span class=\"p\">(<\/span><span class=\"n\">database<\/span><span class=\"o\">=<\/span><span class=\"s\">\"dev\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">user<\/span><span class=\"o\">=<\/span><span class=\"s\">\"root\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">password<\/span><span class=\"o\">=<\/span><span class=\"s\">\"\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">host<\/span><span class=\"o\">=<\/span><span class=\"s\">\"localhost\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">port<\/span><span class=\"o\">=<\/span><span class=\"s\">\"4566\"<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Retrieve data from the materialized view using pandas\n<\/span><span class=\"n\">df<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pd<\/span><span class=\"p\">.<\/span><span class=\"n\">read_sql_query<\/span><span class=\"p\">(<\/span><span class=\"s\">\"SELECT window_start, restaurant_id, total_order FROM restaurant_orders_view;\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">conn<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Create a Dash application\n<\/span><span class=\"n\">app<\/span> <span class=\"o\">=<\/span> <span class=\"n\">dash<\/span><span class=\"p\">.<\/span><span class=\"n\">Dash<\/span><span class=\"p\">(<\/span><span class=\"n\">__name__<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Define layout\n<\/span><span class=\"n\">app<\/span><span class=\"p\">.<\/span><span class=\"n\">layout<\/span> <span class=\"o\">=<\/span> <span class=\"n\">html<\/span><span class=\"p\">.<\/span><span class=\"n\">Div<\/span><span class=\"p\">(<\/span><span class=\"n\">children<\/span><span class=\"o\">=<\/span><span class=\"p\">[<\/span>\n    <span class=\"n\">html<\/span><span class=\"p\">.<\/span><span class=\"n\">H1<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Restaurant Orders Table\"<\/span><span class=\"p\">),<\/span>\n    <span class=\"n\">dash_table<\/span><span class=\"p\">.<\/span><span class=\"n\">DataTable<\/span><span class=\"p\">(<\/span><span class=\"nb\">id<\/span><span class=\"o\">=<\/span><span class=\"s\">\"restaurant_orders_table\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">columns<\/span><span class=\"o\">=<\/span><span class=\"p\">[{<\/span><span class=\"s\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"n\">i<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"n\">i<\/span><span class=\"p\">}<\/span> <span class=\"k\">for<\/span> <span class=\"n\">i<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">df<\/span><span class=\"p\">.<\/span><span class=\"n\">columns<\/span><span class=\"p\">],<\/span> <span class=\"n\">data<\/span><span class=\"o\">=<\/span><span class=\"n\">df<\/span><span class=\"p\">.<\/span><span class=\"n\">to_dict<\/span><span class=\"p\">(<\/span><span class=\"s\">\"records\"<\/span><span class=\"p\">),<\/span> <span class=\"n\">page_size<\/span><span class=\"o\">=<\/span><span class=\"mi\">10<\/span><span class=\"p\">),<\/span>\n    <span class=\"n\">html<\/span><span class=\"p\">.<\/span><span class=\"n\">H1<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Restaurant Orders Graph\"<\/span><span class=\"p\">),<\/span>\n    <span class=\"n\">dcc<\/span><span class=\"p\">.<\/span><span class=\"n\">Graph<\/span><span class=\"p\">(<\/span><span class=\"nb\">id<\/span><span class=\"o\">=<\/span><span class=\"s\">\"restaurant_orders_graph\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">figure<\/span><span class=\"o\">=<\/span><span class=\"n\">px<\/span><span class=\"p\">.<\/span><span class=\"n\">bar<\/span><span class=\"p\">(<\/span><span class=\"n\">df<\/span><span class=\"p\">,<\/span> <span class=\"n\">x<\/span><span class=\"o\">=<\/span><span class=\"s\">\"window_start\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">y<\/span><span class=\"o\">=<\/span><span class=\"s\">\"total_order\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">color<\/span><span class=\"o\">=<\/span><span class=\"s\">\"restaurant_id\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">barmode<\/span><span class=\"o\">=<\/span><span class=\"s\">\"group\"<\/span><span class=\"p\">))<\/span>\n<span class=\"p\">])<\/span>\n\n<span class=\"c1\"># Run the application\n<\/span><span class=\"k\">if<\/span> <span class=\"n\">__name__<\/span> <span class=\"o\">==<\/span> <span class=\"s\">'__main__'<\/span><span class=\"p\">:<\/span>\n    <span class=\"n\">app<\/span><span class=\"p\">.<\/span><span class=\"n\">run_server<\/span><span class=\"p\">(<\/span><span class=\"n\">debug<\/span><span class=\"o\">=<\/span><span class=\"bp\">True<\/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 \u0642\u0637\u0639\u0647 \u06a9\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0642\u0633\u0645\u062a \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f <strong><code>restaurant_orders_view<\/code><\/strong>  \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u0646\u062f\u0627\u0647\u0627 \u0648 \u0646\u0645\u0627\u06cc\u0634 \u0622\u0646 \u062f\u0631 \u062c\u062f\u0648\u0644 \u062f\u0627\u0634 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong><code>dash_table.DataTable<\/code><\/strong>  \u0648 \u0646\u0645\u0648\u062f\u0627\u0631 \u0645\u06cc\u0644\u0647 \u0627\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>dcc.Graph<\/code>.  \u062c\u062f\u0648\u0644 \u0648 \u0646\u0645\u0648\u062f\u0627\u0631 \u0645\u06cc\u0644\u0647\u200c\u0627\u06cc \u062f\u0627\u0631\u0627\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642\u200c\u06cc\u0627\u0641\u062a\u0647 (&#8220;window_start&#8221;\u060c &#8220;total_order&#8221; \u0648 &#8220;restaurant_id&#8221;) \u0648 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642\u200c\u06cc\u0627\u0641\u062a\u0647 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f. <\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_6_%D9%86%D8%AA%D8%A7%DB%8C%D8%AC_%D8%B1%D8%A7_%D9%85%D8%B4%D8%A7%D9%87%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  <strong>\u0645\u0631\u062d\u0644\u0647 6: \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u0628\u0627\u0644\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <code>dash-example.py<\/code> \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0648 \u067e\u06cc\u0645\u0627\u06cc\u0634 \u0628\u0647 <strong><code>http:\/\/localhost:8050\/<\/code><\/strong>  \u062f\u0631 \u0645\u0631\u0648\u0631\u06af\u0631 \u0648\u0628 \u062e\u0648\u062f (\u067e\u06cc\u0627\u0645\u06cc \u062f\u0631 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0645\u06cc \u06af\u0648\u06cc\u062f \u0628\u0647 \u0627\u06cc\u0646 \u067e\u06cc\u0648\u0646\u062f \u0628\u0631\u0648\u06cc\u062f).<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/06\/1686960502_962_\u062a\u062c\u0633\u0645-\u062f\u0627\u062f\u0647-\u0647\u0627\u06cc-\u0632\u0645\u0627\u0646-\u0648\u0627\u0642\u0639\u06cc-\u0628\u0627-\u067e\u0627\u06cc\u062a\u0648\u0646\u060c-\u062f\u0627\u0634-\u0648-\u0627\u0641\u0632\u0627\u06cc\u0634.png\" alt=\"\u062a\u062c\u0633\u0645 \u0646\u0645\u0627\u06cc \u062a\u062c\u0633\u0645 \u06cc\u0627\u0641\u062a\u0647 \u062f\u0627\u0634\" loading=\"lazy\" width=\"800\" height=\"264\" title=\"\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AE%D9%84%D8%A7%D8%B5%D9%87\"><\/span>\n<p>  \u062e\u0644\u0627\u0635\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0647 \u0637\u0648\u0631 \u06a9\u0644\u06cc\u060c Dash \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644\u06cc \u062f\u0627\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0631\u0627\u0628\u0637 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0648 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f\u060c \u0647\u0645\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0627\u062f\u06af\u06cc \u0648 \u0638\u0631\u0627\u0641\u062a \u0632\u0628\u0627\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646.  \u0648\u0642\u062a\u06cc \u0627\u0632 \u0622\u0646 \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0631\u06cc\u0645 RisingWave \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u060c \u0628\u06cc\u0646\u0634\u200c\u0647\u0627\u06cc\u06cc \u062f\u0631\u0628\u0627\u0631\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u0628\u0647 \u062f\u0633\u062a \u0645\u06cc\u200c\u0622\u0648\u0631\u06cc\u0645 \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0647 \u0645\u0627 \u062f\u0631 \u062a\u0635\u0645\u06cc\u0645\u200c\u06af\u06cc\u0631\u06cc \u0622\u06af\u0627\u0647\u0627\u0646\u0647\u200c\u062a\u0631 \u0648 \u0627\u0642\u062f\u0627\u0645 \u0628\u0631\u0627\u06cc \u0628\u0647\u06cc\u0646\u0647\u200c\u0633\u0627\u0632\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u06a9\u0645\u06a9 \u06a9\u0646\u06cc\u0645.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D9%86%D8%A7%D8%A8%D8%B9_%D9%85%D8%B1%D8%AA%D8%A8%D8%B7\"><\/span>\n<p>  \u0645\u0646\u0627\u0628\u0639 \u0645\u0631\u062a\u0628\u0637<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%AD%D8%AA%D9%88%D8%A7%DB%8C_%D9%BE%DB%8C%D8%B4%D9%86%D9%87%D8%A7%D8%AF%DB%8C\"><\/span>\n<p>  \u0645\u062d\u062a\u0648\u0627\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A7%D9%86%D8%AC%D9%85%D9%86\"><\/span>\n<p>  \u0627\u0646\u062c\u0645\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\ud83d\ude4b \u0628\u0647 \u0627\u0646\u062c\u0645\u0646 Risingwave \u0628\u067e\u06cc\u0648\u0646\u062f\u06cc\u062f<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AF%D8%B1%D8%A8%D8%A7%D8%B1%D9%87_%D9%86%D9%88%DB%8C%D8%B3%D9%86%D8%AF%D9%87\"><\/span>\n<p>  \u062f\u0631\u0628\u0627\u0631\u0647 \u0646\u0648\u06cc\u0633\u0646\u062f\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0628\u0631\u0627\u06cc \u06a9\u0633\u0628 \u0648 \u06a9\u0627\u0631\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u0635\u0645\u06cc\u0645 \u06af\u06cc\u0631\u06cc \u0633\u0631\u06cc\u0639 \u0645\u0647\u0645 \u0627\u0633\u062a. \u062f\u06cc\u062f\u0646 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0628\u0635\u0631\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u062a\u0635\u0645\u06cc\u0645 \u06af\u06cc\u0631\u06cc \u0633\u0631\u06cc\u0639\u062a\u0631 \u06a9\u0645\u06a9 \u06a9\u0646\u062f. \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u06cc\u0627 \u062f\u0627\u0634\u0628\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u0646\u0645\u0627\u06cc\u0634 \u0647\u0627\u06cc \u0628\u0635\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645. \u062f\u0627\u0634 \u0627\u0633\u062a \u06cc\u06a9 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u067e\u0627\u06cc\u062a\u0648\u0646 \u06a9\u0647 \u0637\u06cc\u0641 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":27236,"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-27235","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\/27235","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=27235"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/27235\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/27236"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=27235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=27235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=27235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}