filePro is a proprietary DBMS and RAD system originally developed by Howard Wolowitz as The Electric File Clerk in 1978. He licensed it to Tandy Corporation in 1979 who first published it in 1980 as Profile II. Although there was a Profile for the TRS-80 model I, model III and model IV, these were unrelated programs. Today's filePro started out on the Model II and was first released by Tandy as "Profile II". After passing through several owners, the code is currently the property of fPTechnologies, Inc.
Contents |
Current Status
filePro is not a true relational database, because it does not satisfy Codd's 12 laws, although the language does allow looking up data in one file while working in another. filePro, in fact, fully satisfies only the first of Codd's 12 laws. filePro stores data in fixed length record files. It allows for rapid prototyping of curses-like screens, and add-on products are available for client-side ODBC interoperability, Common Gateway Interface-like functionality, and even a form of SQL. While filePro supports limited data integrity checking at the table level, these checks can be overridden by code. There is limited support for triggers, and locking is done on a per-record basis, so that two users cannot update different fields in the same record simultaneously. Code is stored on a per-table basis, and follows a complex set of execution rules which few users fully exploit. Most execution rules involve triggers such as on an update or When-Leave-Field. The product no longer ships with a printed user manual; however, there is a manual available in electronic format. As well, there is a single third-party full reference book available, along with a single third-party quick-reference guide. There are several filePro resources available online including a company maintained discussion forum at http://www.fptechforum.com ; A user created free access website containing sample code, articles, tutorials and a directory of active filePro developers at http://www.fpgroups.com ; a user maintained mailing list--for more information, visit http://lists.celestial.com/mailman/listinfo/filepro-list ; and a user run chat room at http://www.valar.com/fp_room/fp_room_enter.htm
History
- 1978
- Howard Wolowitz develops for the TRS-80 Model II.
- 1979
- The small Computer Company is founded.
- 1980
- Tandy Corporation publishes it as Profile II.
- ????
- Profile II Plus is released.
- 1983
- Profile 16 is released for the TRS-80 Model 16 running Xenix.
- ????
- Profile 16 Plus is released.
- ????
- filePro 16 and filePro 16 Plus are released by The small Computer Company for non-Tandy computers. (Profile was a trademark licensed by Tandy.)
- 1986
- Version 3.0 released for both filePro 16 and filePro 16 Plus. This was the last version for the non-Plus filePro 16. Further versions also dropped the 16 part of the name.
- ????
- filePro Plus Version 4.0 released.
- ????
- The small Computer Company is bought by another company (Athena Investment Group), and becomes a subsidiary of that company. Over the next years, the parent company itself changes hands several times.
- ????
- Version 4.5 released.
- ????
- Version 4.8 released.
- 1998
- fPTechnologies, Inc. is founded by the filePro employees, and buys the rights to filePro.
- ????
- Version 5.0 released.
- 2006
- Version 5.6 released.
Future
While there is an fpGUI add-on for GUI-based access, filePro is still primarily character-based, which some users assert makes for faster and more efficient data entry. There is, however, no support for screens larger than 24x80. There are several people who have created XML and SQL bridges that allow cross-communication with legacy systems. Not even the PHP community has provided a full featured layer with the ability to directly read/write to filePro data in real time. PHP has contributions that allow reads if record numbers are known; however, record numbers could change in a reorganization, thus eliminating the usefulness of the contribution. Writing to filePro databases is still an issue, while the internal format of the B+ tree indexes used has been officially documented, no one has adapted such a library for these indexes--any programmers wishing to write new records to a database must do that (not inconsequential) work themselves. It is possible that the internals of filePro are so convoluted and complex that fPTech is essentially unable to remedy the problems listed above.
Database Features
Strengths
- Fast data lookups
- Short learning curve NOTE: people with traditional programming experience, particularly exposure to Object Oriented methodologies challenge this statement
- Data entry system allows for quick familiarity with keyboard shortcuts, and as such, typists do not have to rely on mouse acquisition.
Weaknesses
- SQL support is read-only
- Limited ability to communicate with other DB systems
- ODBC support is client-side only
- Only supports 24 lines of 80 characters
- No journaling
- Relationship management is manual
- Coding limited to only if and goto and gosub (no else, switch, or looping statements)
- Design does not allow for typical low-coupling/high-cohesion code design
- No transactions
Trivia
- Howard Wolowitz is one of the character's names on the TV show The Big Bang Theory, which was created by Bill Prady, one of the founding partners of The small Computer Company.
External links
- fPTechnologies Official Site
- filePro Developer's mailing list
- Voice chatroom
- An anti-filePro article
- A rebuttal to the "anti-filePro article"
(that rebuttal did not exist on 12/20/2007)
