Hello guys,
I have a big project for six month, i need a little help about technology
imbrication ...
1) Reflexion about System architecture
> a) I want to make script in python which control/launch R, R access
data with library "rdbi" and "RdbiPgSQL". I need this to realize simple
statistics. Do you think it's better to access data in DB with R or with
python in this case ?
> b) I want in near futur to create an another type of script wich
access data in DB with grass by R module "spgrass6" (wich interface R <-->
GRASS). I need this to make Spatial Analysis
So with my two type of script a) and b) , you think Rpy is a good choice to
manipulate data/query in R and R <-> GRASS ? Have you an experience in this
type of plateform/architecture?
*
2) I have problem with RPY and connexion with my DB :*
from rpy import *
import math
r.library("Rdbi")
r.library("RdbiPgSQL")
r.dbConnect(r.PgSQL(),host="localhost", dbname="simpop", user="postgres",
password="postgres")
*
I have this error message : *
Traceback (most recent call last):
File "simpop.py", line 7, in <module>
r.dbConnect(r.PgSQL(),host="localhost", dbname="simpop",
user="postgres", password="postgres")
rpy.RPy_RException: Error in dbConnect.default("PostgreSQL object", host =
"localhost", password = "postgres", :
Invalid database class
In R, with the same query, no error ...
*Thanks a lot for you advice/help !*
Sebastien, student paris7 diderot
------------------------------------------------------------------------------
_______________________________________________
rpy-list mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rpy-list
