[Twisted-Python] Any good examples?
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify? I've been reading the Twisted docs since yesterday but I am a bit overwhelmed by the design of the framework. Mktap looks to be the way to go but I need more info especially on the factory and protocol classes. -- Best Regards, Mel Irizarry ----------------------------- I can't go to school 'cause I ain't got a gun I ain't got a gun 'cause I ain't got a job I can't get a job 'cause I can't go to school Lost in America - Alice Cooper
On Sun, 10 Apr 2005 16:52:57 -0700, Mel Irizarry <melirizarry@adelphia.net> wrote:
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify?
I've been reading the Twisted docs since yesterday but I am a bit overwhelmed by the design of the framework. Mktap looks to be the way to go but I need more info especially on the factory and protocol classes.
These links might get you started: <http://twistedmatrix.com/documents/current/howto/servers> <http://twistedmatrix.com/documents/current/howto/enterprise> Jp
There are plenty of examples on how to use adbapi and how to write servers. 1 + 1 = 2. On Apr 10, 2005, at 7:52 PM, Mel Irizarry wrote:
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify?
I've been reading the Twisted docs since yesterday but I am a bit overwhelmed by the design of the framework. Mktap looks to be the way to go but I need more info especially on the factory and protocol classes. -- Best Regards,
Mel Irizarry
----------------------------- I can't go to school 'cause I ain't got a gun I ain't got a gun 'cause I ain't got a job I can't get a job 'cause I can't go to school
Lost in America - Alice Cooper
_______________________________________________ Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
Mel Irizarry <melirizarry@adelphia.net> writes:
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify?
I must not understand because this is exactly what "mysqld" does. -Brett.
Brett Viren wrote:
Mel Irizarry <melirizarry@adelphia.net> writes:
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify?
I must not understand because this is exactly what "mysqld" does.
-Brett.
_______________________________________________ Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
I do not want the clients to connect directly to MySQL. It's a security issue. -- Best Regards, Mel Irizarry ----------------------------- I can't go to school 'cause I ain't got a gun I ain't got a gun 'cause I ain't got a job I can't get a job 'cause I can't go to school Lost in America - Alice Cooper
So you're going to parse their SQL statements for bad statements? On Apr 11, 2005, at 3:28 PM, Mel Irizarry wrote:
Brett Viren wrote: Mel Irizarry <melirizarry@adelphia.net> writes:
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify?
I must not understand because this is exactly what "mysqld" does.
-Brett.
_______________________________________________ Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
I do not want the clients to connect directly to MySQL. It's a security issue.
-- Best Regards,
Mel Irizarry
----------------------------- I can't go to school 'cause I ain't got a gun I ain't got a gun 'cause I ain't got a job I can't get a job 'cause I can't go to school
Lost in America - Alice Cooper
_______________________________________________ Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
Mel Irizarry wrote:
I am in need of a server that will allow multiple clients to connect, take a MySQL Statement from the client, execute it and return the results to the client. Is there a good example that I could download and perhaps modify?
I'm not sure how clients would be connecting, but it sounds like you want Twisted to actually behave as a MySQL server. This is probably going to be tricky because you're going to have to re-implement the MySQL server-side protocol. If having clients connect through another protocol like Perspective Broker is an option, you could get by pretty easily. I attached a couple of files that basically combine the twisted perspective broker and rdbms examples. -Ken
participants (5)
-
Brett Viren -
Jp Calderone -
Ken Kinder -
Mel Irizarry -
orbitz＠ezabel.com