Re: Database bindings development ?

Slobodan Blazeski schrieb:
I just started a new app which needs data warehousing capable RDMBS
backend, so I went for MonetDB http://monetdb.cwi.nl/. Hooking lisp
through odbc works fine but it seemed that odbc is malfunctioning on a
lot of machines , mostly because of corrupted registries or
malfunctioning MDAC, also the instalation process would be more
cumbersome. So I'm asking myself how much would it take to create
production quality bindings for monetdb? And does it worth it? If
anybody has some experience with creating database bindings I would be
glad to hear it.

Hello Slobodan,

I've recently "finished" (that is, it's 90% complete and currently on
hold, till in a few weeks or so) a binding to the Firebird database.
It already works rather well. Firebird is a fork from Interbase,
which is developed Borland aka Inprise. Borland stopped releasing
Interbase as open-source, so the community took over, founded the
Firebird project and continued work on the codebase. That's been like
five years or so, iirc.
Firebird a very good database and we're using it for years now. It's
simple to set up, stable, has stored procedures, triggers, foreign keys,
generators (similar to sequences) and even more neat features in the
recently released version 2.0.
The binding works on Interbase, too, since the network-protocol did
not change. I'm not all that certain about the newer, commercial
releases of Interbase, though.

You can find my bindings (consisting of a C-library (that's actually
written in C++, but exports C symbols) and the Lisp cffi-code with
a small beatifie-layer) at
http://code.google.com/p/fbsql/

Disclaimer: This was actually my first Lisp-project (I'm still in the
learning process) and it's hacked together in a matter of days. It's
rather clean, in my opinion, but there might be things that an
experience Lisp-programmer might consider stupid. Anybody feel free
about contacting me with any kind of issues with the code.
There'll be a major cleanup in the future, and I'll eventually release
a version 1.0 then.

Regards,
Daniel Albuschat
.

Relevant Pages

  • Re: Database bindings development ?
    ... malfunctioning MDAC, also the instalation process would be more ... anybody has some experience with creating database bindings I would be ... Firebird is a fork from Interbase, ...
    (comp.lang.lisp)
  • Re: Database bindings development ?
    ... malfunctioning MDAC, also the instalation process would be more ... anybody has some experience with creating database bindings I would be ... Firebird is a fork from Interbase, ...
    (comp.lang.lisp)
  • Re: Database bindings development ?
    ... malfunctioning MDAC, also the instalation process would be more ... anybody has some experience with creating database bindings I would be ... Firebird is a fork from Interbase, ...
    (comp.lang.lisp)