Choosing MySQL vs PostgreSQL

There is a great comparison on WikiVS for those of you wondering if you should choose MySQL or PostgreSQL as your database language.

From the MySQL vs PostgreSQL page:

MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with propriety database software. MySQL has long been assumed to be the faster but featureless of the two database systems, while PostgreSQL was assumed to be a more densely featured database system often described as an open-source version of Oracle. MySQL has been popular among various software projects because of its speed and ease of use, while PostgreSQL has had a close following from developers who come from an Oracle or SQL Server background.

Read more..

Vote for your favorite open source projects

SourceForge is holding the 2008 Community Choice awards where you get to nominate open source projects in different categories. Based on the nominations, ten finalists will be chosen in each category and the winners will receive the coveted award robot, be showered with praise, and will have vastly increased reputation in the city or town of their choice.

Here are the award categories:

  • Most Likely to Change the World
  • Best New Project
  • Most Likely to Be Ambiguously Accused of Patent Violation
  • Most Likely to Get Users Sued
  • Best Tool or Utility for SysAdmins
  • Best Tool or Utility for Developers
  • Best Project
  • Best Project for the Enterprise
  • Best Project for Educators
  • Most Likely to Be the Next $1B Acquisition
  • Best Project for Multimedia
  • Best Project for Gamers

Go here for more information and to nominate your favorite open source projects!

Monitor Unix and Linux with Microsoft

Sean Michael Kerner is at Interop in Las Vegas where Microsoft has announced that their new Microsoft System Center Operations Manager allows you to monitor Unix and Linux systems.

Shilmover showed a live demo of Microsoft’s tool actually managing a Red Hat Enterprise Linux Server, SUSE Linux Enterprise Server and a MySQL database server. To be honest I’ve never seen anything like it before –  Microsoft demonstrating how it can manage Linux and Open Source technologies.

Microsoft is finally acknowledging that the open source and Linux/Unix world is slowly becoming the norm.  Instead of sitting back, they are coming up with new business models to adapt.  I suppose this is a good thing, but who really wants to use Windows to manager their Linux and Unix servers?

Read Sean Kerners article here.

50 Open Source Applications

There’s a great article written by Christiana Laun that details 50 open source applications to get your office using Open Source. The article covers Desktop and Server distributions, Email and instant messaging, productivity, imaging and design, content management, web tools, network and server management, finances, and security and tracking.

Though not all of the applications listed are open source, it’s still a decent list and a good read.

Read the full article..

Microsoft Is Embracing Open Source..

Amazing isn’t it? According to Scott Guthrie, a General Manager for Microsoft’s Developer Division, Microsoft will be releasing the source code for the .NET framework libraries for .NET 3.5 and VS 2008 releases due later this year.

From Scott’s blog:

We’ll begin by offering the source code (with source file comments included) for the .NET Base Class Libraries (System, System.IO, System.Collections, System.Configuration, System.Threading, System.Net, System.Security, System.Runtime, System.Text, etc), ASP.NET (System.Web), Windows Forms (System.Windows.Forms), ADO.NET (System.Data), XML (System.Xml), and WPF (System.Windows). We’ll then be adding more libraries in the months ahead (including WCF, Workflow, and LINQ). The source code will be released under the Microsoft Reference License (MS-RL).

This is a positive step forward for Microsoft and a great advantage for .NET developers. I look forward to hearing more open source initiatives by Microsoft in the future.

Update: Turns out I, as well as a few others, misunderstood the news yesterday about the .NET framework libraries being released as open source. In actuality, Microsoft is releasing the source code for .NET as shared source, meaning that developers will simply be able to BROWSE the source code, but will be unable to make changes to the code itself. Basically, you can look – but you can’t touch. So, this isn’t really an embrace of open source and I stand corrected.

Intuits QuickBooks Embraces Linux

.. Well, kind of. According to this press release dated June 13th, 2007, Intuit Inc. announced that it will be offering businesses its QuickBooks Enterprise Solutions software on Linux servers. The Linux Database Server Manager is free and will be available for download via Intuit’s site on June 25th, 2007. However, the functionality is only available to users running QuickBooks Enterprise Solutions 7.0 or later.

Obviously this is great news for the Linux community. Intuit is a fairly big company that has been around and established for quite some time now, so its nice to see Linux being embraced more and more by big businesses who are tired of the drag-along costs of operating a separate server for applications they can’t run on their Linux servers. Now the question is (and I hope it happens) will Intuit be releasing a QuickBooks version for the Linux desktop? Only time will tell.

5 Ways to run Windows Applications in Linux

As we all know, one of the major concerns for a user switching from a Windows operating system to a Linux distribution is what Windows software will work on Linux as well as how it can be done. Many users stray away from running Windows because of the simple fact that some must needed Windows applications can not perform under Wine. Tristan Rhodes, The Open Source Advocate has a nicely written article describing 5 ways to use Windows applications in Linux.

  1. Use an open source alternative instead
  2. Buy a commercial product that was designed for Linux
  3. Use Wine to run the application in Linux
  4. Run Windows in a Virtual Machine
  5. Run the application on a remote Windows system

Click here to find out more details for each method of running Windows applications Linux.