{"id":1209,"date":"2014-12-17T16:34:50","date_gmt":"2014-12-17T16:34:50","guid":{"rendered":"https:\/\/ibex.tech\/visualcpp\/?p=1209"},"modified":"2022-02-17T06:24:03","modified_gmt":"2022-02-17T06:24:03","slug":"sqlite-general","status":"publish","type":"post","link":"https:\/\/ibex.tech\/visualcpp\/databases\/sqlite\/sqlite-general","title":{"rendered":".SQLite General"},"content":{"rendered":"<p>\n<span class=\"rangySelectionBoundary\" id=\"selectionBoundary_1418834259877_20981594524346292\" style=\"line-height: 0; display: none;\">\ufeff<\/span><a href=\"https:\/\/www.sqlite.org\/\">https:\/\/www.sqlite.org<\/a>\n<\/p>\n<p>\nSQLite&nbsp;doesn&#39;t require any installation on the client machine. &nbsp;It&nbsp;depends on the Visual C++ runtime, but you don&#39;t need to install it on the client machine. The system.data.sqlite download page contains several &quot;static&quot; packages that already contain the runtime.\n<\/p>\n<p>\nSQLite isn&#39;t a full SQL database, it uses a small set of datatypes and doesn&#39;t have all the same functionality. &nbsp;However it is very widely used, well supported, very powerful still and is able to handle large databases. If you are looking for a pure SQL environment it won&#39;t be for you, but if you want a pretty easy to implement and no installation requried on target machine database then its hard to beat with a bit of learning to work around some of its SQL limitations \/ differences.\n<\/p>\n<p>\nSQLite requires a 64bit&nbsp;exe if running on a 64bit machine, so your application will need to build as 32 bit and 64 bit and install accordingly on user machines.\n<\/p>\n<p>\nAll the &quot;static&quot; packages contain either native or mixed-mode assembly binaries linked statically to the appropriate version of the Visual C++ runtime. Typically, these packages are used in cases where customer machines may not have the necessary version of the Visual C++ runtime installed and it cannot be installed due to limited privileges.\n<\/p>\n<p>\nFor example, on my a machine running Windows 8.1 x64 you might go to Precompiled Statically-Linked Binaries for 64-bit Windows (.NET Framework 4.0) and downloaded sqlite-netFx40-static-binary-x64-2010-1.0.90.0.zip. This binary package contains all the binaries for the x64 version of the System.Data.SQLite 1.0.90.0 (3.8.2) package. The Visual C++ 2010 SP1 runtime for x64 is statically linked. The .NET Framework 4.0 is required.\n<\/p>\n<p>\nUnzip&nbsp;the package and run test.exe to make sure everything works. Zero installation required.\n<\/p>\n<p>\nSQLite is also available as a single C file (amalgamation), which you can directly compile into your application, if you use native C\/C++. It then works in any situation where your app can open a file. No additional DLLs nor installation required.\n<\/p>\n<p>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ufeffhttps:\/\/www.sqlite.org SQLite&nbsp;doesn&#39;t require any installation on the client machine. &nbsp;It&nbsp;depends on the Visual C++ runtime, but you don&#39;t need to install it on the client machine. The system.data.sqlite download page contains several &quot;static&quot; packages that already contain the runtime. SQLite isn&#39;t a full SQL database, it uses a small set of datatypes and doesn&#39;t have [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[104],"tags":[],"class_list":["post-1209","post","type-post","status-publish","format-standard","hentry","category-sqlite"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts\/1209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/comments?post=1209"}],"version-history":[{"count":5,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts\/1209\/revisions"}],"predecessor-version":[{"id":1345,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts\/1209\/revisions\/1345"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/media?parent=1209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/categories?post=1209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/tags?post=1209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}