- developers-list - monetdb.org

Re: [Monetdb-developers] autogen.py
by RichardGUO Fei 26 May '09

26 May '09

The problem is resolved. I just edited the Makefile.am directly and then use automake. From: gladiatorcn(a)hotmail.com To: monetdb-developers(a)lists.sourceforge.net Subject: autogen.py Date: Mon, 25 May 2009 17:52:00 +0000 Hi, I am new to MonetDB development. I add some source files to MonetDB/MonetDB/src/gdk, which rely on the external libraries. When I try to modify Makefile.am in order to add the relevant link information. It says that it was generated by autogen.py. To be honest, I do not know autogen.py and I could not find any useful information from Google. Could you guys give a little hint please? Thank you very much! Fei 把MSN装进手机，更多聊天乐趣等你挖掘！立刻下载！ _________________________________________________________________ 打工，挣钱，买房子，快来MClub一起”金屋藏娇”！ http://club.msn.cn/?from=10

2 2

[Monetdb-developers] autogen.py
by RichardGUO Fei 25 May '09

25 May '09

Hi, I am new to MonetDB development. I add some source files to MonetDB/MonetDB/src/gdk, which rely on the external libraries. When I try to modify Makefile.am in order to add the relevant link information. It says that it was generated by autogen.py. To be honest, I do not know autogen.py and I could not find any useful information from Google. Could you guys give a little hint please? Thank you very much! Fei _________________________________________________________________ 打工，挣钱，买房子，快来MClub一起”金屋藏娇”！ http://club.msn.cn/?from=10

1 0

Re: [Monetdb-developers] Installing MonetDB5 (Stable) failed on Int.32.32.d.1-Windows5.1 Mic.32.32.d.1-Windows5.1 Int.64.32.d.1-Windows5.2 Mic.64.32.d.1-Windows5.2 Mic.64.64.d.1-Windows5.2
by Stefan Manegold 25 May '09

25 May '09

Dear all, removing the *_export macro definitions from .c source files seems to have broken M5 compilation on Windows --- I'm busy fixing it by re-adding these definitions in .h header files... Stefan On Mon, May 25, 2009 at 05:06:19AM +0200, Testweb Compilation wrote: > copy "lib_streams.lib" "g:\monet\monet.Int.32.32.d.1.28441\MonetDB5\.Int.32.32.d.1-Windows5.1\lib\MonetDB5\lib_streams.lib" > The system cannot find the file specified. > NMAKE : fatal error U1077: 'copy' : return code '0x1' > > http://www.ins.cwi.nl/~monet/permastore/2009-05-25/Stable/install-MonetDB5-… > > CVS committers: manegold(a)cwi.nl mk(a)cwi.nl niels(a)cwi.nl > > module maintainers: mk(a)cwi.nl niels(a)cwi.nl > > An identical error message was detected on the following systems: > Int.32.32.d.1-Windows5.1 Mic.32.32.d.1-Windows5.1 Int.64.32.d.1-Windows5.2 Mic.64.32.d.1-Windows5.2 Mic.64.64.d.1-Windows5.2 > > -- > At this time you cannot configure Testing mail, sorry > You are receiving this mail because: > - you checked in some code on MonetDB5 (Stable) > - you are a fixed recipient > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 4

[Monetdb-developers] GDK::BAT_select_ problem
by RichardGUO Fei 24 May '09

24 May '09

Hi, I am doing some developments in GDK. More concretely, I want to modify the behavior of a SQL select statement. I print some messages in BAT_select_ as I think that most of SQL selects would be compiled into plusieur BATselects. Is that right? I used mserver --dbinit 'include sql;' to start, and saw some messages coming out (BAT_select_ is also used for authentication). However, after I logged in by using mclient -l sql, no matter what kind of SELECT I performed, there was just no message. Was BAT_select_ called after all in this case? Thank you very much for your responses. Regards, Richard _________________________________________________________________ MSN 表情魔法书，改变你的对话时代！ http://im.live.cn/emoticons/

2 2

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Tests All, May2009, 1.61, 1.61.2.1
by Sjoerd Mullender 24 May '09

24 May '09

On 2009-05-24 11:43, Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/test/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15423/src/test/Tests I took care of the (non-)propagation of this and the other three All files. > Modified Files: > Tag: May2009 > All > Log Message: > disabled tests (should not be propagated!) > > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Tests/All,v > retrieving revision 1.61 > retrieving revision 1.61.2.1 > diff -u -d -r1.61 -r1.61.2.1 > --- All 9 Apr 2009 18:48:49 -0000 1.61 > +++ All 24 May 2009 09:43:11 -0000 1.61.2.1 > @@ -87,7 +87,7 @@ > setoptimizer > load_dec_as_int > string > -NOT_WIN32?crashme > +#NOT_WIN32?crashme > 50ways > load_with_offset > copy_into > > > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://www.creativitycat.com > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.303, 1.304
by Sjoerd Mullender 23 May '09

23 May '09

Is this a bug fix? On 2009-05-23 11:56, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv19871 > > Modified Files: > mal_interpreter.mx > Log Message: > We better protect global variables in the interpreter. > > > U mal_interpreter.mx > Index: mal_interpreter.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_interpreter.mx,v > retrieving revision 1.303 > retrieving revision 1.304 > diff -u -d -r1.303 -r1.304 > --- mal_interpreter.mx 16 May 2009 18:26:23 -0000 1.303 > +++ mal_interpreter.mx 23 May 2009 09:55:57 -0000 1.304 > @@ -734,11 +734,12 @@ > #endif > @:performanceVariables@ > > -#ifdef DEBUG_FLOW2 > + pci = getInstrPtr(flow->mb, stkpc); > +#ifdef DEBUG_FLOW > stream_printf(cntxt->fdout,"#execute thread %d \n", tid); > + printInstruction(GDKstdout, flow->mb, 0, pci, LIST_MAL_ALL); > #endif > THRset_errbuf(THRget(THRgettid()), cntxt->errbuf); /* where to leave errors */ > - pci = getInstrPtr(flow->mb, stkpc); > if (stk->cmd || mb->trap) { > lng tm = 0; > if( oldtimer) > @@ -857,9 +858,13 @@ > { > int i; > > - assert(worker == NULL); > + mal_set_lock(mal_contextLock, "DFLOWcreate"); > + if ( work != NULL){ > + mal_unset_lock(mal_contextLock, "DFLOWcreate"); > + return; > + } > > - work = q_create(256); > + work = q_create(256); /* seems enough for the time being */ > > nway = GDKnr_threads; > worker = (FlowTask *) GDKzalloc(sizeof(FlowTask)*nway); > @@ -868,6 +873,7 @@ > /* create the thread and let it wait */ > MT_create_thread(&worker[i].tid, runDFLOWworker, worker+i); > } > + mal_unset_lock(mal_contextLock, "DFLOWcreate"); > } > > static void > > > ------------------------------------------------------------------------------ > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian > Group, R/GA, & Big Spaceship. http://www.creativitycat.com > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

2 1

[Monetdb-developers] ODBC windows build script
by Stefan de Konink 23 May '09

23 May '09

Is there any 'asset' available that allows to build the Windows ODBC driver from within Linux or a howto to build it in Windows? Especially related to the recent authentication changes. Stefan

3 3

[Monetdb-developers] DBSlayer for MonetDB
by Stefan de Konink 22 May '09

22 May '09

Hi, I have set up a development server for OpenStreetMap that allows 'Joe Regular' to perform /any/ SQL request on a dataset limited to the borders of The Netherlands, Belgium and Luxembourgh. That means around 700MB of data. Because OpenStreetMap mainly targets webdevelopment, making it easy-to-use and efficient-to-parse become key issues. Because my favorite webserver [1] implemented DBSlayer [2] technology for MySQL; I could plugin an architecture layer to support different databases. MonetDB is in beta phase, and PostgreSQL is coded. The output is available in native PHP, Python and Ruby arrays; JSON, and XML-RPC is coded but not yet in production. The attached script shows a trivial example how to query a database farm over the web. Hanging more servers under the webserver, automatically increases performance and redundancy. I configured the webserver in such way that a rewrite takes place if no LIMIT was specified. Because the requests are URIs, every request is logged, what makes it possible to analyse the performance and benchmark the test set against new releases. With this platform I am able to plugin my multicolumn 'optimizer' idea, so we all benefit. To the outside Mapi is available, for accessing it by our mclient or ODBC client. If our 'native' Ruby/Python MAPI implementations are ready for testing, I can promote them on the site, or provide a sandbox. The site itself is still boring; http://xapi.openstreet.nl:8000/ Stefan [1] http://www.cherokee-project.com/ [2] http://code.nytimes.com/projects/dbslayer #!/usr/bin/env python import urllib sql="SELECT lat, long FROM nodes_legacy, node_tags WHERE id = node AND k = 'amenity' and v = 'atm';" query = urllib.quote(sql) print 'Original:', sql print 'Encoded:', query url = 'http://xapi.openstreet.nl:8000/python/%s'%(query) response = urllib.urlopen(url) print 'RESPONSE:', response print 'URL :', response.geturl() headers = response.info() print 'DATE :', headers['date'] print 'HEADERS :' print '---------' print headers data = response.read() print 'LENGTH :', len(data) print 'DATA :' print '---------' obj = eval(data) print obj

1 0

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/ruby activerecord-monetdb-adapter-0.1.gem, , NONE, 1.1 activerecord-monetdb-adapter-0.1.gemspec, , NONE, 1.1 Changelog, , 1.2, 1.3 README, , 1.3, 1.4 TODO, , 1.2, 1.3 ruby-monetdb-sql-0.1.gem, , 1.2, 1.3
by Stefan Manegold 20 May '09

20 May '09

On Wed, May 20, 2009 at 11:17:14AM +0000, Gabriele Modena wrote: > Update of /cvsroot/monetdb/clients/src/ruby > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv30426 > > Modified Files: > Changelog README TODO ruby-monetdb-sql-0.1.gem > Added Files: > activerecord-monetdb-adapter-0.1.gem > activerecord-monetdb-adapter-0.1.gemspec > Log Message: > Fixed bugs that prevented the correct working of activerecords' migration; The activerecord connector now supports insertion, update and alter table operations; Type casting is working in activerecord; Added a rubygem and rakefile for activerecord-monetdb-adapter; Added a new usage example for activerecord to the README file; Added an example directory to the cvs tree; The driver now correctly works with merovingian. ^^^^^^^^^^ Shouldn't this checkin then have gone to the May2009 release branch? See `man cvs` and/or pages 8 - 16 of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf for information about how to use CVS branches in genral and/or with MonetDB in particular. Don't hesitate to ask if you have questions. Please check with Sjoerd, whether a(n execptional!) back-port is desired; if so, see the above references (or ask) how to do this using CVS commands, only. If required, I can help. Stefan > > U Changelog > Index: Changelog > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/ruby/Changelog,v > retrieving revision 1.2 > retrieving revision 1.3 > diff -u -d -r1.2 -r1.3 > --- Changelog 9 May 2009 14:49:30 -0000 1.2 > +++ Changelog 20 May 2009 11:17:12 -0000 1.3 > @@ -1,3 +1,13 @@ > +* Mon 18 May 2009 15:22:31 CEST > +Fixed bugs that prevented the correct working of activerecords' migration; > +The activerecord connector now supports insertion, update and alter table operations; > +Type casting is working in activerecord; > +Added a rubygem and rakefile for activerecord-monetdb-adapter; > +Added a new usage example for activerecord to the README file; > +Added an example directory to the cvs tree; > +The driver now correctly works with merovingian. > + > + > * Sat 9 May 2009 15:58:36 CEST > Fixed bugs with the query processing in the standalone driver; > Added INSERT and UPDATE methods in the activerecord connector. > > --- NEW FILE: activerecord-monetdb-adapter-0.1.gemspec --- > Gem::Specification.new do |s| > s.required_ruby_version = '>= 1.8.0' > s.name = %q{activerecord-monetdb-adapter} > s.version = "0.1" > s.date = %q{2009-05-18} > s.authors = ["G Modena"] > s.email = %q{gm(a)cwi.nl} > s.summary = %q{ActiveRecord Connector for MonetDB} > s.homepage = %q{http://monetdb.cwi.nl/} > s.description = %q{ActiveRecord Connector for MonetDB built on top of the pure Ruby database driver} > s.files = [ "adapter/active_record/connection_adapters/monetdb_adapter.rb" ] > s.has_rdoc = true > s.require_path = './lib' > s.add_dependency(%q<activerecord>, [">= 2.3.2"]) > s.add_dependency(%q<ruby-monetdb-sql>, [">= 0.1"]) > end > > U ruby-monetdb-sql-0.1.gem > Index: ruby-monetdb-sql-0.1.gem > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/ruby/ruby-monetdb-sql-0.1.gem,v > retrieving revision 1.2 > retrieving revision 1.3 > diff -u -d -r1.2 -r1.3 > Binary files /tmp/cvs9arhWX and /tmp/cvsfjZs3J differ > > --- NEW FILE: activerecord-monetdb-adapter-0.1.gem --- > (This appears to be a binary file; contents omitted.) > > U README > Index: README > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/ruby/README,v > retrieving revision 1.3 > retrieving revision 1.4 > diff -u -d -r1.3 -r1.4 > --- README 7 May 2009 15:06:41 -0000 1.3 > +++ README 20 May 2009 11:17:12 -0000 1.4 > @@ -2,7 +2,6 @@ > This directory contains the a ruby interface to monetdb5 > written in pure ruby. > > - > lib/MonetDB.rb > lib/MonetDBConnection.rb > lib/MonetDBStatements.rb > @@ -16,54 +15,8 @@ > > doc/: rubydoc in HTML format > > -== ActiveRecord adapter == > -Active Record connects business objects and database tables to create a persistable domain model where logic and data are presented in one wrapping. It‘s an implementation of the object-relational mapping (ORM) pattern. > - > -Required files: > -adapter/lib/active_record/monetdb_adapter.rb > - > -At the moment connection and SELECT queries are supported. > - > -Usage example follows: > - > - > -require 'active_record' > - > -ActiveRecord::Base.establish_connection( > - :adapter => "monetdb", > - :host => "localhost", > - :database => "demo" > -) > - > -# map the tables schema to a class > -class Tables < ActiveRecord::Base > -end > - > -# return the first result of the query SELECT * from tables > -puts Tables.find(:first) > - > - > - > - > -== Rubygem == > - > -The standalone ruby driver can be distributed as a ruby gem. > -A gem file is already available; however, it can be generated > -starting from the ruby-monetdb-sql-0.1.gemspec file: > - > -$ gem build ruby-monetdb-sql-0.1.gemspec > - > -To install the file run the command: > - > -$ gem install ruby-monetdb-sql-0.1.gem > - > -Documentation in ri and html format will be generated and installed as well > - > == Usage == > -To use the driver import the 'MonetDB' class and 'rubygems' (in case you installed it using gems). > - > - > -* Processing Statements that Return a Result Set > +To use the standalone driver import the 'MonetDB' class and 'rubygems' (in case you installed it using gems). > > A typical sequence of events is as follows: > Invoke query using the database handle to send the statement to the server and get back a result set object. > @@ -104,3 +57,85 @@ > db.close > > See lib/demo.rb and the MonetDBDatar class documentation for more examples. > + > + > + > +== ActiveRecord connector adapter == > +Active Record connects business objects and database tables to create a persistable domain model where logic and data are presented in one wrapping. It‘s an implementation of the object-relational mapping (ORM) pattern. > + > +Required files: > + > +adapter/lib/active_record/monetdb_adapter.rb > + > +Usage example follows: > +require 'active_record' > + > +ActiveRecord::Base.logger = Logger.new(STDERR) > +ActiveRecord::Base.colorize_logging = true > + > +ActiveRecord::Base.establish_connection( > + :adapter => "monetdb", > + :host => "localhost", > + :database => "demo" > +) > + > +# Create a new table > +class AddTests < ActiveRecord::Migration > + def self.up > + create_table :tests do |table| > + table.column :name, :string > + table.column :surname, :string > + end > + end > + > + def self.down > + drop_table :tests > + end > + > +end > + > +AddTests.up > + > +# Migration: add a column name with a default value > +class AddAge < ActiveRecord::Migration > + def self.up > + add_column :tests, :age, :smallint, :default => 18 > + end > + > + def self.down > + remove_column :tests, :age > + end > + > +end > + > +class Test < ActiveRecord::Base > +end > + > +# Insert an entry in the table > +Test.create(:name => 'X', :surname => 'Y') > + > +# add a column > +AddAge.up > + > +# return the first result of the query SELECT * from tables > +row = Test.find(:first) > +printf "SELECT * from tests LIMIT 1:\n" > +printf "Name: %s, Surname: %s, Age: %s\n", row.name, row.surname, row.age > + > +# Drop the table > +AddTests.down > + > +== Rubygem == > + > +The standalone ruby driver can be distributed as a ruby gem. > +A gem file is already available; however, it can be generated > +starting from the ruby-monetdb-sql-0.1.gemspec file: > + > +$ gem build ruby-monetdb-sql-0.1.gemspec > + > +To install the file run the command: > + > +$ gem install ruby-monetdb-sql-0.1.gem > + > +Documentation in ri and html format will be generated and installed as well > + > > U TODO > Index: TODO > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/ruby/TODO,v > retrieving revision 1.2 > retrieving revision 1.3 > diff -u -d -r1.2 -r1.3 > --- TODO 7 May 2009 15:06:41 -0000 1.2 > +++ TODO 20 May 2009 11:17:12 -0000 1.3 > @@ -1,5 +1,15 @@ > +* implement PROTOCOL 9 login changes > + > * improve activerecord driver > + > * profiling and performance tuning > + > * improve type conversion (do conversion "on demand" as in jdbc driver) > + > * improve tests > + > * code and documentation cleanup > + > +* fix syntax errors with ruby 1.9 > + > +* OSM on rails demo > > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables > unlimited royalty-free distribution of the report engine > for externally facing server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 2

[Monetdb-developers] OpenSSL header check
by Stefan de Konink 20 May '09

20 May '09

I was just compiling MonetDB head on this distro called `Debian' (poor me). In the middle of the compilation I had missing headers. Wouldn't it be feasible to check for them like we check for PCRE presence? Stefan

2 4