On Sat, Aug 3, 2019 at 11:57 AM Ben Collver <bencoll...@riseup.net> wrote: > Some day i would like to benchmark the DOS port of SQLite versus > databases such as Foxpro and Paradox. I understand these are not fair > comparisons because those old DOS databases supported the 8086. It is a > technical marvel that they worked as well as they did. I digress..
What would you be benchmarking? SQLite is a full SQL compliant relational DBMS implemented as a single library. dBASE and FoxPro were, IIRC "hierarchical" DBMS products. Depending on what you are benchmarking this sounds like an apples and oranges comparison. Yes, FoxPro and Paradox supported the 8086. And FoxPro can be thought of as a GUI version if Ashton-Tate's dBase, and that had roots back in CP/M running non 8bit CPUs like the Intel 8080 and Zilog Z80. For that matter, there were DBMS packages for the Commodore 64, including one, IIRC, that took advantage of feature of the 1541 floppy drive used by the C64. The 1541 used the same 6502 CPU as the C64 as the drive controller, with onboard firmware and 2K RAM. It was possible to write machine language routines that could be downloaded to the 1541 and run asynchronously *on the drive* while the host did something else. I believe at least one C64 DBMS made use of that ability An eco-system existed back the around dBASE, with the common factor among competing products being the use of the dBASE query language. Products in that eco-system expanded to become capable of multi-user access over a network, An assortment of other DBMSs also existed, like WordPerfect Corp's DataPerfect, which is still available for DOS. These days, the usual distinction between DBMSes is whether they use SQL as query language, Most are SQL compliant, but there are popular server products like Mongo and Couch that are explicitly NoSQL. > -Ben ______ Dennis _______________________________________________ Freedos-user mailing list Freedos-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freedos-user
