{"id":1714,"date":"2012-07-14T04:31:00","date_gmt":"2012-07-13T19:31:00","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1714"},"modified":"2017-01-31T19:44:52","modified_gmt":"2017-01-31T10:44:52","slug":"%ec%95%88%eb%93%9c%eb%a1%9c%ec%9d%b4%eb%93%9candroid%ec%97%90%ec%84%9c-sqlite-%ec%bd%98%ec%86%94-%ec%82%ac%ec%9a%a9","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1714","title":{"rendered":"\uc548\ub4dc\ub85c\uc774\ub4dc(Android)\uc5d0\uc11c sqlite \ucf58\uc194 \uc0ac\uc6a9"},"content":{"rendered":"

\uc548\ub4dc\ub85c\uc774\ub4dc\uc5d0\uc11c \uae30\ubcf8\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 DB\ub294 sqlite\uc785\ub2c8\ub2e4. sqlite\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud558\ub098\uc758 \ud30c\uc77c \ub2e8\uc704\ub85c \ud558\uc5ec \uc5ec\ub7ec\uac1c\uc758 \ud14c\uc774\ube14\uc744 \ubb36\uc5b4 \uad00\ub9ac\ud569\ub2c8\ub2e4. sqlite\ub294 \ub85c\uceec DBMS\uc774\uba70 \uc774 \ud30c\uc77c \ud558\ub098\ub9cc \ubcf5\uc0ac\ud574\uc11c \ub2e4\ub978 \uacf3\uc5d0 \ubcf5\uc0ac\ud558\uba74 \uc544\ubb34\ub7f0 \ubb38\uc81c \uc5c6\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud3b8\uc758\uc131\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc5ec\uae30\uc11c \uc124\uba85\ud558\ub294 sqlite\uc758 \ubc84\uc804\uc740 3\uc774\uba70 \uc774 sqlite3\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 DBMS \ud30c\uc77c\uc744 \ubc14\uc774\ub108\ub9ac \ud615\ud0dc\ub85c \uc0b4\ud3b4\ubcf4\uba74 \ub2e4\uc74c \uc608\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790<\/p>\n

\ud30c\uc77c\uba85\uacfc \ud655\uc7a5\uc790\ub294 \uc758\ubbf8\uac00 \uc5c6\uace0 \uadf8 \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \ud1b5\ud574 sqlite\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc774\ub77c\ub294 \uac83\uc744 \uc778\uc2dd\ud569\ub2c8\ub2e4. \uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc5d0\uc11c \uc815\ubcf4\ub97c \uc0b4\ud3b4\ubcf4\uae30 \uc704\ud574\uc11c \uc548\ub4dc\ub85c\uc774\ub4dc\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 SDK\ub97c \ud1b5\ud574 sqlite3.exe \uc2e4\ud589\ud30c\uc77c\uc744 \uc774\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790<\/p>\n

\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4(map.mbtiles \ud30c\uc77c)\uc5d0 \uc815\uc758\ub41c \ud14c\uc774\ube14 \uc774\ub984\uc744 \ubcf4\uae30 \uc704\ud55c \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uadf8\ub9ac\uace0 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc2a4\ud0a4\ub9c8 \uc815\ubcf4\ub97c \ubcf4\uae30 \uc704\ud55c \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uc774\uc81c, \ud14c\uc774\ube14 \uba85\uacfc \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc2a4\ud0a4\ub9c8 \uc815\ubcf4\ub97c \ud30c\uc545\ud560 \uc218 \uc788\uc73c\ub2c8 SQL \ubb38\uc744 \ud1b5\ud574 \uc6d0\ud558\ub294 \uc815\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc548\ub4dc\ub85c\uc774\ub4dc\uc5d0\uc11c \uae30\ubcf8\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 DB\ub294 sqlite\uc785\ub2c8\ub2e4. sqlite\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud558\ub098\uc758 \ud30c\uc77c \ub2e8\uc704\ub85c \ud558\uc5ec \uc5ec\ub7ec\uac1c\uc758 \ud14c\uc774\ube14\uc744 \ubb36\uc5b4 \uad00\ub9ac\ud569\ub2c8\ub2e4. sqlite\ub294 \ub85c\uceec DBMS\uc774\uba70 \uc774 \ud30c\uc77c \ud558\ub098\ub9cc \ubcf5\uc0ac\ud574\uc11c \ub2e4\ub978 \uacf3\uc5d0 \ubcf5\uc0ac\ud558\uba74 \uc544\ubb34\ub7f0 \ubb38\uc81c \uc5c6\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud3b8\uc758\uc131\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc124\uba85\ud558\ub294 sqlite\uc758 \ubc84\uc804\uc740 3\uc774\uba70 \uc774 sqlite3\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 DBMS \ud30c\uc77c\uc744 \ubc14\uc774\ub108\ub9ac \ud615\ud0dc\ub85c \uc0b4\ud3b4\ubcf4\uba74 \ub2e4\uc74c \uc608\uc640 \uac19\uc2b5\ub2c8\ub2e4. \ud30c\uc77c\uba85\uacfc \ud655\uc7a5\uc790\ub294 \uc758\ubbf8\uac00 \uc5c6\uace0 \uadf8 \ud30c\uc77c\uc758 … <\/p>\n

\ub354 \ubcf4\uae30 “\uc548\ub4dc\ub85c\uc774\ub4dc(Android)\uc5d0\uc11c sqlite \ucf58\uc194 \uc0ac\uc6a9”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61,8],"tags":[],"class_list":["post-1714","post","type-post","status-publish","format-standard","hentry","category-android","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1714"}],"version-history":[{"count":5,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions"}],"predecessor-version":[{"id":3053,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions\/3053"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1714"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}