{"id":29785,"date":"2023-11-08T10:52:24","date_gmt":"2023-11-08T01:52:24","guid":{"rendered":"http:\/\/nori.company\/?p=29785"},"modified":"2023-11-08T10:52:24","modified_gmt":"2023-11-08T01:52:24","slug":"doltgresql-%eb%b2%84%ec%a0%84-%ec%bb%a8%ed%8a%b8%eb%a1%a4%eb%90%98%eb%8a%94-postgresql","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=29785","title":{"rendered":"DoltgreSQL &#8211; \ubc84\uc804 \ucee8\ud2b8\ub864\ub418\ub294 PostgreSQL"},"content":{"rendered":"<ul>\n<li>\ubc84\uc804 \ucee8\ud2b8\ub864 \ub418\ub294 SQL DB\uc778 Dolt(&quot;Git for Data&quot;)\uac00 PostgreSQL \ubc84\uc804\uc744 \uacf5\uac1c<\/li>\n<li>Postgres\uc758 \uc2a4\ud0a4\ub9c8\uc640 \ub370\uc774\ud130\uc5d0 \ub300\ud574\uc11c Git \uc2a4\ud0c0\uc77c\uc758 log, diff, branch, merge \ub4f1\uc758 \uae30\ub2a5\uc744 \uc9c0\uc6d0<\/li>\n<li>2019\ub144\ubd80\ud130 \ub9cc\ub4e4\uc5b4\uc9c4 \uae30\uc874 Dolt\ub294 \ub0b4\ubd80\uc560 MySQL\uad00\ub828 \ucf54\ub4dc\ub294 \uc5c6\uc9c0\ub9cc \uadf8\uc5d0 \ub9de\ucdb0\uc838 \uc788\uc5c8\uace0, \uadf8 \uc2dc\uc808\uc5d4 SQL\ucabd&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=11739\" 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>\ubc84\uc804 \ucee8\ud2b8\ub864 \ub418\ub294 SQL DB\uc778 Dolt(&quot;Git for Data&quot;)\uac00 PostgreSQL \ubc84\uc804\uc744 \uacf5\uac1c Postgres\uc758 \uc2a4\ud0a4\ub9c8\uc640 \ub370\uc774\ud130\uc5d0 \ub300\ud574\uc11c Git \uc2a4\ud0c0\uc77c\uc758 log, diff, branch,&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-29785","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-7Kp","jetpack-related-posts":[{"id":31533,"url":"https:\/\/nori.company\/?p=31533","url_meta":{"origin":29785,"position":0},"title":"HN\uc5d0 \ubb3b\ub2e4: \ubc84\uc804 \uad00\ub9ac\ub97c \uc704\ud574 Git\ubcf4\ub2e4 \ub098\uc740 \ubc29\ubc95\uc774 \uc788\uc744\uae4c?","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 12\uc6d4 13\uc77c","format":false,"excerpt":"Git\uc758 \ubbf8\ub798\uc640 \uac00\ub2a5\uc131 \ubc84\uc804 \uad00\ub9ac \uc2dc\uc2a4\ud15c(VCS)\uc5d0 \uc788\uc5b4 Git\uc774 \ucd5c\uc885\uc801\uc778 \ud574\uacb0\ucc45\uc778\uc9c0, \uc544\ub2c8\uba74 \ub354 \ub098\uc740 \uc2dc\uc2a4\ud15c\uc774 \uac00\ub2a5\ud55c\uc9c0\uc5d0 \ub300\ud55c \uc758\ubb38 \uc81c\uae30. Git\uc758 \ud604\uc7ac \uc9c0\uc704\uc640 \uadf8 \ud55c\uacc4\uc810\uc744 \uace0\ub824\ud55c \ub17c\uc758 \ud544\uc694\uc131. \uae30\uc220 \ubc1c\uc804\uacfc \uc0ac\uc6a9\uc790 \uc694\uad6c\uc758 \ubcc0\ud654\uc5d0 \ub530\ub77c \uc0c8\ub85c\uc6b4 VCS\uc758 \uac00\ub2a5\uc131 \ud0d0\uc0c9. GN\u207a\uc758... \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":25662,"url":"https:\/\/nori.company\/?p=25662","url_meta":{"origin":29785,"position":1},"title":"\uc8fc\uc220: \uac04\ub2e8\ud558\uace0 \uac15\ub825\ud55c Git \ud638\ud658 \ubd84\uc0b0 \ubc84\uc804 \uad00\ub9ac \uc2dc\uc2a4\ud15c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 2\uc77c","format":false,"excerpt":"Jujutsu: Git \ud638\ud658 DVCS\ub85c Git, Mercurial, Pijul\/Darcs\uc758 \uae30\ub2a5\uc744 \uacb0\ud569\ud558\uace0 \ub3c5\ud2b9\ud55c \uae30\ub2a5\uc744 \ucd94\uac00\ud55c \uac83 \uba85\ub839 \uc904 \ub3c4\uad6c\ub294 jj\ub85c \ubd88\ub9ac\uba70 \ud504\ub85c\uc81d\ud2b8\ub294 \"Jujutsu\"\ub85c \ubd88\ub9bc Jujutsu\ub294 Git\uacfc \ud638\ud658\ub418\uba70 Git \ubc31\uc5d4\ub4dc\ub97c \uac00\uc9c0\uace0 \uc788\uc74c \uac70\uc758 \ubaa8\ub4e0 Jujutsu \uba85\ub839\uc740 \uc791\uc5c5 \ubcf5\uc0ac\ubcf8\uc744 \uc790\ub3d9\uc73c\ub85c \ucee4\ubc0b... \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":22937,"url":"https:\/\/nori.company\/?p=22937","url_meta":{"origin":29785,"position":2},"title":"\ub354 \ub098\uc740 Git \uc6cc\ud06c\ud50c\ub85c\uc6b0\ub97c \ud5a5\ud574\uc11c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 5\uc6d4 4\uc77c","format":false,"excerpt":"\uae43\uc744 \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc73c\ub85c \ud65c\uc6a9\ud558\uae30 \uc704\ud55c \ubc29\ubc95\uc744 \ubaa8\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ub808\ud3ec\uad6c\uc870 Git\uc740 \ubd84\uc0b0 \ubc84\uc804 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc774\ub77c \uc911\uc559\uc9d1\uc911\ud615, \uae43\ud5c8\ube0c\/\uae43\ub7a9 \ubc29\uc2dd, \uacc4\uce35\ud615\ub4f1 \ub2e4\uc591\ud55c \ubc29\uc2dd\uc73c\ub85c \uad6c\uc131 \uac00\ub2a5 \ube0c\ub79c\uce58 \uad6c\uc870 \uae43\ud5c8\ube0c \ud50c\ub85c\uc6b0: Main\uc744 \ub450\uace0 \uae30\ub2a5\uc774\ub098 \ubc84\uadf8 \ube0c\ub79c\uce58\ub97c \uc0dd\uc131 \ud6c4 \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":26598,"url":"https:\/\/nori.company\/?p=26598","url_meta":{"origin":29785,"position":3},"title":"Cloud Database Cheat Sheet","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 24\uc77c","format":false,"excerpt":"AWS,Azure,Google \uacfc \uc624\ud508\uc18c\uc2a4\/\uc368\ub4dc\ud30c\ud2f0\uc758 DB \ub4e4\uc744 Type\uc5d0 \ub530\ub77c \ud55c\uac1c\uc758 \ud14c\uc774\ube14\ub85c \uc815\ub9ac Structured Relational : RDS, SQL DB, Cloud SQL, Oracle\/PostgreSQL\/MySQL\/SQL Server Columnar : Redshift, Synapse Analytics, BigQuery, Snowflake\/ClickHouse Semi... \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":28808,"url":"https:\/\/nori.company\/?p=28808","url_meta":{"origin":29785,"position":4},"title":"PostgresJs: Node.js\uc640 Deno\ub97c \uc704\ud55c PostgreSQL \ud074\ub77c\uc774\uc5b8\ud2b8","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 16\uc77c","format":false,"excerpt":"Postgres.js\ub294 \uac04\ub2e8\ud55c API\ub97c \uac00\uc9c4 Node.js\uc640 Deno\uc6a9 PostgreSQL \ud074\ub77c\uc774\uc5b8\ud2b8\uc785\ub2c8\ub2e4. \uc774 \ud074\ub77c\uc774\uc5b8\ud2b8\ub294 ES6 \ud0dc\uadf8 \ud15c\ud50c\ub9bf \ubb38\uc790\uc5f4\uc744 \uc0ac\uc6a9\ud558\uba70 \ub3d9\uc801 \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. Gitter\uc5d0\uc11c \ucc44\ud305 \ubc0f \ub3c4\uc6c0\uc744 \uc81c\uacf5\ud558\uba70 npm\uc744 \ud1b5\ud574 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Postgres.js\ub294 SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4 \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":27564,"url":"https:\/\/nori.company\/?p=27564","url_meta":{"origin":29785,"position":5},"title":"PostgreSQL 16","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 15\uc77c","format":false,"excerpt":"PostgreSQL 16\uc740 \ucffc\ub9ac \ubcd1\ub82c\uc131, \ub300\ub7c9 \ub370\uc774\ud130 \ub85c\ub529 \ubc0f \ub17c\ub9ac\uc801 \ubcf5\uc81c\uac00 \ub208\uc5d0 \ub744\uac8c \uac1c\uc120\ub418\uc5b4 \uc131\ub2a5\uc744 \ud5a5\uc0c1 \ub354 \ub9ce\uc740 SQL\/JSON \ubb38\ubc95, \uc791\uc5c5 \ubd80\ud558\ub97c \uc704\ud55c \uc0c8\ub85c\uc6b4 \ubaa8\ub2c8\ud130\ub9c1 \ud1b5\uacc4, \uadf8\ub9ac\uace0 \uc811\uadfc \uc81c\uc5b4 \uaddc\uce59\uc744 \uc815\uc758\ud558\ub294 \ub370 \ub354 \ud070 \uc720\uc5f0\uc131\uc744 \ub3c4\uc785 \uc131\ub2a5 \uac1c\uc120 \ucffc\ub9ac \ud50c\ub798\ub108\uac00 \uc774\uc81c FULL \ubc0f R... \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\/29785","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=29785"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/29785\/revisions"}],"predecessor-version":[{"id":29786,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/29785\/revisions\/29786"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}