Topics tagged sql

Topic	Replies	Views	Activity
mysql using RMariaDB connects in R Script but not in preview mode for SQL Script RStudio IDE rstudio , sql , mysql , rstudio-preview , rmariadb	2	1396	June 6, 2022
error in odbc after upgrading to R 4.2.0 General odbc , sql , upgrade-r	1	2193	June 21, 2022
Get SQL code from SQL chunk with variables evaluated Publishing Your Results rmarkdown , knitr , sql	11	3848	May 24, 2022
Exporting tables from shiny using dbwritetable shinyapps.io shiny , dbi , sql , tbl , rmariadb	0	1392	May 18, 2022
Error in translate_sql_ General dbplyr , sql	1	872	May 18, 2022
character encoding for SQL query incorrect in RStudio Cloud but same Rmd and credentials work correctly in local RStudio Posit Cloud encoding , sql , rmariadb	1	1010	May 3, 2022
Accented characters in an SQL query General sql	1	883	April 19, 2022
Shiny apps and large tables Shiny odbc , sql , datatable	1	2663	May 22, 2022
Apply R script over chunks or batches taken from an SQL database General dplyr , production , sql , chunked	2	1369	April 6, 2022
data table is hidden in SQL server General rstudio , odbc , sql	1	1006	March 30, 2022
dbSendQuery (ROracle): define, set, alter session result in console errors General sql , roracle	3	1274	March 9, 2022
Add in SQL query designer General addins , sql	2	1146	March 3, 2022
Converting Nested Queries into Individual Queries General sql	2	1016	March 2, 2022
unable to create table for sql database using dbsebdquery General rstudio , dbi , sql , rodbc	1	1290	January 25, 2022
Using sqldf() in R to create a df that fulfills a count distinct condition? General sql	2	2528	October 7, 2021
Using sqldf to Delete Values from A dataset General sql	8	2087	October 6, 2021
Creating a list of S4 objects General database , driver , sql , rjdbc , s4	5	4899	August 18, 2021
Using reactive values in markdown file Shiny rmarkdown , shiny , rstudio , sql , rodbc	2	2184	August 30, 2021
Error when running R in store proc sql Server General rstudio , sql	1	693	July 28, 2021
Pass input$dates[1] into a .sql script used in shiny app General shiny , sql	2	1321	June 20, 2021
Error in SQL connection from RStudio server in debian - Server not found in Kerberos database General rstudio , odbc , rstudio-server , sql , rodbc	1	1455	June 22, 2021
Refering to a local table with SQL General rstudio , sql	1	874	May 5, 2021
Connection DB with Shiny Shiny dplyr , shiny , rstudio , shinyappsio , sql	4	2182	May 21, 2021
Expressions with cat and paste to go through an SQL request Shiny shiny , sql	6	1374	April 20, 2021
Connecting to SQL database in RStudio Server - SQLAllocHandle error General odbc , rstudio-server , sql	1	1085	March 3, 2021
Change the default SQL preview magic comment RStudio IDE sql	4	1296	February 12, 2021
Split-Apply-Combine (Divide and conquer) in a remote tibble or dbplyr class General purrr , dbplyr , tibble , sql , map	1	930	February 23, 2021
Converting oracle table(R) to dataframe IN R (Shiny) . Error when reading data columns Shiny shiny , sql	1	808	March 10, 2021
R + SQL: Performing and optimizing queries + using indexing General dbplyr , sql , datatable	8	3267	January 28, 2021
Execute SQL Stored Procedures from R General sql	4	4616	December 30, 2020