dBASE

At NASA’s Jet Propulsion Laboratory in the 1970s, Wayne Ratliff probably had no idea he was about to write a chapter in the history of personal database systems. His JPLDIS system, designed to process information for the space laboratory, would become the ancestor of one of personal computing’s most significant software products.

Ratliff transformed his initial work into a product he named Vulcan, which he sold through classified ads in specialized press. The commercial venture took a different turn when Ashton-Tate decided to distribute the software under a new name: dBASE II. This naming convention, which cleverly avoided version I, immediately suggested the maturity of an already proven product. The strategy worked perfectly. On 8-bit microcomputers running CP/M, dBASE II became the essential reference for data management.

What distinguished dBASE from other tools was its comprehensive approach. Where competitors offered isolated functions, dBASE provided a fully integrated work environment. Once launched, users accessed a complete universe: table creation, data manipulation, information retrieval, export to other formats. The software went further by offering a programming language to automate repetitive tasks or build custom interfaces.

This integration pushed the concept to include a text editor, file management tools, and the ability to interact directly with the operating system. Everything happened within a single environment, without having to juggle between different programs. The command-line interface, recognizable by its famous dot prompt, became increasingly familiar to users who learned to interact directly with their data.

The technical architecture relied on logical information organization. Data tables, stored in .dbf files, structured information into columns and rows following the classic relational model. The system relied on different file types: indexes to speed up searches, memory for temporary calculations, report formats for presentation, screen formats for interaction, programs for automation.

dBASE III marked a major technical breakthrough. Maintenance and code evolution were facilitated following Ashton-Tate’s abandonment of assembly language in favor of C. This version introduced date management and significantly increased processing capabilities. dBASE III Plus, released in 1986, reached a new level with pull-down menus inspired by Framework, doubled performance, and native multi-user support.

The numbers speak for themselves: unlimited files, up to one billion records per file, 128 fields maximum per record, 4 KB per record. Tests showed that sorting was twice as fast as the previous version, while indexing gained a factor of ten. Compatibility extended to PFS:FILE, Lotus 1-2-3, VisiCalc DIF, MultiPlan, and standard ASCII files.

Networking took on particular importance. dBASE III Plus directly integrated multi-user functionality at no extra cost. Automatic record and file locking prevented data corruption during simultaneous access. Eight levels of password protection secured access to sensitive information. Data encryption and decryption occurred automatically at each workstation level.

Yet by the late 1980s, the machine began to seize up. Wayne Ratliff’s departure from Ashton-Tate in 1988 deprived the company of its original creator, while competition intensified with the arrival of products like FoxBASE and Clipper, often more efficient and less expensive. Legal problems mounted: Ashton-Tate lost several copyright infringement lawsuits, having never disclosed that dBASE descended directly from JPLDIS.

Unlike WordStar, which had successfully recalled its founders during similar difficulties, Ashton-Tate persisted in a strategy that proved losing. The market reorganized around new players: Borland absorbed Ashton-Tate, Microsoft acquired Fox (FoxBASE’s publisher), Computer Associates purchased Nantucket (Clipper’s creator).

After his departure, Wayne Ratliff developed Emerald Bay, a new product that bore troubling resemblances to Microsoft Access. In a 2007 interview with Visual Pro Magazine, Ratliff highlighted these similarities without making explicit accusations, leaving doubt about potential “borrowing” of concepts.

dBase’s integrated development environment concept, direct interaction with data through an intuitive user interface, data-oriented programming: all innovations that would leave a lasting mark on the industry. Microsoft Access, among others, directly inherited these pioneering concepts.

Jerry Pournelle perfectly captured the product’s ambiguity in BYTE magazine’s columns by describing it as “exasperating but excellent”. This phrase sums up the mindset where the personal software industry still hesitated between pure technical innovation and ease of use. dBASE embodied this tension: innovative in its concepts, sometimes bewildering in daily use. Above all, dBASE demonstrated how database management systems became indispensable tools, both in personal and professional computing.