Link to home
Start Free TrialLog in
Avatar of duncanb7
duncanb7

asked on

Do I need to use Mysql ?

Dear Experts,

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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of duncanb7
duncanb7

ASKER

becoz I can make my database saving in csv file format with php coding
 and stored into my disk.
I can convert csv file format to mysql format once I need to use mysql.
but at least I don't need to be always remeber mysql syntax or method for just
10000 users
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Whether php script can handle all  ? since Mysql is also based on cobol language

What is special of Mysql from php coding ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
yes, right, Ray
Recently,  just in these month, I gave up to use Cpanel  becoz I already know how to install
all free software kid such as awstate, phpadmin, something like that etc..., why I need to pay for Cpanel.  I am not SAYING Cpanel is not good tools , Cpanel is good tools for beginners who doesn't know about the programming language or not-interesting programming lauanges customers.

next cases, when go to free tool of mysql but  mysql monitor service is another service and that
also need to pay...Just think you go to move every step on internet, need to pay
if you don't know computer system or language

Duncan
if I can have csv file to store as database, why worry about it in spreadsheet
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for your reply, now,

Summary to those key word,

Mysql's power on columne level locking, database in spreadsheet that Php not be easy  to
replace him,  Is it right ?
hope next reply for that

If I go to wrong road, I need to go back to Mysql that waste time for myself
if I would like to use php to replace mysql for just 10000 users
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Could we say php can NOT do sql 's RDBM and column locking ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So next thing, why Oracle is so big to dominate all Sql database market becoz
they handle Infinite data entry or database using Sql or doing well on databse security
that other languages can not handle it, even it is possible for other language but need a
time to develpe but the market is already on his hand.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
honestly, if my boss agree me what I say, and let me to use php to replace sql, I will
reply him why don't use Mysql from Oracle, it is  funny reply from me, becoz I also need to sleep

Is it Oracle so big just because all business companies get used to use it ?
change will be big problem for internal company employees or employers

That is not becoz of any language advantage for Oracle's makert dominate
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You should not also generalize Oracle to MySQL.  MySQL is just one of MANY products Oracle owns.

Sound like mysql is not important to Oracle, If yes, Mysql is not special or magic product, other lanaguages  can replace him easily if spenting time to develope or just half-year on php coding

If all yes, my three questions could be finalized soon
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
before window-9 version , I need to sleep first and reply you window 7 is better than window 9 new version even it is not released yet, so I understood why  people are still loving
mysql

Since there is no general answer, I would like to make the score even for sharing
Thanks for all of you reply,

I will try to replace Mysql by php for testing purpose only for cutting cost
>> testing purpose only for cutting cost

What cost?  The only cost you mentioned is a monitoring service.  You never stated what this service does that you cannot code yourself?
https://www.webyog.com/
the monitor service is a pay service.
And I tried his demo, no magic except on window friendly, if
know linux command, it will output the same result but in text format.
I am willing to pay but too many package to need to pay that is not important
if I can pay for all in one page.

Now I have 20 parties, 20 login and 20 passwords without including my bank,
electricty, tax, ISP and 20 computer language, 20 friends, 20 ......
20 social forum like facebook, twistter, ....

So business idea will be soon for customers for one account

I imagine you don't need to remember anything, one year later, you'll receive something
like

Sir, My company will take care for you with my system within just one login and password
to handle your 10,000 connected company serivce.
Even you moved to new place, we will handle for you with just $20 /per month




I write down all login and password in one paper or in one compute file. but
I forgot where is the paper and file.

Idea is coming like e-bay, google,.....facebook,

Duncan
>>no magic except on window friendly, if know linux command, it will output the same result but in text format.

So, we are back at free and your comment "testing purpose only for cutting cost" is not accurate.  Free versus your development time to write database code.