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

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