Re: PgSQL vs MySQL
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 site but they are significally less critical. After reviewing this and talking to some other people i'm switching over to postgresql. I'm sure there is a place with mysql but I don't think i'd trust it for anything critical unless you very confident your developers know what they are doing. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: PgSQL vs MySQL
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 (7 years as an Oracle DBA) that developers don't take the time to learn the intricacies of a particular database. So if you plan on using mysql, make all your developers read that gotcha's page. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: PgSQL vs MySQL
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 one of these files but I guess to do a point in time recovery you would delete all of the sql after that PIT. You could also possibly write a script to backup the data in individual tables by locking the table and then 'selecting' out the data like in mysql. Like I said, i'm not an expert in either mysql or postgresql and each dbms has its place.. Its just I would probably use postgresql for a more critical database. Actually, if the database is critical i'd be using oracle. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: oracle.
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 WHERE owner = 'YOUR NAME' If you want to see all the tables in the database use dba_tables but you'll need to be granted access to it. Dave From: Anil Garg [EMAIL PROTECTED] Date: 2003/03/17 Mon PM 12:34:32 EST To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Writing a database program in GNU C++ using MySQL.
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 you have to worry about a firewall then you can still use Java with Servlets but there will be an added learning curve. In that case your probably better off using PHP/JSP, etc From: Kamara Eric R-M [EMAIL PROTECTED] Date: 2003/01/30 Thu AM 07:34:58 EST To: Prabu Subroto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Writing a database program in GNU C++ using MySQL. Hi Prabu, From my own experience I'd say that PHP is the best option since it can be compiled with MySQL support and you will find that accessing the database is very easy. Regards, Eric On Wed, 29 Jan 2003, Prabu Subroto wrote: Dear my friends, My boss wants a database application running on linux machine without XWindows. Is it easy to make the connection to MySQL with GNU C++ . Is perl better then GNU C++ in this case? How is Jave ? TAC. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php