Had a discussion this afternoon about finding a suitable graphical front-end client, to run under Windows, for the database Postgres. This is a project run by my “assistant”, ‘cos he’s had more experience with serious database admin than I have.
Initial plans were to use the data access part of OpenOffice but that didn’t work too well – seemed to run into some kind of read-only mess. Next up was PgAccess which seemed to be a little quirky, to put it mildly. So we were stuck. I can’t believe we’ve decided to try using Microsoft Access instead – this doesn’t strike me as a good idea – and in any case, my initial testing didn’t uncover any way to store queries in the databases (“views”).
Have just been taking a look at PgAdmin which looks like it has potential. It is quite fully-featured and apart from the lack of a decent graphical query builder, seems very nice. Only down-side here is that the end-users may insist on a friendly query-building interface …
Update Wednesday 17.12.2003 12:24: Seems that the end-users in question are quite happy to learn how to use SQL directly 😎 which is a rather welcome development. Means they won’t really be too fussy about which Windows client they use. Think we’ll probably go with PgAdmin.
Are you using Open Office via ODBC- that should not be read-only.
PermalinkUsing psqlodbc, yes, and OpenOffice under Windows 98. The database access works, but changes cannot be made to the database. My colleague had some discussions on one of the postgresql mailing lists and on one of the openoffice mailing lists – it was fairly clearly confirmed by one of the OO developers that this is a limitation of OO.
Permalink