i believe that mysql has ACID aswell. And if money is not the problem why not buy the mysql pro ?
well i’ve been looking around at companies and MYSQL systems will take longer to build. Also its really so that there is room for growth, I know that mysql is great for small stuff, but when it comes to more complex and damanding stuff its starts to get… yeah. Well there is no point in getting MYSQL PRO, since i’m not buying any software at all. I am getting a application developed and hosting it on a “.net” server, it of course works out to be cheaper and more reliable. You don’t need to buy any SQL server software unless your planning to set up a server yourself.
BTW if i have my SQL Databases off a host, when I need to download the databases and intergrate into accounting software such as Quicken or MYBO will i need to have SQL server running on my computers?
OR i think it works to just have the database on my host and just connect to it using like simego or something. Ether way i’ll need to transfer database information from the host to my computers. So that instead of hosting the database off our own server which is expensive and unreliable, that instead i have the database on a host then my computers just “synchronise” to the host database?
ALSO is this safe?
I really now have choosen to use SQL and ASP since its more a e-commerce kinda thing. WOuld you say SQL and ASP is as (or even more) safer than MYSQL and PHP. OR it really doesn’t matter and it’s just how the company scripts it?
btw, i checked and i’m pretty sure MYSQL doesn’t have ACID. I think MYSQL backsup every so minutes. But SQL i’ve heard is so good that it even backsup while a process is still happening, so it can finish off that process once its back online.
SQLserver is owned and developed by M$, but M$ bought it from another company, that is what I was trying to clarify. But SQLserver is more advanced than mySQL.
BTW if i have my SQL Databases off a host, when I need to download the databases and intergrate into accounting software such as Quicken or MYBO will i need to have SQL server running on my computers?
I am not sure what you are saying here. Do you mean you are running SQL from a remote host and connecting from a completely different location? Bad, don’t do it. Not secure at all.
Software will have some method to connect to the database, like ODBC. I have never used Quicken, so I don’t know the logistics of it.
I wouldn’t necessarily say ASP is better than PHP for eCommerce. PHP5 just came out of beta and the new Zend engine, so it’s progressing very fast.
MySQL’s licensing is free - if you redistribute it, then you must distribute the source code as well, but for web apps, commercial or not, then it’s free.
Oracle rocks, but is very expensive. There are other relational database systems like PostgreSQL as well - Postgres is very feature-rich, but quite slow. There’s also SQLite - which is very fast and light.
MySQL is a good balance between speed and features.
SQL is in no way safer than MYSQL infact there are many security issues with SQL. the same for ASP, infact all ms products have serious security issues.
mySQL is free in some circumstances, but read the licensing because in some cases it isn’t and it isn’t cheap. You are basing off the GPL, but mySQL doesn’t use the GPL anymore, they call it the LGPL or something like that.
ASP is as secure as the programmer writing the code. M$ does have lots of exploits, but *nix systems have lots of vulnerabilities as well. Your network is pretty much as secure as your admins are able to take care of it.
Yeah, I mean MYSQL has problems too i mean if its not programmed right it could be vunvarible to SQL injection etc.
With ether SQL or MYSQL most people if not all have it on a remote computer (host). Isn’t this really the most relistic way to do it? If it is on a remote computer ho would you connect to the data? If its not safe then how do people usually do it?
MYSQL and SQL are basically the same in cost, since you only need to purchase web hosting with the supporting platform. Of course SQL cost a bit more but thats ok. My programmer said that i don’t need to go out and buy sql server software or anything. And that i can just download the databae over onto my computers then use a free SQL editing / viewing / creating software such as simego.
sql is simply a language that many servers use, asking this question is like asking “should I write my site in a language or php.” If you are comparing mysql to other products such as postgresql, then I’d suggest mysql simply because of it’s compliance with php and because there is so much more support for it. It also is a very simple solution to setup.
I’m getting a bit confused on what you need. Are you looking at renting web hosting from a company not related to yours? I was under the impression you were setting up your own servers and all that. But maybe that was not your intention.
No you really never connect to a database externally. It’s frowned upon and most hosting companies would not appreaciate it. What you do is connect to it internally from the server via loopback address or in some cases on another server from within the network.
So if you have an application built from php / mysql. You connect to the webserver, which parses the php pages, the php engine makes calls to the database and returns html output to you. That happens on the server level. You never actually connect to the database from your computer. The server handles it. What it sounded like is you wanted to actually connect directly to the database from your desktop via the web. That is not something you want to start doing.
Ahh ok.
my fault i didn’t make it clear from the beginning. What i am trying to get done is a software which will take care of payments, inventory, shipping, checkouts etc. Basically a shopping cart however, i need to get it customised since the shopping cart i need it very different to existing ones.
And this shopping cart will be hosted on a external computer (web host). I’m not setting up a server, this is too expensive.
What i am really asking is what database type should this shopping cart run on, MYSQL or MS SQL? RIght now i want it to be built on MS SQL because its faster and cheaper to get built.
Another question was when using MS SQL what language used be used? eg. asp etc.
So i hope that makes it clearer.
ALSO when using MS SQL i will need to use a .net server, this is where you got confused. I was just saying that i will be getting a host with .net, i’m not setting up a server.
In short, getting software compeleted (I will likely go with MS SQL), which lanuage used be used (I heard MSDN is good but i can also use asp), when going with MS SQL databases will use .net hosting.
Ah, ok, that clarifies it…
What I would probably do is:
mySQL <-> PHP
M$SQL <-> .NET
You will save money going with php / mySQL … hosting will be a lot cheaper and so will a dedicated server if need be.
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.
if money ain’t an option and you need the best, get oracle 
Oracle is more difficult to manage, and though money may not be an option, finding a competant Oracle admin can be very difficult.
Great database, though.
yep, I just had to point that out, not sure why 
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…
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
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.
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?