Hi Virusim,
There is another Open Source database that run under Linux called postgres. If you select a full install of RedHat Linux, postgres will be installed and ready to go. I switched over to Postgres about three or four year ago. Something about postgres just gave me a feeling of having more power at my finger tips.
MySQL is a good database for use on the web where it is only being accessed by two or three people at a time in a read only mode. When the number of concerrent users increase, and there is alot of writing to the backend, postgres is better for this kind of heavy lifting. Performance wise Postgres is comparable to MSSQL and possible a little faster. Postgres has long had feature that MySQL has only recently introduced. Postgres support functions, triggers, referential integrity, stored procedure which can be written in many different programming languages including SQL/PL. Here are the limitation of Postgres:
Limitations of PostgreSQL
Maximum size for a database unlimited (60GB databases exist)
Maximum size for a table 64 TB on all operating systems
Maximum size for a row unlimited in 7.1 and later
Maximum size for a field 1GB in 7.1 and later
Maximum number of rows in a table unlimited
Maximum number of columns in a table 1600
Maximum number of indexes on a table unlimited
The number of fields supported may need to be reduced depending on each field's length.
Linux is a good platfore for Postgres. You can allocate as much memory as you like to postgres depending on how much memory is availble in a system, so that a database could exist solely in memory reducing the need to access the hard drive. Some operating system limit that amount of memory that can be allocated, like Apple only allow a maximum of three megs.
Visual FoxPro, with its fast database engine, ability to work with cursors, and rich programming language, make it an execellent choice as a front-end application platform for a backend postgres database. Visual FoxPro is MS Windows Platform dependent so you would need to maintain a MS Windows presents if you go with Visual FoxPro.