On 04-01-2010 22:23:20 +0100, Guillaume Yziquel wrote:
Merovingian(1) and monetdb(1) enable increased security features of mserver5. If you start mserver5 manually, you do not enable this.
In short, you mix the usage of merovingian(1) and mserver5, that's asking for problems.
I'm not mixing the use of merovingian and mserver5, but mixing the use of merovingian and monetdb_sql(). Or maybe I misunderstood you.
That is the same. "Embedded" in MonetDB terminology means nothing more than to start a full server in single threaded mode, hence without locks. You connect to it using a mapi connection, which is the same as e.g. mclient does. "Embedded" doesn't necessarily mean that you just access the data using a library. Calling monetdb_sql() is roughly the same as running `mserver5 --dbinit="include sql;"` on the console.
If you want to create databases with merovingian(1), you best make a connection to merovingian(1)'s control channel to tell it to create a database.
OK. So is it possible to create a database via a call to monetdb_sql(), and to access it via a command line tool such as mclient? If yes, how?
I'm not sure, but in principle as long as the thing remains running and you don't have any connections to it, you can just connect to it using e.g. mclient.