What advantages, besides ease of setup, does MySQL hold over PostgreSQL?
It would seem, to me, that the two are close competitors (both in
quality, and performance).
Are you sure about quality? Check out:
http://sql-info.de/mysql/gotchas.html
You can check out postgresql's on the same
Would you trust anything to developers who do not know what they are doing?
As a _novice_ developer I learned the noted aspects of MySQL: it's part of knowing
how the database works and how to use it, and not terribly sophisticated.
Then you may be a good developer but experience tells me
I do not approve or disapprove of your choice of Postgres over MySQL.
I don't profess to be a postgresql expert, i'm still learning about it.. but a quick
glance at the documentation tells me that the only option would be to use pg_dump
utility which creates a sql file. I haven't looked at
Some people have already mentioned the answer but forgot to mention one point. If
you do a
select owner, table_name from user_tables;
It will show you all the tables you have access to, not necessarily ones owned by you.
If you want to see tables you have created add a where clause
Accessing a DB via Java is very easy as well.. IMHO PHP and the like scripts are
over rated. You'll have much more flexibility with Java. (If you don't have to worry
about firewalls...) Since it sounds like you a C++ person you'll pick up on Java
quickly, if you don't know it already.
If