RMariaDB

RMariaDB copied to clipboard

dbDataType might have an issue with integer64 class in data.frames

1

Hey there, i might have encountered a small issue with the evaluation of integer64 objects in data.frames to determine their SQL datatype. It seems everything works fine if integer64 objects...

jd4ds

Call of stored procedures gives `Commands out of sync` error

12

Hello everyone! I get error `Commands out of sync; you can't run this command now [2014]` after first call of Stored Procedure. You can find example of my code [here](https://github.com/rstudio/pool/issues/134#issue-1303654909)...

vanhry

db_append_table should not double escape already escaped quotes

4

Hey there, long awaited and now available, I was very happy about the possibility to insert data into MySQL databases via local file. However, I may have found a small...

jd4ds

Swap readr for data.table as creator of TSV

4

This closes #270.

jd4ds

dbGetQuery (dbFetch?) result has different data frame format than RMySQL

2

I am querying the number of rows in a table. If I print the resulting data frame in a console or print the results to the console in RStudio, everything...

GundryLab

Use string as default for unknown column type

1

PR for Issue https://github.com/r-dbi/RMariaDB/issues/259. Querying a JSON column on MySQL 8.0.26 returns a column of type 245, which is not handled by RMariaDB. This PR converts column of unknown type...

LeeMendelowitz

OP #100 by @ankane. It's a good idea, my current focus is on dbi3, happy to review a PR.

krlmlr

RMariaDB failed to connect to db

1

Hi I am using Rstudio on my MacBook, I connected MariaDB server by terminal and it connected well, but when i try to run a code below, it does not...

EllyJung

Lack of connectivity to MariaDB on a NAS

5

Hi Thanks for maintaining both DBI and RMariaDB! I have a problem connecting to a MariaDB on a Synology NAS. It doesn't work at all using `RMariaDB::MariaDB` and just unsatisfactory...

jay-sf

dbListFields error on table with JSON column

3

`DBI::dbListFields` does not work on a table that has a JSON column. I get an error message "Error: Unimplemented MAX_NO_FIELD_TYPES". I do not get the same error if I try...

LeeMendelowitz