[MonetDB-users] Djonet
Hi, I've updated the MonetDB Django backend created by Mark Bucciarelli and renamed it to Djonet. https://github.com/gijzelaerr/djonet basic stuff is working, but many Django tests are still failing, which i'm working on. Still it is already quite usable. If people want to help make it better, let me know. -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/
I have an issue with getting all the Django tests working with MonetDB. Django assumes a database can have a column with a hyphen in it's name, as long as it is correctly escaped. It is this specific test which should generate valid SQL when passed trough the MonetDB Django backend: https://github.com/django/django/blob/master/tests/modeltests/reserved_names... Does MonetDB support a hyphen in it's column name, if so, how do I escape this correctly? -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/
On Wed, Jun 06, 2012 at 12:55:42PM +0000, Molenaar, Gijs wrote:
I have an issue with getting all the Django tests working with MonetDB. Django assumes a database can have a column with a hyphen in it's name, as long as it is correctly escaped.
It is this specific test which should generate valid SQL when passed trough the MonetDB Django backend: https://github.com/django/django/blob/master/tests/modeltests/reserved_names...
Does MonetDB support a hyphen in it's column name, if so, how do I escape this correctly?
I guess, MonetDB does not allow hyphens in identifiers, even when quoted: sql>create table t (a-b int); 42000!syntax error, unexpected '-' in: "create table t (a-" sql>create table t ("a-b" int); Invalid identifier 'a-b' Stefan
-- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/
------------------------------------------------------------------------------ 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
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
Hi Gijs, I have got a lot of trouble using MonetDB with the standard Python code. MonetDB eats endsless amounts of memory, where I suspect it has to do with keeping the connection alive. Eventually getting a Out-Of-Memory. Since I guess Djonet is also keeping the database connect alive, do you nee any summing up of MonetDB's memory? Stefan
On 06/06/2012 09:31 PM, Stefan de Konink wrote:
Hi Gijs,
I have got a lot of trouble using MonetDB with the standard Python code. MonetDB eats endsless amounts of memory, where I suspect it has to do with keeping the connection alive. Eventually getting a Out-Of-Memory.
I'm seeing similar problems with the Python API. I was not able to complete the full Django test suite on Djonet and MonetDB yet, since it will crash mserver5 or let CPU usage go to 100% at random points in the test suite. Maybe there is something weird happening in the Python API that will result in unstable behaviour of MonetDB. I'm trying to isolate the problem, but it takes time.
Since I guess Djonet is also keeping the database connect alive, do you nee any summing up of MonetDB's memory?
Sorry, I don't understand your question. greetings, - Gijs
On Fri, 8 Jun 2012, Gijs Molenaar wrote:
Since I guess Djonet is also keeping the database connect alive, do you nee any summing up of MonetDB's memory?
Sorry, I don't understand your question.
I guess with your personal description, you got my question. In proper English: I guess Djonet is using keep alive connections as well, do you see any summing up of MonetDB's memory. - I read you do. Stefan
participants (5)
-
Gijs Molenaar -
Gijs Molenaar -
Molenaar, Gijs
-
Stefan de Konink -
Stefan Manegold