{"id":41697,"date":"2022-12-15T23:02:11","date_gmt":"2023-02-24T21:37:26","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/"},"modified":"2024-04-29T05:29:02","modified_gmt":"2024-04-28T21:29:02","slug":"%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/","title":{"rendered":"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93"},"content":{"rendered":"

\u5199\u4f5c<\/h3>\n

\u4f7f\u7528Node.js\u521b\u5efa\u7684\u5e94\u7528\u7a0b\u5e8f\u5982\u4f55\u8fde\u63a5\u5230PostgreSQL\u6570\u636e\u5e93\u3002<\/p>\n

\u524d\u63d0\u6761\u4ef6 t\u00ed<\/h3>\n

\u4f7f\u7528\u4e0b\u8ff0\u6587\u7ae0\u4e2d\u63d0\u5230\u7684\u65b9\u6cd5\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002
\n\u5c06[DB \/ SQL]\u8981\u6c42\u8f6c\u5316\u4e3a\u8868\u683c\u7684\u8bb0\u4e8b\u65b9\u6cd5\u7684\u5907\u5fd8\u5f55\uff08\u4ee5\u590d\u5f0f\u7c3f\u8bb0\u8868\u683c\u8bbe\u8ba1\u4e3a\u4f8b\uff09\u3002<\/p>\n

\u6587\u4ef6\u5939\u7ed3\u6784<\/h3>\n
NodeJSSampleApp\r\n\u2523 app.js\r\n\u2523 node_modules\r\n\u2523 package-lock.json\r\n\u2523 package.json\r\n\u2523 public\r\n\u2517 views\r\n  \u2517 journal.ejs\r\n<\/code><\/pre>\n
\u4ee3\u7801 (Mandarin Chinese)<\/h3>\n
Pinyin:<\/p>\n
const<\/span> express<\/span> =<\/span> require<\/span>(<\/span>'<\/span>express<\/span>'<\/span>);<\/span>\r\nconst<\/span> app<\/span> =<\/span> express<\/span>();<\/span>\r\n\r\napp<\/span>.<\/span>use<\/span>(<\/span>express<\/span>.<\/span>static<\/span>(<\/span>'<\/span>public<\/span>'<\/span>));<\/span>\r\n\r\nvar<\/span> {<\/span>Client<\/span>}<\/span> =<\/span> require<\/span>(<\/span>'<\/span>pg<\/span>'<\/span>);<\/span>\r\n\r\nvar<\/span> client<\/span> =<\/span> new<\/span> Client<\/span>({<\/span>\r\n    user<\/span>:<\/span> '<\/span>DB USER NAME<\/span>'<\/span>,<\/span> \/\/ DB \u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u6307\u5b9a<\/span>\r\n    host<\/span>:<\/span> '<\/span>localhost<\/span>'<\/span>,<\/span>\r\n    database<\/span>:<\/span> '<\/span>SampleApp<\/span>'<\/span>,<\/span>\r\n    password<\/span>:<\/span> '<\/span>DB PASSWORD<\/span>'<\/span>,<\/span> \/\/ DB \u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6307\u5b9a<\/span>\r\n    post<\/span>:<\/span> 5432<\/span>\r\n})<\/span>\r\n\r\nclient<\/span>.<\/span>connect<\/span>();<\/span>\r\n\r\nvar<\/span> query<\/span> =<\/span> '<\/span>select journal.id as \u4ed5\u8a33ID,journal.date as \u65e5\u4ed8, (select accounts_title.name from accounts_title where accounts_title.id = journal_details.debit_accounts_id) as \u501f\u65b9\u79d1\u76ee,journal_details.credit_amount as \u501f\u65b9\u91d1\u984d,(select accounts_title.name from accounts_title where accounts_title.id = journal_details.credit_accounts_id) as \u8cb8\u65b9\u79d1\u76ee,journal_details.credit_amount as \u8cb8\u65b9\u91d1\u984d,journal.memo as \u6458\u8981 from journal_details join journal on journal_details.journal_id = journal.id;<\/span>'<\/span>;<\/span>\r\n\r\napp<\/span>.<\/span>get<\/span>(<\/span>'<\/span>\/<\/span>'<\/span>,(<\/span>req<\/span>,<\/span>res<\/span>)<\/span>=><\/span>{<\/span>\r\n\r\n    client<\/span>.<\/span>query<\/span>(<\/span>query<\/span>,(<\/span>error<\/span>,<\/span>result<\/span>)<\/span>=><\/span>{<\/span>\r\n        console<\/span>.<\/span>log<\/span>(<\/span>result<\/span>);<\/span>\r\n        res<\/span>.<\/span>render<\/span>(<\/span>'<\/span>journal.ejs<\/span>'<\/span>,{<\/span>results<\/span>:<\/span> result<\/span>});<\/span> \/\/ results \u306b\u683c\u7d0d\u3057\u305f\u53d6\u5f97\u7d50\u679c\u3092 journal.ejs \u3067\u8868\u793a<\/span>\r\n        client<\/span>.<\/span>end<\/span>();<\/span>\r\n    });<\/span>\r\n\r\n});<\/span>\r\n\r\napp<\/span>.<\/span>listen<\/span>(<\/span>3000<\/span>);<\/span>\r\n<\/code><\/pre>\n
<html>\r\n<head>\r\n<title>\u8907\u5f0f\u7c3f\u8a18<\/title>\r\n<link rel = \"stylesheet\" type=\"text\/css\" href = \"\/css\/style.css\">\r\n<head>\r\n<body>\r\n<h1>\u8907\u5f0f\u7c3f\u8a18<\/h1>\r\n<table>\r\n<thead>\r\n<tr>\r\n<th>\u4ed5\u5206ID<\/th>\r\n<th>\u65e5\u4ed8<\/th>\r\n<th>\u501f\u65b9\u79d1\u76ee<\/th>\r\n<th>\u501f\u65b9\u91d1\u984d<\/th>\r\n<th>\u8cb8\u65b9\u79d1\u76ee<\/th>\r\n<th>\u8cb8\u65b9\u91d1\u984d<\/th>\r\n<th>\u6458\u8981<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<% for(var i=0;i< results.rowCount;i++) {%>\r\n<% var year = results.rows[i].\u65e5\u4ed8.getFullYear(); %>\r\n<% var month = results.rows[i].\u65e5\u4ed8.getMonth() + 1; %>\r\n<% var day = results.rows[i].\u65e5\u4ed8.getDate(); %>\r\n<tr>\r\n<td><%= results.rows[i].\u4ed5\u8a33id %><\/td>\r\n<td><%= year + '\/' + month + '\/' + day %><\/td>\r\n<td><%= results.rows[i].\u501f\u65b9\u79d1\u76ee %><\/td>\r\n<td><%= results.rows[i].\u501f\u65b9\u91d1\u984d %><\/td>\r\n<td><%= results.rows[i].\u8cb8\u65b9\u79d1\u76ee %><\/td>\r\n<td><%= results.rows[i].\u8cb8\u65b9\u91d1\u984d %><\/td>\r\n<td><%= results.rows[i].\u6458\u8981 %><\/td>\r\n<\/tr>\r\n<% } %>\r\n<\/table>\r\n\r\n<\/body>\r\n<\/html>\r\n<\/code><\/pre>\n
\u6253\u5f00\u5e94\u7528\u7a0b\u5e8f\uff0c\u4ece\u6d4f\u89c8\u5668\u4e2d\u8bbf\u95ee localhost:3000<\/h3>\n
$ cd NodeJSSampleApp\r\n$ node app.js\r\n<\/code><\/pre>\n
\u8868\u660e\u6548\u679c<\/h3>\n
\"2020-05-06<\/div>\n","protected":false},"excerpt":{"rendered":"
\u5199\u4f5c \u4f7f\u7528Node.js\u521b\u5efa\u7684\u5e94\u7528\u7a0b\u5e8f\u5982\u4f55\u8fde\u63a5\u5230PostgreSQL\u6570\u636e\u5e93\u3002 \u524d\u63d0\u6761\u4ef6 t\u00ed \u4f7f\u7528\u4e0b\u8ff0\u6587\u7ae0\u4e2d\u63d0 […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41697","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93 - 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\/\uff3bnode-js-postgresql\uff3d\u4f7f\u7528-node-js-\u5e94\u7528\u8fde\u63a5\u5230-postgresql-\u6570\u636e\u5e93\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93\" \/>\n<meta property=\"og:description\" content=\"\u5199\u4f5c \u4f7f\u7528Node.js\u521b\u5efa\u7684\u5e94\u7528\u7a0b\u5e8f\u5982\u4f55\u8fde\u63a5\u5230PostgreSQL\u6570\u636e\u5e93\u3002 \u524d\u63d0\u6761\u4ef6 t\u00ed \u4f7f\u7528\u4e0b\u8ff0\u6587\u7ae0\u4e2d\u63d0 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\uff3bnode-js-postgresql\uff3d\u4f7f\u7528-node-js-\u5e94\u7528\u8fde\u63a5\u5230-postgresql-\u6570\u636e\u5e93\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-24T21:37:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-28T21:29:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d488437434c4406cabec4\/12-0.png\" \/>\n<meta name=\"author\" content=\"\u6e05, \u5b87\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u5b87\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \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\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/\",\"name\":\"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-02-24T21:37:26+00:00\",\"dateModified\":\"2024-04-28T21:29:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93\"}]},{\"@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\/1a6ecd3d914d22a5ac32791ffc1fbd8e\",\"name\":\"\u6e05, \u5b87\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u5b87\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93 - 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\/\uff3bnode-js-postgresql\uff3d\u4f7f\u7528-node-js-\u5e94\u7528\u8fde\u63a5\u5230-postgresql-\u6570\u636e\u5e93\/","og_locale":"zh_CN","og_type":"article","og_title":"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93","og_description":"\u5199\u4f5c \u4f7f\u7528Node.js\u521b\u5efa\u7684\u5e94\u7528\u7a0b\u5e8f\u5982\u4f55\u8fde\u63a5\u5230PostgreSQL\u6570\u636e\u5e93\u3002 \u524d\u63d0\u6761\u4ef6 t\u00ed \u4f7f\u7528\u4e0b\u8ff0\u6587\u7ae0\u4e2d\u63d0 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\uff3bnode-js-postgresql\uff3d\u4f7f\u7528-node-js-\u5e94\u7528\u8fde\u63a5\u5230-postgresql-\u6570\u636e\u5e93\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-02-24T21:37:26+00:00","article_modified_time":"2024-04-28T21:29:02+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d488437434c4406cabec4\/12-0.png"}],"author":"\u6e05, \u5b87","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u5b87","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/","name":"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-02-24T21:37:26+00:00","dateModified":"2024-04-28T21:29:02+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\uff3bNode.js + PostgreSQL\uff3d\u4f7f\u7528 Node.js \u5e94\u7528\u8fde\u63a5\u5230 PostgreSQL \u6570\u636e\u5e93"}]},{"@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\/1a6ecd3d914d22a5ac32791ffc1fbd8e","name":"\u6e05, \u5b87","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","caption":"\u6e05, \u5b87"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%ef%bc%bbnode-js-postgresql%ef%bc%bd%e4%bd%bf%e7%94%a8-node-js-%e5%ba%94%e7%94%a8%e8%bf%9e%e6%8e%a5%e5%88%b0-postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41697","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41697"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41697\/revisions"}],"predecessor-version":[{"id":83329,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41697\/revisions\/83329"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}