[ANN] postgres-pr (pure Ruby PostgreSQL)

Hi,

I'm proud to announce the first public "release" of postgres-pr. This is a library to access PostgreSQL from Ruby without the need of any C
library.

* You can use it only with newer 7.x databases that use wire-protocol 3.
* Lot's of stuff is missing, only the wire-protocol is quite complete.

Quick Example:

   > gem install postgres-pr
   > irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

   require 'postgres-pr/connection'
   c = Connection.new('DBNAME', 'DBUSER')
   c.query('SELECT 1+2') # => [["3"]]

Regards,

   Michael

Michael Neumann wrote:

Hi,

I'm proud to announce the first public "release" of postgres-pr. This is a library to access PostgreSQL from Ruby without the need of any C
library.

* You can use it only with newer 7.x databases that use wire-protocol 3.
* Lot's of stuff is missing, only the wire-protocol is quite complete.

Quick Example:

  > gem install postgres-pr
  > irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

  require 'postgres-pr/connection'
  c = Connection.new('DBNAME', 'DBUSER')
  c.query('SELECT 1+2') # => [["3"]]

Regards,

  Michael

oh neato. I'm glad someone made a pure ruby version.

Is there an rpa?

David Ross

I'm proud to announce the first public "release" of postgres-pr. This is a library to access PostgreSQL from Ruby without the need of any C
library.

Just excellent! Thanks a lot :slight_smile: Lets hope that more people will start using PostgreSQL instead of mySQL.

George.

···

--
www.navel.gr | tel: +30 2106898050 | fax: +30 2106898437

web appliction engine: http://www.navel.gr/nitro
have fun: http://www.joy.gr

Am having problems testing...

I added 0.2.2 via gem install method..

and following the above I get;

E:\ruby\code\postgres-test>irb -r rubygems
irb(main):001:0> require 'postgres-pr/connection'
=> true
irb(main):002:0> c = Connection.new('dbtest', 'sgeorge')
NameError: uninitialized constant Connection from (irb):2

and so doing a test .rb

require 'rubygems'
require_gem 'postgres-pr/connection', ">= 0.2.2"

c = Connection.new('dbtest', 'sgeorge')
c.query('SELECT 1+2')

It doesnt like it....

e:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:116:in `activate':
(Gem::LoadError)
Could not find RubyGem postgres-pr/Connection (>= 0.2.2)
        from e:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:34:in
`require_gem'
        from test.rb:2

I tried even PostgresPR::Connection.new, etc...

can you pass /connection in a reqiure_gem?

hmm so removing the /connection from the require_gem line gets me
test.rb:4: uninitialized constant Connection (NameError)

so... how exactly do I use it???

(I have a dbtest created and my username associated to that DB, I
checked that already with psql)....

what exactly am I doing wrong?

-- Stu --
[FAQ] Write Your Own Operating System
    http://www.mega-tokyo.com/osfaq2

···

On Fri, 19 Nov 2004 00:12:28 +0900, Michael Neumann <mneumann@ntecs.de> wrote:

  > gem install postgres-pr
  > irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

  require 'postgres-pr/connection'
  c = Connection.new('DBNAME', 'DBUSER')
  c.query('SELECT 1+2') # => [["3"]]

David Ross wrote:

Michael Neumann wrote:

Hi,

I'm proud to announce the first public "release" of postgres-pr. This is a library to access PostgreSQL from Ruby without the need of any C
library.

* You can use it only with newer 7.x databases that use wire-protocol 3.
* Lot's of stuff is missing, only the wire-protocol is quite complete.

Quick Example:

  > gem install postgres-pr
  > irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

  require 'postgres-pr/connection'
  c = Connection.new('DBNAME', 'DBUSER')
  c.query('SELECT 1+2') # => [["3"]]

Regards,

  Michael

oh neato. I'm glad someone made a pure ruby version.

Is there an rpa?

nope. maybe later, if it's better tested.

Regards,

   Michael

David Ross wrote:

Michael Neumann wrote:
oh neato. I'm glad someone made a pure ruby version.

ditto here. a wonderful news. i think i'm going to try to use it on a regular basis instead of the "postgres" C-based library, solely because only postgres-pr is available as a gem (yes, i'm that lazy :-). i use ruby on lots of machines...

Is there an rpa?

i thought the purpose of RPA is as a collection of _production_-level (mostly mature, stable, well tested) libraries?

···

--
dave

George Moschovitis wrote:

I'm proud to announce the first public "release" of postgres-pr. This is a library to access PostgreSQL from Ruby without the need of any C
library.

Just excellent! Thanks a lot :slight_smile: Lets hope that more people will start using PostgreSQL instead of mySQL.

I'm looking forward to use postgres-pr with Og :wink:

Regards,

   Michael

Stu wrote:

···

On Fri, 19 Nov 2004 00:12:28 +0900, Michael Neumann > <mneumann@ntecs.de> wrote:

> gem install postgres-pr
> irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

require 'postgres-pr/connection'
c = Connection.new('DBNAME', 'DBUSER')
c.query('SELECT 1+2') # => [["3"]]

Am having problems testing...

I added 0.2.2 via gem install method..

and following the above I get;

E:\ruby\code\postgres-test>irb -r rubygems
irb(main):001:0> require 'postgres-pr/connection'
=> true
irb(main):002:0> c = Connection.new('dbtest', 'sgeorge')
NameError: uninitialized constant Connection from (irb):2

I moved everything into the PostgresPR module.

   c = PostgresPR::Connection.new(...)

should work.

Rubygems does not automatically inlude Module's.

Regards,

   Michael

Michael Neumann wrote:

David Ross wrote:

Michael Neumann wrote:

Hi,

I'm proud to announce the first public "release" of postgres-pr. This is a library to access PostgreSQL from Ruby without the need of any C
library.

* You can use it only with newer 7.x databases that use wire-protocol 3.
* Lot's of stuff is missing, only the wire-protocol is quite complete.

Quick Example:

  > gem install postgres-pr
  > irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

  require 'postgres-pr/connection'
  c = Connection.new('DBNAME', 'DBUSER')
  c.query('SELECT 1+2') # => [["3"]]

Regards,

  Michael

oh neato. I'm glad someone made a pure ruby version.

Is there an rpa?

nope. maybe later, if it's better tested.

Regards,

  Michael

Maybe I'll throw it together then for batsman, I *love* postgres with a passion, and was going to use postgres as a backend for my project. I'm glad theres a pure ruby version, people hate compiling. Thanks a kilo Neumann

Ross

···

--
Hazzle free packages for Ruby?
RPA is available from http://www.rubyarchive.org/

That is the primary goal of RPA, but it doesn't exclude packaging more
libraries; in fact, some 150 libraries/applications have been packaged
so far, and many are not "production-level".
Quoting from http://rpa-base.rubyforge.org/wiki/wiki.cgi?Rpa_FAQ :

Will there be a repository for experimental packages or will all packages
need to fit the production requirements?

A (small) part of RPA will be declared suitable for production use
(i.e. mature, documented, tested). However, third party software that is
not ready for production will be packaged too, in a separate section of
the repository. You can compare that broadly to Debian's sections: there
will be a "production" section and another bigger one with everything else
(we have yet to decide on the names).

In other words, the requirements for "production quality" will be met by
the software declared production-ready by RPA (this will be a section
within RPA). Those requirements do not determine whether some software
will be packaged by RPA or not. Clearly, high quality software is more
likely to be packaged in RPA, but given enough resources (esp. manpower)
RPA could repackage most of the software currently listed in RAA.

···

On Fri, Nov 19, 2004 at 04:42:36PM +0900, David Garamond wrote:

David Ross wrote:
>Michael Neumann wrote:
>oh neato. I'm glad someone made a pure ruby version.

ditto here. a wonderful news. i think i'm going to try to use it on a
regular basis instead of the "postgres" C-based library, solely because
only postgres-pr is available as a gem (yes, i'm that lazy :-). i use
ruby on lots of machines...

>Is there an rpa?

i thought the purpose of RPA is as a collection of _production_-level
(mostly mature, stable, well tested) libraries?

--
Hassle-free packages for Ruby?
RPA is available from http://www.rubyarchive.org/

I'm looking forward to use postgres-pr with Og :wink:

You can count on that :slight_smile:

I 'll include postgres-pr support in the stand-alone Og
distribution (next week).

regards,
George

···

--
www.navel.gr | tel: +30 2106898050 | fax: +30 2106898437

web appliction engine: http://www.navel.gr/nitro
have fun: http://www.joy.gr

Michael;

Does this mean there is a new Postgres-PR release available for
download/update?

Also, I think the problems I'm having with a tutorial I'm working through
are related to Activerecord not communicating through PostgresPR... It looks
like it goes to it's connection_modules directory looking for a valid
postgres connector and the default postgres connector included with
Activerecord doesn't work for some reason. The precise error is below... but
I'm curious how I can ensure (what settings to check, file locations, etc)
that Activerecord can communicate to and through PostgresPR...?

RuntimeError in Todo#index

authentification failed

c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/connecti
on.rb:58:in `initialize'
c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/connecti
on.rb:32:in `loop'
c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/connecti
on.rb:32:in `initialize'
c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/connecti
on.rb:26:in `synchronize'
c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/connecti
on.rb:26:in `initialize'
c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/postgres
-compat.rb:22:in `new'
c:/cs/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.2.2/lib/postgres-pr/postgres
-compat.rb:22:in `initialize'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/conne
ction_adapters/postgresql_adapter.rb:34:in `connect'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/conne
ction_adapters/postgresql_adapter.rb:34:in `postgresql_connection'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/conne
ction_adapters/abstract_adapter.rb:140:in `send'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/conne
ction_adapters/abstract_adapter.rb:140:in `connection='
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/conne
ction_adapters/abstract_adapter.rb:104:in `retrieve_connection'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/base.
rb:172:in `connection'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/base.
rb:276:in `find_by_sql'
c:/cs/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1.0/lib/active_record/base.
rb:270:in `find_all'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/sca
ffolding.rb:103:in `list'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/sca
ffolding.rb:96:in `index'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/bas
e.rb:577:in `send'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/bas
e.rb:577:in `perform_action_without_filters'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/fil
ters.rb:236:in `perform_action_without_benchmark'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/ben
chmarking.rb:30:in `perform_action_without_rescue'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/ben
chmarking.rb:30:in `measure'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/ben
chmarking.rb:30:in `perform_action_without_rescue'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/res
cue.rb:68:in `perform_action'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/bas
e.rb:254:in `process'
c:/cs/ruby/lib/ruby/gems/1.8/gems/actionpack-0.9.5/lib/action_controller/bas
e.rb:242:in `process'
c:/cs/ruby/lib/ruby/gems/1.8/gems/rails-0.8.5/lib/dispatcher.rb:35:in
`dispatch'
/public/dispatch.rb:10
/public/dispatch.rb:1:in `load'
/public/dispatch.rb:1
-:7

···

-----Original Message-----
From: Michael Neumann [mailto:mneumann@ntecs.de]
Sent: Monday, November 29, 2004 5:57 AM
To: ruby-talk ML
Subject: Re: [ANN] postgres-pr (pure Ruby PostgreSQL)

Stu wrote:

On Fri, 19 Nov 2004 00:12:28 +0900, Michael Neumann > <mneumann@ntecs.de> wrote:

> gem install postgres-pr
> irb -r rubygems

Then in the interactive Ruby interpreter type (replace DBNAME and DBUSER
accordingly):

require 'postgres-pr/connection'
c = Connection.new('DBNAME', 'DBUSER')
c.query('SELECT 1+2') # => [["3"]]

Am having problems testing...

I added 0.2.2 via gem install method..

and following the above I get;

E:\ruby\code\postgres-test>irb -r rubygems
irb(main):001:0> require 'postgres-pr/connection'
=> true
irb(main):002:0> c = Connection.new('dbtest', 'sgeorge')
NameError: uninitialized constant Connection from (irb):2

I moved everything into the PostgresPR module.

   c = PostgresPR::Connection.new(...)

should work.

Rubygems does not automatically inlude Module's.

Regards,

   Michael

David Ross wrote:

Maybe I'll throw it together then for batsman, I *love* postgres with a passion, and was going to use postgres as a backend for my project. I'm glad theres a pure ruby version, people hate compiling. Thanks a kilo Neumann

btw, I quickly hacked up a compat-library, so that you can use the postgres-ActiveRecord adaptor. It thinks, it uses the C version of postgres (and indeed loads it if it's available).

I was to lazy to rewrite the whole adaptor...

Regards,

   Michael

Mauricio Fernández wrote:

i thought the purpose of RPA is as a collection of _production_-level (mostly mature, stable, well tested) libraries?

That is the primary goal of RPA, but it doesn't exclude packaging more
libraries; in fact, some 150 libraries/applications have been packaged
so far, and many are not "production-level".
Quoting from http://rpa-base.rubyforge.org/wiki/wiki.cgi?Rpa_FAQ :

I see. Thanks for the clear-up. Haven't had a chance to play with RPA.

So which between rubygems and RPA is more popular? Is there any indication of which one will be the "official" or "preferred" packaging system for Ruby in the future? Which one will become (or will be the closest to) the Ruby equivalent of CPAN? By that I mean I can find and install most Ruby libraries with it.

Ruby library writers, which one do you prefer or do you find easier to package your software with?

Regards,
dave

Abraham Vionas wrote:

Michael;

Does this mean there is a new Postgres-PR release available for
download/update?

You already have the newest version (0.2.2).

Also, I think the problems I'm having with a tutorial I'm working through
are related to Activerecord not communicating through PostgresPR...

No, it communicates through PostgresPR, I'm sure!

It looks like it goes to it's connection_modules directory looking for a valid
postgres connector and the default postgres connector included with
Activerecord doesn't work for some reason. The precise error is below... but
I'm curious how I can ensure (what settings to check, file locations, etc)
that Activerecord can communicate to and through PostgresPR...?

You don't have to setup anything.

RuntimeError in Todo#index

authentification failed

The problem is with authentification. You have either specified a wrong user/password combination for Postgres, or it's an authentification method that postgres-pr is not-yet capable of. Can you setup your Postgres-database to either use password-less or plain-text password authentification?

Regards,

   Michael

Michael Neumann wrote:

David Ross wrote:

Maybe I'll throw it together then for batsman, I *love* postgres with a passion, and was going to use postgres as a backend for my project. I'm glad theres a pure ruby version, people hate compiling. Thanks a kilo Neumann

btw, I quickly hacked up a compat-library, so that you can use the postgres-ActiveRecord adaptor. It thinks, it uses the C version of postgres (and indeed loads it if it's available).

it's now available as postgres-pr version 0.1.0. If you've installed this and ActiveRecord, it should work out-of-the-box.

Regards,

   Michael

>That is the primary goal of RPA, but it doesn't exclude packaging more
>libraries; in fact, some 150 libraries/applications have been packaged
>so far, and many are not "production-level".
>Quoting from http://rpa-base.rubyforge.org/wiki/wiki.cgi?Rpa_FAQ :

I see. Thanks for the clear-up. Haven't had a chance to play with RPA.

So which between rubygems and RPA is more popular?

RubyGems is more popular. The RubyGems team have made a great effort to
document and establish it as the Ruby standard for upstream releases.

Is there any indication of which one will be the "official" or
"preferred" packaging system for Ruby in the future?

One doesn't preclude the other. RubyGems' goal is expressed by its
RubyForge description:
"RubyGems is the Ruby standard for publishing and managing third party
  libraries."
(AFAIK there is no other mission statement or declaration of purposes)
In other words, RubyGems should become the preferred system for upstream
releases. This is fine because the RubyGems team have often expressed
their commitment to making RubyGems packages easy to repackage, so
hopefully it will improve the current situation; this hasn't happened
yet but RubyGems is still young.

The goals of RPA are expressed in our manifesto:
  http://rpa-base.rubyforge.org/wiki/wiki.cgi?RpaManifesto
The RPA project is larger and more ambitious than RubyGems; it's not
primarily about making other people package using our technology, but
about having the RPA packager team create and maintain the packages.

The analogy would be automake/autoconf vs. FreeBSD.

RPA happens to use its own packaging technology (rpa-base) because
RubyGems' one doesn't satisfy our requirements and there is some gain
in being able to change simultaneously the port/package manager and the
ports/packages. You can find more information about rpa-base and its
features at http://rpa-base.rubyforge.org/ .

Which one will become (or will be the closest to) the Ruby equivalent
of CPAN? By that I mean I can find and install most Ruby libraries
with it.

Currently, there are more libraries/applications packaged in RPA than in
RubyGems' repository. This should change eventually, since mere package
count is not a goal in itself for RPA: the fact that it still has more
packages than RubyGems' repository is a rather anomalous situation.

Note that neither RubyGems nor RPA try to mimic CPAN. In the case of RPA,
the main sources of inspiration are FreeBSD and Debian. However the idea
of having a repository is more central to RPA than to RubyGems: after
all, it's the Ruby Production *Archive*.

Ruby library writers, which one do you prefer or do you find easier to
package your software with?

In general, they should package using RubyGems or Aoki's setup.rb.
RPA packages are created by the RPA crew: the upstream developer needs
not do anything.

So the comparison would be creating the gemspec vs. doing nothing :wink:

If you're interested in RPA or its technology, feel free to join #RPA
at irc.freenode.net. A typical "rpafied install.rb" (most often the only
thing you need to create a RPA port) looks like

require 'rpa/install'

class Install_rcov < RPA::Install::FullInstaller
    name "rcov"
    version "0.0.2-2"
    classification Application.Devel
    description <<EOF
RPA's code coverage info and profiling overview generator

rcov allows the developer to identify unused regions of code. It is
especially useful when combined with unit tests, since it will indicate
which areas of the code can't possibly have been tested.

rcov can also gather some basic profiling information (how often a line
of code is run), allowing to locate the hotspots visually.
EOF
end

···

On Fri, Nov 19, 2004 at 08:55:28PM +0900, David Garamond wrote:

--
Hassle-free packages for Ruby?
RPA is available from http://www.rubyarchive.org/

I'm going to attempt to nip this one in the bud being that this will
have been the Nth (N being higher than 2) RubyGems vs. RPA thread on
ruby-talk. RubyGems and RPA are NOT an either/or question. RPA is
not a package manager. rpa-base is a package manager, with it's
primary goal being to support the needs of RPA.

RubyGems is only a package manager. Its goal is to become the
official package manager for Ruby libraries and applications. Most
gems are created by the original authors of these libraries or
applications. Most RPA packages are created by Mauricio Fernandez
(repackaged). RPA will eventually be QA'd by a team of people.
RubyGems are (officially) unpoliced--bazaar-style distribution (though
it would be possible to create a QA'd repository of gems, that's not
on our radar screen at the moment).

Ideally, RPA-ification of libraries will lead to RubyGems-friendliness
and vice versa.

···

On Fri, 19 Nov 2004 20:55:28 +0900, David Garamond <lists@zara.6.isreserved.com> wrote:

Mauricio Fernández wrote:
>>i thought the purpose of RPA is as a collection of _production_-level
>>(mostly mature, stable, well tested) libraries?
>
> That is the primary goal of RPA, but it doesn't exclude packaging more
> libraries; in fact, some 150 libraries/applications have been packaged
> so far, and many are not "production-level".
> Quoting from http://rpa-base.rubyforge.org/wiki/wiki.cgi?Rpa_FAQ :

I see. Thanks for the clear-up. Haven't had a chance to play with RPA.

So which between rubygems and RPA is more popular? Is there any
indication of which one will be the "official" or "preferred" packaging
system for Ruby in the future? Which one will become (or will be the
closest to) the Ruby equivalent of CPAN? By that I mean I can find and
install most Ruby libraries with it.

Ruby library writers, which one do you prefer or do you find easier to
package your software with?

--

Chad Fowler
http://chadfowler.com

http://rubygems.rubyforge.org (over 20,000 gems served!)

OH NO, you realize you're opening the proverbial can of worms, right? Last
time (if I recall correctly) things ended up with Gems vs. RPA'ers and at
each others throats.

Personally, I believe some of my recent difficulties getting a Rails
tutorial to work may be because I installed both RPA and Gems and then
allowed RPA to take ownership of Rails... I've also noticed that RPA will
redownload and install any dependencies for it's packages even if they
already exist on the users machine.

Regards, Abe

P.s. I like both methods. One thing that RPA has that Gems doesn't is the
ability to list (with a single line summary) all of the packages available
for download and install through RPA. While I understand that there's a lot
of methology differences between the two camps, from a user perspective both
seem to accomplish the same thing and do so very well.

···

-----Original Message-----
From: David Garamond [mailto:lists@zara.6.isreserved.com]
Sent: Friday, November 19, 2004 4:55 AM
To: ruby-talk ML
Subject: RPA vs rubygems (Re: [ANN] postgres-pr (pure Ruby PostgreSQL))

Mauricio Fernández wrote:

i thought the purpose of RPA is as a collection of _production_-level
(mostly mature, stable, well tested) libraries?

That is the primary goal of RPA, but it doesn't exclude packaging more
libraries; in fact, some 150 libraries/applications have been packaged
so far, and many are not "production-level".
Quoting from http://rpa-base.rubyforge.org/wiki/wiki.cgi?Rpa_FAQ :

I see. Thanks for the clear-up. Haven't had a chance to play with RPA.

So which between rubygems and RPA is more popular? Is there any indication
of which one will be the "official" or "preferred" packaging system for
Ruby in the future? Which one will become (or will be the closest to) the
Ruby equivalent of CPAN? By that I mean I can find and install most Ruby
libraries with it.

Ruby library writers, which one do you prefer or do you find easier to
package your software with?

Regards,
dave

Thanks for the response Michael!

I looked into the topics you suggested and I think I made some progress...
at least now I can see attempts to connect to the db in the postgresql log.
However, it says that my user names don't exist, when I know they exist
because I can see them from psql - and from PGAdmin III. Any ideas?

My entry in the database.yml is:

production:
  adapter: postgresql
  database: todo
  host: localhost
  port: 5432
  username: root

Errors in Postgresql log:

2004-11-29 19:49:02 FATAL: user "abrahamvionas_sr " does not exist
2004-11-29 19:57:59 FATAL: user "root " does not exist
2004-11-29 19:58:11 FATAL: user "root " does not exist

···

-----Original Message-----
From: Michael Neumann [mailto:mneumann@ntecs.de]
Sent: Monday, November 29, 2004 5:14 PM
To: ruby-talk ML
Subject: Re: [ANN] postgres-pr (pure Ruby PostgreSQL)

Abraham Vionas wrote:

Michael;

Does this mean there is a new Postgres-PR release available for
download/update?

You already have the newest version (0.2.2).

Also, I think the problems I'm having with a tutorial I'm working through
are related to Activerecord not communicating through PostgresPR...

No, it communicates through PostgresPR, I'm sure!

It looks like it goes to it's connection_modules directory looking for a

valid

postgres connector and the default postgres connector included with
Activerecord doesn't work for some reason. The precise error is below...

but

I'm curious how I can ensure (what settings to check, file locations, etc)
that Activerecord can communicate to and through PostgresPR...?

You don't have to setup anything.

RuntimeError in Todo#index

authentification failed

The problem is with authentification. You have either specified a wrong
user/password combination for Postgres, or it's an authentification
method that postgres-pr is not-yet capable of. Can you setup your
Postgres-database to either use password-less or plain-text password
authentification?

Regards,

   Michael