I need a non-bias option! MYSQL OR SQL?

[system]

yep, I just had to point that out, not sure why

[system]

Well i keep with my statement. mSql suc*s big time… got serious issues. I am not a fan off ms anyway but… …

ill rather do mysql even for a site like that. if not that and you can afford it ( its not that to difficult to handle it.) go with oracle…

[system]

@JustJeff

If money isn’t an option, use MS SQL.

It’s faster, it’s more robust, and it’s got things built-in that make money-related issues ‘better’ on MS SQL - specifically, foreign key constraints, transactions, etc.

It takes a while to fully explain the concepts, but essentially, MS SQL will allow you to guarantee that if the database died in the middle of an order, it will always be in a consistent state - either the order got processed, or it didn’t. You won’t have to worry about the person being billed, but the order not appearing in their records, or the order getting processed, but quantity/inventory tables not getting updated - you can force all actions be complete, else they all get rolled back. This is VERY important in money-related database applications.

Yeah thats what i found out. I know lots of people love MYSQL but really for businese prupose MS SQL really is the best way to go. Like you send its good how ether it goes in or not, if it wasn;t like this it would cause lots of problems.

I was looking at orcale BUT its very very hard to find people who use it and they usually charge more. I think MS SQL is better. BTW whats so good about orcale

[system]

@dreamer

I was looking at orcale BUT its very very hard to find people who use it and they usually charge more. I think MS SQL is better. BTW whats so good about orcale

There’s a saying in the business world (OK, in obscure corners of the IT world) that goes something like:

‘A good DBA is second only to a good accountant’

Good database admins cost a lot of money, and that’s true for MSSQL, Postgres, and Oracle. Knowing how to optimize a DB is classic theory (you can take courses on it at any 4 year college, and I have), but applying that theory to the real world is challenging - you have to be able to watch a live DB, modify the structure, push the changes back to the developers, tune their queries, tune the system (occasionally rewrite parts of the system - a lot of the work on FreeBSD lately has been pushed back by Yahoo as they find limitations of the threading implementation).

Oracle is fast. It’s very fast. It also supports some advanced concepts (transactions, rollback, etc), which until recently, some of the free databases lacked (specifically MySQL). It also runs on Unix platforms, which MS SQL intentionally lacks. If you were building a very large system that had to be up 99.999% of the time, you don’t plan a base on Microsoft, unless you want to pay out the nose for some clustering server package. You can go with Oracle on Unix (Solaris, Tru64, HP-UX, AIX, Linux, FreeBSD), for a fraction of the cost and have a really good chance of hitting the uptime numbers you need.

[system]

ahh i c.

What would oracle use as its scripting language?

BTW, a web development company wants to use MS SQL databases with MSDN. Is MSDN good?

[system]

I don’t believe msdn is a language, as far as I know it’s just a group of people on microsoft. msdn.microsoft.com is their site, and it just has all sorts of code documentation and stuff. I believe it only deals with asp.net for server side stuff, no jsp or php or anything.

[system]

Oracle can be used with about any language you want.

[system]

Structured Query Language. Databases use SQL. It is pretty much the same between databases but there are slight variations in SQL between databases. So if you know SQL you can handle Oracle, MS SQL and mySQL.

http://www.w3schools.com/sql/default.asp
http://www.sql.org/

[system]

ahh ok.

Well thanks everybody for the tonnes of responces. really did help alot!

THANKS!