Don,
It sounds like your project is similar to mine. My app is a scientific database that contains journal articles and data related to neuropsychological assessment. The goal is to support evidence-based clinical practice as well as to serve as a basis for research and a book I am working on. The database has 30 tables with up to three layers (parent-child-child). The ultimate size of the database will be in the 1000's of records.
I originally started the project in Paradox several years ago. Paradox was good for its day but it was deprecated and so I had to migrate. After much study (reading reviews, comparisons, mailing lists) I chose PostgreSQL. It is popular (so it won't be deprecated), has excellent documentation, the support group is super, and it is very reliable. It has some pretty important features; transactions and built-in referential integrity. I also develop in a Windows XP environment - without problems.
Regarding resources, my install of PostgreSQL takes up 100M of disk, with 57M used by the data directory (my database is only about 11M). I don't think that's too big of a footprint for modern programs.
I programmed my user interface in Java, using Eclipse. I found the learning curve for Eclipse to be pretty steep and, unlike PostgreSQL, the documentation and community support are uneven. Now that the interface is done, I'm pretty happy with it. The basic interface - without custom features needed for a specific purpose - is available on pgFoundry (the Komo project) and you can use it to get started. Have a look!
For output, I added JasperReports to my GUI and that works fine. Note that PostgreSQL, Eclipse, and JasperReports are all open source.
Good luck!
Michael Schmidt
