{"id":27950,"date":"2023-09-24T12:53:07","date_gmt":"2023-09-24T03:53:07","guid":{"rendered":"http:\/\/nori.company\/?p=27950"},"modified":"2023-09-24T12:53:07","modified_gmt":"2023-09-24T03:53:07","slug":"postgres%ec%97%90%ec%84%9c-%eb%b3%80%ed%99%94%eb%a5%bc-%ed%8f%ac%ec%b0%a9%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95%eb%93%a4","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=27950","title":{"rendered":"Postgres\uc5d0\uc11c \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ubc29\ubc95\ub4e4"},"content":{"rendered":"<ul>\n<li>\uae30\uc0ac\ub294 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ub2e4\uc591\ud55c \ubc29\ubc95\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4.<\/li>\n<li>Sequin\uc774\ub77c\ub294 \ud68c\uc0ac\ub294 Salesforce\uc640 HubSpot\uacfc \uac19\uc740 \uc81c3\uc790 API\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \ub3d9\uae30\ud654\ud558\uc5ec \uac1c\ubc1c\uc790\ub4e4\uc774 \uadf8\ub4e4\uc758 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec API \ub370\uc774\ud130\ub97c \uad6c\ucd95\ud558\uac8c \ud569\ub2c8\ub2e4.<\/li>\n<li>Postgres\ub294 \ud14c\uc774\ube14 \ubcc0\ud654\uc5d0 \uae30&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=11020\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uae30\uc0ac\ub294 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ub2e4\uc591\ud55c \ubc29\ubc95\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4. Sequin\uc774\ub77c\ub294 \ud68c\uc0ac\ub294 Salesforce\uc640 HubSpot\uacfc \uac19\uc740 \uc81c3\uc790 API\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \ub3d9\uae30\ud654\ud558\uc5ec \uac1c\ubc1c\uc790\ub4e4\uc774 \uadf8\ub4e4\uc758&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[138],"tags":[163],"class_list":["post-27950","post","type-post","status-publish","format-standard","hentry","category-it","tag-geeknews-----"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa3PO4-7gO","jetpack-related-posts":[{"id":25617,"url":"https:\/\/nori.company\/?p=25617","url_meta":{"origin":27950,"position":0},"title":"PeerDB &#8211; Postgres\ub97c \uc704\ud55c ETL\/ELT \ud50c\ub7ab\ud3fc","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 1\uc77c","format":false,"excerpt":"Postgres\uc5d0\uc11c \ub370\uc774\ud130\ub97c 10\ubc30 \uc774\uc0c1 \ube60\ub974\uac8c In\/Out \uac00\ub2a5\ud558\uac8c \ucd5c\uc801\ud654 \uac04\ub2e8\ud55c SQL\uba85\ub839\uc73c\ub85c Sync\/Transform\/Query \uac00\ub2a5 \uc0ac\uc6a9 \uac00\ub2a5\ud55c Use-Case \uc2e4\uc2dc\uac04 CDC(Change-Data-Capture) \ub370\uc774\ud130 \uc2a4\ud1a0\uc5b4\uac04 \ucffc\ub9ac \uacb0\uacfc\uc758 \uc2e4\uc2dc\uac04 \uc2a4\ud2b8\ub9ac\ubc0d \uacf5\ud1b5 SQL Interface\ub85c \uba40\ud2f0 \ub370\uc774\ud130 \uc2a4\ud1a0\uc5b4... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28008,"url":"https:\/\/nori.company\/?p=28008","url_meta":{"origin":27950,"position":1},"title":"Postgres \ud050 \uae30\uc220 \uc120\ud0dd","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 25\uc77c","format":false,"excerpt":"\"Postgres \ud050 \uae30\uc220 \uc0ac\uc6a9\uc758 \uc7a5\uc810\uc5d0 \ub300\ud55c \uae30\uc0ac, \ub2e4\ub978 '\ud655\uc7a5 \uac00\ub2a5\ud55c' \ud050 \uae30\uc220\ub4e4\uc5d0 \ube44\ud574 \uc6b0\uc6d4\ud558\ub2e4\ub294 \uc8fc\uc7a5\" \"Postgres \ud050 \uae30\uc220\uc774 \uc8fc\ub958\uac00 \uc544\ub2cc \uc774\uc720: \ub2e4\ub978 \ud050 \uae30\uc220\ub4e4\uc774 \ub354 \ud070 \ud655\uc7a5\uc131\uc744 \uc81c\uacf5\ud55c\ub2e4\ub294 \uc77c\ubc18\uc801\uc778 \uc0dd\uac01\" \"webapp.io\uc640 \uac19\uc740 \ud68c\uc0ac\ub4e4\uc774 \uc6b4\uc601\uc758 \ub2e8\uc21c\uc131, \uc720\uc9c0 \ubcf4\uc218\uc131... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28586,"url":"https:\/\/nori.company\/?p=28586","url_meta":{"origin":27950,"position":2},"title":"pg_bm25 &#8211; Postgres\uc5d0\uc11c Elastic \uc218\uc900\uc758 \ud488\uc9c8\uc744 \uc81c\uacf5\ud558\ub294 Full-Text \uac80\uc0c9 \ud655\uc7a5","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 11\uc77c","format":false,"excerpt":"Rust \uae30\ubc18\uc758 Postgres \ud655\uc7a5\uc73c\ub85c Full Text \uac80\uc0c9\uc744 \ud5a5\uc0c1\uc2dc\ucf1c\uc90c \ucd5c\uc2e0 \uac80\uc0c9 \uc5d4\uc9c4\ub4e4\uc774 \uc774\uc6a9\ud558\ub294 BM25 \uc54c\uace0\ub9ac\ub4ec(\uac80\uc0c9 \uacb0\uacfc\uc758 \uad00\ub828\uc131 \uc810\uc218\ub97c \uacc4\uc0b0) \uae30\ubc18 \ud604\uc7ac Postgres \uac00 \uc0ac\uc6a9\ud558\ub294 tsvector \uae30\ubc18 \uac80\uc0c9\uc740 2\uac1c\uc758 \ubb38\uc81c\uac00 \uc788\uc74c \uc131\ub2a5 : \ub300\uaddc\ubaa8 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 \uac80\uc0c9\uc774 \ub290\ub9bc \uae30\ub2a5 : \ud37c\uc9c0... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":29075,"url":"https:\/\/nori.company\/?p=29075","url_meta":{"origin":27950,"position":3},"title":"Instant &#8211; JavaScript \ubc0f Postgres\ub97c \uc0ac\uc6a9\ud558\uc5ec API\ub97c \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ud234\ud0b7","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 21\uc77c","format":false,"excerpt":"JavaScript\ub97c \uc704\ud55c \uc0c8\ub85c\uc6b4 Postgres ORM\uc73c\ub85c \ub370\uc774\ud130 \uc870\uc791 \ubc0f \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ub3c4\uad6c\ub97c \uc81c\uacf5 Rails\uc5d0\uc11c \uc601\uac10\uc744 \ubc1b\uc740 CLI\ub85c \uac1c\ubc1c\uc790\uac00 \ube60\ub974\uac8c \uc778\ud130\ub137 \ube44\uc988\ub2c8\uc2a4\ub97c \uad6c\ucd95\ud558\ub3c4\ub85d \ub3c4\uc6c0 Autocode \ub610\ub294 Vercel \uc744 \uc704\ud55c Scaffold \uc0dd\uc131 ... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":31577,"url":"https:\/\/nori.company\/?p=31577","url_meta":{"origin":27950,"position":4},"title":"\ubb34\uc911\ub2e8 Postgres \uc5c5\uadf8\ub808\uc774\ub4dc","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 12\uc6d4 14\uc77c","format":false,"excerpt":"Postgres \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uc704\ud55c \uc900\ube44 \ub9ac\uc2a4\ud06c \ud3c9\uac00: \uc5c5\uadf8\ub808\uc774\ub4dc \uacfc\uc815\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ub9ac\uc2a4\ud06c \ubaa9\ub85d \uc791\uc131 \ubc0f \uc911\uc694\ub3c4\uc5d0 \ub530\ub978 \uc815\ub82c. \ub9ac\uc2a4\ud06c \ud574\uacb0 \ubc29\uc548 \ubaa8\uc0c9: \ub9ac\uc2a4\ud06c\ub97c \uc644\uc804\ud788 \uc81c\uac70\ud558\uac70\ub098 \uc2dc\uac04\uc5d0 \uac78\uccd0 \ubd84\uc0b0\uc2dc\ud0ac \uc218 \uc788\ub294 \ud574\uacb0\ucc45 \uace0\ub824. \ub9ac\uc2a4... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22263,"url":"https:\/\/nori.company\/?p=22263","url_meta":{"origin":27950,"position":5},"title":"PL\/Rust &#8211; Rust\ub85c PostgreSQL \ud568\uc218 \uc791\uc131\ud558\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 4\uc6d4 12\uc77c","format":false,"excerpt":"\"Rust Procedural Language Handler\" \uae30\uc874 PL\ucc98\ub7fc \uc778\ud130\ud504\ub9ac\ud2b8 \ub418\uc9c0 \uc54a\uace0 \ub124\uc774\ud2f0\ube0c \uba38\uc2e0 \ucf54\ub4dc\ub85c \ucef4\ud30c\uc77c \ub418\uc5b4 \ucd5c\uc801\uc758 \uc131\ub2a5\uc744 \uad6c\ud604 \ub3d9\uc801 \ucffc\ub9ac, Prepared Statement, Cursor \ub4f1\uc744 \ud3ec\ud568\ud55c Postgres\uc758 SPI \uc811\uadfc\uc744 \uc9c0\uc6d0 pgx \uae30\ubc18\uc758 Postgres \ud655\uc7a5 ... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/27950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=27950"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/27950\/revisions"}],"predecessor-version":[{"id":27951,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/27950\/revisions\/27951"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=27950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=27950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=27950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}