{"id":175094,"date":"2019-11-11T19:00:00","date_gmt":"2019-11-11T11:00:00","guid":{"rendered":"http:\/\/itteacheritfreelance.hk\/test\/wordpress\/?guid=be7393c07752ceb4c0ff294c6387f937"},"modified":"2019-11-11T19:00:00","modified_gmt":"2019-11-11T11:00:00","slug":"how-to-choose-a-database-for-your-application","status":"publish","type":"post","link":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/2019\/11\/11\/how-to-choose-a-database-for-your-application\/","title":{"rendered":"How to choose a database for your application"},"content":{"rendered":"<article>\n<section class=\"page\">\n<p>Picking the \u201cright\u201d database can often be critical to the success of an application. Rather than taking the advice of vendors or using a database because you already happen to have it, it\u2019s useful to consider the fundamental purpose and requirements of the data store.<\/p>\n<p>These are the most important questions to ask when you are picking a database:<\/p>\n<ul>\n<li>How much data do you expect to store when the application is mature?<\/li>\n<li>How many users do you expect to handle simultaneously at peak load?<\/li>\n<li>What availability, scalability, latency, throughput, and data consistency does your application need?<\/li>\n<li>How often will your database schemas change?<\/li>\n<li>What is the geographic distribution of your user population?<\/li>\n<li>What is the natural \u201cshape\u201d of your data?<\/li>\n<li>Does your application need online transaction processing (OLTP), analytic queries (OLAP), or both?<\/li>\n<li>What ratio of reads to writes do you expect in production?<\/li>\n<li>Do you need geographic queries and\/or full-text queries?<\/li>\n<li>What are your preferred programming languages?<\/li>\n<li>Do you have a budget? If so, will it cover licenses and support contracts?<\/li>\n<li>Are there legal restrictions on your data storage?<\/li>\n<\/ul>\n<p>Let\u2019s expand on those questions and their implications.<\/p>\n<p class=\"jumpTag\"><a href=\"https:\/\/www.javaworld.com\/article\/3452894\/how-to-choose-a-database-for-your-application.html#jump\">To read this article in full, please click here<\/a><\/p>\n<\/section>\n<\/article>\n","protected":false},"excerpt":{"rendered":"<p>Picking the \u201cright\u201d database can often be critical to the success of an application. Rather than taking the advice of vendors or using a database because you already happen to have it, it\u2019s useful to consider the fundamental purpose and requirements&#8230; <a href=\"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/2019\/11\/11\/how-to-choose-a-database-for-your-application\/\">\u95b1\u8b80\u5168\u6587 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":135,"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-Jy6","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts\/175094"}],"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\/135"}],"replies":[{"embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/comments?post=175094"}],"version-history":[{"count":1,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts\/175094\/revisions"}],"predecessor-version":[{"id":175095,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/posts\/175094\/revisions\/175095"}],"wp:attachment":[{"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/media?parent=175094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/categories?post=175094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itteacheritfreelance.hk\/test\/wordpress\/wp-json\/wp\/v2\/tags?post=175094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}