Rails 1.0 and MySQL 5.0 and postgres 8.1


#1

I want to convert my rails app to use either postgres 8.1 or MySQL 5.0
on any given day.
If all this is going to be built into rails 1.0 I can just wait and hope
that installing
rails will enable me to chose by simply migrating and editing my
database.yml file.

Or I can compile the C libraries now for ruby-MySQL and ruby-postgres
and hack around
trying to get them to work with rails 0.13 and all that.

Or download the year-old ruby-MySQL library for windows that works for
MySQL 4.0 but
probably not for 5.0 unless I keep to the old passwords:
http://seagecko.org/thoughts/in-the-past/2004/09/09/ruby-mysql-and-windows/

If 1.0 will do all this for me anyway I’d like to know, but can’t figure
it out from the
dev.rails.org website.

SO: What will 1.0 rails have as built-in database access, the windows C
libraries or the
old ruby libraries or new C libraries or what? Will it include .so
files for Windows XP?
Inquiring minds want to know.

AND: If I’m going to have to compile C code what is the latest and
greatest? I have cygwin
gcc 3.3.3 and MS vc7 (13.10.3077) and that should cover anything I need.

Things are running okay now with MySQL 5.0 and the old password system
and I don’t feel
like repeatedly messing about with database connections as 1.0 is coming
Real Soon Now and
I have enough to do…

Warren


#2

I have a compiled copy of the mysql-ruby 2.7 library for Windows if you
need it. I downloaded it from somewhere, can’t remember where. Send me
an email address and I can mail it to you.

Charles


#3

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Nov 21, 2005, at 7:59 AM, Warren S. wrote:

SO: What will 1.0 rails have as built-in database access, the
windows C libraries or the old ruby libraries or new C libraries or
what? Will it include .so files for Windows XP? Inquiring minds
want to know.

Rails 1.0 does not include any binary drivers.

Rails 1.0 comes with the ruby-mysql driver (that is, the pure-Ruby
mysql driver) version 0.2.6, patched to support the 4.1 protocol and
new-style password hashing. MySQL 5 uses the 4.1 protocol, so it
works too.

However, the mysql-ruby driver (confusing naming, I know) is faster,
better tested, and more compatible than ruby-mysql. It’s a C
extension for Ruby that binds to the mysql client library directly.

AND: If I’m going to have to compile C code what is the latest and
greatest? I have cygwin gcc 3.3.3 and MS vc7 (13.10.3077) and that
should cover anything I need.

The mysql-ruby driver is highly recommended.

We need to

  • compile mysql-ruby 2.7 on Windows
  • package it as a precompiled gem for Windows
  • This is vital for the health of Rails on Windows + MySQL *

Please, help!

jeremy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (Darwin)

iD8DBQFDggJoAQHALep9HFYRAsB4AJ9Z7VkHk4XExdTAStqT8ICZpNzUVgCfXbOI
M9CkxGeiHk8KweKm0OUdh/c=
=j+RT
-----END PGP SIGNATURE-----