{"id":51,"date":"2003-12-16T19:36:37","date_gmt":"2003-12-16T19:36:37","guid":{"rendered":""},"modified":"2003-12-16T19:36:37","modified_gmt":"2003-12-16T19:36:37","slug":"","status":"publish","type":"post","link":"https:\/\/www.sungate.co.uk\/?p=51","title":{"rendered":"Database front-end"},"content":{"rendered":"<p>Had a discussion this afternoon about finding a suitable graphical front-end client, to run under Windows, for the database <a href=\"http:\/\/www.postgresql.org\/\">Postgres<\/a>.  This is a project run by my &#8220;assistant&#8221;, &#8216;cos he&#8217;s had more experience with serious database admin than I have.<\/p>\n<p>Initial plans were to use the data access part of <a href=\"http:\/\/www.openoffice.org\/\">OpenOffice<\/a> but that didn&#8217;t work too well &#8211; seemed to run into some kind of read-only mess.  Next up was <a href=\"http:\/\/www.pgaccess.org\">PgAccess<\/a> which seemed to be a little quirky, to put it mildly.  So we were stuck.  I can&#8217;t believe we&#8217;ve decided to try using <a href=\"http:\/\/office.microsoft.com\/home\/office.aspx?assetid=FX01085791\">Microsoft Access<\/a> instead &#8211; this doesn&#8217;t strike me as a good idea &#8211; and in any case, my initial testing didn&#8217;t uncover any way to store queries in the databases (&#8220;views&#8221;).<\/p>\n<p>Have just been taking a look at <a href=\"http:\/\/www.pgadmin.org\/\">PgAdmin<\/a> 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 &#8230;<\/p>\n<p><b>Update Wednesday 17.12.2003 12:24<\/b>: Seems that the end-users in question are quite happy to learn how to use SQL directly \ud83d\ude0e which is a rather welcome development.  Means they won&#8217;t really be too fussy about which Windows client they use.  Think we&#8217;ll probably go with <a href=\"http:\/\/www.pgadmin.org\/\">PgAdmin<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;assistant&#8221;, &#8216;cos he&#8217;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&#8217;t work&#8230;&nbsp;(<a href=\"https:\/\/www.sungate.co.uk\/?p=51\">read more<\/a>)<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=51"}],"version-history":[{"count":0,"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sungate.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}