{"id":41760,"date":"2023-10-17T05:57:08","date_gmt":"2023-08-08T01:11:12","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/"},"modified":"2024-05-04T04:38:59","modified_gmt":"2024-05-03T20:38:59","slug":"%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/","title":{"rendered":"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7"},"content":{"rendered":"<h2>\u9996\u5148<\/h2>\n<p>\u524d\u4e0d\u4e45\uff0c\u6211\u5199\u4e86\u4ee5\u4e0b\u7684\u6587\u7ae0\u3002<br \/>\n\u3010CAP\u3011\u5c06CAP\u90e8\u7f72\u5230BTP\u7684PostgreSQL\u6570\u636e\u5e93\u3002<\/p>\n<p>\u4f7f\u7528cds-pg\u548ccds-dbm\uff0c\u53ef\u4ee5\u5c06\u5728CAP\u4e2d\u521b\u5efa\u7684CDS\u6a21\u578b\u90e8\u7f72\u5230PostgreSQL\u5e76\u4f7f\u7528\u3002<br \/>\nCAP\u4f1a\u81ea\u52a8\u5904\u7406\u8868\u548c\u89c6\u56fe\u7684\u6ce8\u518c\u53caCRUD\u64cd\u4f5c\uff0c\u5f00\u53d1\u8005\u65e0\u9700\u5173\u6ce8\u8fd9\u4e9b\u5de5\u4f5c\u3002\u7136\u800c\uff0c\u6211\u4e5f\u5e0c\u671b\u4e86\u89e3\u4e00\u4e0b\u5982\u679c\u4e0d\u4f7f\u7528CAP\uff0c\u9700\u8981\u505a\u4ec0\u4e48\u3002<\/p>\n<p>\u56e0\u4e3a\u6709\u4ee5\u4e0b\u793a\u4f8b\u9879\u76ee\uff08\u6559\u7a0b\uff09\uff0c\u6240\u4ee5\u6211\u5c06\u53c2\u8003\u5b83\u521b\u5efa\u4e00\u4e2a\u7b80\u5355\u7684Node.js\u5e94\u7528\u7a0b\u5e8f\u5e76\u786e\u8ba4\u6b65\u9aa4\u3002SAP-samples\/cloud-cf-helloworld-nodejs<\/p>\n<p>\uff1c\u7cfb\u5217\u76ee\u5f55\uff1e<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u3010BTP\u3011Node.js\u3068PostgreSQL\u3067\u30b7\u30f3\u30d7\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\uff081\uff09\u6e96\u5099\u7de8<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u3010BTP\u3011Node.js\u3068PostgreSQL\u3067\u30b7\u30f3\u30d7\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\uff082\uff09CRUD\u51e6\u7406\u7de8<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u3010BTP\u3011Node.js\u3068PostgreSQL\u3067\u30b7\u30f3\u30d7\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\uff083\uff09Approuter\u7de8<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u3010BTP\u3011Node.js\u3068PostgreSQL\u3067\u30b7\u30f3\u30d7\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\uff084\uff09UI\u7de8<\/ul>\n<p>\u6e90\u4ee3\u7801\u5b58\u50a8\u5728GitHub\u4e0a\uff0c\u8bf7\u53c2\u8003\u6587\u7ae0\u3002<\/p>\n<h2>\u8fd9\u7bc7\u6587\u7ae0\u7684\u76ee\u6807\u662f\u4ec0\u4e48\uff1f<\/h2>\n<p>\u672c\u6b21\u6211\u4eec\u5c06\u4f5c\u4e3a\u51c6\u5907\u7bc7\uff0c\u521b\u5efa\u4ee5\u4e0b\u72b6\u6001\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Node.js\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068BTP\u306ePostgreSQL\u306e\u30b5\u30fc\u30d3\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u30d0\u30a4\u30f3\u30c9\u3055\u308c\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL\u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u4f7f\u3046\u30c6\u30fc\u30d6\u30eb\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Node.js\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089BTP\u306ePostgreSQL\u306b\u63a5\u7d9a\u3067\u304d\u308b<\/ul>\n<p>##\u6b65\u9aa4<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5c06 Node.js \u5e94\u7528\u7a0b\u5e8f\u548c PostgreSQL \u670d\u52a1\u5b9e\u4f8b\u8fdb\u884c\u7ed1\u5b9a<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728 PostgreSQL \u4e2d\u6ce8\u518c\u8868<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u4ece Node.js \u5e94\u7528\u7a0b\u5e8f\u8fde\u63a5\u5230 PostgreSQL<\/ol>\n<h3>\u5c06Node.js\u5e94\u7528\u7a0b\u5e8f\u4e0ePostgreSQL\u670d\u52a1\u5b9e\u4f8b\u7ed1\u5b9a\u3002<\/h3>\n<h4>1. \u5728\u4e2d\u56fd\uff0c\u6ce8\u518c\u4e00\u4e2aPostgreSQL\u7684\u670d\u52a1\u5b9e\u4f8b\u3002<\/h4>\n<p>\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u5c06\u670d\u52a1\u5b9e\u4f8b\u6ce8\u518c\u3002<\/p>\n<pre class=\"post-pre\"><code>cf create-service postgresql-db trial &lt;\u30b5\u30fc\u30d3\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d&gt;\r\n<\/code><\/pre>\n<p>\u5728\u8bd5\u7528\u73af\u5883\u4e2d\uff0c\u53ea\u80fd\u521b\u5efa\u4e00\u4e2aPostgreSQL\u7684\u670d\u52a1\u5b9e\u4f8b\uff0c\u6240\u4ee5\u53ef\u4ee5\u91cd\u590d\u4f7f\u7528\u73b0\u6709\u7684\u670d\u52a1\u5b9e\u4f8b\u3002\u6211\u4f7f\u7528\u4e86\u5df2\u6ce8\u518c\u7684\u670d\u52a1\u5b9e\u4f8bcap-posgre-sample-db\u3002<\/p>\n<h4>1.2. \u521b\u5efaNode.js\u9879\u76ee<\/h4>\n<p>\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6587\u4ef6\u5939\u7528\u4e8e\u65b0\u9879\u76ee\uff0c\u5e76\u5728\u5176\u4e0b\u521b\u5efa\u4e00\u4e2a\u540d\u4e3asrv\u7684\u6587\u4ef6\u5939\u3002<\/p>\n<pre class=\"post-pre\"><code>node-postgres-sample\r\n\u3000\u2514 srv\r\n<\/code><\/pre>\n<p>\u8fdb\u5165srv\u6587\u4ef6\u5939\u5e76\u521b\u5efapackage.json\u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code>cd node-postgres-sample\/srv\r\nnpm init --yes\r\n<\/code><\/pre>\n<h4>1.3. \u5b89\u88c5\u4f9d\u8d56\u3002<\/h4>\n<p>\u5c06\u4ee5\u4e0b\u56db\u4e2a\u8f6f\u4ef6\u5305\u8fdb\u884c\u5b89\u88c5\u3002<\/p>\n<pre class=\"post-pre\"><code>npm i express body-parser pg-promise @sap\/xsenv\r\n<\/code><\/pre>\n<p>pg-promise\u306fPostgreSQL\u306b\u63a5\u7d9a\u3057\u305f\u308a\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u305f\u308a\u3059\u308b\u306e\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>@sap\/xsenv\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u74b0\u5883\u5909\u6570\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306e\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>\u5728package.json\u4e2d\u6dfb\u52a0start\u811a\u672c\uff0c\u5e76\u8bbe\u4e3a\u4ee5\u4e0b\u72b6\u6001\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"p\">{<\/span>\r\n  <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"node-postgres-sample\"<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nl\">\"version\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1.0.0\"<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nl\">\"description\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"\"<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nl\">\"scripts\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nl\">\"start\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"node server.js\"<\/span>\r\n  <span class=\"p\">},<\/span>\r\n  <span class=\"nl\">\"dependencies\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nl\">\"@sap\/xsenv\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"^3.1.0\"<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"nl\">\"body-parser\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"^1.19.0\"<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"nl\">\"express\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"^4.17.1\"<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"nl\">\"pg-promise\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"^10.10.2\"<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h4>\u521b\u5efa server.js \u6587\u4ef6\u3002<\/h4>\n<p>\u521b\u5efa\u4e00\u4e2aserver.js\u6587\u4ef6\u3002\u76ee\u524d\u8fd8\u6ca1\u6709\u4e0e\u6570\u636e\u5e93\u7684\u8fde\u63a5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"dl\">'<\/span><span class=\"s1\">use strict<\/span><span class=\"dl\">'<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">express<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">express<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">bodyParser<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">body-parser<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">var<\/span> <span class=\"nx\">_db<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">undefined<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">app<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">express<\/span><span class=\"p\">()<\/span>\r\n\r\n<span class=\"nx\">app<\/span><span class=\"p\">.<\/span><span class=\"nf\">use<\/span><span class=\"p\">(<\/span><span class=\"nx\">bodyParser<\/span><span class=\"p\">.<\/span><span class=\"nf\">json<\/span><span class=\"p\">())<\/span>\r\n\r\n<span class=\"nx\">app<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">\/<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"nf\">function <\/span><span class=\"p\">(<\/span><span class=\"nx\">req<\/span><span class=\"p\">,<\/span> <span class=\"nx\">res<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nx\">res<\/span><span class=\"p\">.<\/span><span class=\"nf\">send<\/span><span class=\"p\">(<\/span><span class=\"dl\">\"<\/span><span class=\"s2\">Hello!<\/span><span class=\"dl\">\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">})<\/span>\r\n\r\n<span class=\"kd\">var<\/span> <span class=\"nx\">PORT<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">process<\/span><span class=\"p\">.<\/span><span class=\"nx\">env<\/span><span class=\"p\">.<\/span><span class=\"nx\">PORT<\/span> <span class=\"o\">||<\/span> <span class=\"mi\">8088<\/span>\r\n<span class=\"kd\">var<\/span> <span class=\"nx\">server<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">app<\/span><span class=\"p\">.<\/span><span class=\"nf\">listen<\/span><span class=\"p\">(<\/span><span class=\"nx\">PORT<\/span><span class=\"p\">,<\/span> <span class=\"kd\">function<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"nx\">host<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">server<\/span><span class=\"p\">.<\/span><span class=\"nf\">address<\/span><span class=\"p\">().<\/span><span class=\"nx\">address<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"nx\">port<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">server<\/span><span class=\"p\">.<\/span><span class=\"nf\">address<\/span><span class=\"p\">().<\/span><span class=\"nx\">port<\/span>\r\n    <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"s2\">`Example app listening at http:\/\/<\/span><span class=\"p\">${<\/span><span class=\"nx\">host<\/span><span class=\"p\">}<\/span><span class=\"s2\">:<\/span><span class=\"p\">${<\/span><span class=\"nx\">port<\/span><span class=\"p\">}<\/span><span class=\"s2\">`<\/span><span class=\"p\">)<\/span>    \r\n<span class=\"p\">})<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d48be37434c4406cacbc2\/31-0.png\" alt=\"image.png\" \/><\/div>\n<h4>\u521b\u5efa1.5\u4e2amta.yaml\u6587\u4ef6<\/h4>\n<p>\u6211\u5011\u5c07\u5728\u5c08\u6848\u7684\u6839\u76ee\u9304\u4e0b\u5275\u5efamta.yaml\u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"na\">_schema-version<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">3.1'<\/span>\r\n<span class=\"na\">ID<\/span><span class=\"pi\">:<\/span> <span class=\"s\">node-postgres-sample<\/span>\r\n<span class=\"na\">version<\/span><span class=\"pi\">:<\/span> <span class=\"s\">1.0.0<\/span>\r\n\r\n<span class=\"na\">modules<\/span><span class=\"pi\">:<\/span>\r\n <span class=\"pi\">-<\/span> <span class=\"na\">name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">node-postgres-sample-srv<\/span>\r\n   <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">nodejs<\/span>\r\n   <span class=\"na\">path<\/span><span class=\"pi\">:<\/span> <span class=\"s\">srv<\/span>\r\n   <span class=\"na\">provides<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"pi\">-<\/span> <span class=\"na\">name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">srv-api<\/span>\r\n      <span class=\"na\">properties<\/span><span class=\"pi\">:<\/span>\r\n        <span class=\"na\">srv-url<\/span><span class=\"pi\">:<\/span> <span class=\"s\">${default-url}<\/span>\r\n   <span class=\"na\">build-parameters<\/span><span class=\"pi\">:<\/span>\r\n     <span class=\"na\">ignore<\/span><span class=\"pi\">:<\/span> <span class=\"pi\">[<\/span><span class=\"s2\">\"<\/span><span class=\"s\">node_modules\/\"<\/span><span class=\"pi\">]<\/span>        \r\n   <span class=\"na\">requires<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"pi\">-<\/span> <span class=\"na\">name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">cap-posgre-sample-db<\/span>\r\n    \r\n<span class=\"na\">resources<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"pi\">-<\/span> <span class=\"na\">name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">cap-posgre-sample-db<\/span>\r\n    <span class=\"na\">parameters<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"na\">service<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgresql-db<\/span>\r\n      <span class=\"na\">service-plan<\/span><span class=\"pi\">:<\/span> <span class=\"s\">trial<\/span>\r\n      <span class=\"na\">skip-service-updates<\/span><span class=\"pi\">:<\/span>\r\n        <span class=\"na\">parameters<\/span><span class=\"pi\">:<\/span> <span class=\"kc\">true<\/span>\r\n    <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">org.cloudfoundry.existing-service<\/span>   <span class=\"c1\">#\u767b\u9332\u6e08\u30b5\u30fc\u30d3\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u305f\u3081\u3001existing-service\u3068\u3059\u308b<\/span>\r\n<\/code><\/pre>\n<p>\u76ee\u524d\u4e3a\u6b62\uff0c\u8be5\u9879\u76ee\u7684\u7ed3\u6784\u5982\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code>node-postgres-sample\r\n\u3000\u2514 srv\r\n    \u3000|- package.json\r\n    \u3000\u2514  server.js\r\n\u3000\u2514 mta.yaml\r\n<\/code><\/pre>\n<h4>1.6 \u5c06\u5e94\u7528\u90e8\u7f72\u5230 Cloud Foundry<\/h4>\n<p>\u5728\u9879\u76ee\u7684\u6839\u76ee\u5f55\u4e0b\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\uff0c\u5c06\u5176\u90e8\u7f72\u5230Cloud Foundry\u3002<\/p>\n<pre class=\"post-pre\"><code>mbt build\r\ncf deploy mta_archives\/node-postgres-sample_1.0.0.mtar\r\n<\/code><\/pre>\n<h3>2. \u5c06\u8868\u683c\u6ce8\u518c\u5230PostgreSQL\u6570\u636e\u5e93\u3002<\/h3>\n<p>\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u6ce8\u518c\u8981\u5728PostgreSQL\u4e2d\u4f7f\u7528\u7684\u8868\u683c\u3002\u4e3a\u6b64\uff0c\u901a\u8fc7SSH\u8fde\u63a5\u5230PostgreSQL\uff0c\u4f7f\u7528\u547d\u4ee4\u884c\u8fdb\u884c\u64cd\u4f5c\u3002\u6709\u5173\u5de5\u5177\u5b89\u88c5\u548c\u8fde\u63a5\u5230PostgreSQL\u7684\u65b9\u6cd5\uff0c\u8bf7\u53c2\u8003\u8fd9\u7bc7\u6587\u7ae0\u3002<\/p>\n<p>\u4e3a\u4e86\u8fde\u63a5\u5230PostgreSQL\u670d\u52a1\u5b9e\u4f8b\uff0c\u9700\u8981\u4e00\u4e2a\u5145\u5f53\u4e3b\u673a\u7684\u5e94\u7528\u7a0b\u5e8f\u3002\u4e3a\u6b64\uff0c\u6211\u4eec\u5148\u6267\u884c\u4e86\u6b65\u9aa41\u3002\u672c\u6b21\uff0c\u4e3b\u673a\u5e94\u7528\u7a0b\u5e8f\u5c06\u662fnode-postgres-sample-srv\u3002<\/p>\n<h4>2.1. \u6ce8\u518c\u684c\u5b50<\/h4>\n<p>\u6267\u884c\u4ee5\u4e0bSQL\u8bed\u53e5\uff0c\u5c06\u6570\u636e\u5b58\u5165products\u8868\u4e2d\u3002<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE products (\r\nid serial PRIMARY KEY,\r\nname varchar(100),\r\nprice integer\r\n);\r\n<\/code><\/pre>\n<h4>2.2. \u5c06\u6570\u636e\u767b\u8bb0\u5230\u8868\u683c\u4e2d<\/h4>\n<p>\u6267\u884c\u4ee5\u4e0bSQL\u8bed\u53e5\uff0c\u5c06\u6570\u636e\u63d2\u5165\u5230\u8868\u4e2d\u3002<br \/>\n\u7531\u4e8eid\u662f\u81ea\u52a8\u9012\u589e\u7684\u5e8f\u5217\uff0c\u6240\u4ee5\u4e0d\u9700\u8981\u6307\u5b9a\u3002<\/p>\n<pre class=\"post-pre\"><code>INSERT INTO products(name, price) VALUES ('banana', 100);\r\n<\/code><\/pre>\n<p>\u786e\u8ba4\u5df2\u7ecf\u6ce8\u518c\u4e86\u5f55\u97f3\u8bb0\u5f55\u3002<\/p>\n<pre class=\"post-pre\"><code>SELECT * FROM products;\r\n id |  name  | price\r\n----+--------+-------\r\n  1 | banana |   100\r\n(1 \u884c)\r\n<\/code><\/pre>\n<h3>\u4eceNode.js\u5e94\u7528\u7a0b\u5e8f\u8fde\u63a5\u5230PostgreSQL\u3002<\/h3>\n<p>\u8bf7\u5728srv\u6587\u4ef6\u5939\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3adb-conn.js\u7684\u6587\u4ef6\u3002\u5728\u6b64\u6587\u4ef6\u4e2d\u7f16\u5199\u7528\u4e8e\u8fde\u63a5\u6570\u636e\u5e93\u7684\u4ee3\u7801\u3002<br \/>\n\u9879\u76ee\u7684\u7ed3\u6784\u5982\u4e0b\u6240\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code>node-postgres-sample\r\n\u3000\u2514 srv\r\n    \u3000|- package.json\r\n    \u3000|- db-conn.js\r\n    \u3000\u2514  server.js\r\n\u3000\u2514 mta.yaml\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"dl\">'<\/span><span class=\"s1\">use strict<\/span><span class=\"dl\">'<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">xsenv<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">@sap\/xsenv<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">function<\/span> <span class=\"nf\">getConfig<\/span> <span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"kd\">var<\/span> <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{}<\/span>\r\n    <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">process<\/span><span class=\"p\">.<\/span><span class=\"nx\">env<\/span><span class=\"p\">.<\/span><span class=\"nx\">VCAP_SERVICES<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"na\">connectionString<\/span><span class=\"p\">:<\/span> <span class=\"nx\">xsenv<\/span><span class=\"p\">.<\/span><span class=\"nf\">cfServiceCredentials<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">cap-posgre-sample-db<\/span><span class=\"dl\">'<\/span><span class=\"p\">).<\/span><span class=\"nx\">uri<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">ssl<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"na\">rejectUnauthorized<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span> <span class=\"p\">}<\/span>\r\n        <span class=\"p\">}<\/span>\r\n    <span class=\"p\">}<\/span> <span class=\"k\">else<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">running locally is not supported<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"nx\">config<\/span><span class=\"p\">;<\/span>\r\n<span class=\"p\">}<\/span>\r\n        \r\n<span class=\"kd\">function<\/span> <span class=\"nf\">getDB<\/span> <span class=\"p\">(<\/span><span class=\"nx\">cb<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"kd\">let<\/span> <span class=\"nx\">pgp<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">pg-promise<\/span><span class=\"dl\">'<\/span><span class=\"p\">)({<\/span>\r\n        <span class=\"c1\">\/\/ Initialization Options<\/span>\r\n    <span class=\"p\">})<\/span>\r\n    <span class=\"kd\">var<\/span> <span class=\"nx\">db<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">pgp<\/span><span class=\"p\">(<\/span><span class=\"nf\">getConfig<\/span><span class=\"p\">())<\/span>\r\n    <span class=\"kd\">let<\/span> <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`SELECT id FROM products WHERE id = 1;`<\/span>\r\n    <span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">.<\/span><span class=\"nf\">then<\/span><span class=\"p\">((<\/span><span class=\"nx\">result<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">database initialized<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"nx\">result<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">cb<\/span><span class=\"p\">(<\/span><span class=\"kc\">null<\/span><span class=\"p\">,<\/span> <span class=\"nx\">db<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"k\">return<\/span>\r\n    <span class=\"p\">})<\/span>\r\n    <span class=\"p\">.<\/span><span class=\"k\">catch<\/span><span class=\"p\">((<\/span><span class=\"nx\">err<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">cb<\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">,<\/span> <span class=\"kc\">null<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"k\">return<\/span>\r\n    <span class=\"p\">})<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nx\">module<\/span><span class=\"p\">.<\/span><span class=\"nx\">exports<\/span>  <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"na\">getDB<\/span><span class=\"p\">:<\/span> <span class=\"nx\">getDB<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u5011\u4e5f\u6703\u4fee\u6539server.js\uff0c\u4f7f\u5176\u5728\u555f\u52d5\u6642\u6aa2\u67e5\u8207\u6578\u64da\u5eab\u7684\u9023\u63a5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"dl\">'<\/span><span class=\"s1\">use strict<\/span><span class=\"dl\">'<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">express<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">express<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">bodyParser<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">body-parser<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbConn<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">.\/db-conn<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">var<\/span> <span class=\"nx\">_db<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">undefined<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">app<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">express<\/span><span class=\"p\">()<\/span>\r\n\r\n<span class=\"nx\">app<\/span><span class=\"p\">.<\/span><span class=\"nf\">use<\/span><span class=\"p\">(<\/span><span class=\"nx\">bodyParser<\/span><span class=\"p\">.<\/span><span class=\"nf\">json<\/span><span class=\"p\">())<\/span>\r\n\r\n<span class=\"nx\">app<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">\"<\/span><span class=\"s2\">\/<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span> <span class=\"nf\">function <\/span><span class=\"p\">(<\/span><span class=\"nx\">req<\/span><span class=\"p\">,<\/span> <span class=\"nx\">res<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nx\">res<\/span><span class=\"p\">.<\/span><span class=\"nf\">send<\/span><span class=\"p\">(<\/span><span class=\"dl\">\"<\/span><span class=\"s2\">Hello!<\/span><span class=\"dl\">\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">})<\/span>\r\n\r\n<span class=\"kd\">function<\/span> <span class=\"nf\">setDBCallback<\/span><span class=\"p\">(<\/span><span class=\"nx\">error<\/span><span class=\"p\">,<\/span> <span class=\"nx\">db<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">error<\/span> <span class=\"o\">!==<\/span> <span class=\"kc\">null<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">error when fetching the DB connection <\/span><span class=\"dl\">'<\/span> <span class=\"o\">+<\/span> <span class=\"nx\">JSON<\/span><span class=\"p\">.<\/span><span class=\"nf\">stringify<\/span><span class=\"p\">(<\/span><span class=\"nx\">error<\/span><span class=\"p\">))<\/span>\r\n        <span class=\"k\">return<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"nx\">_db<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">db<\/span><span class=\"p\">;<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"kd\">var<\/span> <span class=\"nx\">PORT<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">process<\/span><span class=\"p\">.<\/span><span class=\"nx\">env<\/span><span class=\"p\">.<\/span><span class=\"nx\">PORT<\/span> <span class=\"o\">||<\/span> <span class=\"mi\">8088<\/span>\r\n<span class=\"kd\">var<\/span> <span class=\"nx\">server<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">app<\/span><span class=\"p\">.<\/span><span class=\"nf\">listen<\/span><span class=\"p\">(<\/span><span class=\"nx\">PORT<\/span><span class=\"p\">,<\/span> <span class=\"kd\">function<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"nx\">host<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">server<\/span><span class=\"p\">.<\/span><span class=\"nf\">address<\/span><span class=\"p\">().<\/span><span class=\"nx\">address<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"nx\">port<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">server<\/span><span class=\"p\">.<\/span><span class=\"nf\">address<\/span><span class=\"p\">().<\/span><span class=\"nx\">port<\/span>\r\n    <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"s2\">`Example app listening at http:\/\/<\/span><span class=\"p\">${<\/span><span class=\"nx\">server<\/span><span class=\"p\">}<\/span><span class=\"s2\">:<\/span><span class=\"p\">${<\/span><span class=\"nx\">port<\/span><span class=\"p\">}<\/span><span class=\"s2\">`<\/span><span class=\"p\">)<\/span>\r\n\r\n    <span class=\"nx\">dbConn<\/span><span class=\"p\">.<\/span><span class=\"nf\">getDB<\/span><span class=\"p\">(<\/span><span class=\"nx\">setDBCallback<\/span><span class=\"p\">);<\/span>\r\n<span class=\"p\">})<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u5011\u5c07\u9032\u884c\u69cb\u5efa\u548c\u90e8\u7f72\u3002<\/p>\n<p>\u5728\u90e8\u7f72\u65f6\uff0c\u901a\u8fc7\u8fd0\u884c &#8220;cf logs node-postgres-sample-srv&#8221; \u547d\u4ee4\u6765\u67e5\u770b\u5e94\u7528\u7a0b\u5e8f\u7684\u65e5\u5fd7\u3002\u5982\u679c\u5982\u4e0b\u6240\u793a\u80fd\u591f\u65e0\u9519\u8bef\u5730\u542f\u52a8\uff0c\u5219\u8bf4\u660e\u4e0e\u6570\u636e\u5e93\u7684\u8fde\u63a5\u987a\u5229\u5efa\u7acb\u3002<\/p>\n<pre class=\"post-pre\"><code>   2021-05-27T15:27:58.72+0900 [CELL\/0] OUT Downloaded droplet (22.9M)\r\n   2021-05-27T15:27:58.72+0900 [CELL\/0] OUT Starting health monitoring of container\r\n   2021-05-27T15:27:59.71+0900 [APP\/PROC\/WEB\/0] OUT &gt; node-postgres-sample@1.0.0 start \/home\/vcap\/app\r\n   2021-05-27T15:27:59.71+0900 [APP\/PROC\/WEB\/0] OUT &gt; node server.js\r\n   2021-05-27T15:27:59.95+0900 [APP\/PROC\/WEB\/0] OUT Example app listening at http:\/\/[object Object]:8080\r\n   2021-05-27T15:28:00.09+0900 [APP\/PROC\/WEB\/0] OUT database initialized [ { id: 1 } ]\r\n   2021-05-27T15:28:01.59+0900 [CELL\/0] OUT Container became healthy\r\n<\/code><\/pre>\n<p>\u53ef\u4ee5\u5728\u4e0b\u9762\u7684\u884c\u4e2d\u786e\u8ba4\u6570\u636e\u662f\u5426\u5df2\u83b7\u53d6\u3002<\/p>\n<pre class=\"post-pre\"><code> 2021-05-27T15:28:00.09+0900 [APP\/PROC\/WEB\/0] OUT database initialized [ { id: 1 } ]\r\n<\/code><\/pre>\n<h4>\uff08\u4ec5\u63d0\u4f9b\u4e00\u79cd\u9009\u9879\uff09\u5173\u4e8e\u8fde\u63a5\u7684\u53cd\u590d\u5c1d\u8bd5\u548c\u9519\u8bef<\/h4>\n<p>\u5728\u6211\u6240\u53c2\u8003\u7684\u6e90\u4ee3\u7801\u4e2d\uff0c\u8fde\u63a5\u5230\u6570\u636e\u5e93\u7684\u5904\u7406\u5982\u4e0b\u6240\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kd\">function<\/span> <span class=\"nf\">returnUriToDB<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"kd\">var<\/span> <span class=\"nx\">uri<\/span> <span class=\"o\">=<\/span> <span class=\"dl\">''<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">process<\/span><span class=\"p\">.<\/span><span class=\"nx\">env<\/span><span class=\"p\">.<\/span><span class=\"nx\">VCAP_SERVICES<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"c1\">\/\/ running in cloud<\/span>\r\n        <span class=\"nx\">uri<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">xsenv<\/span><span class=\"p\">.<\/span><span class=\"nf\">cfServiceCredentials<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">sapcpcfhw-db<\/span><span class=\"dl\">'<\/span><span class=\"p\">).<\/span><span class=\"nx\">uri<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"p\">}<\/span> <span class=\"k\">else<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">running locally is not supported<\/span><span class=\"dl\">'<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"nx\">uri<\/span><span class=\"p\">;<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n\r\n<span class=\"kd\">function<\/span> <span class=\"nf\">getDB<\/span><span class=\"p\">(<\/span><span class=\"nx\">cb<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"kd\">let<\/span> <span class=\"nx\">pgp<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">pg-promise<\/span><span class=\"dl\">'<\/span><span class=\"p\">)({<\/span>\r\n        <span class=\"c1\">\/\/ Initialization Options<\/span>\r\n    <span class=\"p\">});<\/span>\r\n    <span class=\"kd\">var<\/span> <span class=\"nx\">db<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">pgp<\/span><span class=\"p\">(<\/span><span class=\"nf\">returnUriToDB<\/span><span class=\"p\">());<\/span>\r\n    <span class=\"p\">...<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d48be37434c4406cacbc2\/65-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u5728\u53c2\u8003\u672cQA\u7684\u60c5\u51b5\u4e0b\uff0c\u6211\u5728\u8fde\u63a5URL\u4e0a\u6dfb\u52a0\u4e86?ssl=true\uff0c\u9519\u8bef\u7684\u5185\u5bb9\u53d1\u751f\u4e86\u53d8\u5316\u3002<\/p>\n<pre class=\"post-pre\"><code>uri = xsenv.cfServiceCredentials('cap-posgre-sample-db').uri + `?ssl=true`\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d48be37434c4406cacbc2\/68-0.png\" alt=\"image.png\" \/><\/div>\n<pre class=\"post-pre\"><code>        <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"na\">connectionString<\/span><span class=\"p\">:<\/span> <span class=\"nx\">xsenv<\/span><span class=\"p\">.<\/span><span class=\"nf\">cfServiceCredentials<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">cap-posgre-sample-db<\/span><span class=\"dl\">'<\/span><span class=\"p\">).<\/span><span class=\"nx\">uri<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">ssl<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"na\">rejectUnauthorized<\/span><span class=\"p\">:<\/span> <span class=\"kc\">false<\/span> <span class=\"p\">}<\/span>\r\n        <span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h2>\u603b\u7ed3<\/h2>\n<p>\u5728\u8fd9\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u4eec\u8fdb\u884c\u4e86\u4ee5\u4e0b\u5b9e\u65bd\u63aa\u65bd\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Node.js\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068PostgreSQL\u306e\u30b5\u30fc\u30d3\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u30d0\u30a4\u30f3\u30c9<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u767b\u9332<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Node.js\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089PostgreSQL\u306b\u63a5\u7d9a<\/ul>\n<p>\u5982\u679c\u4e0d\u4f7f\u7528CAP\uff0c\u6211\u4eec\u77e5\u9053\u4e86\u4e3a\u4e86\u8fde\u63a5\u6570\u636e\u5e93\u5fc5\u987b\u8981\u505a\u4ec0\u4e48\u3002\u4e0b\u4e00\u6b21\u6211\u4eec\u60f3\u8981\u5b9e\u73b0\u5bf9\u4e8e\u8868\u7684CRUD\u64cd\u4f5c\u3002<\/p>\n<h2>\u8bf7\u53c2\u8003<\/h2>\n<ul class=\"post-ul\">SAP-samples\/cloud-cf-helloworld-nodejs\/Chapter 2: Node.js RESTful API persists data in PostgreSQL DB<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u524d\u4e0d\u4e45\uff0c\u6211\u5199\u4e86\u4ee5\u4e0b\u7684\u6587\u7ae0\u3002 \u3010CAP\u3011\u5c06CAP\u90e8\u7f72\u5230BTP\u7684PostgreSQL\u6570\u636e\u5e93\u3002 \u4f7f\u7528cds-p [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41760","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>\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7 - 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\/\u3010btp\u3011-\u4f7f\u7528node-js\u548cpostgresql\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u524d\u4e0d\u4e45\uff0c\u6211\u5199\u4e86\u4ee5\u4e0b\u7684\u6587\u7ae0\u3002 \u3010CAP\u3011\u5c06CAP\u90e8\u7f72\u5230BTP\u7684PostgreSQL\u6570\u636e\u5e93\u3002 \u4f7f\u7528cds-p [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010btp\u3011-\u4f7f\u7528node-js\u548cpostgresql\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-08T01:11:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-03T20:38:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d48be37434c4406cacbc2\/31-0.png\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \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\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/\",\"name\":\"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-08T01:11:12+00:00\",\"dateModified\":\"2024-05-03T20:38:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7\"}]},{\"@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\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7 - 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\/\u3010btp\u3011-\u4f7f\u7528node-js\u548cpostgresql\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7","og_description":"\u9996\u5148 \u524d\u4e0d\u4e45\uff0c\u6211\u5199\u4e86\u4ee5\u4e0b\u7684\u6587\u7ae0\u3002 \u3010CAP\u3011\u5c06CAP\u90e8\u7f72\u5230BTP\u7684PostgreSQL\u6570\u636e\u5e93\u3002 \u4f7f\u7528cds-p [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010btp\u3011-\u4f7f\u7528node-js\u548cpostgresql\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-08T01:11:12+00:00","article_modified_time":"2024-05-03T20:38:59+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d48be37434c4406cacbc2\/31-0.png"}],"author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/","name":"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-08T01:11:12+00:00","dateModified":"2024-05-03T20:38:59+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010BTP\u3011 \u4f7f\u7528Node.js\u548cPostgreSQL\u521b\u5efa\u7b80\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff081\uff09\u51c6\u5907\u7bc7"}]},{"@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\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90btp%e3%80%91-%e4%bd%bf%e7%94%a8node-js%e5%92%8cpostgresql%e5%88%9b%e5%bb%ba%e7%ae%80%e5%8d%95%e7%9a%84%e5%ba%94%e7%94%a8%e7%a8%8b%e5%ba%8f%ef%bc%881%ef%bc%89%e5%87%86%e5%a4%87%e7%af%87\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41760","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41760"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41760\/revisions"}],"predecessor-version":[{"id":96163,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41760\/revisions\/96163"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}