Slashdot Mirror

That's funny.

First link searching "Sybase ASE Manual" on Bing: http://manuals.sybase.com/onli...

Searching for "IBM DB/2 LUW manual" yielded:

https://www-304.ibm.com/suppor...
https://www-304.ibm.com/suppor...
http://www.ibm.com/support/doc...

As the first three results.

Unless you're using a different Bing it seems what you claim is mostly bull.

Couldn't you make a column-based database that uses SQL as a query language?

Sybase IQ is column based and uses SQL.

I have no clue if this is important in this discussion, but SAP acquired Sybase earlier this year.

Oh, so you must mean an older version of Sybase, then.

It would be cost-prohibitive for a phone company to maintain connections to every company they want to exchange SMS with. Instead, they select one of the several companies that maintain inter-carrier messaging networks to deliver this traffic for them. These companies include VeriSign, Syniverse, and Sybase 365. Which carriers you can exchange SMS with depends on which of these vendors your carrier has selected. In general, while they all have two-way reach to the major carriers internationally, each vendor has a different profile of smaller international carriers and countries in their portfolio.

Sybase has separate database servers to do just that: ASE (Adaptive Server Enterprise - formerly SQL Server | row storage) for OLTP, IQ (Intelligent/Integrated Query - a competitor to Teradata | column storage) for data warehousing.

Sybase has separate database servers to do just that: ASE (Adaptive Server Enterprise - formerly SQL Server | row storage) for OLTP, IQ (Intelligent/Integrated Query - a competitor to Teradata | column storage) for data warehousing.

If the cost difference we're talking about here is simply the licensing/upgrading cost, it's worth noting that several of the popular "mega expensive" database platforms offer free (as in $0) versions - albeit with certain functionality removed.

Microsoft SQL Server 2005 Express Edition
Only supports databases up to 4GB, and is lacking the built-in task scheduler, and most of the high-availability and business intelligence features, but is perfectly usable for small-to-mid-sized applications/web sites. Plus you can upgrade later to one of the fancier versions if necessary.

Oracle 10g Express Edition
I haven't had a chance to play with this yet, but it looks similar to SQL Server Express in terms of features and limitations.

IBM DB2 Express-C
I don't really know anything about this one. I just now found it in a fit of "I wonder..." The product comparison pages don't really say much about it, but they'll send it to you free on a DVD, so that's pretty neat.

Sybase ASE Express
Never used this one either. It seems to be only for Linux.

Though honestly, from what I've seen of Postgre, I'd almost think that one would be worth looking into more so than these for small systems. One of these days I'll get around to experimenting with it. The advantage with the Express Editions is, however, that you don't have such a nasty learning curve if you can just jump right in with a database platform you're familiar with from at work. Why else would I do something insane like running php + MS SQL Server? :)

If I can get Sybase 12.5.x or Sybase 15 (the free ones for Linux) running on SLES 10 I will be all over this for a server.
Oh yea, and if anybody is wondering what the hell I am talking about - Sybase ASE 15 is free on Linux if you run a single CPU machine with other limitations (no more than 2G of physical memory allocated to the Sybase engine, and I think it limits the database size to 5G - but other than that no limits; you are even allowed to use it commercially last I checked.)

Actually, oracle 10g runs on os X, not just the client, but the full database, and JDeveloper/SQL Developer. Sybase ASE 12.5.3 and SQL Developer are also available. And Sam Pullara from BEA, who has been doing his dev work on a PowerBook for over a year now, has released his notes on how to do it.

I personally bought my first mac as a way to develop on the road without a network connection. I was working in PHP/MySQL/Apache on Linux and using Dreamweaver/Photoshop on a Windows machine at home. The mac replaced both the machines so well, that after a few months, I just stopped using the other machines. Now 3 years later, I only have macs in my home.

BTW, I am studying CompuSci at university, and thus far, no course has required any technology that is not readily available on my PowerBook G4. This platform really is the best of both worlds, easy enough for mom to use, but you can take it as far as you want, it is as powerfull a development machine as anyone could hope for. It has the perfect mix of opensource power and polished commercial apps that are not available on any other platform out there.

MS SQL Server is the only large scale database I know of that doesn't have a linux version. But that's hardly surprising since they don't seem to have any unix versions at all. (Hmmm... intriguing)

• http://www.sybase.com/linux
• http://www.borland.com/us/products/interbase/index .html

There are more than 2 unix databases commericially available.

MySQL as it now stands is probably the simplest real RDBMS for the casual shopper.

Actually, easy installation and great out-of-the-box performance has always been a hallmark of SQL Anywhere. Feel free to download the free developer edition yourself and see. (Yes, there are Linux and Unix versions available, not just Windows.)

MySQL as it now stands is probably the simplest real RDBMS for the casual shopper.

Actually, easy installation and great out-of-the-box performance has always been a hallmark of SQL Anywhere. Feel free to download the free developer edition yourself and see. (Yes, there are Linux and Unix versions available, not just Windows.)

As for the multi-platform support, I believe that was always one of Watcom's fortes, in addition to the fact that it was the compiler used for PowerBuilder, which runs on Unix, (multiplatform benefit, yeh?) although it was most popular on Windows in the client-server realm.

Actually, what's even more cool than an open source version of an *excellent* compiler is SciTech's work with x86 drivers, one of the companies supporting the open source version of Watcom. Speaking of OS/2, key thing IBM missed was providing good driver support, Microsoft made that a top focus. For Linux to be more competitive with Windows, this is a must.

But let me know when I can download thousands of pirated games that run on Mac OS X.

Also, someone please let him know when he can download thousands of anti-spyware/trojan/virus packages to run with his pirated games.

Or let me know when I can run SQL Server 2000 or something comparable in power and flexibility on Mac OS X.

Ummm... okay, here's Oracle for OS X. Or maybe you prefer Sybase Adaptive Enterprise Server? Or if you want something free, but enterprise quality there's PostgreSQL. Or something free, flexible and fast that's decent enough to power slashdot there's mysql.

SQL Server is decent for small to medium-sized databases, but you're not going to be handling tables mesured in gigabytes in SQL server like in sybase, db2, or oracle. Not unless Microsoft really puts a lot more work into SQL Server and the memory management of Windows itself.

Sybase offers its Express Edition for free, which you may call crippeled, since it permits only one CPU, 5GB of storage and a maximum of 2GB of RAM.

Else then that you are quite free to use it for whatever you want (including productive use) and - save for the documented limits - you get their flagship, enterprise product.

Support is extra, of course.

Disclaimer: I worked for Sybase until 1999, but have no more whatsoever interest in the company. It's a good database, though.

Sybase offers its Express Edition for free, which you may call crippeled, since it permits only one CPU, 5GB of storage and a maximum of 2GB of RAM.

Else then that you are quite free to use it for whatever you want (including productive use) and - save for the documented limits - you get their flagship, enterprise product.

Support is extra, of course.

Disclaimer: I worked for Sybase until 1999, but have no more whatsoever interest in the company. It's a good database, though.

Is it really fair to compare an open-source project, designed to compete with for-pay commercial products, with crippled versions of said commercial products?

For instance, the free "crippled" version of Sybase ASE is limited to 5GB of data, 2GB of RAM, and 1 CPU. These are pretty non-trivial limits given modern hardware and is more than adequate for many serious business applications.

(Note - some content cross posted from the recent MSSQL2005 posting I made)

I take issue with the number of tools.

Postgresql has a great variety of tools, both OSS and commercial that work great. I've been working on an updated list of all the tools. Here are a few of the most popular admin tools:

PGadminIII
http://www.sqlmanager.net/products/postgresql/mana ger [sqlmanager.net]

DBvisualizer
http://www.minq.se/products/dbvis/ [www.minq.se]

EMS Postgresql Manager
http://www.sqlmanager.net/products/postgresql/mana ger [sqlmanager.net]

PHPpgadmin
http://sourceforge.net/projects/phppgadmin [sourceforge.net]

Sybase Power Designer
http://www.sybase.com/products/enterprisemodeling/ powerdesigner [sybase.com]

ERWIN data modeller
http://www3.ca.com/Solutions/Product.asp?ID=260 [ca.com]

CASE Studio 2
http://www.casestudio.com/enu/default.aspx [casestudio.com]

Postgresql has a vibrant tool community. If you want more info on Postgresql tools see
http://techdocs.postgresql.org/v2/Guides/PostgreSQ L%20GUI%20Tools/document_view [postgresql.org]

"Free" versions of databases from Sybase:
Sybase ASE Express Edition for Linux
SQL Anywhere Studio Developer Edition

"Free" versions of databases from Sybase:
Sybase ASE Express Edition for Linux
SQL Anywhere Studio Developer Edition

This must be in satire, or ignorance.

Postgresql has a great variety of tools, both OSS and commercial that work great. I've been working on an updated list of all the tools. Here are a few of the most popular admin tools:

PGadminIII
http://www.sqlmanager.net/products/postgresql/mana ger

DBvisualizer
http://www.minq.se/products/dbvis/

EMS Postgresql Manager
http://www.sqlmanager.net/products/postgresql/mana ger

PHPpgadmin
http://sourceforge.net/projects/phppgadmin

Sybase Power Designer
http://www.sybase.com/products/enterprisemodeling/ powerdesigner

ERWIN data modeller
http://www3.ca.com/Solutions/Product.asp?ID=260

CASE Studio 2
http://www.casestudio.com/enu/default.aspx

Postgresql has a vibrant tool community. If you want more info on Postgresql tools see
http://techdocs.postgresql.org/v2/Guides/PostgreSQ L%20GUI%20Tools/document_view

Link to Sybase SQL Anywhere Developer Edition

Link to Sybase SQL Anywhere Developer Edition

In my opinion Oracle is one of the least trustworthy software vendors and I sure as hell wouldn't bank my company on them, regardless of the price they ask.

In my opinion Oracle is one of the least trustworthy software vendors and I sure as hell wouldn't bank my company on them, regardless of the price they ask.

Have you looked at Sybase Replication Server which allows low-latency, "realtime" replication of data between various DBMS platforms (Sybase, MSSQL, Oracle, DB2 etc). Might be useful in allowing you to spread the load for certain categories of data. It is certainly useful in a hot/warm redundant failover server scenario.

Sybase replication Server Home

Not to break your enthusiasm, but when you need an industry strength database engine Sybase can do better then that.

Their flagship product is available completely free of charge for the Linux platform.

Free as in beer that is and some restrictions apply:

• A maximum of 1 engine (CPU) configurable
• Maximum data storage of 5GB
• Maximum 2GB of total memory configured

And no, I don't work for them (since 1999), but still think it's a good product.

Not to break your enthusiasm, but when you need an industry strength database engine Sybase can do better then that.

Their flagship product is available completely free of charge for the Linux platform.

Free as in beer that is and some restrictions apply:

• A maximum of 1 engine (CPU) configurable
• Maximum data storage of 5GB
• Maximum 2GB of total memory configured

And no, I don't work for them (since 1999), but still think it's a good product.

> ...that OS X is simply not ready for enterprise-class server applications.
Huh? Not sure if I agree with you on that point:

JBoss
Sybase
Oracle
backup

That doesn't even cover directory services integration, messaging, development, file serving, and a slew of other applications...

If I advertised in LBN, I would be seriously pissed at having my products linked to this sort of gutter journalism. http://www.sybase.com/linuxpromo>Sybase & Linux Networx are you listening?

Do click those links folks, the traffic at least should start them wondering what's up.

Sybase and Linux Networx, when you read this: I hope that the exposure that you've had as a result of these links more than makes up for the traffic you would miss from LBN. Please pull your advertising from LBN.

IBM, I'm guessing you don't have a choice about advertising Websphere on the LBN site, since it's through Google but don't you think it's kind of ironic to be subsidising Ms O'Gara's salary?

It's worth noting that when I finally got the article, the advertisers for that story that popped up were Sybase, MedAbiliti, Yahoo hotjobs, and (drum roll...) Microsoft, who actually had TWO ads for Windows Server System.

Feel free to direct rage appropriately. I left out Microsoft because they probably don't care what we think anyway, and also yahoo because for the life of me I couldn't get their customer service contact info...

Most people worry that Blackbox software is a privacy concern. Coming from Microsoft, I believe it would be, but in general, I feel very strongly about black box software. Some black box software can go as far as trace the executable C or C++ code that is running and provide a step by step look at what the code was doing when, say, an error occured. When aprogrammer steps through it, they easily see the problem and can correct it. For support reps like me this is huge in correcting problems.

However, not all languages are supported by black boxes. I hope over time a black box software type comes out to support Powerbuilder, because this would make my life so much easier. I could have this black box running on the user's system and simply "trace" their activity. When a problem occurs, they send the log and I send to programmers.

This of course would leave me the rest of the day to read slashdot and take the occasional "how do I click a mouse" case ;)

To be fair, the creaming was sweetened with significant money, but I still regard them as a candidate for Microsofts famous kiss of death [TM] list.

you mean the source code that originally belonged to Sybase

Per-cpu licensing has been around a long time, and has been a retarded idea a long time. Hopefully, this will spell the death-knell for per-cpu licensing.

Licensing should be per-computer. Or possibly per-user in some cases. The number of cpus/cores in your computer shouldn't drive up the cost of the license.

Oracle, MS, et. al were able to get away with per-cpu licensing as long as the only really multi-cpu machines were corporate 'big-iron' that had 8 processors. But now that cpu makers are trying to shove multiple cores into the cpu, and multi-cpu systems are gradually becoming more mainstream, it's not gonna wash. Home users will never agree to pay microsoft $1200 for licensing an 8-cpu copy of windows for their 8-core computer.

Granted, the immediate thing in question, Oracle, isn't a home-user situation, but even companies are going to get fed up with it. If Oracle gets too greedy, companies may just choose from among a few other alternatives. And if they are really smart, and as long as it can do what they need, they might choose a free software database, like PostgreSQL or the ever-popular-on-slashdot MySQL.

How big is your dataset, per machine?
If you are talking 5G of data or less on a single box, realize that Sybase ASE 12.5 for Linux is free if you follow three rules (single CPU, 2G of RAM in the box (or less), 5G maximum for your database tables.)

It gets a little pricey (relatively speaking) if you want to exceed those - but it's a bad ass back-end for free if your data isn't likely to grow beyond 5G.

Sybase on Linux

It's not that big a deal, really. I wrote a custom web application framework for an iAnywhere product that did exactly what Rails is doing, but in Java. Basically it mapped the path in a request to a set of classes. The mapping was determined at runtime through reflection. Worked well, you could do some neat stuff using inner/nested classes. The parent always got first crack at a request, so it could do filtering before the child was called and also of the child's results.

The disadvantage of doing this stuff dynamically, of course, is that it takes more time to execute, so you have to do caching to simplify things.

For the curious, the details of what I did are available online in the product documentation. Eric

Database - Sybase ASE 12.5

If the box is
Running Linux
On one CPU
With 2G of RAM or less
And keeps the total database space to less than 5G

= free Sybase ASE 12.5
Sybase Linux Promo

You may want to have a look at a Sybase product called Replication Server, which permits you to distribute your data in near real time.

Even though it is not a simple product, setting up a warm standby is fairly straight forward and relatively simple. By setting up appropriate firewall rules you can ensure that the connection is in one direction only. As an added bonus you are better set up in case of a desaster.

The RDBMS in question need not to be Sybase ASE. It works fine with just about any major RDBMS. In fact: There are Sybase customers that use Rep Server in order to replicate from Oracle to Oracle, since Oracle "Replication" just plain sucks!

When will people learn that MySQL, while a useful toy, just can't compare to a real Enterprise-grade database running on real Enterprise-grade hardware?

ANd is Oracle and Sybase available on MacOSX?

Sybase Announces Availability of Enterprise RDBMS on MAC OS X Panther

Oracle Announces Plans to Make Oracle 10g Technology Available to Apple Developers. Oracle Database 10g Early Adopters Release 2 (10.1.0.3) for Apple Mac OS X

Sybase ASE: same original codebase as MSSQL Server
Oracle: most well-known database engine in the world
MySql: Most popular Open-Source database in the world
PostGres: Not my cup of tea, but its an option
DB2: IBM's DB2... SuSE and RedHat only

I always shudder at the thought of running a database engine on Windows...

Sybase has a command on the platforms that support it that affinities a sybase server engine process to a CPU, I use it on Solaris all the time and I watch mpstat going on and on with only a few context switches per minute.
In sybase 11.9.X :
dbcc tune(cpuaffinity, 1, "on")

The whitepaper covers some of these topics: Optimizing Sybase on Linux
and the poster of the system tables helps see the layout of some of the internals.

Sybase has a command on the platforms that support it that affinities a sybase server engine process to a CPU, I use it on Solaris all the time and I watch mpstat going on and on with only a few context switches per minute.
In sybase 11.9.X :
dbcc tune(cpuaffinity, 1, "on")

The whitepaper covers some of these topics: Optimizing Sybase on Linux
and the poster of the system tables helps see the layout of some of the internals.

I'd like to know in terms of things just broken enough to make finding them absolute hell.

Sybase 11.0.3.3 was (and still is) free for production use on Linux and FreeBSD.

Okay, I have to comment on this. First, You've been able to download and play with a *serious* database for some time now.

Is everyone else getting this page when downloading it in Mozilla?

http://crm.sybase.com/sybase/www/sybsurveyerror.js p?error=Sorry%2C+the+system+is+unable+to+process+y our+survey+submission%3A+%0ARule+Evaluation+error+ invoking+RA_SetOpportunityOwner2%28%29%3A+java.lan g.NullPointerException

What a bummer.

Oh what, you mean PowerBuilder?

Yes, it exists. Yes, it's on par with Access. But it's also a pile of shit and if I catch you using it, I'll punch you in the neck. Bad PowerBuilder apps make bad Access apps look like fucking Photoshop. I'm dealing with one right now that has a function which pops up a grey box with the top half of an OK button in it. Clicking the OK button crashes the machine. What the fuck kind of RAD tool lets you build faster, buggier interfaces?

Get you a C# book and start reading. I understand the desire for lightweight database access...but you're better off with the flexibility of DataBinding in ADO.NET (and most of the db tools in the .NET GUI are pretty good...we had a developer who didn't know SQL and he did all his stuff in the IDE, it was almost as good as what I'd write as a 5 year Transact "veteran").