What so special about PostgreSQL and other RDBMS?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Joel Garry

    #61
    Re: What so special about PostgreSQL and other RDBMS?

    quirk@syntac.ne t (Quirk) wrote in message news:<4e20d3f.0 405110058.684e5 968@posting.goo gle.com>...[color=blue]
    > "Volker Hetzer" <volker.hetzer@ ieee.org> wrote in message news:<c7o8i3$3b k$1@nntp.fujits u-siemens.com>...
    >[/color]
    [color=blue][color=green][color=darkred]
    > > > Yes, you have the right to be overcharged for work that may or may not
    > > > not suit your needs by only _one_ vendor, and no right to go elsewhere
    > > > when they fail, ignore you outright, stop supporting your application
    > > > or vanish from the face of the earth. Have you actually read your
    > > > contract or software licence?[/color]
    > > Of course. See the end of this posting.[/color]
    >[color=green][color=darkred]
    > > > It only protects the vendor, not you.[/color]
    > > I've read the licence and done even more: I've used the software and tested the contract.[/color]
    >
    > Realy, care to quote the part of the Contract that Gaurantees you any
    > rights?
    >
    > Instead, what you will find is that the contracts insists that the
    > Software is not gauranteed to be usefull for any particilar purpose,
    > and that they deny all responsibilitty for it to the extent possible
    > by law.
    >
    > By "tested the contarct" what you mean is you agreed to pay them
    > completely on their terms and where satisified with the results they
    > chose to give you.
    >
    > Have you tested alternatives?
    >[/color]

    ....
    [color=blue][color=green][color=darkred]
    > > > > I don't *want* to create my own development
    > > > > team competing with the original one. I don't want to merge my change back
    > > > > into their code with every new release! I don't want to develop code and
    > > > > then have them decide whether they condescend to incorporate it or not! I
    > > > > want the authors of the software to do the coding based on what I'm willing
    > > > > to pay for!
    > > >
    > > > You are dependent on their licence[/color][/color]
    >[color=green]
    > > I'm dependent on the author's licence regardless of which database I use.[/color]
    >
    > Yes, which is why you should choose one that give you a perpetual
    > right to the source code, otherwise you are locked into a dependancy
    > that may prove fatal to your application.
    >[color=green]
    > > It's just that some licences give me the illusion of being able to do
    > > something while mainly giving me in reality the ability to shoot myself in
    > > the foot or paying someone else to shoot me in the foot.[/color]
    >
    > Unsubstantiated bunk, if you have the source code, it is not magic to
    > fix it, or extend it, just normal progamming. Simple calling something
    > an illusion does not explain why you condsider it impossible to
    > actually change a program. Perhaps you should consider a different
    > line of work.[/color]

    As someone who has profited greatly from this, I must point out that
    he is correct. I've profited both from the fact that during and after
    the lawsuit there is a great, _and artificially created_, shortage of
    technical talent, and the fact that companies will indeed shoot
    themselves in the foot by automating existing processes rather than
    reengineering them, if having the source code allows them to do so.
    And when it gets obsolete and no young 'uns want to deal with it,
    that's when the big bucks begin.


    ....
    [color=blue]
    >
    > As I said, my comments where ment *FOR DEVELOPERS* that is those who
    > are developing *NEW* appliciations, and my advice is simple enough,
    > despite your contortions: If your application is important to you, do
    > not engineer a dependency on code you do not have access to.[/color]

    New or old, they get old or they die horribly. Until there is some
    desire in the industry for stability over time, this is a red herring.
    [color=blue]
    >[color=green]
    > > anyone else is going to make a worse job than
    > > them. So, I get the best support when I'm paying them and no one else.[/color]
    >
    > More unsubstantiated bunk, first of all, in many cases you can hire
    > the original developers, regardless of your right to the source code,
    > secondly, by hiring the "Copyright Holders" you *ARE NOT NECESSARLIY
    > HIRING THE DEVELEORS*, who may not even be with the company anymore,
    > in fact you are often hiring some peon who they scooped of the
    > consulting market 5 minutes before sending him to your office as an
    > certified solutions prodiver or whatever idiotic buzzword whey have
    > for their unskilled labour.[/color]

    Make buckets o' cash following them, too.
    [color=blue]
    >
    > And finaly, it is a falalcy to say that someone will do a worse job
    > simply because they are not the original developer.[/color]

    Not necessarily. I've seen plenty of "design drift," especially over
    time when the newbies may not have the context of the original
    developers, and the managers feel the need to compete with completely
    different things from competitors. There is also the classic case of
    developers going from place to place because they are only interested
    in new stuff, so follow-on developers miss a lot of the organizational
    wisdom.


    ....
    [color=blue]
    > In anycase, I am not arguing agianst using Oracle, as I said, if
    > Oracle suits your needs and you think it's worth the money, use it,
    > however, my advice is that if you do develop an application, write
    > your code in such a way that you do not depend on Oracle, but can
    > easily switch it over the the greatest extent possible.[/color]

    Well, this is double-edged. As someone who has spent a great deal of
    the last couple of decades dealing with heterogenousity , I can state
    with some confidence that the lowest-common-denominator approach will
    make it very easy for the competition to eat your lunch after you've
    created their market. I think SAP has seen this and that is why they
    are so hot on controlling mysql, and I think Oracle has seen this and
    that is why they are so hot on controlling peoplesoft (they scheduled
    the court date for September IIRC?), and I think MS has seen this, and
    I think everyone else has seen that MS has seen this, and all the low
    to midrange enterprise app competition are already going under. Niche
    markets excepted, but perhaps even more sensitive to LCD.
    ....
    [color=blue]
    > This is just stupid, elegnt coding is hardly as unatainable an ideal
    > as you seem to be conviced, in fact in this specific case it's a
    > simply matter of using a standard wrapper function throughtout your
    > aplication to access your data rather than using proprietary bindings
    > throughout your application, if your application is sufficently
    > complicated, perhaps a data abstaction object might be usefull for
    > this function, perhaps not, if you use any non standard features of
    > your database server, then write some additional functions as wrappers
    > for these. It is anything but rocket science.[/color]

    If you use non-standard features, your wrapper has to emulate it for
    those db's that don't have it. This may well be rocket science you
    are reinventing. I've seen it be a problem over and over.


    ....[color=blue]
    >[color=green][color=darkred]
    > > > > > If you have the source code, you are the developer,[/color][/color]
    >[color=green][color=darkred]
    > > > > Wrong. I am the user, t.
    > > >
    > > > Oh, well then I guess we have nothing further to discuss, my comments
    > > > here where meant for actual developers.[/color][/color]
    >[color=green]
    > > So, oracle people should further develop oracle and mysql people
    > > mysql. Did I get this right?[/color]
    >
    > No, that's not right, that's not even wrong.
    >
    > (with applogies to Wolfgang Pauli)
    >
    > Application developers should avoid locking themselves in to external
    > dependencies, either by not using products to which they have no right
    > to the source code, or abstracting access when they do use such
    > products. Simple.
    >
    > And having right to the source code does not mean that the program is
    > 'open source,' as you can purchace such a right for propretary code,
    > as is common for libraries.
    >
    > Of course, when the program _is_ open source, you are guaranteed that
    > right.[/color]

    OK, give me the source to the Redhat 5 tape driver.

    ....
    [color=blue]
    >[color=green]
    > > "Assistance with my SRs 24 hours per day, 7days a week". Practically I
    > > usually get two or three guys working on a typical SR of mine, depending on
    > > how log it takes. Without a contract I'd get a 'buzz off, I'm doing my exams > this month'.[/color][/color]

    ROTFL!
    [color=blue]
    >
    > "Assitance" only means that they will provide someone whose time they
    > can bill you for, not that anything will be accomplished. And you
    > discredit yourself by attemping the fallacy that the only way to have
    > access to an applications source code is to hire some one who is doing
    > exams. Many large companies, and profesional develpoers provide source
    > licences and/or support open source products, including the largest
    > computer company in the world, IBM.[/color]

    It's so funny, because I've heard it. And at one time, I almost
    actually said it. I did once say something like "I'm not coming in
    while my wife is having a baby merely because your 'lead dba' can't
    follow instructions to load a test database."

    jg
    --
    @home.com is bogus.
    I change my vote, unmoderated is more fun:

    Comment

    • Quirk

      #62
      Re: What so special about PostgreSQL and other RDBMS?

      "Volker Hetzer" <volker.hetzer@ ieee.org> wrote in message news:<c7t0v0$sb v$1@nntp.fujits u-siemens.com>...[color=blue][color=green]
      > > And what was your reply?[/color][/color]
      [color=blue]
      > I asked first.[/color]

      Is this grade school?
      [color=blue][color=green]
      > > Realy, care to quote the part of the Contract that Gaurantees you any
      > > rights?[/color][/color]
      [color=blue]
      > http://oracle.com/support/index.html?policies.html[/color]

      I asked you to QUOTE the part of the Contract that Guarantees you any
      rights, not post a link to a description of support options and what
      they cost.

      And even so, if you bother to read that page you would have noticed
      that it is mostly about protecting Oracle's rights from you, not
      granting you any.

      For example:

      "Oracle may provide additional releases or versions of its programs
      in the form of an Update as part of our technical support services. It
      may become necessary as a part of Oracle's product lifecycle to
      desupport the programs and, therefore, Oracle reserves the right to
      desupport its programs."

      What do think "Desupport its progams" means?
      [color=blue][color=green]
      > > By "tested the contarct" what you mean is you agreed to pay them
      > > completely on their terms and where satisified with the results they
      > > chose to give you.[/color][/color]
      [color=blue]
      > So, in what way is it different from let's say, buying a cucumber?[/color]

      If my application required a cucumber, I wouldn't sign a deal with a
      cucumber vendor that insisted I could only buy cucumbers from them,
      for ever, even if their cucumbers no longer work for me, while they
      could stop providing cucumbers any time they feel like it and still
      forbid me to use my own, proprietary cucumber dependant, application.
      I would, at least, make my application work with any cucumber.

      This converation has gotten ridiculous, can it be that you really
      don't know the difference between a cucumber and an application
      dependency?
      [color=blue][color=green]
      > > Have you tested alternatives?[/color][/color]
      [color=blue]
      > The other example was buyig gcc support from cygnus.
      > One bug, never got resolved in one year, consequently
      > we cancelled support.[/color]

      Yet in this case, you could have purchaced gcc support from another
      company, however, without source, you would not have this option.
      [color=blue][color=green]
      > > Are so so stupid that you actually expect a serious answer that was
      > > obviously a
      > > hostile attempt to insult by way of a rhetorical question?[/color][/color]
      [color=blue]
      > Ok, so for you explicitly: That was not a rhetorical question. Your response
      > indicated youy didn't read my posting, or at least not the relevant part, so > I wanted to check whether it was worth posting any more.[/color]

      What nonsence, please demonstrate this by comparison, I have clearly
      responded to all your arguments, regardless of how little sense they
      made.

      You attempt empty rhetoric exactly because you have no real argument.

      Worth posting what? Your great advice that developers should *NOT*
      abstract their code?
      [color=blue]
      > I start to repeat myself here.[/color]

      Too bad you have no actual argument to repeat, you are merely
      repeating your empty rhetoric and unsubstantiated bunk.
      [color=blue]
      > The right to the source code does not mean
      > anything useful, see the part you quoted below.[/color]

      Yes it does, it's too bad you don't understand it.

      If I have the source code, I know I can relly on a product for ever,
      and never talk to the original developer again if I so chose. Withouth
      source, the developer holds all the cards.

      Let's take a simple case, say you hired a consultant to write you a
      simple
      application, say a specialized contact manager.

      When the project was over, would you let the consultant leave your
      office, only turning over a compiled binary of the application? Or
      would you insist that he provide the source?
      [color=blue][color=green]
      > > Unsubstantiated bunk, if you have the source code, it is not magic to
      > > fix it, or extend it, just normal progamming.[/color][/color]
      [color=blue]
      > Right. So, if I do CAD programming, why should I learn database programming
      > only to support a dead database? It's much easier to migrate to another one.[/color]

      Why are you struggling so hard with such simple logic?

      - If a Dead Database means your application is also dead, if
      migration is impossible; having source code can save the day.

      - If migration is possible, migrating is easier with abstraction.

      - If you have source *AND* you have abstracted, whoa nelly, you are
      in *really* good shape.

      - If your data is archived in a self contained, self describing,
      human readable format, why, you are all but invincable.

      Thus my advice.
      [color=blue]
      > Besides, have you considered that quite a few open source projects get abandoned
      > because they have become unmaintainable?[/color]

      And closed-source applications have never been abondoned???

      Another simple question: If your application is abandoned, are you in
      better shape with, or without source code?
      [color=blue]
      > Anyone remembers hurd? Groff?[/color]

      Yeah, what about them?
      [color=blue]
      > What was the last gmake improvement? And if the authors throw up their hands,
      > what can I do? Ask my boss to form a department for the beating of dead
      > horses?[/color]

      If you are dependent on them, at least you always have the source code
      and can thus continue to use the product, even have it modified if you
      need to.

      If, however, you are dependent on a closed-source dead horse, well,
      you are horse-shit out of luck.
      [color=blue][color=green]
      > > Simple calling something
      > > an illusion does not explain why you condsider it impossible to
      > > actually change a program. Perhaps you should consider a different
      > > line of work.[/color][/color]
      [color=blue]
      > Oh, it's pretty easy to change a program. Working through millions
      > of lines of code and repairing it with less time or money than it would
      > cost to migrate to another database is the trick.[/color]

      Reminder: I am an the one advocating Abstraction, which would make it
      easier to migrate to another database. What the hell are you talking
      about?

      And If, for some reason, you *must* repair the database, say the bug
      is simple and is easier to fix than to migrate a large working
      implemtation, at least with the source, you can, without the source
      you can not.
      [color=blue]
      > Convincing the customer to
      > install *my* database version is another, particularly if three or four
      > developers do this.[/color]

      Leaving the customer stranded because your application is hosed by an
      obsoleted dependency is even a harder sell.
      [color=blue][color=green][color=darkred]
      > > > Same question: Did you read what I wrote?[/color]
      > >
      > > A better question: What kind of an idiot are you that, in the face of
      > > good sense, the best you can do is attemp insulting, evasive
      > > rehetoric?[/color][/color]
      [color=blue]
      > It's not a better question. You keep bringing up that stupid
      > source code argument totally ignoring the fact that it simply doesn't
      > work, at least not for the money a normal support contract costs.[/color]

      You keep basing your entire argument on nonsencical out-of-hand
      dismissals, like 'it simply doesn't work.'

      It does work, let me let you into a little secret: programmers modify
      source code, that's how programs are made and fixed. Without source
      code you can not fix a program.
      [color=blue]
      > And if support doesn't work, I still won't support it on my own.[/color]

      You can do what you want, my advice is just that, advice, many people
      are in different situtations from you, and have a different point of
      view.
      [color=blue][color=green]
      > > As I said, my comments where ment *FOR DEVELOPERS* that is those who
      > > are developing *NEW* appliciations, and my advice is simple enough,
      > > despite your contortions: If your application is important to you, do
      > > not engineer a dependency on code you do not have access to.'[/color][/color]
      [color=blue]
      > Do you develop for platforms other than linux?[/color]

      Yes, I have and do develop for many platforms, but *I* am not the
      topic of this thread, despite your desperation. Once again, you only
      attack the arguer because you have no argument.

      The assertion you quote remains true, and your response, as usual, is
      not a response at all.
      [color=blue][color=green]
      > > More unsubstantiated bunk, first of all, in many cases you can hire
      > > the original developers,[/color][/color]
      [color=blue]
      > Yeah, exactly. A man year here costs about USD200000,-. A support
      > contract with oracle costs me about a tenth of that.[/color]

      In many cases you can aquire a support contract from corporations that
      have the original developers working for them.
      [color=blue]
      > And even if I buy some incident based support contract, there is still
      > no difference from an incident based support contract with oracle.[/color]

      Yes there is, since you value the original developers so highly, we'll
      try this example.

      The best original developer of Oracle, the one with the greatest
      knowledge of the system and code, quits Oracle and goes to work for
      Databases-R-Us, since you have no source, you must continue to deal
      with Oracle, the copyright holder, and can not hire Databases-R-Us,
      who employ the developer.

      The best original developer of MySQL, the one with the greatest
      knowledge of the system and code, quits MySQL AB and goes to work for
      Databases-R-Us, since you do have source, you no longer need to deal
      with MySQL AB, the copyright holder, and can instead, choose
      Databases-R-Us, who employ the developer.

      Just one simple example of how having the source gives you more
      freedom, and how the developer and the copyright holder are not the
      exact same thing, to say nothing of the support peon they actually let
      you talk to.
      [color=blue]
      > As long as that guy exists and I can sue him into doing his job I don't
      > need the source code (he needs) and otherwise I have no one to
      > replace him.[/color]

      Suing him is a red herring. You applicaion is not powered by law
      suits, but rather by compiled source code.
      [color=blue]
      > But thanks for acknowleding that reliable support costs money.[/color]

      If stating the obvious is somehow of help to you, you're welcome.
      [color=blue][color=green]
      > > regardless of your right to the source code,
      > > secondly, by hiring the "Copyright Holders" you *ARE NOT NECESSARLIY
      > > HIRING THE DEVELEORS*, who may not even be with the company anymore,
      > > in fact you are often hiring some peon who they scooped of the
      > > consulting market 5 minutes before sending him to your office as an
      > > certified solutions prodiver or whatever idiotic buzzword whey have
      > > for their unskilled labour.[/color][/color]
      [color=blue]
      > Try it.[/color]

      Try what? The paragraph you are quoting explains the difference
      between original developer and copyright holder, what are you
      suggesting I try?
      [color=blue]
      > Besides, remember, the company has an interest in providing
      > support because they live off it.[/color]

      They also have an interest in dumping relationships that are no longer
      profitable, and may not be interested in your obscure problem or
      implemention, but rather more interested in selling you (or someone
      else) something new.

      Other organisations may be quite interested in helping you, but are
      unable to because you have no source code for them to fix.
      [color=blue][color=green]
      > > And finaly, it is a falalcy to say that someone will do a worse job
      > > simply because they are not the original developer.[/color][/color]
      [color=blue]
      > So, if I pick some average application programmer off the street,[/color]
      [color=blue]
      > how long do you think it takes before he can start smoothing
      > out bugs in the postgres optimizer?[/color]

      I would not recomed you 'pick some average application programmer off
      the street' if you want to sort a bug in the postgres optimizer.

      Many developers could do whatever you want, for instance: PostgreSQL,
      Inc (not to be confused with PostgreSQL Org), Cybertec Geschwinde &
      Schoenig, NuSphere, or many others which know the system well.

      However when Oracle lets you talk to a programmer, that is just who
      they let you talk to, some average programmer they picked off the
      street, the good programmers in their organisations to not work in the
      support department, but rather on new features for new versions and
      products to sell.
      [color=blue][color=green]
      > > But it stops short of guaranting that your apllication will actualy
      > > work,[/color][/color]
      [color=blue]
      > Of course they don't offer that. But they offer to put effort
      > in it.[/color]

      Only as long as it is profitable for them and no more, then you get
      'Desupported'
      [color=blue]
      > And they are dependent from me for my money.[/color]

      Just you?
      [color=blue][color=green]
      > > or that your existing version of the software will be supported.[/color][/color]
      [color=blue]
      > They provide upgrades and desupport dates. Ok, they do
      > what I pay for.[/color]

      Only as long as you pay, and only on their terms, if you have source,
      you need not change a working system just because it is not supported
      by Oracle anymore.
      [color=blue][color=green]
      > > In anycase, I am not arguing agianst using Oracle, as I said, if
      > > Oracle suits your needs and you think it's worth the money, use it,
      > > however, my advice is that if you do develop an application, write
      > > your code in such a way that you do not depend on Oracle, but can
      > > easily switch it over the the greatest extent possible.[/color][/color]
      [color=blue]
      > Why "the greatest extent"? That costs me more time and money
      > and customers that it's worth.[/color]

      Because it will save you time and money in the long run in many cases,
      but it is, like everything else a case by case call, I was not trying
      to make design decisions for you or anybody else, just giving some
      advice, good advice, I have no idea what you are trying to do other
      than be a crank.
      [color=blue]
      > Just look at informix to see how
      > it goes when a db disappears from the market:
      > They had a big market share, market share dwindled, they got weak
      > and sold themselves to ibm because that's better than going bancrupt.
      > Now IBM handles the migration to db2 and supports me as application
      > developer in porting my app to db2. This is much better than handing
      > me the source code and telling me that from now on I have to develop
      > all the new features and fix bugs on my own or simply buy a new db
      > and do the migration on my own.[/color]

      Or instead of IBM they could have been bought by CA, and fucked up
      royaly. Or just been allowed to disapear. Again, you are depending on
      good luck and good graces, if you have source, you know for sure, but
      as I've said many times, it's even better to have an abstracted
      application.

      And by the way, don't think that IBM is above squeezing these newly
      aquired hostages for every penny they are worth, and tosing aside the
      ones who helping would not be profitable. You dont become a 100
      billion dollar company by being stupid.
      [color=blue][color=green]
      > > I have no idea why you are insisting on jumping up and down like this
      > > is crazy talk, the only plausible theory is that you get some kind of
      > > thrill out of embarassing yourself.[/color][/color]
      [color=blue]
      > Where do I jump up and down?[/color]

      When you stoop to making ridiculous, incoherent, awkward streches of
      logic to keep this conversation going on and on in the face of clearly
      explained, good advice.
      [color=blue][color=green]
      > > This is just stupid, elegnt coding is hardly as unatainable an ideal
      > > as you seem to be conviced, in fact in this specific case it's a
      > > simply matter of using a standard wrapper function throughtout your
      > > aplication to access your data rather than using proprietary bindings
      > > throughout your application, if your application is sufficently
      > > complicated, perhaps a data abstaction object might be usefull for
      > > this function, perhaps not, if you use any non standard features of
      > > your database server, then write some additional functions as wrappers
      > > for these. It is anything but rocket science.[/color][/color]
      [color=blue]
      > So you have defined "elegant" as "abstractio n" and expect the rest
      > of the programmers to agree that that's it?
      > Thanks for solving that problem for the rest of the world.[/color]

      Se here is a good example of your jumping up and down waving around a
      fallacy a s if it was a point.

      I did no such thing, I only explain what an elegent solution might be
      //in this specific case// just as it says.

      I never claimed to solve the general problem of elegent coding for the
      rest world, this is just you wildly contorting yet again.
      [color=blue][color=green]
      > > What about the human and financial load? As in the load on the DBA,
      > > inhouse developers, consulting budgets and application support staff?[/color][/color]
      [color=blue]
      > The load on the DBA depends on the problems the application makes.
      > That typical increases if the application ignores load reducing features for > the sake of being generic[/color]

      And so does constantly changing everything to support differnet
      databases when he finds your unabstarcted application does not use the
      database that all his other applications do.
      [color=blue]
      > This creates an excessive amoung of simple
      > queries and lots of network traffic. Right now we have huge problems
      > getting an application to work properly that claims to support mysql and
      > oracle.[/color]

      There are bad application out there, including ones that are
      Abstracted, and ones that are not.
      [color=blue]
      > They could have done half the app in PL/SQL and saved 90%
      > of the network and client load.[/color]

      And locked themselves out of the portion of the market which does not
      use PL/SQL, but rather something else, or simply does not want to
      bear the cost that using PL/SQL adds to the product not only on
      implementation, but also in anual licencing and support costs.
      [color=blue]
      > Also, if the database is not the standard one (because you have
      > fixed/improved it) I have, at the worst, maintain two independent
      > installations,[/color]

      No, you only have to maintain the one you actuall have in production.
      [color=blue]
      > As for consulting, we pay a flatrate for db support, so we unload as much
      > of our problems on the oracle people. Works fine.[/color]

      Just because it works fine sometimes, in some cases, does not mean
      that it works fine in all cases, my advice was generic, I am not
      anti-Oracle.

      In most cases it does not make sence to build your application to
      depend on Oracle, or any thing else, exclusively. However there are
      certainly worse products to be dependant on, MS SQL for example.
      [color=blue]
      > Ditto for support staff. Our users have oracle, so the more we make the db do
      > the less problems we have in our own code.[/color]

      Your specific case is not neccesarily the general or even common case.
      [color=blue][color=green]
      > > Are you having a nightmare in which we are dicussing the various
      > > merits of MySQL versus Oracle? Please follow your own advice and read
      > > this thread again so that you might figure out what is it we are
      > > actually taking about.[/color][/color]
      [color=blue]
      > We are talking about open source versus commercial databases.[/color]

      Again, if by 'We' you mean some imaginary person the rest of can't see
      or hear, please ignore my intrusion, however if you mean You and I, we
      are not.

      We are talking about two different things, the advantages of source,
      and the advangates of abstarction of access, I have made no comments
      in this thread regarding commercial versus open source databases
      except to agree that the commercial ones _do_ have more features, that
      alone however does not always
      make them the best choice.
      [color=blue]
      > I picked
      > those two as examples because I have worked with both of them.[/color]

      Great, sadly however, not relevent.
       [color=blue][color=green]
      > > More straw men and red herrings. If you are a Developer, which is who
      > > my comments are addressed to, it is your responsiblilty to your users
      > > and clients to know how your application works and to be able to
      > > support it without allowing some third party to hold them hostage.[/color][/color]
      [color=blue]
      > No one holds anyone hostage. I let people do what they are good at.
      > I'm ok with application programming in the CAD world. Oracle (or
      > IBM, or microsoft) are good at programming databases. So, I
      > profit from their expertise by being able to provide a better application
      > than if I had to do db development (or fixing) as well.[/color]

      However, a closed source contract is designed to hold you hostage, and
      to keep competitors away.
      [color=blue]
      > So far no one has complained.[/color]

      No one you know is not no one.
      [color=blue][color=green]
      > > because Database security can only depend on it, not being able to
      > > actualy protect devices, which is the burden on the OS and networking
      > > environment.[/color][/color]
      [color=blue]
      > The os protects devices, not the network. Or, daring to think the
      > unthinkable,[/color]

      The OS is a part of Network security, what manages user priviledges?
      The Switch? What controls device permissions? Your ethernet cables?

      Your network security is a product of the collection of OSes that make
      up the nodes of your network. And the network is exactly as secure as
      the weakest node.
      [color=blue]
      > do you mean that you consider it ok to have database data on nfs mounts?[/color]

      See, you have just provided an example of how bad network security can
      undermine good database security, there are plenty of others as well.

      My point, once again, is that you can only have Database security,
      *IF* you have a secure network, which means that the nodes on it are
      secure.
      [color=blue][color=green]
      > > What does reading text files have to do with Chip design?[/color][/color]
      [color=blue]
      > Because some tool will have to parse the text and create the chip out of it.[/color]

      Yes, that tool being the Application, the very thing following my
      advice will help you protect. Also, not all data is about creating
      chips, in many cases the data is the purpose of the appliction, and
      can outlive it, sometimes it must, by law, be accessible for a really
      really long time, like in the case of public data, as I said. In this
      case in particular, keeping your data in a self contained, self
      describing, human readable file format is good sence. That is why
      things like XML and dublin core get invented.

      It's unfortunate that you can not see the value of something simply
      because you it is not needed for your specific application, and waste
      my time and yours trying to convice me that because you do not need
      it, I shouldn't recomend it to anyone, and by doing so I prove that I
      am inexperienced, however many years of experience I may or may not
      have.
      [color=blue]
      > This tool typically costs in the range of USD100000-200000 for a synopsys
      > ASIC compiler. You need the same tool because any other tool creates
      > totally different designs, ignores the original constraints and rules and
      > uses a different library which may even force a complete redisign.
      > Compared to that, a database migration is truly a breeze.[/color]

      Then your data does not have a long life span, so why are you
      presenting it as an argument, when my advice was specificly qualified
      to "ensure the perminancy and portabilty of your important data?"

      If your data does not need to be either perment nor portable, why are
      you discussing this, do you really imagine that because you data does
      not need to be permenent or portable, that therefore no data needs to
      be?
      [color=blue][color=green]
      > > I can read
      > > text files I created on my Apple ][, and no, I do not have the orginal
      > > hardware (well maybe my mom does somewhere in her basement).[/color][/color]
      [color=blue]
      > Not all textfiles are notices for you to read.[/color]

      Yet some are, and for this data my advice holds true, I have never
      implied that all data must be kept accessable forever, rather advising
      on what to consider when it does.
      [color=blue][color=green]
      > > Which ones? That abstracting access to suspect dependencies is a good
      > > idea?[/color][/color]
      [color=blue]
      > That elegance is abstraction.[/color]

      The quote says "That abstracting access to suspect dependencies is a
      good idea" not "elegance is abstraction"

      Here you are jumping up and down again.
      [color=blue][color=green]
      > > That database security is secondary to network security?[/color][/color]
      [color=blue]
      > Yes.[/color]

      It is, if you ask a security expert you will find they agree with me.
      [color=blue][color=green]
      > > That
      > > one should keep archives in a format that is likely to be readable
      > > forever?[/color][/color]
      [color=blue]
      > Yes.[/color]

      Instead, archives should be kept in a format that can not be readable
      forever? What do you think archives are for? I don't mean simple
      backups.
      [color=blue]
      > Those are the tree main reasons. The fourth one is your persistent
      > belief that the right to the source code is of value.[/color]

      The right to source code is very much of value in many cases, even if
      it's not of value to you.

      You still have demonstrated nothing about my experience, which you
      still know nothing about. And your insisting on having pretentions of
      being more experienced than me only help you make an ass of yourself.
      [color=blue][color=green]
      > > All these things come from experience,[/color][/color]
      [color=blue]
      > So, what migrations have you done so far?[/color]

      As I've said, I'll rather leave my arguments speak for themselves
      rather than be drawn into a pissing contest about who has done more
      migrations. Since having done more migrations would not make me
      automaticaly correct.

      As I've already tried to explain to you, an argument that attacks the
      arguer instead of the argument is a fallacy.

      When I attack you, it is purely for the fun of it, I refute your
      arguments by addressing them directly.
      [color=blue]
      > Right now I'm in the process of doing two, one boing our board design
      > toolchain, with plenty of data translation and the other a business flow app.
      > So far we've spent at least four man years on the CAD flow and it's far
      > from over. As for the other, try to imagine having a small busines flow
      > tool and then introducing SAP companywide.
      > And we get migration support from the new vendor.
      > Believe me, a database migration is *EASY* compared to that.
      > Even if I hardwire OCI calls into my c-code and then switch to
      > ODBC or something.[/color]

      You mean the same SAP that developed the Open Source SAP DB and is now
      working with MySQL DB in making it MaxDB? Did you not tell them that
      source is of no value? Think of all the effort you could have saved
      them! Forunatly there customers, who value their data, told them
      different.

      In anycase, I'm not intersted in what you are working on. It's
      irrelevent and it sounds banal. Nor does it in anyway strengthen your
      arguments.
      [color=blue][color=green]
      > > your attempt to question my
      > > experience, only show that you are unable to formalute an actual
      > > argument, so you try and discredit the arguer instead of the argument.[/color][/color]
      [color=blue]
      > I did. You just didn't understand it.[/color]

      Yeah, sure. I don't understand your arguments. They are
      incomprehensibl e nonsence.
      [color=blue][color=green]
      > > Oh please, my argument has been presented well enough, attacking me
      > > just shows you can not defend your own, that is if you actually had
      > > one.[/color][/color]
      [color=blue]
      > You might have noticed that you got responses from different people[/color]

      And I responded in kind, if one of them made an argument you feel I
      didn't address well enough, feel free to quote it, although I am happy
      you feel a sence of support from MS SQL shills.
      [color=blue]
      > whereas you are the only one who thinks my arguments are rubbish.[/color]

      How do you know what everybody thinks? you think what is posted in
      this thread represent what everyone thinks?
      [color=blue]
      > Now, statistics is not fact, but it's evidence and should get you thinking.[/color]

      Better evidence is how easily all your arguments are refuted.
      [color=blue][color=green]
      > > If my argument was not backed up by anything it would easy enough to
      > > refute it without attempting to insult me,[/color][/color]
      [color=blue]
      > I don't insult you I'm trying to get through to you.[/color]

      Thanks, from now on I will never abstract my database access, ignore
      network security, refuse to accept source code for any dependency of
      my applications, insist on being locked in to single source for all my
      support contracts and always, always keep my archives in an
      incoprehensible filesystem blob that I can only access by way of a
      third party, closed-source deamon.

      Now that you have educated me on the fact that law suits and not
      source code is what I should depend on, I will give up my long career
      as a developer and begin training to be a lawyer.

      You've really set me straight.

      I bow before your awesome experience.
      [color=blue]
      > Reasonable arguments didn't work.[/color]

      Always ready to go beyond the call of duty for a good cause, huh?
      [color=blue][color=green]
      > > These must be voices in your head that you are hearing. Since my
      > > argument have been quite clear and even sumerized several times.[/color][/color]
      [color=blue]
      > Yes. The right to source code balances nonexisting support and
      > buying support for a open source software (instead of trying to
      > fix things oneself) is somehow better than doing the same with
      > commercial software. Did I leave out anything important?[/color]

      Yes, my entire argument, but dont let that stop you from blathering.
      [color=blue][color=green]
      > > Your arguments amount to the metaphysical belief that only the
      > > copyright holders of your favourite proporiety software know how to
      > > program,[/color][/color]
      [color=blue]
      > No, that they are the only ones that should be allowed because they
      > are the only ones that can take responsibility.[/color]

      See, "the only ones that can," -- they posses a special metaphysical
      quality that no one else posses. Interesting faith you have.
      [color=blue][color=green]
      > > that the very concept of good programming is an illussion,[/color][/color]
      [color=blue]
      > No, it's just that so far no one has found out what it is, because
      > despite all the attempts software still is not substantially more stable
      > than software written 30 years ago.[/color]

      So we should not try to write good programms then? Quick, someone tell
      Don Knuth.
      [color=blue][color=green]
      > > and therfore the only way forward is to make yourself both tehnicaly
      > > and legaly dependent on them as much as possible.[/color][/color]
      [color=blue]
      > You forget that they depend on me. Namely, on my money.[/color]

      God help them then.

      Fortunatly there are other customers.
      [color=blue][color=green][color=darkred]
      > > > So, oracle people should further develop oracle and mysql people
      > > > mysql. Did I get this right?[/color]
      > >
      > > No, that's not right, that's not even wrong.[/color][/color]
      [color=blue]
      > So, what is it?[/color]

      A non sequitor, a red herring, a straw man, a fallacy, irrelevent,
      what it isn't is a response to my argument, neither a right, nor a
      wrong response.
      [color=blue][color=green]
      > > Application developers should avoid locking themselves in to external
      > > dependencies, either by not using products to which they have no right
      > > to the source code, or abstracting access when they do use such
      > > products. Simple.[/color][/color]
      [color=blue]
      > There it is again, this source code right thingie. And you complain about me
      > getting rude.[/color]

      I don't complain, go ahead and serve, I'll snap. I like dozens. I just
      wonder why you're such a glutten for punishement.
      [color=blue]
      > Again: The source code is no guarantee of fixed bugs, much less improvements.[/color]

      Again: Not having source is a guarantee that one CAN NOT fix bugs.
      [color=blue]
      > It's not even what I want.[/color]

      Yet others may not want what you want, do you think that my advice was
      directed at you and your application specifically?
      [color=blue]
      > I also can go and tinker with the airbag of my car
      > if I think it's broken, I don't do that either but go to a repair shop.[/color]

      Yes, and just like software, your financing contract may allow you to
      go to any repair shop, or even fix it yourself if you are able to, or
      it may force you into only using the repair shop of the dealer. The
      later, by the way, is sometimes a rip off.
      [color=blue]
      > And if you are worrying about expiring licences, for many products
      > (purify and our oracle installation spring to mind) you get permanent
      > licences and pay yearly for support, so I can still use the app when the
      > vendor goes bust.[/color]

      Who will fix the bugs when the vendor goes bust? Or compile it for
      your new OS, or your new CPU? Or to link a updated library for which
      there is a security patch?
      [color=blue]
      > And before you come again about the source code I can fix and improve,
      > or pay someone to do it, I won't because that would be wasting company
      > money and that would be because a migration is cheaper than tinkering with
      > the old software and it wouldn't lose us customers either because customers
      > When we figured out that our new CAD tool doesn't support oracle 9.2
      > we gave them a ding behind the ear and, see, the next release, out
      > in two months supports it and til then we got a workaround.
      > don't like dead software.[/color]

      You just do whatever you want, I'm sick of talking to you, however
      surely you must know that not everyone agrees with you, even if you
      haven't noticed that, your reasoning is based on nothing substantial
      but your insistances and pretentions, even so you are entitiled to
      hold your goofy ideas. Good luck to you. Just dont bore me with what
      you want, or what you do, or anything about you at all, or me for that
      matter, stick to the topic or go away.

      And trim your posts better, you don't need to quote every line in the
      previous post, only the ones you actually respond to.
      [color=blue][color=green]
      > > And having right to the source code does not mean that the program is
      > > 'open source,' as you can purchace such a right for propretary code,
      > > as is common for libraries.[/color][/color]
      [color=blue]
      > And still, if something goes wrong, I file a service request.
      > And if the company does ceases to offer the product I change company.[/color]

      Sometimes it's best to change companies and keep the product,
      sometimes it's best to abstract your code to make changing products
      easier. What is your point exactly?
      [color=blue][color=green]
      > > "Assitance" only means that they will provide someone whose time they
      > > can bill you for,[/color][/color]
      [color=blue]
      > As I said, we pay a flatrate.[/color]

      And you get what you pay for, do not imagine they will consent to
      losing money on you for long if their costs go above your flat rate.
      [color=blue][color=green]
      > > not that anything will be accomplished.[/color][/color]
      [color=blue]
      > Then they lose money if they don't accomplish anything.[/color]

      Right, if fixing it costs them more that what you are paying them,
      then they desupport you, and you, not having source code can not find
      someone who can (or will) do it cheaper, and you, thinking that
      database access abstraction is a waste of time, must change your
      entire application. Have fun. Your systems and data may have a short
      enough life span that this works for you, do not assume that this is
      the case for all applications and all data.
      [color=blue][color=green]
      > > Many large companies, and profesional develpoers provide source
      > > licences and/or support open source products, including the largest
      > > computer company in the world, IBM.[/color][/color]
      [color=blue]
      > Yep, so I can buy support, mess up the code I've access to and let
      > IBM sort it out, is this what I get by using a IBM supported mysql?[/color]

      Who is the developer, you or IBM? If you are hiring IBM, why are you
      messing with the code? I'm sure, if you are willing to pay them
      enough, IBM corporate services will indulge this crazy plan of yours,
      but they will probably at least suggest you decide wether it is you
      *OR* them who are developing the code, and if you already have screwed
      it up, perhaps they might prefer to start with a fresh copy from MySQL
      AB.

      But anyway, this is nothing more than you jumping up and down again
      making ludicrous examples.
      [color=blue]
      > If not, what's the difference to buying db2 support?
      > (One thing more: No, if IBM abandons mysql I'm still not taking
      > on the support task, ok?)[/color]

      IBM corporate services will not abondon anything as long as you keep
      paying, heck, this is the company that created VisaulAge Cobol and
      CICS for NT, however if you do have source, you can get someone else
      to take over if you chose. But I know, source code is useless, good
      programming is a myth, data abstraction a waste of time, readable file
      formats are for novices, and network security is nothing but humbug.
      Thanks for enlightening us all. I'm sure you think normalized data
      models are for pussies too.

      Regards,
      Dmytri Kleiner
      Wide eyed heretic, who believes tabs are better than spaces, does not
      have a preference between Emacs or vi, yet actually thinks coding
      standards matter. Go figure.

      Comment

      • Greg D. Moore \(Strider\)

        #63
        Re: What so special about PostgreSQL and other RDBMS?


        "Quirk" <quirk@syntac.n et> wrote in message
        news:4e20d3f.04 05120034.31bd92 ac@posting.goog le.com...[color=blue]
        >
        > Unfortunately you have created unneeded dependencies for them, the
        > worst of which is not MS SQL, since it is fairly easy to get at data
        > in MS SQL and archive it or export it in a usefull way, the worst is
        > that you have tied your customers to a terrible Operating System with
        > a terrible licence, even Oracle users are not so screwed since at the
        > very least they have a choice when it comes to OS.[/color]

        I'm curious about this terrible OS you refer to. I know the one I use is
        stable, hasn't crashed on me once for SQL Server on 1/2 dozen machines for
        4+ years and so far has not succumbed to any security holes. Or is this
        just blatant bias?





        Comment

        • Quirk

          #64
          Re: What so special about PostgreSQL and other RDBMS?

          "Greg D. Moore \(Strider\)" <mooregr_delete th1s@greenms.co m> wrote in message news:<0wBoc.183 156$M3.141910@t wister.nyroc.rr .com>...
          [color=blue]
          > "Quirk" <quirk@syntac.n et> wrote in message
          > news:4e20d3f.04 05120034.31bd92 ac@posting.goog le.com...[color=green]
          > >
          > > Unfortunately you have created unneeded dependencies for them, the
          > > worst of which is not MS SQL, since it is fairly easy to get at data
          > > in MS SQL and archive it or export it in a usefull way, the worst is
          > > that you have tied your customers to a terrible Operating System with
          > > a terrible licence, even Oracle users are not so screwed since at the
          > > very least they have a choice when it comes to OS.[/color]
          >
          > I'm curious about this terrible OS you refer to. I know the one I use is
          > stable, hasn't crashed on me once for SQL Server on 1/2 dozen machines for
          > 4+ years and so far has not succumbed to any security holes. Or is this
          > just blatant bias?[/color]

          Eeek. Someone actually wants me to discuss Windows.

          If you're really interested in learning, which I doubt, read this:



          "Why Windows NT Server 4.0 continues to exist in the enterprise would
          be a topic appropriate for an investigative report in the field of
          psychology or marketing, not an article on information technology."

          -- John Kirch, Networking Consultant and Microsoft Certified
          Professional

          NOTE TO SELF: remember to notice when groups like
          comp.databases. ms-sqlserver are in the newsgroup list and remove them
          in replies, lets at least maintain //some// level of quality in these
          discussions.

          Comment

          • Gawnsoft

            #65
            Re: What so special about PostgreSQL and other RDBMS?

            On Wed, 12 May 2004 13:14:39 +0200, "Volker Hetzer"
            <volker.hetzer@ ieee.org> wrote (more or less):
            [color=blue]
            >
            >"Quirk" <quirk@syntac.n et> schrieb im Newsbeitrag news:4e20d3f.04 05110058.684e59 68@posting.goog le.com...[color=green]
            >> "Volker Hetzer" <volker.hetzer@ ieee.org> wrote in message news:<c7o8i3$3b k$1@nntp.fujits u-siemens.com>...
            >>[color=darkred]
            >> > > > > > That's not true.
            >> >
            >> > > > > Yes it is.
            >> >
            >> > > > What was the value of this reply?
            >> > >
            >> > > What was the value of yours? Or this latest one?
            >> > A question is not an answer.[/color]
            >>
            >> And what was your reply?[/color]
            >I asked first.
            >[color=green]
            >>[color=darkred]
            >> > > Yes, you have the right to be overcharged for work that may or may not
            >> > > not suit your needs by only _one_ vendor, and no right to go elsewhere
            >> > > when they fail, ignore you outright, stop supporting your application
            >> > > or vanish from the face of the earth. Have you actually read your
            >> > > contract or software licence?
            >> > Of course. See the end of this posting.[/color]
            >>[color=darkred]
            >> > > It only protects the vendor, not you.
            >> > I've read the licence and done even more: I've used the software and tested the contract.[/color]
            >>
            >> Realy, care to quote the part of the Contract that Gaurantees you any
            >> rights?[/color]
            >http://oracle.com/support/index.html?policies.html
            >[color=green]
            >> By "tested the contarct" what you mean is you agreed to pay them
            >> completely on their terms and where satisified with the results they
            >> chose to give you.[/color]
            >So, in what way is it different from let's say, buying a cucumber?[/color]

            You are unlikely to be locked-in to purchase decision for your
            cucumber for very long.

            IME they start to go runny after only a week or two in the fridge.


            --
            Cheers,
            Euan
            Gawnsoft: http://www.gawnsoft.co.sr
            Symbian/Epoc wiki: http://html.dnsalias.net:1122
            Smalltalk links (harvested from comp.lang.small talk) http://html.dnsalias.net/gawnsoft/smalltalk

            Comment

            • Quirk

              #66
              Re: What so special about PostgreSQL and other RDBMS?

              [comp.databases. ms-sqlserver removed from Groups, not intersted in
              windows versus unix holy war]

              Erland Sommarskog <sommar@algonet .se> wrote in message news:<Xns94E7EB 1BB3781Yazorman @127.0.0.1>...[color=blue]
              > Dmytri Kleiner (quirk@syntac.n et) writes:[/color]
              [color=blue]
              > The fact that you may found Windows a terrible operation system is
              > of course completely irrelvant to the discussion.[/color]

              That it is terrible is irrelevant, yes, that your application is tied
              to it is relevent.
              [color=blue]
              > If it wasn't clear: we offer our customers a product, and they are not
              > only tied to the DBMS and operating system, they are just as well tied
              > to our product.[/color]

              Which would be a better product if it were not tied to a particular OS
              at the very least, and, if possible, not to a particular database
              either.

              Oracle or Sybase, at least run on several OSes. Not to mention
              PostgreSQL and Firebird. One of these would certainly be a better
              choice than MS SQL, again, not that MS SQL server is particularly bad,
              it's not, part of was writen by Sybase . It's that it traps you in
              Windows.
              [color=blue]
              > As for the platform, the customers knows what they get when they buy
              > our system. If they don't accept Windows, they are not likely to go
              > for us either.[/color]

              Good comanpies educate there clients, bad companies take advantage of
              their ignorance.
              [color=blue][color=green]
              > > I would say you made it quite clear that your basic message was that
              > > it would be folly to do what I was suggesting,[/color]
              >
              > Yes, it would be a folly to do so out of principle always.[/color]

              Ah, thw word 'always' -- after duress, some qualification!

              I have never recomended doing anything always, only given some good
              advice.
              [color=blue]
              > Sometimes
              > it may be necessary, sometimes you are better off tying yourself to
              > one single platform.[/color]

              There are always exceptions to all rules of thumb, however, in the
              case of data abstraction, only extream performance concerns are
              generaly a good enough reason, and then, if your application is so
              specialized that abstraction is not workable, you are _usualy_ better
              off using something for wich you have source code.
              [color=blue][color=green]
              > > It is not, as I've said, it can be as simple as writing a wrapper
              > > function around your data access.[/color]
              >
              > Yes, if you build your system with all logic in a middle layer. Which
              > often can result in serious performance problems, because a lot of
              > data has to travel forth and back over the network. We have a lot of
              > the business logic in stored procedures, and we have also found that
              > this works best.[/color]

              try this:

              * create a wrapper around the execute binding, that way your
              application can at least execute stored procured on any backend that
              supports them.

              * use standard syntax as much as possible.

              * issolate the use of non standardized syntax in as few procedures as
              possible.

              How difficult is that?
              [color=blue][color=green]
              > > Not as expensive as having the system itself obsoleted by an obsoleted
              > > dependency or the inabilty to get support for a dependency due to a
              > > licencing dispute.[/color][/color]
              [color=blue]
              > Well, my company has worked this system since 1992, and nothing close
              > to that has happened yet.[/color]

              Come gather 'round people
              Wherever you roam
              And admit that the waters
              Around you have grown
              And accept it that soon
              You'll be drenched to the bone.
              If your time to you
              Is worth savin'
              Then you better start swimmin'
              Or you'll sink like a stone
              For the times they are a-changin'.

              Comment

              • Erland Sommarskog

                #67
                Re: What so special about PostgreSQL and other RDBMS?

                Quirk (quirk@syntac.n et) writes:[color=blue]
                > [comp.databases. ms-sqlserver removed from Groups, not intersted in
                > windows versus unix holy war][/color]

                It appears that you failed to do that. That is the newsgroup from
                where I read this thread. If you feel this group is not the venue
                for you, just don't reply at all.

                And if you want to avoid holy wars, don't come with blanket statments
                about "terrible operating system" or barf just because people say
                "SQL Server".
                [color=blue]
                > Which would be a better product if it were not tied to a particular OS
                > at the very least, and, if possible, not to a particular database
                > either.[/color]

                Only if you hold non-tiedness as a religious belief. Making a system
                portable over platforms, not the least RDBMSs, is very expensive, and
                I would suggest that our customers prefer to get more functionality
                out of the system.
                [color=blue]
                > try this:
                >
                > * create a wrapper around the execute binding, that way your
                > application can at least execute stored procured on any backend that
                > supports them.
                >
                > * use standard syntax as much as possible.
                >
                > * issolate the use of non standardized syntax in as few procedures as
                > possible.
                >
                > How difficult is that?[/color]

                Very.

                And if you had any experience of developing an enterprise OLTP system
                you would know that.
                [color=blue]
                >only extream performance concerns are generaly a good enough reason,[/color]

                Rewriting an UPDATE statement which actually used standard syntax
                (correlated subquery in the SET clause), to one that use the
                proprietary FROM clause with a derived table, slashed execution time
                from two minutes to a few seconds.

                And those cases are common place when you work with an RDBMS. Even if
                your standard SQL ports from one RDBMS to another (not all support
                the same subset of the standard), you cannot rely on that you
                performance does.

                --
                Erland Sommarskog, SQL Server MVP, sommar@algonet. se

                Books Online for SQL Server SP3 at
                Transform your business with a unified data platform. SQL Server 2019 comes with Apache Spark and Hadoop Distributed File System (HDFS) for intelligence over all your data.

                Comment

                • Greg D. Moore \(Strider\)

                  #68
                  Re: What so special about PostgreSQL and other RDBMS?


                  "Quirk" <quirk@syntac.n et> wrote in message
                  news:4e20d3f.04 05130341.8761e5 8@posting.googl e.com...[color=blue]
                  > "Greg D. Moore \(Strider\)" <mooregr_delete th1s@greenms.co m> wrote in[/color]
                  message news:<0wBoc.183 156$M3.141910@t wister.nyroc.rr .com>...[color=blue][color=green]
                  > >
                  > > I'm curious about this terrible OS you refer to. I know the one I use[/color][/color]
                  is[color=blue][color=green]
                  > > stable, hasn't crashed on me once for SQL Server on 1/2 dozen machines[/color][/color]
                  for[color=blue][color=green]
                  > > 4+ years and so far has not succumbed to any security holes. Or is this
                  > > just blatant bias?[/color]
                  >
                  > Eeek. Someone actually wants me to discuss Windows.
                  >
                  > If you're really interested in learning, which I doubt, read this:[/color]

                  No, I don't seem to be the one who has the closed mind.
                  [color=blue]
                  >
                  > http://kirch.net/unix-nt
                  >
                  > "Why Windows NT Server 4.0 continues to exist in the enterprise would
                  > be a topic appropriate for an investigative report in the field of
                  > psychology or marketing, not an article on information technology."[/color]

                  Interesting, but not the OS in question.

                  Thanks for playing troll.
                  [color=blue]
                  >
                  > -- John Kirch, Networking Consultant and Microsoft Certified
                  > Professional
                  >
                  > NOTE TO SELF: remember to notice when groups like
                  > comp.databases. ms-sqlserver are in the newsgroup list and remove them
                  > in replies, lets at least maintain //some// level of quality in these
                  > discussions.[/color]

                  Yes, we would rather keep the level of discussion professional and based on
                  facts, so please, in the future excuse yourself.



                  Comment

                  • Jeff Rodriguez

                    #69
                    Re: What so special about PostgreSQL and other RDBMS?

                    Sarah Tanembaum wrote:
                    [color=blue]
                    > Beside its an opensource and supported by community, what's the fundamental
                    > differences between PostgreSQL and those high-price commercial database (and
                    > some are bloated such as Oracle) from software giant such as Microsoft SQL
                    > Server, Oracle, and Sybase?
                    >
                    > Is PostgreSQL reliable enough to be used for high-end commercial
                    > application? Thanks
                    >
                    >[/color]
                    _Short Summary_

                    *PostgreSQL*
                    Free, loaded with features, not particularly fast, some extras

                    *MySQL*
                    Free, not so loaded with features, very fast, some extras

                    *SQL Server*
                    /Definetly/ not free, jam packed with features, very fast, lots of extras

                    *Sybase and Oracle*
                    Can't say, I have no experience with them.


                    _Answer to your question_
                    Suitable for a high-end commercial application? I'm not sure I would risk my job
                    on it...

                    We use SQL Server where I work and we well, beat the shit out of the server. The
                    hardware is backed with F.C. NAS from Network Appliance. The actual hardware is
                    a Dell 4-way (excluding Hyper Threading) with ~8GB of RAM and considering what a
                    beating the box has to endure it does really well until one of the developers
                    starts joining half a million records off of a table with insufficient indexes.
                    But I digress...

                    Personally, I wouldn't use it for commercial apps. The commercial solutions have
                    something very useful, commercial backing. This gives them the opportunity to
                    work on the server itself, extra features, extras like management interfaces and
                    clustering software.

                    IMHO current open source RDBMS do not have the robustness, stability, or
                    performance to use in mission-critical situations.

                    _A Message to Open Source Bible Beaters_
                    I'm one of you too, but I also work in a company where we make thousands of
                    dollars per minute. Downtime is /not/ an option and frankly, open source
                    databases are not quite there yet. I forsee things seriously shifting in the
                    next decade or so.

                    Comment

                    • Quirk

                      #70
                      Re: What so special about PostgreSQL and other RDBMS?

                      [comp.databases. ms-sqlserver group removed]

                      Jeff Rodriguez <newsgroup1@gur ugeek.EXAMPLENO SPAM.com> wrote in message news:<40A457C7. 4000304@gurugee k.EXAMPLENOSPAM .com>...
                      [color=blue]
                      > *PostgreSQL*
                      > Free, loaded with features, not particularly fast, some extras
                      >
                      > *MySQL*
                      > Free, not so loaded with features, very fast, some extras
                      >
                      > *SQL Server*
                      > /Definetly/ not free, jam packed with features, very fast, lots of extras
                      >
                      > *Sybase and Oracle*
                      > Can't say, I have no experience with them.[/color]

                      Ok, in very general terms, true enough, but of course anyone making
                      such a choise should ask themselves, what are my performance needs,
                      which features to I need, which extras do I need, etc.
                      [color=blue]
                      > _Answer to your question_[/color]
                      [color=blue]
                      > Suitable for a high-end commercial application? I'm not sure I would risk my > job on it...[/color]

                      But you *would* risk your Job on developing "high-end commercial"
                      applications for which you have no source code for dependencies, or
                      even perpetual access (at any cost) to the dependencies, and a sole
                      source for your support?

                      Interesting priorities your employer has, certainly no real software
                      developement company, like microsoft for instance, would put
                      themselves in
                      such a position, namely making their //own// software, that they have
                      invested there own money in developing, depend exclusively on an
                      //external// product, for which they only have a binary.
                      [color=blue]
                      > We use SQL Server where I work and we well, beat the shit out of the server. > The hardware is backed with F.C. NAS from Network Appliance. The actual
                      > hardware is a Dell 4-way (excluding Hyper Threading) with ~8GB of RAM and
                      > considering what a beating the box has to endure it does really well until
                      > one of the developers starts joining half a million records off of a table
                      > with insufficient indexes.
                      > But I digress...[/color]

                      You do digress, so I'll take this window of offtopicness to say that
                      in no way am I suggesting that one should _never_ use proprietary or
                      closed source applications. For high end or very specialized
                      applications they often make a lot of sence, and are sometimes the
                      _only_ solution.

                      What I am trying to do, is to give some sensibile advice on what a
                      choice between closed and open source really means, namely that closed
                      source means an *exclusive* external dependency, when entering such a
                      dependency you are extreamly vulnerable and should only do so with
                      both eyes open, after you have determined that this is justified for
                      you needs. And even then, you should have an exit strategy so that
                      your investment is not lost when the relationship ends or the external
                      provider's product loses whatever advantage they had when you made the
                      deal.
                      [color=blue]
                      > Personally, I wouldn't use it for commercial apps. The commercial solutions
                      > have something very useful, commercial backing. This gives them the
                      > opportunity to work on the server itself, extra features, extras like
                      > management interfaces and clustering software.[/color]

                      Commercial backing is available for //all// products, closed or open
                      source, except that with open source, you can chose the commercial
                      backer, and with closed source, you can only chose the copyright
                      holder.
                      [color=blue]
                      > IMHO current open source RDBMS do not have the robustness, stability, or
                      > performance to use in mission-critical situations.[/color]

                      That depends on the mission. If your mission really does depend on
                      million record table joins, I may agree with you, if your mission
                      depends on being able to build new commodity-grade servers anytime you
                      need one, with out risking getting sued for 'over-deployment' I may
                      not.
                      [color=blue]
                      > _A Message to Open Source Bible Beaters_[/color]
                      [color=blue]
                      > I'm one of you too,[/color]

                      Then why do you preach FUD?

                      In anycase, open source is a good engineering practice, not a
                      religion, we do not need 'bible beaters' thank you.

                      The real 'bible beaters' are those that endlessly repeat their
                      metephysical belief in the infallibility of closed source vendors, and
                      even they can not agree on *which* closed source vendor is the real
                      infallible one, simular to actual bible beaters and their scriptural
                      disputes. The open source community are better compared to Quakers, no
                      source is sacred.

                      Most of the poor closed-source zealots do not even realize what a
                      small segment of the computer industry licence vending closed-source
                      software developers actualy are.
                      [color=blue]
                      > but I also work in a company where we make thousands of
                      > dollars per minute.[/color]

                      If I where I you I would feel antsy about an application where being
                      down for
                      a minute would cost me a thousand dollars, and yet I had no source
                      code and was locked into a exclusive external support contract. But
                      good luck.
                      [color=blue]
                      > Downtime is /not/ an option and frankly,[/color]

                      Microsoft released an unprecedented release of eight patches that
                      repaired 21 security holes on April 13, how safe where you on April
                      12? Since you have no source code, no one knows but Microsoft (and the
                      hackers).

                      I'm glad you trust Microsoft, I would rather trust the likes of Bruce
                      Schneier.
                      [color=blue]
                      > open source databases are not quite there yet.[/color]

                      For million record table joins, perhaps not, but for large
                      commodity-grade clusters that can handle billions of simple
                      transactions, they may be, as I said, it all depends on the
                      application. Google, perhaps the worlds biggest database application,
                      doesn't use any database products at all, comercial or otherwise, but
                      rather uses their own specialized code built on top of as many lines
                      of open source code as they can their mits on.
                      [color=blue]
                      > I forsee things seriously shifting in the
                      > next decade or so.[/color]

                      Really? I see the barbarians of the Open Source database world
                      storming the datacenters quite aggresively, PostgreSQL, MySQL, MaxDB,
                      Firebird, SQLite, and many other less prominent ones. And NetApp is
                      losing ground to the likes of DRDB. Huge powerhouses like IBM, SAP and
                      Novell are joining the charge, if you think the paradigm shift is a
                      decade off, you need get out of your chair and look out of the window
                      a little.

                      Not much longer than a decade ago there was no MS SQL Server.

                      Comment

                      • Erland Sommarskog

                        #71
                        Re: What so special about PostgreSQL and other RDBMS?

                        Quirk (quirk@syntac.n et) writes:[color=blue]
                        > [comp.databases. ms-sqlserver group removed][/color]

                        You really need training! You failed again! (And while you are at it,
                        drop comp.lang.ruby which we both were requested by mail to do.)
                        [color=blue]
                        > But you *would* risk your Job on developing "high-end commercial"
                        > applications for which you have no source code for dependencies, or
                        > even perpetual access (at any cost) to the dependencies, and a sole
                        > source for your support?[/color]

                        It happens to the be the case that in my position as an SQL Server MVP
                        I could get access to the source code for SQL Server, or at least I
                        think so. But I have not taken up on this offer. Why? Because I would
                        absolutely no use for it. I know about SQL programming, the SQL Server
                        source code is a lot of C++ code which is far beyond my field of
                        expertise.

                        And this applies to the very vast majority of SQL Server users.
                        [color=blue]
                        > Most of the poor closed-source zealots do not even realize what a
                        > small segment of the computer industry licence vending closed-source
                        > software developers actualy are.[/color]

                        I don't know if there are any closed-source zealots out there. I am
                        certainly not one of them. If I knew that MySQL or PostgresSQL was
                        the best solution for someone, I would not hesitate from making the
                        recomendation. Admittedly, it is a bit unlikely, but that is only
                        because my expert knowledge lies with SQL Server, so I would really
                        know what I am recommending. (And, no, I would not recommend SQL
                        Server, just because I know that one well.)


                        --
                        Erland Sommarskog, SQL Server MVP, sommar@algonet. se

                        Books Online for SQL Server SP3 at
                        Transform your business with a unified data platform. SQL Server 2019 comes with Apache Spark and Hadoop Distributed File System (HDFS) for intelligence over all your data.

                        Comment

                        • Jeff Rodriguez

                          #72
                          Re: What so special about PostgreSQL and other RDBMS?

                          Part of the beauty of SQL is that there are standards which if you try and stick
                          with, you can relatively easily migrate to another solution such as PostgreSQL
                          once they reach maturity. PostreSQL really does support a lot, however they're
                          missing the speed, tools, and high-availability addons of MS SQL Server.

                          For a company that does thousands of dollars worth of transactions per minute,
                          such as the one I work for, that $14,000 per processor is a small price to pay
                          for the reliability we can get from a commercial app. such as MS SQL Server.

                          Do I like the fact that MS SQL Server is closed source? Of course not, however,
                          if I had a choice of commercial support providers I would definetly choose
                          Microsoft; open source or not. I don't know if you've ever had to use their
                          support, but you can get on the phone with them and within a couple hours have
                          just about anything worked out. Why? Because they're big, they've seen damn near
                          everything.

                          I do not believe that closed source software it infallible, however nither is
                          open source. Now I'm not going to say that we've never been hacked, because
                          saying so will make me out to sound like an ignorant ass. Instead I'll say that
                          we are not aware of ever having any problems with our SQL Server being hacked.

                          Anyway, down to what matters:[color=blue]
                          > What I am trying to do, is to give some sensibile advice on what a
                          > choice between closed and open source really means, namely that closed
                          > source means an *exclusive* external dependency, when entering such a
                          > dependency you are extreamly vulnerable and should only do so with
                          > both eyes open, after you have determined that this is justified for
                          > you needs. And even then, you should have an exit strategy so that
                          > your investment is not lost when the relationship ends or the external
                          > provider's product loses whatever advantage they had when you made the
                          > deal.[/color]

                          In the case of SQL Servers, sticking as close to standard sql as possible gives
                          you an exit strategy. Extremely vulnerable? I disagree, if Microsoft were to die
                          tomorrow by some will of the software gods, someone would just pick up the
                          pieces and carry on where they left off. MS SQL Server would be sold to someone,
                          along with the licensees, yadda yadda yadda.


                          In conclusion I do not agree that using a closed SQL solution makes you
                          vulnerable, because there will always be support for you as long as the product
                          is still popular. MS SQL Server is very popular, and by the time one might
                          consider switching to a new solution, the open source solutions will be large
                          enough to be considered viable. Hell, if we're lucky maybe Novell will pick up
                          PostgreSQL...

                          Comment

                          • Galen Boyer

                            #73
                            Re: What so special about PostgreSQL and other RDBMS?

                            On Fri, 14 May 2004, newsgroup1@guru geek.EXAMPLENOS PAM.com wrote:[color=blue]
                            > Part of the beauty of SQL is that there are standards which if
                            > you try and stick with, you can relatively easily migrate to
                            > another solution such as PostgreSQL once they reach
                            > maturity.[/color]

                            I like the seats and dashboards of my BMW, so just yesterday, I
                            pulled them out and put them in my wifes Ford Escort, but damn,
                            the car just doesn't seem to perform as well. I really thought
                            the car industry standard was supposed to take care of these
                            performance degradations.

                            --
                            Galen Boyer

                            Comment

                            • Daniel Morgan

                              #74
                              Re: What so special about PostgreSQL and other RDBMS?

                              Jeff Rodriguez wrote:
                              [color=blue]
                              > _Short Summary_
                              >
                              > *PostgreSQL*
                              > Free, loaded with features, not particularly fast, some extras
                              >
                              > *MySQL*
                              > Free, not so loaded with features, very fast, some extras
                              >
                              > *SQL Server*
                              > /Definetly/ not free, jam packed with features, very fast, lots of extras
                              >
                              > *Sybase and Oracle*
                              > Can't say, I have no experience with them.
                              >
                              >
                              > _Answer to your question_
                              > Suitable for a high-end commercial application? I'm not sure I would
                              > risk my job on it...[/color]

                              Interesting list ... Speed and extras. Not one would be on my list
                              of most important considerations. How about rating them on:

                              1. Security
                              2. Stability
                              3. Scalability

                              If it isn't secure who cares how fast it is?
                              If it isn't stable who cares how many features it has?
                              If it won't scale to the number of users who gives a rip about extras?

                              And, to be quite blunt, if the only operating system it will run on
                              is Windows that becomes a limitation affecting all of the above. Any
                              time you database server is at risk from every 16 year old on the
                              planet. It can't really be called secure or stable.

                              --
                              Daniel Morgan
                              We make it possible for you to keep learning at the University of Washington, even if you work full time or live outside of the Seattle area.

                              We make it possible for you to keep learning at the University of Washington, even if you work full time or live outside of the Seattle area.

                              damorgan@x.wash ington.edu
                              (replace 'x' with a 'u' to reply)

                              Comment

                              • Howard J. Rogers

                                #75
                                Re: What so special about PostgreSQL and other RDBMS?

                                Daniel Morgan wrote:
                                [color=blue]
                                > Jeff Rodriguez wrote:
                                >[color=green]
                                >> _Short Summary_
                                >>
                                >> *PostgreSQL*
                                >> Free, loaded with features, not particularly fast, some extras
                                >>
                                >> *MySQL*
                                >> Free, not so loaded with features, very fast, some extras
                                >>
                                >> *SQL Server*
                                >> /Definetly/ not free, jam packed with features, very fast, lots of extras
                                >>
                                >> *Sybase and Oracle*
                                >> Can't say, I have no experience with them.
                                >>
                                >>
                                >> _Answer to your question_
                                >> Suitable for a high-end commercial application? I'm not sure I would
                                >> risk my job on it...[/color]
                                >
                                >
                                > Interesting list ... Speed and extras. Not one would be on my list
                                > of most important considerations. How about rating them on:
                                >
                                > 1. Security
                                > 2. Stability
                                > 3. Scalability
                                >
                                > If it isn't secure who cares how fast it is?
                                > If it isn't stable who cares how many features it has?
                                > If it won't scale to the number of users who gives a rip about extras?
                                >
                                > And, to be quite blunt, if the only operating system it will run on
                                > is Windows that becomes a limitation affecting all of the above. Any
                                > time you database server is at risk from every 16 year old on the
                                > planet. It can't really be called secure or stable.[/color]


                                Oh, I dunno. Stick it behind a firewall with some AV software and at
                                least keep it (OS and AV) minimally up to date, and it will do quite
                                reasonable service, and the script kiddies can be largely forgotten about.

                                Would I want to do a database on Windows that was servicing 2000 users?
                                No, not really, though I think it might just conceivably stretch that
                                far. But 200? Yes. With rather vital data? Yup. Been there, done that.
                                Can't mention specific names, but the Australian securities market
                                springs to mind.

                                Windows *is* an operating system. It might not be perfect (which one is?
                                And you're not allowed to mention VMS in your reply to that rhetorical
                                question!). And it might have its issues (they all do). It might even
                                have more issues than most others. But it does the job, for many people,
                                in many circumstances.

                                As a happy user, at one time or another, of DOS, Windows Kiddie (er, 2.0
                                to 98), Windows Proper (NT to XP), Linux, Solaris, Tru64, Novell, BeOS
                                and OS X, all have their quirks and all have their perks. I know which
                                one I'd implement Oracle on (Linux by choice). And I know which one will
                                be easiest to manage (Windows by a long shot).

                                But life would be far more productive if people would stop dissing the
                                tools that others use perfectly happily, and instead were to concentrate
                                how to make the best use of *whatever* tools that fall readily to hand.

                                Regards
                                HJR

                                Comment

                                Working...