MySQL, MySQL, and more MySQL. A love affair has grown with MySQL.... but what happened to PostgreSQL?
Inherent advantages exist with using PostgreSQL: subqueries, stored procedures, cursors and views among them. A feature-rich database. Let's not forget the time one wastes running REPAIR TABLE on larger databases with non-transactional MyISAM and transaction-capable InnoDB.
A MySQL vs. PostgreSQL debate could rage forever, and I see merits in arguments against PostgreSQL, but to the matter at hand. That tool mentioned earlier in this thread is actually recommended highly by all my Database-loving friends for said purpose. I personally would prefer to write something myself, as I never feel fully comfortable with someone else's GUI view forced down my throat.
Web-based is the way to go. Using local apps for a database application is on the same stupidity level as spending months bundling a firewall with a service pack for an os that doesn't work after months of singing its praises. A properly developed web-based app for handling a database can do the same job as a local app.
MySQL, MySQL, and more MySQL. A love affair has grown with MySQL.... but what happened to PostgreSQL?
Inherent advantages exist with using PostgreSQL: subqueries, stored procedures, cursors and views among them. A feature-rich database. Let's not forget the time one wastes running REPAIR TABLE on larger databases with non-transactional MyISAM and transaction-capable InnoDB.
A MySQL vs. PostgreSQL debate could rage forever, and I see merits in arguments against PostgreSQL, but to the matter at hand. That tool mentioned earlier in this thread is actually recommended highly by all my Database-loving friends for said purpose. I personally would prefer to write something myself, as I never feel fully comfortable with someone else's GUI view forced down my throat.
Web-based is the way to go. Using local apps for a database application is on the same stupidity level as spending months bundling a firewall with a service pack for an os that doesn't work after months of singing its praises. A properly developed web-based app for handling a database can do the same job as a local app.