[MonetDB-users] Persistent Stored Modules ?
I need to perform some ETL processing for which I need CURSOR support in a PSAM. I read the meta-data in a CURSOR and dynamically create SQL statements for execution. According to documentation CURSORS are not supported because of the underlying data model in a PSM. This means I can't use PSM for my ETL processing. Let me know if there is anything I could use a PSM in my ETL process. I only wish you had a driver for Ruby. I see that you have PERL, Python and PHP. It would be great if we have a Ruby Library (:- Regards,
Venks wrote:
I need to perform some ETL processing for which I need CURSOR support in a PSAM. I read the meta-data in a CURSOR and dynamically create SQL statements for execution. According to documentation CURSORS are not supported because of the underlying data model in a PSM. This means I can't use PSM for my ETL processing. Let me know if there is anything I could use a PSM in my ETL process.
I only wish you had a driver for Ruby. I see that you have PERL, Python and PHP. It would be great if we have a Ruby Library (:-
Yes, it is on our wishlist for almost a year. The key problem is that we don't have access to an *experienced* Ruby programmer. If in the community there is such a person, who also knows C, and who has some spare time to help out, we are glad to join forces to create this API. Our estimate is that wrapping Mapi library into Ruby is a matter of a few days (or even less). The subsequent construction of the driver classes takes more time.
Regards,
------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Dec 7, 2007 4:39 PM, Venks
I only wish you had a driver for Ruby. I see that you have PERL, Python and PHP. It would be great if we have a Ruby Library (:-
This probably isn't what you want to hear. But you might want to check out SQLAlchemy, if you are looking for an ORM or SQL generation. I'm writing the backend for Monetdb. It's written in python. If you're using ROR or everything in Ruby this won't help. But if you're doing from the command line it might be worth a shot. -matt
participants (3)
-
m h
-
Martin Kersten
-
Venks