Thread: Sharing Database Connection Among Different CGI scripts writen in different languages
Sharing Database Connection Among Different CGI scripts writen in different languages
From
"Alexey V. Meledin"
Date:
Hi! I have 2 CGI scripts. Each script makes some queries to PostgreSQL and returns html code as a result . Simple example: 1-st CGI returns: "Hello, Anny!" (Anny is choosen from DataBase) 2-nd CGI returns: "There is 3 messages for you!" (number of messages is choosen from Database) Scripts can run separately each from other. Suppose, that I want to call 2-nd script from the first via HTTP or fork+execv+pipe. I receive: "Hello, Anny! There is 3 messages for you!" All OK, but I have two separated queries and two Backends started. It's not good, because I don't need any concurrency :( How can I optimize such situation? I see: 1. Share Database conection among two scripts. Can I do it? 2. Write "proxy" daemon to execute queries. Is it possible? 3. Use Application Servers and so either (can't use them and any other transaction mechanizm) Thenks, Alexey V. Meledin InterForge Developers Group, Saint-Petersburg look_to: <www.etcompany.ru><www.businessweb.ru> <www.inplan.spb.ru><www.pia.ru>>>>>>>>>>>>>>>>> mail_to: <avm@webclub.ru><nick_as: <cureman>>>>