Cable Column: QL – Archive – PC

See all articles from Update April 1990
Author(s): Bill Cable
Publication: Update Magazine
Pub Details: Update April 1990
Date: April 1990
Pages: 11-13

WOOD AND WIND COMPUTING
Bill Cable : RR 3 Box 92 : Cornish, NH 03745

QL – ARCHIVE – PC

Databases are specialized programs for efficient handling of both text and numeric information on a computer. Anyone trying to put their computer to good use should be using a database in one form or another. As many of you know I am a great fan of the ARCHIVE database and programming language. I write commercial software with it. For handling information on a QL it has no peer for its capabilities. This is not to say that there is not a price to pay for using ARCHIVE. Either you have to learn how to use its programming language or you have to buy ARCHIVE programs. Other alternatives include buying FLASHBACK or write or buy database type programs written in SUPERBASIC or other languages.

In earlier issues of UPDATE I have tried to explain the basics of using ARCHIVE. Now that I see there is so much interest in MSDOS by QL users I want to push ARCHIVE from another angle. If you want to be able to do something useful on MSDOS computers then learn the ARCHIVE language on your QL. I have been aware that there is PC version of ARCHIVE. But until recently I have had very little experience on MSDOS machines (PCs). After tackling my first serious conversion attempt (making DBEasy work on a PC) I would say I am already close to being an expert with PC-ARCHIVE because the PC and QL versions are so similar. Almost all of the ARCHIVE I have learned on the QL can be transfered directly to the PC. DBEasy, my ARCHIVE database manager, is now available in both QL and PC versions (see my ad). The importance of this QL-PC connection should not be minimized. Transporting software and experience from one computer to another is generally a very difficult process. If you take an elaborate SUPERBASIC program and try to convert it to run on a PC using one of the PC BASIC languages, almost certainly you would have to make major changes to the code and a lot of learning to do as well. So learn the ARCHIVE language on your QL and you can apply what you have learned directly to a PC. You can transfer your databases and programs to a PC as well. And its not like ARCHIVE is an inferior language. I still maintain that it is one of the nicest languages around. Its a nice structured procedure oriented language with a built in editor and good error messages and handling. Its very much like SUPERBASIC without line numbers or bugs. And I have talked with people who are experienced with PC-ARCHIVE and other PC databases and they feel that ARCHIVE is a superior database for PCs. Just like the QL was/is ignored by the masses, PC-ARCHIVE is ignored even though it is a fine database. And compared to the price of DBASE or PC database programs it is a bargain.

This Cable Column is going to describe how I went about converting my DBEasy program to the PC. This included purchasing a PC computer, the Amstrad PPC640 portable, and learning a little bit about using MSDOS. I will also give some statistics comparing DBEasy’s performance on the QL and on different PCs. We already have ARCHIVE for our QLs. For the PC you must purchase it as a package with QUILL, ABACUS, and EASEL called PC-FOUR. The price is about $99. It can be purchased from me (see my ad) or EMSOFT or RMG or Sharps. If you work on a PC it makes sense for you to have PC-FOUR because you use the same programs on your QL. The PC versions also have extra features. It’s pure folly to purchase PC-FOUR to use soley with PC-CONQUEOR. The QL makes a poor PC.

Choosing a PC

Before I could do serious PC work I needed a PC computer. DBEasy swamps PC-CONQUEROR so I couldn’t do the work on my QL with the emulator. Even if it worked, life is too short for its snails pace. The possible choices for a PC are limitless. They range from an XT type (8088 or 8086 processor) or an AT type (80286) or an 80386 machine with prices from $500 to $2000. My final choice was a portable by Amstrad, the PPC640. It is an XT type but the 8086 processor has a 16 bit data bus so it is almost as fast as an AT of similar clock speed (8 MHz). It is too heavy to be a laptop but is totally portable and takes little space to set up. It will run from batteries or 12 volt DC (as in a car) or normal house current. I have my own home power system and the fact that it uses only 20 watts of power and I can run it on 12 volt DC were big pluses to me. I also liked it having a full size AT style keyboard. It has two 720k 3 1/2 inch drives. It has an LCD screen (no backlight) but will also plug into my Magnavox RGB monitor with CGA display. I use the same monitor with my QL. The PPC640 also has a built in 1200 baud modem with phone connector and is provided with software to run it. It has 2 serial ports and 1 parallel port. I bought it from UNDER-WARE Electronics (800-442-1408) as advertised in Computer Shopper for $700 plus $25 shipping. Although still available, it is no longer in production and was originally suppose to sell for something like $1200. There are also versions with one disk drive and no modem available for less. It comes with DOS 3.2. It has worked flawlessly for me and I recommend it. The keyboard action is not the best but works fine. The drives are quiet. The LCD screen needs good room lighting but is adequate. I have found it to be fast compared to my QL mostly because of much faster screen handling. There is suppose to be a 20 Meg portable hard drive available for $300 but I don’t have it yet. It is certainly an inexpensive way to break into the PC market place. I have a comprehensive payables/receivables package for home and small businesses written in QL-ARCHIVE that is almost ready for release. By converting it to PC-ARCHIVE, I have a package to sell locally to small businesses. Later if things go well I will consider getting a more versatile 386 machine. Have I abandoned my QL? No way! I consider QDOS a more flexible operating system than MSDOS and I like being able to multitask. I don’t want to abandon SUPERBASIC with its excellent language for making quick programs with very flexible graphics. Even if slower in some respects, I can still work faster on my QL because of its excellent features. In the future I will work on both the QL and PC machines. It is certainly nice to have the 4 PSION programs available on both.

The DBEasy Program

DBEasy is a front end database manager for ARCHIVE. It allows you to use most of ARCHIVE’s features without having to know anything about its language. It allows the user to create and manage all sorts of databases. It is a large complex program (55k on the QL and 56k on the PC) but very simple to use. As with any friendly software most of the development effort went into making clear and simple menus and displays.

Transfering DBEasy to a PC

Now that I had a QL, a PC, ARCHIVE for both I next needed to transfer my QL files to the PC. There are at least 2 ways available. The best way is to use a QL software like DISCOVER or PC-CONQUEROR to copy them to a PC formated disk on the QL and take the disk to my PC. I couldn’t do that because my QL has 5 1/4 drives and my PC has 3 1/2 drives. I have 3 1/2 drives on order for my QL from RMG to make life easier. So I had to use the serial ports on my QL and PC to transfer the files. I used the communication software, MIRROR II, on my Amstrad to communicate with my QL which had software so it emulated a VT-52 terminal. I had some trouble figuring out the cabling. Peter Hale provided the necessary expertise to finally get it working. After that it was simple. Only text (ASCII) files can be transferred. This means I have to have my ARCHIVE programs in _prg form rather than _pro form. If you save a program in ARCHIVE with the SAVE “filename” command then it is saved in ASCII format (_prg). If you save it with the SAVE OBJECT “filename” command then it is saved in binary format(_pro). Normally you keep large programs in binary format because they load faster but for transfering to the PC I had to put them all in ASCII files. Also my databases had to be in export (_exp) files (ASCII) rather than database (_dbf) files for the same reason. Since screens (_scn) are not ASCII files I can’t transfer then. I must reconstruct them with the ARCHIVE SEDIT command on my PC. After transferring I started PC-ARCHIVE, imported the databases, rebuilt my screens, started DBEasy and changed code where problems existed.

Some differences between QL and PC ARCHIVE :

The most important difference for me is that there is no POSITION command and RECNUM() function in PC-ARCHIVE. I like to use those features to keep track of where I am in a database. If you use the FIND command it is nice to know how far you are in the file if you find something. They have been replaced in PC-ARCHIVE by a more powerful ordering and selecting process that allows you to keep 4 ordering and 1 selecting definitions at the same time and switch between them. This is a very powerful feature but my code doesn’t take advantage of it yet. The BACKUP command works differently in the 2 versions. On the QL it is similar to a general file copy command but on the PC it only works on databases and does a record by record copy. In PC-ARCHIVE there is no FORMAT command. There is no RENAME command in QL-ARCHIVE. The PC-ARCHIVE has more complexities with paper and ink colors because mono and color monitors display differently. PC-ARCHIVE and the other PSION programs have a special task sequencing language (TSL) which can be used to control the program at startup. This allows me to have ARCHIVE and DBEasy start up automatically, something I can’t do with QL-ARCHIVE. These are the major differences I have discovered when I tried to run DBEasy on the PC. The hardest part was dealing with all occurences of RECNUM() and POSITION in my code. I have worked out a display format on the QL which works surprising well on the PC so the DBEasy program looks exactly the same on the PC. Now that I know more about the differences I can plan ahead so conversions will be much easier. Since PC-ARCHIVE has more features than QL-ARCHIVE it will not be as easy to transfer back to the QL once I take advantage of those features.

DBEasy Performance Chart (time in seconds)

               - Computer Type - - - - -
DBEasy     QL     IBM PC   PPC640   AT       AT
Task       7Mhz   4Mhz     8Mhz     10 MHz   20MHz
------------------------------------------------
Load       69     94       57       48       10
Find       15     17       11        9        2
"xxx"
Step       58     50       19       12        8
10 records

Display    17     20        7        5        2
new page

Sum        13      9        4        2        1
Population

Order      13     18        9        7        1
by 'country'

Locate      4      4        2        9        2
'SWEDEN'

Select     19     24       12        7        2
'Europe'

In the chart above I give elapsed time for DBEasy to do various tasks on a few different computers. I used my DBEasy program with the gazet database (155 countries of the world) modified for DBEasy. The time is in seconds. The 20 MHz AT used DBEasy from hard drive. On all the others it ran from disk drive. I must say that using DBEasy on the 20MHz machine was almost intimidating. You couldn’t slow it down by doing anything. Some may be horrified to see how slow the QL is. But except for the tasks which require heavy screen work the QL gives very acceptable responses. And those that were slow like stepping through 10 records are adequate because you wouldn’t be stepping through the records unless you wanted to read them and you need that much time for absorbing the information on the screen. Also notice that finding things in a database is most efficiently done by ordering and using locate if possible. Locate is fast and is pretty much independent of the database file size.

How do we judge the QLs performance against the other machines? I. QL much slower in its screen handling. This is evident in QUILL and ARCHIVE. I tried SPEEDSCREEN and LIGHTNING but they didn’t improve the times. Some programs still manage to give fast screens. The EDITOR and TEXT87 are examples. Also the QL was multitasking QUILL while DBEasy was being run. That didn’t affect the speed of doing the tasks because QUILL was sitting idle None of the other computers can multitask. None of the other computers can network either without expensive equipment. And the AT machines cost 2 to 5 times as much as the QL. At some point I will try these same tasks on a THOR and pass on the results. It should be much closer to the AT machines. If you were to judge the QL purely on response times it shows its age. If you judge it on overall features taking into account its powerful operating system, its cost, and how much you can accomplish with it then it still can hold its own against most PCs.

I have quite a group of QL Softwares and I’m developing more for both the QL and the IBM. All are priced low for what they do. I will list four of my newest. I invite you to call or write for a complete listing. Bill Cable.