Ruby on Rails on PostgreSQL Installer for Windows

Hi,

I’m one of the maintainers of the windows distribution of PostgreSQL
and am currently working on an application stack management tool to
complement the PostgreSQL installer and allow our users to quickly and
easily setup their application environment. The project includes the
development of the stack builder tool, a setup toolkit, and what we
hope will become a wide range of applications for users to choose
from.

The first of these applications, developed alongside the setup toolkit
is a windows installer packaged distribution of Ruby, preinstalled
with Rails (with the rails command defaulting to PostgreSQL support)
and the postgres-pr interface.

If anyone would like to give the current beta version a try, we’d love
to hear any feedback you might have. The project website can be found
at:

http://pgfoundry.org/projects/stackbuilder/

with downloads at:

http://pgfoundry.org/frs/?group_id=1000256

Regards, Dave.

Hi Dave,
I made mention of your ruby/rails/postgreSQL distribution not but a few
hours ago!

I am current working on windows XP (development server) using Apache 2.2
and
postgreSQL 8.1 (with SSL). I noticed in your documentation that the
install
process checks for an exitance of postgreSQL. I take it that your
distribution is inclusive of the latest postgreSQL option 8.2.x? Could
you
please confirm whether my current version will be updated to the latest
version during the installation process or will it simply ignore
installation of postgreSQL altogether bu yet yet setup the necessary
configuration files in ruby/rails?


Regards

Andrew

Hi,
I’ve managed to answer all point from my former question.

I have installed your binary distribution on Win XP SP2 and have a
folder
sitting in my root directory as so:

c:>pgRails

I have placed C:\pgRails\bin in my system path and when I do:

c:>rails projectname

I get the following error message:

ruby: No such file or directory – rails (LoadError)

What is the issue here?


Regards

Andrew

On Feb 28, 1:02 pm, “Andrew M.” [email protected] wrote:

installation of postgreSQL altogether bu yet yet setup the necessary
configuration files in ruby/rails?

Hi Andrew,

PostgreSQL is not included in the pgRails package. What will
eventually happen is that following a regular install of PostgreSQL on
Windows, the stack builder wizard will run and allow the user to
select additional packages to install to complement their shiny new
PostgreSQL installation. The wizard works out the interdependencies,
then downloads and runs the installer for each package selected. Where
possible we aim to use existing official packages, but when not, we’ll
use our setup kit to build our own package. Of course, you will also
be able to run the wizard at a later time which is why it will look to
see what versions of PostgreSQL/EnterpriseDB you have already.

The Rails package is built with our setup kit, and as downloaded
manually from pgFoundry can be used as a completely standalone
installer, even running alongside the Ruby one-click installation if
required (though you may have to tweak your PATH).

As a standalone package it doesn’t care if you have PostgreSQL
installed or not, and will still happily work with any other DBMS,
though you might need to use the non-defaulted version of rails.cmd
(shipped as rails-orig.cmd).

Regards, Dave

On Mar 2, 1:55 am, Shauna [email protected] wrote:

Dave,

InstantRails is a nice, all-inclusive installer. It’d be great to have a
version that installs its constellation plus PostgreSQL all
pre-configured. (Or your version could omit MySQL, etc.)

I would love to be able to run Rails with PostgreSQL out of the box
instead of MySQL.

Hi Shauna,

At risk of sounding like a troll, PostgreSQL is a far more complex
DBMS than MySQL and can’t easily be installed from a zip file without
potentially compromising the security and data integrity values that
the PostgreSQL community hold so highly. We’ve gone to great lengths
to make the PostgreSQL installer stand up to those values, and to be
easy to integrate with other installers to allow packagers to bundle
PostgreSQL with their products.

In this case though, please remember that I’m first and foremost a
PostgreSQL guy, so my aim is to make it easy for people like yourself
to use PostgreSQL and add the tools and applications you want to your
PostgreSQL environment (in this case, Ruby on Rails of course).
Consequently I have little interest in working the other way round
myself, although, if anyone were serious about building an installer
for their project that included PostgreSQL, I would be more than happy
to provide any assistance needed to help them achieve that using our
existing PostgreSQL installer.

Regards, Dave.

Dave,

InstantRails is a nice, all-inclusive installer. It’d be great to have a
version that installs its constellation plus PostgreSQL all
pre-configured. (Or your version could omit MySQL, etc.)

I would love to be able to run Rails with PostgreSQL out of the box
instead of MySQL.

Shauna

Personally the next, next, next finish installers are good for some
things bud if you install a bundle of different applications that have
a security issues and need more attention from the user.
This wizard like installers should consist off all needed applications
and a good intuitive path of installation procedure.
In that way the all applications could be installed and configured
properly and users can profit from it.

I am very for this PostgreSqlRailsAllInOne installer and it is a
fabulous tool to have.

Go for it in a clever way.