{"id":297,"date":"2026-01-25T01:58:48","date_gmt":"2026-01-24T17:58:48","guid":{"rendered":"https:\/\/skwp.zeabur.app\/2026\/01\/25\/%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9105-%e6%95%b4%e5%90%88%e5%af%a6%e6%88%b0%ef%bc%9a%e6%89%93%e9%80%a0%e5%ae%8c%e6%95%b4%e7%9a%84%e6%9c%83%e5%93%a1%e8%b3%87%e6%96%99%e7%b3%bb%e7%b5%b1\/"},"modified":"2026-01-25T01:58:48","modified_gmt":"2026-01-24T17:58:48","slug":"%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9105-%e6%95%b4%e5%90%88%e5%af%a6%e6%88%b0%ef%bc%9a%e6%89%93%e9%80%a0%e5%ae%8c%e6%95%b4%e7%9a%84%e6%9c%83%e5%93%a1%e8%b3%87%e6%96%99%e7%b3%bb%e7%b5%b1","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/01\/25\/%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9105-%e6%95%b4%e5%90%88%e5%af%a6%e6%88%b0%ef%bc%9a%e6%89%93%e9%80%a0%e5%ae%8c%e6%95%b4%e7%9a%84%e6%9c%83%e5%93%a1%e8%b3%87%e6%96%99%e7%b3%bb%e7%b5%b1\/","title":{"rendered":"\u3010Supabase \u6559\u5b78\u3011#05 \u6574\u5408\u5be6\u6230\uff1a\u6253\u9020\u5b8c\u6574\u7684\u6703\u54e1\u8cc7\u6599\u7cfb\u7d71"},"content":{"rendered":"\n<div id=\"quiz-basic\">\n<style>\n#quiz-basic .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-basic .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-basic .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-basic .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-basic .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-basic .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-basic .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-basic .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-basic .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-basic .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-basic .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-basic .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1aSupabase \u6574\u5408\u5be6\u6230 &#8211; \u6253\u9020\u5b8c\u6574\u7684\u6703\u54e1\u8cc7\u6599\u7cfb\u7d71<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. \u70ba\u4ec0\u9ebc\u9700\u8981\u5efa\u7acb\u7368\u7acb\u7684 profiles \u8868\uff0c\u800c\u4e0d\u662f\u76f4\u63a5\u4f7f\u7528 auth.users \u8868\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. auth.users \u8868\u7684\u6548\u80fd\u8f03\u5dee\uff0c\u7121\u6cd5\u8655\u7406\u5927\u91cf\u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. auth.users \u7121\u6cd5\u900f\u904e API \u76f4\u63a5\u5b58\u53d6\uff0c\u4e14\u6b04\u4f4d\u56fa\u5b9a\u7121\u6cd5\u81ea\u8a02<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. auth.users \u8868\u53ea\u80fd\u5b58\u653e\u5bc6\u78bc\uff0c\u4e0d\u80fd\u5b58\u653e\u5176\u4ed6\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. Supabase \u898f\u5b9a\u6bcf\u500b\u5c08\u6848\u5fc5\u9808\u5efa\u7acb profiles \u8868<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u5728 profiles \u8868\u7684\u4e3b\u9375\u8a2d\u8a08\u4e2d\uff0c<code>on delete cascade<\/code> \u7684\u4f5c\u7528\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u7576 profiles \u8a18\u9304\u88ab\u522a\u9664\u6642\uff0c\u540c\u6b65\u522a\u9664 auth.users \u8a18\u9304<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u9632\u6b62\u4efb\u4f55\u4eba\u522a\u9664 profiles \u6216 auth.users \u7684\u8a18\u9304<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u7576 auth.users \u8a18\u9304\u88ab\u522a\u9664\u6642\uff0c\u81ea\u52d5\u522a\u9664\u5c0d\u61c9\u7684 profiles \u8a18\u9304<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u5141\u8a31\u4f7f\u7528\u8005\u540c\u6642\u522a\u9664\u591a\u7b46 profiles \u8a18\u9304<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5728 Database Trigger \u4e2d\u4f7f\u7528 <code>security definer<\/code> \u7684\u76ee\u7684\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'A')\">A. \u8b93 function \u4ee5\u5efa\u7acb\u8005\u7684\u6b0a\u9650\u57f7\u884c\uff0c\u53ef\u5beb\u5165 public schema<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'A')\">B. \u52a0\u5f37\u5b89\u5168\u6027\uff0c\u9632\u6b62\u672a\u6388\u6b0a\u7684\u4f7f\u7528\u8005\u89f8\u767c trigger<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'A')\">C. \u9650\u5236\u53ea\u6709\u7ba1\u7406\u54e1\u624d\u80fd\u4fee\u6539 trigger function<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'A')\">D. \u81ea\u52d5\u52a0\u5bc6 trigger \u8655\u7406\u7684\u6240\u6709\u8cc7\u6599<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u5728 RLS Policy \u4e2d\uff0c<code>using<\/code> \u548c <code>with check<\/code> \u7684\u5dee\u7570\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'D')\">A. using \u7528\u65bc SELECT\uff0cwith check \u7528\u65bc INSERT<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'D')\">B. using \u9a57\u8b49\u4f7f\u7528\u8005\u8eab\u4efd\uff0cwith check \u9a57\u8b49\u8cc7\u6599\u683c\u5f0f<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'D')\">C. \u5169\u8005\u529f\u80fd\u76f8\u540c\uff0c\u53ea\u662f\u8a9e\u6cd5\u4e0d\u540c<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'D')\">D. using \u6c7a\u5b9a\u54ea\u4e9b\u8a18\u9304\u53ef\u88ab\u9078\u4e2d\uff0cwith check \u78ba\u4fdd\u66f4\u65b0\u5f8c\u7684\u8cc7\u6599\u7b26\u5408\u689d\u4ef6<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u4f7f\u7528 Supabase Client \u7684 <code>upsert<\/code> \u65b9\u6cd5\u6709\u4ec0\u9ebc\u4f5c\u7528\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'B')\">A. \u5f37\u5236\u66f4\u65b0\u8a18\u9304\uff0c\u5982\u679c\u8a18\u9304\u4e0d\u5b58\u5728\u6703\u62cb\u51fa\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'B')\">B. \u5982\u679c\u8a18\u9304\u5b58\u5728\u5c31\u66f4\u65b0\uff0c\u4e0d\u5b58\u5728\u5c31\u65b0\u589e<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'B')\">C. \u540c\u6642\u57f7\u884c\u591a\u7b46\u66f4\u65b0\u64cd\u4f5c\u7684\u6279\u6b21\u8655\u7406<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'B')\">D. \u5728\u66f4\u65b0\u524d\u5148\u5099\u4efd\u539f\u6709\u8cc7\u6599<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"auth.users \u5b58\u653e\u5728 auth schema \u4e2d\uff0c\u4e0d\u6703\u88ab PostgREST \u66b4\u9732\u51fa\u4f86\uff0c\u56e0\u6b64\u7121\u6cd5\u900f\u904e API \u76f4\u63a5\u5b58\u53d6\u3002\u6b64\u5916\uff0cauth.users \u7684\u6b04\u4f4d\u662f\u7531 Supabase \u7cfb\u7d71\u7ba1\u7406\u7684\uff0c\u7121\u6cd5\u96a8\u610f\u65b0\u589e\u81ea\u8a02\u6b04\u4f4d\u3002\u56e0\u6b64\u5b98\u65b9\u5efa\u8b70\u5728 public schema \u5efa\u7acb profiles \u8868\u4f86\u5b58\u653e\u4f7f\u7528\u8005\u7684\u984d\u5916\u8cc7\u6599\u3002\",\n        2: \"<code>on delete cascade<\/code> \u8a2d\u5b9a\u5728\u5916\u9375\u95dc\u806f\u4e0a\uff0c\u8868\u793a\u7576\u88ab\u53c3\u8003\u7684\u8a18\u9304\uff08auth.users\uff09\u88ab\u522a\u9664\u6642\uff0c\u6703\u81ea\u52d5\u522a\u9664\u53c3\u8003\u5b83\u7684\u8a18\u9304\uff08profiles\uff09\u3002\u9019\u78ba\u4fdd\u4e86\u8cc7\u6599\u7684\u4e00\u81f4\u6027\uff0c\u907f\u514d\u51fa\u73fe\u5b64\u7acb\u7684 profile \u8a18\u9304\u3002\",\n        3: \"<code>security definer<\/code> \u8b93 function \u4ee5\u5efa\u7acb\u8005\uff08\u901a\u5e38\u662f postgres\uff09\u7684\u6b0a\u9650\u57f7\u884c\uff0c\u800c\u4e0d\u662f\u89f8\u767c\u8005\u7684\u6b0a\u9650\u3002\u56e0\u70ba supabase_auth_admin \u89d2\u8272\u6c92\u6709\u6b0a\u9650\u5beb\u5165 public schema\uff0c\u4f7f\u7528 security definer \u53ef\u4ee5\u7e5e\u904e\u9019\u500b\u9650\u5236\uff0c\u8b93 trigger \u80fd\u5920\u5728\u4f7f\u7528\u8005\u8a3b\u518a\u6642\u6210\u529f\u5efa\u7acb profile\u3002\",\n        4: \"<code>using<\/code> \u5b50\u53e5\u6c7a\u5b9a\u54ea\u4e9b\u73fe\u6709\u8a18\u9304\u53ef\u4ee5\u88ab\u9078\u4e2d\u9032\u884c\u64cd\u4f5c\uff08\u5982\u8b80\u53d6\u6216\u66f4\u65b0\uff09\uff0c\u800c <code>with check<\/code> \u5b50\u53e5\u5247\u78ba\u4fdd\u64cd\u4f5c\u5f8c\u7684\u8cc7\u6599\uff08\u65b0\u589e\u6216\u66f4\u65b0\u5f8c\uff09\u5fc5\u9808\u7b26\u5408\u6307\u5b9a\u689d\u4ef6\u3002\u5728 UPDATE \u64cd\u4f5c\u4e2d\uff0c\u5169\u8005\u90fd\u6703\u88ab\u6aa2\u67e5\uff0c\u9632\u6b62\u4f7f\u7528\u8005\u5c07\u8cc7\u6599\u6539\u6210\u4e0d\u7b26\u5408\u689d\u4ef6\u7684\u503c\u3002\",\n        5: \"<code>upsert<\/code> \u662f \\\"update or insert\\\" \u7684\u7e2e\u5beb\uff0c\u5b83\u6703\u6aa2\u67e5\u8a18\u9304\u662f\u5426\u5b58\u5728\uff1a\u5982\u679c\u5b58\u5728\u5c31\u57f7\u884c\u66f4\u65b0\uff0c\u5982\u679c\u4e0d\u5b58\u5728\u5c31\u65b0\u589e\u4e00\u7b46\u3002\u9019\u662f\u8655\u7406 profile \u66f4\u65b0\u7684\u5e38\u898b\u6a21\u5f0f\uff0c\u53ef\u4ee5\u7c21\u5316\u7a0b\u5f0f\u78bc\u908f\u8f2f\uff0c\u4e0d\u9700\u8981\u5148\u67e5\u8a62\u518d\u6c7a\u5b9a\u8981 insert \u6216 update\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" \ud83c\udf89 \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \ud83d\udc4d \u4e0d\u932f\uff01\"\n                : \" \ud83d\udcda \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u8a00<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d93\u904e\u524d\u56db\u7bc7\u7684\u5b78\u7fd2\uff0c\u4f60\u5df2\u7d93\u638c\u63e1\u4e86 Supabase \u7684\u6838\u5fc3\u529f\u80fd\uff1a\u8cc7\u6599\u5eab\u64cd\u4f5c\u3001\u8eab\u4efd\u9a57\u8b49\u3001\u4ee5\u53ca Row Level Security\u3002\u73fe\u5728\u662f\u6642\u5019\u628a\u9019\u4e9b\u77e5\u8b58\u6574\u5408\u8d77\u4f86\uff0c\u6253\u9020\u4e00\u500b\u5b8c\u6574\u7684\u6703\u54e1\u8cc7\u6599\u7cfb\u7d71\u4e86\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u7bc7\u6587\u7ae0\u5c07\u5e36\u4f60\u5f9e\u9700\u6c42\u5206\u6790\u958b\u59cb\uff0c\u4e00\u6b65\u6b65\u5efa\u7acb <code>profiles<\/code> \u8868\u3001\u8a2d\u5b9a\u81ea\u52d5\u5316\u7684 Database Trigger\u3001\u914d\u7f6e RLS Policy\uff0c\u6700\u5f8c\u6574\u5408\u524d\u7aef\u7a0b\u5f0f\u78bc\uff0c\u5b8c\u6210\u4e00\u500b\u53ef\u4ee5\u5be6\u969b\u904b\u4f5c\u7684\u6703\u54e1\u7cfb\u7d71\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b78\u7fd2\u76ee\u6a19<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b80\u5b8c\u672c\u7bc7\u5f8c\uff0c\u4f60\u5c07\u80fd\u5920\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6574\u5408 Auth + Database + RLS \u5efa\u7acb\u5b8c\u6574\u529f\u80fd<\/li>\n<li>\u8a2d\u8a08 profiles \u8868\u8207 auth.users \u7684\u95dc\u806f<\/li>\n<li>\u4f7f\u7528 Database Trigger \u81ea\u52d5\u5efa\u7acb\u4f7f\u7528\u8005\u8cc7\u6599<\/li>\n<li>\u5be6\u4f5c\u6703\u54e1\u8cc7\u6599\u7684\u986f\u793a\u8207\u66f4\u65b0\u529f\u80fd<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u5c08\u6848\u9700\u6c42\u5206\u6790<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u958b\u59cb\u5beb\u7a0b\u5f0f\u78bc\u4e4b\u524d\uff0c\u8b93\u6211\u5011\u5148\u601d\u8003\u4e00\u500b\u6703\u54e1\u7cfb\u7d71\u9700\u8981\u4ec0\u9ebc\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u9700\u8981 profiles \u8868\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Supabase \u7684 <code>auth.users<\/code> \u8868\u662f\u7531\u7cfb\u7d71\u7ba1\u7406\u7684\uff0c\u5b58\u653e\u5728 <code>auth<\/code> schema \u4e2d\uff0c\u6709\u5e7e\u500b\u9650\u5236\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u7121\u6cd5\u76f4\u63a5\u900f\u904e API \u5b58\u53d6<\/strong>\uff1a<code>auth.users<\/code> \u4e0d\u6703\u88ab PostgREST \u66b4\u9732\u51fa\u4f86<\/li>\n<li><strong>\u6b04\u4f4d\u56fa\u5b9a<\/strong>\uff1a\u4f60\u7121\u6cd5\u96a8\u610f\u65b0\u589e\u81ea\u8a02\u6b04\u4f4d<\/li>\n<li><strong>\u7531 Supabase \u7ba1\u7406<\/strong>\uff1a\u6b04\u4f4d\u7d50\u69cb\u53ef\u80fd\u6703\u8b8a\u52d5<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u56e0\u6b64\uff0c\u5b98\u65b9\u5efa\u8b70\u7684\u505a\u6cd5\u662f\uff1a<strong>\u5728 public schema \u5efa\u7acb\u4e00\u500b profiles \u8868\uff0c\u900f\u904e\u5916\u9375\u95dc\u806f\u5230 auth.users<\/strong>\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6703\u54e1\u7cfb\u7d71\u7684\u6838\u5fc3\u9700\u6c42<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6211\u5011\u7684\u6703\u54e1\u7cfb\u7d71\u9700\u8981\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u529f\u80fd<\/th>\n<th>\u8aaa\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u81ea\u52d5\u5efa\u7acb\u8cc7\u6599<\/td>\n<td>\u4f7f\u7528\u8005\u8a3b\u518a\u6642\uff0c\u81ea\u52d5\u5728 profiles \u5efa\u7acb\u4e00\u7b46\u8a18\u9304<\/td>\n<\/tr>\n<tr>\n<td>\u8b80\u53d6\u500b\u4eba\u8cc7\u6599<\/td>\n<td>\u4f7f\u7528\u8005\u53ef\u4ee5\u67e5\u770b\u81ea\u5df1\u7684 profile<\/td>\n<\/tr>\n<tr>\n<td>\u66f4\u65b0\u500b\u4eba\u8cc7\u6599<\/td>\n<td>\u4f7f\u7528\u8005\u53ef\u4ee5\u4fee\u6539\u81ea\u5df1\u7684 username\u3001website \u7b49\u8cc7\u8a0a<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u9694\u96e2<\/td>\n<td>\u4f7f\u7528\u8005\u53ea\u80fd\u5b58\u53d6\u81ea\u5df1\u7684\u8cc7\u6599\uff08RLS\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u8cc7\u6599\u8868\u8a2d\u8a08<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">profiles \u8868\u7d50\u69cb<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u662f\u6211\u5011\u7684 profiles \u8868\u8a2d\u8a08\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">create table public.profiles (\n  id uuid not <span class=\"hljs-literal\">null<\/span> references auth.users on <span class=\"hljs-keyword\">delete<\/span> cascade,\n  username text unique,\n  full_name text,\n  avatar_url text,\n  website text,\n  updated_at timestamp <span class=\"hljs-keyword\">with<\/span> time zone,\n\n  primary key (id)\n);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u8b93\u6211\u5011\u9010\u884c\u89e3\u8b80\u9019\u6bb5 SQL\uff1a<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e3b\u9375\u8a2d\u8a08<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">id uuid not <span class=\"hljs-literal\">null<\/span> references auth.users on <span class=\"hljs-keyword\">delete<\/span> cascade,\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><code>id uuid<\/code>\uff1a\u4f7f\u7528 UUID \u4f5c\u70ba\u4e3b\u9375\uff0c\u8207 <code>auth.users<\/code> \u7684 id \u4e00\u81f4<\/li>\n<li><code>references auth.users<\/code>\uff1a\u5efa\u7acb\u5916\u9375\u95dc\u806f<\/li>\n<li><code>on delete cascade<\/code>\uff1a\u7576 auth.users \u7684\u8a18\u9304\u88ab\u522a\u9664\u6642\uff0cprofiles \u4e5f\u6703\u81ea\u52d5\u522a\u9664<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u662f Supabase \u5b98\u65b9\u63a8\u85a6\u7684\u505a\u6cd5\uff1a<strong>\u53ea\u4f7f\u7528\u4e3b\u9375\u4f5c\u70ba\u5916\u9375\u53c3\u8003<\/strong>\uff0c\u56e0\u70ba\u4e3b\u9375\u4fdd\u8b49\u4e0d\u6703\u6539\u8b8a\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5176\u4ed6\u6b04\u4f4d<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">username text unique,        -- \u4f7f\u7528\u8005\u540d\u7a31\uff0c\u5fc5\u9808\u552f\u4e00\nfull_name text,              -- \u986f\u793a\u540d\u7a31\navatar_url text,             -- \u982d\u50cf URL\nwebsite text,                -- \u500b\u4eba\u7db2\u7ad9\nupdated_at timestamp <span class=\"hljs-keyword\">with<\/span> time zone,  -- \u6700\u5f8c\u66f4\u65b0\u6642\u9593\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u57f7\u884c\u5efa\u8868\u8a9e\u53e5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 Supabase Dashboard \u7684 SQL Editor \u4e2d\u57f7\u884c\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u5efa\u7acb profiles \u8868\ncreate table public.profiles (\n  id uuid not <span class=\"hljs-literal\">null<\/span> references auth.users on <span class=\"hljs-keyword\">delete<\/span> cascade,\n  username text unique,\n  full_name text,\n  avatar_url text,\n  website text,\n  updated_at timestamp <span class=\"hljs-keyword\">with<\/span> time zone,\n\n  primary key (id)\n);\n\n-- \u555f\u7528 RLS\nalter table public.profiles enable row level security;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Database Trigger\uff1a\u81ea\u52d5\u5efa\u7acb Profile<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f7f\u7528\u8005\u8a3b\u518a\u6642\uff0c\u6211\u5011\u5e0c\u671b\u81ea\u52d5\u5728 profiles \u8868\u5efa\u7acb\u4e00\u7b46\u8a18\u9304\u3002\u9019\u9700\u8981\u7528\u5230 Database Trigger\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7406\u89e3 Trigger \u7684\u904b\u4f5c\u539f\u7406<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">\u4f7f\u7528\u8005\u8a3b\u518a\n    |\n    v\nauth.users \u65b0\u589e\u4e00\u7b46\u8a18\u9304\n    |\n    v\n\u89f8\u767c on_auth_user_created trigger\n    |\n    v\n\u57f7\u884c handle_new_user() <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>\n    |\n    <span class=\"hljs-title\">v<\/span>\n\u5728 <span class=\"hljs-title\">profiles<\/span> \u8868\u65b0\u589e\u5c0d\u61c9\u8a18\u9304\n<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u5efa\u7acb Trigger Function<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">create <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">handle_new_user<\/span>(<span class=\"hljs-params\"><\/span>)\n<span class=\"hljs-title\">returns<\/span> <span class=\"hljs-title\">trigger<\/span>\n<span class=\"hljs-title\">language<\/span> <span class=\"hljs-title\">plpgsql<\/span>\n<span class=\"hljs-title\">security<\/span> <span class=\"hljs-title\">definer<\/span> <span class=\"hljs-title\">set<\/span> <span class=\"hljs-title\">search_path<\/span> = ''\n<span class=\"hljs-title\">as<\/span> <span class=\"hljs-title\">$$<\/span>\n<span class=\"hljs-title\">begin<\/span>\n  <span class=\"hljs-title\">insert<\/span> <span class=\"hljs-title\">into<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">profiles<\/span> (<span class=\"hljs-params\">id, full_name, avatar_url<\/span>)\n  <span class=\"hljs-title\">values<\/span> (<span class=\"hljs-params\">\n    new.id,\n    new.raw_user_meta_data -&gt;&gt; <span class=\"hljs-string\">'full_name'<\/span>,\n    new.raw_user_meta_data -&gt;&gt; <span class=\"hljs-string\">'avatar_url'<\/span>\n  <\/span>);\n  <span class=\"hljs-title\">return<\/span> <span class=\"hljs-title\">new<\/span>;\n<span class=\"hljs-title\">end<\/span>;\n<span class=\"hljs-title\">$$<\/span>;\n<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u6bb5\u7a0b\u5f0f\u78bc\u6709\u5e7e\u500b\u95dc\u9375\u9ede\uff1a<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">security definer \u7684\u4f5c\u7528<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">security definer <span class=\"hljs-keyword\">set<\/span> search_path = ''\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>security definer<\/code> \u662f\u9019\u6bb5\u7a0b\u5f0f\u78bc\u7684\u95dc\u9375\u3002\u5b83\u8b93 function \u4ee5<strong>\u5efa\u7acb\u8005\u7684\u6b0a\u9650<\/strong>\uff08postgres\uff09\u57f7\u884c\uff0c\u800c\u4e0d\u662f\u89f8\u767c\u8005\u7684\u6b0a\u9650\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u70ba\u4ec0\u9ebc\u9700\u8981\u9019\u6a23\uff1f\u56e0\u70ba\u7ba1\u7406 auth.users \u7684\u89d2\u8272\u662f <code>supabase_auth_admin<\/code>\uff0c\u5b83\u6c92\u6709\u6b0a\u9650\u5beb\u5165 public schema\u3002\u4f7f\u7528 <code>security definer<\/code> \u53ef\u4ee5\u7e5e\u904e\u9019\u500b\u9650\u5236\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5b58\u53d6\u4f7f\u7528\u8005 metadata<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">new<\/span>.raw_user_meta_data -&gt;&gt; <span class=\"hljs-string\">'full_name'<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>new<\/code> \u4ee3\u8868\u525b\u63d2\u5165\u7684\u8a18\u9304\uff08\u65b0\u7684 auth.users \u884c\uff09\u3002<code>raw_user_meta_data<\/code> \u662f\u4e00\u500b JSONB \u6b04\u4f4d\uff0c\u5b58\u653e\u4f7f\u7528\u8005\u8a3b\u518a\u6642\u63d0\u4f9b\u7684\u984d\u5916\u8cc7\u6599\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528 <code>-&gt;&gt;<\/code> \u904b\u7b97\u5b50\u53ef\u4ee5\u53d6\u51fa JSON \u4e2d\u7684\u503c\u4f5c\u70ba text\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5efa\u7acb Trigger<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">create<\/span> <span class=\"hljs-selector-tag\">trigger<\/span> <span class=\"hljs-selector-tag\">on_auth_user_created<\/span>\n  <span class=\"hljs-selector-tag\">after<\/span> <span class=\"hljs-selector-tag\">insert<\/span> <span class=\"hljs-selector-tag\">on<\/span> <span class=\"hljs-selector-tag\">auth<\/span><span class=\"hljs-selector-class\">.users<\/span>\n  <span class=\"hljs-selector-tag\">for<\/span> <span class=\"hljs-selector-tag\">each<\/span> <span class=\"hljs-selector-tag\">row<\/span> <span class=\"hljs-selector-tag\">execute<\/span> <span class=\"hljs-selector-tag\">procedure<\/span> <span class=\"hljs-selector-tag\">public<\/span><span class=\"hljs-selector-class\">.handle_new_user<\/span>();\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u500b trigger \u6703\u5728\u6bcf\u6b21 <code>auth.users<\/code> \u6709\u65b0\u8a18\u9304\u63d2\u5165\u5f8c\u57f7\u884c <code>handle_new_user()<\/code> function\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b8c\u6574\u7684 SQL \u8173\u672c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u628a\u4e0a\u9762\u7684\u7a0b\u5f0f\u78bc\u6574\u5408\u8d77\u4f86\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- <span class=\"hljs-number\">1.<\/span> \u5efa\u7acb profiles \u8868\ncreate table public.profiles (\n  id uuid not <span class=\"hljs-literal\">null<\/span> references auth.users on <span class=\"hljs-keyword\">delete<\/span> cascade,\n  username text unique,\n  full_name text,\n  avatar_url text,\n  website text,\n  updated_at timestamp <span class=\"hljs-keyword\">with<\/span> time zone,\n\n  primary key (id)\n);\n\n-- <span class=\"hljs-number\">2.<\/span> \u555f\u7528 RLS\nalter table public.profiles enable row level security;\n\n-- <span class=\"hljs-number\">3.<\/span> \u5efa\u7acb trigger <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>\n<span class=\"hljs-title\">create<\/span> <span class=\"hljs-title\">function<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">handle_new_user<\/span>(<span class=\"hljs-params\"><\/span>)\n<span class=\"hljs-title\">returns<\/span> <span class=\"hljs-title\">trigger<\/span>\n<span class=\"hljs-title\">language<\/span> <span class=\"hljs-title\">plpgsql<\/span>\n<span class=\"hljs-title\">security<\/span> <span class=\"hljs-title\">definer<\/span> <span class=\"hljs-title\">set<\/span> <span class=\"hljs-title\">search_path<\/span> = ''\n<span class=\"hljs-title\">as<\/span> <span class=\"hljs-title\">$$<\/span>\n<span class=\"hljs-title\">begin<\/span>\n  <span class=\"hljs-title\">insert<\/span> <span class=\"hljs-title\">into<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">profiles<\/span> (<span class=\"hljs-params\">id, full_name, avatar_url<\/span>)\n  <span class=\"hljs-title\">values<\/span> (<span class=\"hljs-params\">\n    new.id,\n    new.raw_user_meta_data -&gt;&gt; <span class=\"hljs-string\">'full_name'<\/span>,\n    new.raw_user_meta_data -&gt;&gt; <span class=\"hljs-string\">'avatar_url'<\/span>\n  <\/span>);\n  <span class=\"hljs-title\">return<\/span> <span class=\"hljs-title\">new<\/span>;\n<span class=\"hljs-title\">end<\/span>;\n<span class=\"hljs-title\">$$<\/span>;\n\n-- 4. \u5efa\u7acb <span class=\"hljs-title\">trigger<\/span>\n<span class=\"hljs-title\">create<\/span> <span class=\"hljs-title\">trigger<\/span> <span class=\"hljs-title\">on_auth_user_created<\/span>\n  <span class=\"hljs-title\">after<\/span> <span class=\"hljs-title\">insert<\/span> <span class=\"hljs-title\">on<\/span> <span class=\"hljs-title\">auth<\/span>.<span class=\"hljs-title\">users<\/span>\n  <span class=\"hljs-title\">for<\/span> <span class=\"hljs-title\">each<\/span> <span class=\"hljs-title\">row<\/span> <span class=\"hljs-title\">execute<\/span> <span class=\"hljs-title\">procedure<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">handle_new_user<\/span>(<span class=\"hljs-params\"><\/span>);\n<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">RLS Policy \u8a2d\u5b9a<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u63a5\u4e0b\u4f86\u8981\u8a2d\u5b9a Row Level Security\uff0c\u78ba\u4fdd\u4f7f\u7528\u8005\u53ea\u80fd\u5b58\u53d6\u81ea\u5df1\u7684\u8cc7\u6599\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Policy \u8a2d\u8a08\u601d\u8def<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>\u898f\u5247<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>SELECT<\/td>\n<td>\u53ea\u80fd\u8b80\u53d6\u81ea\u5df1\u7684 profile<\/td>\n<\/tr>\n<tr>\n<td>UPDATE<\/td>\n<td>\u53ea\u80fd\u66f4\u65b0\u81ea\u5df1\u7684 profile<\/td>\n<\/tr>\n<tr>\n<td>INSERT<\/td>\n<td>\u7531 trigger \u8655\u7406\uff0c\u4e00\u822c\u4f7f\u7528\u8005\u4e0d\u9700\u8981<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u5be6\u4f5c RLS Policy<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">-- \u4f7f\u7528\u8005\u53ef\u4ee5\u67e5\u770b\u81ea\u5df1\u7684 profile\ncreate policy <span class=\"hljs-string\">\"Users can view own profile\"<\/span>\non <span class=\"hljs-keyword\">public<\/span>.profiles\n<span class=\"hljs-keyword\">for<\/span> select\nto authenticated\nusing (auth.uid() = id);\n\n-- \u4f7f\u7528\u8005\u53ef\u4ee5\u66f4\u65b0\u81ea\u5df1\u7684 profile\ncreate policy <span class=\"hljs-string\">\"Users can update own profile\"<\/span>\non <span class=\"hljs-keyword\">public<\/span>.profiles\n<span class=\"hljs-keyword\">for<\/span> update\nto authenticated\nusing (auth.uid() = id)\nwith check (auth.uid() = id);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">\u89e3\u8b80\u9019\u4e9b Policy<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SELECT Policy\uff1a<\/strong><\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">using (auth.uid() = id)\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>auth.uid()<\/code> \u6703\u56de\u50b3\u7576\u524d\u767b\u5165\u4f7f\u7528\u8005\u7684 UUID\u3002\u9019\u500b\u689d\u4ef6\u78ba\u4fdd\u4f7f\u7528\u8005\u53ea\u80fd\u8b80\u53d6 <code>id<\/code> \u7b49\u65bc\u81ea\u5df1 UUID \u7684\u8a18\u9304\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>UPDATE Policy\uff1a<\/strong><\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">using (auth.uid() = id)        -- \u54ea\u4e9b\u8a18\u9304\u53ef\u4ee5\u88ab\u9078\u4e2d\u66f4\u65b0\n<span class=\"hljs-keyword\">with<\/span> check (auth.uid() = id)   -- \u66f4\u65b0\u5f8c\u7684\u8cc7\u6599\u5fc5\u9808\u7b26\u5408\u7684\u689d\u4ef6\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>using<\/code> \u6c7a\u5b9a\u54ea\u4e9b\u73fe\u6709\u8a18\u9304\u53ef\u4ee5\u88ab\u66f4\u65b0\uff0c<code>with check<\/code> \u78ba\u4fdd\u66f4\u65b0\u5f8c\u7684\u8cc7\u6599\u4ecd\u7136\u7b26\u5408\u689d\u4ef6\uff08\u9632\u6b62\u4f7f\u7528\u8005\u628a id \u6539\u6210\u5225\u4eba\u7684\uff09\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u91cd\u8981\u63d0\u9192\uff1aRLS \u7684\u9650\u5236<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">RLS \u662f\u57fa\u65bc<strong>\u884c\uff08row\uff09<\/strong>\u7684\u5b89\u5168\u6a5f\u5236\uff0c\u7121\u6cd5\u63a7\u5236<strong>\u6b04\u4f4d\uff08column\uff09<\/strong>\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8209\u4f8b\u4f86\u8aaa\uff0c\u5982\u679c\u4f60\u7d66\u4f7f\u7528\u8005\u66f4\u65b0\u81ea\u5df1 profile \u7684\u6b0a\u9650\uff0c\u4ed6\u53ef\u4ee5\u4fee\u6539\u8a72\u884c\u7684\u4efb\u4f55\u6b04\u4f4d\u3002\u5982\u679c\u4f60\u60f3\u4fdd\u8b77\u67d0\u4e9b\u6b04\u4f4d\uff08\u4f8b\u5982\u4e0d\u8b93\u4f7f\u7528\u8005\u81ea\u5df1\u6539 <code>id<\/code>\uff09\uff0c\u9700\u8981\u4f7f\u7528 Trigger \u4f86\u8655\u7406\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u7aef\u6574\u5408\u7bc4\u4f8b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u73fe\u5728\u8b93\u6211\u5011\u7528 JavaScript\/React \u4f86\u5be6\u4f5c\u524d\u7aef\u529f\u80fd\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u521d\u59cb\u5316 Supabase Client<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">import<\/span> { createClient } <span class=\"hljs-keyword\">from<\/span> <span class=\"hljs-string\">'@supabase\/supabase-js'<\/span>\n\n<span class=\"hljs-keyword\">const<\/span> supabaseUrl = <span class=\"hljs-string\">'https:\/\/your-project.supabase.co'<\/span>\n<span class=\"hljs-keyword\">const<\/span> supabaseAnonKey = <span class=\"hljs-string\">'your-anon-key'<\/span>\n\n<span class=\"hljs-keyword\">export<\/span> <span class=\"hljs-keyword\">const<\/span> supabase = createClient(supabaseUrl, supabaseAnonKey)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u8a3b\u518a\u6642\u5e36\u5165 metadata<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a3b\u518a\u6642\u53ef\u4ee5\u5e36\u5165\u984d\u5916\u7684 metadata\uff0c\u9019\u4e9b\u8cc7\u6599\u6703\u5b58\u5728 <code>raw_user_meta_data<\/code>\uff0c\u4e26\u88ab trigger \u8b80\u53d6\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">signUp<\/span>(<span class=\"hljs-params\">email, password, fullName<\/span>) <\/span>{\n  <span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.signUp({\n    <span class=\"hljs-attr\">email<\/span>: email,\n    <span class=\"hljs-attr\">password<\/span>: password,\n    <span class=\"hljs-attr\">options<\/span>: {\n      <span class=\"hljs-attr\">data<\/span>: {\n        <span class=\"hljs-attr\">full_name<\/span>: fullName,\n        <span class=\"hljs-attr\">avatar_url<\/span>: <span class=\"hljs-literal\">null<\/span>,\n      },\n    },\n  })\n\n  <span class=\"hljs-keyword\">if<\/span> (error) {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u8a3b\u518a\u5931\u6557:'<\/span>, error.message)\n    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-literal\">null<\/span>\n  }\n\n  <span class=\"hljs-keyword\">return<\/span> data\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u53d6\u5f97\u500b\u4eba\u8cc7\u6599<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">getProfile<\/span>(<span class=\"hljs-params\"><\/span>) <\/span>{\n  <span class=\"hljs-comment\">\/\/ \u5148\u53d6\u5f97\u7576\u524d\u4f7f\u7528\u8005<\/span>\n  <span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { user } } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.getUser()\n\n  <span class=\"hljs-keyword\">if<\/span> (!user) {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u4f7f\u7528\u8005\u672a\u767b\u5165'<\/span>)\n    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-literal\">null<\/span>\n  }\n\n  <span class=\"hljs-comment\">\/\/ \u67e5\u8a62 profiles \u8868<\/span>\n  <span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n    .from(<span class=\"hljs-string\">'profiles'<\/span>)\n    .select(<span class=\"hljs-string\">'username, full_name, avatar_url, website, updated_at'<\/span>)\n    .eq(<span class=\"hljs-string\">'id'<\/span>, user.id)\n    .single()\n\n  <span class=\"hljs-keyword\">if<\/span> (error) {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u53d6\u5f97 profile \u5931\u6557:'<\/span>, error.message)\n    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-literal\">null<\/span>\n  }\n\n  <span class=\"hljs-keyword\">return<\/span> data\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">\u7a0b\u5f0f\u78bc\u89e3\u8b80<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">.select(<span class=\"hljs-string\">'username, full_name, avatar_url, website, updated_at'<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6307\u5b9a\u8981\u53d6\u5f97\u7684\u6b04\u4f4d\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">.eq(<span class=\"hljs-string\">'id'<\/span>, user.id)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u7be9\u9078\u689d\u4ef6\uff1aid \u7b49\u65bc\u7576\u524d\u4f7f\u7528\u8005\u7684 id\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-18\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-class\">.single<\/span>()\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9810\u671f\u53ea\u6703\u56de\u50b3\u4e00\u7b46\u8a18\u9304\u3002\u5982\u679c\u56de\u50b3 0 \u7b46\u6216\u591a\u7b46\uff0c\u6703\u62cb\u51fa\u932f\u8aa4\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u66f4\u65b0\u500b\u4eba\u8cc7\u6599<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-19\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">updateProfile<\/span>(<span class=\"hljs-params\">{ username, fullName, website, avatarUrl }<\/span>) <\/span>{\n  <span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { user } } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.getUser()\n\n  <span class=\"hljs-keyword\">if<\/span> (!user) {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u4f7f\u7528\u8005\u672a\u767b\u5165'<\/span>)\n    <span class=\"hljs-keyword\">return<\/span> { <span class=\"hljs-attr\">error<\/span>: <span class=\"hljs-string\">'\u4f7f\u7528\u8005\u672a\u767b\u5165'<\/span> }\n  }\n\n  <span class=\"hljs-keyword\">const<\/span> updates = {\n    <span class=\"hljs-attr\">id<\/span>: user.id,\n    <span class=\"hljs-attr\">username<\/span>: username,\n    <span class=\"hljs-attr\">full_name<\/span>: fullName,\n    <span class=\"hljs-attr\">website<\/span>: website,\n    <span class=\"hljs-attr\">avatar_url<\/span>: avatarUrl,\n    <span class=\"hljs-attr\">updated_at<\/span>: <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-built_in\">Date<\/span>().toISOString(),\n  }\n\n  <span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n    .from(<span class=\"hljs-string\">'profiles'<\/span>)\n    .upsert(updates)\n    .select()\n\n  <span class=\"hljs-keyword\">if<\/span> (error) {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u66f4\u65b0 profile \u5931\u6557:'<\/span>, error.message)\n    <span class=\"hljs-keyword\">return<\/span> { <span class=\"hljs-attr\">error<\/span>: error.message }\n  }\n\n  <span class=\"hljs-keyword\">return<\/span> { data }\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-19\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">upsert \u7684\u4f5c\u7528<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-20\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-class\">.upsert<\/span>(<span class=\"hljs-selector-tag\">updates<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-20\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>upsert<\/code> \u662f &#8220;update or insert&#8221; \u7684\u7e2e\u5beb\u3002\u5982\u679c\u8a18\u9304\u5b58\u5728\u5c31\u66f4\u65b0\uff0c\u4e0d\u5b58\u5728\u5c31\u65b0\u589e\u3002\u9019\u662f\u8655\u7406 profile \u66f4\u65b0\u7684\u5e38\u898b\u6a21\u5f0f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">React \u5143\u4ef6\u7bc4\u4f8b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-21\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">import<\/span> { useState, useEffect } <span class=\"hljs-keyword\">from<\/span> <span class=\"hljs-string\">'react'<\/span>\n<span class=\"hljs-keyword\">import<\/span> { supabase } <span class=\"hljs-keyword\">from<\/span> <span class=\"hljs-string\">'.\/supabaseClient'<\/span>\n\n<span class=\"hljs-keyword\">export<\/span> <span class=\"hljs-keyword\">default<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">Profile<\/span>(<span class=\"hljs-params\"><\/span>) <\/span>{\n  <span class=\"hljs-keyword\">const<\/span> &#91;loading, setLoading] = useState(<span class=\"hljs-literal\">true<\/span>)\n  <span class=\"hljs-keyword\">const<\/span> &#91;username, setUsername] = useState(<span class=\"hljs-string\">''<\/span>)\n  <span class=\"hljs-keyword\">const<\/span> &#91;fullName, setFullName] = useState(<span class=\"hljs-string\">''<\/span>)\n  <span class=\"hljs-keyword\">const<\/span> &#91;website, setWebsite] = useState(<span class=\"hljs-string\">''<\/span>)\n  <span class=\"hljs-keyword\">const<\/span> &#91;avatarUrl, setAvatarUrl] = useState(<span class=\"hljs-string\">''<\/span>)\n\n  useEffect(<span class=\"hljs-function\"><span class=\"hljs-params\">()<\/span> =&gt;<\/span> {\n    loadProfile()\n  }, &#91;])\n\n  <span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">loadProfile<\/span>(<span class=\"hljs-params\"><\/span>) <\/span>{\n    setLoading(<span class=\"hljs-literal\">true<\/span>)\n\n    <span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { user } } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.getUser()\n\n    <span class=\"hljs-keyword\">if<\/span> (user) {\n      <span class=\"hljs-keyword\">const<\/span> { data } = <span class=\"hljs-keyword\">await<\/span> supabase\n        .from(<span class=\"hljs-string\">'profiles'<\/span>)\n        .select(<span class=\"hljs-string\">'username, full_name, website, avatar_url'<\/span>)\n        .eq(<span class=\"hljs-string\">'id'<\/span>, user.id)\n        .single()\n\n      <span class=\"hljs-keyword\">if<\/span> (data) {\n        setUsername(data.username || <span class=\"hljs-string\">''<\/span>)\n        setFullName(data.full_name || <span class=\"hljs-string\">''<\/span>)\n        setWebsite(data.website || <span class=\"hljs-string\">''<\/span>)\n        setAvatarUrl(data.avatar_url || <span class=\"hljs-string\">''<\/span>)\n      }\n    }\n\n    setLoading(<span class=\"hljs-literal\">false<\/span>)\n  }\n\n  <span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">handleSubmit<\/span>(<span class=\"hljs-params\">e<\/span>) <\/span>{\n    e.preventDefault()\n    setLoading(<span class=\"hljs-literal\">true<\/span>)\n\n    <span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { user } } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.getUser()\n\n    <span class=\"hljs-keyword\">const<\/span> { error } = <span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'profiles'<\/span>).upsert({\n      <span class=\"hljs-attr\">id<\/span>: user.id,\n      username,\n      <span class=\"hljs-attr\">full_name<\/span>: fullName,\n      website,\n      <span class=\"hljs-attr\">avatar_url<\/span>: avatarUrl,\n      <span class=\"hljs-attr\">updated_at<\/span>: <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-built_in\">Date<\/span>().toISOString(),\n    })\n\n    <span class=\"hljs-keyword\">if<\/span> (error) {\n      alert(<span class=\"hljs-string\">'\u66f4\u65b0\u5931\u6557: '<\/span> + error.message)\n    } <span class=\"hljs-keyword\">else<\/span> {\n      alert(<span class=\"hljs-string\">'\u66f4\u65b0\u6210\u529f\uff01'<\/span>)\n    }\n\n    setLoading(<span class=\"hljs-literal\">false<\/span>)\n  }\n\n  <span class=\"hljs-keyword\">return<\/span> (\n    <span class=\"xml\"><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">form<\/span> <span class=\"hljs-attr\">onSubmit<\/span>=<span class=\"hljs-string\">{handleSubmit}<\/span>&gt;<\/span>\n      <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">div<\/span>&gt;<\/span>\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">label<\/span>&gt;<\/span>\u4f7f\u7528\u8005\u540d\u7a31<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">label<\/span>&gt;<\/span>\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">input<\/span>\n          <span class=\"hljs-attr\">type<\/span>=<span class=\"hljs-string\">\"text\"<\/span>\n          <span class=\"hljs-attr\">value<\/span>=<span class=\"hljs-string\">{username}<\/span>\n          <span class=\"hljs-attr\">onChange<\/span>=<span class=\"hljs-string\">{(e)<\/span> =&gt;<\/span> setUsername(e.target.value)}\n        \/&gt;\n      <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">div<\/span>&gt;<\/span>\n\n      <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">div<\/span>&gt;<\/span>\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">label<\/span>&gt;<\/span>\u986f\u793a\u540d\u7a31<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">label<\/span>&gt;<\/span>\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">input<\/span>\n          <span class=\"hljs-attr\">type<\/span>=<span class=\"hljs-string\">\"text\"<\/span>\n          <span class=\"hljs-attr\">value<\/span>=<span class=\"hljs-string\">{fullName}<\/span>\n          <span class=\"hljs-attr\">onChange<\/span>=<span class=\"hljs-string\">{(e)<\/span> =&gt;<\/span> setFullName(e.target.value)}\n        \/&gt;\n      <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">div<\/span>&gt;<\/span>\n\n      <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">div<\/span>&gt;<\/span>\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">label<\/span>&gt;<\/span>\u500b\u4eba\u7db2\u7ad9<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">label<\/span>&gt;<\/span>\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">input<\/span>\n          <span class=\"hljs-attr\">type<\/span>=<span class=\"hljs-string\">\"url\"<\/span>\n          <span class=\"hljs-attr\">value<\/span>=<span class=\"hljs-string\">{website}<\/span>\n          <span class=\"hljs-attr\">onChange<\/span>=<span class=\"hljs-string\">{(e)<\/span> =&gt;<\/span> setWebsite(e.target.value)}\n        \/&gt;\n      <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">div<\/span>&gt;<\/span>\n\n      <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">button<\/span> <span class=\"hljs-attr\">type<\/span>=<span class=\"hljs-string\">\"submit\"<\/span> <span class=\"hljs-attr\">disabled<\/span>=<span class=\"hljs-string\">{loading}<\/span>&gt;<\/span>\n        {loading ? '\u8655\u7406\u4e2d...' : '\u5132\u5b58'}\n      <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">button<\/span>&gt;<\/span>\n    <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">form<\/span>&gt;<\/span><\/span>\n  )\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-21\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u9032\u968e\u5ef6\u4f38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Storage \u982d\u50cf\u4e0a\u50b3<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Supabase Storage \u53ef\u4ee5\u7528\u4f86\u5b58\u653e\u4f7f\u7528\u8005\u982d\u50cf\u3002\u57fa\u672c\u6d41\u7a0b\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-22\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">async<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">uploadAvatar<\/span>(<span class=\"hljs-params\">file<\/span>) <\/span>{\n  <span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { user } } = <span class=\"hljs-keyword\">await<\/span> supabase.auth.getUser()\n\n  <span class=\"hljs-comment\">\/\/ \u7522\u751f\u552f\u4e00\u7684\u6a94\u6848\u8def\u5f91<\/span>\n  <span class=\"hljs-keyword\">const<\/span> filePath = <span class=\"hljs-string\">`<span class=\"hljs-subst\">${user.id}<\/span>\/<span class=\"hljs-subst\">${<span class=\"hljs-built_in\">Date<\/span>.now()}<\/span>-<span class=\"hljs-subst\">${file.name}<\/span>`<\/span>\n\n  <span class=\"hljs-comment\">\/\/ \u4e0a\u50b3\u6a94\u6848<\/span>\n  <span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase.storage\n    .from(<span class=\"hljs-string\">'avatars'<\/span>)\n    .upload(filePath, file)\n\n  <span class=\"hljs-keyword\">if<\/span> (error) {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u4e0a\u50b3\u5931\u6557:'<\/span>, error.message)\n    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-literal\">null<\/span>\n  }\n\n  <span class=\"hljs-comment\">\/\/ \u53d6\u5f97\u516c\u958b URL<\/span>\n  <span class=\"hljs-keyword\">const<\/span> { <span class=\"hljs-attr\">data<\/span>: { publicUrl } } = supabase.storage\n    .from(<span class=\"hljs-string\">'avatars'<\/span>)\n    .getPublicUrl(filePath)\n\n  <span class=\"hljs-comment\">\/\/ \u66f4\u65b0 profile \u7684 avatar_url<\/span>\n  <span class=\"hljs-keyword\">await<\/span> supabase.from(<span class=\"hljs-string\">'profiles'<\/span>).upsert({\n    <span class=\"hljs-attr\">id<\/span>: user.id,\n    <span class=\"hljs-attr\">avatar_url<\/span>: publicUrl,\n    <span class=\"hljs-attr\">updated_at<\/span>: <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-built_in\">Date<\/span>().toISOString(),\n  })\n\n  <span class=\"hljs-keyword\">return<\/span> publicUrl\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-22\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u8a18\u5f97\u5728 Storage \u8a2d\u5b9a\u5c0d\u61c9\u7684 Policy\uff0c\u8b93\u4f7f\u7528\u8005\u53ea\u80fd\u4e0a\u50b3\u5230\u81ea\u5df1\u7684\u8cc7\u6599\u593e\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Realtime \u8a02\u95b1<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u4f60\u9700\u8981\u5373\u6642\u66f4\u65b0 profile \u8cc7\u6599\uff08\u4f8b\u5982\u591a\u88dd\u7f6e\u540c\u6b65\uff09\uff0c\u53ef\u4ee5\u4f7f\u7528 Realtime\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-23\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u8a02\u95b1 profiles \u8868\u7684\u8b8a\u66f4<\/span>\n<span class=\"hljs-keyword\">const<\/span> channel = supabase\n  .channel(<span class=\"hljs-string\">'profile-changes'<\/span>)\n  .on(\n    <span class=\"hljs-string\">'postgres_changes'<\/span>,\n    {\n      <span class=\"hljs-attr\">event<\/span>: <span class=\"hljs-string\">'*'<\/span>,\n      <span class=\"hljs-attr\">schema<\/span>: <span class=\"hljs-string\">'public'<\/span>,\n      <span class=\"hljs-attr\">table<\/span>: <span class=\"hljs-string\">'profiles'<\/span>,\n      <span class=\"hljs-attr\">filter<\/span>: <span class=\"hljs-string\">`id=eq.<span class=\"hljs-subst\">${userId}<\/span>`<\/span>,\n    },\n    (payload) =&gt; {\n      <span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">'Profile \u66f4\u65b0\u4e86:'<\/span>, payload.new)\n      <span class=\"hljs-comment\">\/\/ \u66f4\u65b0 UI<\/span>\n    }\n  )\n  .subscribe()\n\n<span class=\"hljs-comment\">\/\/ \u53d6\u6d88\u8a02\u95b1<\/span>\n<span class=\"hljs-comment\">\/\/ channel.unsubscribe()<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-23\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u5e38\u898b\u554f\u984c\u8207\u89e3\u6c7a\u65b9\u6848<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Trigger \u5931\u6557\u5c0e\u81f4\u7121\u6cd5\u8a3b\u518a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c trigger function \u6709\u932f\u8aa4\uff0c\u6703\u5c0e\u81f4\u6574\u500b\u8a3b\u518a\u6d41\u7a0b\u5931\u6557\u3002\u5efa\u8b70\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5728\u90e8\u7f72\u524d\u5fb9\u5e95\u6e2c\u8a66 trigger function<\/li>\n<li>\u4f7f\u7528 <code>try-catch<\/code> \u5305\u88dd\u908f\u8f2f\uff08\u96d6\u7136 PL\/pgSQL \u8a9e\u6cd5\u4e0d\u540c\uff09<\/li>\n<li>\u78ba\u4fdd <code>security definer<\/code> \u8a2d\u5b9a\u6b63\u78ba<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">RLS \u5c0e\u81f4\u67e5\u8a62\u6c92\u6709\u7d50\u679c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Policy \u662f\u5426\u6b63\u78ba\u8a2d\u5b9a <code>to authenticated<\/code><\/li>\n<li>\u4f7f\u7528\u8005\u662f\u5426\u5df2\u767b\u5165<\/li>\n<li><code>auth.uid()<\/code> \u662f\u5426\u6b63\u78ba\u5c0d\u61c9\u5230 profile \u7684 id<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">\u6b04\u4f4d\u9a57\u8b49<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">RLS \u7121\u6cd5\u9650\u5236\u7279\u5b9a\u6b04\u4f4d\u7684\u66f4\u65b0\u3002\u5982\u679c\u9700\u8981\u9632\u6b62\u4f7f\u7528\u8005\u4fee\u6539 <code>id<\/code> \u6216\u5176\u4ed6\u6b04\u4f4d\uff0c\u53ef\u4ee5\u4f7f\u7528 trigger\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-24\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">create <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">protect_profile_id<\/span>(<span class=\"hljs-params\"><\/span>)\n<span class=\"hljs-title\">returns<\/span> <span class=\"hljs-title\">trigger<\/span>\n<span class=\"hljs-title\">language<\/span> <span class=\"hljs-title\">plpgsql<\/span>\n<span class=\"hljs-title\">as<\/span> <span class=\"hljs-title\">$$<\/span>\n<span class=\"hljs-title\">begin<\/span>\n  <span class=\"hljs-title\">if<\/span> <span class=\"hljs-title\">new<\/span>.<span class=\"hljs-title\">id<\/span> != <span class=\"hljs-title\">old<\/span>.<span class=\"hljs-title\">id<\/span> <span class=\"hljs-title\">then<\/span>\n    <span class=\"hljs-title\">raise<\/span> <span class=\"hljs-title\">exception<\/span> '<span class=\"hljs-title\">Cannot<\/span> <span class=\"hljs-title\">change<\/span> <span class=\"hljs-title\">profile<\/span> <span class=\"hljs-title\">id<\/span>';\n  <span class=\"hljs-title\">end<\/span> <span class=\"hljs-title\">if<\/span>;\n  <span class=\"hljs-title\">return<\/span> <span class=\"hljs-title\">new<\/span>;\n<span class=\"hljs-title\">end<\/span>;\n<span class=\"hljs-title\">$$<\/span>;\n\n<span class=\"hljs-title\">create<\/span> <span class=\"hljs-title\">trigger<\/span> <span class=\"hljs-title\">prevent_id_change<\/span>\n  <span class=\"hljs-title\">before<\/span> <span class=\"hljs-title\">update<\/span> <span class=\"hljs-title\">on<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">profiles<\/span>\n  <span class=\"hljs-title\">for<\/span> <span class=\"hljs-title\">each<\/span> <span class=\"hljs-title\">row<\/span> <span class=\"hljs-title\">execute<\/span> <span class=\"hljs-title\">procedure<\/span> <span class=\"hljs-title\">public<\/span>.<span class=\"hljs-title\">protect_profile_id<\/span>(<span class=\"hljs-params\"><\/span>);\n<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-24\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u7cfb\u7d71\u67b6\u69cb\u7e3d\u89bd<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b93\u6211\u5011\u7528\u4e00\u5f35\u5716\u4f86\u7e3d\u7d50\u6574\u500b\u7cfb\u7d71\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-25\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">                     \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n                     \u2502   \u524d\u7aef\u61c9\u7528\u7a0b\u5f0f   \u2502\n                     \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                              \u2502\n                              <span class=\"hljs-selector-tag\">v<\/span>\n                     \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n                     \u2502 <span class=\"hljs-selector-tag\">Supabase<\/span> <span class=\"hljs-selector-tag\">Client<\/span> \u2502\n                     \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                              \u2502\n         \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n         \u2502                    \u2502                    \u2502\n         <span class=\"hljs-selector-tag\">v<\/span>                    <span class=\"hljs-selector-tag\">v<\/span>                    <span class=\"hljs-selector-tag\">v<\/span>\n   \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510        \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510        \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n   \u2502   <span class=\"hljs-selector-tag\">Auth<\/span>   \u2502        \u2502 <span class=\"hljs-selector-tag\">Database<\/span> \u2502        \u2502 <span class=\"hljs-selector-tag\">Storage<\/span>  \u2502\n   \u2502 (\u8a8d\u8b49)   \u2502        \u2502 (\u8cc7\u6599\u5eab) \u2502        \u2502 (\u6a94\u6848)   \u2502\n   \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2518        \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2518        \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n        \u2502                   \u2502\n        \u2502  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n        \u2502  \u2502                                  \u2502\n        <span class=\"hljs-selector-tag\">v<\/span>  <span class=\"hljs-selector-tag\">v<\/span>                                  <span class=\"hljs-selector-tag\">v<\/span>\n   \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510                   \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n   \u2502  <span class=\"hljs-selector-tag\">auth<\/span><span class=\"hljs-selector-class\">.users<\/span>  \u2502                   \u2502  <span class=\"hljs-selector-tag\">profiles<\/span>   \u2502\n   \u2502  (\u7cfb\u7d71\u8868)    \u2502\u2500\u2500\u2500\u2500\u2500 <span class=\"hljs-selector-tag\">Trigger<\/span> \u2500\u2500\u2500\u2500&gt;\u2502  (\u81ea\u8a02\u8868)   \u2502\n   \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518                   \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                                            \u2502\n                                            <span class=\"hljs-selector-tag\">v<\/span>\n                                      \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n                                      \u2502   <span class=\"hljs-selector-tag\">RLS<\/span>    \u2502\n                                      \u2502 <span class=\"hljs-selector-tag\">Policies<\/span> \u2502\n                                      \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-25\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u91cd\u9ede\u56de\u9867<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>profiles \u8868\u8a2d\u8a08<\/strong>\uff1a\u4f7f\u7528 UUID \u4f5c\u70ba\u4e3b\u9375\uff0c\u900f\u904e\u5916\u9375\u95dc\u806f\u5230 auth.users\uff0c\u8a2d\u5b9a <code>on delete cascade<\/code><\/li>\n<li><strong>Database Trigger<\/strong>\uff1a\u4f7f\u7528 <code>security definer<\/code> \u8b93 function \u6709\u6b0a\u9650\u5beb\u5165 public schema\uff0c\u5728\u4f7f\u7528\u8005\u8a3b\u518a\u6642\u81ea\u52d5\u5efa\u7acb profile<\/li>\n<li><strong>RLS Policy<\/strong>\uff1a\u4f7f\u7528 <code>auth.uid() = id<\/code> \u78ba\u4fdd\u4f7f\u7528\u8005\u53ea\u80fd\u5b58\u53d6\u81ea\u5df1\u7684\u8cc7\u6599<\/li>\n<li><strong>\u524d\u7aef\u6574\u5408<\/strong>\uff1a\u4f7f\u7528 <code>getUser()<\/code> \u53d6\u5f97\u7576\u524d\u4f7f\u7528\u8005\uff0c\u4f7f\u7528 <code>upsert<\/code> \u66f4\u65b0 profile<\/li>\n<li><strong>\u9032\u968e\u529f\u80fd<\/strong>\uff1aStorage \u982d\u50cf\u4e0a\u50b3\u3001Realtime \u5373\u6642\u8a02\u95b1<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u7cfb\u5217\u7e3d\u7d50<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u606d\u559c\u4f60\u5b8c\u6210\u4e86\u6574\u500b Supabase \u6559\u5b78\u7cfb\u5217\uff01\u8b93\u6211\u5011\u56de\u9867\u4e00\u4e0b\u5b78\u5230\u7684\u5167\u5bb9\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>#01<\/strong>\uff1a\u8a8d\u8b58 Supabase \u8207\u5c08\u6848\u8a2d\u5b9a<\/li>\n<li><strong>#02<\/strong>\uff1a\u8cc7\u6599\u5eab\u64cd\u4f5c CRUD<\/li>\n<li><strong>#03<\/strong>\uff1a\u8eab\u4efd\u9a57\u8b49 (Authentication)<\/li>\n<li><strong>#04<\/strong>\uff1aRow Level Security<\/li>\n<li><strong>#05<\/strong>\uff1a\u6574\u5408\u5be6\u6230 &#8211; \u6703\u54e1\u8cc7\u6599\u7cfb\u7d71<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u73fe\u5728\u4f60\u5df2\u7d93\u5177\u5099\u4e86\u4f7f\u7528 Supabase \u958b\u767c\u5b8c\u6574\u61c9\u7528\u7a0b\u5f0f\u7684\u80fd\u529b\u3002\u63a5\u4e0b\u4f86\u53ef\u4ee5\u7e7c\u7e8c\u63a2\u7d22\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Supabase Edge Functions\uff08Serverless Functions\uff09<\/li>\n<li>Supabase Vector\uff08AI\/\u5411\u91cf\u641c\u5c0b\uff09<\/li>\n<li>\u66f4\u8907\u96dc\u7684 RLS \u8a2d\u8a08\uff08\u591a\u89d2\u8272\u3001\u7d44\u7e54\u67b6\u69cb\uff09<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u795d\u4f60\u958b\u767c\u9806\u5229\uff01<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u53c3\u8003\u8cc7\u6e90<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/supabase.com\/docs\/guides\/auth\/managing-user-data\">Supabase User Management Documentation<\/a><\/li>\n<li><a href=\"https:\/\/supabase.com\/docs\/guides\/database\/postgres\/row-level-security\">Supabase Row Level Security<\/a><\/li>\n<li><a href=\"https:\/\/supabase.com\/docs\/guides\/getting-started\/tutorials\/with-react\">Build a User Management App with React<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"quiz-advanced\">\n<style>\n#quiz-advanced .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-advanced .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-advanced .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-advanced .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-advanced .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-advanced .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-advanced .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-advanced .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-advanced .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-advanced .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-advanced .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-advanced .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-advanced .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-advanced .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-advanced .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-advanced .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-advanced .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1aSupabase \u6574\u5408\u5be6\u6230 &#8211; \u6253\u9020\u5b8c\u6574\u7684\u6703\u54e1\u8cc7\u6599\u7cfb\u7d71<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u6240\u5b78\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u6b63\u5728\u5efa\u7acb\u4e00\u500b\u6703\u54e1\u7cfb\u7d71\uff0c\u9700\u8981\u8b93\u4f7f\u7528\u8005\u80fd\u5920\u66f4\u65b0\u81ea\u5df1\u7684 profile\uff0c\u4f46\u4e0d\u80fd\u4fee\u6539\u5176\u4ed6\u4eba\u7684\u8cc7\u6599\u3002\u4f60\u61c9\u8a72\u5982\u4f55\u8a2d\u8a08 RLS Policy\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'C')\">A. \u53ea\u8a2d\u5b9a <code>using (auth.uid() = id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'C')\">B. \u53ea\u8a2d\u5b9a <code>with check (auth.uid() = id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'C')\">C. \u540c\u6642\u8a2d\u5b9a <code>using (auth.uid() = id)<\/code> \u548c <code>with check (auth.uid() = id)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'C')\">D. \u8a2d\u5b9a <code>using (true)<\/code> \u642d\u914d\u524d\u7aef\u9a57\u8b49<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u5718\u968a\u6210\u54e1\u5728\u6e2c\u8a66\u8a3b\u518a\u529f\u80fd\u6642\uff0c\u767c\u73fe\u65b0\u4f7f\u7528\u8005\u8a3b\u518a\u5f8c profiles \u8868\u6c92\u6709\u81ea\u52d5\u5efa\u7acb\u8a18\u9304\u3002\u4ee5\u4e0b\u662f trigger function \u7684\u7a0b\u5f0f\u78bc\uff1a<span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">create function public.handle_new_user()\nreturns trigger\nlanguage plpgsql\nas $$\nbegin\n  insert into public.profiles (id, full_name)\n  values (\n    new.id,\n    new.raw_user_meta_data ->> &#8216;full_name&#8217;\n  );\n  return new;\nend;\n$$;<\/div>\n      <p>\u6700\u53ef\u80fd\u7684\u554f\u984c\u662f\u4ec0\u9ebc\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'B')\">A. <code>new.id<\/code> \u8a9e\u6cd5\u932f\u8aa4\uff0c\u61c9\u8a72\u7528 <code>NEW.id<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'B')\">B. \u7f3a\u5c11 <code>security definer<\/code>\uff0csupabase_auth_admin \u6c92\u6709\u6b0a\u9650\u5beb\u5165 public schema<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'B')\">C. <code>-&gt;&gt;<\/code> \u904b\u7b97\u5b50\u7121\u6cd5\u7528\u65bc JSONB \u6b04\u4f4d<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'B')\">D. \u6c92\u6709\u8a2d\u5b9a <code>return new<\/code>\uff0c\u5c0e\u81f4 trigger \u5931\u6557<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u9700\u8981\u5728\u4f7f\u7528\u8005\u8a3b\u518a\u6642\u5c07\u4ed6\u5011\u8f38\u5165\u7684\u66b1\u7a31\u5b58\u5165 profiles \u8868\u3002\u8a3b\u518a\u8868\u55ae\u8981\u5982\u4f55\u50b3\u905e\u9019\u500b\u8cc7\u6599\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. \u8a3b\u518a\u6210\u529f\u5f8c\uff0c\u53e6\u5916\u547c\u53eb API \u5c07\u8cc7\u6599\u5b58\u5165 profiles<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. \u76f4\u63a5\u5728\u524d\u7aef\u4fee\u6539 auth.users \u8868\u7684\u6b04\u4f4d<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. \u5c07\u66b1\u7a31\u653e\u5728 email \u6b04\u4f4d\u7684\u8a3b\u89e3\u4e2d<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. \u4f7f\u7528 <code>signUp<\/code> \u7684 <code>options.data<\/code> \u50b3\u5165\uff0c\u8b93 trigger \u5f9e <code>raw_user_meta_data<\/code> \u8b80\u53d6<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u4f7f\u7528\u8005\u56de\u5831\u8aaa\u4ed6\u53ef\u4ee5\u8b80\u53d6\u81ea\u5df1\u7684 profile\uff0c\u4f46\u7121\u6cd5\u66f4\u65b0\u3002\u4f60\u6aa2\u67e5\u4e86 RLS Policy \u5982\u4e0b\uff1a<span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">&#8212; SELECT Policy\ncreate policy &#8220;Users can view own profile&#8221;\non public.profiles for select\nto authenticated\nusing (auth.uid() = id);\n\n&#8212; UPDATE Policy\ncreate policy &#8220;Users can update own profile&#8221;\non public.profiles for update\nto anon\nusing (auth.uid() = id)\nwith check (auth.uid() = id);<\/div>\n      <p>\u554f\u984c\u51fa\u5728\u54ea\u88e1\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'A')\">A. UPDATE Policy \u7684 <code>to anon<\/code> \u61c9\u8a72\u6539\u70ba <code>to authenticated<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'A')\">B. UPDATE Policy \u4e0d\u61c9\u8a72\u540c\u6642\u6709 <code>using<\/code> \u548c <code>with check<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'A')\">C. SELECT Policy \u6c92\u6709\u8a2d\u5b9a <code>with check<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'A')\">D. \u5169\u500b Policy \u7684\u540d\u7a31\u4e0d\u80fd\u6709\u7a7a\u683c<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u4f60\u767c\u73fe\u6709\u60e1\u610f\u4f7f\u7528\u8005\u900f\u904e API \u5617\u8a66\u628a\u81ea\u5df1\u7684 profile id \u6539\u6210\u5225\u4eba\u7684 id\uff0c\u60f3\u8981\u5192\u5145\u5176\u4ed6\u4f7f\u7528\u8005\u3002\u5982\u4f55\u9632\u6b62\u9019\u7a2e\u653b\u64ca\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. \u4f7f\u7528 RLS Policy \u7684 <code>using<\/code> \u5b50\u53e5\u9650\u5236\u5b58\u53d6<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u5728\u524d\u7aef\u9a57\u8b49\u4f7f\u7528\u8005\u8f38\u5165\u7684 id<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u5efa\u7acb BEFORE UPDATE trigger\uff0c\u6aa2\u67e5 <code>new.id != old.id<\/code> \u6642\u62cb\u51fa\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. \u5c07 id \u6b04\u4f4d\u8a2d\u70ba nullable\uff0c\u963b\u6b62\u4fee\u6539<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"\u5c0d\u65bc UPDATE \u64cd\u4f5c\uff0c<code>using<\/code> \u6c7a\u5b9a\u54ea\u4e9b\u73fe\u6709\u8a18\u9304\u53ef\u4ee5\u88ab\u9078\u4e2d\u66f4\u65b0\uff0c<code>with check<\/code> \u78ba\u4fdd\u66f4\u65b0\u5f8c\u7684\u8cc7\u6599\u4ecd\u7b26\u5408\u689d\u4ef6\u3002\u53ea\u8a2d\u5b9a\u5176\u4e2d\u4e00\u500b\u6703\u6709\u5b89\u5168\u6f0f\u6d1e\uff1a\u53ea\u6709 using \u6642\uff0c\u4f7f\u7528\u8005\u53ef\u80fd\u628a\u8cc7\u6599\u6539\u6210\u4e0d\u7b26\u5408\u689d\u4ef6\u7684\u503c\uff1b\u53ea\u6709 with check \u6642\uff0c\u6c92\u6709\u9650\u5236\u53ef\u4ee5\u9078\u4e2d\u54ea\u4e9b\u8a18\u9304\u3002\u524d\u7aef\u9a57\u8b49\u53ef\u4ee5\u88ab\u7e5e\u904e\uff0c\u7d55\u4e0d\u80fd\u55ae\u9760\u524d\u7aef\u3002\",\n        2: \"\u95dc\u9375\u554f\u984c\u662f\u7f3a\u5c11 <code>security definer set search_path = ''<\/code>\u3002\u7ba1\u7406 auth.users \u7684\u89d2\u8272\u662f supabase_auth_admin\uff0c\u5b83\u6c92\u6709\u6b0a\u9650\u5beb\u5165 public schema\u3002\u4f7f\u7528 security definer \u53ef\u4ee5\u8b93 function \u4ee5\u5efa\u7acb\u8005\uff08postgres\uff09\u7684\u6b0a\u9650\u57f7\u884c\uff0c\u7e5e\u904e\u9019\u500b\u9650\u5236\u3002\u7a0b\u5f0f\u78bc\u4e2d\u7684 new.id \u5beb\u6cd5\u6b63\u78ba\uff08PL\/pgSQL \u4e0d\u5206\u5927\u5c0f\u5beb\uff09\uff0c->> \u904b\u7b97\u5b50\u4e5f\u6b63\u78ba\uff0creturn new \u4e5f\u6709\u5beb\u3002\",\n        3: \"\u6700\u4f73\u505a\u6cd5\u662f\u4f7f\u7528 <code>signUp<\/code> \u65b9\u6cd5\u7684 <code>options.data<\/code> \u53c3\u6578\u50b3\u5165\u984d\u5916\u8cc7\u6599\u3002\u9019\u4e9b\u8cc7\u6599\u6703\u5b58\u5165 auth.users \u7684 raw_user_meta_data \u6b04\u4f4d\uff0c\u7136\u5f8c trigger function \u53ef\u4ee5\u5f9e\u4e2d\u8b80\u53d6\u4e26\u5b58\u5165 profiles \u8868\u3002\u9078\u9805 A \u96d6\u7136\u53ef\u884c\uff0c\u4f46\u6703\u7522\u751f\u7af6\u722d\u689d\u4ef6\uff08race condition\uff09\uff0c\u53ef\u80fd\u5728 trigger \u4e4b\u524d\u6216\u4e4b\u5f8c\u57f7\u884c\u3002\u9078\u9805 B \u4e0d\u53ef\u884c\uff0c\u56e0\u70ba\u7121\u6cd5\u76f4\u63a5\u5b58\u53d6 auth.users\u3002\",\n        4: \"UPDATE Policy \u8a2d\u5b9a\u4e86 <code>to anon<\/code>\uff0c\u8868\u793a\u9019\u500b policy \u53ea\u9069\u7528\u65bc\u533f\u540d\uff08\u672a\u767b\u5165\uff09\u4f7f\u7528\u8005\u3002\u4f46 <code>auth.uid()<\/code> \u5c0d\u533f\u540d\u4f7f\u7528\u8005\u6703\u56de\u50b3 null\uff0c\u6240\u4ee5\u689d\u4ef6\u6c38\u9060\u4e0d\u6210\u7acb\u3002\u6b63\u78ba\u505a\u6cd5\u662f\u6539\u70ba <code>to authenticated<\/code>\uff0c\u8b93\u5df2\u767b\u5165\u7684\u4f7f\u7528\u8005\u624d\u80fd\u4f7f\u7528\u9019\u500b policy\u3002UPDATE \u540c\u6642\u6709 using \u548c with check \u662f\u6b63\u78ba\u7684\u505a\u6cd5\u3002\",\n        5: \"RLS \u662f\u57fa\u65bc\u300c\u884c\u300d\u7684\u5b89\u5168\u6a5f\u5236\uff0c\u7121\u6cd5\u63a7\u5236\u300c\u6b04\u4f4d\u300d\u5c64\u7d1a\u7684\u4fee\u6539\u3002\u4e00\u65e6 policy \u5141\u8a31\u4f7f\u7528\u8005\u66f4\u65b0\u81ea\u5df1\u7684 profile\uff0c\u4ed6\u53ef\u4ee5\u4fee\u6539\u8a72\u884c\u7684\u4efb\u4f55\u6b04\u4f4d\u3002\u8981\u9632\u6b62 id \u88ab\u4fee\u6539\uff0c\u9700\u8981\u4f7f\u7528 BEFORE UPDATE trigger\uff0c\u5728 function \u4e2d\u6aa2\u67e5 <code>if new.id != old.id then raise exception<\/code>\u3002\u524d\u7aef\u9a57\u8b49\u53ef\u88ab\u7e5e\u904e\uff0cnullable \u8207\u9632\u6b62\u4fee\u6539\u7121\u95dc\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1aSupabase \u6574\u5408\u5be6\u6230 &#8211; \u6253\u9020\u5b8c\u6574\u7684\u6703\u54e1\u8cc7\u6599\u7cfb\u7d71 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[197],"tags":[301,314,312,313],"class_list":["post-297","post","type-post","status-publish","format-standard","hentry","category-supabase","tag-supabase","tag-314","tag-312","tag-313"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=297"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/297\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}