Free Software for DOS >          
 
home
   
about

Database and Spreadsheet

     

> DATABASE PROGRAMS
> SIMPLE DATABASES
> DISK CATALOGERS
> DATABASE VIEW/ EDIT
> DATABASE REPAIR
> SPREADSHEETS
> FORMAT CONVERTERS
 
Also see: Calendars, Clocks & PIMs and Information, Reference, Research.

GENERAL PURPOSE DATABASE PROGRAMS

DataPerfect - Professional relational database.

* * * * *

[added 2001; updated 2010-05-30]

DataPerfect is an impressive relational database program which does not require the use of a programming language – or the latest hardware. Now has Web-authoring capability. This is a mature program, highly stable, and designed to handle very large, complex jobs.

Comments from a DP user:
As far as existing database platforms, none resemble DP's structure. None of the Windows platforms, when using only the applications generator (i.e., not writing code) allow for the complexity DP allows for, and most...don't allow for some of DP's relationality even with writing code. Also, most do very poorly with medium to large databases (say, databases with data files holding over 50,000 records each); whereas, DP allows for almost no slowdown, free of corruption, with data files in the millions of records each.

Copyrighted freeware. Originally released by WordPerfect Corp., then Novell (through 1994); subsequent releases by the author.

Author: Lew Bastian (2009). Suggested by A. Padilla, Maurizio Converso.

2009: v2.6y available

Download dp26y.zip from FSFD (440K).

Go to the DataPerfect Users Discussion Group for manuals, tools, links to other DP sites, mailing list, etc.

 

nanoBase 1997 (nB) - xBase, *.DBF compatible database.

* * * *

[updated 2006-08-21]

nanoBase is a dBase compatible database that can function as a Dot command interpreter, menu driven xBase, xBase program interpreter, or compiler / executer of simple xBase programs. From my limited evaluation, it appears to be a solid choice for maintaining a variety of catalogs or databases. nB can access files created with Fox Pro 2, dBase III and up, and CA-Clipper. Mouse compatible. Source (*.PRF) available.

Author: Daniele Giacomini, Italy (1997).

1997-01-01: v97.01.01

Downloads
EXEs 1
nbase7a1.zip
(373K)
For XT, or 80286 with low RAM
EXEs 2
nbase7a2.zip
(229K)
For 80286+ with >2MB RAM – most users should get this version
EXEs 3
nbase7a3.zip
(491K)
Protected mode services, for all PCs
Docs
nbase7a4.zip
(365K)
Macros
nbase7a5.zip
(73K)
Source 1
nbase7a6.zip
(108K)
Older v96.01.01, no mouse support
Source 2
nbase7a7.zip
(192K)
v97.01.01, with mouse support

For more info, go to the nanoBase 1997 description page and to the online manual.

 

PC-File - Award-winning, flat file database manager.

unrated

PC-File, created by the "Father of Shareware" Jim Button, has been reclassified (9-97) as unsupported freeware. PC-File won three PC Magazine Editor's Choice awards in the '80s and early '90s. I've heard much about it, but have no experience with it. I will allow an old advertisement to speak for this program:

Awarded its second Editors' Choice in the June 26, 1990 issue of PC Magazine, PC-File is the #1 rated flat-file database manager. The May 14, 1990 issue of PC Week said "PC-File emerged as the most powerful flat filer". ShareWare magazine awarded PC-File an Editors Choice award in 1991. In December 1991 Home Office Computing awarded PC-File four stars stating, "Few programs in recent years have offered as much power for the price as PC-File." In July 1992, Data Based Advisor magazine awarded PC-File 1st place in Documentation, Ease of use in report creation, and Price vs. value provided. PC-File is so popular because it does just what you need a database to do: store, organize, retrieve, manipulate and update information. Whether it's your mailing list or your membership list; your clients, your customers, or your contacts; sales, inventory, expenses, payables & receivables, even your hobby collection...PC-File can keep track of it.
PC-File sports an impressive list of features, such as easy database creation, relational posting and retrieval, customized data entry screens, powerful search and retrieval capabilities, five different ways to create reports, including point and click and a forms designer, merge letters, bar code output including ZIP+4 Postnet & UPC, pie, bar and line graphs, quick mailing labels, 10 levels of sorting, macros, password protection, dBase file compatibility, extensive import and export with many other popular programs and much more!

The freeware version is the fully functional v5.01, but the included manual is for v3.0. Documentation may be inadequate for some features. PC-File is not Y2K compliant.

Author: Jim Knopf [aka Jim Button] (1997).

Download pcf501.zip (626K).

 

Easy Base - Programmable relational database.

* * *

[added 2001-08-12, updated 2004-04-20]

Formerly paid shareware, now free. See description wih screenshots at the Easy Base page.

Author: John Turnbull / Easy Software Ltd., UK (1998).

1998-06-05: v11.4.

Download eb114.zip (1.3MB).

 

DBM (Database Manager) - Flexible database.

* * *

[updated 2006-03-14]

DBM is a fairly small but powerful and flexible program, with a text-graphic interface, drop-down menus, data entry boxes and context-sensitive online help (in popup windows). It can produce data files with a large number of fields, and a variety of display formats. A text editor is built in. Full keyboard operation. Minimum operating requirement: 600K conventional memory. Recommended: 80386+, EGA+, XMS memory, DOS5.0+, mouse.

Other features, from the docs:

Limitation: Data files are written to and searched for in the program directory only – no convenient organizing of projects into subdirectories is possible.

Note: May not be wise to run this program under Win3.1 (rg).

1995-10-28: v1.13. Cardware.

Author: Zhuhan Jiang, Australia (1995). Suggested by Lars-Erik Sandberg.

Download dbm113.zip (300K).

SIMPLE DATABASE–LIKE PROGRAMS

FREEBASE (FBASE) - Simple database uses plain text files.
Trilogy - Note retrieval system for researchers and writers.

[added 1998-06-16, updated 2006-08-21]

Reviewed by Howard Schwartz.

FREEBASE and Trilogy represent a middle ground between simple "cardfile" programs, such as the applet that comes with Windows, and fully functional databases. These programs operate on collections of various pieces of text, e.g., recipes, notes, book summaries, phone call descriptions, medical information. We often want to search these pieces of text to find specific information. But we don't want to deal with the complexity, time, and effort of setting up and maintaining a full fledged database. FREEBASE and Trilogy let you label pieces of text with one or more descriptive keywords, and retrieve the text items by doing simple, "database" type searches on the keywords.

FREEBASE is one of the few database programs that operates on an ordinary ascii file as the data file. You can change the (ascii) data file with any text editor of your choice. To add a new piece of text, you simply mark its beginning with a special character (~), and add one or more descriptive keywords at the end of the text.

You retrieve items of text in one of two ways: You can search the text itself for the presence of one or more words (similar to a wordprocessor's search and replace mechanism). You you can search your list of descriptive keywords for these words. "Or" type searches are done by doing a sequence of full data-base searches, one at a time. "And" type searches are done by doing several searches in succession, where each new search looks only through the text found by the last search.

Advantages: 1) Uses a simple ascii file as the data file. Does not require items to be imported to or exported from a special format. 2) Has a wonderful, easy to use, well thought out interface and display format. 3) Has a DOS escape key, so you can use it as a pop-up data base by starting it and then escaping to DOS.

Disadvantages: 1) Cannot perform complex Boolean searches on keywords (e.g., search for text containing word, X, but not word, Y). 2) Must search for text strings only, no wildcards available. 3) You must prepare index of keywords manually by including a separate list of keywords as the first piece of text in your data file. 3) Limitations on the size of the database. The manual claims that a piece of text must be no more than a screenful of lines (21 lines). However, I found that larger pieces seem to work fine.

Other: The installation program can be used at any time to configure screen colors, filenames, reserved characters, and more.

Author: Glynn Shaffer (1988).

Download fbase12.zip (78K)

Trilogy permits more elaborate Boolean searches of keywords, and it automatically generates two indexes for you – an alphabetized list of keywords, and a list of "titles" for each piece of text. A "title" is the line of keywords that starts a piece of text. The cost of these extras is using a specially formatted, non-ascii, database file. Preparation of pieces of text is equally easy: include one or more keywords at the beginning of the text, and then import the text into a data-base, using the trilogy program itself. You can view the indices of keywords and titles, and then retrieve pieces of text, using simple or relatively complex Boolean searches on the keywords or titles. Trilogy also lets you print out pieces of text, as well as viewing them. The program was originally written by a professor to keep track of notes made in preparation for writing a research book.

Advantages: 1) Complex "and" and "or" searches are permitted. However, "not" type searches are not available. 2) Searches can use a simple wildcard (*). 3) Handles relatively large databases of up to 500 notes per file, filesizes up to 1/2 Meg, and multi-screen text items.

Disadvantages: 1) Cannot search the text itself for words. To do this you must export the text out of Trilogy's data-base and search it with an ordinary editor. 2) Changing the keywords or text in a data file is time consuming and awkward: You must export the text out of the database, change it with a text editor, and then import it back into the database. 3) Has an awkward, non-intuitive user interface. In particular, one cannot go directly from the keyword screen to the retrieve-text screen. You can get around this limitation by using a key macro TSR (e.g., Quickey).

Author: B. J. Ball (1988).

1988-04-04 release. Package includes BAS source code.

Download trilogy.zip (57K).

 

dg (data-grepper) - Search for a phrase, in text records.

unrated

From the docs:
dg will search a text file for a given phrase and print all "records" containing that phrase to standard output...This utility is not designed to replace full featured databases with formal query languages. It is suitable for keeping utility files, such as address or contact files or software requirements files, when the purpose of the search is not to settle just for individual lines containing the desired phrase, but to get the entire paragraph or record. It is like grep with some notion of context...
dg is intended for free form "flat" files of text containing records (multi-line chunks or "paragraphs") separated by a defined delimiter character (default is "*")... A "paragraph" mode (-dd option) treats blank lines as record delimiters... Unlike grep, which would report only the specific lines containing the search term (or a fixed number of lines either side of the find), data-grepper will print the entire record in which the search term was found – or a specified number of key lines for that record. It is useful from the command line, but most powerful when used in batch files that grab a set of records and then do further processing on them...
The program does not directly support wildcards, nor does it understand all unix "regular expressions." A wildcarded list of files to search may be done using the dgw batch file.

(See docs for a list of limitations).

Author: Pete Marikle (1997). Suggested by Marianna Van Erp.

1997-05-26: v0.53.

Download dg53.zip (109K).

DISK CATALOGERS

Also see: FCAT, from Bob Ferguson's Freeware – a multi-tool disk and archive cataloger package; more complex but fairly versatile.

CD Navigator - Floppy, HD, CD cataloger.

* * * *

[added 1997-11-, updated 1998-03-06]

Although this cataloging program was designed with the audio CD user in mind, it also functions very well as a floppy or hard disk cataloger. The Norton Commander-like text mode interface is mouse compatible and easy to navigate. Unlike the more basic freeware Disk Manager (next item), CD Navigator can: 1) store user file notes (or 4DOS descriptions); and, 2) read and store a disk's formatted label. Multiple disks can be cataloged together into larger groups. A quick disk scan feature (MSCAN) is especially nice if you are cataloging a large collection of floppies at one time. CD Navigator includes a robust search engine for finding disk or file names, notes, and CD audio tracks. Also plays audio CD tracks and includes a screen saver. The download file also includes a basic (but neat looking) stand-alone audio CD player (PCDN) which can read CD Navigator generated data files. English, Hungarian and Polish language packages are available.

Limitations:

Author: János Tomoga, Hungary (1998).

1998-02-21: v4.20.

Download cdnav42e.zip (111K).

 

Disk Manager - Clipper based floppy diskette file cataloging program.

* * *

[updated 2006-08-21 ; Links updated 2010-06-01]

Disk Manager does one thing, and does it well: It reads filenames from a diskette (drive A or B) and, with user input from menus and a file manager, produces an indexed database of files, the diskettes they reside on, and the boxes containing the diskettes. Database size is essentially unlimited (unless you have 1,000,000+ diskettes). The program can also print labels, and reports (dir listings) of diskette contents. Neat color interface, online help.

Author: A.C. Software (1994).

1994-02-06: v2.8.

Download ac_disk.zip from FSFD (114K).

DATABASE VIEWERS AND EDITORS

DBV - xBase (*.DBF) file viewer and editor.

unrated

This is a handy little (55K) *.DBF file viewer with the added ability to edit records and fields. Search function included. A configuration file can store custom switches. File size limit unknown, but it can handle relatively large files (I've only tested it with a 1.2MB file). Pops up a directory browser if run without parameters.

Author: Raymond T. Kaya (1994).

1994-04-06: v1.23.

Download dbv123.zip (44K).

 

DBFVIEW - xBase (*.DBF) file viewer and editor, mouse support.

unrated

[added 1999-05-03, updated 2005-12-09]

Much like DBV and VFPVIEW but includes good mouse support and some different options. Requires 80286+, DOS3.3+

Author: Tibor Kovács, Romania (2000).

2000-01-13: v2.33.

Download dbfv2_33.zip (29K).

 

VFPView - xBase table viewer and editor, supports Win9x LFNs.

unrated.

[added 11-97, updated 2005-12-09]

Similar to DBV but includes additional enhancements. Includes a search field function, displays header info, type of table, and table code page. Latest versions can also repair damaged headers and display Win9x long file names (LFNs). Code page translation support. May choke on empty directory (i.e., w/ no *.DBF files).

Author: Milan Kosina, Czech Republic (1999-2001).

2001-01-05: v3.2 recompiled.

Download vfpvw32.zip (36K).

 

CLUT - Powerful DBF viewer, editor, and manipulator.

unrated

[added 2000-03-21, updated 2004-10-01]

Package includes three versions of the program: Real mode (80286, DOS 3+), standard protected mode, graphic protected mode. All run under DOS or Win32. Bilingual, English and Italian.

From the docs:
"CLUT.EXE" is intended to be a more efficient alternative to the "Dbu.Exe" utility, distributed with CA-Clipper...
The program allows to open simultaneously one or more DBF files, each of them with its own indexes, using the same or different "RDDs"; relations may be set among them and they may be displayed (browse) separately or in selected multifile views. It also allows to execute any operation done in complex procedure.
The usable "RDDs" are "DbfNdx" (Dbase III), "DbfNtx" (CA-Clipper) and the quite undocumented CA-Clipper 5.3 "DbfCdx", with its innovative features (Comix-FlexFile-BLOB).
...it includes a "dot" command prompt too, to process any expression or function. It may be used to test how new or yet unused expressions or functions work.

...and much more – see the docs.

Author: Sergio Cocci, Italy (2004).

2004-05-19: v2.14.

Download clut_214a.zip (1.5MB).

DATABASE REPAIR

Titanic - Rescue / repair damaged DBF files.

unrated

[added 1999-09-07 ; updated 2001-01-01 ; links updated 2010-05-30]

STATUS: DISCONTINUED OR DORMANT

"The idea [behind the] program is to copy the correct header from [a] sample file and recover all data in [the] damaged file. [The] sample file can be empty or you can create a new empty file for this purpose." Performance: "100% successful in the case of damaged header"; can recover a maximum of data even with "shifted disk block" error. Interactive, full screen interface. Runs under DOS 0r Win32. Available in English, Slovak and Czech language versions. "This is SHAREWARE, registration fee is a POSTCARD no money".

Author: Branislav Stofko, Slovakia (1998-2001).

v98.04 (1999; was "re-released" in 2001).

Download bstitae1.zip from FSFD, in English, (77K).

 

SPREADSHEETS
 

GENERAL REMARKS:

Two DOS spreadsheets I can recommend are As Easy AS, and InstaCalc, both discontinued shareware products which have been reclasssified as freeware by their respective owners- but the new status has not been updated in the file packages themselves. (i.e., the owners provided serial; numbers through company forums or informal communications). I have preserved that information here.

All freeware spreadsheets below (except InstaCalc, As Easy As) are lacking standard commands that most spreadsheet users now expect (e.g., format number as a date, sort a range of cells, undo.)

Other comments:
 

AS Easy AS - Award winning shareware spreadsheet- now free (DOS / Win9x versions).

* * * * *

[added 2010-05-21]

As-Easy-As (AEA) was a shareware DOS spreadsheet program developed by Trius from the mid 1980s to the late 1990's. AEA was also rewritten for the Windows 9x platform before being discontinued around 2004 and was informally designated as free to register around 2006. AEA was an excellent example of how smaller shareware products could effectively compete against commercial developers on both price point and features.

AEA combines classic metaphors derived from Lotus 1-2-3 with updated features such as pull-down menus. Both cell formulas and the @function syntax resemble those of Lotus 1-2-3. Graphing capabilities are tuned more to scientific and engineering applications.

Screenshot

Awards:

Author: Trius Inc. Trius now develops advanced GIS and Mapping Technology solutions. Trius Support Forum

Downloads

  Program File serial number /password Size
  DOS v5.7 asa57.exe (Winizip) 570-110-0424-3 601K
  DOS manual asa57_manual.exe ASA57Licensed3974 4600K
  Final Win 9x version asawin95.exe 16-0101-2317-2 1680K
  Win9x manual asawin16_manual.exe ASAWINLicensed1385 480K

notes: DOS and Win 9x freeware status statements from Trius: (1 , 2)

 

InstaCalc - Older spreadsheet, still useful.

* * * *

[updated 2006-03-14]

This old but venerable menu-driven spreadsheet for DOS is still a great little program. A reliable source who contacted the current (1999) owner was told that InstaCalc is no longer being developed, marketed, or supported and can now be used free of charge. InstaCalc can import and export 1-2-3 (WKS, WK1), dBase, and delimited text. Can generate charts. Needs about 200K disk space.

Features:

Publisher: FormalSoft (1991).

1991-05-31: v3.

Download instaca3.zip from FSFD (324K).

 

VisiCalc - 1981 version of the classic DOS spreadsheet.

unrated

[added 2000-12-03]

Placed here primarily because of its historical significance, the 1981 PC version of VisiCalc is now being distributed by one of its co-authors. Only the 26.8 Kb *.com file is distributed (no docs), but you can download a graphic of a 1979 Apple II reference card. Hint: to quit the program, use command "/SQY."

License note: VisiCalc is still copyrighted (Lotus) and can only be used for non-commercial purposes.

Authors: Dan Bricklin and Bob Frankston (1981). Suggested by many.

See the VisiCalc Home Page for a first-person history of this archetype of modern spreadsheets.

VisiCalc download page.

 

Matrix - Spreadsheet that supports range selection with mouse.

unrated

[added 2000-02-27]

First impressions: Matrix is a newer DOS spreadsheet that uniquely supports selection of cell ranges using the mouse. Needs a fast 80386 and a coprocessor/FPU (80387), 80486+ recommended.

A few features:

Remarks: Matrix requires (emulated) expanded memory. Unfortunately this requires replacing the (usually) desirable emm386.sys /NOEMS switch in config.sys with /RAM or /AUTO. Win98 users may have to explicitly add himem.sys and emm386 statements to config.sys in order to permit use of expanded memory, with something like:

DEVICE=C:\WINDOWS\HIMEM.SYS
DEVICE=C:\WINDOWS\EMM386.EXE /RAM 4096 /I=B000-B7FF

/I=B000-B7FF can get you 32K of extra high memory if you're not using a monochrome adapter.

Author: Michael Finnegan / Grove Business Software, Ireland (2000). Suggested by Paul Chung.

2000-02-23: v2.0.

Download mtrix2.zip (395K).

 

Rebel - Key-driven spreadsheet.

unrated

[added 2000-02-27]

Quick impressions: Rebel is an old (1993) spreadsheet that is not widely distributed on the Internet. It isn't well suited to GUI spreadsheet users (no mouse support). Absent features include a "format number as date" function (in order to input something resembling a numeric date you have to use 3 columns for month, date, and year [see how it's done in the CHECKS.RB2 sample]). No sorting feature. Does have a simple undo command.

Requires DOS 2.1+ and 384K memory.

Author: Brad L. Smith (1993). Thanks to Torben Jørgensen for finding Rebel.

Download rebel302.zip (178K).

 

SC (Spreadsheet Calculator) - Character mode spreadsheet ported from Unix.

unrated

[updated 2005-03-11]

This SC package includes two executable versions (both ~250K) – SC.EXE for 16-bit DOS and OS/2 1.x, and SC32.EXE for 32-bit DOS and OS/2 2.x. The 32-bit EXE is for 80386+ PCs and, if you can get it to run, should handle larger data sets than the 16-bit version.

Quick feature list (incomplete):

Remarks: The 32-bit EXE will not run under Windows or in another DPMI environment. (It's an EMX build for OS/2 and DOS, should run under DOS but I haven't had success).

Author: Jeff Buhrt, et al. (1994).

1994-05-14: v6.21.

Download sc621_3.zip (508K).

Get more info, source & other files at the SC download page.

Also see SLSC, next item.

 

SLSC - Enhanced 32-bit version of SC (Spreadsheet Calculator).

unrated

[added 2000-01-06, updated 2004-10-01, links revised 2010-05-22]

This is another derivative of the original SC, on which the SC listed above is also based. From the docs:

SLSC is derived from the public domain spreadsheet SC. With the exception of the internal parts of the spreadsheet, much of it has been completely rewritten. In particular, the user interface is completely different and the spreadsheet is now customizable to suit different tastes. Although all of the power of SLSC is available from the keyboard, a simple menu interface modeled after a popular spreadsheet has been implemented. This interface is available by pressing the '/' key.

Supported formats (write): native SLSC, TeX and variants. Max cell grid size = 199r x 70c.

Hints: Don't forget to exract the *.rc config file when installing the program, and read it to see default key bindings. The program seems to behave oddly after loading a file from the command line (maybe it needs a path variable set?). I load files from within the program only.

32-bit DJGPP build, requires 80386+ and a DOS Protected Mode Interface (CWSDPMI or other). Also requires FPU (80387 or 80486+).

Authors: Jeff Edwards / Edwards Custom Software, Inc. (1999), based on an earlier SLSC by John E. Davis (1994). Suggested by Jean-François Buisson.

Downloads
slscdj1b.zip
(152K)
Program
slscdj1s.zip
(88K)
Additional docs and source

 

DATA FILE FORMAT CONVERTERS
 

Also see DBF2HTML in HTML Utils, and the catdoc set in Text Utils - 5.

CONVERT (2) - Converts among dBase, CSV text, fixed text, Lotus 1-2-3 formats.

unrated

[updated 2002-11-15]

From the docs:

Converts between data formats: FROM dBase, ASCII-delimited (typically commas between fields and quotes around strings), and fixed field TO Lotus WKS, ASCII-delimited, dBase, and fixed field.

Notes: Requires DOS3.0+. User can create definition files that override default settings.

Author: Bruce Guthrie (2002).

2002-08-10: v0208.

Download CONV0208.ZIP (102K).

More in these pages from Bruce Guthrie.

 

dBTAB - Converts DBF to tab-delimited ASCII text.

unrated

[updated 2006-08-21]

Syntax: DBTAB [switches] dbffile[.dbf] [txtfile[.txt]]
Switches:
  /d		Skip deleted records
  /f fieldlist	Process only fields specified in the fieldlist
		(for example, /f2,5,7 displays only the 2th, 5th and 7th field)
  /l		Use the four digits format to display years
  /m mask	Display records using a given mask (see README for details)
  /s		Display file structure

Inside the mask the following macros can be used:
  $ contents of the <number>-th field
  $$        the '$' character
  $q        the '"' character
  $p        the '%' character
  $t        the TAB character
  $+        the value of the autoincrementing counter

Author: Simone Govoni, Italy (1997).

1997-10-23: v1.11.

Download dbt111.zip (16K).

 

Go to Top | Front Page ]


©1994-2016 Rich Green.
©2004-2016, Steve Adelwitz (Short.Stop).