{"id":5095,"date":"2025-02-13T17:36:41","date_gmt":"2025-02-13T08:36:41","guid":{"rendered":"https:\/\/secondlife.lol\/?p=5095"},"modified":"2025-02-13T17:36:42","modified_gmt":"2025-02-13T08:36:42","slug":"db-field-database-guide","status":"publish","type":"post","link":"https:\/\/secondlife.lol\/en\/db-field-database-guide\/","title":{"rendered":"Database Fields? You Can't Eat Them, Can You?! - A Beginner's Complete Guide to DB"},"content":{"rendered":"\n<p>\uc5ec\ub7ec\ubd84, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub77c\ub294 \ub2e8\uc5b4\ub97c \ub4e4\uc73c\uba74 \uc5b4\ub5a4 \uc0dd\uac01\uc774 \ub4dc\uc2dc\ub098\uc694? \ubcf5\uc7a1\ud558\uace0 \uc5b4\ub824\uc6b4 \uac1c\ub150\ucc98\ub7fc \ub290\uaef4\uc9c0\uc2dc\ub098\uc694? <\/p>\n\n\n\n<p>\uac71\uc815 \ub9c8\uc138\uc694! \uc624\ub298 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud544\ub4dc\ub77c\ub294 \uac1c\ub150\ubd80\ud130 \uc2dc\uc791\ud574\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ub150, \ud544\uc694\uc131, \uadf8\ub9ac\uace0 \uc911\uc694\uc131\uae4c\uc9c0 \ubaa8\ub4e0 \uac83\uc744 \uc54c\uae30 \uc27d\uac8c \uc124\uba85\ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uac8c\ub2e4\uac00 <a href=\"http:\/\/python.org\" target=\"_blank\" rel=\"noopener\">\ud30c\uc774\uc36c<\/a>\uc744 \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e4\ub8e8\ub294 \ubc29\ubc95\uae4c\uc9c0 \ubc30\uc6cc\ubcfc \uac70\uc608\uc694. \uc774 \ud3ec\uc2a4\ud2b8\ub97c \ub2e4 \uc77d\uace0 \ub098\uba74, \uc5ec\ub7ec\ubd84\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\ubb38\uac00\uac00 \ub420 \uc218 \uc788\ub2f5\ub2c8\ub2e4!<\/p>\n\n\n<style>.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap{padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-right:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);padding-left:var(--global-kb-spacing-sm, 1.5rem);border-top:3px solid var(--global-palette2, #2B6CB0);border-right:3px solid var(--global-palette2, #2B6CB0);border-bottom:3px solid var(--global-palette2, #2B6CB0);border-left:3px solid var(--global-palette2, #2B6CB0);border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:0px 0px 14px 0px rgba(0, 0, 0, 0.2);}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title-wrap{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title-wrap{color:var(--global-palette2, #2B6CB0);}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title{color:var(--global-palette2, #2B6CB0);font-size:28px;font-weight:regular;font-style:normal;}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap .kb-table-of-content-list{color:var(--global-palette1, #3182CE);line-height:2em;font-weight:regular;font-style:normal;margin-top:var(--global-kb-spacing-sm, 1.5rem);margin-right:0px;margin-bottom:0px;margin-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap .kb-table-of-content-list .kb-table-of-contents__entry:hover{color:var(--global-palette6, #718096);}@media all and (max-width: 1024px){.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap{border-top:3px solid var(--global-palette2, #2B6CB0);border-right:3px solid var(--global-palette2, #2B6CB0);border-bottom:3px solid var(--global-palette2, #2B6CB0);border-left:3px solid var(--global-palette2, #2B6CB0);}}@media all and (max-width: 1024px){.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title{font-size:28px;}}@media all and (max-width: 767px){.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap{border-top:3px solid var(--global-palette2, #2B6CB0);border-right:3px solid var(--global-palette2, #2B6CB0);border-bottom:3px solid var(--global-palette2, #2B6CB0);border-left:3px solid var(--global-palette2, #2B6CB0);}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title{font-size:28px;}}<\/style>\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub780 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/h2>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc6b0\ub9ac \uc77c\uc0c1 \uacf3\uacf3\uc5d0 \uc228\uc5b4\uc788\uc5b4\uc694. <\/p>\n\n\n\n<p>\uc5ec\ub7ec\ubd84\uc774 \uc88b\uc544\ud558\ub294 \uc628\ub77c\uc778 \uc1fc\ud551\ubab0\uc5d0\uc11c \uc0c1\ud488\uc744 \uac80\uc0c9\ud560 \ub54c, \uc18c\uc15c \ubbf8\ub514\uc5b4\uc5d0\uc11c \uce5c\uad6c\uc758 \uac8c\uc2dc\ubb3c\uc744 \ubcfc \ub54c, \uc2ec\uc9c0\uc5b4 \uc2a4\ub9c8\ud2b8\ud3f0\uc73c\ub85c \ub0a0\uc528\ub97c \ud655\uc778\ud560 \ub54c\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uac04\ub2e8\ud788 \ub9d0\ud574, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc815\ubcf4\ub97c \uccb4\uacc4\uc801\uc73c\ub85c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc2dc\uc2a4\ud15c\uc774\uc5d0\uc694.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud544\uc694\uc131<\/h3>\n\n\n\n<p>\uc6b0\ub9ac\uac00 \uc0b4\uace0 \uc788\ub294 \ub514\uc9c0\ud138 \uc2dc\ub300\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud544\uc694\uc131\uc740 \ub354\uc6b1 \ucee4\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc65c \uadf8\ub7f4\uae4c\uc694?<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uc815\ubcf4\uc758 \ud6a8\uc728\uc801 \uad00\ub9ac<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub300\ub7c9\uc758 \uc815\ubcf4\ub97c \uc27d\uac8c \uc800\uc7a5\ud558\uace0 \uac80\uc0c9\ud560 \uc218 \uc788\uc5b4\uc694.<\/li>\n\n\n\n<li><strong>\ub370\uc774\ud130 \uc77c\uad00\uc131 \uc720\uc9c0<\/strong>: \uc911\ubcf5\ub41c \ub370\uc774\ud130\ub97c \uc904\uc774\uace0 \uc815\ubcf4\uc758 \uc815\ud655\uc131\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ubcf4\uc548 \uac15\ud654<\/strong>: \uc911\uc694\ud55c \uc815\ubcf4\ub97c \uc548\uc804\ud558\uac8c \ubcf4\ud638\ud560 \uc218 \uc788\uc5b4\uc694.<\/li>\n\n\n\n<li><strong>\ub370\uc774\ud130 \uacf5\uc720 \uc6a9\uc774<\/strong>: \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uac19\uc740 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc911\uc694\uc131<\/h3>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc911\uc694\uc131\uc740 \ub450\ub9d0 \ud560 \ub098\uc704\uac00 \uc5c6\uc5b4\uc694. \ud604\ub300 \uc0ac\ud68c\uc758 \uadfc\uac04\uc774 \ub418\ub294 \uae30\uc220\uc774\uac70\ub4e0\uc694. \ube44\uc988\ub2c8\uc2a4 \uc758\uc0ac\uacb0\uc815, \uacfc\ud559 \uc5f0\uad6c, \uc815\ubd80 \uc815\ucc45 \uc218\ub9bd \ub4f1 \uac70\uc758 \ubaa8\ub4e0 \ubd84\uc57c\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc798 \ud65c\uc6a9\ud558\uba74 \ub354 \ub098\uc740 \uacb0\uc815\uc744 \ub0b4\ub9ac\uace0, \ud6a8\uc728\uc131\uc744 \ub192\uc774\uba70, \ud601\uc2e0\uc744 \uc774\ub8f0 \uc218 \uc788\ub2f5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc885\ub958<\/h2>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc885\ub958\ub294 \uc5ec\ub7ec\uac00\uc9c0\uac00 \uc788\uc5b4\uc694. \uac01\uac01\uc758 \ud2b9\uc9d5\uc744 \uac04\ub2e8\ud788 \uc0b4\ud3b4\ubcfc\uae4c\uc694?<\/p>\n\n\n<style>.kb-image5095_66c216-f1 .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image5095_66c216-f1 img.kb-img, .kb-image5095_66c216-f1 .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:0px 0px 14px 0px rgba(0, 0, 0, 0.2);}<\/style>\n<figure class=\"wp-block-kadence-image kb-image5095_66c216-f1 size-full\"><img decoding=\"async\" width=\"1154\" height=\"824\" src=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-121838_Chrome.jpg\" alt=\"\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc885\ub958 \uc124\uba85\uc774\ubbf8\uc9c0\" class=\"kb-img wp-image-5102\" srcset=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-121838_Chrome.jpg 1154w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-121838_Chrome-300x214.jpg 300w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-121838_Chrome-600x428.jpg 600w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-121838_Chrome-768x548.jpg 768w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-121838_Chrome-18x12.jpg 18w\" sizes=\"(max-width: 1154px) 100vw, 1154px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>: \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc720\ud615\uc73c\ub85c, \ub370\uc774\ud130\ub97c \ud14c\uc774\ube14 \ud615\ud0dc\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4.<br>\uc608: MySQL, PostgreSQL, Oracle<\/li>\n\n\n\n<li><strong>NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>: \ube44\uc815\ud615 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \ub370 \uc801\ud569\ud574\uc694.<br>\uc608: MongoDB, Cassandra<\/li>\n\n\n\n<li><strong>\ud074\ub77c\uc6b0\ub4dc \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>: \uc778\ud130\ub137\uc744 \ud1b5\ud574 \uc811\uadfc \uac00\ub2a5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4.<br>\uc608: Amazon RDS, Google Cloud SQL<\/li>\n\n\n\n<li><strong>\uceec\ub7fc\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>: \ub370\uc774\ud130\ub97c \uc5f4 \ub2e8\uc704\ub85c \uc800\uc7a5\ud558\uc5ec \ubd84\uc11d\uc5d0 \uc720\ub9ac\ud574\uc694.<br>\uc608: Google BigQuery, Apache Cassandra<\/li>\n\n\n\n<li><strong>\uc640\uc774\ub4dc \uceec\ub7fc \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>: \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\uc5b4\uc694.<br>\uc608: Apache HBase, Google Bigtable<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud544\ub4dc \uc774\ud574\ud558\uae30<\/h2>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud544\ub4dc\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc758 \uac01 \uc5f4\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. <\/p>\n\n\n<style>.kb-image5095_ed1651-70 .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image5095_ed1651-70 img.kb-img, .kb-image5095_ed1651-70 .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:0px 0px 14px 0px rgba(0, 0, 0, 0.2);}<\/style>\n<figure class=\"wp-block-kadence-image kb-image5095_ed1651-70 size-full\"><img decoding=\"async\" width=\"1034\" height=\"756\" src=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-122233_Chrome.jpg\" alt=\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud544\ub4dc \uc124\uba85\uc774\ubbf8\uc9c0\" class=\"kb-img wp-image-5101\" srcset=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-122233_Chrome.jpg 1034w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-122233_Chrome-300x219.jpg 300w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-122233_Chrome-600x439.jpg 600w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-122233_Chrome-768x562.jpg 768w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/Screenshot_20250213-122233_Chrome-16x12.jpg 16w\" sizes=\"(max-width: 1034px) 100vw, 1034px\" \/><\/figure>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, &#8216;\uc0ac\uc6a9\uc790&#8217; \ud14c\uc774\ube14\uc774 \uc788\ub2e4\uba74 &#8216;\uc774\ub984&#8217;, &#8216;\ub098\uc774&#8217;, &#8216;\uc774\uba54\uc77c&#8217; \ub4f1\uc774 \uac01\uac01\uc758 \ud544\ub4dc\uac00 \ub420 \uc218 \uc788\uc5b4\uc694. <\/p>\n\n\n\n<p>\ud544\ub4dc\ub294 \ub370\uc774\ud130\uc758 \uad6c\uc870\ub97c \uc815\uc758\ud558\uace0, \uac01 \ub370\uc774\ud130 \ud56d\ubaa9\uc758 \ud2b9\uc131\uc744 \ub098\ud0c0\ub0b4\ub294 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud30c\uc774\uc36c\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub2e4\ub8e8\uae30<\/h2>\n\n\n\n<p>\uc774\uc81c \ud30c\uc774\uc36c\uc744 \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 \ubc30\uc6cc\ubcfc\uae4c\uc694? SQLite\ub97c \uc608\ub85c \ub4e4\uc5b4 \uc124\uba85\ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code language-python\"><code>import sqlite3\n\n# \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\nconn = sqlite3.connect('my_database.db')\ncursor = conn.cursor()\n\n# \ud14c\uc774\ube14 \uc0dd\uc131\ncursor.execute('''CREATE TABLE IF NOT EXISTS users\n                  (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)''')\n\n# \ub370\uc774\ud130 \uc0bd\uc785\ncursor.execute(\"INSERT INTO users (name, age) VALUES (?, ?)\", (\"David\", 30))\nconn.commit()\n\n# \ub370\uc774\ud130 \uc870\ud68c\ncursor.execute(\"SELECT * FROM users\")\nusers = cursor.fetchall()\nfor user in users:\n    print(f\"ID: {user&#91;0]}, name: {user&#91;1]}, age: {user&#91;2]}\")\n\n# \uc5f0\uacb0 \uc885\ub8cc\nconn.close()<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\ucf54\ub4dc \ud574\uc124<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>import sqlite3<\/code>: SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \ubaa8\ub4c8\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>conn = sqlite3.connect('my_database.db')<\/code>: &#8216;my_database.db&#8217;\ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>cursor = conn.cursor()<\/code>: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \ucee4\uc11c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>cursor.execute(...)<\/code>: SQL \uba85\ub839\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 &#8216;users&#8217; \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>cursor.execute(\"INSERT INTO ...\")<\/code>: \ud14c\uc774\ube14\uc5d0 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>conn.commit()<\/code>: \ubcc0\uacbd\uc0ac\ud56d\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>cursor.execute(\"SELECT * FROM users\")<\/code>: \ubaa8\ub4e0 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>users = cursor.fetchall()<\/code>: \uc870\ud68c \uacb0\uacfc\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>for<\/code> \ub8e8\ud504\ub85c \uac01 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>conn.close()<\/code>: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc744 \uc885\ub8cc\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading5095_07bad1-d2, .wp-block-kadence-advancedheading.kt-adv-heading5095_07bad1-d2[data-kb-block=\"kb-adv-heading5095_07bad1-d2\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading5095_07bad1-d2 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading5095_07bad1-d2[data-kb-block=\"kb-adv-heading5095_07bad1-d2\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading5095_07bad1-d2 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading5095_07bad1-d2[data-kb-block=\"kb-adv-heading5095_07bad1-d2\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<h3 class=\"kt-adv-heading5095_07bad1-d2 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading5095_07bad1-d2\">\ud30c\uc774\uc36c \ucf54\ub4dc \uc138\ubd80 \uc124\uba85<\/h3>\n\n\n\n<p>\uc704 \ud30c\uc774\uc36c \ucf54\ub4dc\ub294 SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac04\ub2e8\ud55c \uc0ac\uc6a9\uc790 \uc815\ubcf4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc744 \uad6c\ud604\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ucf54\ub4dc\uc758 \ud750\ub984\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<p>\uba3c\uc800, sqlite3 \ubaa8\ub4c8\uc744 \uac00\uc838\uc640 SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc900\ube44\ub97c \ud569\ub2c8\ub2e4. \uadf8 \ub2e4\uc74c, &#8216;my_database.db&#8217;\ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud569\ub2c8\ub2e4. \uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc73c\uba74 \uc0c8\ub85c \uc0dd\uc131\ub418\uace0, \uc774\ubbf8 \uc874\uc7ac\ud55c\ub2e4\uba74 \uadf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc5f0\uacb0\uc774 \uc124\uc815\ub418\uba74, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \ucee4\uc11c \uac1d\uccb4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc774 \ucee4\uc11c\ub97c \ud1b5\ud574 SQL \uba85\ub839\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc73c\ub85c, &#8216;users&#8217;\ub77c\ub294 \uc774\ub984\uc758 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc774 \ud14c\uc774\ube14\uc740 id(\uc815\uc218\ud615, \uae30\ubcf8 \ud0a4), name(\ud14d\uc2a4\ud2b8), age(\uc815\uc218\ud615) \ud544\ub4dc\ub97c \uac00\uc9d1\ub2c8\ub2e4. &#8216;IF NOT EXISTS&#8217; \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc774 \uc774\ubbf8 \uc874\uc7ac\ud558\ub294 \uacbd\uc6b0 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud14c\uc774\ube14\uc774 \uc900\ube44\ub418\uba74, INSERT \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 &#8216;\ud64d\uae38\ub3d9&#8217;\uc774\ub77c\ub294 \uc774\ub984\uacfc 30\uc774\ub77c\ub294 \ub098\uc774\ub97c \uac00\uc9c4 \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uc0bd\uc785 \ud6c4\uc5d0\ub294 commit() \uba54\uc11c\ub4dc\ub97c \ud638\ucd9c\ud558\uc5ec \ubcc0\uacbd\uc0ac\ud56d\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc601\uad6c\uc801\uc73c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8 \ub2e4\uc74c, SELECT \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec users \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4. fetchall() \uba54\uc11c\ub4dc\ub85c \uc870\ud68c \uacb0\uacfc\ub97c \uac00\uc838\uc640 users \ubcc0\uc218\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, for \ub8e8\ud504\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc870\ud68c\ub41c \uac01 \uc0ac\uc6a9\uc790\uc758 \uc815\ubcf4\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4. \uac01 \uc0ac\uc6a9\uc790\uc758 ID, \uc774\ub984, \ub098\uc774\uac00 \ud654\uba74\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubaa8\ub4e0 \uc791\uc5c5\uc774 \uc644\ub8cc\ub418\uba74, close() \uba54\uc11c\ub4dc\ub97c \ud638\ucd9c\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc744 \uc885\ub8cc\ud569\ub2c8\ub2e4. \uc774\ub294 \ub9ac\uc18c\uc2a4\ub97c \ud574\uc81c\ud558\uace0 \ub370\uc774\ud130\uc758 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\ub294 \uc911\uc694\ud55c \ub2e8\uacc4\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \ucf54\ub4dc\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae30\ubcf8\uc801\uc778 CRUD \uc791\uc5c5 \uc911 Create(\uc0dd\uc131)\uc640 Read(\uc77d\uae30) \uc791\uc5c5\uc744 \uc218\ud589\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae30\ubcf8 \uac1c\ub150\uacfc \ud30c\uc774\uc36c\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc870\uc791 \ubc29\ubc95\uc744 \uc774\ud574\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<style>.wp-block-kadence-advancedheading.kt-adv-heading5095_152560-4b, .wp-block-kadence-advancedheading.kt-adv-heading5095_152560-4b[data-kb-block=\"kb-adv-heading5095_152560-4b\"]{font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading5095_152560-4b mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading5095_152560-4b[data-kb-block=\"kb-adv-heading5095_152560-4b\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading5095_152560-4b img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading5095_152560-4b[data-kb-block=\"kb-adv-heading5095_152560-4b\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<h2 class=\"kt-adv-heading5095_152560-4b wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading5095_152560-4b\">\ub9c8\ubb34\ub9ac\ud558\uae30<\/h2>\n\n\n\n<p>\uc774\ub807\uac8c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae30\ubcf8 \uac1c\ub150\ubd80\ud130 \ud30c\uc774\uc36c\uc744 \uc774\uc6a9\ud55c \uc2e4\uc81c \uc0ac\uc6a9\ubc95\uae4c\uc9c0 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc6b0\ub9ac \uc77c\uc0c1 \uacf3\uacf3\uc5d0\uc11c \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud558\uace0 \uc788\uc5b4\uc694. \uc774\uc81c \uc5ec\ub7ec\ubd84\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc138\uacc4\ub85c \ud55c \uac78\uc74c \ub354 \uac00\uae4c\uc774 \ub2e4\uac00\uac14\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uacc4\uc18d\ud574\uc11c \uacf5\ubd80\ud558\uace0 \uc2e4\uc2b5\ud574\ubcf4\uba74, \uace7 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\ubb38\uac00\uac00 \ub420 \uc218 \uc788\uc744 \uac70\uc608\uc694.<\/p>\n\n\n\n<p>\ucc38\uace0\ub85c, R\uc5b8\uc5b4\uc5d0\uc11c\ub3c4 \ud30c\uc774\uc36c\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e4\ub8e8\ub294\ub370\uc694. <a href=\"https:\/\/secondlife.lol\/excel-to-r-sqlite-data-analysis-guide\/\" data-type=\"post\" data-id=\"3476\">\uc5d1\uc140\uc5d0\uc11c R SQLite DB\ub85c: \ub370\uc774\ud130 \ubd84\uc11d\uc758 \uc0c8\ub85c\uc6b4 \uc9c0\ud3c9<\/a> \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uadf8 \ub0b4\uc6a9\uc744 \ud655\uc778\ud574 \ubcf4\uc138\uc694!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucd08\ubcf4\uc790\ub97c \uc704\ud55c \uc6a9\uc5b4 \ud574\uc124<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SQL<\/strong>: Structured Query Language\uc758 \uc57d\uc790\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\uace0 \uc870\uc791\ud558\ub294 \uc5b8\uc5b4\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ud14c\uc774\ube14<\/strong>: \ub370\uc774\ud130\ub97c \ud589\uacfc \uc5f4\ub85c \uad6c\uc131\ud55c \ud615\ud0dc\uc785\ub2c8\ub2e4. \uc5d1\uc140 \uc2dc\ud2b8\uc640 \ube44\uc2b7\ud558\ub2e4\uace0 \uc0dd\uac01\ud558\uc2dc\uba74 \ub3fc\uc694.<\/li>\n\n\n\n<li><strong>\ucffc\ub9ac<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc815\ubcf4\ub97c \uc694\uccad\ud558\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>CRUD<\/strong>: Create(\uc0dd\uc131), Read(\uc77d\uae30), Update(\uac31\uc2e0), Delete(\uc0ad\uc81c)\uc758 \uc57d\uc790\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae30\ubcf8 \uc791\uc5c5\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc778\ub371\uc2a4<\/strong>: \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ub192\uc774\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130 \uad6c\uc870\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n<style>.kb-image4457_249bea-0c.kb-image-is-ratio-size, .kb-image4457_249bea-0c .kb-image-is-ratio-size{max-width:300px;width:100%;}.wp-block-kadence-column > .kt-inside-inner-col > .kb-image4457_249bea-0c.kb-image-is-ratio-size, .wp-block-kadence-column > .kt-inside-inner-col > .kb-image4457_249bea-0c .kb-image-is-ratio-size{align-self:unset;}.kb-image4457_249bea-0c figure{max-width:300px;}.kb-image4457_249bea-0c .image-is-svg, .kb-image4457_249bea-0c .image-is-svg img{width:100%;}.kb-image4457_249bea-0c .kb-image-has-overlay:after{opacity:0.3;}<\/style>\n<div class=\"wp-block-kadence-image kb-image4457_249bea-0c\"><figure class=\"aligncenter size-medium\"><img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-300x300.webp\" alt=\"\ud14c\ub9ac \uc774\ubaa8\ud2f0\ucf58\" class=\"kb-img wp-image-4456\" srcset=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-300x300.webp 300w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-600x600.webp 600w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-150x150.webp 150w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-768x768.webp 768w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-12x12.webp 12w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding.webp 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><figcaption><strong>( \uc990\uac81\uac8c \ucf54\ub529\uc744 \ud569\uc2dc\ub2e4! )<\/strong><\/figcaption><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What do you think of when you hear the word database? Like a complicated and difficult concept...<\/p>","protected":false},"author":3,"featured_media":5108,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[3],"tags":[906,486,33],"class_list":["post-5095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python-coding","tag-db","tag-486","tag-33"],"taxonomy_info":{"category":[{"value":3,"label":"\ud30c\uc774\uc36c(Python)"}],"post_tag":[{"value":906,"label":"DB"},{"value":486,"label":"\ub370\uc774\ud130\ubca0\uc774\uc2a4"},{"value":33,"label":"\ud30c\uc774\uc36c"}]},"featured_image_src_large":["https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/02\/\ud30c\uc774\uc36c-\uc139\uc158-600x600.jpg",600,600,true],"author_info":{"display_name":"TERE","author_link":"https:\/\/secondlife.lol\/en\/author\/tere\/"},"comment_info":0,"category_info":[{"term_id":3,"name":"\ud30c\uc774\uc36c(Python)","slug":"python-coding","term_group":0,"term_taxonomy_id":3,"taxonomy":"category","description":"","parent":20,"count":116,"filter":"raw","cat_ID":3,"category_count":116,"category_description":"","cat_name":"\ud30c\uc774\uc36c(Python)","category_nicename":"python-coding","category_parent":20}],"tag_info":[{"term_id":906,"name":"DB","slug":"db","term_group":0,"term_taxonomy_id":906,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":486,"name":"\ub370\uc774\ud130\ubca0\uc774\uc2a4","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4","term_group":0,"term_taxonomy_id":486,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":33,"name":"\ud30c\uc774\uc36c","slug":"%ed%8c%8c%ec%9d%b4%ec%8d%ac","term_group":0,"term_taxonomy_id":33,"taxonomy":"post_tag","description":"","parent":0,"count":30,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/posts\/5095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/comments?post=5095"}],"version-history":[{"count":10,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/posts\/5095\/revisions"}],"predecessor-version":[{"id":5107,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/posts\/5095\/revisions\/5107"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/media\/5108"}],"wp:attachment":[{"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/media?parent=5095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/categories?post=5095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/secondlife.lol\/en\/wp-json\/wp\/v2\/tags?post=5095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}