Slashdot Log In
IBM Sets DB2 Database Free (Beer)
Posted by
ScuttleMonkey
on Mon Jan 30, 2006 12:04 PM
from the not-as-in-speech dept.
from the not-as-in-speech dept.
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. "
This discussion has been archived.
No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Full
Abbreviated
Hidden
Loading... please wait.
Question for/from the Inept (Score:5, Interesting)
*paints two large concentric circles on his chest, one inside the other*
*throws off his gloves
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
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
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.
self taught learning? (Score:4, Insightful)
Parent
Re:Question for/from the Inept (Score:5, Funny)
You are underestimating the slashdot crowd. Try posting a link to your website here.
Parent
Re:Question for/from the Inept (Score:5, Funny)
Wait a minute
Parent
Re:Question for/from the Inept (Score:3, Insightful)
Let them use it, and they will come.
features (Score:5, Interesting)
http://www-128.ibm.com/developerworks/db2/library
Parent
Re:features (Score:5, Funny)
Parent
Re:features (Score:3, Informative)
*Braces for attack*
thankfully, not (Score:3, Insightful)
Re:features (Score:5, Informative)
Here are the major differences between commercial databases I've used, all offer a free "express" edition:
I know I may have missed some major issues that I'm not aware of, so feel free to add to this.
Parent
Re:features - Postgresql replication (Score:3, Informative)
Re:No, mysql does not jail you with proprietarisms (Score:3, Informative)
select * from mytable limit 4,10
Re:Question for/from the Inept (Score:5, Insightful)
Parent
Re:Question for/from the Inept (Score:3, Insightful)
Re:Question for/from the Inept (Score:5, Informative)
You shouldn't. In fact, it's mildly surprising you're even bothering with a database.
You should download the big databases if you fit in any of the following categories:
1) You need to develop against or evalute the database.
2) You need to learn the database to increase your marketable skills.
3) You happen to run a high-traffic site and you need features not found in PostgreSQL.
4) You run a site that you expect to grow in traffic and want the option of upgrading to a more powerful version of the software at a later date.
I'm sure that others can find one or two more cases under which these DBs would be useful.
Parent
Re:Question for/from the Inept (Score:5, Informative)
Parent
Re:Question for/from the Inept (Score:3, Insightful)
developers,developers,developers (Score:5, Informative)
So all companies are releasing a "playful developer edition" of their tools, so that developers learn their stuff, play with it,and when they do a serious project, they will ask their boss to buy tool X because it's what they know.
To directly answer your question: you don't have a reason to replace MySql on your site where you post mexico photos. But IBM wants other people to use DB/2 on their personal sites/apps so that they get the habit of using it elsewhere.
Parent
Scalable Software (Score:4, Interesting)
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.
Parent
Re:Question for/from the Inept (Score:2)
Funny, Paris Hilton [t-online.de] told me the exact same thing last week after just 2 bites in to my lunch at Spago.
MOD PARENT REDUNDANT (Score:5, Funny)
Parent
Re:Question for/from the Inept (Score:5, Informative)
DB2 is arguably the most scalable RDBMS out there. It was some time ago but when I worked for Tivoli we kicked out some benchmarks and the story was basically that SQL Server (basically Sybase 10 back then) was fastest but least scalable, oracle was slower but much more scalable, and DB2 was slowest but by far most scalable, basically never slowing down any measurable amount no matter how much data you stuffed into it.
Whether this is the current state of affairs, I can't say.
Personally I'm a postgres fan but I'm using mysql for fiddling around with drupal because the mysql support is exceptionally poor. Most all the modules have schema information only for mysql, and sure you can translate it over, but some things won't work quite reliably in all cases. So the answer, as usual, is that you should run the platform supported by your applications.
Parent
Re:Question for/from the Inept (Score:5, Insightful)
For people that do not understand scalability versus performance, let's put it like this:
MySQL is fast for one user and PostgreSQL, while fast for one user, tends to be slightly slower than MySQL. On the other hand, add a hundred concurrent, mixed operation (aka, not read only) users and MySQL tends to go belly up. At the same time, given the same example, PostgreSQL is happily chugging along; albiet at increased latencies. Of course, this statement is broad and makes many assumptions, but it will hopefully help others understand the concept.
So, given your rankings above, PostgreSQL, tends to find a middle ground between Oracle's performance/scalability ranking. In other words, PostgreSQL tends to scale less than Oracle yet tends to perform better. MySQL, on the other hand, performs fairly fast for read-only databases but scales very poorly.
Parent
Re:Question for/from the Inept (Score:3, Interesting)
performance/scalability ranking.
> In other words, PostgreSQL tends to scale less than Oracle yet tends to perform better.
While I agree with your definitions of scaleability & performance, what would lead you to the above conclusion?
Both postgresql and mysql lack query parallelism, fine memory tuning, any kind of partitioning, etc. Without these features postgresql is *at best* only faster than oracle on ind
Re:Question for/from the Inept (Score:4, Interesting)
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.
Parent
Why the hell not? (Score:3, Insightful)
If MySQL works for you and you don't need anything else and don't want to learn anything keep MySQL.
Now for the reason you would.
Want to learn how to use DB2?
Want a really heavy duty ACID compliant Database server?
The limits on DB2 are... TINY I mean even in a good sized company a 4 gig ram limit and two core limit is unlikely to cause you issues.
This is to target MS-SQL not MySQL. If you dev
I'm confused (Score:4, Interesting)
Re:I'm confused (Score:2)
Re:I'm confused (Score:2)
All I can think of was that the free developer versions went away with version 8.0, and haven't been replaced until now.
Re:It's a trial copy (Score:3, Informative)
Nope, I'm talking about the Personal Development Edition [ibm.com]. (I looked it up.
Ah! (Score:3, Funny)
Re:I'm confused (Score:5, Informative)
The "Free" version that they used to give away was for development use. You couldn't use that version on your production system. At least thats how I remember it. I was playing around with it and decided not to install it because of that limitation.
With this new version, it can be used on small production enviroments also. This makes it a lot appealing because of the starting costs of development and moving to production.
Parent
Free (Beer) (Score:5, Funny)
Downside (Score:2, Funny)
Toes, now feet in the water (Score:3, Interesting)
Now, IBM, when will you offer either a 'naked' Thinkpad, or one that comes preinstalled with Linux (or FreeBSD) for us who want a real workstation?
Re:Toes, now feet in the water (Score:4, Informative)
IBM no longer produces the Thinkpad, Lenovo does.
Parent
OK - I'll bite - the 2 proc limit is significant (Score:3, Interesting)
A little too late? (Score:5, Insightful)
"Migrate Now! for DB2 Universal Database (UDB) facilitates the migration from Oracle, Sybase, Microsoft SQL server, and additional database platforms to DB2 UDB at a special price. Migrate Now! is an end-to-end offering that includes migration tool kits, no-charge online education, sales teams and resources to assist you in planning and implementing your migration based on IBM's proven methodology."
I think it falls directly in step with IBM's shift in strategy - lower the software cost and generate service based revenues. I don't think I'll be moving my stuff over anytime soon. Oracle on the data warehouse (the app was built before mysql could do cross table updates), mysql on the select only local repository.
IBM may be too late for the vast majority of developers. The ones that offered their products to develop and learn on are the ones that will find some sort of loyalty.
'DB Express-C' available on multiple platforms (Score:5, Informative)
A quick search of IBM's site reveals the links to download DB Express-C [ibm.com]. (Registration is required.)
Since no one
Communism! (Score:4, Funny)
I'm sure Sam Palmisano has one of this posters [maebmij.org] in his office.
So what? (Score:4, Interesting)
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.
Scalability and windows commentary (Score:3, Informative)
I am interested in all of these free editions for my web projects because it seems like it offers simpler scalability than MySQL down the road. Most high-end web developers--which I certainly am not--often end up having to find ways to get off of MySql as the site grows. Am I the only one who likes the idea of these scalable databases that I can buy later on?
On the other hand, if you're on Windows, it seems like MSSQL 2005 is your clear choice. It surprises me that any of these companies are bothering to compete against Microsoft there. It's beautifully integrated into the Visual Studio IDE, as well as offers
Wow. No user limits or db size limits? (Score:4, Insightful)
Of course it is. Do the logic (Score:3, Insightful)
The logic is exemplary. Microsoft has a lot of SME installations of MSSQL, and they hope that some will become big installations and by then they will have figured out how to do big iron. So IBM says to the SME "come to us instead and no matter how fast you grow your investment in software will never be obsolete. Hey, worried ab
Most people don't need this. (Score:3, Informative)
One word...OS/2 (Score:3, Insightful)
The best reason to get it (I already did) (Score:3, Interesting)
I can throw this on my laptop, and try out some ODBC stuff as well which is going to come down the pike from the development side of the house.
Re:So ... why would I move from PostgreSQL to DB2? (Score:4, Funny)
Plenty of headaches? Bragging rights? Optional corporate (un)support? Good karma? Ability to "fight the man" by "being the man"? (You 'da man?)
See? Lots of reasons!
Parent
Re:So ... why would I move from PostgreSQL to DB2? (Score:5, Interesting)
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.
Parent
Re:IBM Undercutting Itself? (Score:4, Insightful)
If your database is mostly used on commodity, low-end hardware, you can't give away a version that runs on a quad-core, 4GB machine: that's eating into your home market. IBM can, because a lot of their revenue (I'm guessing) comes from machines much further up the specification ladder than that. In fact, they would love you to run DB/2 on a high end machine, because the sooner you do, the sooner you'll make use of it, and probably the sooner you'll find its limits. (Following the general rule that software expands to fill whatever resources you allocate to it.) And when you hit the limits of the commodity/low-end hardware, IBM would be more than happy to help you migrate your DB/2 install into something a little sweeter. For a price, naturally.
Also, since they're last to the free-version game, they want to one-up everyone else. Simple competition.
Anyway, I think the "spec creep" is a good thing for consumers, both IBM's and otherwise, because it might cause a 'free version war,' that can only be a good thing in the end.
Parent