Sybase

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Sybase

Post by anjanesh »

Hi

I recently noticed in phpinfo(); that many hosts support sybase.
Just wanted to know if its any better than using MySQL. Is it ?
PostgreSQL has more features and functions than MySQL (3.x and 4.x) but not all hosts seem to have it. But recently I found out that many hosts are supporting Sybase but theres no talk of it.

Would Sybase be a better option than MySQL ?

Thanks
User avatar
AKA Panama Jack
Forum Regular
Posts: 878
Joined: Mon Nov 14, 2005 4:21 pm

Post by AKA Panama Jack »

Since I started developing ADOdb Lite 6 months ago I have had the dubious pleasure of testing many different databases and quite frankly I don't see any real improvement in features, scalability or speed in them over Mysql. BTW, you do know that Googles search engine uses Mysql and that should tell you something.

You might want to give Sybase a try and see if it is worth it but since it isn't that prevalent on hosts you might want to stick with Mysql if you want better portability.

And don't get me started on Postgres and SQLite. They really are a pain to use if you are familier with using Mysql because there are so many things missing that you may be used to using. You usually have to jump through hoops with more complex queries or extra queries using those databases than with Mysql. Plus the later versions of MySql 4 and Mysql 5 include just about everything some people have been wanting like stored proceedures.

But honestly I have been testing a number of databases and Mysql always comes out on top when it comes to features, speed and scalability so you might want to stick with it unless you are going to be changing jobs and working at a company that uses something different.

Oh, and any host still using Mysql 3 needs to be soundly slapped as it really is a feature lacking and slow version of Mysql.
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

Thanks for your input. BTW, I hear most of the time that MS SQL Server is the most robust one of all.
Of course its not supported on Linux but remote access to MS SQL Server.
And what abt Oracle ? Its considered the strongest and fastest and even has a free Linux version (I think) - why aren't hosts using Oracle ?

Thanks
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

anjanesh wrote:Thanks for your input. BTW, I hear most of the time that MS SQL Server is the most robust one of all.
Of course its not supported on Linux but remote access to MS SQL Server.
And what abt Oracle ? Its considered the strongest and fastest and even has a free Linux version (I think) - why aren't hosts using Oracle ?

Thanks
Oracle doesn't have a free linux version. If you want to test/develop with then yes there's a free license. If howver you're using it commercially you have to pay to costs ;)

I'm in the same boat in terms of trying a few other DBMS's although Sybase isn't something I'm in a hurry to look at... I'm looking more at the heavily used ones (namely PgSQL and Oracle).

Personally I'm quite liking PgSQL... If I write SQL that's following the standards more it makes my apps much more portable, to the point I could simply switch my Database access layer for another one without disruption to my application.

I've heard from more than a handful of people the MSSQL is awful if you're used to standards.... although I do believe it has a huge feature set.
Post Reply