{"id":21169,"date":"2026-05-10T22:22:34","date_gmt":"2026-05-10T13:22:34","guid":{"rendered":"https:\/\/jore2.com\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary\/"},"modified":"2026-05-10T22:24:01","modified_gmt":"2026-05-10T13:24:01","slug":"community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary","status":"publish","type":"post","link":"https:\/\/jore2.com\/?p=21169","title":{"rendered":"3GB \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c 10MB\ub85c \uc555\ucd95\ud55c \uae30\uc220\uc801 \ubc18\uc804: FST \uac00 \uac00\uc838\uc628 \ud6a8\uc728\uc131\uc758 \uc7ac\uc815\uc758"},"content":{"rendered":"
\n

\ubc15\uc11c\uc724<\/strong><\/p>\n<\/div>\n

\ucd5c\uadfc \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0\ub97c \uac15\ud0c0\ud55c \uac00\uc7a5 \ud765\ubbf8\ub85c\uc6b4 \uc18c\uc2dd\uc740 \uac70\ub300\ud55c 3GB \uc758 SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub2e8 10MB \uc758 FST \uc774\uc9c4 \ud30c\uc77c\ub85c \ub300\uccb4\ub41c \uc0ac\ub840\uc785\ub2c8\ub2e4. \ub2e8\uc21c\ud788 \ud30c\uc77c \ud06c\uae30\uac00 \uc904\uc5c8\ub2e4\ub294 \uc0ac\uc2e4\ub9cc\uc73c\ub85c\ub3c4 \ub180\ub78d\uc9c0\ub9cc, \uc774 \ubcc0\ud654\uac00 \uac00\uc838\uc628 300 \ubc30\uc5d0 \ub2ec\ud558\ub294 \uba54\ubaa8\ub9ac \uc808\uac10 \ud6a8\uacfc\ub294 \ub370\uc774\ud130 \ucc98\ub9ac \ubc29\uc2dd\uc5d0 \ub300\ud55c \uae30\uc874\uc758 \uc0c1\uc2dd\uc744 \ub4a4\uc9d1\ub294 \uacc4\uae30\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 \ud540\ub780\ub4dc\uc5b4\uc640 \uc601\uc5b4 \uc0ac\uc804\uc744 \uc704\ud55c \uac80\uc0c9 \uc5d4\uc9c4\uc778 Taskusanakirja \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uad6c\ud604\ub41c \uc774 \uae30\uc220\uc740, \ubcf5\uc7a1\ud55c \uc5b4\ubbf8 \ubcc0\ud654\uac00 \ub9ce\uc740 \uc5b8\uc5b4 \ud658\uacbd\uc5d0\uc11c\ub3c4 \uc989\uac01\uc801\uc778 \uc790\ub3d9 \uc644\uc131 \uac80\uc0c9\uc744 \uac00\ub2a5\ud558\uac8c \ud558\uba70 \uc131\ub2a5\uacfc \ud6a8\uc728\uc131\uc744 \ub3d9\uc2dc\uc5d0 \uc7a1\uc740 \ubaa8\ubc94 \uc0ac\ub840\ub85c \ud3c9\uac00\ubc1b\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774 \uae30\uc220\uc774 \uc8fc\ubaa9\ubc1b\ub294 \ud575\uc2ec \uc774\uc720\ub294 \ubd88\ud544\uc694\ud55c \uc624\ubc84\ud5e4\ub4dc\ub97c \uacfc\uac10\ud788 \uc81c\uac70\ud55c \ub370\uc774\ud130 \uad6c\uc870\uc758 \uc120\ud0dd\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uae30\uc874\uc5d0\ub294 \ubc94\uc6a9\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc778 SQLite \ub97c \uc0ac\uc6a9\ud558\uc5ec B-\ud2b8\ub9ac\uc640 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uae30\ub2a5\uc744 \uad6c\ud604\ud588\uc9c0\ub9cc, \uc774\ub294 \uc815\uc801\uc774\uace0 \ud2b9\uc218\ud654\ub41c \ub370\uc774\ud130\uc14b\uc5d0\ub294 \uacfc\ub3c4\ud55c \ub9ac\uc18c\uc2a4\ub97c \uc18c\ubaa8\ud558\ub294 \ubc29\uc2dd\uc774\uc5c8\uc2b5\ub2c8\ub2e4. \ub300\uc2e0 \ud2b8\ub77c\uc774 \uad6c\uc870\ub97c \uae30\ubc18\uc73c\ub85c \ud55c FST \ub97c \ub3c4\uc785\ud568\uc73c\ub85c\uc368, \ubd88\ud544\uc694\ud55c \uc911\ubcf5 \ub178\ub4dc\ub97c \uc81c\uac70\ud558\uace0 \uba54\ubaa8\ub9ac \uc0c1\uc5d0\uc11c \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \ud615\ud0dc\ub85c \ub370\uc774\ud130\ub97c \uc7ac\ubc30\uc5f4\ud588\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ub9c8\uce58 \ubb34\uac70\uc6b4 \uc7a5\ube44\ub97c \ub4e4\uace0 \ub2e4\ub2c8\ub358 \uc0ac\ub78c\uc774 \uac00\uc7a5 \ud544\uc694\ud55c \ub3c4\uad6c\ub9cc \ucc59\uaca8 \uac00\ubcbc\uc6b4 \ubc30\ub0ad\uc73c\ub85c \uc804\ud658\ud55c \uac83\uacfc \uac19\uc740 \uc804\ub7b5\uc801 \ud310\ub2e8\uc774\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

\ud765\ubbf8\ub85c\uc6b4 \uc810\uc740 \uc774 \ud601\uc2e0\uc774 \ud558\ub8e8\uc544\uce68\uc5d0 \uc774\ub8e8\uc5b4\uc9c4 \uac83\uc774 \uc544\ub2c8\ub77c, ‘\uc77c\ub2e8 \uc791\ub3d9\ud558\ub294 \uc26c\uc6b4 \ubc29\ubc95’\uc744 \uba3c\uc800 \uc120\ud0dd\ud55c \ud6c4 \uc810\uc9c4\uc801\uc73c\ub85c \ucd5c\uc801\ud654\ud574 \ub098\uac04 \uacfc\uc815\uc758 \uacb0\uacfc\ubb3c\uc774\ub77c\ub294 \uac83\uc785\ub2c8\ub2e4. \uac1c\ubc1c\uc790\ub294 \ucd08\uae30\uc5d0 SQLite \ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\uace0 \uac80\uc99d\ud55c \ub4a4, \uc131\ub2a5 \ubcd1\ubaa9\uc774 \uba85\ud655\ud574\uc9c0\uc790 \uc774\ub97c FST \ub85c \uad50\uccb4\ud558\ub294 \uacfc\uac10\ud55c \ub3c4\uc804\uc744 \uac10\ud589\ud588\uc2b5\ub2c8\ub2e4. \uc774 \uacfc\uc815\uc5d0\uc11c \uc0dd\uc131\ub41c \ucd5c\uc801\ud654 \ubc84\uc804\uc740 \uc6d0\ubcf8\uacfc \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294 \uacb0\uacfc\ub97c \ubcf4\uc7a5\ud558\uba74\uc11c\ub3c4, \uc2dc\uc2a4\ud15c\uc758 \ubd80\ud558\ub97c \ud68d\uae30\uc801\uc73c\ub85c \ub0ae\ucdc4\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ubcf5\uc7a1\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \ub54c \ubb34\uc870\uac74 \ucd5c\uc2e0 \uae30\uc220\uc744 \uc801\uc6a9\ud558\uae30\ubcf4\ub2e4, \ubb38\uc81c\uc758 \ubcf8\uc9c8\uc744 \ud30c\uc545\ud558\uace0 \uac00\uc7a5 \uc801\ud569\ud55c \ub3c4\uad6c\ub97c \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc5bc\ub9c8\ub098 \uc911\uc694\ud55c\uc9c0\ub97c \ubcf4\uc5ec\uc8fc\ub294 \uc0ac\ub840\uc785\ub2c8\ub2e4.<\/p>\n

\uc55e\uc73c\ub85c \uc774 \uae30\uc220\uc758 \uc601\ud5a5\ub825\uc740 \ud540\ub780\ub4dc\uc5b4\ub098 \ud130\ud0a4\uc5b4\ucc98\ub7fc \uc811\ubbf8\uc0ac\uac00 \ud48d\ubd80\ud55c \uc5b8\uc5b4\ub97c \ub118\uc5b4, \uc77c\ubcf8\uc5b4\uc640 \uac19\uc740 \ub2e4\uc591\ud55c \uc5b4\uc871\uc758 \uc0ac\uc804 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0\ub3c4 \ud655\uc7a5\ub420 \uac00\ub2a5\uc131\uc774 \ud07d\ub2c8\ub2e4. \ud2b9\ud788 \uc784\ubca0\ub514\ub4dc \uc2dc\uc2a4\ud15c\uc774\ub098 \ubaa8\ubc14\uc77c \ud658\uacbd\ucc98\ub7fc \uba54\ubaa8\ub9ac \uc81c\uc57d\uc774 \uc2ec\ud55c \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc815\uc801 \ub370\uc774\ud130\uc14b\uc744 \ub2e4\ub8f0 \ub54c FST \uc640 \uac19\uc740 \uc804\uc6a9 \uad6c\uc870\uc758 \ud65c\uc6a9\ub3c4\uac00 \ub192\uc544\uc9c8 \uac83\uc73c\ub85c \uc608\uc0c1\ub429\ub2c8\ub2e4. \ub2e8\uc21c\ud55c \uc6a9\ub7c9 \uac10\uc18c\ub97c \ub118\uc5b4, \ub370\uc774\ud130\uac00 \uc5b4\ub5bb\uac8c \uc800\uc7a5\ub418\uace0 \uc811\uadfc\ub418\ub294\uc9c0\uc5d0 \ub300\ud55c \uadfc\ubcf8\uc801\uc778 \uc0ac\uace0\uc758 \uc804\ud658\uc774 \ud544\uc694\ud55c \uc2dc\uc810\uc785\ub2c8\ub2e4. \uc774\uc81c \uac1c\ubc1c\uc790\ub4e4\uc740 \ub354 \uc774\uc0c1 \ubb34\uac70\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubb34\uc870\uac74 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc815\ub2f5\uc774\ub77c\uace0 \uc0dd\uac01\ud558\uc9c0 \uc54a\uc73c\uba70, \ub370\uc774\ud130\uc758 \ud2b9\uc131\uc5d0 \ub9de\ucdb0 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \uad6c\uc870\ub97c \uc124\uacc4\ud558\ub294 \uc0c8\ub85c\uc6b4 \ud328\ub7ec\ub2e4\uc784\uc744 \ud5a5\ud574 \ub098\uc544\uac00\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc218\uc2ed \ubc30\uc758 \uc800\uc7a5 \uacf5\uac04 \ucc28\uc774\ub97c \ub9cc\ub4e4\uc5b4\ub0b8 FST(\uc720\ud55c \uc0c1\ud0dc \uc804\uc774\uae30) \uae30\uc220\uc774 \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0\ub97c \ub728\uac81\uac8c \ub2ec\uad6c\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ubb34\uac70\uc6b4 SQLite \ub97c \ub300\uccb4\ud55c \uc774 \ud601\uc2e0\uc774 \uc65c \uc9c0\uae08 \uc8fc\ubaa9\ubc1b\ub294\uc9c0, \uadf8\ub9ac\uace0 \ub2e8\uc21c\ud55c \uc6a9\ub7c9 \uac10\uc18c\ub97c \ub118\uc5b4\uc120 \ub370\uc774\ud130 \uad6c\uc870\uc758 \ubcf8\uc9c8\uc801 \ubcc0\ud654\uac00 \ubb34\uc5c7\uc744 \uc758\ubbf8\ud558\ub294\uc9c0 \uc0b4\ud3b4\ubd05\ub2c8\ub2e4.<\/p>\n","protected":false},"author":6,"featured_media":21170,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[406],"tags":[16099,10239,16102,16103,11319,2632],"class_list":["post-21169","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-406","tag-fst","tag-sqlite","tag-16102","tag-16103","tag-11319","tag-2632"],"featured_image_urls":{"full":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary.png",1200,630,false],"thumbnail":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary-150x150.png",150,150,true],"medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary-300x158.png",300,158,true],"medium_large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary-768x403.png",640,336,true],"large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary-1024x538.png",640,336,true],"1536x1536":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary.png",1200,630,false],"2048x2048":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary.png",1200,630,false],"morenews-large":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary-825x575.png",825,575,true],"morenews-medium":["https:\/\/jore2.com\/wp-content\/uploads\/2026\/05\/community-8333-replacing-a-3-gb-sqlite-db-with-a-10-mb-fst-finite-state-transducer-binary-590x410.png",590,410,true]},"author_info":{"info":["\ubc15\uc11c\uc724"]},"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\/21169","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21169"}],"version-history":[{"count":1,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/21169\/revisions"}],"predecessor-version":[{"id":21171,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/posts\/21169\/revisions\/21171"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=\/wp\/v2\/media\/21170"}],"wp:attachment":[{"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jore2.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}