similar to: auto increment id

anyone? -a -- =============================================================================== | EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov | PHONE :: 303.497.6469 | When you do something, you should burn yourself completely, like a good | bonfire, leaving no trace of yourself. --Shunryu Suzuki ===============================================================================

I''ve used mysql for quite some time now. Other than crashing when the partition gets full, I''ve had no problems with it. But I''ve heard great things about postgres and have seen some people say it''s much superior to mysql. So, with a Rails application, is there any reason why I would want to learn/use another DB besides mysql? Any pragmatic benefits?

line 212 of postgresql_adapter.rb is return Time.now.to_s if value =~ /^\(''now''::text\)::(date|timestamp)/ i don''t think this will work. in postgresql the field ''now'' is pinned to the SAME TIME for the duration of a transaction. eg. if you do begin transaction; insert into t values(42, ''now''); # sleep one minute

Greetings all-- Humble newbie requesting help here. I''ve just installed Ruby 1.8.2, Rake 0.4.15, and RubyGems 0.8.8. When I try to get Rails into place via "gem install rails," I get the error below. What have I done wrong? Can anybody throw me a rope? Attempting local installation of ''rails'' Local gem file not found: rails*.gem Attempting remote

I''m having a problem converting a date retrieved from my MySQL database and I''m hoping someone can help. MySQL stores the date/time as this: 2005-03-08 17:00:34.0 and according to my Pickaxe book Ruby stores times as "the number of seconds and microseconds since [...] January 1, 1970". All well and good. Unfortunately, RoR is converting my date to this:

I think my rails app has a slow memory leak that degrades performance over the course of several days. I''d like to get to the bottom of it but in the meantime I''d prefer to just bandage it and force the fcgi library to start a new instance of my app every so often. Is there a clean way to do this? Calling break in the each_cgi loop causes an error. Sending SIGUSR1, which

I hacked a forking FCGI dispatcher for Rails. I have no idea if this is the correct way to do it, but it seems to work fine. It improves memory usage a bit; after it is started the processes share almost 10 MB (of 12 MB total), but unfortunately it drops to 2 MB after a few requests. ===================================== #!/usr/local/bin/ruby require File.dirname(__FILE__) +

Hi all, Last night, I wrote a web-based syntax highlighter that takes Ruby and produces nice HTML of the code, ready for including on web pages, or in blog posts, or whatever. I don''t know how useful it will be for other people, but feel free to use it. Anyway, the URL is : http://syntax.carldr.com/ Any comments/suggestions would be gratefully received. Enjoy!

First let me say that Rails caching is very very cool. The traffic (and responsiveness) I''ve saved by added 10 lines of ruby code would be enourmous, if I actually had traffic... ;) Sweepers as observers are great, btw. Since every page of my side is dynamic, once I did some DB optimization I''m caching the content of the index page which was taking the bulk of the time to load

Recently my application has refused to start on my production environment. The setup is debian(unstable)/apache2/fastcgi/mysql Rails 0.10 (upgrading to 0.10.1 as we speak) When I first start up apache the machine grinds to a crawl starting up the dispatch.cfi processes. It''s a VPS with 256M of ram, but still (in addition to user time) it''s spending 30% of time in system

i''ve been bashing my head against the screen for about two hours... for the life of me i could not figure out why connections to mysql were failing when view through browser but NOT from the command line as user apache... i confirmed that all connection parameters were correct and still no go. eventually i disabled selinux and all is well. there was a configuration section that claimed

Hi, I am from a Java background and pretty new to Ruby and Rails. What I am wondering is how I would shared state accross requests and users without involving IO, i.e. use memory. My current understanding is that for each request a new process ist spawn and therefore it gets its own memory. So no sharing can take place between requests? Do I understand this right? For those who know

considering that sqlite, mysql, postgresql, etc all handle times differently (well only postgresql really *handles* them) i''m wondering how to best approach time fields in rails. my current thinking is that sqlite is the least common denominator: it stores everything as text and does not checking, mysql has datetime, date, and timestamp but does poor checking (crippled to be precise) to

Hi, I''m trying to get the UserEngine running. I have installed the LoginEngine, added the essential lines to environment.rb / application.rb and application_helper.rb. Worked fine. Then I did the same with the UserEngine and when trying to set up the db: rake engine_migrate ENGINE=user I get: Migrating engine ''user_engine'' rake aborted! stack level too deep But...

The latest version of dispatch.fcgi in the trunk has the following code snippet: trap("USR1") do # Go to exit as soon as possible. end One of the issues I encountered while debugging fcgi under windows is that SIGUSR1 is not supported in the native Windows version of Ruby (though it is in cygwin). Currently, I have it commented out to allow dispatch.fcgi to run without blowing up.

So apparently 1.8.4 is soon forthcoming. We need testing against it. Could someone help out with that? I believe Ara already checked into some of the issues, do you know if those are resolved, Ara? -- David Heinemeier Hansson http://www.loudthinking.com -- Broadcasting Brain http://www.basecamphq.com -- Online project management http://www.backpackit.com -- Personal information manager

NAME tumblr SYNOPSIS tumblr (setup|write|read|authenticate|check-vimeo|check-audio) [options]+ DESCRIPTION tumblr.rb is a command line utility and library which interfaces to the excellent tumblr blogging platform @ http://www.tumblr.com tumblr.rb implements the complete restful api in both library and command line utility, doccumented in full @ http://www.tumblr.com/api

i''ve got a little rails app i''m messing with the schema is create table timedatevalidates ( id serial, timedatetovalidate timestamp, primary key (id) ); the mvc was initialized using rails scripts/generate scaffold timedatevalidate i''ve got this in a subdir of webroot and have modified .htaccess and config/routes.rb like so .htaccess :

Hi, Attached are links to two patches I submitted via the RoR Trac system a week or so ago: http://dev.rubyonrails.org/ticket/8305 http://dev.rubyonrails.org/ticket/8308 I refrained from creating a new Trac ticket for ARes, which will be affected if both of these patches are accepted by Core. There are a couple of workarounds for this issue, but it would be nice for AR, AS and ARes to output

i''ve got the latest ruby and rails on this box and am seeing that image_tag will turn something like /foo/bar.jpg into /foo/foo/bar.jpg in the following situation: /ror/foo/public /var/www/html/foo -> /var/ror/foo/public/ image_tag("/foo/bar.jpg") this is exactly how compute_public_path is written to work: def compute_public_path(source, dir, ext)