Add the dependencies <\/p>\n
\r\n[dependencies]\r\nrusqlite = { version = "0.37.0", features = ["bundled"] }\r\n<\/pre>\nThe bundled<\/em> part will automatically compile and link an upto date SQLite, without this I got errors such as “LINK : fatal error LNK1181: cannot open input file ‘sqlite3.lib'”, obviously if you have everything installed for SQLite, then you might prefer the non-bundled dependency, so just replace this with.<\/p>\n\r\n[dependencies]\r\nrusqlite = "0.37.0"\r\n<\/pre>\nCreate a DB<\/strong><\/p>\nNow let’s create a database as a file and insert an initial row of data<\/p>\n
\r\nuse rusqlite::Connection;\r\n\r\nfn main() {\r\n let connection = Connection::open(".\/data.db3").unwrap();\r\n connection.execute("CREATE TABLE app (id INTEGER PRIMARY KEY, name TEXT NOT NULL", ()).unwrap();\r\n connection.execute("INSERT INTO app (id, name) VALUES (?, ?)", (1, "Hello")).unwrap();\r\n}\r\n<\/pre>\nWe could also do this in memory using the following<\/p>\n
\r\nlet connection = Connection::open_in_memory().unwrap();\r\n<\/pre>\nReading from our DB<\/strong><\/p>\nWe’ll create a simple structure representing the DB created above<\/p>\n
\r\n#[derive(Debug)]\r\nstruct App {\r\n id: i32,\r\n name: String,\r\n}\r\n<\/pre>\nNow to read into this we use the following<\/p>\n
\r\nlet mut statement = connection.prepare("SELECT * FROM app").unwrap();\r\nlet app_iter = statement.query_map([], |row| {\r\n Ok(App {\r\n id: row.get(0)?,\r\n name: row.get(1)?,\r\n })\r\n}).unwrap();\r\n\r\nfor app in app_iter {\r\n println!("{:?}", app.unwrap());\r\n}\r\n<\/pre>\nYou’ll also need the following use<\/em> clause<\/p>\n\r\nuse rusqlite::fallible_iterator::FallibleIterator;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Add the dependencies [dependencies] rusqlite = { version = "0.37.0", features = ["bundled"] } The bundled part will automatically compile and link an upto date SQLite, without this I got errors such as “LINK : fatal error LNK1181: cannot open input file ‘sqlite3.lib’”, obviously if you have everything installed for SQLite, then you might prefer […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[191,764],"tags":[],"class_list":["post-11969","post","type-post","status-publish","format-standard","hentry","category-rust","category-sqlite"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/11969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=11969"}],"version-history":[{"count":3,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/11969\/revisions"}],"predecessor-version":[{"id":11972,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/11969\/revisions\/11972"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=11969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=11969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=11969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}