{"id":32300,"date":"2022-11-25T14:10:51","date_gmt":"2023-09-28T00:42:53","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/"},"modified":"2024-01-15T07:14:29","modified_gmt":"2024-01-14T23:14:29","slug":"%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/","title":{"rendered":"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma)"},"content":{"rendered":"<p>@kenmaro\u5728\u3002<br \/>\n\u6211\u5e73\u65f6\u4e3b\u8981\u53d1\u5e03\u4e0e\u79d8\u5bc6\u8ba1\u7b97\u3001\u540c\u6001\u52a0\u5bc6\u7b49\u76f8\u5173\u7684\u6587\u7ae0\u3002<br \/>\n\u6709\u5173\u79d8\u5bc6\u8ba1\u7b97\u7efc\u8ff0\u6587\u7ae0\uff0c\u8bf7\u67e5\u770b\u4ee5\u4e0b\u5185\u5bb9\u3002<\/p>\n<blockquote><p>\u6211\u6210\u4e3a\u4fdd\u5bc6\u8ba1\u7b97\u5de5\u7a0b\u5e08\u5df2\u7ecf\u8fc7\u53bb\u4e86\u4e00\u5e74\u3002<br \/>\n\u6211\u6210\u4e3a\u4fdd\u5bc6\u8ba1\u7b97\u5de5\u7a0b\u5e08\u5df2\u7ecf\u8fc7\u53bb\u4e86\u4e24\u5e74\u534a\u3002<\/p><\/blockquote>\n<h2>\u7b80\u4ecb<\/h2>\n<p>Only one option is needed: \u7b80\u4ecb<\/p>\n<p>\u5728\u4f7f\u7528Node.js\u7684\u9a71\u52a8\u7a0b\u5e8f\u8fde\u63a5\u5230PostgreSQL\u8fdb\u884c\u6d4b\u8bd5\u65f6\uff0c\u6211\u8c03\u67e5\u4e86\u6709\u54ea\u4e9b\u9a71\u52a8\u7a0b\u5e8f\u3001\u5e93\u548c\u6846\u67b6\uff0c\u5e76\u7b80\u5355\u5730\u603b\u7ed3\u5728\u5907\u5fd8\u5f55\u4e2d\u3002<\/p>\n<h2>\u9996\u5148\u8981\u603b\u7ed3<\/h2>\n<p>\u6709\u51e0\u4e2a\u7c7b\u4f3c\u4e8e\u6570\u636e\u5e93\u9a71\u52a8\u7a0b\u5e8f\u7684\u4e1c\u897f\u5b58\u5728\uff0c\u5176\u4e2d\u4e5f\u6709\u51e0\u4e2a\u77e5\u540d\u7684\uff0c\u4f46\u8fd9\u4e24\u4e2a\u4f3c\u4e4e\u662f\u5176\u4e2d\u6700\u6709\u540d\u7684\u3002<\/p>\n<ul class=\"post-ul\">Sequelize<\/ul>\n<p>\u5982\u679c\u60f3\u8981\u7b80\u5355\u5730\u8fde\u63a5\u5230\u6570\u636e\u5e93\u5e76\u5177\u5907ORM\u529f\u80fd\uff0c\u4f7f\u7528\u8fd9\u6837\u7684\u5e93\u4f3c\u4e4e\u662f\u4e00\u4e2a\u4e0d\u9519\u7684\u9009\u62e9\u3002<\/p>\n<ul class=\"post-ul\">Prisma<\/ul>\n<p>\u4ece\u6240\u9700\u7684\u6587\u4ef6\u5939\u7ed3\u6784\u7b49\u65b9\u9762\u6765\u770b\uff0c\u5b83\u66f4\u50cf\u4e00\u4e2a\u6846\u67b6\u800c\u4e0d\u662f\u4e00\u4e2a\u5e93\u3002\u5982\u679c\u4f60\u9700\u8981\u6df1\u5165\u5f00\u53d1\u548c\u6784\u5efa\u7f51\u9875\u5e94\u7528\u7b49\u65b9\u9762\u7684\u5185\u5bb9\uff0c\u5c1d\u8bd5\u4f7f\u7528\u5b83\u53ef\u80fd\u662f\u4e00\u4e2a\u4e0d\u9519\u7684\u9009\u62e9\u3002\u5b83\u4f3c\u4e4e\u8d8a\u6765\u8d8a\u53d7\u6b22\u8fce\u4e86\u3002<\/p>\n<p>\u6211\u5c1d\u8bd5\u8fc7\u4e24\u79cd\u65b9\u6cd5\uff0c\u4f46\u7531\u4e8e\u6211\u662f\u4e3a\u4e86\u5feb\u901f\u6d4b\u8bd5\u7684\u76ee\u7684\uff0c\u6700\u7ec8\u6211\u4e3b\u8981\u4f7f\u7528\u4e86Sequelize\u3002<\/p>\n<h2>\u73af\u5883\u642d\u5efa<\/h2>\n<p>\u7528Docker\u8f7b\u677e\u642d\u5efa\u5f00\u53d1\u73af\u5883\u6bd4\u5728\u672c\u5730\u6784\u5efaPostgreSQL\u66f4\u7b80\u5355\u65b9\u4fbf\uff0c\u867d\u7136\u4e5f\u53ef\u4ee5\u5728\u672c\u5730\u6784\u5efa\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"na\">version<\/span><span class=\"pi\">:<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">2\"<\/span>\r\n<span class=\"na\">services<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">mysql<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">restart<\/span><span class=\"pi\">:<\/span> <span class=\"s\">always<\/span>\r\n    <span class=\"na\">image<\/span><span class=\"pi\">:<\/span> <span class=\"s\">mysql:latest<\/span>\r\n    <span class=\"na\">ports<\/span><span class=\"pi\">:<\/span> <span class=\"pi\">[<\/span><span class=\"s2\">\"<\/span><span class=\"s\">3306:3306\"<\/span><span class=\"pi\">]<\/span>\r\n    <span class=\"na\">environment<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"na\">MYSQL_DATABASE<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">test'<\/span>\r\n      <span class=\"na\">MYSQL_ROOT_PASSWORD<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">password'<\/span>\r\n      <span class=\"na\">MYSQL_USER<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">postgres'<\/span>\r\n      <span class=\"na\">MYSQL_PASS<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">password'<\/span>\r\n    <span class=\"na\">volumes<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">\/mnt\/data\/mysql:\/var\/lib\/mysql<\/span>\r\n  <span class=\"na\">pgdb<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">container_name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">pg_db<\/span>\r\n    <span class=\"na\">image<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres:latest<\/span>\r\n    <span class=\"na\">ports<\/span><span class=\"pi\">:<\/span> <span class=\"pi\">[<\/span><span class=\"s2\">\"<\/span><span class=\"s\">5432:5432\"<\/span><span class=\"pi\">]<\/span>\r\n    <span class=\"na\">environment<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">POSTGRES_PASSWORD=password\"<\/span>\r\n    <span class=\"na\">command<\/span><span class=\"pi\">:<\/span> <span class=\"pi\">[<\/span><span class=\"s2\">\"<\/span><span class=\"s\">postgres\"<\/span><span class=\"pi\">,<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">-c\"<\/span><span class=\"pi\">,<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">log_statement=all\"<\/span><span class=\"pi\">,<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">-c\"<\/span><span class=\"pi\">,<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">log_destination=stderr\"<\/span><span class=\"pi\">]<\/span>\r\n<\/code><\/pre>\n<p>\u5982\u679c\u60a8\u4e8b\u5148\u51c6\u5907\u597d\u53ef\u4ee5\u8f7b\u677e\u642d\u5efa MySQL \u548c PostgreSQL \u7684 docker-compose.yml\uff0c\u90a3\u5c06\u975e\u5e38\u65b9\u4fbf\u3002<\/p>\n<p>\u8bf7\u7528\u4e2d\u6587\u7ffb\u8bd1\u4ee5\u4e0b\u5185\u5bb9\uff0c\u5e76\u7ed9\u51fa\u4e00\u79cd\u9009\u9879\uff1a<br \/>\n\u5728\u6b64yml\u6587\u4ef6\u7684\u540c\u4e00\u7ea7\u76ee\u5f55\u4e0b\uff0c<\/p>\n<pre class=\"post-pre\"><code>$docker-compose up -d pgdb\r\n<\/code><\/pre>\n<p>\u8ba9\u6211\u4eec\u542f\u52a8\u5f00\u53d1PostgreSQL\u3002<\/p>\n<p>\u4e00\u65e6\u542f\u52a8\u540e\uff0c\u6211\u4eec\u5c06\u4f7f\u7528\u540d\u4e3apsql\u7684\u5ba2\u6237\u7aefCLI\u5e93\u8fdb\u884c\u8fde\u63a5\u6d4b\u8bd5\u3002<br \/>\n\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5df2\u914d\u7f6e\u4e86\u4e00\u4e2a\u540d\u4e3a\u201cpostgres\u201d\u7684\u7528\u6237\u548c\u4e00\u4e2a\u540d\u4e3a\u201cpostgres\u201d\u7684\u6570\u636e\u5e93\uff0c<br \/>\n\u5bc6\u7801\u662f\u5728docker-compose\u4e2d\u6307\u5b9a\u7684\u3002<\/p>\n<p>\u56e0\u6b64\uff0c\u8fde\u63a5\u547d\u4ee4\u4e3a<\/p>\n<pre class=\"post-pre\"><code>psql -U postgres -h localhost -d postgres\r\n<\/code><\/pre>\n<p>\u8bf7\u95ee\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\uff0c\u60a8\u53ef\u4ee5\u81ea\u5df1\u521b\u5efa\u5f00\u53d1\u7528\u6237\uff0c\u4e5f\u53ef\u4ee5\u521b\u5efa\u5f00\u53d1\u6570\u636e\u5e93\u3002\u5982\u679c\u89c9\u5f97\u9ebb\u70e6\u7684\u8bdd\uff0c\u53ef\u4ee5\u6682\u65f6\u4f7f\u7528\u9ed8\u8ba4\u7528\u6237postgres\u548c\u6570\u636e\u5e93postgres\u3002<\/p>\n<p>\u8bf7\u67e5\u770b\u6211\u4e4b\u524d\u603b\u7ed3\u7684\u5173\u4e8e\u5728psql\u4e2d\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u547d\u4ee4\u7684\u6587\u7ae0\u3002<\/p>\n<h2>Sequelize \u662f\u4e00\u4e2a\u7528\u4e8e Node.js \u7684\u6d41\u884c\u7684 ORM\uff08\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\uff09\u5e93\u3002<\/h2>\n<p>\u516c\u5f0f\u53ef\u4ee5\u4ece\u8fd9\u91cc\u83b7\u53d6\u3002<\/p>\n<p>\u6211\u5011\u5728\u5f15\u5c0e\u904e\u7a0b\u4e2d\u53c3\u8003\u4e86\u4ee5\u4e0b\u5167\u5bb9\u3002<\/p>\n<p>\u8fde\u63a5\u5efa\u7acb\u7684\u53c2\u6570\u7b49\u53ef\u53c2\u8003\u8fd9\u91cc\uff1a<br \/>\nhttps:\/\/sequelize.org\/master\/class\/lib\/sequelize.js~Sequelize.html#instance-constructor-constructor<\/p>\n<p>\u6211\u4f1a\u5b9e\u9645\u8fde\u63a5\u4e00\u6b21\u3002<br \/>\n\u4e0d\u7ba1\u6587\u4ef6\u5939\u7ed3\u6784\u7b49\u7b49\uff0c\u53ea\u9700\u8981index.js\u5c31\u8db3\u591f\u4e86\uff0c\u6240\u4ee5\u53ef\u4ee5\u5feb\u901f\u5c1d\u8bd5\u3002<\/p>\n<pre class=\"post-pre\"><code>mkdir nodetest\r\ncd nodetest\r\nnpm init -y\r\nnpm install --save sequelize\r\nnpm install --save pg pg-hstore\r\ntouch index.js\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"kd\">const<\/span> <span class=\"p\">{<\/span> <span class=\"nx\">Sequelize<\/span><span class=\"p\">,<\/span> <span class=\"nx\">Model<\/span><span class=\"p\">,<\/span> <span class=\"nx\">DataTypes<\/span><span class=\"p\">,<\/span> <span class=\"nx\">QueryTypes<\/span> <span class=\"p\">}<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">sequelize<\/span><span class=\"dl\">'<\/span><span class=\"p\">);<\/span>\r\n<span class=\"c1\">\/\/const sequelize = new Sequelize('sqlite::memory:');<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">sequelize<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nx\">Sequelize<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">postgres<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">user<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">password<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"na\">host<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">localhost<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"na\">port<\/span><span class=\"p\">:<\/span> <span class=\"mi\">8088<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"na\">dialect<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">postgres<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"na\">pool<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"na\">max<\/span><span class=\"p\">:<\/span> <span class=\"mi\">5<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"na\">min<\/span><span class=\"p\">:<\/span> <span class=\"mi\">0<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"na\">acquire<\/span><span class=\"p\">:<\/span> <span class=\"mi\">30000<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"na\">idle<\/span><span class=\"p\">:<\/span> <span class=\"mi\">10000<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">});<\/span>\r\n\r\n<span class=\"kd\">class<\/span> <span class=\"nx\">Test<\/span> <span class=\"kd\">extends<\/span> <span class=\"nx\">Model<\/span> <span class=\"p\">{}<\/span>\r\n<span class=\"nx\">Test<\/span><span class=\"p\">.<\/span><span class=\"nx\">init<\/span><span class=\"p\">({<\/span>\r\n  <span class=\"na\">c1<\/span><span class=\"p\">:<\/span> <span class=\"nx\">DataTypes<\/span><span class=\"p\">.<\/span><span class=\"nx\">STRING<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">},<\/span> <span class=\"p\">{<\/span> <span class=\"nx\">sequelize<\/span><span class=\"p\">,<\/span> <span class=\"na\">modelName<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">test<\/span><span class=\"dl\">'<\/span> <span class=\"p\">});<\/span>\r\n\r\n<span class=\"p\">(<\/span><span class=\"k\">async<\/span> <span class=\"p\">()<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"k\">await<\/span> <span class=\"nx\">sequelize<\/span><span class=\"p\">.<\/span><span class=\"nx\">sync<\/span><span class=\"p\">();<\/span>\r\n  <span class=\"c1\">\/\/const res = await Test.findAll();<\/span>\r\n  <span class=\"c1\">\/\/const res = await sequelize.query(`SELECT * FROM \"test\"`, { type: QueryTypes.SELECT });<\/span>\r\n  <span class=\"kd\">const<\/span> <span class=\"nx\">res<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">sequelize<\/span><span class=\"p\">.<\/span><span class=\"nx\">query<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">SELECT id FROM \"test\"<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"p\">{<\/span> <span class=\"na\">type<\/span><span class=\"p\">:<\/span> <span class=\"nx\">QueryTypes<\/span><span class=\"p\">.<\/span><span class=\"nx\">SELECT<\/span> <span class=\"p\">});<\/span>\r\n  <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nx\">log<\/span><span class=\"p\">(<\/span><span class=\"dl\">\"<\/span><span class=\"s2\">here done<\/span><span class=\"dl\">\"<\/span><span class=\"p\">);<\/span>\r\n  <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nx\">log<\/span><span class=\"p\">(<\/span><span class=\"nx\">res<\/span><span class=\"p\">);<\/span>\r\n  <span class=\"c1\">\/\/const jane = await Test.create({<\/span>\r\n  <span class=\"c1\">\/\/  username: 'janedoe',<\/span>\r\n  <span class=\"c1\">\/\/});<\/span>\r\n  <span class=\"c1\">\/\/console.log(jane.toJSON());<\/span>\r\n<span class=\"p\">})();<\/span>\r\n\r\n\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>node index.js\r\n<\/code><\/pre>\n<p>\u5e94\u8be5\u80fd\u591f\u63a5\u6536\u5230\u67e5\u8be2\u7ed3\u679c\u4e86\u3002<\/p>\n<h2>\u667a\u80fd\u68f1\u955c<\/h2>\n<p>\u6211\u5bf9Prisma\u8fd9\u4e2a\u5e94\u7528\u6240\u89c1\u7684\u6587\u7ae0\u5e76\u4e0d\u591a\uff0c\u4f46\u6211\u89c9\u5f97\u6700\u5408\u9002\u7684\u662f\u8ddf\u968f\u5e76\u5c1d\u8bd5\u4e86\u524d\u4e24\u7bc7\u6587\u7ae0\u3002<\/p>\n<p>\u4f46\u662f\uff0c\u6211\u8ba4\u4e3a\u8bd5\u7740\u7b80\u5355\u5feb\u901f\u6d4b\u8bd5\u53ef\u80fd\u6709\u70b9\u7e41\u7410\u7684\u6b65\u9aa4\u3002<\/p>\n<h2>\u7efc\u4e0a\u6240\u8ff0<\/h2>\n<p>\u6700\u8fd1\uff0c\u6211\u4e2a\u4eba\u4e13\u6ce8\u5730\u4f7f\u7528Firebase\uff0c\u5e76\u4e14\u4e45\u8fdd\u5730\u7814\u7a76\u4e86\u4e00\u4e0bNode.js\u7684\u5e93\uff0c\u611f\u89c9\u975e\u5e38\u6709\u610f\u601d\u3002<\/p>\n<p>\u6211\u662f\u5426\u5e94\u8be5\u8c03\u67e5\u4e00\u4e0b\u5176\u4ed6\u8bed\u8a00\u7684\u9a71\u52a8\u7a0b\u5e8f\u5462\u3001\u3001<\/p>\n<p>\u8fd9\u6b21\u5c31\u5230\u8fd9\u5427\u3002<\/p>\n<p>@kenmaro \u8bf7\u7528\u6c49\u8bed\u6bcd\u8bed\u5bf9\u4ee5\u4e0b\u5185\u5bb9\u8fdb\u884c\u6539\u5199\u3002\u53ea\u9700\u63d0\u4f9b\u4e00\u79cd\u9009\u9879\uff1a<\/p>\n<p>@kenmaro<\/p>\n","protected":false},"excerpt":{"rendered":"<p>@kenmaro\u5728\u3002 \u6211\u5e73\u65f6\u4e3b\u8981\u53d1\u5e03\u4e0e\u79d8\u5bc6\u8ba1\u7b97\u3001\u540c\u6001\u52a0\u5bc6\u7b49\u76f8\u5173\u7684\u6587\u7ae0\u3002 \u6709\u5173\u79d8\u5bc6\u8ba1\u7b97\u7efc\u8ff0\u6587\u7ae0\uff0c\u8bf7\u67e5\u770b\u4ee5\u4e0b\u5185\u5bb9\u3002 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32300","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma) - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bnodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8fsequelize\u3001prisma\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma)\" \/>\n<meta property=\"og:description\" content=\"@kenmaro\u5728\u3002 \u6211\u5e73\u65f6\u4e3b\u8981\u53d1\u5e03\u4e0e\u79d8\u5bc6\u8ba1\u7b97\u3001\u540c\u6001\u52a0\u5bc6\u7b49\u76f8\u5173\u7684\u6587\u7ae0\u3002 \u6709\u5173\u79d8\u5bc6\u8ba1\u7b97\u7efc\u8ff0\u6587\u7ae0\uff0c\u8bf7\u67e5\u770b\u4ee5\u4e0b\u5185\u5bb9\u3002 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bnodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8fsequelize\u3001prisma\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-28T00:42:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-14T23:14:29+00:00\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/\",\"name\":\"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma) - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-09-28T00:42:53+00:00\",\"dateModified\":\"2024-01-14T23:14:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma) - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bnodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8fsequelize\u3001prisma\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma)","og_description":"@kenmaro\u5728\u3002 \u6211\u5e73\u65f6\u4e3b\u8981\u53d1\u5e03\u4e0e\u79d8\u5bc6\u8ba1\u7b97\u3001\u540c\u6001\u52a0\u5bc6\u7b49\u76f8\u5173\u7684\u6587\u7ae0\u3002 \u6709\u5173\u79d8\u5bc6\u8ba1\u7b97\u7efc\u8ff0\u6587\u7ae0\uff0c\u8bf7\u67e5\u770b\u4ee5\u4e0b\u5185\u5bb9\u3002 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bnodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8fsequelize\u3001prisma\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-09-28T00:42:53+00:00","article_modified_time":"2024-01-14T23:14:29+00:00","author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/","name":"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma) - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-09-28T00:42:53+00:00","dateModified":"2024-01-14T23:14:29+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u6211\u5c1d\u8bd5\u4e86\u4e00\u4e0bNodejs\u7684postgresql\u9a71\u52a8\u7a0b\u5e8f(Sequelize\u3001Prisma)"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e4%ba%86%e4%b8%80%e4%b8%8bnodejs%e7%9a%84postgresql%e9%a9%b1%e5%8a%a8%e7%a8%8b%e5%ba%8fsequelize%e3%80%81prisma%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=32300"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32300\/revisions"}],"predecessor-version":[{"id":57272,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32300\/revisions\/57272"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=32300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=32300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=32300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}