MySql? is a relational database management system (RDBMS).

It is small and fast. It lacks a lot of features that other databasen, noticably PostgreSql?, offer.

When should I use MySql??

When your primary concern is the speed of your SELECT queries. Even then PostgreSql? is getting much quicker at these.

When should I not use MySql??

When you think "It's only going to ever be a small web site...", and there's a chance it could grow into a big one. If at any point you think you might need to change to something else, start with that other system instead.

How can I lessen the impact of having to switch later on?

Use PearDB? in your PHP scripts.

(JARRING CHORD)

(The door flies open and Bill Gates of Microsoft enters, flanked by two junior cardinals. Steve Ballmer has goggles pushed over his forehead. Sam Palmisano (IBM) is just an idiot.)

Gates: NOBODY expects the InfoWorld Article! The chief thing missing from MySQL is subselects...subselects and views...views and subselects.... The two things missing are views and subselects...and triggers.... The three things missing are views, subselects and triggers...and an almost fanatical devotion to row-level transactions.... The four...no... Amongst the things missing from MySQL ...are such elements as views, subselects.... I'll come in again. (Exit and exeunt)