OCaml-MySQL

OCaml-MySQL

[Daniel Margolis]

Hi,

I'm trying to get database access working in OCaml, using v. 3.0.9 on  
MacOS 10.4. So first, if anyone has recommendations of a good  
interface for any (free) database server (i.e. I'm not tied to  
implementation--MySQL, PostgreSQL, SQLite, etc, are all fine), I'd  
gladly like to hear them. Performance is something of a concern, but  
my main concern is ease of use--something with an intuitive interface  
would be nice.

Second, I've been trying to get OCaml-MySQL  (from http:// 
raevnos.pennmush.org/code/ocaml-mysql/) working, since it seems a  
good option. So I had to replace the OCamlMakefile it comes with with  
a newer version (because the version it comes with tries to do gcc - 
shared, which is unavailable on OSX) to get it to compile. But when I  
try to build the demo, using "ocamlc mysql.cma demo.ml", I get

> Error on dynamically loaded library: Symbol not found:  
> _mysql_get_host_info
>   Referenced from: ./dllmysql_stubs.so
>   Expected in: flat namespace

I don't know anything much about linking OCaml code to C modules, so  
I'm a bit lost. Can anyone suggest what might be causing this, and  
how I can fix it?

Thanks,
Dan

Re: [Caml-list] OCaml-MySQL (fixed)

[Daniel Margolis]

With some help, I've managed to get OCaml-MySQL working. But if  
anyone has any other recommendations of database libraries, still  
feel free to share them with me.

Thanks.

Re: [Caml-list] OCaml-MySQL (fixed)

[Richard Jones]

On Mon, Nov 14, 2005 at 01:43:39PM -0500, Daniel Margolis wrote:
> With some help, I've managed to get OCaml-MySQL working. But if  
> anyone has any other recommendations of database libraries, still  
> feel free to share them with me.

ocamldbi has a MySQL interface.

http://savannah.nongnu.org/download/modcaml/

Rich.

-- 
Richard Jones, CTO Merjis Ltd.
Merjis - web marketing and technology - http://merjis.com
Team Notepad - intranets and extranets for business - http://team-notepad.com

Re: [Caml-list] OCaml-MySQL (fixed)

[David Baelde]

It may be worth pointing that ocaml-mysql is not thread-ready. I
reported that a few months ago and nothing was done. The problem is
that the bindings do not declare blocking sections, so when one thread
calls a mysql function (which can take time) the other threads won't
be scheduled.

I'm glad to hear about ocamldbi. Is it well maintained ? has blocking
sections stuff ? If so, we (savonet.sf.net) should swicth to it.
--
David