{"id":12882,"date":"2020-05-17T16:44:02","date_gmt":"2020-05-17T16:44:02","guid":{"rendered":"https:\/\/merikebi.warrenmyers.com\/?p=12882"},"modified":"2020-05-17T16:44:02","modified_gmt":"2020-05-17T16:44:02","slug":"for-an-expected-low-traffic-website-servicewhy-use-database-over-text-files-at-what-point-do-db-benefits-outrank-simplicity-of-files-is-sqlite-good-enough-vs-mysql-mariadb-or-postgre","status":"publish","type":"post","link":"https:\/\/merikebi.warrenmyers.com\/?p=12882","title":{"rendered":"For an expected low-traffic #website\/service\u2026why use #database over text files? At what point do #db benefits outrank simplicity of files? Is #sqlite good enough vs #mysql\/#mariadb or #postgresql\/#pgsql? #webservice #python #writingCodeAgain"},"content":{"rendered":"<blockquote class=\"twitter-tweet\">\n<p lang=\"en\" dir=\"ltr\">For an expected low-traffic <a href=\"https:\/\/twitter.com\/hashtag\/website?src=hash&amp;ref_src=twsrc%5Etfw\">#website<\/a>\/service\u2026why use <a href=\"https:\/\/twitter.com\/hashtag\/database?src=hash&amp;ref_src=twsrc%5Etfw\">#database<\/a> over text files?<\/p>\n<p>At what point do <a href=\"https:\/\/twitter.com\/hashtag\/db?src=hash&amp;ref_src=twsrc%5Etfw\">#db<\/a> benefits outrank simplicity of files?<\/p>\n<p>Is <a href=\"https:\/\/twitter.com\/hashtag\/sqlite?src=hash&amp;ref_src=twsrc%5Etfw\">#sqlite<\/a> good enough vs <a href=\"https:\/\/twitter.com\/hashtag\/mysql?src=hash&amp;ref_src=twsrc%5Etfw\">#mysql<\/a>\/<a href=\"https:\/\/twitter.com\/hashtag\/mariadb?src=hash&amp;ref_src=twsrc%5Etfw\">#mariadb<\/a> or <a href=\"https:\/\/twitter.com\/hashtag\/postgresql?src=hash&amp;ref_src=twsrc%5Etfw\">#postgresql<\/a>\/<a href=\"https:\/\/twitter.com\/hashtag\/pgsql?src=hash&amp;ref_src=twsrc%5Etfw\">#pgsql<\/a>?<a href=\"https:\/\/twitter.com\/hashtag\/webservice?src=hash&amp;ref_src=twsrc%5Etfw\">#webservice<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/python?src=hash&amp;ref_src=twsrc%5Etfw\">#python<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/writingCodeAgain?src=hash&amp;ref_src=twsrc%5Etfw\">#writingCodeAgain<\/a><\/p>\n<p>&mdash; Warren Myers ?? (@warrenmyers) <a href=\"https:\/\/twitter.com\/warrenmyers\/status\/1262058676757692417?ref_src=twsrc%5Etfw\">May 17, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><br \/>\n<br \/>\nfrom Twitter https:\/\/twitter.com\/warrenmyers<\/p>\n<p>May 17, 2020 at 12:33PM<br \/>\nvia <a href=\"https:\/\/ifttt.com\/?ref=da&#038;site=wordpress\">IFTTT<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For an expected low-traffic #website\/service\u2026why use #database over text files? At what point do #db benefits outrank simplicity of files? Is #sqlite good enough vs #mysql\/#mariadb or #postgresql\/#pgsql?#webservice #python #writingCodeAgain &mdash; Warren Myers ?? (@warrenmyers) May 17, 2020 from Twitter https:\/\/twitter.com\/warrenmyers May 17, 2020 at 12:33PM via IFTTT<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[792],"keyring_services":[],"class_list":["post-12882","post","type-post","status-publish","format-standard","hentry","category-blih","tag-twitter"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/12882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12882"}],"version-history":[{"count":1,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/12882\/revisions"}],"predecessor-version":[{"id":12883,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/12882\/revisions\/12883"}],"wp:attachment":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12882"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fkeyring_services&post=12882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}