PMF for Linux and Windows, current version: 5.1.25 (June  2020)

Note: Starting with v.5.1.19, the DB2 CAE-based plugin for PMF will require DB2 v9 and higher. If you want PMF to work with older DB2 versions, drop me a mail.

What it's all about

Very short description: PMF (Poor Man's Flight) is an OpenSource table-editor/visualizer for IBM's DB2 database and Microsoft Sql Server. Main feature is viewing and editing any table in the database, but PMF has some other useful functions, too (see below). Useful for developers and database admins. PMF is available for Linux and Windows (and, for DB2 only, OS2).

What it does

Main Features: Additional features:

A little history

PMF (Poor Man's Flight) is a comfortable and rather powerful editor/visualizer for the tables of a DB2 Database. With DB2 v.2 IBM shipped a very useful program called "(Visualizer) Flight", which (among other things) allowed DB2 users to view and change the contents of tables.

In 1997 I started to write a program for my company which should do much the same (hence the name), for two reasons: First, we needed a trace-function: Changes to tables had to be documented. Second and most important, IBM's "Flight" was only available for OS/2 and we were using DB2 on both OS/2 and Windows. Since 1997 PMF has improved of course, it became faster and some useful functions have been added. Originally intended for inhouse use only, PMF soon became a "Don't leave home without it"-tool and even found some fans outside the company.

Being a Linux fan, I wanted to rewrite PMF for this platform and this is what I have been doing for the last couple of years. With TrollTech releasing a non-commercial edition of their librabry, I was able to port the Linux version to Windows and provide PMF as Free Software.
For nearly 5 years I didn't change much if anything, but with Trolltech releasing QT4 it became obvious that the times are indeed a-changing and that a complete rewrite of the GUI was necessary. I started around christmas 2010 and spent nearly a year fixing bugs and adding new features (I'm doing this in my spare time).

The latest iteration handles Sql Server as well, which required a redesign of the invisible parts. Busy times.

So, whether you are a database administrator or a software-developer or just curious to take a look into your database without view-blocking heavy interfaces, you might find PMF very useful.

Trademarks: Windows NT, Windows 2000, Windows XP, Sql Server trademarks of Microsoft Corporation; IBM, OS/2 and DB2 trademarks of International Business Machines Corporation; Linux is a trademark of Linus Torvalds. All other trademarks are trademarks of their respective owners.

Author: Gregor Leipelt