[plt-scheme] Why do folks implement statically typed languages?

Prepare statement is more or less a named stored procedure with one query
statement (i.e. less powerful) - not all database supports it by default (I
don't know whether Oracle supports it because I have no experience with
Oracle, but AFAIK Oracle has a notion of stored procedures), but the basic
concept remains the same - abstracting statement(s) by name and parameters.

HTH,
yinso

On 5/31/07, Richard Cobbe <cobbe at ccs.neu.edu> wrote:
>
> On Thu, May 31, 2007 at 11:22:53PM +0200, Jens Axel Søgaard wrote:
> >  Richard Cobbe skrev:
> > > On Thu, May 31, 2007 at 10:19:36PM +0200, Jens Axel Søgaard wrote:
>
> > >>  > (define s (prepare db (sql (SELECT (entry_id title url score)
> > >>                                    FROM entries
> > >>                                    ORDER-BY (score DESC)
> > >>                                    LIMIT ,"?"))))
> > > Looks great, and I'd love to know more about this.  Let's start with:
> > >   - sqlite.plt defines prepare in terms of an FFI call to SQLite.  Is
> this
> > >     feature available for other DBMSs (specifically Oracle)?  Or are
> > >     Oracle's bind variables (SELECT x FROM y WHERE z = :1) the
> equivalent
> > >     functionality?
> >
> >  I am no database expert, but I think Prepare is part of the SQL
> >  standard.
>
> So I did some digging -- specifically, I googled for
>     "prepared statement" oracle.
> Everything I've seen so far suggests that this notion of a prepared
> statement is part of [OJ]DBC, rather than SQL.  We're not using *DBC, so
> AFAICT this doesn't apply, but we appear to have an equivalent
> alternative.
>
> I'm spending so much time on this here because I want to make sure I'm not
> overlooking something that would be useful to us.
>
> > >   - I'm particularly interested in the sql form above, but it doesn't
> seem
> > >     to be defined in sqlite.plt.  Where'd that come from?
> >
> >  See  "An Introduction to Web Development with PLT Scheme"  for an
> >  elaborate explanation.
>
> Thanks; I'll check that out.
>
> Richard
> _________________________________________________
>   For list-related administrative tasks:
>   http://list.cs.brown.edu/mailman/listinfo/plt-scheme
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.racket-lang.org/users/archive/attachments/20070531/4fbff238/attachment.html>