IBM Sets DB2 Database Free (Beer)

Anonymous Coward writes to tell us that in the hopes of winning more developer interest, IBM has released a free version of their DB2 database. From the article: "DB Express-C is the same database as IBM's commercial offerings but the company places limits on what kind of hardware it can run on. It can be deployed on systems with two processor cores or up to two dual-core chips on Advanced Micro Devices- or Intel-based servers. The memory limit is 4GB but there are no limits on the size of database or number of users. "

Comments

Question for/from the Inept

[eldavojohn]

*puts on his ragged and unused database admin hat*

*paints two large concentric circles on his chest, one inside the other*

*throws off his gloves ... and steps into the circle of death that is known as a Slashdot forum*

Alright, I run a MYSQL database at home for my little crappy web server which no one visits because pictures of me visiting Mexico isn't exactly worth typing a number into your browser. All those details aside, why should I switch to either Microsoft's SQL Server 2005, Oracle 10g or DB2?

I'm a huge MYSQL fan ... well, because I've enjoyed their stuff freely for quite some time. Suddenly, everyone (and their dog) is releasing their once-thousand-dollar database in a free and slightly inhibited form.

Why the hell should I even bother thinking about switching to these new databases? And, further more, it seems that most of these newly free databases are not intended for corporate use ... like DB2's memory limit and the castrations of the other databases ... so where do they belong? In the hands of small businesses? A company's "developer camp?"

And could you be so kind as to make the prior assumption that I know I'm an idiot so you don't need to tell me that. Just give me some nice hard facts that are easy to measurably prove one database has an advantage over another.

By the way, thanks ScuttleMonkey for clarifying that it's "free as in beer." Unfortunately it's only noon and now you've awakened my desire to get slammed over lunch.

Re:Question for/from the Inept

[iabervon]

The big databases seem to do better with tons of reads and writes. They also tend to have extensions that let you do things to make certain types of complicated queries a lot faster (such as "for each month, give me the number of rows with a date column in that month and the total of the value column, also the total number of rows, and the total of the value column. But only include rows where the owner column is this value.")

The reason that they're releasing free versions is for developers whose software is used by big companies. If you were working on software for some big company and the database companies didn't offer free versions, you couldn't provide a solution using an expensive database, because you wouldn't be able to test it without paying a lot of money that you won't want to. Then the big company doesn't have a reason to buy the expensive database, because their applications aren't tested with it and probably won't run any faster. When I was working for a company that made a web application intended to be deployed internally by big companies, we used half a dozen free copies of Oracle, and probably wouldn't have used Oracle if these hadn't been available. Of course, these free copies of Oracle were running on workstations and only dealing with example data, not real customer data, so, from Oracle's point of view, the weren't actually doing any database work.

I'm confused

[AKAImBatman]

How does this differ from the "Free" version they used to give away? I think I still have the install files sitting around somewhere for the 7.1 UDB install that I got off IBM's website. Did they stop offering a free version for awhile, then restart, or is this licensed a bit differently?

features

[MORTAR_COMBAT!]

does mysql do this:

http://www-128.ibm.com/developerworks/db2/library/ techarticle/dm-0511singh/

Scalable Software

[RevMike]

Why the hell should I even bother thinking about switching to these new databases? And, further more, it seems that most of these newly free databases are not intended for corporate use ... like DB2's memory limit and the castrations of the other databases ... so where do they belong? In the hands of small businesses? A company's "developer camp?"

First of all, the commercial database offerings are far more feature rich than MySQL, though MySQL is getting better all the time. MySQL is fabulous for the hobbyist and small business crowd, but won't be found as a core technology of a major investment bank or backing an SAP installation at a large manufacturer anytime soon.

So the benefit of these free commercial products is that developers can build systems based on these technologies, then scale them easily to both small businesses and large enterprises. No one will start running their self-hosted blog on DB2, but it is easy to build a software product which may target businesses of several different sizes, and using a consistent database engine for small business and large enterprises is useful.

Re:So ... why would I move from PostgreSQL to DB2?

[DARKFORCE123]

DB2 main attractiveness for being free is its feature set. PostgreSQL already has a well developed feature set for a 'free' offering so you may not get as much from it unlike if you migrated from MySQL. No offense to MySQL, but for now its claim to greatness is being 'free' and speed, not having a fully developed feature set.

Bottom line is that this free DB2 should be considered an evaulation kit for a larger deployment more than anything else since its way more than you need for a small system.

So what?

[Qbertino]

I don't want a free database. There are more full-range free databases out there than free full-range editors.

I want a free database + free zero hassle one stop installation + free zero database driver suckage + free native object-relational OSS PL support (and I mean Python and Ruby and PHP and Perl, all at the same time) + free full range plattform independent grafical admining + SQL errors that don't say "syntax error between line 3 and 10000" + a free full-range professional level grafical ER tool with reverse engineering of any DB I have to migrate to the DB they offer + free optional zero fuss, 3 config lines maximum load balancing.

Call me when you offer that and I'll be using DB2, Oracle or whatever within an instant.

Until then I'll stick to my current MySQL InnoDB stunts and my plans to migrate to Postgres or - as the case might be - Firebird. They are truly free and they got my attention. And if MySQL Workbench will be as cool as it looks I might even just not switch at all. Despite the fact that current MySQL still has way to go before becoming a full range database. MaxDB might change that - but we'll see.

Sorry folks but getting attention requires a tad more than just giving your DB away for free these days. And it's all your fault. Hadn't you asked such bizar prices in the first place things probably would look different today.