Groups
Conversations
All groups and messages
Send feedback to Google
Help
Sign in
Groups
sqldf
Conversations
About
sqldf
1–30 of 80
Discussion of sqldf, gsubfn, batchfiles, proto and other gg packages for R.
Mark all as read
Report abusive group
0 selected
최현희
,
Gabor Grothendieck
2
2/2/21
Failed to load extension & Error in !dbPreExists.
I am unable to reproduce in Windows. This works for me without error. library(sqldf) sqldf("
unread,
Failed to load extension & Error in !dbPreExists.
I am unable to reproduce in Windows. This works for me without error. library(sqldf) sqldf("
2/2/21
Gabor Grothendieck
9/2/20
nls2 0.3 on github
Version 0.3 of nls2 is on github and can be installed using: library(devtools) install_github("
unread,
nls2 0.3 on github
Version 0.3 of nls2 is on github and can be installed using: library(devtools) install_github("
9/2/20
Gabor Grothendieck
6/9/20
R 4.0.2
There is a serious bug in R itself that can cause R to crash when used with tcltk affecting R version
unread,
R 4.0.2
There is a serious bug in R itself that can cause R to crash when used with tcltk affecting R version
6/9/20
malcol...@gmail.com
,
Gabor Grothendieck
3
6/22/19
BUG? sqldf dataframe can not have periods in their name
Here is an example: > library(sqldf) Loading required package: gsubfn Loading required package:
unread,
BUG? sqldf dataframe can not have periods in their name
Here is an example: > library(sqldf) Loading required package: gsubfn Loading required package:
6/22/19
Gabor Grothendieck
10/24/18
Utilities to filter data when using sqldf
This stackoverflow post discusses some utilities that can usefully be used with the read.csv.sql and
unread,
Utilities to filter data when using sqldf
This stackoverflow post discusses some utilities that can usefully be used with the read.csv.sql and
10/24/18
Gabor Grothendieck
2
9/30/18
Ryacas
Mikkel Meyer Andersen has become the new Ryacas maintainer and the package is now back on CRAN. https
unread,
Ryacas
Mikkel Meyer Andersen has become the new Ryacas maintainer and the package is now back on CRAN. https
9/30/18
Gabor Grothendieck
,
febi...@gmail.com
3
4/16/18
sqldf 0.4-11
You will need to show a reproducible example that use the latest version of sqldf and RSQLite on CRAN
unread,
sqldf 0.4-11
You will need to show a reproducible example that use the latest version of sqldf and RSQLite on CRAN
4/16/18
Gabor Grothendieck
3/30/18
gsubfn 0.70
gsubfn version 0.7 was released to CRAN earlier this month and should now be on all mirrors. It's
unread,
gsubfn 0.70
gsubfn version 0.7 was released to CRAN earlier this month and should now be on all mirrors. It's
3/30/18
Dwaipayan Dasgupta
, …
ben.he...@gmail.com
3
8/25/17
Cannot pass NA to dbQuoteIdentifier()
On Thursday, June 22, 2017 at 2:31:14 PM UTC+2, Dwaipayan Dasgupta wrote: > Error: Cannot pass NA
unread,
Cannot pass NA to dbQuoteIdentifier()
On Thursday, June 22, 2017 at 2:31:14 PM UTC+2, Dwaipayan Dasgupta wrote: > Error: Cannot pass NA
8/25/17
francois...@gmail.com
,
Gabor Grothendieck
2
7/16/17
sqldf on data frame when RPostgreSQL is loaded
See FAQ 12 on the sqldf github page: https://github.com/ggrothendieck/sqldf#12-how-does-one-use-sqldf
unread,
sqldf on data frame when RPostgreSQL is loaded
See FAQ 12 on the sqldf github page: https://github.com/ggrothendieck/sqldf#12-how-does-one-use-sqldf
7/16/17
Gabor Grothendieck
,
tjcr...@gmail.com
3
6/23/17
RSQLite 2.0 breaks sqldf
Thank you so much!
unread,
RSQLite 2.0 breaks sqldf
Thank you so much!
6/23/17
Nicolino David Oppes
6/22/17
RSQLite 2.0 blocks sqldf()
HI, after installing RSQLite on Windows 10 I now can't execute and returns this message: Error in
unread,
RSQLite 2.0 blocks sqldf()
HI, after installing RSQLite on Windows 10 I now can't execute and returns this message: Error in
6/22/17
spka...@gmail.com
6/22/17
Help file examples fail with the new version of the RSQLite package
Every example from sqldf.Rd with a select statement fails when run with the new version of RSQLite (
unread,
Help file examples fail with the new version of the RSQLite package
Every example from sqldf.Rd with a select statement fails when run with the new version of RSQLite (
6/22/17
d.ma...@ya.ru
,
Gabor Grothendieck
2
5/2/17
Wildcard join and sqldf inconsistent
Please provide the code needed to generate the R data frames used so it can just be copied and pasted
unread,
Wildcard join and sqldf inconsistent
Please provide the code needed to generate the R data frames used so it can just be copied and pasted
5/2/17
Gabor Grothendieck
2
1/18/17
RSQLite 1.1-1 incompatibility
RSQLite 1.1-2 has been released. This version is supposed to be compatible with sqldf. On Friday,
unread,
RSQLite 1.1-1 incompatibility
RSQLite 1.1-2 has been released. This version is supposed to be compatible with sqldf. On Friday,
1/18/17
lastr...@gmail.com
,
Gabor Grothendieck
2
11/27/16
C stack usage is too close to the limit with sqldf
sqldf has no C code so it cannot be issuing this message. On Sun, Nov 27, 2016 at 6:06 PM, lsun@
unread,
C stack usage is too close to the limit with sqldf
sqldf has no C code so it cannot be issuing this message. On Sun, Nov 27, 2016 at 6:06 PM, lsun@
11/27/16
lsun at Edmunds
11/27/16
Sqldf runs into 'c stack usage too close to the limit' error
After load package RPostgreSQL package I am running into an issue with sqldf as follows- > sqldf(
unread,
Sqldf runs into 'c stack usage too close to the limit' error
After load package RPostgreSQL package I am running into an issue with sqldf as follows- > sqldf(
11/27/16
Fabio Eitelvein
, …
Gabor Grothendieck
8
6/9/16
Unused arguments error on .local() when loading from file.
You will need to post a reproducible example. It works for me. > cat("a,b\n1,2\n", file
unread,
Unused arguments error on .local() when loading from file.
You will need to post a reproducible example. It works for me. > cat("a,b\n1,2\n", file
6/9/16
Peter Gensler
,
Gabor Grothendieck
2
6/9/16
SQL Query Error
This seems to be a duplicate of a post on stackoverflow. The comments to the question provide the
unread,
SQL Query Error
This seems to be a duplicate of a post on stackoverflow. The comments to the question provide the
6/9/16
jaco...@sas.upenn.edu
,
Gabor Grothendieck
2
4/15/16
Memory loss
Perhaps you could try one of the other back ends that sqldf supports. read.csv.sql is not supported
unread,
Memory loss
Perhaps you could try one of the other back ends that sqldf supports. read.csv.sql is not supported
4/15/16
mohamme...@gmail.com
,
Gabor Grothendieck
2
3/22/16
Sqldf - Using sql server Inbuilt functions error
sqldf uses sqlite by default and can also use H2, MySQL and PostgreSQL backends. SQL Server is not
unread,
Sqldf - Using sql server Inbuilt functions error
sqldf uses sqlite by default and can also use H2, MySQL and PostgreSQL backends. SQL Server is not
3/22/16
Gabor Grothendieck
2/29/16
Inserting rows into a dataframe based on a vector that contains dates
There is an interesting problem on stackoverflow here: http://stackoverflow.com/questions/35614766/
unread,
Inserting rows into a dataframe based on a vector that contains dates
There is an interesting problem on stackoverflow here: http://stackoverflow.com/questions/35614766/
2/29/16
mbac
, …
Gabor Grothendieck
4
11/10/15
Error running the simplest commands
Please provide complete examples inlcuding inputs; however, I will take a guess that the problem is
unread,
Error running the simplest commands
Please provide complete examples inlcuding inputs; however, I will take a guess that the problem is
11/10/15
Stephen Mandel
, …
Gabor Grothendieck
4
11/10/15
sqldf and functions
On Tuesday, November 10, 2015 at 5:07:11 PM UTC-5, Catherine Smith wrote: Gabor, I haven't found
unread,
sqldf and functions
On Tuesday, November 10, 2015 at 5:07:11 PM UTC-5, Catherine Smith wrote: Gabor, I haven't found
11/10/15
Claus W
,
Gabor Grothendieck
4
11/5/15
package ‘gsubfn’ is not available (for R version 3.2.2)
That should not be necessary. gsubfn is on CRAN and is available for R-3.2.2. On Thursday, November 5
unread,
package ‘gsubfn’ is not available (for R version 3.2.2)
That should not be necessary. gsubfn is on CRAN and is available for R-3.2.2. On Thursday, November 5
11/5/15
varma.a...@gmail.com
,
Gabor Grothendieck
2
10/6/15
How to append an existing postgresql database table with a new data frame
> I wanted to append the existing postgresql table structure and data with a new data frame. How
unread,
How to append an existing postgresql database table with a new data frame
> I wanted to append the existing postgresql table structure and data with a new data frame. How
10/6/15
sch...@gmail.com
,
Gabor Grothendieck
2
9/16/15
SQLite mismatch between compiled version 3.8.10.2 and runtime version 3.8.11.1
This seems to be a problem with your configuration and RSQLite. (1) You could try to get help from
unread,
SQLite mismatch between compiled version 3.8.10.2 and runtime version 3.8.11.1
This seems to be a problem with your configuration and RSQLite. (1) You could try to get help from
9/16/15
Hannah Page
,
Gabor Grothendieck
2
9/15/15
Error in sqliteSendQuery - table already exists
The error message says that you are trying to create a table which already exists. You have a table
unread,
Error in sqliteSendQuery - table already exists
The error message says that you are trying to create a table which already exists. You have a table
9/15/15
letsana...@gmail.com
,
Gabor Grothendieck
2
8/13/15
Update statement is not working
I tried to use the update statment but it returns null on execution. The values in the dataset are
unread,
Update statement is not working
I tried to use the update statment but it returns null on execution. The values in the dataset are
8/13/15
hol...@thebutlerfirm.com
,
Gabor Grothendieck
2
6/20/15
gsubfn scoping
The default environment used by gsubfn to find variables is env = parent.frame(), ie the function
unread,
gsubfn scoping
The default environment used by gsubfn to find variables is env = parent.frame(), ie the function
6/20/15