# Rails 1.0 and MySQL 5.0 and postgres 8.1 **URL:** \ **Category:** Rails\ **Created:** [November 21, 2005, 5:00pm UTC](https://www.ruby-forum.com/t/rails-1-0-and-mysql-5-0-and-postgres-8-1/49112 "2005-11-21T17:00:18Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![warrens](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/bc79bd/32.png) [@warrens](https://www.ruby-forum.com/u/warrens)\ **Post date:** [November 21, 2005, 5:00pm UTC](https://www.ruby-forum.com/t/rails-1-0-and-mysql-5-0-and-postgres-8-1/49112/1 "2005-11-21T17:00:18Z")
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/](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](http://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 ---
**Author:** ![warrens](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/bc79bd/32.png) [@warrens](https://www.ruby-forum.com/u/warrens)\ **Post date:** [November 21, 2005, 7:58pm UTC](https://www.ruby-forum.com/t/rails-1-0-and-mysql-5-0-and-postgres-8-1/49112/2 "2005-11-21T19:58:00Z")
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 ---
**Author:** ![warrens](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/bc79bd/32.png) [@warrens](https://www.ruby-forum.com/u/warrens)\ **Post date:** [November 21, 2005, 6:25pm UTC](https://www.ruby-forum.com/t/rails-1-0-and-mysql-5-0-and-postgres-8-1/49112/3 "2005-11-21T18:25:20Z")
-----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-----