filePro

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.

Current status

A Robust, Cross Platform 4GL Database Development and Management System with exciting new features. It is a perfect choice for small to medium-sized businesses who need a customizable and powerful database package.

The product no longer ships with a printed user manual; however, there is a manual available online at fpTech's website. 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 user maintained mailing list—for more information, visit http://lists.celestial.com/mailman/listinfo/filepro-list

History
This list is incomplete; you can help by expanding it.
1978
Howard Wolowitz develops Electric File Clerk 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.
2009
Reorganized and renamed fP Technologies of Ohio, Inc.

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 are several people who have created XML and SQL bridges that allow cross-communication with legacy systems.

Database Features

Strengths
  • Fast data lookups
  • Short learning curve (for programmers, user experience is software dependent).
  • Data entry system allows for quick familiarity with keyboard shortcuts, and as such, typists do not have to rely on mouse acquisition
  • Provides version updates and bug releases for operating systems for more than a decade[1]
  • Ability to create PDF outputs and reports automatically. (filePro version 5.8)
  • Excellent for performing data imports and data manipulation.
  • Able to connect to MySQL and utilize the power of filePro to read / write / report data from MySQL data. (Linux filePro 5.7 and higher)
  • Dual write capabilities. (Redundant mirror backup) (filePro 5.8.01.03)
  • Data Encryption at field and table level. (filePro 5.8.00.03)
  • Multi Platform - applications created on one operating system can be converted to other platforms easily. (Support for: Windows (32 and 64 Bit), SCO Openserver Unix/Unixware, Linux (32 and 64 Bit), Sun, HP-UX, IBM AIX, IBM eServer iSeries Linux and FreeBSD (64 Bit))
  • 26 Available Automatic Indexes with 10 Demand Index options
  • Mathematical Precision - 16 Places to left. 8 places to right of decimal.

Weaknesses
  • fP SQL support is read-only[2] ( fP SQL Query and Report Generator )
  • Only supports 24 lines of 80 characters
  • Maximum print width of 255 characters per line[3]

Trivia
  • The Big Bang Theory pays homage to one of the founding partners of the small Computer Company by naming one of the characters "Howard Wolowitz". (Showrunner Bill Prady was a business partner of Wolowitz's at one time; the actual Wolowitz has appeared in a cameo on the show.)
gollark: Sometimes, when I need to be quieter, I use a touchscreen - if I tap the right side it triggers a right click, and the same for the left.
gollark: I say "RIGHT CLICK" and it triggers a right click.
gollark: I use voice recognition mouse buttons.
gollark: Well, I expect you'll get used to it after a few... hours.
gollark: Thank you for the information.

References
  1. "Archived copy". Archived from the original on 2011-07-11. Retrieved 2010-01-16.CS1 maint: archived copy as title (link)
  2. "Archived copy". Archived from the original on 2011-07-11. Retrieved 2010-01-16.CS1 maint: archived copy as title (link)
  3. "Archived copy". Archived from the original on 2011-07-11. Retrieved 2010-01-16.CS1 maint: archived copy as title (link)

Contact Information

Phone: (800) 847-4740

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.