I’ve been updating the computational analytics platform on my Wintel notebook the last few days. I’d fallen behind several versions on each of the main tools and decided to get them all back in synch at once. The good news for hackers like me is that there are so many freely-available, open source analytics products to choose from. The bad news is that it takes a focused effort to stay up to date on the latest largesse.

First up were the relational databases MySQL and PostgreSQL, along with the accompanying ODBC and JDBC drivers. Both are solid SQL’s capable of sourcing small to mid-sized analytics challenges with ease. Support is available from vendors Oracle and EnterpriseDB, respectively, for enterprise customers. For my work, both database installations and configurations were uneventful. Though I only tested the ODBC drivers, I was able to connect both to several front-end tools with no problems.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access