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
Sybase
Moderator: General Moderators
- AKA Panama Jack
- Forum Regular
- Posts: 878
- Joined: Mon Nov 14, 2005 4:21 pm
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.
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.
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
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
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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 costsanjanesh 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
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.