新聞財經娛樂♬資訊 News Economy

I studied SQL before , and the code is easy I think or that I  might not experience tough code.
The question is as follows.
 
1- If I am really familar with php or c coding, do I still need to use mysql if my number of
users are just 100,1000,10000, for example only ? Why I ask this question becoz
sometimes, there is a lot language or website Sql monitor service, login and password to be kept in our memory. If  for non-programmer, I think mysql is easy for them, If you are good programmer, I think Mysql is no need for you, Right ?

2- If question one is yes, not neccessary to use mysql if you are good programmer with
just handling 10000 users,
Why Oracle is so big  on database technology, what is behind ? Is it becoz they can handle
100000000000000000000000000 or infinte data entry database for users with using its
system ? Or they are doing well on security on database not just huge database entry

3- I want to give up to use Mysql since I'm familar with php and users is just 10000 only. Do you think that is saving time for me and save money to pay Mysql monitor service ?
Since I strongly believe php code can cover Mysql coding

Please advise

Duncan

Most of the time, in this world you get what you pay for.  If you don't want to pay the price for a product like Oracle and you want to use a "free" database tool instead, you can do that.  You just won't get the features that Oracle includes.

Or, if you prefer to take the time to build your own record-keeping system using php or c and simple *.csv files, you can do that.  But, you may find this takes you a long time, and you may encounter problems that databases already have built-in features to handle (thing like: multiple users, record locking, data concurrency, security, etc.).

Just like if you want to travel from Paris to Singapore, you don't have to buy a plane ticket - you could walk.  It is the same with computer databases.  You can buy one that includes lots of features and allows you to quickly set up an application, or you may choose to build you own.  No one is forcing you to buy an Oracle system.

I'm really looking forward to getting your version of Windows 9 ;-)

There is NO "general" answer here!

I totally agree with slightwv.

>>Is it Oracle so big just because all business companies get used to use it ?

Or do they use it because Oracle is so big?

There is no answer here.

You should not also generalize Oracle to MySQL.  MySQL is just one of MANY products Oracle owns.

I suppose I should also point out that Oracle Express is free for production use.  It just has size, memory and CPU limitations.

SQL Server also has a free version.

>>Oracle is so big to dominate

All of the above.  With a little help from the previously mentioned marketing and sales people.

Biggest advantage: Runs on all platforms and is enterprise level.

You could do this manually, I suppose even with Assembler, BUT do you really want to build your car from scratch by your own or "just" buy that one that fits your needs?!
There is a reason why software like RDBMS exists....

>>Could we say php can NOT do sql 's RDBM and column locking ?

Databases are written in code so you can write code to do it...  so, I guess it is 'possible' to do with php.

Relational Database Management System

not just "flat" files scattered all over your disk(s) ;-)

I don't know how much you save by giving up cPanel.  I don't know whether this is a good value trade off -- saving the money or having the tool.  Should a carpenter sell his saw or hammer?  I can't answer that in the abstract.

MySQL is free.  I am sure there are both free and paid tools for working with MySQL.

Databases are soooo much more than just column locking.

There is the 'Relational' part of RDBMS.

There is also data integrity, constraints, indexes, etc...  Way to much to go into here.

imho: CSV != DB and Spreadsheet != DB

Use it or leave it ;-)

.... or take Couch DB^^

It sounds like you have already made up your mind to not use databases and are looking for us to confirm this.  Sorry, I cannot.

It boils down to return on investment.

Can you 'buy' something cheaper than you can write and maintain it?

It's also hard to build in relationships to a flat file CSV layout.

As far as the monitoring service:  Do you have to use it?

For just 10000 users why bother programming at all?
You can keep track on index cards, or if you want to use computer enter the data in a spreadsheet.
:p

>>What is special of Mysql from php coding ?

Don't know.  I'm not a PHP coder.

Can PHP handle record/column level locking, read consistency, transactions?

If PHP can do everything then I doubt smaller database products would have ever been created...

Use the right tool for the job.

Use the data base.  You obtain no advantage by avoiding it.  Choose any PHP extension except MySQL.

Oracle is successful because they have a great many salesmen who are highly paid to tell everyone that Oracle is a good product.

None of this has anything to do with being a "good" programmer.  It's about choosing the tools that give you the most advantage.  But the question sounds kind of like, "If I am a good carpenter, I do not need to use power tools?"

How will the data be used by the users?

Will you have transactions where any user can insert/update/delete any row?

If you have data, what are your options if not a database?

XML files on disk, flat files on disk?

If you go with files on disk, you run into issues with record locking, transactions, etc...

Databases are for data.  Why not use them?