[GENERAL] join table design question

Hi, I have tried two db designs and both can work but I wonder which one the db gurus would go with. This is a general db design question that has cropped up in a few situation. Here is the example I've been working on... In an online store, categories and images have a many-to-many relationship

[GENERAL] Moving from MySQL to PostgreSQL with Ruby on Rails.

Hi, I'm just new to the PostgreSQL world. I've been using MySQL but I want to develop a Ruby on Rails application that can be installed on either MySQL or PostgreSQL. I don't know how much the DDL dialects vary between them. At the moment I am interested in the options on a table like UTF-8. In My