RMariaDB | An R interface to MariaDB | Database library

Due to some of the CSS classes clashing between the {shiny} Bootstrap UI framework {shiny.semantic} Semantic UI, you'll experience some unexpected behaviour with some of the extension packages.

To write something similar using {shiny.semantic}, you can use dropdown_input and adding in a bit of JS. I can't find an easy way of auto selecting everything within the dropdown with a button, but to remove all options in one easy click I've added the "clearable" class.

Here's a method that is likely more efficient: the use of a temporary table instead of manually encoding the data as a string of (a,b,c),(a,b,c) data sets.

For the sake of complete-demonstration, I've modified the df_live data slightly so that we have one row with no change, one row with updated data, and one row that is new. This process also works unaltered with your original df_live, I just wanted to highlight the three modes.

Technically, though, the "no change" row does update the database, but it is not obvious. If the table has a "lastmodified" field that updates with the current timestamp when something in the row is updated, then you can see a little more of what is happening.

In fact, I'll add (just for demonstration) two fields: created and modified, which show when the row was first created and when the last update occurred. These are not required for normal UPSERTs.

This section should not be necessary, unless you don't have a primary key(s) on the table (in which case, add one).

I'll name the main table "mydata", and upload the db_live dataset into it. I believe (without extensive testing) that MariaDB requires UPSERTs to find the duplicate or conflict rows based on pre-existing keys. This means we'll need to set a (primary) key; I'll assume your table already has this (and show how I do it with manually-uploaded data).

1. head works:

I had to solve this changing from my Windows 10 local pc to an Ubuntu server. In Ubuntu the conection was a breeze. Run this before install.packages("RMariaDB"):

The usual way to escape single apostrophes on the MySQL side is to just double them up, i.e. use ''. So try this version:

As @r2evans wrote in the comment. Correct answer to this would be installing mariadb/mysql devel package. Unfortunately this does not solve this issue, when MariaDB is installed from MariaDB10.repo After some testing, this issue was solved after installing MariaDB5.5 from official repositories.

I unfortunately overlooked the fact that RMariaDB was not correctly installed on the R Server. The installation failed because no mysql client library was found on the server. By installing libmariadbclient-dev on the server and reinstalling the RMariaDB R-package, everything works fine now.

Thanks for giving more context with reactivePoll, I think I found the issue:

The problem here lies in the execution of reactivePoll. When you start the app, reactivePoll already starts executing, but no user is logged in yet. That means that auth$user does not exist yet (it is NULL) and the code in your checkFun and valueFun can't handle that. I've included a small example (use user = 1 and password = 1) to demonstrate that in principle it works. I made sure that I don't execute the code as long as auth$user is NULL:

BETWEEN expects dates in ascending order.

Try