← Back to team overview

dhis2-devs team mailing list archive

Re: Web GUI for Query Development

 

We have used OpenVPN/IPSec to allow direct access to the database for those
users who need it. Therefore users do not need shell access and strong
certificates can be used. This was viewed as a lower security risk than
having PHP on the server or by opening up the database itself directly.
Might also be a route to consider.

Regards,
Jason

--Sent from my mobile
On Mar 4, 2014 8:02 PM, "Bob Jolliffe" <bobjolliffe@xxxxxxxxx> wrote:

> yes people talk highly of phpPgAdmin.  It has some small benefit over
> pgadminIII that you don't have to explicitly open up your pg_hba.conf
> settings to the full range of user/hosts which might connect.
>
> I guess it would be a simple enough app to embed phpPgAdmin into some sort
> of iframe for integration with dhis ...
>
>
> On 4 March 2014 16:16, Jason Pickering <jason.p.pickering@xxxxxxxxx>wrote:
>
>> Hi Greg,
>> You may want to check out phpPgAdmin.
>>
>> PgAdminIII could also of course be used by directly connecting to the
>> database with an ODBC connection.
>>
>> Regards,
>> Jason
>>
>> --Sent from my mobile
>> On Mar 4, 2014 12:26 PM, "Greg Rowles" <greg.rowles@xxxxxxxxx> wrote:
>>
>>> Hi Devs
>>>
>>> Is anyone aware of a web-based query gui-toolset? We have an 'IE'
>>> designed tool here:
>>>
>>> http://hispsa.org/staging_timesheets/tablerels/viewtables.asp
>>>
>>> It only works on IE (sometimes) but at least allows users to see table
>>> designs and edit SQL syntax. We're looking at something that we can plug-in
>>> ontop of DHIS2 for our advanced users...
>>>
>>> Any responses will be appreciated...
>>>
>>> Thanks,
>>> Greg
>>> --
>>>
>>> Business Intelligence Planner
>>> *Health Information Systems Programme*
>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - -
>>> - - *
>>> Mobile  :    073 246 2992
>>> Landline:   021 554 3130
>>> Fax:          086 733 8432
>>>  Skype:      gregory_rowles
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

Follow ups

References