similar to: Which DBMS to use?

Hi R users, I am new to using DBMS with R for large datasets. Thanks to all who responded with useful suggestion to my earlier postings about using large datasets and DBMS with R. I am writing to get some help about how to design good tables in DBMS to take full advantage of the wonderful built-in facilities in R, like labels. I am using RMySQL client. Because R makes good use of variable

I'm using Samba to allow my users to store their database on a Redhat 6.1 file server. I've got some who want to shift to using Linux instead of Windows but the DBMS they use is not supported (yet... I'm told) on Linux and I'm afraid that multi-user access on different OS's are going to screw things all to high heck anyways... But that being said... Are there existing

<PRE>I am looking for suggestions for a good Database Management System to use with R. The main use of this will be to format, query and make subsets of large datafiles for use in R. I recall reading a comparative write-up either in the newsletter, in the mails or someone's webpage last summer, but cant seem to find it now. I will be thankful if someone can help in locating such

I am seeking to hire a hardware/software consultant to help me build a stem with a 64 bit OS, R, and a SQL-compatible DBMS. Please contact me if you know of anyone qualified. Details: I am in need of a robust system that will run R, and a SQL compatible database. I will be working with large datasets, and wish to take advantage of as much RAM as possible, and therefore think I should use a 64

In a RoR application, is it possible to have individual userids associated with particular sessions employed to establish their related connections to the postgresql DBMS backend and, if so, is this design desireable? What are the implications for performance and future deployment limitations? The idea behind this question is that in our application certain tables require that the last

Hi, I agree that replacing data.frames for modeling functions would be too painful. Also I agree with Thomas that new class(es) for tabular data should not inherit from data.frame, and that data.frames should conceptually inherit from some other base tabular data class. At this point I'm not suggesting anything in concrete --- I haven't sorted it out in my own mind --- but I want

Can somebody provide me with a code example of how to tell a migration to add a sequence other than the default? I have been floundering around with the books and online resources but cannot find a clear example. I anticipate that some sort of option hash is invloved but I cannot determin the correct syntax. I imagine that it would go something like this: ... t.column :my_sequence_name

Hi I'm a new user with Asterisk Realtime. I'm trying to write a web application in PHP that will show me asterisk *conf files configuration and that can help me to add/remove users/peers etc... I know that from asterisk 1.0.7 on (with cvs upload) asterisk configuration files can be managed trough aDBMS in my case Mysql. I'd want to know if someone knows how can I "map"

http://www.regdeveloper.co.uk/2008/02/18/stonebraker_dbms_outdated/ <quote> Stonebraker and his group also advocate abandoning SQL because they see no need for a separate data manipulation language. Data manipulation, they said, can be performed with other tasks using languages such as Ruby. </quote> -- There is nothing wrong with America that the faith, love of freedom,

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <- dbConnect(drv,

Dear Friends Greetings, i have a question for you, i am sure someone can help. The pfsense captive portal is up and running. Time countdown vouchers are working without issue, such as 30m, 45m, 1h & so on. However, I'd like to set up a download quota of 200MB per voucher. but then you need to login with a username and password, instead of vouchers. but I haven't found a way to

Is there any way of preserving order of ordered factors when storing a table in PostgreSQL? I have been using PostgreSQL and the RPgSQL package to store a large table with answers such as "Strong disagreement", "Strong agreement", "Mild disagreement". "Mild agreement". When reading the table, such answers are turned into factors, apparently in

I''ve found vague mentions of various attempts at creating an ActiveRecord adapter for the KirbyBase pure Ruby DBMS, but nothing which looks like it''s actually working. Anyone know of such an adapter that is functional and available? b

I see some possible issues with the SQL that is being generated by the firebird adapter. Every SQL is being generated on the fly by concatenating strings. Can someone please explain why the SQL is being generated the way it is? I cannot use this in real life for a couple of reasons: 1. This introduces a security hole because a user, accidentally or deliberately, could potentially submit a

The R FAQ is very helpful about installing R on various Linuxes, but doesn't seem to discuss the advantages of one distribution over another. I am new to Linux (though not to Unix!), and would appreciate some guidance from those with experience. I plan to set up a headless Linux x86 server for the sole purpose of running 64-bit R. Are there reasons to prefer some Linux distributions over

Hi there, I would like some advice, not so much about how to use R, but about software that I need to complement R. I've rooted around in the FAQ's and done a few searches on this mailing list but haven't quite found the perspective I need. I am an experienced data analyst in my field (forest ecology and ecological monitoring) but new to R. I am a long time user of SPSS and have

Hi, I need to somehow make R communicate with another remote JAVA process which provides compute services. I have control over the communications protocol, but I would like to keep it to a standardised protocol, such as SOAP, CORBA, etc. What I would like to know is, what do other people use to do this? The nature of the communications will be low bandwidth procedure calls, with little data.

Rails 2.3 How does one identify the adapter that a migration is using? I have some SQL code that only applies if the postgresql adapter is involved and I wish to put my execute method inside a suitable conditional. However, I cannot see a way to get this information from an instance of ActiveRecord::Migration. Nonetheless, some means must exist for migrations to work. How do I ID the DBMS

I have a .csv table named mailing.csv as below. It consist a receiver, subject and sender. Receiver subject sender 1 Adrian Cole RE: [WHIRR-117] Composable services Tom White 2 Adrian Cole RE: [WHIRR-117] Composable services Tom White 3 Adrian Cole RE: [WHIRR-117] Composable services Adrian Cole 4 Adrian Cole RE: [WHIRR-117]

Has anyone used an AJAX data grid with Rails? I am rebuilding a copy of the venture source web site as a first ruby/ rails exercise. If anyone has used a javascript data grid with Rails, I would appreciate sample code, or notes on your experience. The controller action would presumably communicate with the data grid component running on the browser by extracting data from a relational