{"id":8616,"date":"2024-03-14T08:26:58","date_gmt":"2024-03-14T08:26:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/"},"modified":"2025-08-03T07:22:59","modified_gmt":"2025-08-03T07:22:59","slug":"what-is-the-usage-of-sqlite-in-c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/","title":{"rendered":"SQLite C++ Tutorial: Usage Guide"},"content":{"rendered":"<p>To use SQLite in C++, one must utilize the SQLite C\/C++ API for database operations. Below is a simple example demonstrating how to use SQLite in C++.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-meta\">#<span class=\"hljs-keyword\">include<\/span> <span class=\"hljs-string\">&lt;sqlite3.h&gt;<\/span><\/span>\r\n<span class=\"hljs-meta\">#<span class=\"hljs-keyword\">include<\/span> <span class=\"hljs-string\">&lt;iostream&gt;<\/span><\/span>\r\n\r\n<span class=\"hljs-function\"><span class=\"hljs-type\">int<\/span> <span class=\"hljs-title\">main<\/span><span class=\"hljs-params\">()<\/span> <\/span>{\r\n    sqlite3 *db;\r\n    <span class=\"hljs-type\">char<\/span> *zErrMsg = <span class=\"hljs-number\">0<\/span>;\r\n    <span class=\"hljs-type\">int<\/span> rc;\r\n\r\n    rc = <span class=\"hljs-built_in\">sqlite3_open<\/span>(<span class=\"hljs-string\">\"test.db\"<\/span>, &amp;db);\r\n\r\n    <span class=\"hljs-keyword\">if<\/span>(rc) {\r\n        std::cerr &lt;&lt; <span class=\"hljs-string\">\"Can't open database: \"<\/span> &lt;&lt; <span class=\"hljs-built_in\">sqlite3_errmsg<\/span>(db) &lt;&lt; std::endl;\r\n        <span class=\"hljs-keyword\">return<\/span>(<span class=\"hljs-number\">0<\/span>);\r\n    } <span class=\"hljs-keyword\">else<\/span> {\r\n        std::cout &lt;&lt; <span class=\"hljs-string\">\"Opened database successfully\"<\/span> &lt;&lt; std::endl;\r\n    }\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u521b\u5efa\u8868<\/span>\r\n    <span class=\"hljs-type\">const<\/span> <span class=\"hljs-type\">char<\/span> *sql = <span class=\"hljs-string\">\"CREATE TABLE COMPANY(\"<\/span>\r\n                        <span class=\"hljs-string\">\"ID INT PRIMARY KEY     NOT NULL,\"<\/span>\r\n                        <span class=\"hljs-string\">\"NAME           TEXT    NOT NULL,\"<\/span>\r\n                        <span class=\"hljs-string\">\"AGE            INT     NOT NULL,\"<\/span>\r\n                        <span class=\"hljs-string\">\"ADDRESS        CHAR(50),\"<\/span>\r\n                        <span class=\"hljs-string\">\"SALARY         REAL );\"<\/span>;\r\n    \r\n    rc = <span class=\"hljs-built_in\">sqlite3_exec<\/span>(db, sql, <span class=\"hljs-number\">0<\/span>, <span class=\"hljs-number\">0<\/span>, &amp;zErrMsg);\r\n\r\n    <span class=\"hljs-keyword\">if<\/span>(rc != SQLITE_OK) {\r\n        std::cerr &lt;&lt; <span class=\"hljs-string\">\"SQL error: \"<\/span> &lt;&lt; zErrMsg &lt;&lt; std::endl;\r\n        <span class=\"hljs-built_in\">sqlite3_free<\/span>(zErrMsg);\r\n    } <span class=\"hljs-keyword\">else<\/span> {\r\n        std::cout &lt;&lt; <span class=\"hljs-string\">\"Table created successfully\"<\/span> &lt;&lt; std::endl;\r\n    }\r\n\r\n    <span class=\"hljs-built_in\">sqlite3_close<\/span>(db);\r\n    \r\n    <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-number\">0<\/span>;\r\n}\r\n<\/code><\/pre>\n<p>The example code above demonstrates how to use SQLite in C++ to create a database and a table named COMPANY. In real applications, you can use the SQLite API for more database operations such as inserting data, querying data, and so on. For further information, you can refer to the official SQLite documentation for usage of the SQLite C\/C++ API.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To use SQLite in C++, one must utilize the SQLite C\/C++ API for database operations. Below is a simple example demonstrating how to use SQLite in C++. #include &lt;sqlite3.h&gt; #include &lt;iostream&gt; int main() { sqlite3 *db; char *zErrMsg = 0; int rc; rc = sqlite3_open(&#8220;test.db&#8221;, &amp;db); if(rc) { std::cerr &lt;&lt; &#8220;Can&#8217;t open database: &#8221; &lt;&lt; [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[10647,381,11703,11701,11702],"class_list":["post-8616","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-c-database","tag-c-programming","tag-sqlite-api","tag-sqlite-c","tag-sqlite-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLite C++ Tutorial: Usage Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to use SQLite in C++ with the official API. Get code examples and step-by-step database operations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite C++ Tutorial: Usage Guide\" \/>\n<meta property=\"og:description\" content=\"Learn to use SQLite in C++ with the official API. Get code examples and step-by-step database operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T08:26:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T07:22:59+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"SQLite C++ Tutorial: Usage Guide\",\"datePublished\":\"2024-03-14T08:26:58+00:00\",\"dateModified\":\"2025-08-03T07:22:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\"},\"wordCount\":94,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"C++ database\",\"C++ Programming\",\"SQLite API\",\"SQLite C++\",\"SQLite tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\",\"name\":\"SQLite C++ Tutorial: Usage Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T08:26:58+00:00\",\"dateModified\":\"2025-08-03T07:22:59+00:00\",\"description\":\"Learn to use SQLite in C++ with the official API. Get code examples and step-by-step database operations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite C++ Tutorial: Usage Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQLite C++ Tutorial: Usage Guide - Blog - Silicon Cloud","description":"Learn to use SQLite in C++ with the official API. Get code examples and step-by-step database operations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/","og_locale":"en_US","og_type":"article","og_title":"SQLite C++ Tutorial: Usage Guide","og_description":"Learn to use SQLite in C++ with the official API. Get code examples and step-by-step database operations.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T08:26:58+00:00","article_modified_time":"2025-08-03T07:22:59+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"SQLite C++ Tutorial: Usage Guide","datePublished":"2024-03-14T08:26:58+00:00","dateModified":"2025-08-03T07:22:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/"},"wordCount":94,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["C++ database","C++ Programming","SQLite API","SQLite C++","SQLite tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/","name":"SQLite C++ Tutorial: Usage Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T08:26:58+00:00","dateModified":"2025-08-03T07:22:59+00:00","description":"Learn to use SQLite in C++ with the official API. Get code examples and step-by-step database operations.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-usage-of-sqlite-in-c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQLite C++ Tutorial: Usage Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=8616"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8616\/revisions"}],"predecessor-version":[{"id":153437,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8616\/revisions\/153437"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=8616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=8616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=8616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}