{"id":2105,"date":"2021-09-27T00:46:22","date_gmt":"2021-09-27T00:46:22","guid":{"rendered":"http:\/\/optimumsportsperformance.com\/blog\/?p=2105"},"modified":"2021-09-27T13:01:06","modified_gmt":"2021-09-27T13:01:06","slug":"tidyx-76-polling-database-for-multi-user-shiny-interactive-table","status":"publish","type":"post","link":"https:\/\/optimumsportsperformance.com\/blog\/tidyx-76-polling-database-for-multi-user-shiny-interactive-table\/","title":{"rendered":"TidyX 76: Polling databases for a multi-user interactive shiny table"},"content":{"rendered":"<p><strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/twitter.com\/ellis_hughes\">Ellis Hughes<\/a><\/span><\/strong> and I wrap up our SQL database\/shiny series by taking a question from one of our viewers.<\/p>\n<p>In <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/optimumsportsperformance.com\/blog\/tidyx-75-tables-in-shiny-that-can-write-back-to-the-database\/\">TidyX 75<\/a><\/span><\/strong>, we built a {shiny} app that allowed the user to update a table and save the results back to the database. One of the viewers asked if we could address the issue of multiple users editing the table simultaneously, ultimately canceling out the notes that they are both writing to the database. So, we have addressed this in our recent episode.<\/p>\n<p>To watch the screen cast, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.youtube.com\/watch?v=ElV705LtmDI\">CLICK HERE<\/a><\/span><\/strong>.<\/p>\n<p>To access the code, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/github.com\/thebioengineer\/TidyX\/tree\/master\/TidyTuesday_Explained\/076-Databases_with_Shiny_4\">CLICK HERE<\/a><\/span><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ellis Hughes and I wrap up our SQL database\/shiny series by taking a question from one of our viewers. In TidyX 75, we built a {shiny} app that allowed the user to update a table and save the results back to the database. One of the viewers asked if we could address the issue of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[],"class_list":["post-2105","post","type-post","status-publish","format-standard","hentry","category-tidyx-screen-cast"],"_links":{"self":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/comments?post=2105"}],"version-history":[{"count":4,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2105\/revisions"}],"predecessor-version":[{"id":2109,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2105\/revisions\/2109"}],"wp:attachment":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/media?parent=2105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/categories?post=2105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/tags?post=2105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}