[Phpwm] SQL query builder

[Tony Lovering]

alan dunn wrote:
> 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
>>
>>
>>   
>
Have a look at JasperReports there's a version that you can embed in 
your application:

http://www.jaspersoft.com/JasperSoft_JasperReports.html

Tony

-- 
**********************************************************************
This email message and any files transmitted with it are confidential and intended solely for the use of the addressee.  This communication may contain material protected by law from being passed on.  If you are not the intended recipient and have received this email message in error, you are advised that any use, dissemination, forwarding, printing or copying of this email message and any files transmitted with it is strictly prohibited.  If you have received this email in error, please contact the sender immediately by reply email and then delete it from your system.

Thank you for your co-operation.
**********************************************************************