[MonetDB-users] Developing in MAL!
Hi, I'm new to MonetDB, but are looking to develop my own interface towards the database, not using SQL, but just sticking with MAL or if possible C and just want to know what my options are? Is it, for example, possible to load you own MAL-files into the client, just for a test run or do you have to type in the commands line by line? And on the server side, how to you setup your own modules and libraries? Regards Erik Holstad
On Thu, Mar 06, 2008 at 09:24:23AM -0800, Erik Holstad wrote:
Hi, I'm new to MonetDB, but are looking to develop my own interface towards the database, not using SQL, but just sticking with MAL or if possible C and just want to know what my options are? Is it, for example, possible to load you own MAL-files into the client, just for a test run or do you have to type in the commands line by line?
The mclient allows file's, redirection etc. See http://monetdb.cwi.nl/projects/monetdb/MonetDB/Documentation/MAPI-Client.htm... For a description of the client.
And on the server side, how to you setup your own modules and libraries?
Try a checkout of the template module from sourceforge. It is an example of the module/library setup outside the MonetDB5 source tree.
Niels
Regards Erik Holstad
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi! And thanks for the quick answers!! I tried to install the template that was recommended, at first I had a little bit problem with the buildtools, but it worked out, but I can see any configure file in the template folder, so is there something that I'm missing? Regards Erik Holstad
Hi Erik,
as with all MonetDB sources from CVS, also with "template", there is a "configure.ag" file in the top-level directory, cf., http://monetdb.cvs.sourceforge.net/*checkout*/monetdb/template/configure.ag, that will be processed by the "buildtools" during `./bootstrap` to produce the final "configure" script.
Since we do not release it, I assume, you got the template module from CVS, right?
Since you noticed (and solved?) problems with buildtools, I suppose you did run bootstrap, right? Hence, if this was successful, there should be a confiugre afterwards. Otherwise, bootstrap failed and should give some error message indicating what went wrong.
Stefan
On Thu, Mar 06, 2008 at 07:01:37PM -0800, Erik Holstad wrote:
Hi! And thanks for the quick answers!! I tried to install the template that was recommended, at first I had a little bit problem with the buildtools, but it worked out, but I can see any configure file in the template folder, so is there something that I'm missing? Regards Erik Holstad
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi! Yes I did get the template from the CVS and I did run the ./bootstrap for both buildtools and template and this is the message that I got:
automake 1.10 is 1.7 or newer. Good. autoconf 2.61 is 2.57 or newer. Good. libtool 1.5.24 is 1.4 or newer. Good. Python 2.5.1 is 2.0.0 or newer. Good. /home/erik/MonetDB/template/conf /home/erik/MonetDB/template/src /home/erik/MonetDB/template/src/monetdb4 /home/erik/MonetDB/template/src/monetdb5 Remember to add `AC_PROG_LIBTOOL' to `configure.in'. Putting files in AC_CONFIG_AUX_DIR, `conf'. patching file aclocal.m4 Hunk #1 succeeded at 423 (offset -5963 lines). conf/Makefile.am:15: bad characters in variable name `C_monetdb-template-config' conf/Makefile.am:16: bad characters in variable name `C_script_monetdb-template-config'
and I looked at rows 15 and 16 but couldn't see what was wrong.
Regards Erik
On Thu, Mar 6, 2008 at 10:19 PM, Stefan Manegold Stefan.Manegold@cwi.nl wrote:
Hi Erik,
as with all MonetDB sources from CVS, also with "template", there is a "configure.ag" file in the top-level directory, cf.,
http://monetdb.cvs.sourceforge.net/*checkout*/monetdb/template/configure.ag , that will be processed by the "buildtools" during `./bootstrap` to produce the final "configure" script.
Since we do not release it, I assume, you got the template module from CVS, right?
Since you noticed (and solved?) problems with buildtools, I suppose you did run bootstrap, right? Hence, if this was successful, there should be a confiugre afterwards. Otherwise, bootstrap failed and should give some error message indicating what went wrong.
Stefan
On Thu, Mar 06, 2008 at 07:01:37PM -0800, Erik Holstad wrote:
Hi! And thanks for the quick answers!! I tried to install the template that was recommended, at first I had a little bit problem with the buildtools, but it worked out, but I can see
any
configure file in the template folder, so is there something that I'm missing? Regards Erik Holstad
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Fri, Mar 07, 2008 at 09:13:35AM -0800, Erik Holstad wrote:
Hi! Yes I did get the template from the CVS and I did run the ./bootstrap for both buildtools and template and this is the message that I got:
automake 1.10 is 1.7 or newer. Good. autoconf 2.61 is 2.57 or newer. Good. libtool 1.5.24 is 1.4 or newer. Good. Python 2.5.1 is 2.0.0 or newer. Good. /home/erik/MonetDB/template/conf /home/erik/MonetDB/template/src /home/erik/MonetDB/template/src/monetdb4 /home/erik/MonetDB/template/src/monetdb5 Remember to add `AC_PROG_LIBTOOL' to `configure.in'. Putting files in AC_CONFIG_AUX_DIR, `conf'. patching file aclocal.m4 Hunk #1 succeeded at 423 (offset -5963 lines). conf/Makefile.am:15: bad characters in variable name `C_monetdb-template-config' conf/Makefile.am:16: bad characters in variable name `C_script_monetdb-template-config'
and I looked at rows 15 and 16 but couldn't see what was wrong.
obviously, the '-' in the variable names are the problem; they should be '_' (and are in my case) --- I have no idea (yet?), why they aren't in your case --- what system are you running on?
Stefan
Regards Erik
Running on Fedora 8. Tried to change the names in the makefile but they are overwritten, when I run bootstrap again: This is what the makefile look llike:
## This file is generated by autogen.py, do not edit ## Process this file with automake to produce Makefile.in ## autogen includes dependencies so automake doesn't need to generated them
AUTOMAKE_OPTIONS = no-dependencies 1.4 foreign
if NEED_MX NEED_MX = 1 endif
uninstall-local-: install-exec-local-: if NOT_WIN32 C_monetdb-template-config = monetdb-template-config C_script_monetdb-template-config = script_monetdb-template-config endif script_monetdb-template-config: monetdb-template-config chmod a+x $< install-exec-local-monetdb-template-config: monetdb-template-config -mkdir -p $(DESTDIR)$(bindir) -$(RM) $(DESTDIR)$(bindir)/monetdb-template-config $(INSTALL) $< $(DESTDIR)$(bindir)/monetdb-template-config
uninstall-local-monetdb-template-config: $(RM) $(DESTDIR)$(bindir)/monetdb-template-config
if NEED_MX endif monetdb-template-config: monetdb-template-config.in INCLUDES = -I$(srcdir) BUILT_SOURCES = $(C_monetdb-template-config) MOSTLYCLEANFILES = $(C_monetdb-template-config) EXTRA_DIST = Makefile.msc config.guess config.sub install-sh missing ltmain.sh config.h.in $(BUILT_SOURCES) bin_SCRIPTS = $(C_script_monetdb-template-config) install-exec-local-SCRIPTS: all-local-SCRIPTS: $(bin_SCRIPTS) uninstall-local: uninstall-local-$(C_monetdb-template-config) install-exec-local: install-exec-local-$(C_monetdb-template-config)
include $(top_srcdir)/*.mk include $(top_builddir)/*.mk
Regards Erik
On Fri, Mar 7, 2008 at 9:48 AM, Stefan Manegold Stefan.Manegold@cwi.nl wrote:
On Fri, Mar 07, 2008 at 09:13:35AM -0800, Erik Holstad wrote:
Hi! Yes I did get the template from the CVS and I did run the ./bootstrap
for
both buildtools and template and this is the message that I got:
automake 1.10 is 1.7 or newer. Good. autoconf 2.61 is 2.57 or newer. Good. libtool 1.5.24 is 1.4 or newer. Good. Python 2.5.1 is 2.0.0 or newer. Good. /home/erik/MonetDB/template/conf /home/erik/MonetDB/template/src /home/erik/MonetDB/template/src/monetdb4 /home/erik/MonetDB/template/src/monetdb5 Remember to add `AC_PROG_LIBTOOL' to `configure.in'. Putting files in AC_CONFIG_AUX_DIR, `conf'. patching file aclocal.m4 Hunk #1 succeeded at 423 (offset -5963 lines). conf/Makefile.am:15: bad characters in variable name `C_monetdb-template-config' conf/Makefile.am:16: bad characters in variable name `C_script_monetdb-template-config'
and I looked at rows 15 and 16 but couldn't see what was wrong.
obviously, the '-' in the variable names are the problem; they should be '_' (and are in my case) --- I have no idea (yet?), why they aren't in your case --- what system are you running on?
Stefan
Regards Erik
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Fri, Mar 07, 2008 at 10:21:04AM -0800, Erik Holstad wrote:
Running on Fedora 8. Tried to change the names in the makefile but they are overwritten, when I run bootstrap again:
Indeed, Makefile.am and Makefile.in are generated from the original source in Makefile.ag during bootstrap.
Did you successfuly manage to build and install (i.e., bootstrap; configure; make install) buildtools, MonetDB, clients & MonetDB5 from CVS before hitting the template problems?
Stefan
This is what the makefile look llike:
## This file is generated by autogen.py, do not edit ## Process this file with automake to produce Makefile.in ## autogen includes dependencies so automake doesn't need to generated them
AUTOMAKE_OPTIONS = no-dependencies 1.4 foreign
if NEED_MX NEED_MX = 1 endif
uninstall-local-: install-exec-local-: if NOT_WIN32 C_monetdb-template-config = monetdb-template-config C_script_monetdb-template-config = script_monetdb-template-config endif script_monetdb-template-config: monetdb-template-config chmod a+x $< install-exec-local-monetdb-template-config: monetdb-template-config -mkdir -p $(DESTDIR)$(bindir) -$(RM) $(DESTDIR)$(bindir)/monetdb-template-config $(INSTALL) $< $(DESTDIR)$(bindir)/monetdb-template-config
uninstall-local-monetdb-template-config: $(RM) $(DESTDIR)$(bindir)/monetdb-template-config
if NEED_MX endif monetdb-template-config: monetdb-template-config.in INCLUDES = -I$(srcdir) BUILT_SOURCES = $(C_monetdb-template-config) MOSTLYCLEANFILES = $(C_monetdb-template-config) EXTRA_DIST = Makefile.msc config.guess config.sub install-sh missing ltmain.sh config.h.in $(BUILT_SOURCES) bin_SCRIPTS = $(C_script_monetdb-template-config) install-exec-local-SCRIPTS: all-local-SCRIPTS: $(bin_SCRIPTS) uninstall-local: uninstall-local-$(C_monetdb-template-config) install-exec-local: install-exec-local-$(C_monetdb-template-config)
include $(top_srcdir)/*.mk include $(top_builddir)/*.mk
Regards Erik
Hi! I installed the MonetDB from the superBall and then installed the buildtools afterwards with the boot/conf/make.. commands
On Fri, Mar 7, 2008 at 10:29 AM, Stefan Manegold Stefan.Manegold@cwi.nl wrote:
On Fri, Mar 07, 2008 at 10:21:04AM -0800, Erik Holstad wrote:
Running on Fedora 8. Tried to change the names in the makefile but they are overwritten, when
I
run bootstrap again:
Indeed, Makefile.am and Makefile.in are generated from the original source in Makefile.ag during bootstrap.
Did you successfuly manage to build and install (i.e., bootstrap; configure; make install) buildtools, MonetDB, clients & MonetDB5 from CVS before hitting the template problems?
Stefan
This is what the makefile look llike:
## This file is generated by autogen.py, do not edit ## Process this file with automake to produce Makefile.in ## autogen includes dependencies so automake doesn't need to generated
them
AUTOMAKE_OPTIONS = no-dependencies 1.4 foreign
if NEED_MX NEED_MX = 1 endif
uninstall-local-: install-exec-local-: if NOT_WIN32 C_monetdb-template-config = monetdb-template-config C_script_monetdb-template-config = script_monetdb-template-config endif script_monetdb-template-config: monetdb-template-config chmod a+x $< install-exec-local-monetdb-template-config: monetdb-template-config -mkdir -p $(DESTDIR)$(bindir) -$(RM) $(DESTDIR)$(bindir)/monetdb-template-config $(INSTALL) $< $(DESTDIR)$(bindir)/monetdb-template-config
uninstall-local-monetdb-template-config: $(RM) $(DESTDIR)$(bindir)/monetdb-template-config
if NEED_MX endif monetdb-template-config: monetdb-template-config.in INCLUDES = -I$(srcdir) BUILT_SOURCES = $(C_monetdb-template-config) MOSTLYCLEANFILES = $(C_monetdb-template-config) EXTRA_DIST = Makefile.msc config.guess config.sub install-sh missing ltmain.sh config.h.in $(BUILT_SOURCES) bin_SCRIPTS = $(C_script_monetdb-template-config) install-exec-local-SCRIPTS: all-local-SCRIPTS: $(bin_SCRIPTS) uninstall-local: uninstall-local-$(C_monetdb-template-config) install-exec-local: install-exec-local-$(C_monetdb-template-config)
include $(top_srcdir)/*.mk include $(top_builddir)/*.mk
Regards Erik
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Fri, Mar 07, 2008 at 10:42:06AM -0800, Erik Holstad wrote:
Hi! I installed the MonetDB from the superBall and then installed the buildtools afterwards with the boot/conf/make.. commands
I see --- well, I must admit, that this combination has prbably never been tested.
As an alternative, you can try to build from the nightly-built source tarball "MonetDB-template-0.2.1.tar.gz" from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./0_latest... This does not require buildtools and bootstrap, but is ready for the "simple" configure; make; make install ...
Stefan
Thank you! That worked much better, now I just have to look what to do :) Don't know if you know, but the README files 4 and 5 are missing in that one Regards Erik
On Fri, Mar 7, 2008 at 10:55 AM, Stefan Manegold Stefan.Manegold@cwi.nl wrote:
On Fri, Mar 07, 2008 at 10:42:06AM -0800, Erik Holstad wrote:
Hi! I installed the MonetDB from the superBall and then installed the
buildtools
afterwards with the boot/conf/make.. commands
I see --- well, I must admit, that this combination has prbably never been tested.
As an alternative, you can try to build from the nightly-built source tarball "MonetDB-template-0.2.1.tar.gz" from
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./0_latest... This does not require buildtools and bootstrap, but is ready for the "simple" configure; make; make install ...
Stefan
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Fri, Mar 07, 2008 at 11:05:54AM -0800, Erik Holstad wrote:
Thank you! That worked much better, now I just have to look what to do :) Don't know if you know, but the README files 4 and 5 are missing in that one Regards Erik
Well, you can use the READMEs from CVS, of course ;-)
In fact, we should get the CVS version working eventually, but for now, using the tarball was the simplest and quickest way to get you started ;-)
Stefan
On 07-03-2008 20:40:51 +0100, Stefan Manegold wrote:
On Fri, Mar 07, 2008 at 11:05:54AM -0800, Erik Holstad wrote:
Thank you! That worked much better, now I just have to look what to do :) Don't know if you know, but the README files 4 and 5 are missing in that one Regards Erik
Well, you can use the READMEs from CVS, of course ;-)
In fact, we should get the CVS version working eventually, but for now, using the tarball was the simplest and quickest way to get you started ;-)
monetdb-install.sh --cvs isn't working?
On Fri, Mar 07, 2008 at 08:43:38PM +0100, Fabian Groffen wrote:
On 07-03-2008 20:40:51 +0100, Stefan Manegold wrote:
On Fri, Mar 07, 2008 at 11:05:54AM -0800, Erik Holstad wrote:
Thank you! That worked much better, now I just have to look what to do :) Don't know if you know, but the README files 4 and 5 are missing in that one Regards Erik
Well, you can use the READMEs from CVS, of course ;-)
In fact, we should get the CVS version working eventually, but for now, using the tarball was the simplest and quickest way to get you started ;-)
monetdb-install.sh --cvs isn't working?
is it supposed to work for template?
Stefan
Hi! Yes, I know, just wanted to inform you about it. And thanks for the help! Regards Erik
On Fri, Mar 7, 2008 at 11:40 AM, Stefan Manegold Stefan.Manegold@cwi.nl wrote:
On Fri, Mar 07, 2008 at 11:05:54AM -0800, Erik Holstad wrote:
Thank you! That worked much better, now I just have to look what to do :) Don't know if you know, but the README files 4 and 5 are missing in that
one
Regards Erik
Well, you can use the READMEs from CVS, of course ;-)
In fact, we should get the CVS version working eventually, but for now, using the tarball was the simplest and quickest way to get you started ;-)
Stefan
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On 07-03-2008 20:45:27 +0100, Stefan Manegold wrote:
In fact, we should get the CVS version working eventually, but for now, using the tarball was the simplest and quickest way to get you started ;-)
monetdb-install.sh --cvs isn't working?
is it supposed to work for template?
We could make it so, like we do for geom, I guess...
On Fri, Mar 07, 2008 at 09:03:09PM +0100, Fabian Groffen wrote:
On 07-03-2008 20:45:27 +0100, Stefan Manegold wrote:
In fact, we should get the CVS version working eventually, but for now, using the tarball was the simplest and quickest way to get you started ;-)
monetdb-install.sh --cvs isn't working?
is it supposed to work for template?
We could make it so, like we do for geom, I guess...
Good, might eventually be a handy idea for new developers ...
Stefan
Hi! I'm wondering if there is a table over the functions at hand, kind of like the Appendix C Instruction Help but where you can actually see what input and outputs are to expect and delivered to the functions? Regards Erik
Erik Holstad wrote:
Hi! I'm wondering if there is a table over the functions at hand, kind of like the
Appendix C Instruction Helpbut where you can actually see what input and outputs are to expect and delivered to the functions? Regards Erik
http://monetdb.cwi.nl/projects/monetdb/MonetDB/Documentation/The-MAL-Modules...
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On 07-03-2008 21:28:01 +0100, Stefan Manegold wrote:
monetdb-install.sh --cvs isn't working?
is it supposed to work for template?
We could make it so, like we do for geom, I guess...
Good, might eventually be a handy idea for new developers ...
I implemented this now, using --enable-template
I tested on --nightly=stable and it works as far as I can check. You can find the script with this support at: http://www.cwi.nl/~fabian/troep/monetdb-install.sh
Hi! I'm wondering if there is a way to look at the mal code that is produced by, for example, some sql code? Regards Erik
Hi! I'm trying to build a database from scratch in Mal and I'm wondering if there is a good way to treat several different BATs as one table? Regards Erik
Erik Holstad wrote:
Hi! I'm trying to build a database from scratch in Mal and I'm wondering if there is a good way to treat several different BATs as one table?
there is none. It is a binary model. Any combination/grouping of BATs should be done by yourself supported by a catalog. See the SQL compiled code how it is done there.
Regards Erik
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi! If one wants to do a lot if inserts into a Bat and keep it sorted at all times, is there a good way of doing that in Mal or do you have to use the sort or order function after every insert? Regards Erik
participants (5)
-
Erik Holstad -
Fabian Groffen -
Martin Kersten -
Niels Nes -
Stefan Manegold