{"id":242,"date":"2007-05-31T17:18:19","date_gmt":"2007-05-31T16:18:19","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/?p=242"},"modified":"2007-05-31T17:18:19","modified_gmt":"2007-05-31T16:18:19","slug":"sqlite-will-be-everywhere","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/242-sqlite-will-be-everywhere.html","title":{"rendered":"SQLite will be everywhere"},"content":{"rendered":"<p>One of the core components in Google&#8217;s new Gears API is <a href=\"http:\/\/www.sqlite.org\" target=\"_blank\">SQLite<\/a>, an open source database engine. I&#8217;ve been an enthusiast for SQLite for a while now &#8211; I first <a href=\"http:\/\/www.itwriting.com\/blog\/?postid=11\" target=\"_blank\">blogged about it<\/a> in 2003. I&#8217;ve also worked a little on SQLIte wrappers for Java and Delphi.<\/p>\n<p>It&#8217;s a superb embedded database engine and I&#8217;m pleased but not surprised to see it now picked up by Google. It&#8217;s part of PHP 5.x, and also used by Apple for Core Data and Spotlight search&nbsp;in OS X. Now it is part of Gears and I imagine will be widely deployed. Google is also apparently contributing to the project &#8211; Full Text Search has been mentioned here at Developer Day &#8211; though I&#8217;ve not&nbsp;yet&nbsp;looked at this in detail. Congratulations to the primary author D. Richard Hipp, truly a star of the open source world, and thanks to him for making SQLite &#8220;<a href=\"http:\/\/www.sqlite.org\/copyright.html\" target=\"_blank\">completely free and unencumbered by copyright<\/a>&#8220;.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"wlWriterSmartContent\" id=\"0767317B-992E-4b12-91E0-4F059A8CECA8:98e2d1e0-4b80-4c05-83fd-fea8c523768f\" contenteditable=\"false\" style=\"padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px\">Technorati tags: <a href=\"http:\/\/technorati.com\/tags\/sqlite\" rel=\"tag\">sqlite<\/a>, <a href=\"http:\/\/technorati.com\/tags\/open%20source\" rel=\"tag\">open source<\/a>, <a href=\"http:\/\/technorati.com\/tags\/google\" rel=\"tag\">google<\/a>, <a href=\"http:\/\/technorati.com\/tags\/developer%20day\" rel=\"tag\">developer day<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>One of the core components in Google&#8217;s new Gears API is SQLite, an open source database engine. I&#8217;ve been an enthusiast for SQLite for a while now &#8211; I first blogged about it in 2003. I&#8217;ve also worked a little on SQLIte wrappers for Java and Delphi. It&#8217;s a superb embedded database engine and I&#8217;m &hellip; <a href=\"https:\/\/www.itwriting.com\/blog\/242-sqlite-will-be-everywhere.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SQLite will be everywhere<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79,80],"tags":[],"class_list":["post-242","post","type-post","status-publish","format-standard","hentry","category-software","category-software-development"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=242"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/242\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}