Slashdot Mirror


Microsoft Plays Up Open Source

An anonymous reader writes "Recently Microsoft's open source software lab posted PostgreSQL on Windows: A Primer. Postgres is one of the longest running open source databases — it has been around for nearly 11 years. The powerful object-relational database is a direct competitor to other OSS databases, as well as Microsoft's SQL Server 2005. So why is Microsoft promoting it? I get Redmond's interest in boosting anything that runs on Windows as a platform. Is this simply a case of left-hand, right-hand, or is something deeper going on?"

39 of 224 comments (clear)

  1. What's going on here? by croddy · · Score: 5, Insightful

    Easy. This is targeted at folks who have already decided they want to use Postgres, so they can't be sold on the $xx,000 MSSQL license... but maybe they can still be sold on the $300 OS license! It may be too late to lock them into our database, but it's not too late to lock them into the OS.

    1. Re:What's going on here? by Nadsat · · Score: 5, Informative

      Right--This is not news. Nothing is going on here. They are not promoting PostgreSQL at all. There is no real promotion period. I'm not sure how one would come to that conclusion (other than conspiracy fears). The website is simply a set of installation guidelines. A guide to help keep people happy with Windows OS and not leave.

    2. Re:What's going on here? by AoT · · Score: 4, Insightful

      And therein lies the genius of the plan.

      Step 1: Convince company to run postgres on windows.

      Step 2: Postgress run like crap.

      Step 3: Convince customer that it is postgres and *not* windows that is the problem.

      Step 4: Get customer to use MSSQL

      Step 5: Profit ...er

      Step 6: ?

    3. Re:What's going on here? by geminidomino · · Score: 2, Interesting

      Wouldn't know myself. I run it on FreeBSD. I care too much about my servers to put Windows on them. ;)

    4. Re:What's going on here? by jkrise · · Score: 2, Insightful

      Step 1: Convince company to run postgres on windows.

      Step 2: Postgress run like crap.

      Step 3: Convince customer that it is postgres and *not* windows that is the problem.


      The problem for Microsoft is that Postgres runs very well indeed on all other operating systems. Developers are by definition slightly more knowledgable than end-users; and will abandon Windows Server if this happened. Microsoft's moves to improve PHP performance on Windows servers might also be in the same direction.

      Anyone wise enough to know about Postgres would also know how to get it running on Linux... and these days, even Solaris; along with apache and PHP.

      Postgres on Windows is more useful to keep developers hooked onto .Net; the expensive MS-SQL database could be a hindrance to widespread .Net adoption; now they can replace it with Postgres; which in many ways is superior to MySQL.

      However PHP continues to improve by the day; and with accelerators and compilers providing the ability to deliver 'exes' or 'jars'-like code to customers; it is becoming more and more attractive to ISVs. This move by MS might extend the active lifespan of the Windows Server and .Net development platform by about 2 years; after which LAMP or LAPP or SAPP can be expected to be the market leader.

      --
      If you keep throwing chairs, one day you'll break windows....
    5. Re:What's going on here? by DrXym · · Score: 3, Informative
      PostgreSQL is easy peasy to install on Windows, so I don't see why anyone would even think of leaving Windows just to use it. It has a nice installer which includes pgAdmin, compiled help manual and drivers for Java, ODBC and .NET. I've even hooked it up to Open Office Base before now.

      My only wish is that they'd produce a PostgreSQL Engine version - basically PostgreSQL without the help or extraneous fluff which automatically installs without icons or anything. The DB is far, far smaller that MSDE (cut down MS SQL Server 2000) or MS SQL Server Express 2005, has most of the same features and no restrictions on use or database capacity. I work on a project that uses MSDE and the thing is a bitch to configure and make work. If I didn't have 1000+ SQL statements and 1 million lines of C++ to port, I would switch to PostgreSQL in an instant.

      Still doesn't make much sense that MS should promote it though.

    6. Re:What's going on here? by ajs318 · · Score: 2, Funny

      I have heard of at least one company where the IT department were ordered to set up IIS, ASP and MS SQL server for a management-initiated project (one of the bosses had taken some mickey-mouse correspondence course and fancied himself as a designer of database-driven web sites). What they actually did was set up a small test server for Gates's toady; pocket the rest of the money meant for Microsoft; set up Linux, Apache, PHP and MySQL on the outward-facing server; make some flimsy security-related excuses why the boss shouldn't have direct access to the outward-facing server; and translate all the well-meaning-but-terminally-incompetent boss's badly-written ASP code into PHP.

      It makes me think of this song .....

      --
      Je fume. Tu fumes. Nous fûmes!
    7. Re:What's going on here? by cookd · · Score: 2, Interesting

      I love this response. "Microsoft can make better programs because they use the super-secret ultra-special hidden APIs." Completely false. Though sometimes I wish there were secret hidden APIs that could be used to somehow make programs work better, this seems pretty far-fetched.

      Microsoft employees use MSDN for documentation just like everybody else. While it is possible that they have access to better support options than the average developer (i.e. their friends that work on the Windows team can given them advice), there is no secret sauce available. Just elbow grease.

      In fact, SQL Server has it worse than non-Microsoft products. Beyond the simple absurdity of "secret APIs", there are also legal restrictions. SQL Server (just like any other non-Windows* MS product) legally must restrict itself to public Windows APIs. As a part of the antitrust restrictions on Microsoft operations, if the API is not documented on MSDN, SQL Server cannot use it. Every other company gets to use whatever Microsoft API they can find, however they can find it. SQL Server has to do everything by the book. Not only that, but the SQL Server team (and the teams behind every other non-Windows program shipped by Microsoft) has to be able to document that they aren't using any undocumented APIs.

      On the other hand, SQL Server has it better than other databases. The SQL Server team gets to focus its efforts on a single OS. SQL Server is TIGHT (like this!) with Windows. It has been tuned and re-tuned to work well on Windows. It leverages the Win32 API like no other database on the market. No abstraction layers, no designing to the lowest common denominator, no limitations because "one of the OSes we support can't do that". (Well, not entirely true -- multiple versions of Windows with differing capabilities are supported, but still mostly true.) SQL Server makes use of the Windows OS like probably no other program that has ever been written.

      If Microsoft programs ever outshine the competition, it is because they got more effort put into them or were designed better. And when other programs work better than Microsoft's, it is because they got more effort or were designed better. No secret sauce, no secret APIs.

      * (Windows components do use internal and undocumented APIs to communicate with other Windows components. That's just abstraction layers at work - every program I can think of uses undocumented APIs to talk to other parts of itself. In any case, only Windows components are allowed to use undocumented Windows APIs.)

      --
      Time flies like an arrow. Fruit flies like a banana.
    8. Re:What's going on here? by jazir1979 · · Score: 2, Insightful

      I'm saying that you can't take MS-SQL on to other platforms, I thought that was pretty obvious.

      If you design your app in a DB-independant way then fine, you can port to another DB, but that's alot more overhead than sticking with a DB that runs on multiple OS'es.

      --
      What's your GCNSEQNO?
  2. If they don't buy MS, they might buy Oracle or IBM by LaminatorX · · Score: 4, Insightful

    MS is boosting Postgre because they don't want people buying Oracle or IBM's database offerings.

  3. maybe databases aren't profitable? by belmolis · · Score: 2, Informative

    It is widely reported that Microsoft makes its money on Windows and Office. The other products earn little or even lose money. If this is true, it may make sense for Microsoft to attract people to Windows or keep them using Windows, by supporting PostgresSQL, even if it reduces their sales of their own database.

    1. Re:maybe databases aren't profitable? by ChatHuant · · Score: 5, Informative

      It is widely reported that Microsoft makes its money on Windows and Office. The other products earn little or even lose money

      No, it isn't reported, and no, other products do make (lots of) money. It's very easy to look it up too: the breakdown of earnings per division can be found here. You can see that out of 5 divisions, 3 are operating at a gain, and two at a loss. The Entertainment and Devices Division (XBox) and Online Services Business (MSN) are in the red. Windows, Office and SQL Server are in the black

      The business division of interest for this particular article is Server And Tools, makers of SQL Server. Here's what Business Week says about this division here: Microsoft's server and tools business, long Microsoft's lone growth engine, had another blowout period, posting its 18th consecutive quarter of double-digit growth. Its SQL server database software posted particularly sharp gains, up 30% for the period. That helped the division's sales jump 17% to $2.9 billion

    2. Re:maybe databases aren't profitable? by ChatHuant · · Score: 2, Informative

      the figures you cite ... don't in any way refute my statement as to what is widely reported.

      Uhh... Yes, they do. Sorry.

      Here, for example, is a report of the type that I mentioned, which is the first hit returned by Google on "Microsoft profit breakdown Office Windows".

      If you had bothered to look at the article you're citing you may have observed it was published in 2002. Long past its shelf life, in an industry as dynamic as software.

      You will of course note that I indicated that I didn't know whether the reports were true. Don't be so quick to criticize.

      You posted false information (even if you got moderated informative) and I corrected you. That's not criticism. It's more like a public service.

  4. Postgres is much more than 10 years old by stox · · Score: 3, Interesting

    Version 1 of Postgres was released in 1989. It later evolved into Postgres95 and then PostgreSQL. And it keeps getting better every year!

    --
    "To those who are overly cautious, everything is impossible. "
  5. Bullshit summary as usual... by jkrise · · Score: 5, Insightful

    Postgres is one of the longest running open source databases it has been around for nearly 11 years. The powerful object-relational database is a direct competitor to other OSS databases, as well as Microsoft's SQL Server 2005. So why is Microsoft promoting it?

    Firstly, an article on Port 25 is not promotion. It does not count as mainstream media by any stretch.

    Remember the ads on TV.. where there's a forklift, lifting up what looks like battery cells... and placing them on top of a huge building... and then you see, SQL Server 2005. If Microsoft replaces those ads with Postgres instead; we can call it promotion... not until then.

    Many firms (like mine) would like to use the manpower conversant with and trained on .Net... but use a free (as in beer) database. MySQL is pretty slow with joins, so Postgres with PL/SQL and stored procedures support, may be the answer.

    --
    If you keep throwing chairs, one day you'll break windows....
    1. Re:Bullshit summary as usual... by jkrise · · Score: 2, Interesting

      WOW that's pretty amazing. I have never seen any MS development shop not use SQL server. What's your company?

      We aren't an MS development company. We happen to develop and deliver IT solutions to customers mainly in the BFSI segment. Ironically, the biggest cost in s/w development happens to be trained manpower; and using .Net allows us to hire cheap workforce that can do 'Brains-Free Programming!'.

      One of our important offerings for the stock brokers is built around .Net and Oracle ; we're trying to now change the database to MySQL / Postgres instead. Small broking firms find the database licensing (SQL and Oracle) as expensive as our product. Postgres seems much faster and more suited at first glance.

      --
      If you keep throwing chairs, one day you'll break windows....
    2. Re:Bullshit summary as usual... by ady1 · · Score: 2, Funny

      Firstly, an article on Port 25 is not promotion.
      It's not. It's SMTP
  6. MS is not really so monolithic by Felonius+Thunk · · Score: 5, Insightful

    They're really several companies with distinct businesses under common ownership. Occasionally the strategy tax must be paid (e.g. no IE for linux, no java/lamp for Visual Studio, no Exchange for *nix, MSN using wmv instead of flash), but I would guess most of the inner businesses want to do what their competitors do. It shouldn't be a surprise when they do, just laughable/sad when they don't.

    1. Re:MS is not really so monolithic by killjoe · · Score: 2, Funny

      What's remarkable about this community is their lack of objection to their companies behavior. Clearly people who either agree with how their company behaves or maybe people who don't have a strong moral compass.

      --
      evil is as evil does
  7. Microsoft is only Anti-GPL by Schraegstrichpunkt · · Score: 4, Insightful

    So why is Microsoft promoting it?

    Because PostgreSQL isn't licenced under the GNU GPL.

    1. Re:Microsoft is only Anti-GPL by vladkrupin · · Score: 2, Insightful

      That is exactly what's going on. Non-GPL code can be easily embraced, extended, etc... you know the trick. GPL code is a much harder nut to crack. Many have tried to "get cute with the GPL" as PJ of Groklaw puts it, but none have succeeded. If you can marginalize the GPL, eliminating the non-GPL competition by embracing, extending, extinguishing is a much easier task. GPL is their only threat, really.

      --

      Jobs? Which jobs?
    2. Re:Microsoft is only Anti-GPL by nacturation · · Score: 3, Funny

      Microsoft is behaving like a beached whale. Are they in more trouble than anyone knows? All this recent FUD including Ballmer. BALL My Eyes Red? Cray baby cry... I never would have thought it possible, but my monitor actually frothed just from displaying that comment.
      --
      Want to improve your Karma? Instead of "Post Anonymously", try the "Post Humously" option.
    3. Re:Microsoft is only Anti-GPL by javilon · · Score: 2, Insightful

      "Many have tried to "get cute with the GPL" as PJ of Groklaw puts it, but none have succeeded."

      Well, the jury is still out on the Microsoft-Novell deal.

      --


      When his defense asked, "Which computer has Jon Johansen trespassed upon?" the answer was: "His own."
  8. Furthering their extortion by Anonymous Coward · · Score: 2, Funny

    Maybe they beleive they have a solid case that postgressql infringes on their patents. They want more companies using it (and to know who) so they know who they can take to court and extort some protection money.

  9. My enemies' enemies are my friends by pablodiazgutierrez · · Score: 4, Informative

    Obviously, MS is interested in weakening the position of any competitor. In this case, Oracle is a bigger player in the databases market than MS ever dreamed to be. Therefore, helping PostgreSQL damages the competition more than it does damage MS itself, which is a win for them, in terms of market share and potential risks due to loss of control over that market. Kind of the same reason why IBM supports PostgreSQL and other OSS in detriment of its own products.

  10. Am I the only one.. by Shiny+One · · Score: 5, Insightful

    .. that didn't miss the most obvious comment.

    Embrace. <-- You are here
    Extend.
    Extinguish.

    1. Re:Am I the only one.. by LordEd · · Score: 2, Insightful

      I thought that "its a trap" would be more obvious.

      In any case, this isn't a case of the 3e approach. All they did was install Postgres on windows and write up a step by step installation doc with a few tips discovered in the process. There is nothing on their interpretation of whether it is good or bad.

  11. Re:What's going on here? - But MSSQL is free too! by MrZaius · · Score: 2, Insightful

    True to an extent, but MSSQL is free to many users. What's more likely is that they're promoting it as a way to break the L out of the LAMP/LAPP stack, like the recent Sun Microsystem moves.

  12. You get people to get off this by peterbiltman · · Score: 2, Interesting

    Anti-Microsoft bandwagon. I'm seriously beginning to wonder if reading Slashdot makes any sense. It seems to be nothing more than a constant bash of Microsoft along with questionable articles about anything non-Microsoft. You claim to be a news source, but when you slant the news all the times you become a propoganda machine and not a news source. There is nothing wrong with sharing information about how to do something. Microsoft is merely showing people how to do something on their operating system. It isn't a consipracy theory, there are no hidden agendas, it is just people sharing information with other people.

  13. Microsoft has always supported BSD license by phantomfive · · Score: 4, Interesting

    Nobody has mentioned it yet, so I'll throw in my two cents. Microsoft is not against open source at all, they actively encourage and even use it on occasion (the TCP stack in windows is famously known to be from BSD Unix). They are happy when people write code that they can use.

    Where they have the biggest problem is with GPL'd stuff, which they can't use at all. Of course in this particular situation there are other factors involved, but since they have been addressed by others, I will not repeat them here.

    --
    Qxe4
  14. Re:Non-native by tgl · · Score: 2, Informative

    "Cygwin is required"? Apparently you haven't actually looked at Postgres in a few years. There's been a native port since PG 8.0.

  15. Re:What's going on here? - But MSSQL is free too! by killjoe · · Score: 4, Informative

    MSSQL is only free if your database is smaller then four gigs. On the other hand DB/2 is free no matter how much data you have.

    --
    evil is as evil does
  16. Re:If they don't buy MS, they might buy Oracle or by Tablizer · · Score: 3, Interesting

    MS is boosting Postgre [PG] because they don't want people buying Oracle or IBM's database offerings.

    I tend to agree. Oracle is a huge company, and if lots of people used PG instead of Oracle, then it may mean more Windows sales over Unix/Linux sales. Even if they lose a bit of SQL-Server sales, the migration over to Windows may offset that. Perhaps the MS bean-counters calculated that gained Windows sales would offset lost SQL-Server sales. They maybe figure that OSS DB's will eat into *all* commercial DB's anyhow. MS may rather be in the OS biz than the DB biz because of this. I hear PG's SQL syntax is closer to Oracle's than SQL-Server anyhow.

  17. Re:Microsoft strongly prefers BSD license to GPL by Swordfish · · Score: 4, Informative

    You're right. You beat me to the comment. Postgres is not a threat in the sense that MySQL is. Also MySQL takes money away from MS and puts it in their own bank account, whereas Postgres does not build up a cash-hoard that can be used against MS later. Postgres is really free, as opposed to GPL, which signifies ownership by "the community". A Few years ago, MS said very publically what their list of okay licences was. That list included BSD, but did not include GPL or the Artistic licence.

  18. Cancel or allow by floki · · Score: 4, Funny

    Best part: "The install on Vista is similar to other Windows installs but to install on Vista, you must turn off User Account Control first." :-)

    --
    from the to-stupid-for-words dept.
  19. Re:I just corrected this myth here yesterday! by bmo · · Score: 2, Informative

    "Again (and again, and again ..) the antitrust case against MS was a civil one. MS hasn't been convicted of anything and isn't a criminal."

    Riiiiight.

    http://www.law.cornell.edu/uscode/html/uscode15/us c_sec_15_00000002----000-.html

    Seeya.

    --
    BMO

  20. Re:Nothing to see. by StrawberryFrog · · Score: 2, Informative

    Seriously, people who can get by with Postgres wouldn't buy SQL server anyway - it's not even in the same league.

    Most people who use databases don't make much use of the advanced features. This is why MySQL is even in the market. I like MS SQL server a lot - it's good DB server, but most of the stuff done on it could just as easily be done on PostgreSQL. Good old select, insert, update, delete covers a lot of ground. The pressure with commercial software is to add new features in new versions, regardless of if they are needed or not.

    --

    My Karma: ran over your Dogma
    StrawberryFrog

  21. Re:Nothing to see. by JohnFluxx · · Score: 2, Informative

    I disagree specifically with "people who can get by with Postgres wouldn't buy SQL server anyway" - I think the problem is that people _do_ use SQL server when they can get by with Postgres.

    On a different note, I've never liked the idea of having a heavy database - i.e. one with code procedures etc. It seems to make more sense to keep the database as just a database and implement your model logic in the model classes of what ever access it. That way you can change the database fairly easily and aren't tied completely to one particular database system.

  22. It's not about software, it's about consulting by NetSettler · · Score: 2, Interesting

    This is targeted at folks who have already decided they want to use Postgres, so they can't be sold on the $xx,000 MSSQL license... but maybe they can still be sold on the $300 OS license!

    While that's not money any of us as individuals would sneeze at, I doubt that's the money Microsoft cares about. The big money is surely in support, and Microsoft is leaving that money on the table if it insists, based on foolish pride, that it won't support stuff it didn't develop.

    Large companies like Microsoft have little to fear from free software. It provides a rich source of business problems to solve for respectable consulting return. In many ways, the initial production of software is just a loss leader for big companies to get into the consulting game. Free software doesn't threaten that. All it does is limit the ability of the author to gain economically from royalty revenue at levels that would probably matter to them but that almost certainly is too smallfry for a company like Microsoft to even care about.

    It seems to me very sad for the producers of useful software to unilaterally and voluntarily economically disempower themselves. The world needs people who can think and develop, and when they don't use that power to put food on the table, they lock themselves into day jobs working for someone else to do so... Worse, the main places to get those day jobs will be the places business wants to buy software support from: stable companies offering longevity and stability... companies like, say, Microsoft. Great.

    Personally, I'd rather see a few more "small" millionaires, perhaps starting small and interesting sofwtare houses from royalty revenue, than no royalty revenue going to the code authors and all of industry's money going to the same old big consulting houses, who realize the market will bear the spending of that money and are willing to provide a product that the market can spend it on.

    The big companies know they don't have to waste time and money trying uselessly to put the free software producers out of business. They can just use the freeness of the software to reduce their development costs in producing new products--why not do your R&D on someone else's nickel? Then they can make money on cleaning up the mess when the failure to acquire revenue means the talented creators of free-and-should-be-charged-for software software can't scale to support what they've made.

    Heck, if the Postgres business really takes off for Microsoft, it could later eliminate a few of its developer jobs and cancel its own SQL product and just let Postgres continue to be developed by people willing to give away their skills rather than charge for them in a legitimate commercial challenge to Microsoft.

    --

    Kent M Pitman
    Philosopher, Technologist, Writer