similar to: seeking hardware/software consultant to build system with 64-bit OS, R, SQL DBMS

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

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

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

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

I am searching for a programmer whom I can hire to develop a simple Speex audio recording and playback program for use in Windows.  If anyone is interested in this project, please contact me at extrastuff123@aol.com for more details. If you know of anyone who might be capable and available for hire, please let them know of this offer.  Thank you for your help. <p><p>--- >8

Dear R helpers, i am using the ecdf(emp. cumulative distribution function,and am getting the following error on daily returns of stock data (about 2000 data points). I am not sure what this means, I would expect the result of the code to be 1 (the integral from -infinity to +infinity of the emp. cumulative distribution). Also when I try to integrate a smaller subset(from say 0 to 1, i get an

> I am searching for a programmer whom I can hire to develop a simple Speex audio recording and playback > program for use in Windows. If anyone is interested in this project, please contact me at > extrastuff123@aol.com for more details. If you know of anyone who might be capable and available for hire, > please let them know of this offer. Thank you for your help. Windows Sound

Hello Everyone, My name is Prashant and I head the placement division with ANZ Solutions. We work with close to 53 clients all over the country and help them with their staffing requirements. I like to network with strong technical people like you and like to associate myself with respect to your career plans. Please let me know and I will give you a call. We can help you for any kind of

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've recently stumbled across data.table, Matthew Dowle's package. I'm impressed by the speed of the package in handling operations with large data.frames, but am a bit overwhelmed with the syntax. I'd like to express the SQL statement below using data.table operations rather than sqldf (which was incredibly slow for a small subset of my financial data) or import/export with a

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

Hello R users, I have a full time job opportunity at SolutionSet, 100% working for Google in Mountain View, CA. Email me your resume at mae.coughlin at solutionset.com, if you are interested. Thank you! --mae Strategy & Analytics Lead Consultant for Google Position overview: As a valued member of our marketing service agency SolutionSet, you?ll work collaboratively with our account &

Dear Candidate, Please have a look on the Direct Client Requirement and send me the profile ASAP along with the rate and contact details. Position: Backend Software Engineer with Ruby on Rails Location: Boston, MA F2F must after telescreen (Client will pay Expense) Duration - 6 Months (It is Contract to Hire Position) The ideal candidate will be a Ruby on Rails guru, with

Hello Ruby on Rails groups! My name is Kristy Julien and I am recruiting for a Mid-level Software Engineer position that is currently available in Herndon, VA. The position is contract to hire with a very progressive company with STELLAR benefits and is available immediately. I''ve pasted the job description below. The qualified candidate has project experience on a Rails project and

For a recent project I had to construct an advanced search page with some ranges and some select boxes, all of which are optional. The difficulty came in figuring out a way to construct a proper SQL query from the options provided. I hacked one together that works for the time being, but I would like to know how this is done properly. Does anyone have any links to references where this is