Why is prefered SQL versus Xbase(dbase,foxpro,clipper)?

Question

I worked many years with xbase(dbase,foxpro,clipper)
Now,I work with Sql(Oracle,MsSqlServer).
In fact, the goal of Xbase and SQL is the same, but in my
opinion, Xbase is more intuitive and efficiently.
I do not understand ,why today, Xbase has lost his popularity,
and Sql is so widely used

Answer 1

Yes...you are absolutely right! and you forgot something else. XBase is cheaper than SQL.

I do not know how old you are... maybe yo do not know the history about VisfualFoxPro.

Some years ago, existed a product called "FOX" with the best technology to do a search and easy programming commands to handle a database. That search technology is known as "Rushmore" for others historical reasons which I don't want mentione here. In those years Microsoft also had nothing to offer to database programmers about database handle, except "BASIC" to work with sequential text files. Pretty unefficient!!!

So this giant Microsoft bought "Fox" including search technology.

Microsoft changed his programming language "BASIC" by including database commands and including off course, "Rushmore". BASIC will not dissapears because it is the Bill Gates's favorite baby and made by himself when he was very young.

FoxPro has been in a midle of battles many times, because Microsoft wants to kill it since many years ago and on the other edge, fox programmers around the world fighting for demands of new and better versions of VFP and demanding to microsoft keep it alived.

Keep this in your mind: "VFP is an adopted boy", "BASIC or Visual BASIC" is the actual bill's boy.

and keep this on mind: "Nothing will be faster than a fox"

ok dude, no more history.... hope that clears your mind. Good luck!

Answer 2

Actually SQL is not a Microsoft offering and I'm not sure why so much is being made here of Microsoft which, while it may have its own proprietary version of SQL, is so similar to the basic version as to make no difference. It is an industry standard. All the big RDBMS suppliers use SQL, Ingres, Sybase, MSSqlserver and Oracle. The ones you mention for Xbase are not really used much by the industry. It has been around for decades, IBM use it on their mainframe DB2 offering. SQL was around before Xbase and it will outlive it because it happens to be the most portable DB access language and it also the best.

Answer 3

You're right, but Microsoft is so big they just want ppl to do it their way or no way! Altho many other stuff is better than microsofts products, its becoming a Microsoft world!

Answer 4

Capris & a tank top. Flip flops. You remind me that I have several skirts in my closet, and now that I have some tan on my legs, I need to get those out & wear 'em!!