[Caml-list] Re: OcamlDBI

[Richard Jones <rich@annexia.org>]

On Mon, Mar 01, 2004 at 07:51:38PM +0100, Christophe TROESTLER wrote:
> Well, you know much more about databases than I do but it seems to me
> that the following functions do the job: for PostgreSQL,
[...]

OK, this is interesting and I think we should do it.  It requires
coordination because we have a metric ton of code here which uses the
current access method, and that would have to all be changed.  I'll
see if I can schedule some time to do this with my manager.  I also
want to be more sure about exactly how the code is going to work, so
I'll probably want to build a few prototypes and share them with you -
I'm still not 100% sure I understand how the `Null stuff works.

> Also it would be nice to be able to declare in the code new conversion
> functions (e.g. to use `Point(x,y)) -- but the decoding part is tricky
> and probably impossible without Camlp4.  Have you had a need for such
> thing in your applications?  In any case, one should maybe add a
> [`Unknown of string] to deal with new types...???

We use lots of odd PostgreSQL types, eg. IP addresses ... but
generally insert and select these as strings and do any conversion
necessary ourselves.  Getting the basics working is most important.

Jeremy:

It looks like we have a chance to get ocamldbi accepted as the
standard DBI interface for OCaml, if we schedule some time to make a
few changes.  I guess we're looking at 1-2 days work tops.  What do
you think?

Rich.

-- 
Richard Jones. http://www.annexia.org/ http://www.j-london.com/
Merjis Ltd. http://www.merjis.com/ - improving website return on investment
http://www.YouUnlimited.co.uk/ - management courses

-------------------
To unsubscribe, mail caml-list-request@inria.fr Archives: http://caml.inria.fr
Bug reports: http://caml.inria.fr/bin/caml-bugs FAQ: http://caml.inria.fr/FAQ/
Beginner's list: http://groups.yahoo.com/group/ocaml_beginners