Psion Epoc Database Software and Data

The best miniature computers on the planet

Database applications and manipulating data.

I haven't had database needs that could not be handled by the Psion Data application, so I regret these remain untested. Reports of their uses under field conditions are most welcome.

See my Psion Data application page for more on the inbuilt data application. See my Psion Contacts page for more on the Psion Contacts address book, and various programs that extend Contacts to multiple files, or convert Contacts files to Data and other formats.

On this page

Data to Contacts
Database Applications
Find Utilities
Other Applications

Data to Contact

Several programs assist in moving Data files into the Contacts address book.

ConvertData
Convert Data by Cornelius Mawby, converts Data to Contacts. Formerly at useritl.net/~nijel/ConvertData.htm
Data Contact
DataContact converts Data files into Contact files, by importing the address info into Contacts. Written by Pascal Nicholas. Formerly http://pnicolas.epocboulevard.com/
MxContacts
Richard Balch. Ports Data files to Contacts. URL changed.

Database Applications

Database programs either more powerful or more specialised than the built in flatfile Data application.

Collection
Pytheria has commercial specialist database programs, Art Collection, Book Collection and Music Collection. Formerly Palmscape. www.pocketiq.com
Kevin Millican PsiDat
Freeware. This is creates OPL DBMS data files and databases. Has SQL query. Browsing and editing of OPL DBMS data files and creates EPOC databases with and without indexes. The program also features good importing and exporting options for industry standard databases, as well as delimited text files. www.millican.info
Multivue
Business database, relational links with other files. Psion User Group www.user-group.co.uk (this group was taken over in early 2001, and site is down).
Oracle 8i Lite
Available from Oracle's site although whether or not it'll run on a 5mx is another matter. www.oracle.com/
Pointbase
PointBase, Inc., the new company created in 1999 by Oracle co-founder Bruce Scott, has launched its PointBase database system. Built entirely in Java, the database is designed for mobile and embedded applications. Despite a memory footprint as small as 270 Kb, it has a wide range of features, including intelligent maintenance and optimisation. The company envisages it being used in mobile computers, servers and other internet appliances. www.pointbase.com
PowerBase
Called the first relational database for Psion, from Purple Software. It is not a true relational database and it does not have a command line interface. But it can be queried in an SQL fashion, it has a simple relational set-up and its reporting features are excellent. Better than Access for the simpler studies and investigations. Obviously, when automation is needed then the tables can be converted (via CSV) to Access. www.purplesoft.com/
SmallBase
Eric Sebban Small Base Manage your own databases. Long Memo field Type (more than 255 chars). Card View (removable). Find feature allowing wildchars (? and *). Filters and Colors on Text type field allow wildchars (? and *) in the keyword. Next step : link between tables ! Also provides Windows emulator version. corisoftnet.com or www.pocketiq.com

Find Utilities

FindIt
Tony Crocker. Shareware. $18. v3.6 Tracks which items are in which of your Data files. Records a list of items, lets you attach a database name to each. Import options, hot key while open. Designed for Psion 5 display. tsteven at cix.co.uk Formerly ourworld.compuserve.com/homepags/tsteven_c/
Global Find
Called Find. Finds files on your Psion using different tests. Freeware by R Panton. Version 1.1 dated 30 October 1997, 16k. Searches for wildcard filenames, searches under a folder, search all or any disks, including rom, look for a string within files, search by file type. Richard Panton has a number of free utilities on his web site. They include a fine vt100 terminal emulator called Hermes. VWin, a Virtual Windows manager for OPL programs, inplementing scrollbars, windows, buttons. Partially completed disassembler, and a description of the clipboard format. www.iota.demon.co.uk/psion/find
SmartFind
Global search utility searches for files and file contents. Knows about file names, type, size, attribute, date and content. AND and OR operators, multiple phrases. Sort results. Double tap for access. Not sure if it allows options like all occurences (not just first), whole word only. SmartFind 2 is shareware US$15. Paragon Software. Andrew Scherbakov. www.epocware.com

Other Applications

DataFile Manager
Information Technologies. Compare two data files and do a smart merge to remove duplicates. Leaves original files intact. Also irChat, chat program for Psion, Palm, PocketPC. Also AddressBeam. www.palmix.itil.com
FindIt
Freeware to keep track of which data was in which database. T Stevens.
Internet Movie Database
Tom Sheppard's download area for area for Palm will also work for Epoc. Formerly http://www.magma.ca/~sheppard/IMDb/Web
Jotter Data File
Freeware example of how to use a pre-formatted data file as a Jotter. Very similar to R5 Jotter. Formerly on www.geocities.com/Siliconvalley/Heights/5596/s5.htm but you can find a similar version on my Data page.
Label Maker
Prints labels from an address database, with some conversion routines. Comes with OPL source code. Allows grouping of names. Location and details unknown (and I'd really like to find this one).
Psipsi
Rik Sagar. Website that can display and search Psion Data files put there by users. I can now get to the data from any web browser, says Rik. Now you can do the same! Formerly http://sagar.org/psispi
Sheet2SQL
Freeware app by Ivo Woltring. Convert Sheet to SQL insert statements, for database programmers. Site includes several OPMs. Formerly http://home.hetnet.nl/mr_2/164/thedolphin/Epoc
T5Mdb
Read Palm Pilot HanDBase MobileDb database files. Freeware. Trygveh Henriksen. home.c2i.net/trygveh/english/
T5Story
Trygveh Henriksen. Database application designed to organise a collection of books. Database is based on the stories in the books, not on the books themselves. Must investigate it. home.c2i.net/trygveh/english/

This site will look much better in a browser that supports W3C web standards but it is accessible to any browser or internet device, including Psion Web and similar PDA or limited browsers. Netscape 4.x users - turn Style Sheets off. Your style sheet support is too broken to use (sorry).


ericlindsay.com -> epoc -> software sites -> database

Contact Webmaster PO Box 640, Airlie Beach, Qld 4802 Australia