MySql is supposed to be the latest and greatest database management system, and they say it can be used from almost any programming language.
My question: Can MySql be used from QuickBasic or QB?
Other than the fact that QB is not GUI, and runs under MSDOS, the other big disadvantage is that its file handling is very rudimentary. Access to something like MySql would vastly improve its file capabilities and image.
About 12 years ago, we QBers used a database handler called Btrieve, by Novell. But for some reason it has fallen from grace over the past 7 years or so, even though it was bought out by Pervasive.
*****
i don't think that we can use MySql with qb. But then again i wouldn't need to
You could probably create an interface for Qbasic to work with MySQL in a similar way that DS4QB works with DirectX, but I doubt that the effort would be worth it. It would be far easier to use MySQL with a Basic variant such as VisualBasic or XBasic that runs on the same systems that MySQL runs on.
Thanks Ruudyboy and LooseCaboose.
Anybody else have any ideas on the issue?
*****
Stop dreaming :lol:
seriously, it would be nice to have that, but as loose says, too much effort...
RapidQ. Supports Mysql and almost qb-like in syntax. Free too. ;*)
Toonski? Comment on this plsssssss... ;*)
Have you tried 7.1. It has features, ISAM, that are supposed to improve database handling.
Thanks, SCM.
I have a problem with ISAM, which I learned and used for many years on the IBM 360, back in the early 1960's. The problem is that when I saw the abortion that 7.1 called ISAM, I almost threw up. They took some basic ideas from the original ISAM and made a mess of it. Maybe IBM didn't let Microsoft look at the design specifications. Who knows. To tell you the truth, even the original ISAM wasn't that good either.
As Ruudboy also said, I really don't need a better access method. What I need is a classy name like MySql, with my same old QB programs running in the background, to be able to say to a perspective client "This system runs under MySql". Many older systems have been spruced up to run under SQL, DB2, etc. just to get the prestige. I would like to bring my QB programming expertise out into the limelight. You could write the best system using QB, but it would have no acceptance just because it's written in Basic.
*****
Quote:You could write the best system using QB, but it would have no acceptance just because it's written in Basic.
I dont think that it would get no acceptance because its written in Basic. VisualBasic is one of the most used programming lanuages available today (mostly in Web and Database applications) and its syntax is very similar to Qbasic.
For a potential client I think the problem would be that you are trying to mix two very different systems, the MySQL database which runs on 32/64 bit Windows and UNIX platforms and QBasic which runs on DOS based systems. There would are several problems for a potential client faced with this solution. Firsly, Microsoft is slowly dropping support for DOS based products, there is no guarantee that DOS based applications will be compatible at all with future Windows releases. Secondly your solution will be non-portable, if your client is running MySQL for Windows but later decides to switch to a UNIX based solution then all of your QBasic code will become useless. Thirdly, there a few and far between serious QBasic engineers out there anymore, so if you left after providing a client with a QBasic based solution then the client may be hard pressed to find someone who can take over maintainence of the code.
You could show your expertise by porting your old QBasic programs into something like VisualBasic or Java with interfaces to MySQL. Your skill in programming will show in any language you use. IMHO, a major part of programming skill is knowing what language and tools to use for what job. QBasic may be a fun language to work with as a hobby and there may still be QBasic programs in use commercially (largely because they have never been replaced), but trying to offer QBasic based solutions to clients nowdays when much better solutions exist is like trying to sell someone a horse-drawn Porsche.
*Cracks knuckles*
Thank you rel, I've been looking for an outlet.
RapidQ is the slowest 32-bit piece of CRAP programming language, which astounds me as it's a windows programming language that runs several times SLOWER than QBASIC which is a 16-BIT language FROM 1987 running in a &^%-@#$@ed EMULATED WINDOW. If you are looking for a "look mommy, i'm a programmer" playskool programs, you might as well stick with it but you're never going much further than that. But for the rest of us, a set which includes every concious person, stay away from that god-awful mockery of programming they call RapidQ.
Oh, and QB was made in a time when btrieve was still the standard. But if you can find some real mode dos libraries that access databases you might have a shot. I wouldnt count on it though. Besides, there arent many databases you'd want to use in qb more complex than something you could use binary or random access records to get.