similar to: RoR, pg_connections, and pg_users

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

Hi all, I have the following script,which won't plot (tried in RGUI and also in Eclipse StatET): library(ggplot2) # for plotting results userids <- c(1,2,3) for (userid in userids){ qplot(c(1:10), c(1:20)) } print ("end") No plot shows up. If I run the following: library(ggplot2) # for plotting results userids <- c(1,2,3) for (userid in userids){ blabla))) qplot(c(1:10),

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

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

We have an existing samba server with many userids, using NTLM authentication (stored in OpenLDAP). We would like to add many other userids, which will authenticate against an existing MIT kerberos server. Each of our customers will have either an NTLM-based userid/password, or a kerberos-based userid/password, but never both. We would like both kinds of userids to work with the same samba

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,

I updated all my servers to 3.0.25 early this morning. Everything seems 100% A-OK except for the most surprising thing, all my Windows and Macintosh clients, no problems. But I'm having severe difficulty with the 3.0.25 smbclient. If I use smbclient from 3.0.24 it too can connect to my 3.0.25 servers without issue. Its bizarre. Before I go into it let me say, I've got some 3.0.25

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

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.

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

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'm currently trying to do analysis on a 565k record database of Philadelphia's property assessments. I read the Data Import/Export .pdf and am still conflicted about which DBMS I should use to maintain reliability and ensure I don't crash while trying to do my calculations. Should I go with PostgreSQL for the option of Proxy Data Frames or should I go with MySQL for the "lean

<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

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

= About Ackbar Ackbar is an adapter for ActiveRecord (the Rails ORM layer) to the KirbyBase pure-ruby plain-text DBMS. Because KirbyBase does not support SQL, joins or transactions, this is not a 100% fit. There are some changes to the ActiveRecord interface (see below), but it may still be useful in some cases. = URIs Ackbar: http://ackbar.rubyforge.org KirbyBase:

I have an index in which I want different records to be accessible to different users. I think I can do this by adding a "users" field to each record in the index and narrow down my queries to only those records matching the current user''s userid. I have the userids separated by commas. What would be the right way to query for a certain user? I have to make sure that I

Hello all, We just bought a new server to migrate our Samba installation, but we are facing some problems with it. Both machines run Samba 2.2.7 configured as PDC for our domain. When migrating, I copied /etc/samba/smb.conf and smbpasswd, and adjusted smb.conf to listen to the new server's IP address. Now all users can log on to the domain and access the Samba shares, but no-one can

I'd like to search for a particular string in an SQLite database using RSQLite, but I'm running into problems constructing the query properly, because of embedded quotes and parens in the string. Is there a function that escapes these for me, or some other fixup that would let me do the queries below? In the real situation I don't have control over what strings get searched for.

Hi, I am writing a function that writes to a csv file for every call. However, for the subsequent calls, I want to append the data to the existing csv file without appending the column names again. I tried searching in the previous posts, but I am stuck with different errors. Here is what I am doing (dataF is a data-frame):- outputFilePath <- paste(getwd(), "/",