{"id":773,"date":"2026-02-23T22:28:21","date_gmt":"2026-02-23T14:28:21","guid":{"rendered":"https:\/\/blog.itsmygo.uk\/2026\/02\/23\/%e3%80%90%e5%b7%a5%e7%a8%8b%e5%b8%ab%e7%9a%84%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e3%80%9101-%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e6%80%9d%e7%b6%ad%e5%85%a5%e9%96%80%ef%bc%9a%e5%be%9e%e9%9c%80\/"},"modified":"2026-02-23T22:28:21","modified_gmt":"2026-02-23T14:28:21","slug":"%e3%80%90%e5%b7%a5%e7%a8%8b%e5%b8%ab%e7%9a%84%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e3%80%9101-%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e6%80%9d%e7%b6%ad%e5%85%a5%e9%96%80%ef%bc%9a%e5%be%9e%e9%9c%80","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/02\/23\/%e3%80%90%e5%b7%a5%e7%a8%8b%e5%b8%ab%e7%9a%84%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e3%80%9101-%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e6%80%9d%e7%b6%ad%e5%85%a5%e9%96%80%ef%bc%9a%e5%be%9e%e9%9c%80\/","title":{"rendered":"\u3010\u5de5\u7a0b\u5e2b\u7684\u7cfb\u7d71\u8a2d\u8a08\u3011#01 \u7cfb\u7d71\u8a2d\u8a08\u601d\u7dad\u5165\u9580\uff1a\u5f9e\u9700\u6c42\u5230\u67b6\u69cb\u5716"},"content":{"rendered":"\n<div id=\"quiz-3393dbf4\">\n<style>\n#quiz-3393dbf4 .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-3393dbf4 .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-3393dbf4 .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-3393dbf4 .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-3393dbf4 .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-3393dbf4 .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-3393dbf4 .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-3393dbf4 .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-3393dbf4 .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-3393dbf4 .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-3393dbf4 .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-3393dbf4 .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-3393dbf4 .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-3393dbf4 .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\uff1a\u7cfb\u7d71\u8a2d\u8a08\u601d\u7dad\u5165\u9580 &#8212; \u5f9e\u9700\u6c42\u5230\u67b6\u69cb\u5716<\/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. \u300c\u5beb\u7a0b\u5f0f\u300d\u548c\u300c\u7cfb\u7d71\u8a2d\u8a08\u300d\u7684\u6838\u5fc3\u5dee\u7570\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u5beb\u7a0b\u5f0f\u95dc\u6ce8\u6548\u80fd\uff0c\u7cfb\u7d71\u8a2d\u8a08\u95dc\u6ce8\u6b63\u78ba\u6027<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u5beb\u7a0b\u5f0f\u89e3\u6c7a\u300c\u600e\u9ebc\u505a\u300d\uff0c\u7cfb\u7d71\u8a2d\u8a08\u89e3\u6c7a\u300c\u600e\u9ebc\u7d44\u5408\u300d<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u5beb\u7a0b\u5f0f\u7528\u4e00\u7a2e\u8a9e\u8a00\uff0c\u7cfb\u7d71\u8a2d\u8a08\u7528\u591a\u7a2e\u8a9e\u8a00<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u5beb\u7a0b\u5f0f\u4e0d\u9700\u8981\u67b6\u69cb\uff0c\u7cfb\u7d71\u8a2d\u8a08\u4e0d\u9700\u8981\u7a0b\u5f0f\u78bc<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u4e0b\u5217\u54ea\u4e00\u9805\u5c6c\u65bc\u300c\u975e\u529f\u80fd\u6027\u9700\u6c42\u300d\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u4f7f\u7528\u8005\u53ef\u4ee5\u8f38\u5165\u9577\u7db2\u5740\uff0c\u7522\u751f\u77ed\u7db2\u5740<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u8a2a\u554f\u77ed\u7db2\u5740\u6642\u8981\u91cd\u65b0\u5c0e\u5411\u5230\u539f\u59cb\u7db2\u5740<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u7cfb\u7d71 99.9% \u7684\u6642\u9593\u5fc5\u9808\u53ef\u7528\uff0c\u4e00\u5e74\u6700\u591a\u639b 8.7 \u5c0f\u6642<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u77ed\u7db2\u5740\u53ef\u4ee5\u8a2d\u5b9a\u904e\u671f\u6642\u9593<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5728\u77ed\u7db2\u5740\u670d\u52d9\u7684\u4f30\u7b97\u4e2d\uff0c\u5047\u8a2d DAU \u70ba 1,000 \u842c\u3001\u6bcf\u4eba\u6bcf\u5929\u7522\u751f 0.1 \u500b\u77ed\u7db2\u5740\u3001\u8b80\u5beb\u6bd4 100:1\uff0c\u5247\u9ad8\u5cf0\u671f\u7684\u8b80\u53d6 QPS \u5927\u7d04\u662f\u591a\u5c11\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'B')\">A. 1,200 QPS<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'B')\">B. 6,000 QPS<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'B')\">C. 12,000 QPS<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'B')\">D. 60 QPS<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u5728\u67b6\u69cb\u5716\u4e2d\uff0cCache\uff08\u5feb\u53d6\uff09\u7684\u4e3b\u8981\u4f5c\u7528\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'B')\">A. \u6c38\u4e45\u5132\u5b58\u6240\u6709\u8cc7\u6599\uff0c\u53d6\u4ee3\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'B')\">B. \u66ab\u5b58\u5e38\u7528\u8cc7\u6599\uff0c\u6e1b\u5c11\u8cc7\u6599\u5eab\u67e5\u8a62\u4ee5\u52a0\u901f\u8b80\u53d6<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'B')\">C. \u628a\u6d41\u91cf\u5206\u6563\u5230\u591a\u53f0\u4f3a\u670d\u5668<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'B')\">D. \u628a\u57df\u540d\u8f49\u6210 IP \u4f4d\u5740<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5728\u77ed\u7db2\u5740\u670d\u52d9\u7684 FastAPI \u7bc4\u4f8b\u4e2d\uff0c\u7c21\u6613\u7248\u4f7f\u7528 Python <code>dict<\/code> \u7576\u8cc7\u6599\u5eab\u3002\u70ba\u4ec0\u9ebc\u6b63\u5f0f\u7248\u9700\u8981\u63db\u6210 PostgreSQL\uff1f<\/h3>\n      <div class=\"code-block\">url_db: dict[str, str] = {}   # { &#8220;abc123&#8221;: &#8220;https:\/\/long-url.com\/&#8230;&#8221; }<\/div>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'C')\">A. dict \u7684\u67e5\u8a62\u901f\u5ea6\u592a\u6162\uff0cPostgreSQL \u6bd4\u8f03\u5feb<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'C')\">B. dict \u7121\u6cd5\u5132\u5b58\u5b57\u4e32\u985e\u578b\u7684 value<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'C')\">C. dict \u5b58\u5728\u8a18\u61b6\u9ad4\u4e2d\uff0c\u91cd\u555f\u5f8c\u8cc7\u6599\u6703\u907a\u5931<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'C')\">D. dict \u4e0d\u652f\u63f4 Base62 \u7de8\u78bc\u7684 key<\/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: \" \u6587\u7ae0\u660e\u78ba\u6307\u51fa\uff1a\u5beb\u7a0b\u5f0f\u89e3\u6c7a\u300c\u600e\u9ebc\u505a\u300d\uff0c\u7cfb\u7d71\u8a2d\u8a08\u89e3\u6c7a\u300c\u600e\u9ebc\u7d44\u5408\u300d\u3002\u5beb\u7a0b\u5f0f\u95dc\u6ce8\u7684\u662f\u6b63\u78ba\u6027\uff0c\u800c\u7cfb\u7d71\u8a2d\u8a08\u95dc\u6ce8\u7684\u662f\u898f\u6a21\u8207\u53ef\u9760\u6027\u3002\u9078\u9805 A \u525b\u597d\u628a\u5169\u8005\u7684\u95dc\u6ce8\u9ede\u8aaa\u53cd\u4e86\u3002\",\n        2: \" \u529f\u80fd\u6027\u9700\u6c42\u662f\u300c\u7cfb\u7d71\u80fd\u505a\u4ec0\u9ebc\u300d\uff08\u5982\u7522\u751f\u77ed\u7db2\u5740\u3001\u8f49\u5740\uff09\uff0c\u975e\u529f\u80fd\u6027\u9700\u6c42\u662f\u300c\u7cfb\u7d71\u8981\u505a\u5230\u4ec0\u9ebc\u7a0b\u5ea6\u300d\uff08\u5982\u5ef6\u9072\u3001\u541e\u5410\u91cf\u3001\u53ef\u7528\u6027\uff09\u300299.9% \u53ef\u7528\u6027\u5c6c\u65bc\u53ef\u7528\u6027\uff08Availability\uff09\u6307\u6a19\uff0c\u662f\u5178\u578b\u7684\u975e\u529f\u80fd\u6027\u9700\u6c42\u3002\",\n        3: \" \u8a08\u7b97\u904e\u7a0b\uff1a\u5e73\u5747\u5beb\u5165 QPS = 1,000 \u842c x 0.1 \/ 86,400 \u2248 12 QPS\uff0c\u5e73\u5747\u8b80\u53d6 QPS = 12 x 100 = 1,200 QPS\u3002\u9ad8\u5cf0\u671f\u7d04\u70ba\u5e73\u5747\u7684 2~5 \u500d\uff0c\u6240\u4ee5\u9ad8\u5cf0\u8b80\u53d6 QPS \u2248 6,000\u3002\u9078\u9805 A \u662f\u5e73\u5747\u503c\u800c\u975e\u9ad8\u5cf0\u503c\uff0c\u9078\u9805 D \u662f\u9ad8\u5cf0\u5beb\u5165\u91cf\u3002\",\n        4: \" \u6587\u7ae0\u4e2d Cache \u7684\u4e00\u53e5\u8a71\u8aaa\u660e\u662f\u300c\u66ab\u5b58\u5e38\u7528\u8cc7\u6599\uff0c\u52a0\u901f\u8b80\u53d6\u300d\u3002\u5b83\u89e3\u6c7a\u7684\u554f\u984c\u662f\u300c\u6bcf\u6b21\u90fd\u67e5\u8cc7\u6599\u5eab\u592a\u6162\u300d\u3002\u9078\u9805 A \u932f\u5728 Cache \u662f\u66ab\u5b58\u4e0d\u662f\u6c38\u4e45\u5132\u5b58\uff1b\u9078\u9805 C \u63cf\u8ff0\u7684\u662f Load Balancer\uff1b\u9078\u9805 D \u63cf\u8ff0\u7684\u662f DNS\u3002\",\n        5: \" \u6587\u7ae0\u5728\u300c\u5f9e\u7c21\u6613\u7248\u5230\u6b63\u5f0f\u7248\u300d\u7684\u6bd4\u8f03\u8868\u4e2d\u660e\u78ba\u6307\u51fa\uff1a\u7c21\u6613\u7248\u7528 dict \u7576\u8cc7\u6599\u5eab\uff0c\u6b63\u5f0f\u7248\u63db\u6210 PostgreSQL \u7684\u539f\u56e0\u662f\u300c\u91cd\u555f\u4e0d\u6703\u907a\u5931\u8cc7\u6599\u300d\u3002dict \u5b58\u5728\u8a18\u61b6\u9ad4\u4e2d\uff0c\u7a0b\u5f0f\u4e00\u91cd\u555f\u8cc7\u6599\u5c31\u6c92\u4e86\u3002\u5be6\u969b\u4e0a dict \u7684\u67e5\u8a62\u901f\u5ea6\uff08O(1)\uff09\u4e26\u4e0d\u6162\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\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7cfb\u7d71\u8a2d\u8a08\u5c31\u662f\u6c7a\u5b9a\u300c\u54ea\u4e9b\u5143\u4ef6\u3001\u600e\u9ebc\u7d44\u5408\u300d\uff0c\u8b93\u670d\u52d9\u5728\u5927\u91cf\u4f7f\u7528\u8005\u4e0b\u4f9d\u7136\u7a69\u5b9a\u904b\u4f5c\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u8a00\uff1a\u5beb\u7a0b\u5f0f\u8ddf\u7cfb\u7d71\u8a2d\u8a08\u6709\u4ec0\u9ebc\u4e0d\u540c\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5f88\u591a\u4eba\u80fd\u5beb\u51fa\u4e00\u500b\u529f\u80fd\u5b8c\u6574\u7684\u77ed\u7db2\u5740\u670d\u52d9\uff0c\u4f46\u88ab\u554f\u5230\u300c\u5982\u679c\u6bcf\u5929\u6709\u4e00\u5104\u4eba\u7528\u5462\uff1f\u300d\u5c31\u5361\u4f4f\u4e86\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u5c31\u662f\u7cfb\u7d71\u8a2d\u8a08\u8981\u89e3\u6c7a\u7684\u554f\u984c\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u5beb\u7a0b\u5f0f<\/th>\n<th>\u7cfb\u7d71\u8a2d\u8a08<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u89e3\u6c7a\u300c\u600e\u9ebc\u505a\u300d<\/td>\n<td>\u89e3\u6c7a\u300c\u600e\u9ebc\u7d44\u5408\u300d<\/td>\n<\/tr>\n<tr>\n<td>\u4e00\u53f0\u96fb\u8166\u3001\u4e00\u500b\u7a0b\u5f0f<\/td>\n<td>\u591a\u53f0\u6a5f\u5668\u3001\u591a\u500b\u670d\u52d9\u5354\u4f5c<\/td>\n<\/tr>\n<tr>\n<td>\u95dc\u6ce8\u6b63\u78ba\u6027<\/td>\n<td>\u95dc\u6ce8\u898f\u6a21\u8207\u53ef\u9760\u6027<\/td>\n<\/tr>\n<tr>\n<td>\u8f38\u5165 \u2192 \u8f38\u51fa<\/td>\n<td>\u9700\u6c42 \u2192 \u67b6\u69cb \u2192 \u5143\u4ef6 \u2192 \u9023\u63a5\u65b9\u5f0f<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u5beb\u7a0b\u5f0f\u662f\u84cb\u4e00\u9593\u623f\u9593\uff0c\u7cfb\u7d71\u8a2d\u8a08\u662f\u898f\u5283\u4e00\u68df\u5927\u6a13 &#8212; \u8981\u8003\u616e\u96fb\u68af\u3001\u6c34\u7ba1\u3001\u9003\u751f\u8def\u7dda\u600e\u9ebc\u914d\u7f6e\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c\u4e00\u6b65\uff1a\u9700\u6c42\u5206\u6790 &#8212; \u641e\u6e05\u695a\u5230\u5e95\u8981\u505a\u4ec0\u9ebc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7cfb\u7d71\u8a2d\u8a08\u7684\u8d77\u9ede\u6c38\u9060\u662f\u9700\u6c42\u3002\u9700\u6c42\u5206\u5169\u7a2e\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u529f\u80fd\u6027\u9700\u6c42\uff08Functional Requirements\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c\u7cfb\u7d71\u8981\u80fd\u505a\u4ec0\u9ebc\u4e8b\u300d\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\"><span><code class=\"hljs\">\u77ed\u7db2\u5740\u670d\u52d9\u7684\u529f\u80fd\u6027\u9700\u6c42\uff1a\n1. \u7d66\u4e00\u500b\u9577\u7db2\u5740 \u2192 \u7522\u751f\u4e00\u500b\u77ed\u7db2\u5740\n2. \u8a2a\u554f\u77ed\u7db2\u5740 \u2192 \u91cd\u65b0\u5c0e\u5411\u5230\u539f\u59cb\u9577\u7db2\u5740\n3. \uff08\u53ef\u9078\uff09\u53ef\u4ee5\u81ea\u8a02\u77ed\u7db2\u5740\n4. \uff08\u53ef\u9078\uff09\u77ed\u7db2\u5740\u6709\u904e\u671f\u6642\u9593\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4e00\u53e5\u8a71<\/strong>\uff1a\u529f\u80fd\u6027\u9700\u6c42\u5c31\u662f\u300c\u4f7f\u7528\u8005\u80fd\u505a\u4ec0\u9ebc\u300d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u975e\u529f\u80fd\u6027\u9700\u6c42\uff08Non-Functional Requirements\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c\u7cfb\u7d71\u8981\u505a\u5230\u4ec0\u9ebc\u7a0b\u5ea6\u300d\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6307\u6a19<\/th>\n<th>\u610f\u601d<\/th>\n<th>\u7bc4\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u5ef6\u9072\uff08Latency\uff09<\/td>\n<td>\u56de\u61c9\u901f\u5ea6<\/td>\n<td>\u77ed\u7db2\u5740\u8f49\u5740\u8981\u5728 100ms \u5167\u5b8c\u6210<\/td>\n<\/tr>\n<tr>\n<td>\u541e\u5410\u91cf\uff08Throughput\uff09<\/td>\n<td>\u6bcf\u79d2\u8655\u7406\u91cf<\/td>\n<td>\u6bcf\u79d2\u80fd\u8655\u7406 10,000 \u6b21\u8f49\u5740<\/td>\n<\/tr>\n<tr>\n<td>\u53ef\u7528\u6027\uff08Availability\uff09<\/td>\n<td>\u4e0d\u639b\u6389\u7684\u6642\u9593\u6bd4\u4f8b<\/td>\n<td>99.9% \u6642\u9593\u53ef\u7528\uff08\u4e00\u5e74\u6700\u591a\u639b 8.7 \u5c0f\u6642\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u4e00\u81f4\u6027\uff08Consistency\uff09<\/td>\n<td>\u8cc7\u6599\u6b63\u78ba\u6027<\/td>\n<td>\u5efa\u7acb\u7684\u77ed\u7db2\u5740\u99ac\u4e0a\u5c31\u80fd\u7528<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4e00\u53e5\u8a71<\/strong>\uff1a\u975e\u529f\u80fd\u6027\u9700\u6c42\u5c31\u662f\u300c\u7cfb\u7d71\u8981\u6709\u591a\u5feb\u3001\u591a\u7a69\u3001\u591a\u5927\u300d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u7cfb\u7d71\u8a2d\u8a08\u8a0e\u8ad6\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u529f\u80fd\u6027\u9700\u6c42\u6709\u5217\u6e05\u695a\u55ce\uff1f\uff08\u4f7f\u7528\u8005\u80fd\u505a\u4ec0\u9ebc\uff09<\/li>\n\n\n<li>[ ] \u975e\u529f\u80fd\u6027\u9700\u6c42\u6709\u91cf\u5316\u55ce\uff1f\uff08\u4e0d\u662f\u300c\u8981\u5feb\u300d\uff0c\u800c\u662f\u300c100ms \u5167\u300d\uff09<\/li>\n\n\n<li>[ ] \u6709\u6c92\u6709\u907a\u6f0f\u7684\u908a\u754c\u60c5\u6cc1\uff1f\uff08\u904e\u671f\u3001\u91cd\u8907\u3001\u932f\u8aa4\u8655\u7406\uff09<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c\u4e8c\u6b65\uff1a\u4f30\u7b97\u601d\u7dad &#8212; \u6578\u5b57\u6703\u8aaa\u8a71<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9762\u8a66\u6216\u5be6\u6230\u4e2d\uff0c\u62ff\u5230\u9700\u6c42\u5f8c\u7b2c\u4e00\u4ef6\u4e8b\u5c31\u662f\u300c\u4f30\u7b97\u300d\u3002\u9019\u53eb <strong>Back-of-the-envelope estimation<\/strong>\uff08\u4fe1\u5c01\u80cc\u9762\u4f30\u7b97\uff09\uff0c\u4e0d\u9700\u8981\u7cbe\u78ba\uff0c\u4f46\u8981\u6709\u91cf\u7d1a\u6982\u5ff5\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u77ed\u7db2\u5740\u670d\u52d9\u7684\u4f30\u7b97\u7bc4\u4f8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5047\u8a2d\u689d\u4ef6\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=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">-<\/span> <span class=\"hljs-selector-tag\">DAU<\/span>\uff08\u6bcf\u65e5\u6d3b\u8e8d\u4f7f\u7528\u8005\uff09\uff1a1,000 \u842c\n<span class=\"hljs-selector-tag\">-<\/span> \u6bcf\u500b\u4f7f\u7528\u8005\u6bcf\u5929\u7522\u751f 0<span class=\"hljs-selector-class\">.1<\/span> \u500b\u77ed\u7db2\u5740\uff08\u5927\u90e8\u5206\u4eba\u53ea\u662f\u8b80\u53d6\uff09\n<span class=\"hljs-selector-tag\">-<\/span> \u8b80\u5beb\u6bd4\uff1a100<span class=\"hljs-selector-pseudo\">:1<\/span>\uff08\u8b80\u53d6\u9060\u591a\u65bc\u5beb\u5165\uff09\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><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\">\u958b\u59cb\u7b97\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\"><span><code class=\"hljs\">\u5beb\u5165 QPS\uff08\u6bcf\u79d2\u5beb\u5165\u91cf\uff09\uff1a\n  1,000 \u842c x 0.1 \/ 86,400 \u79d2 \u2248 12 QPS\n\n\u8b80\u53d6 QPS\uff08\u6bcf\u79d2\u8b80\u53d6\u91cf\uff09\uff1a\n  12 x 100 = 1,200 QPS\n\n\u9ad8\u5cf0\u671f\uff08\u5c16\u5cf0\u7d04\u70ba\u5e73\u5747\u7684 2~5 \u500d\uff09\uff1a\n  \u5beb\u5165\uff1a60 QPS\n  \u8b80\u53d6\uff1a6,000 QPS\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u5132\u5b58\u91cf\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-2\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\u6bcf\u7b46\u8cc7\u6599\u5927\u7d04\uff1a\n  \u77ed\u7db2\u5740\uff087 \u5b57\u5143\uff09+ \u9577\u7db2\u5740\uff08\u5e73\u5747 200 \u5b57\u5143\uff09+ \u5efa\u7acb\u6642\u9593 \u2248 250 <span class=\"hljs-selector-tag\">bytes<\/span>\n\n\u6bcf\u5929\u65b0\u589e\uff1a100 \u842c\u7b46\n\u6bcf\u5e74\u65b0\u589e\uff1a3<span class=\"hljs-selector-class\">.65<\/span> \u5104\u7b46\n5 \u5e74\u5132\u5b58\uff1a3<span class=\"hljs-selector-class\">.65<\/span> \u5104 <span class=\"hljs-selector-tag\">x<\/span> 5 <span class=\"hljs-selector-tag\">x<\/span> 250 <span class=\"hljs-selector-tag\">bytes<\/span> \u2248 456 <span class=\"hljs-selector-tag\">GB<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><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<h3 class=\"wp-block-heading\">\u5e38\u7528\u6578\u5b57\u901f\u67e5\u8868<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a18\u4f4f\u9019\u4e9b\u6578\u5b57\uff0c\u4f30\u7b97\u6642\u5f88\u597d\u7528\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u9805\u76ee<\/th>\n<th>\u6578\u503c<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u4e00\u5929\u6709\u5e7e\u79d2<\/td>\n<td>~86,400\uff08\u8a18\u6210 ~10 \u842c\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u4e00\u5e74\u6709\u5e7e\u79d2<\/td>\n<td>~3,100 \u842c\uff08\u8a18\u6210 ~3 x 10^7\uff09<\/td>\n<\/tr>\n<tr>\n<td>1 KB<\/td>\n<td>1,000 bytes<\/td>\n<\/tr>\n<tr>\n<td>1 MB<\/td>\n<td>1,000 KB<\/td>\n<\/tr>\n<tr>\n<td>1 GB<\/td>\n<td>1,000 MB<\/td>\n<\/tr>\n<tr>\n<td>1 TB<\/td>\n<td>1,000 GB<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u4e00\u53e5\u8a71<\/strong>\uff1a\u4f30\u7b97\u4e0d\u9700\u8981\u7cbe\u78ba\u5230\u500b\u4f4d\u6578\uff0c\u53ea\u8981\u77e5\u9053\u91cf\u7d1a\u662f\u300c\u5e7e\u767e QPS\u300d\u9084\u662f\u300c\u5e7e\u842c QPS\u300d\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c\u4e09\u6b65\uff1a\u756b\u67b6\u69cb\u5716 &#8212; \u7cfb\u7d71\u8a2d\u8a08\u7684\u6838\u5fc3\u8f38\u51fa<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u67b6\u69cb\u5716\u662f\u7cfb\u7d71\u8a2d\u8a08\u6700\u91cd\u8981\u7684\u7522\u51fa\u3002\u4ee5\u4e0b\u662f\u6700\u5e38\u898b\u7684\u5143\u4ef6\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u57fa\u672c\u67b6\u69cb\u5143\u4ef6<\/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\"><span><code class=\"hljs\">Client\uff08\u4f7f\u7528\u8005\u7aef\uff09\n  \u2193\nDNS\uff08\u57df\u540d\u89e3\u6790\uff09\n  \u2193\nLoad Balancer\uff08\u8ca0\u8f09\u5747\u8861\u5668\uff09\n  \u2193  \u2193  \u2193\nWeb Server  Web Server  Web Server\uff08\u591a\u53f0\u5206\u6563\u6d41\u91cf\uff09\n  \u2193\nApplication Server\uff08\u61c9\u7528\u908f\u8f2f\uff09\n  \u2193           \u2193\nDatabase     Cache\uff08\u5feb\u53d6\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6bcf\u500b\u5143\u4ef6\u7ffb\u8b6f\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u5143\u4ef6<\/th>\n<th>\u7ffb\u8b6f<\/th>\n<th>\u4e00\u53e5\u8a71\u8aaa\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Client<\/td>\n<td>\u4f7f\u7528\u8005\u7aef<\/td>\n<td>\u700f\u89bd\u5668\u6216 App<\/td>\n<\/tr>\n<tr>\n<td>DNS<\/td>\n<td>\u57df\u540d\u89e3\u6790<\/td>\n<td>\u628a <code>bit.ly<\/code> \u8f49\u6210 IP \u4f4d\u5740<\/td>\n<\/tr>\n<tr>\n<td>Load Balancer<\/td>\n<td>\u8ca0\u8f09\u5747\u8861\u5668<\/td>\n<td>\u628a\u6d41\u91cf\u5206\u6563\u5230\u591a\u53f0\u4f3a\u670d\u5668<\/td>\n<\/tr>\n<tr>\n<td>Web Server<\/td>\n<td>\u7db2\u9801\u4f3a\u670d\u5668<\/td>\n<td>\u63a5\u6536 HTTP \u8acb\u6c42<\/td>\n<\/tr>\n<tr>\n<td>Application Server<\/td>\n<td>\u61c9\u7528\u4f3a\u670d\u5668<\/td>\n<td>\u57f7\u884c\u5546\u696d\u908f\u8f2f<\/td>\n<\/tr>\n<tr>\n<td>Database<\/td>\n<td>\u8cc7\u6599\u5eab<\/td>\n<td>\u6c38\u4e45\u5132\u5b58\u8cc7\u6599<\/td>\n<\/tr>\n<tr>\n<td>Cache<\/td>\n<td>\u5feb\u53d6<\/td>\n<td>\u66ab\u5b58\u5e38\u7528\u8cc7\u6599\uff0c\u52a0\u901f\u8b80\u53d6<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u9700\u8981\u9019\u4e9b\u5143\u4ef6\uff1f<\/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\"><span><code class=\"hljs\">\u554f\u984c\uff1a\u4e00\u53f0\u4f3a\u670d\u5668\u6490\u4e0d\u4f4f\n\u89e3\u6cd5\uff1aLoad Balancer + \u591a\u53f0\u4f3a\u670d\u5668\n\n\u554f\u984c\uff1a\u6bcf\u6b21\u90fd\u67e5\u8cc7\u6599\u5eab\u592a\u6162\n\u89e3\u6cd5\uff1aCache \u66ab\u5b58\u71b1\u9580\u8cc7\u6599\n\n\u554f\u984c\uff1a\u8cc7\u6599\u5eab\u639b\u4e86\u5168\u90e8\u5b8c\u86cb\n\u89e3\u6cd5\uff1a\u8cc7\u6599\u5eab\u505a\u4e3b\u5f9e\u8907\u88fd\uff08Replica\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u67b6\u69cb\u5716\u5c31\u662f\u756b\u51fa\u300c\u8acb\u6c42\u5f9e\u4f7f\u7528\u8005\u51fa\u767c\uff0c\u7d93\u904e\u54ea\u4e9b\u7ad9\uff0c\u6700\u5f8c\u62ff\u5230\u7d50\u679c\u300d\u7684\u8def\u7dda\u5716\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c\u56db\u6b65\uff1a\u5be6\u6230\u7bc4\u4f8b &#8212; \u77ed\u7db2\u5740\u670d\u52d9\u7684\u5b8c\u6574\u8a2d\u8a08<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u73fe\u5728\u7528\u77ed\u7db2\u5740\u670d\u52d9\u8d70\u4e00\u904d\u5b8c\u6574\u6d41\u7a0b\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.1 API \u8a2d\u8a08<\/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-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">POST \/api\/shorten\n  \u8acb\u6c42\uff1a{ <span class=\"hljs-string\">\"long_url\"<\/span>: <span class=\"hljs-string\">\"https:\/\/very-long-url.com\/...\"<\/span> }\n  \u56de\u61c9\uff1a{ <span class=\"hljs-string\">\"short_url\"<\/span>: <span class=\"hljs-string\">\"https:\/\/short.ly\/abc123\"<\/span> }\n\nGET \/{short_code}\n  \u884c\u70ba\uff1a<span class=\"hljs-number\">302<\/span> \u91cd\u65b0\u5c0e\u5411\u5230\u539f\u59cb\u9577\u7db2\u5740\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<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u5169\u500b API &#8212; \u4e00\u500b\u300c\u7522\u751f\u77ed\u7db2\u5740\u300d\uff0c\u4e00\u500b\u300c\u7528\u77ed\u7db2\u5740\u8f49\u5740\u300d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.2 \u8cc7\u6599\u6a21\u578b<\/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-4\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">urls \u8868\u683c\uff1a\n+----+-----------+----------------------------------+-----------+\n| id | short_code| long_url                         | created_at|\n+----+-----------+----------------------------------+-----------+\n| <span class=\"hljs-number\">1<\/span>  | abc123    | https:<span class=\"hljs-comment\">\/\/very-long-url.com\/...    | 2024-01-01|<\/span>\n+----+-----------+----------------------------------+-----------+\n\n\u7d22\u5f15\uff1ashort_code\uff08\u552f\u4e00\u7d22\u5f15\uff09  \u2190 \u67e5\u8a62\u6642\u9760\u9019\u500b\u5feb\u901f\u627e\u5230\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<h3 class=\"wp-block-heading\">4.3 \u77ed\u78bc\u7522\u751f\u7b56\u7565<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u5e38\u898b\u7684\u65b9\u5f0f\u662f\u7528 Base62 \u7de8\u78bc\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-5\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import string\n\n<span class=\"hljs-comment\"># Base62 \u5b57\u5143\u96c6\uff1aa-z, A-Z, 0-9 \u5171 62 \u500b\u5b57\u5143<\/span>\nCHARS = string.ascii_letters + string.digits  <span class=\"hljs-comment\"># 'abcdefg...XYZ012...9'<\/span>\n\ndef encode_base62(num: int) -&gt; str:\n    <span class=\"hljs-string\">\"\"<\/span><span class=\"hljs-string\">\"\u628a\u6578\u5b57\u8f49\u6210 Base62 \u5b57\u4e32\"<\/span><span class=\"hljs-string\">\"\"<\/span>\n    <span class=\"hljs-keyword\">if<\/span> num == <span class=\"hljs-number\">0<\/span>:\n        <span class=\"hljs-keyword\">return<\/span> CHARS&#91;<span class=\"hljs-number\">0<\/span>]\n    result = &#91;]\n    <span class=\"hljs-keyword\">while<\/span> num &gt; <span class=\"hljs-number\">0<\/span>:\n        result.append(CHARS&#91;num % <span class=\"hljs-number\">62<\/span>])  <span class=\"hljs-comment\"># \u53d6\u9918\u6578\u5c0d\u61c9\u5b57\u5143<\/span>\n        num <span class=\"hljs-comment\">\/\/= 62                       # \u6574\u6578\u9664\u6cd5\u5f80\u4e0b\u4e00\u4f4d<\/span>\n    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-string\">''<\/span>.join(reversed(result))     <span class=\"hljs-comment\"># \u53cd\u8f49\u5f97\u5230\u6700\u7d42\u7d50\u679c<\/span>\n\n<span class=\"hljs-comment\"># \u7bc4\u4f8b<\/span>\n<span class=\"hljs-keyword\">print<\/span>(encode_base62(<span class=\"hljs-number\">1<\/span>))         <span class=\"hljs-comment\"># \u2192 'b'<\/span>\n<span class=\"hljs-keyword\">print<\/span>(encode_base62(<span class=\"hljs-number\">12345<\/span>))     <span class=\"hljs-comment\"># \u2192 'dnh'<\/span>\n<span class=\"hljs-keyword\">print<\/span>(encode_base62(<span class=\"hljs-number\">999999999<\/span>)) <span class=\"hljs-comment\"># \u2192 'bLY2Mn'<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><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<p class=\"wp-block-paragraph\">\u9010\u884c\u7ffb\u8b6f\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-6\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">CHARS = string.ascii_letters + string.digits\n<span class=\"hljs-comment\"># \u2191 \u5efa\u7acb\u5b57\u5143\u96c6\uff1a\"abcdef...XYZ0123456789\"\uff0c\u5171 62 \u500b\u5b57\u5143<\/span>\n\ndef encode_base62(num: int) -&gt; str:\n<span class=\"hljs-comment\"># \u2191 \u63a5\u6536\u4e00\u500b\u6578\u5b57\uff0c\u56de\u50b3\u4e00\u500b\u5b57\u4e32<\/span>\n\n    result.append(CHARS&#91;num % <span class=\"hljs-number\">62<\/span>])\n    <span class=\"hljs-comment\"># \u2191 num \u9664\u4ee5 62 \u7684\u9918\u6578\uff0c\u5c0d\u61c9\u5230\u5b57\u5143\u96c6\u88e1\u7684\u67d0\u500b\u5b57\u5143<\/span>\n\n    num <span class=\"hljs-comment\">\/\/= 62<\/span>\n    <span class=\"hljs-comment\"># \u2191 \u6574\u6578\u9664\u6cd5\uff0c\u8655\u7406\u4e0b\u4e00\u4f4d\uff08\u5c31\u50cf\u5341\u9032\u4f4d\u8f49\u4e8c\u9032\u4f4d\u7684\u904e\u7a0b\uff09<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><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<p class=\"wp-block-paragraph\"><strong>\u4e00\u53e5\u8a71<\/strong>\uff1aBase62 \u5c31\u662f\u300c\u628a\u6578\u5b57\u8f49\u6210\u7528 62 \u500b\u5b57\u5143\u8868\u793a\u7684\u77ed\u5b57\u4e32\u300d\uff0c7 \u500b\u5b57\u5143\u5c31\u80fd\u8868\u793a 62^7 = 3.5 \u5146\u500b\u7db2\u5740\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.4 \u6700\u5c0f\u53ef\u904b\u884c\u7bc4\u4f8b\uff1aFastAPI \u77ed\u7db2\u5740\u670d\u52d9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0b\u662f\u4e00\u500b\u53ef\u4ee5\u76f4\u63a5\u8dd1\u7684\u6700\u7c21\u7248\u672c\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\"><span><code class=\"hljs\">from fastapi import FastAPI, HTTPException\nfrom fastapi.responses import RedirectResponse\nfrom pydantic import BaseModel\nimport string\n\napp = FastAPI()\n\n# --- \u8cc7\u6599\u6a21\u578b ---\nclass ShortenRequest(BaseModel):\n    long_url: str  # \u5fc5\u9808\u63d0\u4f9b\u9577\u7db2\u5740\n\nclass ShortenResponse(BaseModel):\n    short_url: str  # \u56de\u50b3\u77ed\u7db2\u5740\n\n# --- \u7c21\u6613\u7248\uff1a\u7528 dict \u7576\u8cc7\u6599\u5eab ---\nurl_db: dict&#91;str, str] = {}   # { \"abc123\": \"https:\/\/long-url.com\/...\" }\ncounter = 0                    # \u81ea\u589e ID\uff0c\u7528\u4f86\u7522\u751f\u77ed\u78bc\n\n# --- Base62 \u7de8\u78bc ---\nCHARS = string.ascii_letters + string.digits\n\ndef encode_base62(num: int) -&gt; str:\n    if num == 0:\n        return CHARS&#91;0]\n    result = &#91;]\n    while num &gt; 0:\n        result.append(CHARS&#91;num % 62])\n        num \/\/= 62\n    return ''.join(reversed(result))\n\n# --- API 1\uff1a\u7522\u751f\u77ed\u7db2\u5740 ---\n@app.post(\"\/api\/shorten\", response_model=ShortenResponse)\ndef shorten(req: ShortenRequest):\n    global counter\n    counter += 1\n    short_code = encode_base62(counter)   # \u7528\u81ea\u589e ID \u7522\u751f\u77ed\u78bc\n    url_db&#91;short_code] = req.long_url     # \u5b58\u9032\u300c\u8cc7\u6599\u5eab\u300d\n    return ShortenResponse(short_url=f\"http:\/\/localhost:8000\/{short_code}\")\n\n# --- API 2\uff1a\u77ed\u7db2\u5740\u8f49\u5740 ---\n@app.get(\"\/{short_code}\")\ndef redirect(short_code: str):\n    long_url = url_db.get(short_code)     # \u5f9e\u300c\u8cc7\u6599\u5eab\u300d\u67e5\u627e\n    if not long_url:\n        raise HTTPException(status_code=404, detail=\"Short URL not found\")\n    return RedirectResponse(url=long_url)  # 302 \u91cd\u65b0\u5c0e\u5411\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9010\u884c\u7ffb\u8b6f\u91cd\u9ede\u90e8\u5206\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-7\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">url_db: dict&#91;str, str] = {}\n<span class=\"hljs-comment\"># \u2191 \u7528 Python \u5b57\u5178\u6a21\u64ec\u8cc7\u6599\u5eab\uff0ckey \u662f\u77ed\u78bc\uff0cvalue \u662f\u9577\u7db2\u5740<\/span>\n\ncounter = <span class=\"hljs-number\">0<\/span>\n<span class=\"hljs-comment\"># \u2191 \u7c21\u55ae\u7684\u81ea\u589e ID\uff0c\u6bcf\u6b21\u5efa\u7acb\u77ed\u7db2\u5740\u5c31 +1<\/span>\n\n@app.post(<span class=\"hljs-string\">\"\/api\/shorten\"<\/span>, response_model=ShortenResponse)\n<span class=\"hljs-comment\"># \u2191 POST \u8acb\u6c42\u5230 \/api\/shorten\uff0c\u56de\u50b3\u683c\u5f0f\u662f ShortenResponse<\/span>\n\ndef shorten(req: ShortenRequest):\n<span class=\"hljs-comment\"># \u2191 FastAPI \u81ea\u52d5\u628a request body \u89e3\u6790\u6210 ShortenRequest \u7269\u4ef6<\/span>\n\n    short_code = encode_base62(counter)\n    <span class=\"hljs-comment\"># \u2191 \u628a\u81ea\u589e ID \u8f49\u6210 Base62 \u77ed\u78bc<\/span>\n\n    <span class=\"hljs-keyword\">return<\/span> RedirectResponse(url=long_url)\n    <span class=\"hljs-comment\"># \u2191 \u56de\u50b3 302 \u91cd\u65b0\u5c0e\u5411\uff0c\u700f\u89bd\u5668\u6703\u81ea\u52d5\u8df3\u8f49\u5230\u9577\u7db2\u5740<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><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<h3 class=\"wp-block-heading\">4.5 \u5f9e\u7a0b\u5f0f\u78bc\u5c0d\u61c9\u5230\u67b6\u69cb\u5716<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u500b\u6700\u7c21\u7248\u53ea\u7528\u4e86\u67b6\u69cb\u5716\u88e1\u7684\u4e00\u5c0f\u90e8\u5206\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\"><span><code class=\"hljs\">\u67b6\u69cb\u5716\u5143\u4ef6          \u2192  \u7a0b\u5f0f\u78bc\u5c0d\u61c9\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\nClient              \u2192  \u700f\u89bd\u5668\u767c\u51fa HTTP \u8acb\u6c42\nWeb Server          \u2192  FastAPI\uff08app = FastAPI()\uff09\nApplication Server  \u2192  shorten() \u548c redirect() \u51fd\u5f0f\nDatabase            \u2192  url_db \u5b57\u5178\uff08\u6b63\u5f0f\u7248\u63db\u6210 PostgreSQL\uff09\nCache               \u2192  \uff08\u9019\u500b\u7c21\u6613\u7248\u6c92\u6709\uff0c\u6b63\u5f0f\u7248\u6703\u52a0 Redis\uff09\nLoad Balancer       \u2192  \uff08\u9019\u500b\u7c21\u6613\u7248\u6c92\u6709\uff0c\u6b63\u5f0f\u7248\u6703\u52a0 Nginx\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7ffb\u8b6f<\/strong>\uff1a\u6700\u7c21\u7248\u662f\u300c\u4e00\u53f0\u6a5f\u5668\u8dd1\u6240\u6709\u6771\u897f\u300d\u3002\u6b63\u5f0f\u7248\u8981\u628a\u6bcf\u500b\u5143\u4ef6\u7368\u7acb\u51fa\u4f86\uff0c\u5404\u53f8\u5176\u8077\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c\u4e94\u6b65\uff1a\u5f9e\u7c21\u6613\u7248\u5230\u6b63\u5f0f\u7248 &#8212; \u9700\u8981\u8003\u616e\u4ec0\u9ebc\uff1f<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u7c21\u6613\u7248<\/th>\n<th>\u6b63\u5f0f\u7248<\/th>\n<th>\u70ba\u4ec0\u9ebc<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>dict<\/code> \u7576\u8cc7\u6599\u5eab<\/td>\n<td>PostgreSQL \u6216 DynamoDB<\/td>\n<td>\u91cd\u555f\u4e0d\u6703\u907a\u5931\u8cc7\u6599<\/td>\n<\/tr>\n<tr>\n<td><code>counter<\/code> \u81ea\u589e ID<\/td>\n<td>\u5206\u6563\u5f0f ID \u7522\u751f\u5668\uff08\u5982 Snowflake\uff09<\/td>\n<td>\u591a\u53f0\u4f3a\u670d\u5668\u4e0d\u6703\u7522\u751f\u91cd\u8907 ID<\/td>\n<\/tr>\n<tr>\n<td>\u6c92\u6709\u5feb\u53d6<\/td>\n<td>Redis \u5feb\u53d6\u71b1\u9580\u77ed\u7db2\u5740<\/td>\n<td>\u6e1b\u5c11\u8cc7\u6599\u5eab\u67e5\u8a62\uff0c\u52a0\u901f\u8b80\u53d6<\/td>\n<\/tr>\n<tr>\n<td>\u55ae\u4e00\u4f3a\u670d\u5668<\/td>\n<td>Load Balancer + \u591a\u53f0\u4f3a\u670d\u5668<\/td>\n<td>\u5206\u6563\u6d41\u91cf\uff0c\u907f\u514d\u55ae\u9ede\u6545\u969c<\/td>\n<\/tr>\n<tr>\n<td>\u6c92\u6709\u76e3\u63a7<\/td>\n<td>\u52a0\u5165\u65e5\u8a8c\u3001\u6307\u6a19\u3001\u544a\u8b66<\/td>\n<td>\u51fa\u554f\u984c\u6642\u80fd\u5feb\u901f\u5b9a\u4f4d<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u6b63\u5f0f\u7248\u67b6\u69cb\u5716<\/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-8\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\u4f7f\u7528\u8005\n  \u2193\n<span class=\"hljs-selector-tag\">DNS<\/span>\uff08\u89e3\u6790 <span class=\"hljs-selector-tag\">short<\/span><span class=\"hljs-selector-class\">.ly<\/span>\uff09\n  \u2193\n<span class=\"hljs-selector-tag\">Load<\/span> <span class=\"hljs-selector-tag\">Balancer<\/span>\uff08<span class=\"hljs-selector-tag\">Nginx<\/span>\uff09\n  \u2193  \u2193  \u2193\n<span class=\"hljs-selector-tag\">App<\/span> <span class=\"hljs-selector-tag\">Server<\/span> 1  <span class=\"hljs-selector-tag\">App<\/span> <span class=\"hljs-selector-tag\">Server<\/span> 2  <span class=\"hljs-selector-tag\">App<\/span> <span class=\"hljs-selector-tag\">Server<\/span> 3\n  \u2193                \u2193              \u2193\n  \u2193      \u2190    <span class=\"hljs-selector-tag\">Redis<\/span> <span class=\"hljs-selector-tag\">Cache<\/span>    \u2192   \u2193\n  \u2193                                \u2193\n  \u2514\u2500\u2500\u2500\u2500\u2192 <span class=\"hljs-selector-tag\">PostgreSQL<\/span> (\u4e3b) \u2190\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n              \u2193\n         <span class=\"hljs-selector-tag\">PostgreSQL<\/span> (\u5f9e)  \u2190 \u8b80\u53d6\u6d41\u91cf\u5206\u6563\u5230\u5f9e\u8cc7\u6599\u5eab\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><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\"><strong>\u7ffb\u8b6f<\/strong>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li>\u4f7f\u7528\u8005\u7684\u8acb\u6c42\u5148\u5230 Load Balancer\uff0c\u5206\u914d\u5230\u67d0\u53f0 App Server<\/li>\n\n\n<li>App Server \u5148\u67e5 Redis Cache\uff0c\u6709\u5c31\u76f4\u63a5\u56de<\/li>\n\n\n<li>Cache \u6c92\u6709\u7684\u8a71\uff0c\u67e5 PostgreSQL \u8cc7\u6599\u5eab<\/li>\n\n\n<li>\u8cc7\u6599\u5eab\u6709\u4e3b\u5f9e\u67b6\u69cb\uff0c\u5beb\u5165\u8d70\u4e3b\u5eab\uff0c\u8b80\u53d6\u53ef\u4ee5\u8d70\u5f9e\u5eab<\/li>\n\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u5fc5\u770b\u61c2 vs \u77e5\u9053\u5c31\u597d<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5fc5\u770b\u61c2\uff08\u7cfb\u7d71\u8a2d\u8a08\u9762\u8a66\u5fc5\u8003\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u529f\u80fd\u6027\u9700\u6c42 vs \u975e\u529f\u80fd\u6027\u9700\u6c42\u7684\u5340\u5225<\/li>\n\n\n<li>[ ] \u57fa\u672c\u4f30\u7b97\uff1aDAU\u3001QPS\u3001\u5132\u5b58\u91cf\u600e\u9ebc\u7b97<\/li>\n\n\n<li>[ ] \u67b6\u69cb\u5716\u57fa\u672c\u5143\u4ef6\uff1aClient\u3001Load Balancer\u3001Server\u3001Database\u3001Cache<\/li>\n\n\n<li>[ ] \u70ba\u4ec0\u9ebc\u9700\u8981 Cache \u548c Load Balancer<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u77e5\u9053\u5c31\u597d\uff08\u9047\u5230\u518d\u6df1\u5165\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>CAP \u5b9a\u7406<\/strong>\uff1a\u4e00\u81f4\u6027\u3001\u53ef\u7528\u6027\u3001\u5206\u5340\u5bb9\u932f\u6027\u4e0d\u53ef\u80fd\u540c\u6642\u6eff\u8db3<\/li>\n\n\n<li><strong>\u4e00\u81f4\u6027\u96dc\u6e4a\uff08Consistent Hashing\uff09<\/strong>\uff1a\u5206\u6563\u8cc7\u6599\u5230\u591a\u53f0\u4f3a\u670d\u5668\u7684\u7b56\u7565<\/li>\n\n\n<li><strong>\u8a0a\u606f\u4f47\u5217\uff08Message Queue\uff09<\/strong>\uff1a\u975e\u540c\u6b65\u8655\u7406\u4efb\u52d9\u7684\u5143\u4ef6<\/li>\n\n\n<li><strong>CDN<\/strong>\uff1a\u975c\u614b\u5167\u5bb9\u5206\u6563\u5230\u5168\u7403\u7bc0\u9ede\u52a0\u901f<\/li>\n\n\n<li><strong>\u8cc7\u6599\u5eab\u5206\u7247\uff08Sharding\uff09<\/strong>\uff1a\u628a\u4e00\u500b\u5927\u8cc7\u6599\u5eab\u62c6\u6210\u591a\u500b\u5c0f\u8cc7\u6599\u5eab<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u7cfb\u7d71\u8a2d\u8a08\u76f8\u95dc\u7684\u7a0b\u5f0f\u78bc\u6216\u67b6\u69cb\u5716\u6642\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u80fd\u8aaa\u51fa\u6bcf\u500b\u5143\u4ef6\u7684\u4f5c\u7528\u55ce\uff1f\uff08Load Balancer \u5e79\u561b\u7684\uff1fCache \u5e79\u561b\u7684\uff1f\uff09<\/li>\n\n\n<li>[ ] \u8cc7\u6599\u5f9e\u4f7f\u7528\u8005\u51fa\u767c\uff0c\u7d93\u904e\u54ea\u4e9b\u7ad9\uff0c\u6700\u5f8c\u5230\u54ea\u88e1\uff1f<\/li>\n\n\n<li>[ ] \u6709\u6c92\u6709\u55ae\u9ede\u6545\u969c\uff1f\uff08\u5982\u679c\u67d0\u53f0\u6a5f\u5668\u639b\u4e86\uff0c\u7cfb\u7d71\u9084\u80fd\u52d5\u55ce\uff1f\uff09<\/li>\n\n\n<li>[ ] \u8b80\u5beb\u6bd4\u662f\u591a\u5c11\uff1f\u8b80\u591a\u9084\u662f\u5beb\u591a\uff1f\uff08\u6c7a\u5b9a\u8981\u4e0d\u8981\u52a0 Cache\uff09<\/li>\n\n\n<li>[ ] \u9810\u4f30\u7684 QPS \u548c\u5132\u5b58\u91cf\u662f\u591a\u5c11\u91cf\u7d1a\uff1f<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u5c0f\u7d50<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7cfb\u7d71\u8a2d\u8a08\u7684\u601d\u8003\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\"><span><code class=\"hljs\">\u9700\u6c42\u5206\u6790 \u2192 \u4f30\u7b97\u91cf\u7d1a \u2192 \u756b\u67b6\u69cb\u5716 \u2192 API \u8a2d\u8a08 \u2192 \u8cc7\u6599\u6a21\u578b \u2192 \u8a0e\u8ad6\u53d6\u6368\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u7bc7\u7528\u77ed\u7db2\u5740\u670d\u52d9\u8d70\u4e86\u4e00\u904d\u5b8c\u6574\u6d41\u7a0b\u3002\u4e0b\u4e00\u7bc7\u6211\u5011\u6703\u6df1\u5165\u300c\u8cc7\u6599\u5eab\u9078\u578b\u300d&#8211; \u4ec0\u9ebc\u6642\u5019\u8a72\u7528 SQL\uff0c\u4ec0\u9ebc\u6642\u5019\u8a72\u7528 NoSQL\uff0c\u4ee5\u53ca\u5982\u4f55\u8a2d\u8a08 Schema\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a18\u4f4f\uff1a\u7cfb\u7d71\u8a2d\u8a08\u6c92\u6709\u6a19\u6e96\u7b54\u6848\uff0c\u91cd\u8981\u7684\u662f\u5c55\u793a\u4f60\u7684\u601d\u8003\u904e\u7a0b\u548c\u53d6\u6368\u5224\u65b7\u3002<\/p>\n\n\n\n<div id=\"quiz-6cb6f305\">\n<style>\n#quiz-6cb6f305 .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-6cb6f305 .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-6cb6f305 .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-6cb6f305 .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-6cb6f305 .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-6cb6f305 .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-6cb6f305 .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-6cb6f305 .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-6cb6f305 .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-6cb6f305 .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-6cb6f305 .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-6cb6f305 .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-6cb6f305 .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-6cb6f305 .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-6cb6f305 .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-6cb6f305 .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-6cb6f305 .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\uff1a\u7cfb\u7d71\u8a2d\u8a08\u601d\u7dad\u5165\u9580 &#8212; \u5f9e\u9700\u6c42\u5230\u67b6\u69cb\u5716<\/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    <!-- \u60c5\u5883\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u7684\u5718\u968a\u6b63\u5728\u8a2d\u8a08\u4e00\u500b\u5716\u7247\u5206\u4eab\u5e73\u53f0\u3002PM \u8ddf\u4f60\u8aaa\uff1a\u300c\u4f7f\u7528\u8005\u8981\u80fd\u4e0a\u50b3\u5716\u7247\u3001\u700f\u89bd\u5176\u4ed6\u4eba\u7684\u5716\u7247\uff0c\u800c\u4e14\u7cfb\u7d71\u4e0d\u80fd\u592a\u6162\u3002\u300d\u5728\u958b\u59cb\u756b\u67b6\u69cb\u5716\u4e4b\u524d\uff0c\u4f60\u61c9\u8a72\u5148\u505a\u4ec0\u9ebc\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. \u7acb\u523b\u9078\u64c7\u4f7f\u7528 AWS S3 \u5132\u5b58\u5716\u7247\uff0c\u56e0\u70ba\u9019\u662f\u696d\u754c\u6a19\u6e96<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. \u628a\u300c\u4e0d\u80fd\u592a\u6162\u300d\u91cf\u5316\u6210\u5177\u9ad4\u6307\u6a19\uff0c\u4f8b\u5982\u5716\u7247\u8f09\u5165\u5ef6\u9072\u5728 200ms \u5167\uff0c\u4e26\u78ba\u8a8d DAU\u3001QPS \u7b49\u6578\u5b57<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. \u5148\u6c7a\u5b9a\u8cc7\u6599\u5eab\u7528 SQL \u9084\u662f NoSQL<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u5148\u7814\u7a76\u7af6\u54c1\u7684\u6280\u8853\u67b6\u69cb\uff0c\u76f4\u63a5\u8907\u88fd\u4ed6\u5011\u7684\u8a2d\u8a08<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u4f60\u5728\u8a2d\u8a08\u4e00\u500b\u7dda\u4e0a\u6295\u7968\u7cfb\u7d71\uff0c\u9810\u4f30 DAU \u70ba 500 \u842c\uff0c\u6bcf\u4eba\u6bcf\u5929\u6295 2 \u7968\uff0c\u8b80\u5beb\u6bd4\u70ba 50:1\u3002\u4f60\u9700\u8981\u4f30\u7b97\u9ad8\u5cf0\u671f\u7684\u8b80\u53d6 QPS \u4f86\u6c7a\u5b9a\u9700\u8981\u5e7e\u53f0\u4f3a\u670d\u5668\u3002\u4ee5\u4e0b\u54ea\u500b\u4f30\u7b97\u6700\u63a5\u8fd1\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">\u63d0\u793a\uff1a\u4e00\u5929\u7d04 86,400 \u79d2\uff0c\u9ad8\u5cf0\u671f\u7d04\u70ba\u5e73\u5747\u7684 5 \u500d<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u7d04 580 QPS<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. \u7d04 5,800 QPS<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u7d04 29,000 QPS<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. \u7d04 290,000 QPS<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 3 -->\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u8ca0\u8cac\u7684\u77ed\u7db2\u5740\u670d\u52d9\u4e0a\u7dda\u5f8c\uff0c\u767c\u73fe\u8b80\u53d6 QPS \u9ad8\u9054 8,000\uff0c\u4f46\u5176\u4e2d 80% \u7684\u8acb\u6c42\u90fd\u96c6\u4e2d\u5728\u6700\u8fd1 24 \u5c0f\u6642\u5efa\u7acb\u7684\u77ed\u7db2\u5740\u3002\u70ba\u4e86\u964d\u4f4e\u8cc7\u6599\u5eab\u58d3\u529b\uff0c\u4f60\u61c9\u8a72\u512a\u5148\u63a1\u53d6\u54ea\u500b\u63aa\u65bd\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'B')\">A. \u589e\u52a0\u66f4\u591a\u8cc7\u6599\u5eab\u5f9e\u5eab\uff08Read Replica\uff09\uff0c\u5206\u6563\u8b80\u53d6\u6d41\u91cf<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'B')\">B. \u5728 App Server \u548c Database \u4e4b\u9593\u52a0\u5165 Redis Cache\uff0c\u5feb\u53d6\u71b1\u9580\u77ed\u7db2\u5740<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'B')\">C. \u628a\u8cc7\u6599\u5eab\u5f9e PostgreSQL \u63db\u6210 DynamoDB<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'B')\">D. \u589e\u52a0 Load Balancer \u7684\u6578\u91cf<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u5c0f\u660e\u7528\u6587\u7ae0\u4e2d\u7684 FastAPI \u77ed\u7db2\u5740\u7bc4\u4f8b\u90e8\u7f72\u5230\u751f\u7522\u74b0\u5883\uff0c\u8dd1\u4e86\u4e00\u6bb5\u6642\u9593\u5f8c\u91cd\u555f\u4f3a\u670d\u5668\uff0c\u7d50\u679c\u6240\u6709\u77ed\u7db2\u5740\u90fd\u5931\u6548\u4e86\u3002\u4ee5\u4e0b\u662f\u4ed6\u7684\u6838\u5fc3\u7a0b\u5f0f\u78bc\uff0c\u554f\u984c\u51fa\u5728\u54ea\u88e1\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">url_db: dict[str, str] = {}   # \u5132\u5b58\u77ed\u7db2\u5740\u5c0d\u61c9\ncounter = 0                    # \u81ea\u589e ID\n\n@app.post(&#8220;\/api\/shorten&#8221;, response_model=ShortenResponse)\ndef shorten(req: ShortenRequest):\n    global counter\n    counter += 1\n    short_code = encode_base62(counter)\n    url_db[short_code] = req.long_url\n    return ShortenResponse(short_url=f&#8221;http:\/\/short.ly\/{short_code}&#8221;)<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. <code>encode_base62<\/code> \u51fd\u5f0f\u7522\u751f\u4e86\u91cd\u8907\u7684\u77ed\u78bc<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. <code>url_db<\/code> \u662f\u8a18\u61b6\u9ad4\u4e2d\u7684 dict\uff0c\u91cd\u555f\u5f8c\u8cc7\u6599\u5168\u90e8\u907a\u5931\uff0c\u61c9\u4f7f\u7528\u6301\u4e45\u5316\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. \u6c92\u6709\u4f7f\u7528 <code>async def<\/code> \u5c0e\u81f4\u4f3a\u670d\u5668\u963b\u585e\u5d29\u6f70<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. <code>global counter<\/code> \u5728\u591a\u57f7\u884c\u7dd2\u74b0\u5883\u4e0b\u6703\u7522\u751f\u7af6\u722d\u689d\u4ef6<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u5718\u968a\u90e8\u7f72\u4e86\u4e09\u53f0 App Server \u8655\u7406\u77ed\u7db2\u5740\u670d\u52d9\uff0c\u4f46\u767c\u73fe\u90e8\u5206\u4f7f\u7528\u8005\u5efa\u7acb\u77ed\u7db2\u5740\u5f8c\uff0c\u8a2a\u554f\u77ed\u7db2\u5740\u537b\u6536\u5230 404 \u932f\u8aa4\u3002\u67b6\u69cb\u5982\u4e0b\uff0c\u554f\u984c\u6700\u53ef\u80fd\u51fa\u5728\u54ea\u88e1\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">\u4f7f\u7528\u8005 \u2192 Load Balancer \u2192 App Server 1 (counter=100, url_db={&#8230;})\n                          \u2192 App Server 2 (counter=100, url_db={&#8230;})\n                          \u2192 App Server 3 (counter=100, url_db={&#8230;})\n\n\u6bcf\u53f0 App Server \u5404\u81ea\u7dad\u8b77\u81ea\u5df1\u7684 url_db (dict) \u548c counter<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. Load Balancer \u7684\u5206\u6d41\u6f14\u7b97\u6cd5\u6709\u554f\u984c\uff0c\u61c9\u6539\u7528\u56fa\u5b9a IP \u5206\u914d<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. Base62 \u7de8\u78bc\u5728\u4e0d\u540c\u6a5f\u5668\u4e0a\u7522\u751f\u4e0d\u540c\u7d50\u679c<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u6bcf\u53f0\u4f3a\u670d\u5668\u7528\u5404\u81ea\u7684\u8a18\u61b6\u9ad4\u5b58\u8cc7\u6599\uff0c\u5efa\u7acb\u77ed\u7db2\u5740\u7684\u4f3a\u670d\u5668\u548c\u67e5\u8a62\u7684\u4f3a\u670d\u5668\u4e0d\u540c\uff0c\u5c0e\u81f4\u627e\u4e0d\u5230\u8cc7\u6599\uff1b\u61c9\u6539\u7528\u5171\u4eab\u7684\u5916\u90e8\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. DNS \u89e3\u6790\u5ef6\u9072\u5c0e\u81f4\u8acb\u6c42\u903e\u6642<\/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: \" \u6587\u7ae0\u5f37\u8abf\u7cfb\u7d71\u8a2d\u8a08\u7684\u8d77\u9ede\u6c38\u9060\u662f\u9700\u6c42\u5206\u6790\uff0c\u800c\u4e14\u975e\u529f\u80fd\u6027\u9700\u6c42\u5fc5\u9808\u91cf\u5316\u3002\u300c\u4e0d\u80fd\u592a\u6162\u300d\u662f\u6a21\u7cca\u7684\u63cf\u8ff0\uff0c\u5fc5\u9808\u8f49\u5316\u6210\u5177\u9ad4\u6307\u6a19\uff08\u4f8b\u5982\u5ef6\u9072 200ms \u5167\uff09\u3002\u540c\u6642\u4e5f\u8981\u78ba\u8a8d DAU\u3001QPS \u7b49\u6578\u5b57\uff0c\u624d\u80fd\u9032\u884c\u5f8c\u7e8c\u7684\u4f30\u7b97\u548c\u67b6\u69cb\u6c7a\u7b56\u3002\u9078\u9805 A \u548c C \u90fd\u662f\u8df3\u904e\u9700\u6c42\u5206\u6790\u76f4\u63a5\u9078\u6280\u8853\u65b9\u6848\uff0c\u9078\u9805 D \u5247\u5ffd\u7565\u4e86\u4e0d\u540c\u696d\u52d9\u7684\u9700\u6c42\u5dee\u7570\u3002\",\n        2: \" \u8a08\u7b97\u904e\u7a0b\uff1a\u5beb\u5165 QPS = 500 \u842c x 2 \/ 86,400 \u2248 116 QPS\u3002\u8b80\u53d6 QPS = 116 x 50 = 5,800 QPS\u3002\u9ad8\u5cf0\u671f 5 \u500d = 5,800 x 5 = 29,000 QPS\u3002\u9078\u9805 A\uff08580\uff09\u662f\u5e73\u5747\u5beb\u5165\u7684 5 \u500d\uff1b\u9078\u9805 B\uff085,800\uff09\u662f\u5e73\u5747\u8b80\u53d6\u4f46\u4e0d\u662f\u9ad8\u5cf0\u671f\uff1b\u9078\u9805 D\uff08290,000\uff09\u591a\u7b97\u4e86\u4e00\u500b\u6578\u91cf\u7d1a\u3002\u4f30\u7b97\u7684\u95dc\u9375\u662f\u638c\u63e1\u91cf\u7d1a\uff0c\u800c\u4e0d\u662f\u7cbe\u78ba\u5230\u500b\u4f4d\u6578\u3002\",\n        3: \" \u6587\u7ae0\u6307\u51fa Cache \u7684\u4f5c\u7528\u662f\u300c\u66ab\u5b58\u5e38\u7528\u8cc7\u6599\uff0c\u6e1b\u5c11\u8cc7\u6599\u5eab\u67e5\u8a62\u4ee5\u52a0\u901f\u8b80\u53d6\u300d\u3002\u7576 80% \u7684\u8acb\u6c42\u96c6\u4e2d\u5728\u6700\u8fd1\u7684\u77ed\u7db2\u5740\u6642\uff0c\u9019\u4e9b\u5c31\u662f\u300c\u71b1\u9580\u8cc7\u6599\u300d\uff0c\u975e\u5e38\u9069\u5408\u7528 Redis Cache \u66ab\u5b58\u3002\u9078\u9805 A\uff08\u589e\u52a0\u5f9e\u5eab\uff09\u53ef\u884c\u4f46\u6210\u672c\u8f03\u9ad8\uff0c\u4e14\u6c92\u6709\u5229\u7528\u8cc7\u6599\u7684\u71b1\u5ea6\u7279\u6027\u3002\u9078\u9805 C\uff08\u63db\u8cc7\u6599\u5eab\uff09\u662f\u5927\u898f\u6a21\u8b8a\u66f4\uff0c\u4e0d\u61c9\u8a72\u662f\u7b2c\u4e00\u6b65\u3002\u9078\u9805 D\uff08\u589e\u52a0 Load Balancer\uff09\u89e3\u6c7a\u7684\u662f\u6d41\u91cf\u5206\u914d\u554f\u984c\u800c\u975e\u8cc7\u6599\u5eab\u58d3\u529b\u3002\",\n        4: \" \u6587\u7ae0\u5728\u300c\u5f9e\u7c21\u6613\u7248\u5230\u6b63\u5f0f\u7248\u300d\u4e2d\u660e\u78ba\u6307\u51fa\uff1a<code>dict<\/code> \u5b58\u5728\u8a18\u61b6\u9ad4\u4e2d\uff0c\u91cd\u555f\u4e0d\u6703\u907a\u5931\u8cc7\u6599\u662f\u63db\u6210 PostgreSQL \u7684\u539f\u56e0\u3002\u5c0f\u660e\u76f4\u63a5\u628a\u7bc4\u4f8b\u7528\u5728\u751f\u7522\u74b0\u5883\uff0c\u91cd\u555f\u5f8c <code>url_db<\/code> \u88ab\u91cd\u65b0\u521d\u59cb\u5316\u70ba\u7a7a\u5b57\u5178\uff0c\u6240\u6709\u8cc7\u6599\u90fd\u6d88\u5931\u4e86\u3002\u9078\u9805 D \u96d6\u7136\u4e5f\u662f\u6f5b\u5728\u554f\u984c\uff0c\u4f46\u984c\u76ee\u63cf\u8ff0\u7684\u75c7\u72c0\uff08\u91cd\u555f\u5f8c\u5931\u6548\uff09\u660e\u78ba\u6307\u5411\u8cc7\u6599\u6301\u4e45\u5316\u554f\u984c\uff0c\u800c\u4e0d\u662f\u7af6\u722d\u689d\u4ef6\u3002\",\n        5: \" \u9019\u662f\u5178\u578b\u7684\u300c\u8cc7\u6599\u4e0d\u5171\u4eab\u300d\u554f\u984c\u3002\u7576\u4f7f\u7528\u8005\u5728 App Server 1 \u5efa\u7acb\u77ed\u7db2\u5740\u6642\uff0c\u8cc7\u6599\u53ea\u5b58\u5728 Server 1 \u7684 <code>url_db<\/code> \u4e2d\u3002\u4e0b\u6b21\u4f7f\u7528\u8005\u8a2a\u554f\u77ed\u7db2\u5740\u6642\uff0cLoad Balancer \u53ef\u80fd\u628a\u8acb\u6c42\u5206\u914d\u5230 Server 2 \u6216 3\uff0c\u800c\u9019\u5169\u53f0\u4f3a\u670d\u5668\u7684 <code>url_db<\/code> \u88e1\u6c92\u6709\u9019\u7b46\u8cc7\u6599\uff0c\u56e0\u6b64\u56de\u50b3 404\u3002\u89e3\u6c7a\u65b9\u6cd5\u662f\u4f7f\u7528\u5916\u90e8\u5171\u4eab\u8cc7\u6599\u5eab\uff08\u5982 PostgreSQL\uff09\uff0c\u8b93\u6240\u6709\u4f3a\u670d\u5668\u8b80\u5beb\u540c\u4e00\u500b\u8cc7\u6599\u4f86\u6e90\u3002\u9019\u6b63\u662f\u6587\u7ae0\u4e2d\u6b63\u5f0f\u7248\u67b6\u69cb\u5716\u6240\u5448\u73fe\u7684\u8a2d\u8a08\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\uff1a\u7cfb\u7d71\u8a2d\u8a08\u601d\u7dad\u5165\u9580 &#8212; \u5f9e\u9700\u6c42\u5230\u67b6\u69cb\u5716 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. \u300c\u5beb\u7a0b\u5f0f\u300d [&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":[711],"tags":[291,240,752,749,751,701,750],"class_list":["post-773","post","type-post","status-publish","format-standard","hentry","category-711","tag-fastapi","tag-python","tag-qps","tag-749","tag-751","tag-701","tag-750"],"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\/773","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=773"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/773\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}