{"id":15224,"date":"2026-04-24T01:27:31","date_gmt":"2026-04-23T16:27:31","guid":{"rendered":"https:\/\/jore2.com\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite\/"},"modified":"2026-04-24T01:27:31","modified_gmt":"2026-04-23T16:27:31","slug":"community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=15224","title":{"rendered":"SQLite \uc5d0 \uc2e4\uc2dc\uac04 \uc774\ubca4\ud2b8\uc758 \ub9c8\ubc95\uc744 \ub354\ud558\ub2e4, \uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uc81d\ud2b8 ‘Honker’\uc758 \ub4f1\uc7a5"},"content":{"rendered":"
\n

\ubc30\uc18c\ub77c<\/strong><\/p>\n<\/div>\n

\ucd5c\uadfc \uac1c\ubc1c\uc790\ub4e4 \uc0ac\uc774\uc5d0\uc11c SQLite \uc758 \ud55c\uacc4\ub97c \ub118\uc5b4\uc11c\ub294 \uc0c8\ub85c\uc6b4 \uc2dc\ub3c4 \ud558\ub098\uac00 \ud654\uc81c\ub97c \ubaa8\uc73c\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ubc14\ub85c ‘Honker’\ub77c\ub294 \uc774\ub984\uc758 \uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uc81d\ud2b8\uc785\ub2c8\ub2e4. \uc774 \ub3c4\uad6c\ub294 SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 PostgreSQL \uc758 NOTIFY\/LISTEN \uc2dc\ub9e8\ud2f1\uc744 \ucd94\uac00\ud558\uc5ec, \ubcc4\ub3c4\uc758 \uc11c\ubc84\ub098 \uba54\uc2dc\uc9c0 \ube0c\ub85c\ucee4 \uc5c6\uc774\ub3c4 \uc2e4\uc2dc\uac04 \uc774\ubca4\ud2b8 \ucc98\ub9ac\uac00 \uac00\ub2a5\ud558\ub3c4\ub85d \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \uae30\uc874\uc5d0 SQLite \ub294 \uc8fc\ub85c \ub2e8\uc21c\ud55c \uc800\uc7a5\uc18c\ub098 \ub85c\uceec \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ubc31\uc5d4\ub4dc\ub85c \uc4f0\uc600\uc9c0\ub9cc, Honker \ub294 \uc774\ub97c \uc2e4\uc2dc\uac04 \uc774\ubca4\ud2b8 \uae30\ubc18 \uc544\ud0a4\ud14d\ucc98\ub85c \ud655\uc7a5\ud560 \uc218 \uc788\ub294 \uac00\ub2a5\uc131\uc744 \uc81c\uc2dc\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774 \ud504\ub85c\uc81d\ud2b8\uac00 \uc8fc\ubaa9\ubc1b\ub294 \uc774\uc720\ub294 \ubc14\ub85c ‘\uac04\uacb0\ud568’\uacfc ‘\ud6a8\uc728\uc131’ \ub54c\ubb38\uc785\ub2c8\ub2e4. \ub9ce\uc740 \ud604\ub300 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \ud504\ub808\uc784\uc6cc\ud06c\uc640 SQLite, \uadf8\ub9ac\uace0 Litestream \uc744 \uc870\ud569\ud574 VPS \uc704\uc5d0\uc11c \uac00\ubccd\uac8c \uad6c\ub3d9\ub418\ub294 \ucd94\uc138\uc778\ub370, Honker \ub294 \uc774\ub7ec\ud55c \ud658\uacbd\uc5d0 \uc2e4\uc2dc\uac04 \ud478\uc2dc \uc54c\ub9bc \uae30\ub2a5\uc744 \uc790\uc5f0\uc2a4\ub7fd\uac8c \ud1b5\ud569\ud588\uc2b5\ub2c8\ub2e4. \ubcc4\ub3c4\uc758 \ub370\ubaac \ud504\ub85c\uc138\uc2a4\ub098 \uc678\ubd80 \ube0c\ub85c\ucee4\ub97c \ub3cc\ub9ac\uc9c0 \uc54a\uc544\ub3c4 \ub418\uba70, WAL \ud30c\uc77c\uc758 \uc0c1\ud0dc \ubcc0\ud654\ub97c \uac10\uc9c0\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ub2e8\uc77c \uc790\ub9ac \uc218 \ubc00\ub9ac\ucd08 \ub2e8\uc704\uc758 \ub0ae\uc740 \uc9c0\uc5f0 \uc2dc\uac04\uc744 \ub2ec\uc131\ud569\ub2c8\ub2e4. \uc774\ub294 \uae30\uc874\uc5d0 \uc8fc\uae30\uc801\uc73c\ub85c \ucffc\ub9ac\ub97c \ub3cc\ub9ac\uba70 \uc0c1\ud0dc\ub97c \ud655\uc778\ud558\ub358 \ubc29\uc2dd\uc5d0\uc11c \ubc97\uc5b4\ub098, \uc774\ubca4\ud2b8 \ubc1c\uc0dd \uc2dc \uc989\uc2dc \ubc18\uc751\ud558\ub294 \uad6c\uc870\ub85c \uc804\ud658\ub41c \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/p>\n

Honker \ub294 \ub2e8\uc21c\ud788 \uc54c\ub9bc \uae30\ub2a5\ub9cc \uc81c\uacf5\ud558\ub294 \uac83\uc744 \ub118\uc5b4, \uc601\uad6c\uc801\uc778 \uc791\uc5c5 \ud050, \uc7ac\uc2dc\ub3c4 \ubc0f \ub370\ub4dc \ub808\ud130 \ucc98\ub9ac, \uadf8\ub9ac\uace0 \uc774\ubca4\ud2b8 \uc2a4\ud2b8\ub9bc\uae4c\uc9c0 \ud3ec\uad04\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uae30\ub2a5\ub4e4\uc740 \ubaa8\ub450 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uc0ac\uc6a9\ud558\ub294 \uae30\uc874 .db \ud30c\uc77c \ub0b4\ubd80\uc758 \ud589\uc73c\ub85c \uc800\uc7a5\ub418\uba70, \ube44\uc988\ub2c8\uc2a4 \ub85c\uc9c1\uc758 \uc4f0\uae30 \uc791\uc5c5\uacfc \uc6d0\uc790\uc801\uc73c\ub85c \ucee4\ubc0b\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ud2b8\ub79c\uc7ad\uc158\uc774 \ub864\ubc31\ub418\uba74 \uc774\ubca4\ud2b8 \uae30\ub85d \ub610\ud55c \ud568\uaed8 \uc0ac\ub77c\uc9c0\ub294 \ud2b9\uc131 \ub355\ubd84\uc5d0 \ub370\uc774\ud130 \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\uae30\uac00 \ub9e4\uc6b0 \uc218\uc6d4\ud574\uc84c\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ubcc4\ub3c4\uc758 \uba54\uc2dc\uc9c0 \ud050 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130 \ubd88\uc77c\uce58 \ubb38\uc81c\ub97c \uadfc\ubcf8\uc801\uc73c\ub85c \ud574\uacb0\ud574 \uc8fc\ub294 \uac15\ub825\ud55c \uc7a5\uc810\uc73c\ub85c \uc791\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n

\ud765\ubbf8\ub85c\uc6b4 \uc810\uc740 \uc774 \ud504\ub85c\uc81d\ud2b8\uc758 \uc774\ub984\uacfc \ubc30\uacbd\uc785\ub2c8\ub2e4. \uac1c\ubc1c\uc790\ub294 \uae30\uc874\uc5d0 Oban, pg-boss, Sidekiq \ub4f1 \ub2e4\uc591\ud55c \uba54\uc2dc\uc9d5 \ud234\ub4e4\uc774 \ubaa8\ub450 \uc720\ucf8c\ud55c \uc774\ub984\uc744 \uac00\uc9c0\uace0 \uc788\ub2e4\ub294 \uc810\uc5d0 \ucc29\uc548\ud574, ‘Honker’\ub77c\ub294 \uc774\ub984\uacfc \uac70\uc704 \uc774\ubbf8\uc9c0\ub97c \ucc28\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uae30\uc220\uc801\uc778 \uc5c4\uc219\ud568\ubcf4\ub2e4\ub294 \uac1c\ubc1c \ubb38\ud654\uc758 \uc720\ucf8c\ud568\uacfc \uce5c\uadfc\ud568\uc744 \uac15\uc870\ud558\ub294 \ub3d9\uc2dc\uc5d0, \uc774 \ub3c4\uad6c\uac00 \uac70\ub300\ud55c \uba54\uc2dc\uc9c0 \ube0c\ub85c\ucee4\ub4e4\uacfc \uac19\uc740 \uae38\uc744 \uac77\ub418 \uac00\ubccd\uace0 \uc720\uc5f0\ud558\uac8c \uc791\ub3d9\ud558\uaca0\ub2e4\ub294 \uc758\uc9c0\ub97c \ub2f4\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud604\uc7ac \uc54c\ud30c \ub2e8\uacc4\uc758 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub85c \uacf5\uac1c\ub418\uc5b4 \uc788\uc9c0\ub9cc, \uc774\ubbf8 \uacbd\ub7c9\ud654\ub41c \uc544\ud0a4\ud14d\ucc98\ub97c \uc120\ud638\ud558\ub294 \uac1c\ubc1c \ucee4\ubba4\ub2c8\ud2f0\uc5d0\uc11c \ud070 \uad00\uc2ec\uc744 \ub04c\uba70 \ub2e4\uc591\ud55c \uc5b8\uc5b4 \ubc14\uc778\ub529\uc744 \ud1b5\ud55c \ud655\uc7a5\uc131\ub3c4 \uae30\ub300\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc55e\uc73c\ub85c SQLite \uae30\ubc18\uc758 \uacbd\ub7c9 \uc2dc\uc2a4\ud15c\uc774 \uc5b4\ub5bb\uac8c \uc2e4\uc2dc\uac04 \ucc98\ub9ac \ub2a5\ub825\uc744 \uac16\ucd94\uba70 \uc9c4\ud654\ud560\uc9c0 \uc9c0\ucf1c\ubcf4\ub294 \uac83\uc774 \ud765\ubbf8\ub85c\uc6b8 \uac83\uc785\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc11c\ubc84 \uc5c6\uc774\ub3c4 PostgreSQL \uc758 NOTIFY\/LISTEN \uae30\ub2a5\uc744 SQLite \uc5d0\uc11c \uad6c\ud604\ud574\ub0b8 ‘Honker’\uac00 \uac1c\ubc1c\uc790\ub4e4\uc758 \uc8fc\ubaa9\uc744 \ubc1b\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uacbd\ub7c9 \uc544\ud0a4\ud14d\ucc98\ub97c \uc120\ud638\ud558\ub294 \ud604\ub300 \uac1c\ubc1c \ud2b8\ub80c\ub4dc\uc640 \ub9de\ubb3c\ub824, \ubcf5\uc7a1\ud55c \uba54\uc2dc\uc9c0 \ube0c\ub85c\ucee4 \uc5c6\uc774\ub3c4 \uc2e4\uc2dc\uac04 \ud050\uc640 \ud37c\ube14\ub9ac\uc2dc-\uc11c\ube0c\uc2a4\ud06c\ub77c\uc774\ube0c \ud328\ud134\uc744 \uad6c\ud604\ud560 \uc218 \uc788\ub294 \uc0c8\ub85c\uc6b4 \uac00\ub2a5\uc131\uc774 \uc5f4\ub838\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":11,"featured_media":15223,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[406],"tags":[10240,10239,10242,10243,10241,210],"class_list":["post-15224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-406","tag-honker","tag-sqlite","tag-10242","tag-10243","tag-10241","tag-210"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite.png",1200,600,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite-300x150.png",300,150,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite-768x384.png",640,320,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite-1024x512.png",640,320,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite.png",1200,600,false],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite.png",1200,600,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/04\/community-6037-show-hn-honker-postgres-notify-listen-semantics-for-sqlite-590x410.png",590,410,true]},"author_info":{"info":["\ubc30\uc18c\ub77c"]},"category_info":"\uc694\uc998\ub728\ub294\uc18c\uc2dd<\/a>","tag_info":"\uc694\uc998\ub728\ub294\uc18c\uc2dd","comment_count":"0","_links":{"self":[{"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/15224","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15224"}],"version-history":[{"count":0,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/15224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/15223"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}