[Phpwm] SQL query builder

[alan dunn]

The dataset is quite big - about ten tables of dynamic data and 
30/fields per table so pre-defining queries would be challenging.
We are looking at phpPgAdmin - but before letting the users in there we 
would have to disable all the update/delete/drop functionality - it is 
too comprehensive. Crystal Reports is almost a model for what we want - 
but without all the report formatting -  maybe I just tell the client to 
buy copies of Crystal Reports!

alan dunn

Keith Pope wrote:
> How complex is the dataset? Could you create a load of views that do most of the aggregation and then create a simple search for each view? 
>
> Also you could use something like zend_db_table to easily wrap each view, then you can just create a simple query interface for the user.  
>
> Talking of DB stuff doctrine http://www.phpdoctrine.org is RC1 now worth checking it out, I am liking the look of the DQL http://www.phpdoctrine.org/documentation/manual/0_10/?chapter=dql-doctrine-query-language
>
>
> Keith Pope
> Web Developer
>
> -----Original Message-----
> From: David Goodwin [mailto:david at codepoets.co.uk] 
> Sent: 28 April 2008 12:07
> To: West Midlands PHP User Group
> Subject: Re: [Phpwm] SQL query builder
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Zeth wrote:
> | 2008/4/28 alan dunn <alan at dunns.co.uk>:
> |> OK couple of other details I didn't add - the db is postgres (I think 
> |> phpMyAdmin is just MySQL) and the users are non-technical so a nice 
> |> gui query builder would be good.
>
>
> There is phpPgAdmin, but I'm not sure that giving them a read-only user account would sufficiently provide a 'Query Builder' like capability.
>
>
>
> - --
> David Goodwin
>
> [ david at codepoets dot co dot uk ]
> [ http://www.codepoets.co.uk       ]
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFIFa/Q/ISo3RF5V6YRAnArAJ4whW58+p4l/Rm8m5xFeDb6jd1IKgCfUMRc
> eS/Hyi/RCuvhv5R0cgp3NpY=
> =SZXk
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Phpwm mailing list
> Phpwm at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
> --
>
> allpay.net Limited, Fortis et Fides, Whitestone Business Park, Whitestone, Hereford, HR1 3SE. 
>
> Registered in England No. 02933191. UK VAT Reg. No. 666 9148 88. 
>
>
>
> Telephone: 0870 243 3434, Fax: 0870 243 6041. 
>
> Website: www.allpay.net
>
> Email: enquiries at allpay.net 
>
>
>
> This email, and any files transmitted with it, is confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this email in error please notify the allpay.net Information Security Manager at the number above.
>
> _______________________________________________
> Phpwm mailing list
> Phpwm at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
>   

-- 

DISCLAIMER:

This document originates from within Dunns Imaging Group Limited.
This message, together with any associated files, is intended only for 
the use of the individual or entity to which it is addressed and may 
contain information that is confidential, subject to copyright or 
constitutes a trade secret. If you are not the intended recipient of 
this communication you are hereby notified that any dissemination, 
copying or distribution of this message, or of any files associated with 
this message, is strictly prohibited.
If you have received this message in error, please notify us at once.

Dunns Imaging Group Ltd.
Registered Office: Chester Road Cradley Heath West Midlands B64 6AA.
Tel: 01384 564770
Registered in England 598527.