[Spce-user] DB queries via WSDL

[Andreas Granig]

Hi,

On 06/26/2013 11:32 AM, andreas tseiko wrote:
> Is it possible to make multiple and concurrent queries to MySQL DB via WSDL?
> If yes, is there any limitation regarding the number of them?
> Is it going to affect CE performance?

Well, not arbitrary queries, as you can only call functions defined in 
the WSDL, and there is no function where you could pass raw sql queries.

Maybe there are already functions for the queries you need, depends on 
what you want to achieve :)

Other than that, you can of course create a mysql user which allows 
direct access from the outside. Just make sure to restrict your grants 
to selects and never manipulate data directly in sql, as it will most 
likely screw up your system if you don't know exactly what you're doing 
and what the impact of each query is.

Andreas