|Dec 21, 2008, 01:41 PM||#1|
DB2 Beta Released for OS X
Don't expect this to be considered a major news item, but for anyone interested in databases, and there should be a few on this forum, IBM have (finally and long last after many years of hints and suggestions) released 9.5.2 Express-C for OS X.
It is 64-Bit, Intel Leopard only. Installation doesn't seem straightforward at the moment, certainly not up to Linux or Windows installers (haven't installed yet, hope to sort it out over Christmas break). Don't expect anything along the lines of the MySQL ease of use and set-up for the time being, it is very much along the lines of "OS X is UNIX", not "OS X is a user-friendly OS".
This is the free version and currently a beta release - it is only really good for development and only time will tell if IBM go the full server route. I am just happy to see tangible progress made to support OS X as development platform.
Anyway, thought people might be interested.
Last edited by AlmostThere; Dec 21, 2008 at 01:42 PM. Reason: Add link
|Dec 22, 2008, 03:56 PM||#3|
Well, installation is not without a few hiccups, you need to create or edit /etc/sysctl.conf with this content:
It isn't entirely clear which tools are included - as far as I can see it is simply the database server, and not the administration server or management client software. This is clearly a beta release.
On the other hand, this is more than enough to build and develop with, especially since deployment will be on Windows / Linux. I will try and get some stuff running on this over the next few weeks and see how it fairs with some data, especially compared to parallels.
(There is a thread on this on the DB2 support forums, apparently more documentation will follow).
Last edited by AlmostThere; Dec 22, 2008 at 04:10 PM.
|Jun 30, 2009, 02:59 PM||#6|
For me it has been running fine. I am using it to store sampled data so I can work away from the office to a certain extent, and almost exclusively in Java / shell.
I haven't used to CLI from c/c++, PHP, Ruby or Python bindings (I believe these are all working though). I would like to see if there is a way to get an ODBC connection working for Excel but I have been too busy to look into this.
More than anything, I am aggregating and sorting data. In terms of general performance, my core data sets range between 5 and 10 million records, which are grouped and aggregated by an unindexed field in ~20 seconds (with Java data IDE and Java development IDE running on my work 2.x Ghz MBP with 2Gb RAM). Joining the same query to a dimension table with ~5 million records drives this up to ~5 mins (depends on indexes, result set ~0.5m records). All the olap functions I use on a regular basis are present.
Downside - there doesn't seem to be any sort of real management software (as on Windows and other Unix) so all table stats need to be generated manually / cron-ed, same goes for data transfer. I needed to create a launchd job to start it off on booting.
Defaults parameters needed tweaking (log file size, buffer pools etc.) and almost certainly some performance improvements can be found but I am not going to spend too much time DBA-ing.
It is miles better than SQL Server (or anything) on Parallels, though, which tended to balk at anything more than a few K rows (obviously disk access horrendous). I am not holding out hope for MS to port SQLS to the Mac ... although they would make me very happy if they did.
It has been a while since I tried to get MySQL doing anything similar (was very unhappy with anything 1 million rows and really seems happier as a web DB rather than for any sort of number crunching not to mention the weird syntax, although i confess I know much less about improving MySQL performance) and have never tried Oracle on OS X - I was rather under the impression it had been largely abandoned and is the about the one DBMS we don't have at work.
Overall, there is quite a bit of overhead but it by far the best DB I have found, for me, on a Mac.
|Jun 30, 2009, 05:20 PM||#7|
I gave up on MySQL pretty quickly and MSSQL is obviously out of the question and from looking at pricing DB2 seems quite reasonable for a small single user license. Oracle is obviously too expensive and I am not even sure if it is the best bet really for what I want to do anyway.
Neural Advance - Mac OS X, UNIX and Windows Development
Last.fm Profile | Extreme Metal Reviews
MP 4x 2.66Ghz Xeons / 6GB RAM / 640GB + 500GB + 750GB + 1TB HDDs / ATI Radeon 4870 / iPad 3
|Jul 1, 2009, 03:21 PM||#8|
pgAdmin III has its quirks (double click opening property pages bugs me), but it generally works well. I believe there is a postgres package for OS X that makes it easy to install -- I used it ages ago to first get started -- but now I build my own executable and run it on-demand from the command line. If I quickly need a proper server a fire up a new virtual Ubuntu server and it's ready to go in 10 minutes or less.
By the way, MySQL isn't that bad. I'm not its biggest fan, but I'm coming round to it. Also, I was always under the impression that DB2 was similarly priced to Oracle, but that could have changed since I last looked in to it.
|Jul 1, 2009, 04:41 PM||#9|
We only have Postgres in some web apps but the just released 8.4 http://www.postgresql.org/about/news.1108 looks like it has a very good range of olap functionality. From my point of view, it is really a matter of time and compatibility with the applicable servers. That and it takes years to get to really know a dbms.
DB2 comes in several versions:
Express-C is the free version, limited to RAM and CPUs, and the version available on OS X.
Express, Workgroup and Enterprise allow increasing scalability and features for HADR and management software. I forget exactly what is included with what. The is also a Data Warehouse version, including data mining and a whole host of analysis / BI stuff (a bit like MS Analysis Services) and development tools (presumably to suck you into buying the pricey Rational tools).
It depend on which version suits your needs.
Pricing runs the full gamut, too Spend as little or as much you like.
OS X is not supported as a server ... I am sure IBM will sell you a z-series, though
There are some good introductory postings on http://antoniocangiano.com/ and he was, until recently, a Mac user too.
Last edited by AlmostThere; Jul 1, 2009 at 04:47 PM. Reason: Added link
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|iPhone: IntelliscreenX 7 Beta Released||Alonso Quijano||Jailbreaks and iOS Hacks||170||Mar 18, 2014 03:57 PM|
|ETA on 7.0.5 since Beta 3 got released today.||chillenandy321||iOS 7||10||Jan 7, 2014 03:31 PM|
|General: iOS 7 GM to be released 02/09/13 as beta ends?||Risco||iOS 7||69||Sep 4, 2013 02:41 PM|
|iOS 7 Beta 6 released!||geneticfusion||iOS 7||121||Aug 15, 2013 11:32 PM|
|When will iOS 6.1 beta 2 be released?||mattburley7||iOS 6||30||Nov 14, 2012 09:13 PM|
All times are GMT -5. The time now is 04:29 AM.