similar to: ActiveRecord: Reading MySQL views

Rails SQL Views 0.5.0 is now available from http://rubyforge.org/frs/?group_id=2435&release_id=8685 and shortly as a Gem (gem install rails_sql_views). More information on Rails SQL Views can be found at http://activewarehouse.rubyforge.org/rails_sql_views/ This release finally fixes the SchemaDumper issues, including the necessary select statement for the view. It also introduces PostgreSQL

I have a DB2 schema with many ''views'' and table partitions defined in it. As per our new project requirement we have to support multiple databases (DB2,Oracle and MYSQL to be specific). The frontend application is implemented using Ruby on Rails. I am interested in exploring the possibility of using Rails Migrations to abstract out the schema to a DB independent layer. I could

I''m working on an app that uses info from a government database. For a variety of reasons (not the least of which is that their database is in MS Access), I can''t simply write a wrapper around the legacy database. Instead, we''re looking to have an "import" script in the Rails environment (it''s fine if it''s run from the server and through the

I am receiving the following non-fatal error from Rails for a particular action: Error calling Dispatcher.dispatch #<ArgumentError: Anonymous modules have no name to be referenced by> ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:313:in `to_constant_name'' ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:270:in

Hi! I''ve got a very strange problem. Suddenly the SQLite3 Backend stopped working. Example 1: > rake db:rollback == CreateProducts: reverting ================================================= -- drop_table(:products) rake aborted! An error has occurred, this and all later migrations canceled: SQLite3::SQLException: near "CASCADE": syntax error: DROP TABLE

I have a Person model with attributes first_name and last_name. I want to implement autocomplete search that looks that the entire name. Hence I have a method: def full_name self.first_name + " " + self.last_name end Is it possible for me to query on full_name and have rails match the first_name and last_name fields? I currently receive this error when I try, because full_name

Hello, I need to consume a web service of an App called RedMine created with Rails, in order to have a sort of "separate" interface (not the same as the app) for one of the departments (that interact with the app) to interact with it and generate some different reports based on the same data. I don''t know much about either (ETL and Rest), all I know is that ETL seems to

We have some results that are somewhat entertaining and that relate to the size/speed discussion. The basic idea is exhaustive generation of C functions where "exhaustive" is qualified by some structural restrictions (depth of AST, node type, etc.). For one particular set of restrictions we ended up with about 7 million C functions. We then compiled each of these functions with 7

A few random observations: 1. Clang could do better with large but boring switches like this: http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/E8/E88C5111.shtml Performance of clang's output will be fine but this is a major code size lose. 2. Destruction of stupid loops is incomplete, sometimes due to phase ordering problems:

>> Repetitive code with lots of bitwise operations is compiled by LLVM into >> much larger code than the other compilers: >> >> http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/ED/ED37DAF5.shtml >> http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/1F/1F4003C7.shtml >> >> Note that this is straight-line code, so LLVM's output will

So, I was looking for a setup that would allow me to easily query multiple databases and not have to re-write my customer finder type queries. Here is what I came up with and it seems to be working for me in my very basic tests so I thought I''d share. Just posting it in case this helps anyone else trying to do the same thing. I''m using this with activerecord, but not rails, so

> Umm, can you find one that isn't a popcount implementation? Ok. MMX psadbw instruction: http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/CE/CE3DA132.shtml Position of first set bit: http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/1F/1F4003C7.shtml Log2 floor: http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/83/837A80E9.shtml Pixel format

Hi folks, I've posted an updated code size comparison between LLVM, GCC, and others here: http://embed.cs.utah.edu/embarrassing/ New in this version: - much larger collection of harvested functions: more than 360,000 - bug fixes and UI improvements - added the x86 Open64 compiler John

On Tue, Jan 26, 2010 at 5:55 PM, John Regehr <regehr at cs.utah.edu> wrote: >>> Repetitive code with lots of bitwise operations is compiled by LLVM into >>> much larger code than the other compilers: >>> >>> >>> http://embed.cs.utah.edu/embarrassing/jan_10/harvest/source/ED/ED37DAF5.shtml >>> >>>

So it would appear that llvm-gcc and clang are both slower than gcc4 which is infamous for being slow at compiling code, and yes this is with a release build/--enable-optimizations. This seems to go against notes such as http://clang.llvm.org/features.html#performance which claim clang is signifcantly faster than gcc. Below are some times and the larger object files when compiling an i386

Dear list, could someone point me to the right command to subtract 2 columns in a data.frame. Might be a bit embarrassing question. But I cannot figure out how to do this simple command in R. Thanks, Ulrich -- __________________________________________________ Ulrich Leopold MSc. Department of Physical Geography Institute for Biodiversity and Ecosystem Dynamics Faculty of Science University

Hi, Until last week, I could install a CentOS 7 based desktop using the following approach: 1. Install minimal system. 2. yum groupinstall "X Window System" 3. yum install gdm gnome-classic-session gnome-terminal liberation-fonts 4. Install applications as needed. This morning, the package group "X Window System" seems to have disappeared. This is embarrassing. What

Hello all, I have an enterprise MS SQL Server database system that is being used by multiple applications, both web and windows-clients. Some of the "tables" used by many databases are stored in one accessible database and used as views in the local database of each application. I understand that I can setup multiple database AR connections. That is a potential alternative. I want to

Let''s say I want to find out what column names exist in two tables, table_a and table_b. One way I''ve been doing this is using ActiveRecord and the column info it returns. After establishing a connection for ActiveRecord, I do the following: ActiveRecord::Base.set_table_name("table_a") column_names_a = ActiveRecord::Base.column_names

[cross-posting to the GCC and LLVM lists] I've updated the code size results here: http://embed.cs.utah.edu/embarrassing/dec_09/ The changes for this run were: - delete a number of testcases that contained use of uninitialized local variables - turn off frame pointer emission for all compilers - ask all compilers to target x86 + SSE3 - ask all compilers to not emit stack protector