Return-Path: X-Original-To: apmail-httpd-dev-archive@www.apache.org Delivered-To: apmail-httpd-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 65657D2E6 for ; Sun, 6 Jan 2013 15:23:47 +0000 (UTC) Received: (qmail 77121 invoked by uid 500); 6 Jan 2013 15:23:46 -0000 Delivered-To: apmail-httpd-dev-archive@httpd.apache.org Received: (qmail 77066 invoked by uid 500); 6 Jan 2013 15:23:46 -0000 Mailing-List: contact dev-help@httpd.apache.org; run by ezmlm Precedence: bulk Reply-To: dev@httpd.apache.org list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list dev@httpd.apache.org Received: (qmail 77057 invoked by uid 99); 6 Jan 2013 15:23:46 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Jan 2013 15:23:46 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [188.40.99.202] (HELO eru.sfritsch.de) (188.40.99.202) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Jan 2013 15:23:37 +0000 Received: from stf (helo=localhost) by eru.sfritsch.de with local-esmtp (Exim 4.72) (envelope-from ) id 1Trs4C-00029d-SU for dev@httpd.apache.org; Sun, 06 Jan 2013 16:23:16 +0100 Date: Sun, 6 Jan 2013 16:23:16 +0100 (CET) From: Stefan Fritsch X-X-Sender: stf@eru.sfritsch.de To: dev@httpd.apache.org Subject: Re: [Discuss] mod_lua and database connectivity In-Reply-To: <50E97881.4090505@cord.dk> Message-ID: References: <20130105222442.GC22476@brevard.conman.org> <50E97881.4090505@cord.dk> User-Agent: Alpine 2.00 (DEB 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Checked: Checked by ClamAV on apache.org On Sun, 6 Jan 2013, Daniel Gruno wrote: > Now I just have to take a good look at how to rewrite the prepared > statement stuff, and I believe I'll have a decent proposal ready for > commit :) I am a bit late in the discussion, but maybe you also want to support using statements that have been prepared with DBDPrepareSQL from mod_dbd? Other important things (but I think these have already been pointed out): - don't let lua scripts open connections, instead make them aquire connections from mod_dbd's connection pool. - use parametrized prepared statements in all examples and make that as easy to use as possible. Don't show any examples that put parameters directly into the statement strings.