Re: [MonetDB-users] Using monetdb and sqlalchemy
Still stuck. If you know the answer please share it. Also if you think the two are not meant to work together, share it too. Anyone?
----- Message transféré de sabst@free.fr ----- Date : Thu, 10 May 2012 15:07:17 +0200 De : sabst@free.fr Adresse de retour :sabst@free.fr Sujet : Using monetdb and sqlalchemy À : monetdb-users@lists.sourceforge.net
Hi, I am just starting using monetdb and, even if I could find discussions about Python/SqlAlchemy integration, I could not make it work.
I installed python-monetdb module and have a running monetdb server.
Now I expect my client application to work with monetdb as it does with postgresql and instead of passing a connection string like: postgres://user:password@somehost:port/db I use: monetdb://user:password@somehost/db
But I get this error: ArgumentError: Could not determine dialect for 'monetdb'.
What are the steps required to integrate monetdb into SqlAlchemy?
Certainly missing the obvious but I'm currently stuck.
Thank you in advance for any help, Stephane.
----- Fin du message transféré -----
On Sun, May 20, 2012 at 11:13:32PM +0200, Sabst wrote:
Still stuck.
If you know the answer please share it. Also if you think the two are not meant to work together, share it too.
Anyone?
Sabst A wild guess, your missing the monetdb backend code for sqlalchemy. Other db's (such as postgres) backend code has been added to sqlalchemy and is probably included in the normal sqlalchemy sources and/or your linux distribution. For MonetDB you need to obtain the latest backend code, problem is I'm not sure there is currently a working versie. A quick look on google only shows rather old versions. Niels
----- Message transféré de sabst@free.fr ----- Date : Thu, 10 May 2012 15:07:17 +0200 De : sabst@free.fr Adresse de retour :sabst@free.fr Sujet : Using monetdb and sqlalchemy À : monetdb-users@lists.sourceforge.net
Hi, I am just starting using monetdb and, even if I could find discussions about Python/SqlAlchemy integration, I could not make it work.
I installed python-monetdb module and have a running monetdb server.
Now I expect my client application to work with monetdb as it does with postgresql and instead of passing a connection string like: postgres://user:password@somehost:port/db I use: monetdb://user:password@somehost/db
But I get this error: ArgumentError: Could not determine dialect for 'monetdb'.
What are the steps required to integrate monetdb into SqlAlchemy?
Certainly missing the obvious but I'm currently stuck.
Thank you in advance for any help, Stephane.
----- Fin du message transféré -----
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
Hi Niels, Thank you for the answer. I mentioned the packages I used (python-monetdb and monetdb server). Do you refer to another one? BTW, is anyone using such a combination of MonetDB and sqlalchemy? If not, I should probably stop my investigation. Regards, Stephane. -- View this message in context: http://old.nabble.com/Re%3A-Using-monetdb-and-sqlalchemy-tp33879693p33885299... Sent from the monetdb-users mailing list archive at Nabble.com.
On Mon, May 21, 2012 at 01:34:43PM -0700, Sabst wrote:
Hi Niels,
Thank you for the answer. I mentioned the packages I used (python-monetdb and monetdb server). Do you refer to another one?
Indeed you need more, but we as in "the MonetDB team" do not supply such backend module for sqlalchemy.
BTW, is anyone using such a combination of MonetDB and sqlalchemy? If not, I should probably stop my investigation.
I only know of a very old attemp to get a version of the backend driver into the sqlalchemy code repository, but that attempt sofar failed. Niels
Regards, Stephane.
-- View this message in context: http://old.nabble.com/Re%3A-Using-monetdb-and-sqlalchemy-tp33879693p33885299... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
Ok, I will give up for now. Thank you, Stéphane. -- View this message in context: http://old.nabble.com/Re%3A-Using-monetdb-and-sqlalchemy-tp33879693p33897972... Sent from the monetdb-users mailing list archive at Nabble.com.
participants (2)
-
Niels Nes -
Sabst