Multiple fieldnames in SQL query, was: Perl vs. python vs. Lua?

[Alan DeKok]

On Apr 12, 2018, at 11:15 AM, Dom Latter <freeradius-users at latter.org> wrote:
> Ah, I made the rash assumption that anything mentioned then would by
> now be current - but I now understand that v4 is a big rewrite.

  Yeah.  Lots and lots and lots of things are changed.

  The good news is that the server is a lot more capable.  The bad news is that it isn't done yet.

> So the plan was to move to Perl; but if we did that and ran our mysql queries inside a perl script would we still have the performance issues?

  It would be much better than forking a PHP script.

> I am beginning to think that we can construct a (rather complicated)
> query that will return the VLAN that needs to be assigned, or 0 to
> indicate rejection, or a magic number that will indicate further
> processing required, and use unlang to act appropriately (and call
> either a PHP script or in due course a perl script).

  That makes sense.

> Although rather than a select statement I think it would be a stored
> procedure.

  That's a common solution to this problem.

  Alan DeKok.