database ruby-on-rails

I'm running into scaling issues with a Rails app running on top of MySQL. I'm using memcached and have lots of indexes. I'm also starting to…

Is there a Rails gem, plugin or other means to automatically add or remove ALL RI constraints from your DB and schema? Or ALL of them on a per table…

We are providing document upload on different things like tasks, feeds, comments etc.. And there are lots different permission on documents for…

Environment: MySql, Rails 3.0.7 In my user table I have a 'last_activity_date' column which is kept up to date using various after_save hooks…

I have an iPhone app out that stores data on the device. I want to create an app with user accounts like Instagram, Path, Foursquare, Gowalla, etc.…

I need to create a history table for particular resource and am trying to decide how to design it. My current thought was to create a separate table…

My iPhone app currently uses core data. I want to create an online database where I can sync data from my iPhone. I also want to store user account…

`postgresql_connection': No database specified. Missing argument: database. (ArgumentError) I installed postgresql using Homebrew and am able to…

I've got an app which pulls most data from a remote database. I've got the set-up working locally (development machine connecting to remote…

Hey to all, We are currently using postgresql for our production database in rails, great database, but I am building the new version of our…

How to do? I tried something like: RAILS_ENV=production rake db:create db:load in file /lib/tasks/load_tasks.rake and this file I tried in terminal…

I got a rails project in version 2.3.8.When i tried to run rake db:create, the below error occured. Couldn't create database for…

This is kind of a strange question, but I will try to explain it to the best of my ability. Let's say I have the following two tables: table: cars…

How can I reduce DB values? Anybody have any idea what is going on here? Completed in 0.19635 (5 reqs/sec) | Rendering: 0.00046 (0%) | **DB: 0.04554…

I have a Ruby on Rails application which is not very big, but has one sticky requirement. The requirement is that in the event of a big commit there…

I have a SQL script that has four columns and about 100 records. I only need two columns. I want to transfer the two columns into my seeds.rb file…

I am using Ruby on Rails 3 and MySQL. In my project I would like to create an activity-stream "module" in order to save each user action information…

hi, i have following problem: i have 3 models orders, users and apps, with following relations: Users: has_many :apps has_many :orders Orders:…

Hi im new to rails (please be easy on me :P). Im using rails 3.0.5, ruby 1.9.2 and mysql2. within my rails program i make a call to the database to…

Hey guys, I've been deploying some apps to Heroku recently. I run MySQL on my local dev machine and have spent a little while updating some of my…