Re: Oracle comparison

Daniel Morgan wrote:
>
> Generic Poster wrote:
>
> > Hello, at the risk of flamebait, I would like to ask you to comment on
> > how or why you think Oracle compares favorably with other db products,
> > both commercial and free. We do web development, and were recently
> > contacted by a client who wants us to design a db for him on the web,
> > which would be like a data warehouse for, say, up to 100 little
> > webstores. We do not know a tremendous amount about the db field,
> > though we can make them just fine. We recommended at first MySQL, then
> > decided on PostgreSQL. The question also came up whether a commercial
> > db would be the answer. We felt that at less than 4 TB, open source
> > would do well but that more than that, commercial might be the way to
> > go.
> >
> > So, feel free to comment, knock the competition, point me to some
> > webpages, whatever....
>
> I guess it sort of depends on a lot of factors. Things like:
>
> 1. Stability
> 2. Security
> 3. Performance
> 4. Need for advanced features
> 5. Need for support
> 6. Need for educational materials to support future development and
> maintenance
> 7. Concerns about whether the vendor will still be in business in five
> years
>
> Quite frankly I am very bothered by the thought that you, and your company,
> would consider using a complex product of which you appear to know little
> and expect to create anything but a complete disaster.

Well.....it was more the case that we were avoiding the commercial SW option, or attempting to avoid it. That is why we recommended PostgreSQL. But we were curious about what the advantages of using the commercial stuff were, and wanted to broaden our knowledge of this area. The problem would have been that I do not have many employees who know much about the commercial db's. I have a few guys who have worked with MS SQL, and, in answer to your question, I do have one employee who says he has experience working on Oracle. :) So, that was why Oracle was in the game. If the client would have decided on Oracle, I would have had that worker build it. No, *I* don't know Oracle very well but I believe my worker knows it pretty well....anway, he lists it on his CV, and he has Oracle installed on his development box at home. :)

You are correct, if we had no Oracle experience, we may have had to blow off the job if the client insisted on a solution. Thx for your comments, though. Some of my workers here tell me, "All these SQL db's are pretty much the same. If you know SQL, you can work with any of them." Looks like this is not true.  

 How can you, in good
> conscience, think you could possibly create a good product in Oracle?

We weren't really considering it. We recommended PostgreSQL. We are *curious* about learning more about Oracle. That said, I do have a programmer who claims he can do Oracle programming. :) His experience is Oracle 8i. And he does have an Oracle dev box at home. :)

 Do
> you understand multiversioning? Do you understand Oracle's transaction and
> locking models?

You have to ask my programmer. These are the things that I would like to learn about myself. I basically am just a capitalist who does nothing more than funds and runs this company here; my IT knowledge is somewhat limited (not a programmer). My employees are the ones who know about this stuff. That said, considering it is my company, I do have to know a bit about that stuff.
>
> Given that the likely outcome of this is that you will just make a huge and
> expensive mess ... let me suggest Microsoft SQL Server to you as an
> excellent choice.

No, we are sticking with PostgreSQL. We know we can do a nice PostgreSQL database. We have done them before. :) And, no, they were not huge, expensive messes. :)

You really don't know what kind of a company I run here. We blow off work all the time because we either don't have the skills, or don't have the skills at moment, or the present crop of employees has poor skills in that area, or whatever......I don't like to do crappy work, unlike so many of my competitors. Received on Tue Jun 18 2002 - 17:45:30 CDT