search for: dbmses

Dear all, One of my students (whom I am trying to convince to use R) wants to get a fairly large SAS dataset into R (about 150mB). An obvious and simple thing she tried was to write the dataset as a .csv-file and then read that into R, but that takes forever (or something close to that..). The dataset is so large, that exporting it as an Excel file from SAS is not feasible (more than 65000 lines).

Hi, Is there a way to tell Rails that the magic field name for optimistic database locking is not lock_version? I have a legacy database where the optimistic locking field is named "version". Thanks, Phil -- Posted via http://www.ruby-forum.com/.

...what nailed me--I was doing a simple pull-up-method refactoring and suddenly it started complaining that I had no ''type'' column in my table.) 2. It''s entirely non-relational, and thus bad practice to suggest to those who do not well understand relational DBMSes (which is the vast majority of programmers out there) that this is any sort of a valid technique. SingleTableInheritance is a tool of desperation, when you can''t change your database schema to be relationally sound and make sense. It would in fact be nice if ActiveRecord p...

...ind someone who will say that brilliance would have been better redirected to other pursuits, even if it meant continuing to program in those languages. These people usually aren?t programmers, though, so I?m not inclined to give their opinions much weight. PostgreSQL, MySQL, or SQLite? How many DBMSes do we really need? SQLite simply cannot replace a lot of PostgreSQL installations. Likewise, it?s usually a blunder to try to use PostgreSQL in places where SQLite is most often found. (I?ve only seen it tried once; it was indeed a blunder.) MySQL can stretch to touch either extreme, but it?s n...

We have been struggling with our Lustre performance for some time now especially with large directories. I recently did some informal benchmarking (on a live system so I know results are not scientifically valid) and noticed a huge drop in performance of reads(stat operations) past 20k files in a single directory. I''m using bonnie++, disabling IO testing (-s 0) and just creating, reading,

Holabueno, aunque hay muchas posibilidades para fusionar ambas tablas, usando la tuya sería algo así:Df3<-merge(Df1,Df2,by="Reviewer.Username", all = TRUE) El Lunes 16 de enero de 2017 20:08, Jesús Para Fernández <j.para.fernandez en hotmail.com> escribió: Los data.frames para unirlos lo mejor es que tengan el mismo numero de columnas o variables. El dataframe2 

SQL help needed.. If I have a MySQL table with dialing codes and a corresponding description (see below) and I want to lookup the best match for a phone number.. What would the SQL look like to do it? or would it take more than just SQL to get to the best result? Thanks.. Later.. Example numbers, (random end digits so I don't know who's they are.) 00442085673456 - UK London

On Wed, Jan 7, 2015 at 7:31 AM, Darr247 <darr247 at gmail.com> wrote: > On 07 January 2015 @01:37 zulu, Always Learning wrote: >> >> You seem to forget. Computers were invented to perform repetitive tasks. > > > Or maybe, some of us just seem to remember it differently. > In my opinion, robots/automatons were invented to perform repetitive tasks; > computers

I've been wondering how to work with more data than can fit in memory, in a way that allows it to be worked with conveniently and quickly. Of course, a database can be used for this purpose, but extracting data from a database is much slower and somewhat less convenient than extracting data from a native object (at least in our setup). One idea I was thinking about was to have a new

A consensus seems to emerge : R would excel to exploratory work on small/middle-sized datasets, while SAS would be able to munch much larger datasets. However, I see the "size" problem as a red herring. The objects that have to stay "in core" are usually much smaller than the dataset. For example, for problems involving fixed-effects linear models, you need only some

If anyone is interested ... just in case! :-)... I have tried to write , based on the cdr_mysql.so module, an Sybase module. To compile you can use something like that: export SYBPLATFORM=linux export SYBASE=/opt/sybase cc -I$SYBASE/include -c -o cdr_sybase.o cdr_sybase.c cc -shared -Xlinker -x -o cdr_sybase.so cdr_sybase.o -lsybdb -lm -L$SYBASE/lib (anyone could write the corect Makefile

Hi, I discovered a weird behavior when using a "belongs_to: record" association in Rails 4. Given two models A and B: class A < ActiveRecord::Base belongs_to :record, class_name: ''B'', foreign_key: ''b_id'' end class B < ActiveRecord::Base end When creating A, it inserts a record in B and returns A with id of nil: irb(main):001:0>

Is it possible to have nested MySQL queries in extensions.conf? Ie, perform a query, grab a value, and then jump to another location in the dialplan and do another query based on that original value. I'm having problems with the result and fetchid's and I'm not sure if it's even possible to do this or not. Thanks, Doug. -------------- next part -------------- An HTML