[Tinymux] @query/sql

[Suzanne Baylor]

Stephen Dennis wrote:

>PennMUSH people need to speak out that they have a preference or it is
>already implemented a particular way in one of their patches.
>
>
>  
>
You probably mean the coders but here is an end user perspective:

I have some SQL code that reads and writes phpBB, Mantis, PMBox, and 
misc modules in a PostNuke environment. It uses the sql() and 
sql_escape() pretty much exclusively. I've never noticed a lag problem 
but its all on the same server and is mostly just me goofing around 
testing and learning.

I also play on a Rhost game that uses SQL and has about 60 active folks 
RPing at a time that I believe calls SQL fairly often (+noms, looking up 
info, etc.) In a year and a half I think it was down twice. The rhost 
help command list looks similar to Penn's: sql(), sqlescape(), @sql, 
@sqlconnect, @sqldisconnect, sqlon(), sqloff().

Also note that Penn's digest() encoding function was also very handy for 
checking user passwords stored up in the SQL database but that requires 
SSL for md5 encoding. (So add SSL to the list *grin*)

Suzanne