similar to: Creating a "handcrafted" database object.

Every now and then when I am working on making the SQL Server adapter pass all the ActiveRecord tests, I notice one that looks like a false positive in the core DBs. Here is one case in relations_test.rb. Can someone look at this and just tell me it is normal for other DBs and just odd for SQL Server? Or maybe it is just my understand of some SQL standard. I''m really not that SQL smart.

I know this isn''t Python, but I''d like to get a view on the ''one obvious'' way to set up an SQLite (or other) database and its location per-app. I''ve got a bit lost with the Camping 2 changes and various code snippets I have kicking around. 1. is it best to set up the DB creation/connection: 1.1 at the end of the app

Hi. I was trying to code same as the rails guide : getting started. I could follow steps to 6.3 Working with Posts in the Browser. (setting home page, creating a resource, running a migration) After clicked create button, errors are occured. SQLite3::SQLException: unable to open database file: INSERT INTO "posts" ("name", "created_at", "title",

Hi, I''m using an sqlite3 database with Rails and have some trouble running unit tests What I''ve done is * rails my_app * edited database.yml to use sqlite3 adapter, db/my_app_development and db/my_app_test * ruby script\generate model user * edited model class User < ActiveRecord::Base validates_presence_of :name validates_uniqueness_of :name end *

Hello All, Yesterday i put RoR with Locomotive. I am very happy :p. So I follow this tuto (http://developer.apple.com/tools/rubyonrails.html). I used Sqlite. my database.yml # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql -- --include=/usr/local/lib) # And be sure to use new-style password

Hi all, I submitted a patch the other day for an issue I ran into running an "add_column" migration on a sqlite3 database when there is existing data in the table, and the new column has ":null=>false". Details at http://dev.rubyonrails.org/ticket/5215. The issue I encountered was not picked due to the unit test not having any actual data in it before running the

Hi, My Snow Leopard just let me down and now it could be a "good" moment to upgrade to Lion. But I''m not sure is it an option yet. I would be using Rails 3.0.9, Ruby 1.9.2 via RVM. Postgresql DB. And probably some stuff via homebrew. Git, Versions and that type of stuff. Are the lights red for Lion since it is so fresh? Any experiences? Thanks. -- Posted via

Hi all, I have been reading and trying all the google links/forums for 2 nights now on how to fix my issue with getting sqlite3 installed so I can use rails. Im running SLED 11. plese help! thank you! $ uname -a Linux linux-7lbv 2.6.27.19-5-pae #1 SMP 2009-02-28 04:40:21 +0100 i686 i686 i386 GNU/Linux $ gem install sqlite3-ruby Building native extensions. This could take a while... ERROR:

Hi all, i'' m trying to configure puppet to use rails with postgresql. I'' m having troubles to make it work. Got no error when running puppetmasterd but nothing is being populated in the DB. Is anybody using puppet with postgres ? my config (in puppet.conf) [rails] dbadapter = postgresql dbname = mydb dbserver = localhost dbuser = user dbpassword = password

I am unable to connect to my databases. Here is the error I am getting: MysqlError (Can''t connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2)): Here is my database.yml: # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql --

Hi, Creating a new Rails application with -d postgresql sets the encoding in the database.yml to unicode Creating a new Rails with -d mysql sets the encoding to utf8 Any ideas why this difference? I''ve been having problems with encoding due to localization, accents, json and what no. I thought I was using utf8 and not unicode. Would this have any impact? If this would be an issue?

Hello Rails people. I tried to push a Rails 3.1 app ( created using cedar stack) to Heroku and I encountered the following error Installing sqlite3 (1.3.4) with native extensions Unfortunately, a fatal error has occurred. Please report this error to the Bundler issue tracker at https://github.com/carlhuda/bundler/issues so that we can fix it. Thanks!

allo vous tous vois l''erreur Counting objects: 66, done. Delta compression using up to 4 threads. Compressing objects: 100% (52/52), done. Writing objects: 100% (66/66), 26.30 KiB, done. Total 66 (delta 3), reused 0 (delta 0) -----> Ruby/Rails app detected -----> Installing dependencies using Bundler version 1.3.0.pre.2 Running: bundle install --without development:test

Hello, I have configured puppet and puppetdb (storeconfig) with postgresql and the service run and the collecting are good for example: I can make query with the next command and responds ok . [.........................] [root@master]# curl -X GET -H ''Accept: application/json'' http://127.0.0.1:8080/v2/facts --data-urlencode ''query=["=", "name",

Hi Guys I''d like to know how to change from using sqlite3 to mysql. I''m running windows xp. What is the command that I must type under my application folder? How to I log into the mysql database afterwards? My database.yml file contents at the moment are: # SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development: adapter: sqlite3

Hi, I have developed a little web app with a sqlite3 database in development environment. Now I switched over to mysql2 for production environment. At a first look everthing looks good! BUT, I have delayed_jobs that run methods in the background, where two nested active records were compared with "if hash1 == hash2", then it should just show whether they are the same or not. With

Hi all, As I understand it, storeconfigs needs to be enabled on both the agent and the master to function ideally. I have a couple of questions: -> Can the various agents and the master safely share the same storeconfigs db (say, a postgresql server)? Is there any benefit to setting things up this way? -> Is there any benefit for an _agent_ to use an RDBMS vs sqlite for its

All; I am using Asterisk 1.8 and am running into some performance bottlenecks. Right now I am sending upwards of 700 concurrent faxes. I have no problem with that. The problems appear after the faxes complete. I was thinking of using sqlite3 to log CDR's, thinking that would be faster than using MySQL. Has anyone ever benchmarked this to quantify just how much faster sqlite3 is? Are there

I wanna push my application straight from Github to Heroku. Everything goes through until it hits the installation of the gems. It can''t install the SQLite3 (local DB). I know Heroku doesn''t use SQLite but I didn''t expect this problem. The error messages recommended installing a version of SQLite3 (v1.3.6) which I did but it keeps on complaining :(. Any workaround?

Hi, Developer(s) I will use this fantastic IMAP/POP -Server but i dislike, no a realy HATE PostgreSQL!, please make a hack or code a MySQL support. I know its a strange mail, and "question" but every one's first choice for SQL-DBs is MySQL! :) and i love it!. thanks in advance eLgino