{"id":89763,"date":"2019-02-22T03:20:00","date_gmt":"2019-02-21T19:20:00","guid":{"rendered":"http:\/\/itteacheritfreelance.hk\/test\/wordpress\/?guid=a61ae4cc9963be927561b90f8926a2c3"},"modified":"2019-02-22T03:20:00","modified_gmt":"2019-02-21T19:20:00","slug":"why-you-should-use-sqlite-2","status":"publish","type":"post","link":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/2019\/02\/22\/why-you-should-use-sqlite-2\/","title":{"rendered":"Why you should use SQLite"},"content":{"rendered":"<p>Lift the hood on most any business application, and you\u2019ll reveal some way to store and use structured data. Whether it\u2019s a client-side app, an app with a web front-end, or an edge-device app, chances are it needs an embedded database of some kind.<\/p>\n<p>SQLite is an embeddable open source database, written in C and queryable with conventional SQL, that is designed to cover those use cases and more. SQLite is designed to be fast, portable, and reliable, whether you\u2019re storing only kilobytes of data or multi-gigabyte blobs.<\/p>\n<aside class=\"fakesidebar\"><strong>[ Discover <a href=\"https:\/\/www.infoworld.com\/article\/3306843\/bossies-2018-the-best-of-open-source-software-awards.html\">the Bossie Award winners: 2018\u2019s best open source software for enterprise<\/a> for software development, machine learning, cloud computing, and data storage and analytics. ]<\/strong><\/aside>\n<h2 class=\"toc\">Where you can use SQLite<\/h2>\n<p>One of SQLite\u2019s greatest advantages is that it can run nearly anywhere. SQLite has been ported to a wide variety of platforms: Windows, MacOS, Linux, iOS, Android, and more. Windows users in particular can use precompiled binaries for regular Win32, UWP, WinRT, and .Net. Whatever the deployment target is for your app, odds are there\u2019s an edition of SQLite available for it, or a way to port the C source code to that target.<\/p>\n<p class=\"jumpTag\"><a href=\"https:\/\/www.javaworld.com\/article\/3342621\/database\/why-you-should-use-sqlite.html#jump\">To read this article in full, please click here<\/a><\/p>\n<\/section>\n<\/article>\n<p>(Insider Story)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lift the hood on most any business application, and you&rsquo;ll reveal some way to store and use structured data. Whether it&rsquo;s a client-side app, an app with a web front-end, or an edge-device app, chances are it needs an embedded database of some kind.<\/p>\n<p>SQLite is an embeddable open source database, written in C and queryable with conventional SQL, that is designed to cover those use cases and more. SQLite is designed to be fast, portable, and reliable, whether you&rsquo;re storing only kilobytes of data or multi-gigabyte blobs.<\/p>\n<aside><strong>[ Discover <a href=\"https:\/\/www.infoworld.com\/article\/3306843\/bossies-2018-the-best-of-open-source-software-awards.html\">the Bossie Award winners: 2018&rsquo;s best open source software for enterprise<\/a> for software development, machine learning, cloud computing, and data storage and analytics. ]<\/strong><\/aside>\n<h2>Where you can use SQLite<\/h2>\n<p>One of SQLite&rsquo;s greatest advantages is that it can run nearly anywhere. SQLite has been ported to a wide variety of platforms: Windows, MacOS, Linux, iOS, Android, and more. Windows users in particular can use precompiled binaries for regular Win32, UWP, WinRT, and .Net. Whatever the deployment target is for your app, odds are there&rsquo;s an edition of SQLite available for it, or a way to port the C source code to that target.<\/p>\n<p><a href=\"https:\/\/www.javaworld.com\/article\/3342621\/database\/why-you-should-use-sqlite.html#jump\">To read this article in full, please click here<\/a><\/p>\n<p>(Insider Story) <a href=\"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/2019\/02\/22\/why-you-should-use-sqlite-2\/\">\u95b1\u8b80\u5168\u6587 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":168,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"slim_seo":[],"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[451,2,7],"tags":[398,402,397,414,413,410,409,407,408,406,399,400,394,318,558,560,555,561,566,553,554,586,585,563,562,183,567,524,10,401,396,403,412,411,395,405,404,457,454,319,316],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7prtj-nlN","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts\/89763"}],"collection":[{"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/users\/168"}],"replies":[{"embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/comments?post=89763"}],"version-history":[{"count":1,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts\/89763\/revisions"}],"predecessor-version":[{"id":89764,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts\/89763\/revisions\/89764"}],"wp:attachment":[{"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/media?parent=89763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/categories?post=89763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/tags?post=89763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}