Sybase Adaptive Server Enterprise a steal

Sybase Adaptive Server Enterprise a steal

Before I go any further, I'll spare you the suspense: yes, Sybase is letting Linux users run Sybase Adaptive Server Enterprise (ASE) 11.0.3 for Linux, for free. No restrictions, no tricky licence, no catch. The only requirements are that you run it on Linux and don't try to make it work on any other operating system, and you don't go public with performance benchmark results.

I suppose there is a catch: you can't get this from Sybase. But Linux vendors Red Hat and Caldera include Sybase ASE with their latest releases. And you can download Sybase ASE from Red Hat's and Caldera's Web sites.

Ever the sceptic, I expected the free Linux version of Sybase ASE to be somehow crippled, lamed by its maker so it wouldn't compete with Sybase's other products. In fact, the only thing you can take away from Sybase ASE for Linux is that its version, 11.0.3, is not what Sybase is shipping to paying customers. This is small potatoes considering this database manager is the real deal. Highly optimised, extraordinarily powerful, thoroughly documented, mature, and bulletproof. In the server realm at least, this is Linux's killer application.

I chose an unusual method to test Sybase ASE for Linux. In my lab, I'm running Microsoft SQL Server 6.5, a database manager that has its foundations in Sybase code. I wired Sybase ASE for Linux, running under Red Hat Linux 5.2, together with my Windows NT Server system. I wanted to see how close I could get to replacing an existing Microsoft SQL Server back end with Sybase ASE. The most I hoped for was that I would learn a lot about Sybase's product.

It wasn't a total success - Microsoft's graphical SQL Enterprise Manager won't talk to Sybase ASE - but Microsoft's standard SQL Server ODBC driver worked flawlessly. I was able to use Active Server Pages, Visual C++, and Visual InterDev to build database-aware applications and communicate with Sybase ASE for Linux without difficulty. Microsoft's driver knows it is talking to an older SQL Server, so graphical design aids and other new features are disabled. Yet it does access database schema information, perform queries, and return result sets (called recordsets) with alacrity remarkably close to that of Microsoft's costly database.

How seriously should you take Sybase ASE for Linux? Very. It suffers only minor limitations. In my tests, I was unable to allocate more than approximately 50MB of RAM to it. Sybase ASE supports raw-mode disk access, a feature that I did not have time to exercise. Sybase does not support this product nor supply the source code. Fixes will be offered at their discretion.

Support in the Linux community, however, particularly in Usenet newsgroups (alt.linux.* and comp.os.linux.*) should be strong.

Sybase ASE is the most powerful commercial application ever ported to Linux. This is a big-league database with all its features intact. Developers and webmasters on a budget will get unmatched bang for the buck using Sybase ASE as their back ends. Sybase has, with one magnanimous gesture, given life to Linux as a database server.

The Bottom Line

Sybase Adaptive Server Enterprise 11.0.3 for LinuxSybase's database for Linux is a commercial, multiuser SQL database server. This product's value is so high that it's a steal.

Pros: Feature-rich; optimised; mature; well-documented.

Cons: Linux's lacklustre disk speed.

Platforms: Intel PCs.

Price: Free of charge, no user limits.

Red Hat Software

Caldera Systems

Follow Us

Join the newsletter!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.


Show Comments