similar to: Sqlite3 busy and yet server has no load nor concurrency

Hello, $ ruby script/generate model balance plus:integer minus:integer equal:integer $ cat app/models/balance.rb class Balance < ActiveRecord::Base def save self.equal = self.plus - self.minus super end end $ cat test/fixtures/balances.yml _10-1: plus: 10 minus: 1 $ rake db:fixtures:load $ sqlite3 db/development.sqlite3 sqlite> select * from balances; //=>

i need to use old version of ruby (1.8.7) and older version of rails (2.1.0) so i decided to use rvm. however since i''m somewhat new to ruby and rails i''m having issues. i created a gemset with rvm for my project, installed rails 2.1.0 into it. after that i created a project and a scaffolding for it. however i bumped onto an issue with sqlite3 (or sqlite3-ruby). it seems to me

I am currently experiencing concurrency issues after moving from MySQL to SQLite. My original program worked fined using MySQL but is now returning "SQLite3::BusyException" errors. The same result happens whether or not I enable the allow_concurrency flag. If I do manually acquire a lock on the SQLite DB the problem would disapear, but I thought that rails was supposed to handle this

Hi every one How are you? after a days and searching in forums i still can not find some things that helping me to connect Rails with postgre SQL of course those are helpful but not for a stupid person like me :D So i need my friends helping me here and advice me to how can i connect this two things (ROR and Postgre Sql) I need your help so much My eyes going blind because of searching and

Hi, i want to use development database for my testing purpose. The problem is with, when test cases are run, it deletes the data before and after the test. but i dont want the data to be deleted. how to do this. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group,

Hello, I''m a complete beginner in Ruby on Rails, so excuse me if this is a ridiculous question. Just to bare in mind, I''m using Mac OSX (Snow Leopard), Rails 3, and sqlite3 as a database. I''ve checked, and everything is up to date (Rails, Ruby, Gems). I am simply creating a test application, and I understand the way to run that is by running the ''rails

Hi, I''m currently building a small rails application that needs to store web traffic information. Similar to google analytics and clicky. (but simpler) It needs to store refer domains and visitors. Integration goes through a small javascript snippet. My question is: What database server is the fastest and should I use for this app? I was thinking about SQLlite. Thanks for your time,

Hi, I''d like to make a demo version of my app available, but I''m not ready to get into database stuff, yet. Has anyone ever deployed with sqlite (what I used to develop my app)? If so, what hosting service(s) would you recommend? Thanks, Lille -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this

If anyone understands: def some_method "<script type=''text/javascript''> whatever(''element''); </script>" end => <script type="text/javascript"> whatever(&#8216;element&#8217;) </script> Any idea what could create that strange behavior? -- Posted via http://www.ruby-forum.com/. -- You received

I''m trying to run " rake db:migrate " and im getting an error back: ------------------------------------------------------------------------ C:\wamp\www\demoproject>rake db:migrate (in C:/wamp/www/demoproject) rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB (See full trace by running task

Hi I''m triying to begin developing in ruby on rails, and I''ve instaled all the components but there is a problem with the file sqlite3.dll. When I try to execute my first example in my web browser apears an alert that says sqlite3.dll is not found. I''m working on windows XP with firefox and the server is WEBrick. If someone knows how can I resolve the problem please

if i follow the instructions on: http://agilo.us/2009/03/15/rails-on-windows/ the command gem install sqlite3-ruby will give --------------------------------- Building native extensions. This could take a while... ERROR: Error installing sqlite3-ruby: ERROR: Failed to build gem native extension. c:/ruby/bin/ruby.exe extconf.rb checking for fdatasync() in rt.lib... no checking for

Hello, I recently updated Rails to 3.0.5. The very same code that worked on 3.0.3 now gives error. The code is: def kategorialista Kategoria.where(:elfogadva => TRUE).order("nev").collect {|s| [s.nev, s.sefuri]} end It is in application_controller.rb with helper_method :kategorialista The error it gives on 3.0.5: SQLite3::SQLException: no such table: kategoria: SELECT

Hello all, I''m a Rails newbie trying to get a basic implementation of Paperclip up but it''s giving me problems. I''m developing on Windows XP (I know...) with WEBrick and MySQL. In my model I have: class User < ActiveRecord::Base has_attached_file :avatar,:styles => { :medium => "300x300>", :thumb => "100x100>" }, :url =>

Hi, I''m trying to follow the Rails tutorial found here, http://guides.rubyonrails.org/getting_started.html and when I go to run $ rake db:create I get this wonderful error of sqlite3.dll missing. So, I just went to my ruby directory, and ran $ gem install sqlite3-ruby sqlite3 I''m not entirely sure what to do. Any ideas? -- Posted via http://www.ruby-forum.com/. -- You

I am new to Ruby, and have a problem to install Sqlite3. After searching the previous posts, I found a solution, first to do : sudo apt-get install libsqlite3-0 libsqlite3-dev However, I am on an AWS Ec2 instance which don''t have apt-get, only with yum. Would anyone please tell me how to install apt-get, or how to use yum to install libsqlite3-dev ? Really appreciate ! Scott -- You

I am extremely new to RoR, I am. I am slowly but surely learning Ruby and the Rails concepts but the environment is confusing. I have an application that was written for my company in RoR. It is on a ubuntu server that is going to be shut down. I want to move the app to my two Macs (one Leopard and one Snow Leopard). We want to keep the app to demo a business concept but it can run locally

I have an application where speed is probably the #1 priority here. I am using MySQL 5.0.22. Would SQL be considerably faster than MySQL? I know this has been discussed before, but the search on the forums is not working. Thanks for your help. -- Posted via http://www.ruby-forum.com/.

Using MacPorts To Install Ruby 1.9.1 and Rails 2.3.0 RC1 WARNING: If you want to live on the edge, please continue with the steps below. Also, please be aware that all gems are not fully compatible with Ruby 1.9.1 stable release (i.e. 1.9.1p0). Furthermore, this installation requires you to remove ALL Ruby related gems and ports because we are performing a clean install.

Hi, Here is my problem. I have sqlite3 as the db backend for rails. In addition to Rails, I also have another process that is writing to the db file so that rails can read from the same db file and get updates. The rails is responsible mostly for reading (and displaying) but also it occasionally make modifications to it. However it seems that the activerecord adapter for sqlite3 is locking