how to create a filter layer before the db

[Amzul]

hello all,

i want to know how and in what language i should write a filter layer before querying mysql.

i want to send to this layer all the query's (update insert and select) and this layer will bring back errors (like if the query have a wrong table name or bad col name)
and after the query was checked it will query the DB and return the result from the db to the user.

i want it super fast and stable.

in what language i should write it? (C? C++? perl?)
the server is linux or freebsd i haven't deiced yet

thank you

[Atli]

Hi.

That depends on personal preference, really.

But, generally, when speed is your primary concern, C/C++ is your best bet.
However, it's a pain to use and it's very easy to make horrific mistakes if you don't know your way around it.

I would also consider using Python. It is allegedly very fast, for an interpreted language anyways, and much more "developer-friendly" than C/C++.

[Amzul]

do you happen to know a port or rpm for that? speed and stability is what i am after,
no need to develop it if its been done before
specially if i don't have the 'tools' for it

thanks