monetdb

Transaction with MonetDB and JDBC driver

I'm trying to perform transaction-like behavior with MonetDB and its JDBC driver. I tried first to set autocommit to false for the connection, I then get the following error on commit : java.lang.IndexOutOfBoundsException at java.nio.StringCharBuffer.subSequence(StringCharBuffer.java:92) at nl.cwi.monetdb.mcl.parser.StartOfHead...

Concat a list of elements and scores without using a recursive function in XQuery with Tijah extensions

For a university search engine project, I am using MonetDB with Tijah extensions. I've got a list of nodes, returned from a search string: let $qid := tijah:queryall-id($nexi) let $nodes := tijah:nodes($qid) $nodes now contains a list of elements, e.g.: <book>Design Patterns</book> <book>AntiPatterns</book> I can calculate and ret...

any .Net provider for MonetDB

are there any or any alternatives available ? ...

To store images in SQL or not?

Generally, I had thought it was always better to store images in the filesystem and link to it via the database entry. However, I am trying to optimize my db design and am having a few questions. My images are all really small thumbmails in black and white (not greyscale, but true B&W) and are 70x70 in size. If we take the images (whi...