{"id":108738,"date":"2025-05-13T01:18:14","date_gmt":"2025-05-12T21:48:14","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/"},"modified":"2025-05-13T01:18:14","modified_gmt":"2025-05-12T21:48:14","slug":"%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/","title":{"rendered":"\u0647\u0645\u06a9\u0627\u0631\u06cc \u0628\u0627 JSON \u062f\u0631 PostgreSQL \u060c MySQL \u0648 SQL Server"},"content":{"rendered":"<div data-article-id=\"2482139\" id=\"article-body\">\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fl6owcqjok3wsthlx139n.png\" alt=\"  \u0647\u0645\u06a9\u0627\u0631\u06cc \u0628\u0627 JSON \u062f\u0631 PostgreSQL \u060c MySQL \u0648 SQL Server\" loading=\"lazy\" width=\"800\" height=\"533\" title=\"\"><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u062a\u063a\u06cc\u06cc\u0631 \u0648\u0636\u0639\u06cc\u062a \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D9%87%D9%85%DA%A9%D8%A7%D8%B1%DB%8C_%D8%A8%D8%A7_JSON_%D8%AF%D8%B1_PostgreSQL_%D8%8C_MySQL_%D9%88_SQL_Server\" >\u0647\u0645\u06a9\u0627\u0631\u06cc \u0628\u0627 JSON \u062f\u0631 PostgreSQL \u060c MySQL \u0648 SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%B3%D8%AA%D9%88%D9%86%D9%87%D8%A7%DB%8C_JSON_%D8%B1%D8%A7_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0633\u062a\u0648\u0646\u0647\u0627\u06cc JSON \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \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\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#postgresql\" >postgresql:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#mysql\" >mysql:<\/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\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%B3%D8%B1%D9%88%D8%B1_SQL\" >\u0633\u0631\u0648\u0631 SQL:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC_%D9%85%D9%82%D8%A7%D8%AF%DB%8C%D8%B1_JSON\" >\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u0642\u0627\u062f\u06cc\u0631 JSON<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#postgresql-2\" >postgresql:<\/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\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#mysql-2\" >mysql:<\/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\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%B3%D8%B1%D9%88%D8%B1_SQL-2\" >\u0633\u0631\u0648\u0631 SQL:<\/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\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%DA%A9%D9%84_%D8%A7%D8%B4%DB%8C%D8%A7%D8%A1_JSON_%D8%B1%D8%A7_%D8%B0%D8%AE%DB%8C%D8%B1%D9%87_%D9%88_%D8%A8%D8%A7%D8%B2%DB%8C%D8%A7%D8%A8%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\" >\u06a9\u0644 \u0627\u0634\u06cc\u0627\u0621 JSON \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0648 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \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-11\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%AF%D8%B1%D8%AC_%DA%A9%D8%A7%D9%85%D9%84_%D8%B4%DB%8C%D8%A1\" >\u062f\u0631\u062c \u06a9\u0627\u0645\u0644 \u0634\u06cc\u0621:<\/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\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D9%85%D9%88%D8%B1%D8%AF_%DA%A9%D8%A7%D9%85%D9%84\" >\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0648\u0631\u062f \u06a9\u0627\u0645\u0644:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%AF%D8%B1_%D8%AC%D8%A7%DB%8C%DB%8C_%DA%A9%D9%87_%D8%A8%D9%86%D8%AF%D9%87%D8%A7_%D8%A7%D8%B2_JSON_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >\u062f\u0631 \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0646\u062f\u0647\u0627 \u0627\u0632 JSON \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D9%86%D9%85%D8%A7%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_JSON\" >\u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc JSON<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#postgresql_%D9%81%D9%82%D8%B7_JSONB\" >postgresql (\u0641\u0642\u0637 JSONB):<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#mysql-3\" >mysql:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%B3%D8%B1%D9%88%D8%B1_SQL-3\" >\u0633\u0631\u0648\u0631 SQL:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%AE%D8%B1%D9%88%D8%AC%DB%8C_JSON_%D8%A7%D8%B2_SQL\" >\u062e\u0631\u0648\u062c\u06cc JSON \u0627\u0632 SQL<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#postgresql-3\" >postgresql:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%B3%D8%B1%D9%88%D8%B1_SQL-4\" >\u0633\u0631\u0648\u0631 SQL:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#mysql-4\" >mysql:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%A7%D8%B2_%D9%85%D9%88%D8%A7%D8%B1%D8%AF%DB%8C_%D8%A8%D8%B1%D8%A7%DB%8C_JSON_%D8%AF%D8%B1_SQL_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0627\u0632 \u0645\u0648\u0627\u0631\u062f\u06cc \u0628\u0631\u0627\u06cc JSON \u062f\u0631 SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/nabfollower.com\/blog\/%d9%87%d9%85%da%a9%d8%a7%d8%b1%db%8c-%d8%a8%d8%a7-json-%d8%af%d8%b1-postgresql-%d8%8c-mysql-%d9%88-sql-server\/#%D8%A7%D9%81%DA%A9%D8%A7%D8%B1_%D9%86%D9%87%D8%A7%DB%8C%DB%8C_JSON_%D9%81%D9%82%D8%B7_%D8%A8%D8%B1%D8%A7%DB%8C_NOSQL_%D9%86%DB%8C%D8%B3%D8%AA\" >\u0627\u0641\u06a9\u0627\u0631 \u0646\u0647\u0627\u06cc\u06cc: JSON \u0641\u0642\u0637 \u0628\u0631\u0627\u06cc NOSQL \u0646\u06cc\u0633\u062a<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%87%D9%85%DA%A9%D8%A7%D8%B1%DB%8C_%D8%A8%D8%A7_JSON_%D8%AF%D8%B1_PostgreSQL_%D8%8C_MySQL_%D9%88_SQL_Server\"><\/span>\n<p>  \u0647\u0645\u06a9\u0627\u0631\u06cc \u0628\u0627 JSON \u062f\u0631 PostgreSQL \u060c MySQL \u0648 SQL Server<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>&#8220;\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u0647\u0645\u06cc\u0634\u0647 \u0645\u0633\u0637\u062d \u0646\u06cc\u0633\u062a &#8211; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u06af\u0627\u0646 \u0634\u0645\u0627 \u0646\u06cc\u0632 \u0646\u0628\u0627\u06cc\u062f \u0628\u0627\u0634\u0646\u062f.&#8221;<\/p>\n<\/blockquote>\n<p>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc SQL \u0628\u0631\u0627\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u062a\u06a9\u0627\u0645\u0644 \u06cc\u0627\u0641\u062a\u0647 \u0627\u0646\u062f <strong>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0646\u06cc\u0645\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u06cc\u0627\u0641\u062a\u0647<\/strong>\u060c \u0628\u0647 \u062e\u0635\u0648\u0635 JSON \u060c \u062f\u0631 \u06a9\u0646\u0627\u0631 \u0645\u062f\u0644 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0633\u0646\u062a\u06cc. \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062a\u0631\u06a9\u06cc\u0628\u06cc \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<ul>\n<li>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u063a\u0646\u06cc \u0627\u0632 \u062a\u0648 \u062f\u0631 \u062a\u0648 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u0628\u0627 \u0637\u0631\u062d \u0647\u0627\u06cc \u062f\u0631 \u062d\u0627\u0644 \u062a\u062d\u0648\u0644 \u0633\u0627\u0632\u06af\u0627\u0631 \u0634\u0648\u06cc\u062f<\/li>\n<li>\u0628\u0627 \u0647\u0645 \u0628\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a \u06cc\u0627\u0641\u062a\u0647 \u0648 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u0628\u067e\u06cc\u0648\u0646\u062f\u06cc\u062f<\/li>\n<\/ul>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u060c \u0645\u0627 \u067e\u0648\u0634\u0634 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f:<\/p>\n<ul>\n<li>\u0627\u0646\u0648\u0627\u0639 \u0633\u062a\u0648\u0646 JSON<\/li>\n<li>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627\u06cc \u062a\u0648 \u062f\u0631 \u062a\u0648<\/li>\n<li>\u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0628\u0631\u0627\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f<\/li>\n<li>\u0646\u0645\u0648\u0646\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062a\u0642\u0627\u0628\u0644 \u062f\u0631 \u0633\u0631\u0648\u0631 PostgresQL \u060c MySQL \u0648 SQL<\/li>\n<\/ul>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B3%D8%AA%D9%88%D9%86%D9%87%D8%A7%DB%8C_JSON_%D8%B1%D8%A7_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0633\u062a\u0648\u0646\u0647\u0627\u06cc JSON \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"postgresql\"><\/span>\n<p>  postgresql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\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\">users<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">id<\/span> <span class=\"nb\">SERIAL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">profile<\/span> <span class=\"n\">JSONB<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"mysql\"><\/span>\n<p>  mysql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\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\">users<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">id<\/span> <span class=\"nb\">INT<\/span> <span class=\"n\">AUTO_INCREMENT<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">profile<\/span> <span class=\"n\">JSON<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D8%B1%D9%88%D8%B1_SQL\"><\/span>\n<p>  \u0633\u0631\u0648\u0631 SQL:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\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\">users<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">id<\/span> <span class=\"nb\">INT<\/span> <span class=\"k\">IDENTITY<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">profile<\/span> <span class=\"n\">NVARCHAR<\/span><span class=\"p\">(<\/span><span class=\"k\">MAX<\/span><span class=\"p\">)<\/span> <span class=\"c1\">-- must be valid JSON<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC_%D9%85%D9%82%D8%A7%D8%AF%DB%8C%D8%B1_JSON\"><\/span>\n<p>  \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u0642\u0627\u062f\u06cc\u0631 JSON<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"postgresql-2\"><\/span>\n<p>  postgresql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Extract scalar field<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">profile<\/span><span class=\"o\">-&gt;&gt;<\/span><span class=\"s1\">'name'<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Extract nested object<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">profile<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'address'<\/span><span class=\"o\">-&gt;&gt;<\/span><span class=\"s1\">'city'<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">city<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"mysql-2\"><\/span>\n<p>  mysql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Extract with JSON_EXTRACT<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.name'<\/span><span class=\"p\">))<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Nested access<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.address.city'<\/span><span class=\"p\">))<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">city<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D8%B1%D9%88%D8%B1_SQL-2\"><\/span>\n<p>  \u0633\u0631\u0648\u0631 SQL:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Extract scalar field<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">JSON_VALUE<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.name'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Extract nested object<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">JSON_VALUE<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.address.city'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">city<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%DA%A9%D9%84_%D8%A7%D8%B4%DB%8C%D8%A7%D8%A1_JSON_%D8%B1%D8%A7_%D8%B0%D8%AE%DB%8C%D8%B1%D9%87_%D9%88_%D8%A8%D8%A7%D8%B2%DB%8C%D8%A7%D8%A8%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u06a9\u0644 \u0627\u0634\u06cc\u0627\u0621 JSON \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0648 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AF%D8%B1%D8%AC_%DA%A9%D8%A7%D9%85%D9%84_%D8%B4%DB%8C%D8%A1\"><\/span>\n<p>  \u062f\u0631\u062c \u06a9\u0627\u0645\u0644 \u0634\u06cc\u0621:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">users<\/span> <span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">)<\/span>\n<span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'{\"name\": \"Ada\", \"skills\": [\"SQL\", \"Python\"]}'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D9%85%D9%88%D8%B1%D8%AF_%DA%A9%D8%A7%D9%85%D9%84\"><\/span>\n<p>  \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0648\u0631\u062f \u06a9\u0627\u0645\u0644:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">profile<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AF%D8%B1_%D8%AC%D8%A7%DB%8C%DB%8C_%DA%A9%D9%87_%D8%A8%D9%86%D8%AF%D9%87%D8%A7_%D8%A7%D8%B2_JSON_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u062f\u0631 \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0646\u062f\u0647\u0627 \u0627\u0632 JSON \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Get users with SQL skill<\/span>\n<span class=\"c1\">-- PostgreSQL<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">profile<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'skills'<\/span> <span class=\"o\">?<\/span> <span class=\"s1\">'SQL'<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- MySQL<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">JSON_CONTAINS<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"o\">-&gt;<\/span><span class=\"s1\">'$.skills'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'\"SQL\"'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- SQL Server<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">JSON_QUERY<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.skills'<\/span><span class=\"p\">)<\/span> <span class=\"k\">LIKE<\/span> <span class=\"s1\">'%SQL%'<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_JSON\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc JSON<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"postgresql_%D9%81%D9%82%D8%B7_JSONB\"><\/span>\n<p>  postgresql (\u0641\u0642\u0637 JSONB):<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Index top-level key<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">idx_profile_name<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">users<\/span> <span class=\"p\">((<\/span><span class=\"n\">profile<\/span><span class=\"o\">-&gt;&gt;<\/span><span class=\"s1\">'name'<\/span><span class=\"p\">));<\/span>\n\n<span class=\"c1\">-- Full GIN index<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">idx_profile_json<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">users<\/span> <span class=\"k\">USING<\/span> <span class=\"n\">GIN<\/span> <span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"mysql-3\"><\/span>\n<p>  mysql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Generated column (MySQL 5.7+)<\/span>\n<span class=\"k\">ALTER<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">users<\/span> <span class=\"k\">ADD<\/span> <span class=\"n\">name_gen<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">255<\/span><span class=\"p\">)<\/span> <span class=\"k\">GENERATED<\/span> <span class=\"n\">ALWAYS<\/span> <span class=\"k\">AS<\/span> <span class=\"p\">(<\/span><span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.name'<\/span><span class=\"p\">)))<\/span> <span class=\"n\">STORED<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">idx_name_gen<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">users<\/span><span class=\"p\">(<\/span><span class=\"n\">name_gen<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D8%B1%D9%88%D8%B1_SQL-3\"><\/span>\n<p>  \u0633\u0631\u0648\u0631 SQL:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Create computed column<\/span>\n<span class=\"k\">ALTER<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">users<\/span> <span class=\"k\">ADD<\/span> <span class=\"n\">name<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">JSON_VALUE<\/span><span class=\"p\">(<\/span><span class=\"n\">profile<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.name'<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">idx_name<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">users<\/span><span class=\"p\">(<\/span><span class=\"n\">name<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>actives \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u0641\u0647\u0631\u0633\u062a \u0634\u062f\u0647 \u0628\u0627\u0639\u062b \u0627\u0641\u0632\u0627\u06cc\u0634 \u0639\u0645\u0644\u06a9\u0631\u062f \u062f\u0631 \u0645\u062d\u0644 \u0648 \u067e\u06cc\u0648\u0633\u062a\u0646 \u0628\u0647 \u0628\u0646\u062f\u0647\u0627 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AE%D8%B1%D9%88%D8%AC%DB%8C_JSON_%D8%A7%D8%B2_SQL\"><\/span>\n<p>  \u062e\u0631\u0648\u062c\u06cc JSON \u0627\u0632 SQL<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"postgresql-3\"><\/span>\n<p>  postgresql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">jsonb_build_object<\/span><span class=\"p\">(<\/span><span class=\"s1\">'id'<\/span><span class=\"p\">,<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'profile'<\/span><span class=\"p\">,<\/span> <span class=\"n\">profile<\/span><span class=\"p\">)<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B3%D8%B1%D9%88%D8%B1_SQL-4\"><\/span>\n<p>  \u0633\u0631\u0648\u0631 SQL:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">profile<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span> <span class=\"k\">FOR<\/span> <span class=\"n\">JSON<\/span> <span class=\"n\">PATH<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"mysql-4\"><\/span>\n<p>  mysql:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"n\">JSON_OBJECT<\/span><span class=\"p\">(<\/span><span class=\"s1\">'id'<\/span><span class=\"p\">,<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'profile'<\/span><span class=\"p\">,<\/span> <span class=\"n\">profile<\/span><span class=\"p\">)<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">users<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B2_%D9%85%D9%88%D8%A7%D8%B1%D8%AF%DB%8C_%D8%A8%D8%B1%D8%A7%DB%8C_JSON_%D8%AF%D8%B1_SQL_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0627\u0632 \u0645\u0648\u0627\u0631\u062f\u06cc \u0628\u0631\u0627\u06cc JSON \u062f\u0631 SQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>\u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u06a9\u0627\u0631\u0628\u0631 \u067e\u0648\u06cc\u0627<\/li>\n<li>\u0633\u06cc\u0627\u0647\u0647\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0631\u0648\u06cc\u062f\u0627\u062f<\/li>\n<li>\u0628\u0627\u0631\u0647\u0627\u06cc \u0633\u0646\u0633\u0648\u0631 IoT<\/li>\n<li>\u062d\u0628\u0627\u0628 \u0647\u0627\u06cc \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc<\/li>\n<li>\u0627\u062f\u063a\u0627\u0645 \u0628\u0627 API<\/li>\n<\/ul>\n<hr\/>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D9%81%DA%A9%D8%A7%D8%B1_%D9%86%D9%87%D8%A7%DB%8C%DB%8C_JSON_%D9%81%D9%82%D8%B7_%D8%A8%D8%B1%D8%A7%DB%8C_NOSQL_%D9%86%DB%8C%D8%B3%D8%AA\"><\/span>\n<p>  \u0627\u0641\u06a9\u0627\u0631 \u0646\u0647\u0627\u06cc\u06cc: JSON \u0641\u0642\u0637 \u0628\u0631\u0627\u06cc NOSQL \u0646\u06cc\u0633\u062a<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u062f\u0631\u0646 JSON \u060c \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc SQL \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<ul>\n<li>\u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u0628\u0627\u0634\u06cc\u062f<\/li>\n<li>\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0648 \u062f\u0631 \u062a\u0648 \u06cc\u0627 \u067e\u0631\u0627\u06a9\u0646\u062f\u0647<\/li>\n<li>\u0627\u0632 Power SQL \u062f\u0631 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0646\u06cc\u0645\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u06cc\u0627\u0641\u062a\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/li>\n<\/ul>\n<blockquote>\n<p>&#8220;\u0628\u0647\u062a\u0631\u06cc\u0646 \u0647\u0627\u06cc \u0647\u0631 \u062f\u0648 \u062c\u0647\u0627\u0646: JSON \u0628\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 SQL.&#8221;<\/p>\n<\/blockquote>\n<p><em>#SQL #JSON #POSTGRESQL #MYSQL #SQLSERVER #SEMISTRUCTURUD<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0647\u0645\u06a9\u0627\u0631\u06cc \u0628\u0627 JSON \u062f\u0631 PostgreSQL \u060c MySQL \u0648 SQL Server &#8220;\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u0647\u0645\u06cc\u0634\u0647 \u0645\u0633\u0637\u062d \u0646\u06cc\u0633\u062a &#8211; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u06af\u0627\u0646 \u0634\u0645\u0627 \u0646\u06cc\u0632 \u0646\u0628\u0627\u06cc\u062f \u0628\u0627\u0634\u0646\u062f.&#8221; \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc SQL \u0628\u0631\u0627\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u062a\u06a9\u0627\u0645\u0644 \u06cc\u0627\u0641\u062a\u0647 \u0627\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0646\u06cc\u0645\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u06cc\u0627\u0641\u062a\u0647\u060c \u0628\u0647 \u062e\u0635\u0648\u0635 JSON \u060c \u062f\u0631 \u06a9\u0646\u0627\u0631 \u0645\u062f\u0644 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0633\u0646\u062a\u06cc. \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062a\u0631\u06a9\u06cc\u0628\u06cc \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":108739,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh4v2ks05ojzz04qgvata.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-108738","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\/108738","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=108738"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/108738\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/108739"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=108738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=108738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=108738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}