MySQL is a popular database, but if you want more power, you should also look at PostgreSQL, which is a more complete and standard RDBMS. It'll take quite a while for MySQL to catch up to PostgreSQL, if ever. Might as well start with a real full-featured database.
-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply. | [reply] |
I have a couple of why doesn't Postgres do this while MySQL does questions:
Why is there no unsigned option in Postgres?
The amount of space wasted in the database due to inflation of datatype sizes just because I can't use an unsigned integer for an index column and have to move up to the next size column.
Doubling the disk space used per each entry in a table, not to mention the possibilities of the column being indexed...
| [reply] |