{"id":365,"date":"2008-12-14T14:35:19","date_gmt":"2008-12-14T20:35:19","guid":{"rendered":"http:\/\/xmission.com\/blog\/?p=365"},"modified":"2008-12-14T14:36:31","modified_gmt":"2008-12-14T20:36:31","slug":"sqlite-firefox-plugin","status":"publish","type":"post","link":"https:\/\/xmission.com\/blog\/2008\/12\/14\/sqlite-firefox-plugin","title":{"rendered":"SQLite Firefox plugin"},"content":{"rendered":"<p>Over in XMission Research and Development we&#8217;ve been finding ouselves having a lot of conversations about overengineered databases. Sure, it&#8217;s nice to have fully relational databases and be able to store procedures and do subselects, but how often do developers <em>really<\/em> need these sorts of features?<\/p>\n<p><a href=\"http:\/\/www.sqlite.org\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"http:\/\/www.sqlite.org\/images\/SQLite.gif\" alt=\"\" width=\"327\" height=\"97\" \/><\/a><\/p>\n<p>Enter lightweight databases like <a href=\"http:\/\/www.sqlite.org\">SQLite<\/a>. As the home page says, it&#8217;s a self-contained, zero-configuration, transactional database engine. It&#8217;s great for rapid development, but many find that it&#8217;s a perfectly suitable solution for production as well, saving the user the overhead of a more complex solution like <a href=\"http:\/\/www.mysql.com\">MySQL<\/a>.<\/p>\n<p>While playing around a bit with SQLite this weekend, I discovered a handy tool that makes SQLite a breeze to work with. It&#8217;s by <a href=\"http:\/\/mrinalkant.blogspot.com\/\">Mrinal Kant<\/a> and it&#8217;s a nice little <a href=\"https:\/\/addons.mozilla.org\/en-US\/firefox\/addon\/5817\">Firefox plugin<\/a> that allows you to manage SQLite DBs much the same way one might use <a href=\"http:\/\/www.phpmyadmin.net\">phpMyAdmin<\/a> for MySQL databases.<\/p>\n<p>So go forth developers, and create and manage thy lightweight tables for great justice.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Over in XMission Research and Development we&#8217;ve been finding ouselves having a lot of conversations about overengineered databases. Sure, it&#8217;s nice to have fully relational databases and be able to store procedures and do subselects, but how often do developers really need these sorts of features? Enter lightweight databases like SQLite. As the home page [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[11,82,83],"class_list":["post-365","post","type-post","status-publish","format-standard","hentry","category-tips-helpful-information","tag-databases","tag-developers","tag-sql"],"_links":{"self":[{"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/posts\/365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/comments?post=365"}],"version-history":[{"count":2,"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":367,"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/posts\/365\/revisions\/367"}],"wp:attachment":[{"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xmission.com\/blog\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}