R and filemaker pro DB

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

R and filemaker pro DB

Michael Bibo
I have been looking for a database application to use in conjunction with R (on
a Windows network).  When I approached my organization's IT department to ask
about using MySQL, they made a counter-offer of Filemaker Pro (v8).  It is not
specifically mentioned in 'R Data Import/Export', nor do searches of the
archives turn up much information.

Does anyone have any experience using Filemaker Pro with R?
Should package RODBC work with Filemaker, as it is odbc-compliant? (I will be
doing some trials anyway).
Any other relevant advice welcome.

Michael Bibo
Queensland Health
[hidden email]

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Reply | Threaded
Open this post in threaded view
|

Re: R and filemaker pro DB

Sean Davis



On 1/13/06 7:08 AM, "Michael Bibo" <[hidden email]> wrote:

> I have been looking for a database application to use in conjunction with R
> (on
> a Windows network).  When I approached my organization's IT department to ask
> about using MySQL, they made a counter-offer of Filemaker Pro (v8).  It is not
> specifically mentioned in 'R Data Import/Export', nor do searches of the
> archives turn up much information.
>
> Does anyone have any experience using Filemaker Pro with R?
> Should package RODBC work with Filemaker, as it is odbc-compliant? (I will be
> doing some trials anyway).
> Any other relevant advice welcome.

I have used Fmpro via RODBC a bit.  I also use MySQL and PostgreSQL quite a
bit with R.  For smaller datasets, Fmpro is probably fine, but for larger
datasets (more than a few thousand rows), fmpro is pretty slow compared to a
dedicated SQL server.  Also, there is a great deal of flexibility in
database design, tuning, backup, and "enterpriseness".  However, note that
SQL servers do not come with GUI front ends like fmpro, so if you are
building a database for "use" other than data management, fmpro is a good
quick solution.  So, I would do what you suggest you are going to do and set
up both MySQL or PostgreSQL and fmpro and see which better meets your needs.
They are quite different in many ways, though.

Sean

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html