{"id":607,"date":"2018-04-29T11:09:15","date_gmt":"2018-04-29T10:09:15","guid":{"rendered":"http:\/\/generic.wordpress.soton.ac.uk\/soparty\/?p=607"},"modified":"2018-05-04T14:43:34","modified_gmt":"2018-05-04T13:43:34","slug":"the-database-used-in-sosporty","status":"publish","type":"post","link":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/the-database-used-in-sosporty\/","title":{"rendered":"The database used in SoSporty"},"content":{"rendered":"<p style=\"text-align: justify;line-height: 18.0pt;background: white;vertical-align: baseline\"><strong><span style=\"font-family: 'Arial',sans-serif;color: #555555\">The database used in SoSporty <\/span><\/strong><\/p>\n<p style=\"text-align: justify;line-height: 18.0pt;background: white;vertical-align: baseline\"><span style=\"font-family: 'Arial',sans-serif;color: #555555\">There are many database systems to be used such as LevelDB and Couchbase Lite but they are compatible with android systems only. Since we are using both platforms and operating systems (android-IOS) for developing our application for the benefits and the convenience of our users. As our <strong>previous post<\/strong> mentioned. We will choose to produce and use SQLite as our database system since it is available in most mainstream programming languages. In addition, SQLite is included in both iPhone and Android operating systems. <\/span><\/p>\n<p style=\"text-align: justify;line-height: 18.0pt;background: white;vertical-align: baseline\"><span style=\"font-family: 'Arial',sans-serif;color: #555555\">SQLite has many additional advantages since it is an open-source C library for managing relational databases that can be stored both on disk and in memory. It supports transactions, full-text search, single-writer\/multiple-reader access, efficient range queries (useful when storing <b>geographical<\/b> data), and shared <b>caching<\/b> (across connections opened by a single thread to the same database).<\/span><\/p>\n<p style=\"text-align: justify;line-height: 18.0pt;background: white;vertical-align: baseline\"><span style=\"font-family: 'Arial',sans-serif;color: #555555\">\u00a0<\/span><\/p>\n<p style=\"text-align: justify;line-height: 18.0pt;background: white;vertical-align: baseline\"><span style=\"font-family: 'Arial',sans-serif;color: #555555\">you can create an SQLite database on one machine and then use it on another machine with an entirely different architecture by simply copying the corresponding file. It is believed that it is \u201cthe most widely deployed SQL database\u201d.<\/span><\/p>\n<p>our database diagram is introduced in another blogpost.<\/p>\n<p style=\"margin: 0cm;margin-bottom: .0001pt;text-align: justify;line-height: 18.0pt;background: white;vertical-align: baseline\"><span style=\"font-family: 'Arial',sans-serif;color: #555555\"><a href=\"https:\/\/www.developereconomics.com\/five-popular-databases-for-mobile\">https:\/\/www.developereconomics.com\/five-popular-databases-for-mobile<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The database used in SoSporty There are many database systems to be used such as LevelDB and Couchbase Lite but they are compatible with android systems only. Since we are using both platforms and operating systems (android-IOS) for developing our<\/p>\n","protected":false},"author":2947,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_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","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[19,56,72],"tags":[],"class_list":["post-607","post","type-post","status-publish","format-standard","hentry","category-work","category-technical","category-technical-research"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9It56-9N","_links":{"self":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/posts\/607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/users\/2947"}],"replies":[{"embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":2,"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/posts\/607\/revisions"}],"predecessor-version":[{"id":888,"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/posts\/607\/revisions\/888"}],"wp:attachment":[{"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/categories?post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/generic.wordpress.soton.ac.uk\/soparty\/wp-json\/wp\/v2\/tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}