[MonetDB-users] I'm looking for a fast way to write data to the DB from a scripting language.

Martin Kersten Martin.Kersten at cwi.nl
Sun Sep 7 10:11:23 CEST 2008

Dear JJ

Thanks for using MonetDB. Please could you identify the platform
you use MonetDB on and its version? Moreover, the message below
indicates a possible problem we are not aware of. Can you provide
a micro example that illustrates the failed calls, e.g. a 5 line PHP program
to localize the bug.

thanks in advance in improving the code base.

regards, Martin

JJ Jakosky wrote:
> Thank you for replying quickly. Ruby would be a good choice.
> I'm not clear about MAPI. I only know of Mail API. Does this mean 
> Monet API?
> I see a reference to the MAPI include files. Can you please outline 
> the first steps I can take to get this going in Ruby? Can I compile in 
> Cygwin or do I need to do it on Linux?
> Thanks,
> Jay
> On Sat, Sep 6, 2008 at 11:20 PM, Michalis Polakis <mpolakis at gmail.com 
> <mailto:mpolakis at gmail.com>> wrote:
>     Good morning Jay,
>     you can use the Ruby MAPI Wrapper => MAPI calls through Ruby.
>     It's elegant and simple and was used to implement the Ruby on Rails
>     adapter for MonetDB.
>     Plus, from what I see in the SWIG input file, the insert and copy_from
>     functions should be
>     implemented in the Ruby MAPI Wrapper.
>     If you want to go the Ruby way, you may find the files in the MonetDB
>     clients package or
>     at http://rubyforge.org/projects/monetdb-ror/ as part of the Ruby on
>     Rails MonetDB adapter.
>     Regards,
>     Michalis
>     -----------------------------------------------------------------------------------------------
>     Hi,
>     I have 50 million rows and 15 columns that I'd like to put into one
>     table. My first attempt to transfer them was through PHP using the
>     monetdb_query method. This is causing a lot of disk thrashing and my
>     throughput is about 100 rows/sec.
>     I get an "undefined function" error for both monetdb_insert and
>     monetdb_copy_from.
>     I would like to find a fast method, but from inside a common
>     scripting language.
>     Thanks,
>     Jay
> -- 
> JJ Jakosky
> 720.244.0137
> ------------------------------------------------------------------------
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ------------------------------------------------------------------------
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users

More information about the users-list mailing list