On Mon, Jul 7, 2008 at 2:18 PM, Ron [email protected] wrote:
Thanks for the info…I’m a developer first and foremost. I’m working
on a project that will require a large, high performance database. So
I want to start learning about database administration and pick up
some skills along the way.
Are there some books you would recommend for me to get started?
Something that would give me the background necessary to know that My-
SQL isn’t good?
If you are a developer first and foremost, I would go with PostgreSQL.
Postgres is really a fully featured database. It compares with Oracle
or MS SQLServer in it’s functionality and speed and really takes the
cake for it’s accessibility. All the docs are online and free and
easy to get to and the community is great and thriving.
Don’t get me wrong, Oracle has it’s place and I use it as well. It is
definitely the king in the DB world. But I found that my postgres
knowledge allowed me to pickup oracle very very quickly. SQLServer
was a piece of cake after Postgres.
The other nice thing about Postgres is that it is the only real RDBMS
that is supported by Rails out of the box. Which makes it really easy
to start off with.
To start learning SQL, I would recommend a site that I just went over
in one of my blog posts “Know your Fundamentals”, you can find the
article I refer to here http://philip.greenspun.com/sql/
Rails, RSpec and Life blog…