April 2004 - developers-list

[Monetdb-developers] Python + SQL
by Arjan Scherpenisse 20 Apr '04

20 Apr '04

Hello, can someone point me to a simple way of using the SQL frontend from within Python? The default interface (Mapi.py) does only allow the MIL language, as far as I can see. In the past I did it by using the ODBC module, but that was very tiresome. Is there a better way? cheers, Arjan

1 0

[Monetdb-developers] timestamp
by Arjan Scherpenisse 07 Apr '04

07 Apr '04

Hi list, I am importing some tab-separated dump data in which a field is a timestamp, formatted ala "2003-11-26 10:36:53". After importing (through make_persistent/load_data), the two timestamp BATs show up as: [ "profile_track_history_date", "oid", nil, 4516232, 0, "clean", "disk", "pers", 0, 1 ] [ "profile_track_history_serverdate", "oid", nil, 4516232, 0, "clean", "disk", "pers", 0, 1 ] (having a 'nil' tail-type). I guess this is a minor bug; because the BATs are filled with timestamps properly. regards, Arjan

3 5

[Monetdb-developers] Security & usability
by Fabian 04 Apr '04

04 Apr '04

After the checkin by Martin (about giving -u and -P default values on MapiClient), I had to laugh loudly for a minute (or two) after which I had to frown, thinking about the security aspect of this change. Not that it changes much, but being a little minded towards a better situation is not a bad thing IMHO. (Also for the reputation of monet by itself for the outside world) Because I regularly get tired of typing long command line arguments as well, I propose the following solution, which might fit all kinds of tastes. What if we would store some preferences we have in a file ~/.monetdb or something which can be shared by various applications, like MapiClient, JdbcClient, Mserver itself, and maybe any more... The file would be simply a properties file containing something like username=monetdb password=monetdb language=sql startscript=~/monetdb/start_sql which would instruct MapiClient to use sql language with username + pass monetdb and tell Mserver when it starts to load the script ~/monetdb/start_sql so I for instance would not have to type 'module(sql_server);' anymore. Of course command line options override these defaults in this .monetdb file. It is up to the user to chmod it to 600. How about this idea?

3 3

[Monetdb-developers] PHP interface
by Marcin Zukowski 03 Apr '04

03 Apr '04

Hello Monet-hackers, Recently I implemented a PHP Monet interface. Documentation is here: file://localhost/ufs/marcin/utils/phpdoc/html/ref.monetdb.html (accessible from CWI). If anyone of you is interested and would like to play with it, I would be grateful for any comments. Regards, marcin -- : Marcin Zukowski < marcin(a)cwi.nl || eru(a)mimuw.edu.pl > : All true wisdom is found in signatures

1 0