Powerbase Shareware Database

!Powerbase
Powerbase is for
Acorn 32-bit machines and their successors.
None of these programs will run on a PC or Mac.
For information about Acorn Computers and RISC OS click the cogwheel above or see
The RISC OS Site
Richard Atterer's history of Acorn
and follow the links from each site.
Click here to find out about Powerbase in general.
Click here to go to the Download area
Click here to retun to Boulsworth Main Index
What's New?
Site last updated:
31 May 2010
The latest version of Powerbase is v.9.72 which incorporates a few minor changes and bug-fixes from v.9.70 whose description follows.
It's been a long time since a new version of Powerbase appeared and some people might have concluded that the program is no longer being developed. This is far from true; many changes have been implemented in the last couple of years and here at last is v. 9.70. The three major changes from previous versions are as follows:
- The separate versions suffixed DA and SH no longer exist; there is now just one Powerbase suitable for all versions of RISC OS from 3.1 onward. It detects which RISC OS version is being used and loads an appropriate library to support either the sliding heap (for RISC OS 3.1) or dynamic area handling (for RISC OS 3.5 or later).
- The user no longer needs to invoke index balancing or shun data entry in key-order. A new, self-balancing, type of index has been introduced which keeps the indexes reasonably balanced at all times.
- The number of usable subfiles has been increased from 6 to 16. I know many users never need anything but subfile 0, but cataloguing something like a photo collection or a collection of newspaper cuttings is greatly eased by being able to split the data into a number of separate categories.
What about backward compatibility? Will older databases still work? The good new is yes, they will! Powerbase can convert them to the new index structure if you let it; and you should let it do so unless you intend to keep running databases on a pre-9.70 version. The new indexes are not compatible with older versions of Powerbase but the conversion routine does make backups of the old indexes before converting them so you can revert if you really need to.
The main development in v.9.42 was a radical overhaul of the resources for customising a database. The demonstration in custom/zip (see Download area, Miscellaneous downloads, Customising Powerbase) was completely rewritten to add non-trivial features to the !Elements database and gives a much better idea than formerly of what can be achieved. Efforts have been made to provide facilities making it much easier for users to incorporate such fundamental features as menu-creation, text output to a window, scanning a database subfile and providing interactive help. The HTML documentation for Ch 15 of the Reference Manual has been greatly expanded to describe these improvements. Please note that there has been an important change in the method used to report events such as database opening, record loading etc. from Powerbase to a customisation library and the array special%() is no longer used for this purpose. !Sudoku and the customised version of !Elements make use of these events and need at least Powerbase v.9.44 (see below) to run.
Powerbase SUDOKU
!Sudoku is a database which makes use of some of the newest features of Powerbase and also demonstrates how databases can be customised with non-standard features. Each record has just two editable fields: a Name field and a 9-column scrollable list in the form of a Sudoku grid. The custom features enable you to:
- type in a Sudoku puzzle then "fix" it so that only the blank squares are editable thereafter. (The puzzle can be "unfixed" if you made a mistake when entering it!)
- set about solving the puzzle by filling in the blanks. "Illegal" entries will be disallowed.
- click a Help button to tell you what numbers are allowed in the current square.
- reset the puzzle to its initial state if you make a mistake.
- solve the whole thing automatically (but you don't really want to do that, do you?)
- generate new puzzles automatically.
- merge puzzle into an Ovation Pro document at the click of a button. Print the puzzle on paper, with or without the addition of numbers which could go in each blank square.
Get !Sudoku from the Download area. Requires Powerbase v.9.44 or later; v.9.52 recommended.
Distribution list generator
!Distrib is a customised database which might prove useful for anyone who distributes magazines or newsletters to a list of subscribers, some of whom act as sub-distributors to subscribers living nearby. It will work if some of the latter subscribers are themselves sub-sub-distributors and so on! A mixture of postal and hand-deliveries is supported as are extra copies (e.g. for placing in a club or school) and large-print copies. Mailing labels may be printed for postal deliveries. The customisation library was written in response to a real situation faced by a long-term Powerbase user. The version now on the website incorporates a number of changes requested by the user.
Get !Distrib from the Download area. Requires Powerbase v.9.44 or later; v.9.52 recommended.
Manuals and Tutorials
The extensive improvements to Powerbase, especially those introduced in versions 9.25, 9.40 and 9.70 rendered the old documentation woefully out of date. The Ovation Pro and PDF documentation has now been withdrawn and only the HTML-based form, as described below, is supported.
!PbaseDoc — comprehensive HTML documentation
The HTML versions of the tutorials and the reference manual have been incorporated in an application !PbaseDoc. Since this is especially easy to modify and keep up to date it should henceforth be regarded as the definitive version of Powerbase documentation. Besides being extensively illustrated much attention has been devoted to the problem of navigating the large reference manual which constitutes the main part of the application. To this end the manual features:
- a list of chapters
- individual contents lists at the start of each chapter
- an alphabetical index
all of which are provided with HTML links. In addition, there is copious cross-linking between chapters and between parts of chapters, wherever the text refers to another part of the manual. If you follow such a link you will usually find that a return link is provided to get back to where you were before. Button links occur frequently to take you to the start of a chapter or to an illustration of an important dialogue box.
PbaseDoc can be run from the new Help button on Powerbase's iconbar Info window, provided that PbaseDoc and your web browser have both been "seen" by the filer. The very limited Helpreader text incorporated in previous versions of Powerbase has now been removed along with the menu entries which invoked it.
32-bit compatible sliding-heap module
The sliding-heap module was written by Steven Haslam in 1992. It creates and manages any required number of
memory blocks at the top of a program's Wimpslot and allows them to be resized, scrapped and re-created at will.
Because increasing the size of a block is achieved by moving up blocks at higher addresses, and shrinking or
destroying a block results in the "hole" being closed by other blocks sliding down, memory fragmentation is avoided.
The module has now been upgraded to make it 32-bit compatible. Visit the Download area
to obtain a copy of this module for use in your own programs, along with extensive documentation, a library of
BASIC routines for accessing the module's SWIs and a demonstration of the module in action. Thanks are due to
Christopher and Harriet Bazley for undertaking this work.
Powerbase is shareware. Registration costs 10 GBP, payable by cheque to Derek Haslam.
You may register by credit card through APDL.
The printed Manual, with Supplement and Tutorials booklet, (costs 5ukp, not downloadable!)
covers versions through 8.33 (updated May 2001). These items are printed from the Ovation Pro documents
described below.
This site (http://www.boulsworth.co.uk/) is for distribution of Powerbase,
Derek Haslam's shareware database for RiscOS computers.
for more information about Powerbase or if you have comments about the website.
Click here to go to top of page.
Click here to go to the Download area
Click here to meet the programmers.