{"id":49835,"date":"2026-11-22T21:17:28","date_gmt":"2026-11-22T12:17:28","guid":{"rendered":"https:\/\/jore2.com\/?p=49835"},"modified":"2026-11-22T21:17:28","modified_gmt":"2026-11-22T12:17:28","slug":"tips-24048-postgresql-extensions-in-go","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=49835","title":{"rendered":"TinyGo \uae30\ubc18 gopgext\ub85c Go \uc5b8\uc5b4 PostgreSQL \ud655\uc7a5 \uac1c\ubc1c \uac00\ub2a5"},"content":{"rendered":"<div class=\"jore2-editor-byline\">\n<p><strong>\uc774\uac00\uc740<\/strong><\/p>\n<\/div>\n<p>\uac1c\ubc1c\uc790 jespino\uac00 TinyGo \ucef4\ud30c\uc77c\ub7ec\ub97c \uae30\ubc18\uc73c\ub85c \ud55c \uc0c8\ub85c\uc6b4 \ud504\ub808\uc784\uc6cc\ud06c gopgext\ub97c \uacf5\uac1c\ud588\uc2b5\ub2c8\ub2e4. \uc774 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uba74 \uc21c\uc218 Go \ucf54\ub4dc\ub85c PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud655\uc7a5\uc744 \uc9c1\uc811 \uac1c\ubc1c\ud558\uace0 \ubc30\ud3ec\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4.<\/p>\n<p>\uae30\uc874\uc5d0\ub294 PostgreSQL \ud655\uc7a5\uc744 \ub9cc\ub4e4\ub824\uba74 C \uc5b8\uc5b4\ub85c \uc0c1\uc138\ud55c \uc778\ud130\ud398\uc774\uc2a4 \ucf54\ub4dc\ub97c \uc791\uc131\ud574\uc57c \ud588\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc gopgext\ub294 \/\/gopgext:function \uc8fc\uc11d\uc774 \ub2ec\ub9b0 Go \ud568\uc218\ub97c \uc790\ub3d9\uc73c\ub85c SQL \ud568\uc218\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. \ud544\uc694\ud55c C \uae00\ub8e8 \ucf54\ub4dc, \uc124\uce58 \uc2a4\ud06c\ub9bd\ud2b8, \uc81c\uc5b4 \ud30c\uc77c\uae4c\uc9c0 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud574\uc90d\ub2c8\ub2e4.<\/p>\n<p>\ud45c\uc900 \ub77c\uc774\ube0c\ub7ec\ub9ac \uc9c0\uc6d0 \ubc94\uc704\uac00 \ub113\ub2e4\ub294 \uc810\uc774 \ud2b9\uc9d5\uc785\ub2c8\ub2e4. fmt, regexp, encoding\/json, crypto \ud328\ud0a4\uc9c0 \ub4f1 Go\uc758 \uae30\ubcf8 \ubaa8\ub4c8\ub4e4\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. \ubb38\uc790\uc5f4, \uc22b\uc790, \ubc30\uc5f4, NULL \uac12, \ud0c0\uc784\uc2a4\ud0ec\ud504, UUID, JSON \ub4f1 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc774 SQL \ud0c0\uc785\uacfc \ub9e4\ud551\ub429\ub2c8\ub2e4.<\/p>\n<p>\ub2e8\uc21c \ud568\uc218 \uc815\uc758\ubfd0 \uc544\ub2c8\ub77c \ubcf5\uc7a1\ud55c DB \uae30\ub2a5\ub3c4 \uad6c\ud604 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ud2b8\ub9ac\uac70, \uc9d1\uacc4 \ud568\uc218, GiST, GIN, SP-GiST, BRIN \uc5f0\uc0b0\uc790 \ud074\ub798\uc2a4, \uc778\ub371\uc2a4 \uc811\uadfc \uba54\uc11c\ub4dc, \uc678\ubd80 \ub370\uc774\ud130 \ub798\ud37c, \ucffc\ub9ac \ud6c5 \ub4f1\uc744 \ubaa8\ub450 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. SPI\ub97c \ud1b5\ud574 \ub0b4\ubd80 SQL\uc744 \uc2e4\ud589\ud558\uace0 SQLSTATE \uc624\ub958 \ucf54\ub4dc\ub97c \ubc18\ud658\ud558\ub294 \uac83\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<p>PostgreSQL\uc758 \uacf5\uc2dd contrib \ubaa8\ub4c8 \ud3ec\ud305 \uc0ac\ub840\ub3c4 \ud655\uc778\ub418\uc5c8\uc2b5\ub2c8\ub2e4. pgcrypto, hstore, pg_stat_statements, cube \ub4f1\uc758 \ud655\uc7a5\uc774 \uc774 \ud504\ub808\uc784\uc6cc\ud06c\ub85c \uc7ac\uc791\uc131\ub418\uc5b4 \uc6d0\ubcf8\uc758 \ud68c\uadc0 \ud14c\uc2a4\ud2b8\ub97c \ud1b5\uacfc\ud588\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uae30\uc874 C \uae30\ubc18 \ud655\uc7a5\uacfc\uc758 \ud638\ud658\uc131\uc744 \uc785\uc99d\ud558\ub294 \uacb0\uacfc\uc785\ub2c8\ub2e4.<\/p>\n<p>\uba54\ubaa8\ub9ac \uc548\uc804\uc131 \uce21\uba74\uc5d0\uc11c\ub3c4 \uc124\uacc4\uac00 \uc774\ub8e8\uc5b4\uc84c\uc2b5\ub2c8\ub2e4. PostgreSQL \uc5d0\ub7ec\uac00 Go \uc2a4\ud0dd \ud504\ub808\uc784\uc744 \ud1b5\ud574 \ud480\ub824\ub098\uac00\uc9c0 \uc54a\ub3c4\ub85d \ucc98\ub9ac\ud558\uba70, \uacb0\uacfc\ub294 PostgreSQL \uba54\ubaa8\ub9ac\ub85c \ubcf5\uc0ac\ub429\ub2c8\ub2e4. \ud558\ub098\uc758 \ubc31\uc5d4\ub4dc\uc5d0\uc11c \uc5ec\ub7ec Go \ud655\uc7a5\uc744 \ub3d9\uc2dc\uc5d0 \ub85c\ub4dc\ud558\ub294 \uac83\ub3c4 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<p>Hacker News \ucee4\ubba4\ub2c8\ud2f0\uc5d0\uc11c\ub294 \uc774 \ud504\ub85c\uc81d\ud2b8\uc5d0 \ub300\ud574 \uc57d 155\uc810\uc758 \uc810\uc218\uc640 25\uac1c\uc758 \ub313\uae00\uc774 \ub2ec\ub9ac\uba70 \uad00\uc2ec\uc744 \ubcf4\uc600\uc2b5\ub2c8\ub2e4. \uc77c\ubd80 \uc0ac\uc6a9\uc790\ub4e4\uc740 Go\uac00 \ud50c\ub7ab\ud3fc \uc218\uc900\uc758 \uc791\uc5c5\uc5d0\ub294 \uac15\uc810\uc774 \uc788\uc9c0\ub9cc, \ub370\uc774\ud130 \ud3c9\uba74\uc778 DB \ud655\uc7a5\uc5d0\ub294 \uc801\ud569\uc131\uc774 \ubd88\ud655\uc2e4\ud558\ub2e4\ub294 \uc758\uacac\uc744 \ub0b4\uae30\ub3c4 \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>gopgext\ub294 MIT \ub77c\uc774\uc120\uc2a4\ub85c \uacf5\uac1c\ub418\uc5c8\uc73c\uba70, \ud3ec\ud305\ub41c contrib \ubaa8\ub4c8\uc740 PostgreSQL \ub77c\uc774\uc120\uc2a4\ub97c \uc720\uc9c0\ud569\ub2c8\ub2e4. \ub9c8\uc2a4\ucf54\ud2b8\ub294 Ren\u00e9e French\uc758 Go \uace0\ub798\uc640 PostgreSQL \ucf54\ub07c\ub9ac\ub97c \uacb0\ud569\ud55c \ub514\uc790\uc778\uc73c\ub85c \uc81c\uc791\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uac1c\ubc1c\uc790 jespino\uac00 TinyGo\ub97c \ud65c\uc6a9\ud574 Go \ucf54\ub4dc\ub85c PostgreSQL \ud655\uc7a5\uc744 \ub9cc\ub4dc\ub294 \ud504\ub808\uc784\uc6cc\ud06c gopgext\ub97c \uacf5\uac1c\ud588\uc2b5\ub2c8\ub2e4. C \ucf54\ub4dc \uc791\uc131 \uc5c6\uc774 SQL \ud568\uc218\uc640 \uc778\ub371\uc2a4 \uc811\uadfc \uba54\uc11c\ub4dc\ub97c \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":4,"featured_media":49834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jore2_quality_policy":"people-first-v2","footnotes":""},"categories":[387],"tags":[33146,10969,24126,33145,16474,210],"class_list":["post-49835","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it","tag-gopgext","tag-go","tag-postgresql","tag-tinygo","tag-16474","tag-210"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1.png",1200,630,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1-300x158.png",300,158,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1-768x403.png",640,336,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1-1024x538.png",640,336,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1.png",1200,630,false],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1.png",1200,630,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/11\/social-1-590x410.png",590,410,true]},"author_info":{"info":["\uc774\uac00\uc740"]},"category_info":"<a href=\"https:\/\/jore2.com\/?cat=387\" rel=\"category\">IT&amp;\uc0dd\ud65c\uafc0\ud301<\/a>","tag_info":"IT&amp;\uc0dd\ud65c\uafc0\ud301","comment_count":"0","_links":{"self":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/49835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=49835"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/49835\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/49834"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=49835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=49835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=49835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}