{"id":25617,"date":"2023-08-01T11:54:11","date_gmt":"2023-08-01T02:54:11","guid":{"rendered":"http:\/\/nori.company\/?p=25617"},"modified":"2023-08-01T11:54:11","modified_gmt":"2023-08-01T02:54:11","slug":"peerdb-postgres%eb%a5%bc-%ec%9c%84%ed%95%9c-etl-elt-%ed%94%8c%eb%9e%ab%ed%8f%bc","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=25617","title":{"rendered":"PeerDB &#8211; Postgres\ub97c \uc704\ud55c ETL\/ELT \ud50c\ub7ab\ud3fc"},"content":{"rendered":"<ul>\n<li>Postgres\uc5d0\uc11c \ub370\uc774\ud130\ub97c 10\ubc30 \uc774\uc0c1 \ube60\ub974\uac8c In\/Out \uac00\ub2a5\ud558\uac8c \ucd5c\uc801\ud654<\/li>\n<li>\uac04\ub2e8\ud55c SQL\uba85\ub839\uc73c\ub85c Sync\/Transform\/Query \uac00\ub2a5<\/li>\n<li>\uc0ac\uc6a9 \uac00\ub2a5\ud55c Use-Case\n<ul>\n<li>\uc2e4\uc2dc\uac04 CDC(Change-Data-Capture)<\/li>\n<li>\ub370\uc774\ud130 \uc2a4\ud1a0\uc5b4\uac04 \ucffc\ub9ac \uacb0\uacfc\uc758 \uc2e4\uc2dc\uac04 \uc2a4\ud2b8\ub9ac\ubc0d<\/li>\n<li>\uacf5\ud1b5 SQL Interface\ub85c \uba40\ud2f0 \ub370\uc774\ud130 \uc2a4\ud1a0\uc5b4&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=10117\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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&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-25617","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-6Fb","jetpack-related-posts":[{"id":28201,"url":"https:\/\/nori.company\/?p=28201","url_meta":{"origin":25617,"position":0},"title":"Dataherald &#8211; \uc790\uc5f0\uc5b4-to-SQL \uc5d4\uc9c4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 30\uc77c","format":false,"excerpt":"\uad6c\uc870\ud654\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud574\uc11c \uc790\uc5f0\uc5b4\ub85c \ucffc\ub9ac \uac00\ub2a5\ud55c NL-to-SQL \uc5d4\uc9c4 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \ub300\ud55c \uc790\uc5f0\uc5b4 \ucffc\ub9ac API\ub97c \uc0dd\uc131\ud560\uc218 \uc788\uac8c \ud574\uc90c Postgres, BigQuery, Databricks, Snowflake \uc9c0\uc6d0 SaaS \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c DB\uc5d0 \ub300\ud55c Q&A\ub97c \ud558\uac70\ub098, \uc790\uc2e0\uc758 \ub370\uc774\ud130\uc5d0 \ub300\ud55c ChatGPT ... \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":29364,"url":"https:\/\/nori.company\/?p=29364","url_meta":{"origin":25617,"position":1},"title":"\ub2f9\uc2e0\uc774 \uc544\ub9c8\ub3c4 SQLite\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uc774\uc720","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 28\uc77c","format":false,"excerpt":"\uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130 \uc800\uc7a5\uc5d0 SQLite \uc0ac\uc6a9\uc758 \uc774\uc810\uc5d0 \ub300\ud55c \uae30\uc0ac, MySQL \ubc0f Postgres\uc640 \uac19\uc740 \ub2e4\ub978 \uc194\ub8e8\uc158\uacfc \ube44\uad50 SQLite\ub294 SQL \uae30\ubc18 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e8\uc77c \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud558\uc5ec \uac04\ub2e8\ud558\uace0 \uace0\uae09 \uc0ac\uc6a9 \uc0ac\ub840 \ubaa8\ub450\uc5d0 \uac04\ub2e8\ud55c \uc194\ub8e8\uc158 \uc81c\uacf5 SQLite\ub294 \ub2e8\uc77c \ud30c\uc77c \uad6c\uc870\ub85c \uc778\ud55c \uc81c\ub85c \uc9c0\uc5f0... \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":26178,"url":"https:\/\/nori.company\/?p=26178","url_meta":{"origin":25617,"position":2},"title":"Postgres\ub294 \uc5b8\uc81c\ubd80\ud130 \uba4b\uc788\uc5b4\uc84c\uc744\uae4c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 14\uc77c","format":false,"excerpt":"VC \ud380\ub529\ub3c4, DevRel \ud300\ub3c4 \uc5c6\uc774 25\ub144\uac04 \ucc9c\ucc9c\ud788 \uc9c4\ud654\ud568 Ingres(UC \ubc84\ud074\ub9ac, 1970~1985) \u2014> Postgres95 \u2014> PostgreSQL Postgres = \"Post Ingres\" \uccab \uc5b8\uc5b4\ub294 SQL\ub3c4 \uc544\ub2cc QUEL \uc774\uc5c8\uc74c. SQL \uc9c0\uc6d0\uc740 Postgres95\uac00 \ucd9c\uc2dc\ub41c 1995\ub144\uc5d0 \ucd94\uac00\ub428 1996\ub144 Pos... \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":25617,"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":26172,"url":"https:\/\/nori.company\/?p=26172","url_meta":{"origin":25617,"position":4},"title":"Retake &#8211; Postgres\uc6a9 \ud558\uc774\ube0c\ub9ac\ub4dc \uac80\uc0c9 \uc624\ud508\uc18c\uc2a4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 14\uc77c","format":false,"excerpt":"\ud0a4\uc6cc\ub4dc(\uae30\uc874 \uac80\uc0c9) + \uc2dc\ub9e8\ud2f1 \uc11c\uce58(\ubca1\ud130 \uae30\ubc18 \uac80\uc0c9)\ub97c \ud558\ub098\uc758 SDK\uc5d0\uc11c \ud1b5\ud569\ud558\uc5ec \uc0ac\uc6a9\uac00\ub2a5\ud558\uac8c \ucd94\uac00 \uac00\ub2a5 query, with_semantic, with_neural \uc744 \ud1b5\ud574 \uac01\uac01 \ub610\ub294 \ud1b5\ud569\ud558\uc5ec \uac80\uc0c9 \uac00\ub2a5 \uc9c1\uc811 Postgres\uc5d0 \uc5f0\uacb0\ud558\uc5ec CDC \uae30\ubc18\uc73c\ub85c \ubcf5\uc81c\ud558\uace0 \uc778\ub371\uc2f1\uc744 \ucc98\ub9ac \ub370\uc774\ud130 \ubcc0\uacbd\uc2dc \uc784\ubca0\ub529... \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":22316,"url":"https:\/\/nori.company\/?p=22316","url_meta":{"origin":25617,"position":5},"title":"SQL Maxis: RabbitMQ\ub97c Postgres Queue\ub85c \uad50\uccb4\ud55c \uc774\uc720","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 4\uc6d4 13\uc77c","format":false,"excerpt":"RabbitMQ\ub97c \uac77\uc5b4\ub0b4\uace0 PostgresDB\uc5d0 SQL\uc744 \uc774\uc6a9\ud55c \ud050\ub85c \uad50\uccb4 \uad50\uccb4\uc5d0\ub294 \ubc18\ub098\uc808 \uc815\ub3c4 \uac78\ub838\uace0, \uc18c\uc2a4\ub294 580\ub77c\uc778 \uc904\uc5b4\ub4ec \ud6e8\uc52c \uc911\uc694\ud55c \uac83\uc740 \uc548\uc815\uc131\uacfc \ubcf5\uc6d0\uc131(Resiliency)\uac00 \ud06c\uac8c \ud5a5\uc0c1 \ub418\uc5c8\ub2e4\ub294 \uac83 RabbitMQ \uac19\uc740 \ud050 \uc2dc\uc2a4\ud15c\uc758 \ubb38\uc81c\uc5d0 \ub300\ud55c \uc598\uae30\uac00 \uc544\ub2c8\uace0, \ub2e8\uc21c\ud558\uac8c \uc720\uc9c0\ud558\uae30 \uc704\ud55c \ub178\ub825\uc758 \uc77c... \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\/25617","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=25617"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25617\/revisions"}],"predecessor-version":[{"id":25618,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25617\/revisions\/25618"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}